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(J dbcMetadataUtils.java:277) at org.apache.jetspeed.components.rdbms.ojb.DatabasePlatformConfigurator.in it(DatabasePlatformConfigurator.java:69) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac tory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:996) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac tory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:966) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac tory.createBean(AbstractAutowireCapableBeanFactory.java:354) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Ab stractBeanFactory.java:223) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Ab stractBeanFactory.java:147) at org.springframework.beans.factory.support.DefaultListableBeanFactory.pre InstantiateSingletons(DefaultListableBeanFactory.java:277) at org.springframework.context.support.AbstractApplicationContext.refresh(A bstractApplicationContext.java:312) at org.springframework.web.context.support.AbstractRefreshableWebApplicatio nContext.refresh(AbstractRefreshableWebApplicationContext.java:134) at org.apache.jetspeed.components.SpringComponentManager.start(SpringCompon entManager.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.jav a:1105) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.j ava:3917) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4201 ) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.ja va:759) 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:31 0) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSu pport.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.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.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 .java:855) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.ja va:540)
