I have the registry loading and working ok with a local Oracle 10G database. However we need to move the registry and the database to a shared location and when I try to connect my registry application to the shared database setup for this, it throws an error on startup and does not load the application. Why is this? Can this be fixed asap so we can start using the registry in a shared location.
Thanks
Setup Details are as follows
LOCAL registry.xml
------------------
wso2registry
jdbc:oracle:thin:@localhost:1521/WLDEV
wso2registry
wso2registry
oracle.jdbc.driver.OracleDriver
LOCAL user-mgt.xml
------------------
jdbc:oracle:thin:@localhost:1521/WLDEV
wso2registry
wso2registry
oracle
oracle.jdbc.driver.OracleDriver
THE ABOVE WORKS SINCE IT IS CONNECTED TO AN ORACLE DB SETUP ON THE SAME BOX AS THE REGISTRY APPLICATION.
REMOTE registry.xml
------------------
wso2registry
jdbc:oracle:thin:@server:port/SID
wso2registry
wso2registry
oracle.jdbc.driver.OracleDriver
REMOTE user-mgt.xml
------------------
jdbc:oracle:thin:@server:port/SID
wso2registry
wso2registry
oracle
oracle.jdbc.driver.OracleDriver
THIS DOES NOT WORK. IT IS CONNECTED TO AN ORACLE DB SETUP ON A SEPARATE BOX AS THE REGISTRY APPLICATION. I can connect and login to the remote oracle database without any issues. I also tried to connect my local registry application to the remote oracle db and that also fails with the same error as follows:
The local and shared db user(wso2registry) both have the following 2 roles as grants
-- 2 Roles for WSO2REGISTRY
GRANT RESOURCE TO WSO2REGISTRY;
GRANT CONNECT TO WSO2REGISTRY;
ALTER USER WSO2REGISTRY DEFAULT ROLE ALL;
I thought this was a rights issue since locally I had 'CONNECT' and 'DBA' role granted to the user but the shared db user had 'CONNECT' and 'RESOURCE' roles(we cannot grant 'DBA' rights to a user in a shared db environment) so I changed the local db user to have 'RESOURCE' role instead of 'DBA' and that still works. So it does not seem like the role access has anything to do with this.
THE ERROR ON START IS AS FOLLOWS:
Jun 22, 2009 11:25:26 AM org.wso2.carbon.server.Main main
INFO: Starting WSO2 Carbon...
Jun 22, 2009 11:25:26 AM org.wso2.carbon.server.Main main
INFO: Using Java Home : C:\jdk1.5.0_16\jre
Jun 22, 2009 11:25:26 AM org.wso2.carbon.server.Main main
INFO: Using Java Version : 1.5.0_16
Jun 22, 2009 11:25:26 AM org.wso2.carbon.server.Main main
INFO: Using Carbon Home : C:\Carbon\Registry\tomcat\WSO2RE~1.1\bin\..
Jun 22, 2009 11:25:26 AM org.apache.catalina.startup.Embedded start
INFO: Starting tomcat server
Jun 22, 2009 11:25:27 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
Jun 22, 2009 11:25:27 AM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Jun 22, 2009 11:25:27 AM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-9763
Jun 22, 2009 11:25:27 AM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-9763
Jun 22, 2009 11:25:27 AM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-9443
Jun 22, 2009 11:25:27 AM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-9443
[2009-06-22 11:25:34,436] ERROR - WSO2 Registry is not available {org.wso2.carbon.core.ServerConfigurator}
[2009-06-22 11:25:34,436] FATAL - Cannot start WSO2 Registry {org.wso2.carbon.core.ServerManager}
org.apache.axis2.deployment.DeploymentException: WSO2 Registry is not available
at org.wso2.carbon.core.ServerConfigurator.populateAxisConfiguration(ServerConfigurator.java:240)
at org.wso2.carbon.core.ServerConfigurator.getAxisConfiguration(ServerConfigurator.java:170)
at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.j
ava:65)
at org.wso2.carbon.core.CarbonConfigurationContextFactory.createNewConfigurationContext(CarbonConfigurationConte
xtFactory.java:79)
at org.wso2.carbon.core.ServerManager.start(ServerManager.java:130)
at org.wso2.carbon.core.StartupServlet.start(StartupServlet.java:254)
at org.wso2.carbon.core.StartupServlet.init(StartupServlet.java:190)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.init(ServletRegistration.java:64)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.registerServlet(ProxyServlet.java:142)
at org.eclipse.equinox.http.servlet.internal.HttpServiceImpl.registerServlet(HttpServiceImpl.java:50)
at org.wso2.carbon.core.internal.Activator.start(Activator.java:58)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974)
at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350)
at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:634)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:508)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:282)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:468)
at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195)
at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297)
org.wso2.carbon.utils.ServerException: WSO2 Registry startup failed.
at org.wso2.carbon.core.StartupServlet.start(StartupServlet.java:286)
at org.wso2.carbon.core.StartupServlet.init(StartupServlet.java:190)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.init(ServletRegistration.java:64)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.registerServlet(ProxyServlet.java:142)
at org.eclipse.equinox.http.servlet.internal.HttpServiceImpl.registerServlet(HttpServiceImpl.java:50)
at org.wso2.carbon.core.internal.Activator.start(Activator.java:58)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974)
at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350)
at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:634)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:508)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:282)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:468)
at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195)
at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297)
Caused by: org.wso2.carbon.utils.ServerException: Cannot start WSO2 Registry
at org.wso2.carbon.core.ServerManager.start(ServerManager.java:159)
at org.wso2.carbon.core.StartupServlet.start(StartupServlet.java:254)
... 18 more
Caused by: org.apache.axis2.deployment.DeploymentException: WSO2 Registry is not available
at org.wso2.carbon.core.ServerConfigurator.populateAxisConfiguration(ServerConfigurator.java:240)
at org.wso2.carbon.core.ServerConfigurator.getAxisConfiguration(ServerConfigurator.java:170)
at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.j
ava:65)
at org.wso2.carbon.core.CarbonConfigurationContextFactory.createNewConfigurationContext(CarbonConfigurationConte
xtFactory.java:79)
at org.wso2.carbon.core.ServerManager.start(ServerManager.java:130)
... 19 more
[2009-06-22 11:25:34,499] FATAL - Could not start WSO2 Registry {org.wso2.carbon.core.StartupServlet}
org.wso2.carbon.utils.ServerException: WSO2 Registry startup failed.
at org.wso2.carbon.core.StartupServlet.start(StartupServlet.java:286)
at org.wso2.carbon.core.StartupServlet.init(StartupServlet.java:190)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.init(ServletRegistration.java:64)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.registerServlet(ProxyServlet.java:142)
at org.eclipse.equinox.http.servlet.internal.HttpServiceImpl.registerServlet(HttpServiceImpl.java:50)
at org.wso2.carbon.core.internal.Activator.start(Activator.java:58)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974)
at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350)
at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:634)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:508)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:282)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:468)
at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195)
at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297)
Caused by: org.wso2.carbon.utils.ServerException: Cannot start WSO2 Registry
at org.wso2.carbon.core.ServerManager.start(ServerManager.java:159)
at org.wso2.carbon.core.StartupServlet.start(StartupServlet.java:254)
... 18 more
Caused by: org.apache.axis2.deployment.DeploymentException: WSO2 Registry is not available
at org.wso2.carbon.core.ServerConfigurator.populateAxisConfiguration(ServerConfigurator.java:240)
at org.wso2.carbon.core.ServerConfigurator.getAxisConfiguration(ServerConfigurator.java:170)
at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.j
ava:65)
at org.wso2.carbon.core.CarbonConfigurationContextFactory.createNewConfigurationContext(CarbonConfigurationConte
xtFactory.java:79)
at org.wso2.carbon.core.ServerManager.start(ServerManager.java:130)
... 19 more
[2009-06-22 11:25:34,546] ERROR - Error initializing org.wso2.core.services component {org.wso2.carbon.core.services.in
ternal.Activator}
java.lang.NullPointerException
at org.wso2.carbon.core.services.authentication.AuthenticationAdminTrackers.init(AuthenticationAdminTrackers.jav
a:26)
at org.wso2.carbon.core.services.internal.Activator.start(Activator.java:20)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974)
at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350)
at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:634)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:508)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:282)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:468)
at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195)
at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297)
[2009-06-22 11:25:34,577] ERROR - Failed to start Carbon UI {org.wso2.carbon.ui.internal.Activator}
java.lang.Exception: ConfigurationContext Service is not available
at org.wso2.carbon.ui.internal.Activator.start(Activator.java:108)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974)
at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350)
at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:634)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:508)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:282)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:468)
at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195)
at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297)