Re: EOModel/Database access fails once deployed
Re: EOModel/Database access fails once deployed
- Subject: Re: EOModel/Database access fails once deployed
- From: Kieran Kelleher <email@hidden>
- Date: Tue, 2 Mar 2004 23:44:48 -0500
Hello Tom,
I use MySQL with WebObjects. Well since you say your development app is
accessing the MySQL server correctly from your own machine and assuming
that you, the MySQL server and the web server are all on the SAME
network, then I would check the following
First make sure you have Connector/J installed on the server:
Instructions here:
http://homepage.mac.com/kelleherk/iblog/C711669388/E70925289/index.html
Next make sure you have privileges. Remember MySQL authentication is
based on THREE things, the userid, the password AND the client IP
address (host). So, log into the MySQL server on the command line and
check the values for Host, User and Password in the User table of the
mysql database.
Also note that the Host can be wildcarded, for example '192.%' or
'192.168.1.%'. In any case the web server IP address MUST have
permission to access aswell as using the associated user and password.
If the web server IP does not match the Host associated with the user
and password being used in your deployed EOModel, then the connection
will fail. Period.
If you find an anomaly, simply do a "GRANT" statement to correct the
situation and you are done.
http://www.mysql.com/doc/en/GRANT.html
Regards, Kieran
________________________________________________________________
Config = OS X 10.3.2 / Java 1.4.1 / WO 5.2.2 / MySQL 4.0.18 /
Connector-J 3.0.11
Blog: http://webobjects.webhop.org/
On Mar 2, 2004, at 7:39 PM, Thomas Carstensen wrote:
i have a web objects app -- when run locally access the database on
our remote server is works fine -- access the mysql database via an
EOModel.
Move the app to the server. Access it via normal http:// ....
when it tries to access the database it fails. Does so on every WOApp
i move over. Wether i run it locally via XCode or on the server both
are accessing the same database.
Why would it fail simply my moving the WOApp to the server (where the
actually database is (localhost). ??
thanks for any help - below is the WO error message
-Tom Carstensen
Application:
MovieLibrary
Error:
java.lang.IllegalStateException: _obtainOpenChannel --
com.webobjects.eoaccess.EODatabaseContext
com.webobjects.eoaccess.EODatabaseContext@bf8de1: failed to open
database channel. Check your connection dictionary, and ensure your
database is correctly configured.
Reason:
Stack trace:
File
Line#
Method
Package
NA : Non applicable, JIT activated
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.