Just to be sure you are troubleshooting this right, try this on your terminal:

mysql -h localhost -u root -pTHEPASSWORD pi

NOTE: there is no space between 'p' and THEPASSWORD and obviously replace 
THEPASSWORD with your real password since I can't see that in you log output 
below. 


What happens when you do that?

Regards, Kieran.
(Sent from my iPhone)


On Jul 14, 2012, at 1:43 PM, James Cicenia <[email protected]> wrote:

> Hello -
> 
> I am having another head scratching mystery. No matter what I do, no matter 
> the database, no matter the credentials entered and no matter whether the 
> database is local or remote, WO won't connect to the database. I can connect 
> to all databases using Navicat just fine. This only effects my Eclipse and 
> not my deployed apps. Is there another obscure switch in Eclipse?
> 
> Thanks
> James
> 
> 
> WARN  NSLog  - An exception occurred while trying to open a channel: N/A
> Jul 14 13:41:24 PI[52856] INFO  er.transaction.adaptor.Exceptions  - Database 
> Exception occured: java.lang.IllegalStateException: _obtainOpenChannel -- 
> com.webobjects.eoaccess.EODatabaseContext 
> com.webobjects.eoaccess.EODatabaseContext@25964fe8: failed to open database 
> channel.  Check your connection dictionary, and ensure your database is 
> correctly configured.
> Jul 14 13:41:24 PI[52856] INFO  er.extensions.eof.ERXDatabaseContextDelegate  
> - PORTFOLIO: {driver = "com.mysql.jdbc.Driver"; password = "<password deleted 
> for log>"; username = "root"; URL = "jdbc:mysql://localhost:3306/pi"; }
> Jul 14 13:41:24 PI[52856] INFO  er.transaction.adaptor.ConnectionAnalyzer  - 
> Checking JDBC connection with information {driver = "com.mysql.jdbc.Driver"; 
> password = "<password deleted for log>"; username = "root"; URL = 
> "jdbc:mysql://localhost:3306/pi"; }
> Jul 14 13:41:24 PI[52856] INFO  er.transaction.adaptor.ConnectionAnalyzer  - 
> Trying to create JDBCAdaptor...
> Jul 14 13:41:24 PI[52856] INFO  er.transaction.adaptor.ConnectionAnalyzer  - 
> Successfully created adaptor com.webobjects.jdbcadaptor.JDBCAdaptor
> Jul 14 13:41:24 PI[52856] INFO  er.transaction.adaptor.ConnectionAnalyzer  - 
> Trying to create plugin...
> Jul 14 13:41:24 PI[52856] INFO  er.transaction.adaptor.ConnectionAnalyzer  - 
> Created plugin com.webobjects.jdbcadaptor._MySQLPlugIn
> Jul 14 13:41:24 PI[52856] INFO  er.transaction.adaptor.ConnectionAnalyzer  - 
> Trying to load JDBC driver com.mysql.jdbc.Driver...
> Jul 14 13:41:24 PI[52856] INFO  er.transaction.adaptor.ConnectionAnalyzer  - 
> Successfully loaded JDBC driver com.mysql.jdbc.Driver
> Jul 14 13:41:24 PI[52856] INFO  er.transaction.adaptor.ConnectionAnalyzer  - 
> JDBC driver and plugin are loaded, trying to connect...
> Jul 14 13:41:24 PI[52856] INFO  er.transaction.adaptor.ConnectionAnalyzer  - 
> Error: Exception thrown while connecting.
> Check exception message carefully.
> Jul 14 13:41:24 PI[52856] ERROR er.transaction.adaptor.ConnectionAnalyzer  - 
> No connection.
> 
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list      ([email protected])
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/kelleherk%40gmail.com
> 
> This email sent to [email protected]
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to