It doesn't look like permissions; that would be operation not
allowed. Looks to me like the port is either not open or changed.
Here are the relevant lines from a stock my.cnf file (your location
may vary, happiest when at /etc/my.cnf). Try telnet localhost 3306
and see if you can connect.
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
On Nov 27, 2008, at 2:55 AM, Simon McLean wrote:
minor tip: we never use the pre-installed version. i can't remember
why now, but we had problems with it. it's much more straightforward
to download the latest binary from mysql.
make sure your connection dictionary looks like this:
url: jdbc:mysql://127.0.0.1/yourdb?
capitalizeTypeNames=true&zeroDateTimeBehavior=convertToNull
driver: com.mysql.jdbc.Driver
plugin: (none)
and of course make sure you have the right username/password :-)
the exception looks like a permissions issue to me so worth checking
is that you have set permissions in mysql correctly. you'll need to
grant permissions to the user that you are connecting with and to
the domain - ie. if you are connecting local make sure you have
given the user local permission to do so. if you are on a dev
machine might be easiest to grant all permissions to [EMAIL PROTECTED]
and [EMAIL PROTECTED] just to get yourself moving, but you'll need to get it
right for production to ensure you don't leave a potential back door
open...
Simon
On 27 Nov 2008, at 03:11, Eleni Manou wrote:
Hello dear,
Details of my system is :
Mac OS X Server, version 10.5.5, WebObjects version 5.4, Eclipse
3.3.2, WOLips
MySQL is pre installed and working since using NAVICAT I connect
and work normally.
The error message I get when trying to generate SQL from WOLips is :
Failed to generate SQL. Communications link failure due to
underlying exception:
**BEGIN NESTED EXCEPTION**
java.net.ConnectException
MESSAGE: Connection refused
STACKTRACE:
java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
-----
----
There is no problem when I generate SQL for Openbase and Frontbase.
Can anyone help me on this?
Many thanks in advance
Stavros Panidis
_______________________________________________
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/simon_mclean%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/cawineguy%40gmail.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/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
