Re: struts failed connection to remote mySQL

From: Keith Wansbrough (kw217_at_cl.cam.ac.uk)
Date: 08/16/04 

Date: 16 Aug 2004 20:36:58 +0100

Sudsy <bitbucket44@hotmail.com> writes:

> David wrote:
> <snip>
> > When I type netstat -a | grep
> > 3306 I dont' get anything at all.
>
> Then you don't have a listener on that port which is why your
> connection attempt fails.

Comment out the skip-networking directive in /etc/mysql/my.cnf; if you
don't do that, mysql listens on a Unix-domain socket only, but the
MySQL Connector/J uses TCP connections only.

Beware of security issues - by default mysql will listen on all
addresses. I did bind-address = 127.0.0.1 to be relatively safe.

Then shutdown mysql and restart it.

--KW 8-) 

-- 
Keith Wansbrough <kw217@cl.cam.ac.uk>
http://www.cl.cam.ac.uk/users/kw217/
University of Cambridge Computer Laboratory.

Relevant Pages

  • Re: mysql_query(): supplied argument is not a valid MySQL-Link resource
    ... You haven't checked for errors, and if this fails, you're just continuing ... without a connection. ... For every call to mysql_*, ... than global variables always being visible, when you're inside a function you ...
    (comp.lang.php)
  • Re: VFP8 & MySQL
    ... > VFP functions like NVL to a MySQL one, definitely it made the switch very ... > About your connection problem, I have mine setup as default for 100 ... As for the server, we left it ... The server crashed and corrupted the database. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Threading and returning values
    ... But, you still try to retrieve the results before the server has had a chance to do anything with them, and the DoWork event handler will never return, which means your RunWorkerCompleted event handler will never execute. ... TcpListener listener; ... // Start up a new thread to handle this specific connection, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Does apache stop a script mid execution ?
    ... If the user calls a time consuming script and then stops or refreshes ... How does it relate to e.g. a script performing a large mysql query? ... 2.b) how the connection is set up. ... the server stops the script execution. ...
    (comp.lang.php)
  • Re: Accessing DB2 with Java?
    ... Seems to me that you might want to sniff the connection to see what's ... We downloaded and installed the Java SDK ... got from IBM. ... connect to the JDBC listener on the IBM, ...
    (comp.sys.hp.mpe)