Peter Thanks for the hint; could you be more specific as to what/how the authorisation was implemented?
Derek >>> [EMAIL PROTECTED] 27/03/2002 10:42:13 >>> I had a similar problem, Derek, which I eventually tracked down to authorisation problems. My DB was set up for user@localhost, and the driver was trying to connect with [EMAIL PROTECTED] When I added this authorisation to the MySQL tables, it worked w/o problem. Yours may be a different cause, but it looks like the driver can't connect to the DB for some reason. On Wednesday 27 Mar 2002 6:38 am, Derek Hohls wrote: > 1) The jdbc driver file is loaded under: WEB-INF/classes/.... > > 2) The xconf file contains: > > <datasources> > <jdbc name="my_connection"> > <pool-controller min="5" max="10"/> > <auto-commit>true</auto-commit> > <dburl>jdbc:mysql://localhost:3306/mydbase</dburl> > <user>foo</user> > <password>bar</password> > </jdbc> > </datasources> > > 3) I am not sure what you mean by "access.log" - I only have > cocoon.log and root.log in my WEB-INF/logs directory? > > The first enty in the cocoon.log has the line: > > FATAL_E (2002-03-26) 15:31.06:158 [cocoon ] > (Unknown-URI) Unknown-thread/JdbcConnectionPool: > Excalibur could not create any connections. > Examine your settings to make sure they are correct. > Make sure you can connect with the same settings on your machine. > > The root.log has no entries in it at all... > > > Thanks for responding - any comments on the above?? > > Derek > > >>> [EMAIL PROTECTED] 26/03/2002 05:11:18 >>> > > 1) You must have jdbc driver file in classpath > 2) Check your cocoon.xconf > for <datasources>...</datasources> for pool configuration > 3) See access.log for message like this > DEBUG (2002-03-26) 17:04.45:713 [access] (Unknown-URI) > Unknown-thread/Cocoon > Servlet: Trying to load class: org.gjt.mm.mysql.Driver > > ----- Original Message ----- > From: "Derek Hohls" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, March 26, 2002 4:43 PM > Subject: Database connection problem > > > When trying to connect to a mySQL database, I get: > > > > Could not get the datasource java.sql.SQLException: There are no > > connections in the pool, check your settings. > > > > I already have the setting for the driver in the web.xml; > > <init-param> > > <param-name>load-class</param-name> > > <param-value>org.gjt.mm.mysql.Driver</param-value> > > </init-param> > > > > I can also connect to, and 'see' the database with another, > > front-end > > > program. > > > > In fact, the connection AND database were working previously - does > > anyone know if a mod_rewrite for the site in the Apache server would > > affect this?? (seems strange, but thats the only major change that > > has > > > happened on the server that I know about) I have also checked the > > connection without using the VirtualHost and get the same results... > > > > Any ideas as to what else to check? > > > > Thanks > > Derek > > --------------------------------------------------------------------- > > > Please check that your question has not already been answered in the > > FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> > > > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > > For additional commands, e-mail: <[EMAIL PROTECTED]> > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> > > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]> --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>