FS#7256 - MySQL + Java

Attached to Project: Arch Linux
Opened by João Rodrigues (gothicknight) - Thursday, 24 May 2007, 14:58 GMT
Last edited by eliott (cactus) - Friday, 31 August 2007, 06:54 GMT
Task Type Bug Report
Category Packages: Current
Status Closed
Assigned To No-one
Architecture i686
Severity Critical
Priority Normal
Reported Version 0.8 Voodoo
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details


MySQL seems to fail in accepting connections from the JDBC driver, the driver it self works fine to an external (ubuntu) server but not locally.
This is a critical failure as it is needed to host tomcat/mysql server.
Using MySQL Administrator and Query Browser all works, but using JDBC driver fails.

The forum thread with the error
http://bbs.archlinux.org/viewtopic.php?pid=252662#p252662
This task depends upon

Closed by  eliott (cactus)
Friday, 31 August 2007, 06:54 GMT
Reason for closing:  Not a bug
Comment by Pierre Schmitz (Pierre) - Thursday, 24 May 2007, 17:15 GMT
Did you activate tcp-networking of mysqld? (comment out "skip-networking" in /etc/my.cnf) JDBC is not able to connect through unix sockets.
Comment by João Rodrigues (gothicknight) - Thursday, 24 May 2007, 17:38 GMT
Yes, the skip-networking is commented.
Comment by João Rodrigues (gothicknight) - Thursday, 24 May 2007, 17:41 GMT

My 'my.cnf' attatched
   my.cnf (4.5 KiB)
Comment by João Rodrigues (gothicknight) - Thursday, 24 May 2007, 18:23 GMT

I think i've got the problem solved, there's a need to add to /etc/hosts.allow this line:

mysqld : ALL : ACCEPT

The package should add this line in the file, to prevent further bug reports and forum posts.


Comment by Pierre Schmitz (Pierre) - Thursday, 24 May 2007, 18:51 GMT
Ah ok, I forgot to mention that. And no a package should not open any ports by default. ;-) But perhaps a install message would be nice.
Comment by João Rodrigues (gothicknight) - Thursday, 24 May 2007, 19:35 GMT
Yes, you're right, a message would be better. Lucky I've remembered that sshd also needs this.

Loading...