Re: Urgent: WO error after server update to 10.4.4
Re: Urgent: WO error after server update to 10.4.4
- Subject: Re: Urgent: WO error after server update to 10.4.4
- From: Wolfram Stebel <email@hidden>
- Date: Mon, 16 Jan 2006 16:37:25 +0100
- Thread-topic: Urgent: WO error after server update to 10.4.4
Am 16.01.2006 14:38 Uhr schrieb "Kieran Kelleher" unter
<email@hidden>:
Hi Kieran,
Thanks!!!
What i forgot before: the update included WO 5.3.1!
> Is the server on the same machine or a different machine to the WO
> application?
> What is your full connection URL?
> What is the IP address of the WO app machine?
> What is the IP address of the MySQL database server?
All on one server, same IP.
>
> I am guessing your connection URL (perhaps host) is incorrect, or your
> privileges in MySQL (which include ALL OF user, password and client
> host) are not set to match the client IP where the WO app is connecting
> from.
>From the logs:
[2006-01-16 16:20:13 CET] <main> Didn't find any JNDI data source.
[2006-01-16 16:20:13 CET] <main> Using JDBCPlugIn
'com.webobjects.jdbcadaptor.MySQLPlugIn' for JDBCAdaptor@8628573
[2006-01-16 16:20:13 CET] <main> connecting with dictionary: {plugin
= ""; username = "webclubs"; driver = ""; password = "<password
deleted for log>"; URL = "jdbc:mysql://localhost/WebClubs"; }
DriverManager.getConnection("jdbc:mysql://localhost/WebClubs")
trying driver
[className=com.mysql.jdbc.Driver,com.mysql.jdbc.Driver@9d4f72]
java.sql.SQLException: Unable to connect to any hosts due to
exception: java.net.ConnectException: Connection refused
this used to work until today!
Wolfram
>> Hi list,
>>
>> i update server to 10.4.4.
>>
>> Starting my applications in monitor results in :
>>
>> ...
>>
>> java.net.SocketException
>> MESSAGE: java.net.ConnectException: Connection refused
>>
>> STACKTRACE:
>>
>> 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)
>> ...
>>
>>
>> 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)
>>
>>
>> ------
>>
>>
>> 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/:
>>
>> [mysqld]
>> datadir=/Volumes/Sonne-Data/mySQL-Data
>> pid-file=/Volumes/Sonne-Data/mySQL-Data/Sonne.local.pid
>> socket=/var/mysql/mysql.sock
>> port=3306
>> character-set-server=latin1
>> collation-server=latin1_german1_ci
>>
>>
>> [mysql.server]
>> basedir=/usr/bin
>>
>> -------
>>
>> Any tips?
>>
>> Please hurry :-)
>>
>> Wolfram
>>
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>> email@hidden
>>
>> This email sent to email@hidden
>>
>
Dipl. Inform. Wolfram Stebel, bugs&errors
Flutgrabenstr. 19, 35576 Wetzlar
Tel. 06441/47633
Mailto:email@hidden
Web: www.bugs-and-errors.de
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden