Have you updated the ./tomcat/conf/Catalina/localhost/jahia.xml file to include your database connections? When using jahia 5 this file also needs to be updated.
Tim _____ From: Graham Honey [mailto:[EMAIL PROTECTED] Sent: Friday, February 09, 2007 1:16 AM To: [email protected] Subject: FW: Database connection problems with Jahia5 Hi All, Following up from the email below. Is anyone able to offer any advice/information to resolve this issue below. Kind Regards Graham _____ From: Graham Honey Sent: Monday, February 05, 2007 5:21 PM To: '[email protected]' Subject: Database connection problems with Jahia5 Importance: High Hi, I am having problems with Jahia communicating with the database when the database and Jahia instance are on separate servers. When the database and Jahia instance are on the same server the site starts up without any issues. However when migrating the site through our environments it does not work when the site and database are on separate servers. I updated the jahia.properties file from: db_url = jdbc\:postgresql\:jahia501_dbname to: db_url = jdbc\:postgresql\://203.9.156.30\:5432/jahia501_dbname also tried the syntax provided in the jahia manual: to: db_url = jdbc:postgresql://203.9.156.30:5432/jahia501_dbname The error I get starts with the following which I believe is due to the Jahia instance not seeing the database? I have checked firewall and network issues, but as we have several jahia4 instance running with the same set up this is not an issue. Any help in resolving this asap would be great. Kind Regards Graham 595 [2007-02-05 15:39:12,275] [org.jahia.bin.JahiaJetspeedServlet] INFO - JetspeedServlet attempting to create the portlet engine... 804 [2007-02-05 15:39:12,484] [org.jahia.bin.JahiaJetspeedServlet] INFO - JetspeedServlet successfuly created the portal Engine. org.apache.jetspeed.engi [EMAIL PROTECTED] 806 [2007-02-05 15:39:12,486] [org.jahia.bin.JahiaJetspeedServlet] INFO - JetspeedServlet attempting to initialize the portletcontainer... org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'PlatformConfigurator' defined in ServletContext resource [/WEB-INF/et c/jetspeed/conf/assembly/boot/datasource.xml]: Initialization of bean failed; nested exception is org.apache.ojb.broker.metadata.MetadataException: Could not get the metadata from the given datasource org.apache.ojb.broker.metadata.MetadataException: Could not get the metadata from the given datasource at org.apache.ojb.broker.metadata.JdbcMetadataUtils.fillJCDFromDataSource(JdbcM etadataUtils.java:277) at org.apache.jetspeed.components.rdbms.ojb.DatabasePlatformConfigurator.init(D atabasePlatformConfigurator.java:69) 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:585) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory .invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:996) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory .invokeInitMethods(AbstractAutowireCapableBeanFactory.java:966) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory .createBean(AbstractAutowireCapableBeanFactory.java:354) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra ctBeanFactory.java:223) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra ctBeanFactory.java:147) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInst antiateSingletons(DefaultListableBeanFactory.java:277) at org.springframework.context.support.AbstractApplicationContext.refresh(Abstr actApplicationContext.java:312) at org.springframework.web.context.support.AbstractRefreshableWebApplicationCon text.refresh(AbstractRefreshableWebApplicationContext.java:134) at org.apache.jetspeed.components.SpringComponentManager.start(SpringComponentM anager.java:237) at org.apache.jetspeed.engine.JetspeedEngine.start(JetspeedEngine.java:114) at org.jahia.bin.JahiaJetspeedServlet.init(JahiaJetspeedServlet.java:158) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:11 05) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java: 3917) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4201) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:7 59) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:608) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535 ) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor t.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:709) at org.apache.catalina.startup.Catalina.start(Catalina.java:551) 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:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432) Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are corr ect and that the postmaster is accepting TCP/IP connections.) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav a:855) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:5 40)
