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)
