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