hiteksoftware.com Forum Index hiteksoftware.com
User discussion forum
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

connection to mysql database

 
Post new topic   Reply to topic    hiteksoftware.com Forum Index -> Other
View previous topic :: View next topic  
Author Message
melvin
Site Admin


Joined: 25 May 2006
Posts: 635
Location: Santa Barbara, california

PostPosted: Wed Nov 08, 2006 6:41 am    Post subject: connection to mysql database Reply with quote

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...


Last edited by melvin on Wed Nov 08, 2006 6:42 am; edited 1 time in total
Back to top
View user's profile Send private message Send e-mail
melvin
Site Admin


Joined: 25 May 2006
Posts: 635
Location: Santa Barbara, california

PostPosted: Wed Nov 08, 2006 6:42 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
melvin
Site Admin


Joined: 25 May 2006
Posts: 635
Location: Santa Barbara, california

PostPosted: Wed Nov 08, 2006 6:43 am    Post subject: Reply with quote

user response:

That worked... Thanks a lot for your prompt response and support
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    hiteksoftware.com Forum Index -> Other All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group