hiteksoftware.com

[melvin]

user question:

We have purchased Automize and using it to monitor web applications and other utilities. I'm having trouble connecting to the our mySQL database.

- got the connector driver (mm.mysql-2.0.14-you-must-unjar-me.jar) and
unzipped it as instructed under jre/lib/ext
- stopped the scheduler and restarted Automize
- for driver, I used: org.gjt.mm.mysql.Driver - for url I sused: jdbc:mysql://EASSQL2/kv (where EASSQL2 is the db
server, and kv is the instance)
- Ticked the Authenticaiton required and put the user name and password

When try to test the connection, I got the following error:
Communication failure during handshake. Is there a server running on EASSQL2:3306?

We do have a mySQL running on that server and on that exact same port.

Kindly advise...

[melvin]

1) normally, you should not have to unzip / unjar the driver. Just placing it in the ext folder should work.

2) You should also place another copy of the jar in the Automize7 folder.

2) mysql site provides a free java jdbc driver.

http://dev.mysql.com/downloads/connector/j/5.0.html

download and place the .zip driver in the ext folder as well as the
Automize7 folder.
driver = com.mysql.jdbc.Driver
url format = jdbc:mysql://localhost/test?user=monty&password=greatsqldb

[melvin]

user response:

That worked... Thanks a lot for your prompt response and support