meant to say "if that does not work ... 5.0.XX..."
On Mar 25, 2008, at 1:55 PM, Kieran Kelleher wrote:
ssh into the server running the WO app and try and connect to the
server using the same credentials as the WO app
mysql -u <woappuser> -h <databasehost> -p<wopassword> <databasename>
(note NO space between -p and <wopassword> ... that's how to pass a
password non-interactively.
if that works, then change the java jdbc connector to version 5.0.XX
since that's what I am using and it works wit MySQL 5.0.XX
On Mar 20, 2008, at 5:34 PM, Chris Hoyt wrote:
I am having trouble moving a project live. The program errors out
with a JDBC connect error when I put it on my server. The output
is below. Here are some clues:
- I have Mac OS X 10.5
- I have this working my development environment
- I have other websites that successfully use MySQL through PHP
- I have installed mysql-connector-java-5.1.5-bin.jar in /Library/
Java/Extensions
- The databases/users/privileges are identical in my dev
environment and server
Thanks ahead of time.
Last packet sent to the server was 1 ms
ago.java.net.ConnectException: Connection refusedat
com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:
1070)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:
2104)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
at
com
.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:
283)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.webobjects.jdbcadaptor.JDBCContext.connect(JDBCContext.java:
236)
at
com.webobjects.jdbcadaptor.JDBCContext._tryConnect(JDBCContext.java:
362)
at
com
.webobjects
.jdbcadaptor.JDBCContext._channelWillOpen(JDBCContext.java:505)
at
com.webobjects.jdbcadaptor.JDBCChannel.openChannel(JDBCChannel.java:
111)
at
com
.webobjects
.eoaccess
.EODatabaseContext
._openChannelWithLoginPanel(EODatabaseContext.java:1907)
at
com
.webobjects
.eoaccess
.EODatabaseContext._obtainOpenChannel(EODatabaseContext.java:1966)
at
com
.webobjects
.eoaccess
.EODatabaseContext
._objectsWithFetchSpecificationEditingContext
(EODatabaseContext.java:3054)
at
com
.webobjects
.eoaccess
.EODatabaseContext
.objectsWithFetchSpecification(EODatabaseContext.java:3195)
at
com
.webobjects
.eocontrol
.EOObjectStoreCoordinator
.objectsWithFetchSpecification(EOObjectStoreCoordinator.java:488)
at
com
.webobjects
.eocontrol
.EOEditingContext
.objectsWithFetchSpecification(EOEditingContext.java:4053)
at
com
.webobjects
.eocontrol
.EOEditingContext
.objectsWithFetchSpecification(EOEditingContext.java:4428)
at beheard.app.Main.<init>(Main.java:70)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun
.reflect
.NativeConstructorAccessorImpl
.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun
.reflect
.DelegatingConstructorAccessorImpl
.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at
com
.webobjects
.foundation._NSUtilities.instantiateObject(_NSUtilities.java:614)
at
com
.webobjects
.appserver
._private
.WOComponentDefinition
._componentInstanceInContext(WOComponentDefinition.java:566)
at
com
.webobjects
.appserver
._private
.WOComponentDefinition
.componentInstanceInContext(WOComponentDefinition.java:664)
at
com
.webobjects.appserver.WOApplication.pageWithName(WOApplication.java:
2323)
at
com
.webobjects
.appserver
._private
.WOComponentRequestHandler
._dispatchWithPreparedSession(WOComponentRequestHandler.java:284)
at
com
.webobjects
.appserver
._private
.WOComponentRequestHandler
._dispatchWithPreparedApplication(WOComponentRequestHandler.java:332)
at
com
.webobjects
.appserver
._private
.WOComponentRequestHandler
._handleRequest(WOComponentRequestHandler.java:369)
at
com
.webobjects
.appserver
._private
.WOComponentRequestHandler
.handleRequest(WOComponentRequestHandler.java:442)
at
com
.webobjects
.appserver.WOApplication.dispatchRequest(WOApplication.java:1678)
at
com
.webobjects
.appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:144)
at
com
.webobjects
.appserver._private.WOWorkerThread.run(WOWorkerThread.java:226)
at java.lang.Thread.run(Thread.java:613)
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/kieran_lists%40mac.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:
http://lists.apple.com/mailman/options/webobjects-dev/kieran_lists%40mac.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:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
