install on JES2005Q4 webserver: all ok except mysql part

[tvanover]

Hi,

I succesfully deployed alfresco 1.3 on our JES2005Q4 test server (on the webserver, not the application server). I d'loaded and installed the mysql jdbc connector. on a separate server where mysql is running, i created the alfresco database using the db_setup.sql script and ensured that the JES server can contact the mysql server via the network.

Then I tried to startup alfresco but it complained about not being able to connect to the mysql database, so we looked a bit further and edited the file …./alfresco/WEB-INF/classes/alfresco/extension/custom-db-connection.properties

we uncommented the first four lines:

db.username=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=100


and also:

db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://172.16.4.98/alfresco

then we restarted the webserver, but we still see this error in the webserver logs, see underneath. I guess the last line is the most interesting one.

So my question is: what did we miss ?

Thx,
Tom.


[22/Aug/2006:16:07:44] info (18326): CORE3282: stdout:  at org.apache.catalina.core.StandardEngine.start(Stand
ardEngine.java:355)
[22/Aug/2006:16:07:44] info (18326): CORE3282: stdout:  at org.apache.catalina.startup.Embedded.start(Embedded
.java:995)
[22/Aug/2006:16:07:44] info (18326): CORE3282: stdout:  at com.iplanet.ias.web.WebContainer.start(WebContainer
.java:431)
[22/Aug/2006:16:07:44] info (18326): CORE3282: stdout:  at com.iplanet.ias.web.WebContainer.startInstance(WebC
ontainer.java:500)
[22/Aug/2006:16:07:44] info (18326): CORE3282: stdout:  at com.iplanet.ias.server.J2EERunner.confPostInit(J2EE
Runner.java:161)
[22/Aug/2006:16:07:44] info (18326): CORE3282: stdout: Caused by: com.mchange.v2.resourcepool.CannotAcquireRes
ourceException: A ResourcePool could not acquire a resource from its primary factory or source.

[tvanover]

Hi,

some more information on what I changed in the config:

I'm trying to install alfresco 1.3 on Sun's Webserver (part of JES2005Q4).
Deploying the ware file etc. works fine, but I'm having problems of making the connection to the mysql database (I created it on another server wit the db_setup.sql, and it's reachable from the JES server).
I downloaded the mysql driver and installed it correctly i think (before I did it, i found entries in the errors file about 'Could not locate driver class with name 'org.gjt.mm.mysql.Driver''. Now I don't get this error anymore so I assume i got this part right.

The config files I changed were:

/opt/SUNWwbsvr/https-ldapmaster/webapps/https-ldapmaster/alfresco/WEB-INF/classes/alfresco/repository.properties:
this is the line i changed (I added the ip address)
db.url=jdbc:mysql://172.16.4.98/${db.name}


and the other file:
/opt/SUNWwbsvr/https-ldapmaster/webapps/https-ldapmaster/alfresco/WEB-INF/classes/alfresco/extension/custom-db-connection.properties
I uncommented these lines:

db.username=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=100

db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://172.16.4.98/alfresco

Can you give me some clues please ?

Thx,
Tom.

this is the error in the webserver logfile:

[23/Aug/2006:09:35:53] failure (24017): WebModule[/alfresco]: WEB2683: Exception sending context initialized event to lis
tener instance of class org.apache.myfaces.webapp.StartupServletContextListener
java.lang.NoClassDefFoundError: javax/servlet/jsp/el/ELException
        at org.apache.myfaces.config.FacesConfigurator.feedStandardConfig(FacesConfigurator.java:138)
        at org.apache.myfaces.config.FacesConfigurator.configure(FacesConfigurator.java:115)
        at org.apache.myfaces.webapp.StartupServletContextListener.initFaces(StartupServletContextListener.java:63)
        at org.apache.myfaces.webapp.StartupServletContextListener.contextInitialized(StartupServletContextListener.java:
46)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3387)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:3743)
        at com.iplanet.ias.web.WebModule.start(WebModule.java:251)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1133)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:652)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1133)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:355)
        at org.apache.catalina.startup.Embedded.start(Embedded.java:995)
        at com.iplanet.ias.web.WebContainer.start(WebContainer.java:431)
        at com.iplanet.ias.web.WebContainer.startInstance(WebContainer.java:500)
        at com.iplanet.ias.server.J2EERunner.confPostInit(J2EERunner.java:161)

[23/Aug/2006:09:35:53] info (24017): WEB2798: [/alfresco] ServletContext.log(): Loading Spring root WebApplicationContext
[23/Aug/2006:09:36:36] info (24017): CORE3282: stdout: 09:36:36,847 ERROR [hibernate.util.JDBCExceptionReporter] Connecti
ons could not be acquired from the underlying database!
[23/Aug/2006:09:36:56] info (24017): CORE3282: stdout: 09:36:56,429 ERROR [hibernate.util.JDBCExceptionReporter] Connecti
ons could not be acquired from the underlying database!
[23/Aug/2006:09:36:56] info (24017): CORE3282: stdout: 09:36:56,434 ERROR [tool.hbm2ddl.SchemaUpdate] could not get datab
ase metadata
[23/Aug/2006:09:36:56] info (24017): CORE3282: stdout: java.sql.SQLException: Connections could not be acquired from the
underlying database!
[23/Aug/2006:09:36:56] info (24017): CORE3282: stdout:  at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
[23/Aug/2006:09:36:56] info (24017): CORE3282: stdout:  at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPool
edConnection(C3P0PooledConnectionPool.java:352)
[23/Aug/2006:09:36:56] info (24017): CORE3282: stdout:  at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBac
kedDataSource.java:120)
[23/Aug/2006:09:36:56] info (24017): CORE3282: stdout:  at com.mchange.v2.c3p0.ComboPooledDataSource.getConnection(ComboP
ooledDataSource.java:601)

[tvanover]

ok, solved problem. mysql was not allowing my remote 'alfresco' user access to the database. so this part is solved. i'm having some other issues but i'll search some more before posting here.