cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Derek Hohls" <DHo...@csir.co.za>
Subject Re: Database connection problem
Date Wed, 27 Mar 2002 09:43:18 GMT
Peter

Thanks for the hint; could you be more specific as to what/how 
the authorisation was implemented?

Derek

>>> cocoon@peterrobins.co.uk 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 user@localhost.localdomain. 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
>
> >>> demchenko@kyivstar.net 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" <DHohls@csir.co.za>
> To: <cocoon-users@xml.apache.org>
> 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: <cocoon-users-unsubscribe@xml.apache.org>
> > For additional commands, e-mail:
<cocoon-users-help@xml.apache.org>
>
>
---------------------------------------------------------------------
> 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: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
>
>
>
---------------------------------------------------------------------
> 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: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>

---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message