How to integrate IPBX example with MYSQL in mobicent

[Baskar]

Hi,

I have run the IPBX examples in my system i want to check the database connectivity to integrate with mobicent. Can any one assist me to configure mysql database with IPBX examples in Mobicent.

Can any one assist me how to move future. 

--
Thanks with Regards,

N.Baskar 

[Vladimir Ralev]

This should do it http://www.jboss.org/community/wiki/SetUpAMySQLDatasource

[teacurran]

I got ipbx to work fine on Mysql, here is what needs to change:

in resources/ipbx-ds.xml:
<connection-url>jdbc:hsqldb:MyDB</connection-url>
<driver-class>org.hsqldb.jdbcDriver</driver-class>
<user-name>sa</user-name>
<password></password>

change to:
<connection-url>jdbc:mysql://127.0.0.1/ipbx</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password></password>

Then, in every entity class, change:
@Id @GeneratedValue(strategy=GenerationType.SEQUENCE)

to:
@Id @GeneratedValue(strategy=GenerationType.AUTO)



Make sure you have the MySql connector in your server lib folder.
running once should create the database.





On Oct 6, 7:37 am, Vladimir Ralev <vladimir.ra...@gmail.com> wrote:
> This should do ithttp://www.jboss.org/community/wiki/SetUpAMySQLDatasource

[Baskar]

Hi,

Where can i get the source file for IPBX. I have only the war file for ipbx. In that there is no class file or Java file.

So Can you please send me the link for download the source file for IPBX. 

Please assist me to move future. 

[Vladimir Ralev]

I didn't know GenerationType.SEQUENCE would be an issue with MySQL. I
should probably change it for hsql as well. Thanks.

[Vladimir Ralev]

It is in SVN and uses maven build

svn co http://mobicents.googlecode.com/svn/trunk/applications/ipbx/

then

mvn clean install

[Baskar]

Hi,

I need a sample source code for register the extension and some source code to dialling  the sip to pstn gateway.

Can any assist me to work on the above process and send me some sample source code or sample link to move future.

I have downloaded the svn ipbx source code from this link svn link http://mobicents.googlecode.com/svn/trunk/applications/ipbx/ and run that source file but i get these error that 

HTTP Status 404 - /ipbx/home.seam

---

type Status report

message /ipbx/home.seam

description The requested resource (/ipbx/home.seam) is not available.

But when i run the ipbx war file i can able to dial and make a call through PSTN gateway.I cant able to run the source code.

can some one assist to make the source code run successfully.

[Vladimir Ralev]

There would be error messages while booting the server. First you
should build the source with mvn install
and your should take the war file from warbuild directory and deploy
the newly built war file.

[Vladimir Ralev]

I meant use:
ant

instead of:
mvn install

Sorry for the confusion

[Baskar]

Hi,

i have downloaded maven from this link http://maven.apache.org/download.html#Installation. 

I have downloaded this version apache-maven-2.0.10-bin.zip

But in the above mail you have told that to install ant where shall i find the download for the ant for mobicent IPBX.

Please assist me to move future.

[Vladimir Ralev]

You can install ant by following these instructions
http://ant.apache.org/manual/install.html

[Vladimir Ralev]

You need both ant and maven to build the project though

[Baskar]

Hi,

I have install both the mavien and ant in set path according to the user Guide.

While building the sip-servlet-examples it get this fatal error.

How to resolve the problem

F:\Documents and Settings\Peopletech\My Documents\sip-servlets\sip-servlets-exam

ples>mvn clean install

[INFO] Scanning for projects...

[INFO] ------------------------------------------------------------------------

[ERROR] FATAL ERROR

[INFO] ------------------------------------------------------------------------

