Tomcat connecting to MySQL - Ubuntu 8.10 Server

[Mark Kirkwood]

Ambrose Krapacs wrote:
> Perhaps you are on to something here. Below is the output from 3 
> attempts to telnet to localhost on port 3306. Something doens't seem 
> right..
>
> ambrose at ubuntusrvr:~$ telnet localhost 3306
> Trying 127.0.0.1...
> Connected to localhost.
> Escape character is '^]'.
> =
> 5.0.67-0ubuntu6
pOw,olQ3,FIyF1c!tIO2IConnection closed by foreign host.
> ambrose at ubuntusrvr:~$ telnet 127.0.0.1 <http://127.0.0.1/>  3306
> Trying 127.0.0.1...
> Connected to 127.0.0.1 <http://127.0.0.1/>.
> Escape character is '^]'.
> =
> 5.0.67-0ubuntu6Ha2pbz^H,,BG|^AimiF_/Connection closed by foreign host.
> ambrose at ubuntusrvr:~$ telnet 127.0.0.1 <http://127.0.0.1/> 3306
> Trying 127.0.0.1...
> Connected to 127.0.0.1 <http://127.0.0.1/>.
> Escape character is '^]'.
> =
> 5.0.67-0ubuntu6 /;{zsT(i,\o;vcjk\k'|\Connection closed by foreign host.

That would suggest to me that you are talking to Mysql, but it does not 
like what telnet is sending it (expected of course!). Have you got a 
Mysql log file around somewhere - usually called <your hostname>.err and 
located in whatever datadir Mysql uses on Ubuntu (not sure where it goes 
in Debian based distros). This may have more useful error messages in it 
- telling you why the Java connector is being refused a connection...

Cheers

Mark