Default install for MySQL via some Linux package managers (I'm thinking of Debian in particular but not Fedora or Gentoo) will setup your MySQL server to use "Unix socket" style connections.
The "torque/database/mysql" template lists connection URLs based on on having a TCP listener for MySQL.
When we mix both MySQL and Torque "straight out of the box" on some distros, we see that kind of error. Maybe we're not handling that correctly on the Torque config side?
It's possible that the mysql prompt ("console") or "phpmyadmin" is configured to use Unix socket connections, in which case those work fine, but JDBC won't be able to connect. We've seen that.
When one does enable the TCP listener for MySQL, another customer support issue concerns the problem where MySQL re-maps user names using the domain name, e.g.
torque.defaults.connection.user = "foo"
... however, when attempting a JDBC connection, an improperly configured MySQL server may map that to:
torque.defaults.connection.user = "[EMAIL PROTECTED]"
... in which case the Torque access will fail.
At that point, MySQL config can be fixed, or the connection URL can be changed to something like:
jdbc:mysql://localhost:3306/myapp?user=foo&password=bar
Not sure how SuSE stacks up against Fedora, RedHat, Gentoo, or Debian, in regard to its default install of MySQL, if that's actually the issue you're seeing.
paco.
On 24 Aug 2004, at 08:49, Eberle Martin wrote:
Hi there,
i am operating an Turbine app with MySql3 Server and Torque.
Today i've tried to connect to an MySql4 Server with the same
application
on a different Linux Server (SuSE 9.1) which won't work.
The only response is an Error from the BasePeer.initTableSchema
telling me, that on the port 3306 there may no MySql Server running.
With phpmyadmin or console i am able to connect to the MySql Server just
fine.
What am i doing wrong?
Error java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER): Cannot connect to MySQL server on localhost:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.net.ConnectException)
Do i have to use another driver? Or what else? Arrrgl.
Sincerely --Martin--
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
