You can find more on mySQL authorisartion in the documents on the mySQL site. One of them is http://www.mysql.com/articles/mysql_intro.html All it comes down to is setting the correct entries in the user and db tables in the mysql database. Bert At 11:43 27/03/2002 +0200, you wrote: >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]>
--------------------------------------------------------------------- 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]>
