Re: [cobalt-users] Problem with Java and MySQL

["E.B. Dreger" <eddy+public+spam@xxxxxxxxxxxxxxxxx>]

> Date: Wed, 30 Jan 2002 19:17:07 +0100
> From: CMO - Thorsten Mitschele <mitschele@xxxxxx>

(snipping throughout)

> If we try to connect to the mysql-database locally it works...

Locally, meaning from the database server?  Or from the Tomcat
server?

> if we try it via the servlet it fails:
> 
> java.sql.SQLException: Cannot connect to MySQL server on
> mysql.dettingen.cmo.de:3306. Is there a MySQL server running on the
> machine/port you are trying to connect to?
> (java.security.AccessControlException)
> 	at org.gjt.mm.mysql.Connection.(Connection.java:239)
> 	at org.gjt.mm.mysql.Driver.connect(Driver.java:126)
> 	at java.sql.DriverManager.getConnection(DriverManager.java:517)
> 	at java.sql.DriverManager.getConnection(DriverManager.java:177)
> 
> 
> is there any security thing we must configure in Tomcat to
> allow access? The DB-Server is a own machine, not localhost.

The first two things that I'd check are:

1. Permissions in MySQL

2. Make sure that the MySQL client library on the Tomcat machine
   matches the version of MySQL on your server.

> Any hints, suggestions and help will be nice

Please check the above two things...

> Mit freundlichen Grüßen,
> 
> Thorsten Norman Mitschele
> Geschäftsführer


Tschuess,
Eddy

Brotsman & Dreger, Inc. - EverQuick Internet Division
Phone: +1 (316) 794-8922 Wichita/(Inter)national
Phone: +1 (785) 865-5885 Lawrence
--

Date: Mon, 21 May 2001 11:23:58 +0000 (GMT)
From: A Trap <blacklist@xxxxxxxxx>
To: blacklist@xxxxxxxxx
Subject: Please ignore this portion of my mail signature.

These last few lines are a trap for address-harvesting spambots.  Do NOT
send mail to <blacklist@xxxxxxxxx>, or you are likely to be blocked.