> -----Original Message-----
> From: SIMONIN Alexandre
> Sent: Monday, July 30, 2001 2:41 PM
> To: '[EMAIL PROTECTED]'
> Subject: *** HELP *** mySQL connectivity problems
>
> Hi,
>
> I'm running mySQL 2.0.4 and Tomcat 4.0 on Cobalt/Linux. I'm using mm 2.0.4
>
>
> When trying to get a connection to the database, I got the following error
> (the code is provided below - exact id and password replaced for
> confidentiality).
>
> >>> Step 1 : Class.forName("org.gjt.mm.mysql.Driver"); OK
> >>> Step 2 :
> getConnection("jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?
> >>> user=myID&password=myPwd"); ***
> FAILURE ***
> >>>
> >>> SQLException: Cannot connect to MySQL server on
> sherweb7.sherweb.com:3306.
> >>> Is there a MySQL server running on the machine/port you are
> trying to connect to?
> >>> (java.security.AccessControlException)
> >>> SQLState: 08S01
> >>> VendorError: 0
>
> Few comments:
> 1/ the mySQL server's site address is OK (not the localhost)
> 2/ the mySQL server's port is OK
> 3/ the table name is OK
> 4/ the userID is OK
> 5/ the password is OK
> 6/ the connection looks fine through phpMyAdmin
> 7/ I get the same java.security.AccessControlException when doing the same
> request without the userID and password
> 8/ I got a java.net.ConnectException (which seems normal to me) when
> trying to call the server as if it was local to my machine, i.e.:
> jdbc:mysql:///myDatabase?user=myID&password=myPwd
> 9/ granting my id with all the privileges in mySQL doesn't do any good: I
> can view all the tables through phpMyAdmin, but still cannot get a
> connection.
>
> Any suggestion?
>
> The code:
>
> try {
> Class.forName("org.gjt.mm.mysql.Driver"); // this or <the
> same>.newInstance() does the same
> System.out.println("Step1:
> Class.forName(\"org.gjt.mm.mysql.Driver\"): OK");
> }
> catch (Exception e) {
> System.out.println("Class.forName(\"org.gjt.mm.mysql.Driver\"): ***
> FAILURE ***");
> }
>
> Connection myConn = null;
>
> try {
> myConn =
> DriverManager.getConnection("jdbc:mysql://sherweb7.sherweb.com:3306/myData
> base?user=myID&password=myPwd");
> System.out.println("Step 2:
> getConnection(\"jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myI
> D&password=myPwd\"): OK");
> }
> catch (SQLException e) {
> System.out.println("Step 2:
> getConnection(\"jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myI
> D&password=myPwd\"): *** FAILURE ***");
> System.out.println(" SQLException: "+e.getMessage());
> System.out.println(" SQLState: "+e.getSQLState());
> System.out.println(" VendorError: "+e.getErrorCode());
> }
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