[INFO] Error building POM (may not be this project's POM).

Project ID: unknown

POM Location: F:\Documents and Settings\Peopletech\My Documents\sip-servlets\sip

-servlets-examples\conference-demo\pom.xml

Reason: Parse error reading POM. Reason: Duplicated tag: 'repositories' (positio

n: START_TAG seen ...<!-- repositories -->\n\t<repositories>... @326:16)  for pr

oject unknown at F:\Documents and Settings\Peopletech\My Documents\sip-servlets\

sip-servlets-examples\conference-demo\pom.xml

[INFO] ------------------------------------------------------------------------

[INFO] Trace

org.apache.maven.reactor.MavenExecutionException: Parse error reading POM. Reaso

n: Duplicated tag: 'repositories' (position: START_TAG seen ...<!-- repositories

 -->\n\t<repositories>... @326:16)  for project unknown at F:\Documents and Sett

ings\Peopletech\My Documents\sip-servlets\sip-servlets-examples\conference-demo\

pom.xml

        at org.apache.maven.DefaultMaven.getProjects(DefaultMaven.java:378)

        at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:292)

        at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:129)

        at org.apache.maven.cli.MavenCli.main(MavenCli.java:301)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

        at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)

        at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)

        at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)

        at org.codehaus.classworlds.Launcher.main(Launcher.java:375)

Caused by: org.apache.maven.project.InvalidProjectModelException: Parse error re

ading POM. Reason: Duplicated tag: 'repositories' (position: START_TAG seen ...<

!-- repositories -->\n\t<repositories>... @326:16)  for project unknown at F:\Do

cuments and Settings\Peopletech\My Documents\sip-servlets\sip-servlets-examples\

conference-demo\pom.xml

        at org.apache.maven.project.DefaultMavenProjectBuilder.readModel(Default

MavenProjectBuilder.java:1591)

        at org.apache.maven.project.DefaultMavenProjectBuilder.readModel(Default

MavenProjectBuilder.java:1552)

        at org.apache.maven.project.DefaultMavenProjectBuilder.buildFromSourceFi

leInternal(DefaultMavenProjectBuilder.java:503)

        at org.apache.maven.project.DefaultMavenProjectBuilder.build(DefaultMave

nProjectBuilder.java:197)

        at org.apache.maven.DefaultMaven.getProject(DefaultMaven.java:583)

        at org.apache.maven.DefaultMaven.collectProjects(DefaultMaven.java:461)

        at org.apache.maven.DefaultMaven.collectProjects(DefaultMaven.java:534)

        at org.apache.maven.DefaultMaven.getProjects(DefaultMaven.java:365)

        ... 11 more

Caused by: org.codehaus.plexus.util.xml.pull.XmlPullParserException: Duplicated

tag: 'repositories' (position: START_TAG seen ...<!-- repositories -->\n\t<repos

itories>... @326:16)

        at org.apache.maven.model.io.xpp3.MavenXpp3Reader.parseModel(MavenXpp3Re

ader.java:2609)

        at org.apache.maven.model.io.xpp3.MavenXpp3Reader.read(MavenXpp3Reader.j

ava:4998)

        at org.apache.maven.project.DefaultMavenProjectBuilder.readModel(Default

MavenProjectBuilder.java:1587)

        ... 18 more

[INFO] ------------------------------------------------------------------------

[INFO] Total time: 1 second

[INFO] Finished at: Mon Oct 12 15:57:14 IST 2009

[INFO] Final Memory: 2M/4M

[INFO] ------------------------------------------------------------------------

F:\Documents and Settings\Peopletech\My Documents\sip-servlets\sip-servlets-exam

ples>

Some one assist me to move future.

Thanks with Regards,

N.Baskar

[Jean Deruelle]

I updated the pom.xml file to remove the duplicate repositories tag, you can update your local svn copy

However the pbx application is not shipped with MSS (Mobicents Sip Servlets) source code anymore

See http://code.google.com/p/mobicents/source/browse/#svn/trunk/applications/ipbx

[Vladimir Ralev]

The IPBX is in /applications/ipbx/ directory, not in sip-servlets-examples