Hi - now I saw your new mail :-). Good you solved it.
/Mattias
________________________________
From: Michael Owen [mailto:michaelowenuk@...]
Sent: den 5 februari 2008 19:06
To: infoglue-developer@...; Bogeblad Mattias
Subject: RE: [Infoglue-developer] Some parts of CMS can read/use DB,
other parts of CMS can't use DB
Solved the issue.
Somehow the propertyset.xml and hibernate.cfg.xml files had old values
for the DB details.
________________________________
From: michaelowenuk@...
To: infoglue-developer@...; mattias.bogeblad@...
Date: Tue, 5 Feb 2008 17:05:29 +0000
Subject: [Infoglue-developer] Some parts of CMS can read/use DB, other
parts of CMS can't use DB
Hi,
I'm having a problem with my Infoglue setup, which has been running
successfully for 5 months or so. I haven't recently changed any
configuration etc in the installation. I only started to restart the
internal box (see below), when the CMS was hanging when trying to use
it.
I have two boxes:
INTERNAL: Hosts Tomcat with CMS, Working and Preview engines
EXTERNAL: Hosts Tomcat with Live environment, and MySQL
The CMS, Working and Preview engines now have a problem connecting to
the MySQL database upon start up of Tomcat with each giving the
following error:
java.sql.SQLException: Server connection failure during transaction.
Due to underlying exception: 'java.net.SocketException:
java.net.ConnectException: Connection timed out'.
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection timed out
STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection timed
out
at
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:
151)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
at
com.mysql.jdbc.Connection.createNewIO(Connection.java:1895)
at com.mysql.jdbc.Connection.<init>(Connection.java:437)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:26
8)
at
java.sql.DriverManager.getConnection(DriverManager.java:525)
at
java.sql.DriverManager.getConnection(DriverManager.java:171)
at
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(
DriverManagerConnectionFactory.java:65)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableCon
nectionFactory.java:294)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjec
tPool.java:840)
at
org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:176)
at
java.sql.DriverManager.getConnection(DriverManager.java:525)
at
java.sql.DriverManager.getConnection(DriverManager.java:193)
at
org.infoglue.cms.util.workflow.InfoGlueJDBCPropertySet.getConnection(Inf
oGlueJDBCPropertySet.java:647)
at
org.infoglue.cms.util.workflow.InfoGlueJDBCPropertySet.getKeys(InfoGlueJ
DBCPropertySet.java:119)
at
com.opensymphony.module.propertyset.AbstractPropertySet.getKeys(Abstract
PropertySet.java:224)
at
com.opensymphony.module.propertyset.AbstractPropertySet.toString(Abstrac
tPropertySet.java:362)
at java.lang.String.valueOf(String.java:2615)
The link to the DB is fine from the internal box (tested with telnet,
mysql client, simple text program for JDBC call etc).
When Tomcat has loaded (after giving the errors above) I can get into
the CMS with my credentials, therefore indicating that part of the
system can communnicate with the db. Which again is confirmed by
changing my password in the DB, and then making sure I can't login with
my old password and can with my new password.
When in the CMS, the the list of pages loads in the left hand menu, but
when clicking on a particular page for more information I get the above
error again eventually after waiting a long time.
It therefore seems as if some parts of the application can connect the
db, but other parts can't.
I'm using IG version 2.5.0 Final (2007-06-15).
Any thoughts?
Thanks
Mike
________________________________
Think you know your TV, music and film? Try Search Charades!
<https://www.searchcharades.com>
________________________________
Think you know your TV, music and film? Try Search Charades!
<https://www.searchcharades.com>
|