Re: MySQL in TIGER

Hi Gino:
Did you check out the KBase article:
http://docs.info.apple.com/article.html?artnum=302936

Maybe it could help,

-mai
On Jan 20, 2006, at 2:56 AM, Gino Pacitti wrote:

> 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]
>
> _______________________________________________
> 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/mnguyen% 
> 40apple.com
>
> This email sent to [email protected]