Hi pascal,

Check your authentication. MySQL authentication is based on user, password *AND* host.

For local the host is going to be localhost usually.

Open the terminal and verify that you can connect like this:

$ mysql -u <username> -h localhost -p <databasename>
Enter Password:

Then make sure your connection URL and authentication params match what works on the command line.

HTH, Kieran


On Jan 15, 2009, at 1:01 PM, Pascal Robert wrote:

I have a really weird problem with the WOCommunity app and MySQL. The app was connected to MySQL 5.0.XX on a different server, but when I tried to switch it to the local MySQL installation, I got the famous "failed to open database channel" exception. But I know that the JDBC connection info is good, so I looked at connections, and I saw this :

java 28028 appserver 13u IPv6 570160 TCP web1.macti.ca:53034->web1.macti.ca:3306 (CLOSE_WAIT)

Hum, good old CLOSE_WAIT problems... But it's a weird problem because WordPress (PHP) can connect to the same database, and I connect to the database with the MySQL tools (on my MBP) without any problems.

I tried with both Connector/J 3.0.17 and 5.0.8, no differences. My next step is to try with a plain JDBC connection from a Java command- line app, but does anyone have seen this before?

-------------------------------------------------------
Pascal Robert

http://www.macti.ca
http://www.aircourriel.com
http://www.linkedin.com/in/macti

Skype: MacTICanada
AIM/iChat : MacTICanada

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-deploy mailing list (Webobjects- dep...@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-deploy/kieran_lists%40mac.com

This email sent to kieran_li...@mac.com

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-deploy mailing list      (Webobjects-deploy@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-deploy/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Reply via email to