Re: MySQL in TIGER

I also have a problem with MySQL on 10.4.4

It is a new machine and I get this error when I am trying to start my  
app.

An exception occurred while trying to open a channel:  
com.webobjects.jdbcadaptor.JDBCAdaptorException: Cannot connect to  
MySQL server on 127.0.0.1:3306. Is there a MySQL server running on  
the machine/port you are trying to connect to?  
(java.net.ConnectException)
[2006-01-20 10:38:18 GMT] <main> A fatal exception occurred:  
_obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext  
com.webobjects.eoaccess.EODatabaseContext@49f9fa: failed to open  
database channel.  Check your connection dictionary, and ensure your  
database is correctly configured.
[2006-01-20 10:38:18 GMT] <main> java.lang.IllegalStateException:  
_obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext  
com.webobjects.eoaccess.EODatabaseContext@49f9fa: failed to open  
database channel.  Check your connection dictionary, and ensure your  
database is correctly configured.


The mysql daemon is running and I can connect to it using command  
line on the machine.

I have the last driver installed too and the connection dictionary is  
the same I use for a different machine.

Any Ideas.


Gino
On 20 Jan 2006, at 10:50, Wolfram Stebel wrote:

> Am 20.01.2006 10:00 Uhr schrieb ".::welemski::." unter  
> <[email protected]>:
>
>> Hi,
>
> I really had a big problem in MySQL.
> Im running a Tiger server since it
>> is built in from the time it was
> installed I just
> don't have any idea why
>> myWebApp can't connect to mysql?
>
> I search through the internet and I found
>> many people complaining about
> MySQL in Tiger.
>
> Now I have no choice but to
>> revert back to Panther. I still would like to go
> in Tiger though.
>
> Does anyone
>> have a solution for MySQL in Tiger?
>
> --
>  -- -- -- -- -- -- -- -- -- -- --
>
>> welemski
>  -- -- -- -- -- -- --
>
> Try the solution in the attached mail
> It is a copy of from a thread two days ago.
>
> Wolfram
>
>
>
> Hallo Ute,
>
> nenn' mir deine Kontonummer! Du hast's mal wieder getroffen.
>
> Continued in english!
>
> As Ute mentioned, there was something on the list short before and  
> i found
> it by the magic words (mysql, network) Ute told me!
> I should have recognized the tick mark in MySQLManager (Apple  
> startup tool)=
> !
>
> To honor the man who solved it:
>
>> Subject: 10.4.3, mysql, webobjects gotcha
>> From: Graham J Lee <email@hidden>
>> Date: Fri, 4 Nov 2005 18:29:09 +0000
>> Hi all,
>
>> just had a hairy half hour with a load of webobjects instances  
>> failing aft=
> er
>
> You must be glad, i was helpless for hours.
>
>> upgrading to 10.4.3. The problem was that with the software  
>> update, rather=
>  than
>> executing /usr/bin/mysqld_options the MySQL StartupItem now gets  
>> its optio=
> ns
>> from /usr/bin/ mysqld_manager_options. Its default behaviour is  
>> just to
>> disallow network connections (it appends the argument --skip- 
>> networking to=
>  the
>> mysqld_safe invocation). JDBC connects over the network even on  
>> localhost,=
>  so
>> none of the instances could connect to the database. To fix this  
>> (not sure=
>  why
>> it was changed in the first place, frankly) edit /etc/ 
>> mysqlManager.plist a=
> nd
>> change the "no" which appears there to a "yes", then restart MySQL.
>
>> Hope that helps someone,
> Indeed it did!!!
>
> Thanks to:
>> Graham.
>
>
> --
> Graham Lee                       GPG Key ID: 01D5B9D8
> UNIX Systems Manager,
> Oxford Physics Practical Course
> http://nextstep.sdf-eu.org               01865 273450
>
>
>
>> Hallo Wolfram,
>> war da nicht mal ein Thread =FCber ge=E4nderte Mysql Privilegien  
>> und dass
>> der Zugang =FCber das Netz pl=F6tzlich inaktiv/aus war. Ich glaube  
>> man
>> musste im config-File was Network Connection erlauben und mysql neu
>> starten...
>> =20
>> Vielleicht hilft das was...?
>> =20
>> Viele Gr=FC=DFe
>> =20
>> Ute
>> =20
>> Am Montag, 16.01.06 um 14:27 Uhr schrieb Wolfram Stebel:
>> =20
>>> Hi list,
>>> =20
>>> i update server to 10.4.4.
>>> =20
>>> Starting my applications in monitor results in :
>>> =20
>>> ...
>>> =20
>>> java.net.SocketException
>>> MESSAGE: java.net.ConnectException: Connection refused
>>> =20
>>> STACKTRACE:
>>> =20
>>> java.net.SocketException: java.net.ConnectException: Connection  
>>> refused
>>>     at com.mysql.jdbc.StandardSocketFactory.connect
>>> (StandardSocketFactory.java:156)
>>>     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
>>> ...
>>> =20
>>> =20
>>> Last packet sent to the server was 0 ms ago.
>>> [2006-01-16 11:52:50 CET] <main> A fatal exception occurred:
>>> _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext
>>> com.webobjects.eoaccess.EODatabaseContext@c488c: failed to open
>>> database channel.  Check your connection dictionary, and ensure your
>>> database is correctly configured.
>>> [2006-01-16 11:52:50 CET] <main> java.lang.IllegalStateException:
>>> _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext
>>> com.webobjects.eoaccess.EODatabaseContext@c488c: failed to open
>>> database channel.  Check your connection dictionary, and ensure your
>>> database is correctly configured.
>>>     at com.webobjects.eoaccess.EODatabaseContext._obtainOpenChannel
>>> (EODatabaseContext.java:2131)
>>> =20
>>> =20
>>> ------
>>> =20
>>> =20
>>> i'm able to connect with MySQLAdministrator and manually with the  
>>> user
>>> and
>>> password the application uses.
>>> i tried a new jdbc driver.
>>> i have my.cnf in /etc/:
>>> =20
>>> [mysqld]
>>> datadir=3D/Volumes/Sonne-Data/mySQL-Data
>>> pid-file=3D/Volumes/Sonne-Data/mySQL-Data/Sonne.local.pid
>>> socket=3D/var/mysql/mysql.sock
>>> port=3D3306
>>> character-set-server=3Dlatin1
>>> collation-server=3Dlatin1_german1_ci
>>> =20
>>> =20
>>> [mysql.server]
>>> basedir=3D/usr/bin
>>> =20
>>> -------
>>> =20
>>> Any tips?
>>> =20
>>> Please hurry :-)
>>> =20
>>> Wolfram
>
>
>  _______________________________________________
> 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/wolfram.stebel 
> %40bugs-and-errors.de
>
> 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/ginokris% 
> 40mac.com
>
> This email sent to [email protected]