JSLEE Discussions
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Connect to PostgreSQL database
Forum Index » Rhino SIP Servlet
Author Message
g3r4n


Joined: 16/04/2013 19:54:59
Messages: 8
Location: Angers France
Offline

I can't arrive to connect to my database.
How I can connect to it ? How to configure ?

I have tried by two way .

1) connect to the remote adress but il don't have the right. I have a permission socket issue ( acces denied).

2) find the conection by the contexte but i don't where is the configuration and i have the followin error :

2013-05-20 16:51:56.205 INFO [rhino.facility.alarm.manager] <RhinoScheduler-0> Active alarms for cluster:
2013-05-20 16:51:56.206 Major [rhino.facility.alarm.manager] <RhinoScheduler-0> Alarm 101:138008364655618 [SbbNotification[service=ServiceID[name=sipservlet-services,vendor=OpenCloud,version=1.0],sbb=SbbID[name=sipservlet-services,vendor=OpenCloud,version=1.0]],SipApplication,com.opencloud.sipservlet.container.runtime.event.ServletContextInitializedEvent] was raised at 2013-05-20 16:50:37.367 to level Major
Listener threw unhandled exception when processing event: com.opencloud.sipservlet.container.runtime.event.ServletContextInitializedEvent[source=com.opencloud.sipservlet.container.runtime.ServletContextImpl@4cd1063b]
java.sql.SQLException: Database 'joignabilite' not found.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(Unknown Source)
at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(Unknown Source)
at com.opencloud.sipservlet.proxy.B2BProxyServlet.doRequest(Unknown Source)
at javax.servlet.sip.SipServlet.service(Unknown Source)
at sun.reflect.GeneratedMethodAccessor164.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.opencloud.sipservlet.wrapper.impl.SleeEnvironmentImpl$1.run(SleeEnvironmentImpl.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at com.opencloud.sipservlet.wrapper.impl.SleeEnvironmentImpl.doPrivilegedInSarContext(SleeEnvironmentImpl.java:116)
at com.opencloud.sipservlet.container.runtime.SipContainerImpl$1.doPrivilegedInSarContext(SipContainerImpl.java:224)
at com.opencloud.sipservlet.container.runtime.ContainerEnvironmentWrapper.doPrivilegedInSarContext(ContainerEnvironmentWrapper.java:139)
at com.opencloud.sipservlet.container.runtime.handler.ServletHandler.service(ServletHandler.java:331)
at com.opencloud.sipservlet.container.runtime.ServletContainer.onRequest(ServletContainer.java:158)
at com.opencloud.sipservlet.container.runtime.SipContainerImpl.onRequest(SipContainerImpl.java:678)
at com.opencloud.sipservlet.services.sbbwrapper.lib.SipServletSbbWrapper.onRequest(SipServletSbbWrapper.java:413)
at com.opencloud.sipservlet.services.sbbwrapper.lib.SipServletSbbWrapper.onINVITE(SipServletSbbWrapper.java:187)
at com.opencloud.rhino.deployed.sbb.OpenCloud.sipservlet_services_1_0.SbbOCBBBean.sbbDeliverEvent(SbbOCBBBean.java:347)
at com.opencloud.deployed.Service_sipservlet_services_OpenCloud_1_0_3.SBB_sipservlet_services_OpenCloud_1_0OCBB_Local.sbbDeliverEvent(SBB_sipservlet_services_OpenCloud_1_0OCBB_Local.java:1453)
at com.opencloud.ob.Rhino.up.a(2.3-1.2-61504:164)
at com.opencloud.ob.Rhino.up.a(2.3-1.2-61504:136)
at com.opencloud.ob.Rhino.up.g(2.3-1.2-61504:88)
at com.opencloud.ob.Rhino.Ar.run(2.3-1.2-61504:87)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at com.opencloud.ob.Rhino.bp$a$a$a.run(2.3-1.2-61504:436)
Caused by: java.sql.SQLException: Database 'joignabilite' not found.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 37 more
java.sql.SQLException: Database 'joignabilite' not found.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(Unknown Source)
at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(Unknown Source)
at com.opencloud.sipservlet.proxy.B2BProxyServlet.doRequest(Unknown Source)
at javax.servlet.sip.SipServlet.service(Unknown Source)
at sun.reflect.GeneratedMethodAccessor164.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.opencloud.sipservlet.wrapper.impl.SleeEnvironmentImpl$1.run(SleeEnvironmentImpl.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at com.opencloud.sipservlet.wrapper.impl.SleeEnvironmentImpl.doPrivilegedInSarContext(SleeEnvironmentImpl.java:116)
at com.opencloud.sipservlet.container.runtime.SipContainerImpl$1.doPrivilegedInSarContext(SipContainerImpl.java:224)
at com.opencloud.sipservlet.container.runtime.ContainerEnvironmentWrapper.doPrivilegedInSarContext(ContainerEnvironmentWrapper.java:139)
at com.opencloud.sipservlet.container.runtime.handler.ServletHandler.service(ServletHandler.java:331)
at com.opencloud.sipservlet.container.runtime.ServletContainer.onRequest(ServletContainer.java:158)
at com.opencloud.sipservlet.container.runtime.SipContainerImpl.onRequest(SipContainerImpl.java:678)
at com.opencloud.sipservlet.services.sbbwrapper.lib.SipServletSbbWrapper.onRequest(SipServletSbbWrapper.java:413)
at com.opencloud.sipservlet.services.sbbwrapper.lib.SipServletSbbWrapper.onINVITE(SipServletSbbWrapper.java:187)
at com.opencloud.rhino.deployed.sbb.OpenCloud.sipservlet_services_1_0.SbbOCBBBean.sbbDeliverEvent(SbbOCBBBean.java:347)
at com.opencloud.deployed.Service_sipservlet_services_OpenCloud_1_0_3.SBB_sipservlet_services_OpenCloud_1_0OCBB_Local.sbbDeliverEvent(SBB_sipservlet_services_OpenCloud_1_0OCBB_Local.java:1453)
at com.opencloud.ob.Rhino.up.a(2.3-1.2-61504:164)
at com.opencloud.ob.Rhino.up.a(2.3-1.2-61504:136)
at com.opencloud.ob.Rhino.up.g(2.3-1.2-61504:88)
at com.opencloud.ob.Rhino.Ar.run(2.3-1.2-61504:87)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at com.opencloud.ob.Rhino.bp$a$a$a.run(2.3-1.2-61504:436)
Caused by: java.sql.SQLException: Database 'joignabilite' not found.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 37 more
2013-05-20 16:52:56.207 INFO [rhino.facility.alarm.manager] <RhinoScheduler-0> Active alarms for cluster:
2013-05-20 16:52:56.207 Major [rhino.facility.alarm.manager] <RhinoScheduler-0> Alarm 101:138008364655618 [SbbNotification[service=ServiceID[name=sipservlet-services,vendor=OpenCloud,version=1.0],sbb=SbbID[name=sipservlet-services,vendor=OpenCloud,version=1.0]],SipApplication,com.opencloud.sipservlet.container.runtime.event.ServletContextInitializedEvent] was raised at 2013-05-20 16:50:37.367 to level Major
Listener threw unhandled exception when processing event: com.opencloud.sipservlet.container.runtime.event.ServletContextInitializedEvent[source=com.opencloud.sipservlet.container.runtime.ServletContextImpl@4cd1063b]
g3r4n


Joined: 16/04/2013 19:54:59
Messages: 8
Location: Angers France
Offline

the error for the first tip :

[rhino.facility.alarm.manager] <RhinoScheduler-0> Alarm 101:138012263999999 [SbbNotification[service=ServiceID[name=sipservlet-services,vendor=OpenCloud,version=1.0],sbb=SbbID[name=sipservlet-services,vendor=OpenCloud,version=1.0]],SipApplication,com.opencloud.sipservlet.container.runtime.event.ServletContextInitializedEvent] was raised at 2013-05-20 18:20:42.088 to level Major
Listener threw unhandled exception when processing event: com.opencloud.sipservlet.container.runtime.event.ServletContextInitializedEvent[source=com.opencloud.sipservlet.container.runtime.ServletContextImpl@599e80b1]
org.postgresql.util.PSQLException: Your security policy has prevented the connection from being attempted. You probably need to grant the connect java.net.SocketPermission to the database server host and port that you wish to connect to.
at org.postgresql.Driver.connect(Driver.java:282)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.opencloud.sipservlet.proxy.B2BProxyServlet.doRequest(Unknown Source)
at javax.servlet.sip.SipServlet.service(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.opencloud.sipservlet.wrapper.impl.SleeEnvironmentImpl$1.run(SleeEnvironmentImpl.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at com.opencloud.sipservlet.wrapper.impl.SleeEnvironmentImpl.doPrivilegedInSarContext(SleeEnvironmentImpl.java:116)
at com.opencloud.sipservlet.container.runtime.SipContainerImpl$1.doPrivilegedInSarContext(SipContainerImpl.java:224)
at com.opencloud.sipservlet.container.runtime.ContainerEnvironmentWrapper.doPrivilegedInSarContext(ContainerEnvironmentWrapper.java:139)
at com.opencloud.sipservlet.container.runtime.handler.ServletHandler.service(ServletHandler.java:331)
at com.opencloud.sipservlet.container.runtime.ServletContainer.onRequest(ServletContainer.java:158)
at com.opencloud.sipservlet.container.runtime.SipContainerImpl.onRequest(SipContainerImpl.java:678)
at com.opencloud.sipservlet.services.sbbwrapper.lib.SipServletSbbWrapper.onRequest(SipServletSbbWrapper.java:413)
at com.opencloud.sipservlet.services.sbbwrapper.lib.SipServletSbbWrapper.onINVITE(SipServletSbbWrapper.java:187)
at com.opencloud.rhino.deployed.sbb.OpenCloud.sipservlet_services_1_0.SbbOCBBBean.sbbDeliverEvent(SbbOCBBBean.java:347)
at com.opencloud.deployed.Service_sipservlet_services_OpenCloud_1_0_6.SBB_sipservlet_services_OpenCloud_1_0OCBB_Local.sbbDeliverEvent(SBB_sipservlet_services_OpenCloud_1_0OCBB_Local.java:1366)
at com.opencloud.ob.Rhino.up.a(2.3-1.2-61504:164)
at com.opencloud.ob.Rhino.up.a(2.3-1.2-61504:136)
at com.opencloud.ob.Rhino.up.g(2.3-1.2-61504:88)
at com.opencloud.ob.Rhino.Ar.run(2.3-1.2-61504:87)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at com.opencloud.ob.Rhino.bp$a$a$a.run(2.3-1.2-61504:436)
Caused by: java.security.AccessControlException: access denied (java.net.SocketPermission 127.0.0.1:5432 connect,resolve)
at java.security.AccessControlContext.checkPermission(AccessControlContext.java:374)
at java.security.AccessController.checkPermission(AccessController.java:549)
at java.lang.SecurityManager.checkPermission(SecurityManager.java:532)
at java.lang.SecurityManager.checkConnect(SecurityManager.java:1034)
at java.net.Socket.connect(Socket.java:524)
at java.net.Socket.connect(Socket.java:478)
at org.postgresql.core.PGStream.<init>(PGStream.java:60)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
... 27 more
org.postgresql.util.PSQLException: Your security policy has prevented the connection from being attempted. You probably need to grant the connect java.net.SocketPermission to the database server host and port that you wish to connect to.
at org.postgresql.Driver.connect(Driver.java:282)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.opencloud.sipservlet.proxy.B2BProxyServlet.doRequest(Unknown Source)
at javax.servlet.sip.SipServlet.service(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.opencloud.sipservlet.wrapper.impl.SleeEnvironmentImpl$1.run(SleeEnvironmentImpl.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at com.opencloud.sipservlet.wrapper.impl.SleeEnvironmentImpl.doPrivilegedInSarContext(SleeEnvironmentImpl.java:116)
at com.opencloud.sipservlet.container.runtime.SipContainerImpl$1.doPrivilegedInSarContext(SipContainerImpl.java:224)
at com.opencloud.sipservlet.container.runtime.ContainerEnvironmentWrapper.doPrivilegedInSarContext(ContainerEnvironmentWrapper.java:139)
at com.opencloud.sipservlet.container.runtime.handler.ServletHandler.service(ServletHandler.java:331)
at com.opencloud.sipservlet.container.runtime.ServletContainer.onRequest(ServletContainer.java:158)
at com.opencloud.sipservlet.container.runtime.SipContainerImpl.onRequest(SipContainerImpl.java:678)
at com.opencloud.sipservlet.services.sbbwrapper.lib.SipServletSbbWrapper.onRequest(SipServletSbbWrapper.java:413)
at com.opencloud.sipservlet.services.sbbwrapper.lib.SipServletSbbWrapper.onINVITE(SipServletSbbWrapper.java:187)
at com.opencloud.rhino.deployed.sbb.OpenCloud.sipservlet_services_1_0.SbbOCBBBean.sbbDeliverEvent(SbbOCBBBean.java:347)
at com.opencloud.deployed.Service_sipservlet_services_OpenCloud_1_0_6.SBB_sipservlet_services_OpenCloud_1_0OCBB_Local.sbbDeliverEvent(SBB_sipservlet_services_OpenCloud_1_0OCBB_Local.java:1366)
at com.opencloud.ob.Rhino.up.a(2.3-1.2-61504:164)
at com.opencloud.ob.Rhino.up.a(2.3-1.2-61504:136)
at com.opencloud.ob.Rhino.up.g(2.3-1.2-61504:88)
at com.opencloud.ob.Rhino.Ar.run(2.3-1.2-61504:87)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at com.opencloud.ob.Rhino.bp$a$a$a.run(2.3-1.2-61504:436)
Caused by: java.security.AccessControlException: access denied (java.net.SocketPermission 127.0.0.1:5432 connect,resolve)
at java.security.AccessControlContext.checkPermission(AccessControlContext.java:374)
at java.security.AccessController.checkPermission(AccessController.java:549)
at java.lang.SecurityManager.checkPermission(SecurityManager.java:532)
at java.lang.SecurityManager.checkConnect(SecurityManager.java:1034)
at java.net.Socket.connect(Socket.java:524)
at java.net.Socket.connect(Socket.java:478)
at org.postgresql.core.PGStream.<init>(PGStream.java:60)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
... 27 more
 
Forum Index » Rhino SIP Servlet
Go to:   
Powered by JForum 2.1.8 © JForum Team