Re: MySQL in TIGER
Re: MySQL in TIGER
- Subject: Re: MySQL in TIGER
- From: Gino Pacitti <email@hidden>
- Date: Fri, 20 Jan 2006 10:56:49 +0000
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@hidden>:
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@hidden)
Help/Unsubscribe/Update your Subscription:
@bugs-and-errors.de
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40mac.com
This email sent to email@hidden
_______________________________________________
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