I remember MySQL having restrictions that deny access to a user depending on what host it is connecting from. Do the following:
MySQL> USE mysql; MySQL> SELECT user, host FROM user; Sent from my iPhone > On Oct 17, 2015, at 2:01 AM, Stavros Panidis <[email protected]> > wrote: > > Dear, > > thank you for your quick reply! > > It is the same application (not even re compiled) running at least 2 years > with no problem on OS X 10.9 Server. > > I think that rather has to do with MySQL installation on Yosemite Server. > ----------------------- >> >> Message: 2 >> Date: Fri, 16 Oct 2015 19:39:46 +0200 >> From: Markus Ruggiero <[email protected]> >> To: Stavros Panidis <[email protected]> >> Cc: "[email protected]" <[email protected]> >> Subject: Re: Yosemite deployment problem with MySQL >> Message-ID: <[email protected]> >> Content-Type: text/plain; charset="utf-8" >> >> Did you check your connection dictionary? > > YES >> Did you include the jdbc driver into the class path? > > YES >> Is the URL correct (jdbc:mysql://localhost/myDBName) > > YES >> >> Enable adaptor debugging. EOF will then output the used connection info - is >> it using what you think it should? > > ? Sorry, I don’t know how >> >> Where does the connection info come from: the EOModel or from some >> properties or any other mechanism? > > From EOModel if I understand well. Corresponding line in Main component is > > NSArray accountsArray = EOUtilities.objectsForEntityNamed(ec, "Accounts”); > >> >> Just some random thoughts >> ---markus--- >> >>> On 16.10.2015, at 18:50, Stavros Panidis <[email protected]> wrote: >>> >>> Dear list, >>> >>> >>> I get the following error when try to connect to my application. >>> >>> Error: java.lang.IllegalStateException: _obtainOpenChannel -- >>> com.webobjects.eoaccess.EODatabaseContext >>> com.webobjects.eoaccess.EODatabaseContext@3dd81ec9: failed to open database >>> channel. Check your connection dictionary, and ensure your database is >>> correctly configured. >>> Reason: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext >>> com.webobjects.eoaccess.EODatabaseContext@3dd81ec9: failed to open database >>> channel. Check your connection dictionary, and ensure your database is >>> correctly configured. >>> >>> >>> Deployment machine is Mac Mini running Yosemite Server. >>> >>> MySQL version is 5.6.25 >>> MySQL connector Java version is 5.1.31 >>> >>> MySQL is running and stopping locally by System settings. >>> >>> MySQL is working locally with a third application (Navicat) >>> >>> MySQL is working remotely via Terminal login. >>> >>> Any idea what can be wrong? >>> >>> Many thanks in advance >>> >>> Stavros >>> >>> >>> >>> >>> >>> >>> >>> >>> _______________________________________________ >>> 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/mailinglists%40kataputt.com >>> >>> This email sent to [email protected] >> >> -------------- next part -------------- >> An HTML attachment was scrubbed... >> URL: >> <http://lists.apple.com/archives/webobjects-dev/attachments/20151016/c1827c26/attachment.html> >> >> ------------------------------ >> >> Message: 3 >> Date: Fri, 16 Oct 2015 17:45:55 +0000 >> From: Chuck Hill <[email protected]> >> To: Markus Ruggiero <[email protected]>, Stavros Panidis >> <[email protected]> >> Cc: "[email protected]" <[email protected]> >> Subject: Re: Yosemite deployment problem with MySQL >> Message-ID: <d24685ae.39c2a%[email protected]> >> Content-Type: text/plain; charset="iso-8859-1" >> >> Wonder's ERXJDBCConnectionAnalyzer should help here. I though it was >> automatically activated in the case of a connection failure, but maybe I am >> imagining that. > > Sorry, I don’t know how to use it! I think there is something in ‘Practical > WebObjects’ isn’t it? > > _______________________________________________ > 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/rparada%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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
