[Logo] smithproject.org
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
unable to validate mysql database connection  XML
Forum Index -> Database Access
Author Message
[Post New]15/02/2007 18:34:51
    Subject: unable to validate mysql database connection
[Up]
david



Joined: 09/02/2007 18:46:43
Messages: 4
Offline
installed mysql4 on debian and copied mysql-connector-java-5.0.4-bin.jar in smith/WEB-INF/lib, but still could not validate the connection successfully; while another jdbc driver installed on debian /usr/lib/ works fine with tomcat 5.5.

Any suggestion is appreciated.

dav
[Post New]15/02/2007 21:02:39
    Subject: Re:unable to validate mysql database connection
[Up]
Jonaus



Joined: 09/02/2007 16:51:08
Messages: 8
Location: England / NH
Offline
Have you double checked that the mysql user that you are using, has access to log onto the DB you are trying to connect to, from the host you are trying to connect from?

That's normally my problem with MySQL authentication, forgetting that it's host specific
[Post New]16/02/2007 18:51:36
    Subject: Re:unable to validate mysql database connection
[Up]
david



Joined: 09/02/2007 18:46:43
Messages: 4
Offline
Hi Jonaus,

You are right, it's the connection between linux machine and windows machine. I'am using Windows to do all the testing, while the Smith is running on linux machine. The solution: upgrade the tcp/ip package.

Thanks,

david
 
Forum Index -> Database Access
Go to:   
Powered by JForum 2.1.6 © JForum Team