Venu (and others who may have suggestions)
No: the server is up and running.
Plus, I don't think I was clear enough on the kind of errors I get. Let me
try another way...
When I try to get a connection to a local, non-running, mySQL server, I get
a java.net.ConnectException. That I understand: it corresponds to the case
your mentionning in your response.
But here is the problem. When trying to get a connection to a remote, up and
running, mySQL server, I get a java.security.AccessControlException.
Obviously, this is not the same error as above. My problem is that: the
address is OK, the port is OK, the name of the database is OK, the userID is
OK, the password is OK, etc - and when I try to access to the database using
MySQL binaries, it all work OK. The odd thing is that I got exactly the same
message, even when I don't provide a userID or a password.
I'm still confused... and waiting for additional suggestions.
Alexandre
-----Original Message-----
From: Venu A [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 7:22 PM
To: SIMONIN Alexandre
Subject: RE: *** HELP *** mySQL connectivity problems
As a small trial, is the server up and running at the time of connection ?
Becuase you get this error only when the server is not running in the
specified system with the specified port. Just try to connect to the server
using other MySQL binaries and check whether the server is runinng.
Coming to the error msg even after granting, yes as the application is not
finding the server at all, it issues the same error at the time of
connection itself.
Thank you
venu
> -----Original Message-----
> From: SIMONIN Alexandre [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 30, 2001 10:06 AM
> To: '[EMAIL PROTECTED]'
> Cc: '[EMAIL PROTECTED]'
> Subject: RE: *** HELP *** mySQL connectivity problems
>
>
> Thanks,
>
> But it doesn't help me finding out what the problem is (have a look at the
> code below: it basically does the same as your example).
>
> Let me just clarify: the application works all OK when mySQL runs on WinNT
> and when I access to my files locally. The problem comes up when
> porting my
> application to a Linux-based web server. The odd thing is that every
> parameters seems to be OK (hostname, port, userID, password, etc.).
>
> Another odd thing too is that I get a different exception (i.e.:
> java.net.ConnectException) when trying to access the server as if it were
> running on the same station as my java servlet (which is not the
> case): see
> item 8/ below. I think I understand the exception I get in the case
> describded in item 8/. I also understand why I get a different exception
> when contacting the proper server on the proper port
> (java.security.AccessControlException): so it seems that the code
> is going a
> little further. But it also seems that it is a mySQL server error. What I
> don't understand is why I get my connection refused when every parameters
> are OK (and actually: I get the very same error when trying to access a
> table wich doesn't exist, or a table which exists but for which I
> don't have
> the proper rights, or the table to which I want to have access to (which
> exists) but without providing the user or password).
>
> I'm still looking for ideas...
>
>
> -----Original Message-----
> From: Venu A [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 30, 2001 6:46 PM
> To: SIMONIN Alexandre; [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]; Mysql. Com Java@Lists.
> Subject: RE: *** HELP *** mySQL connectivity problems
>
>
> Check the following link, which has the simple MyJDBC sample to connect to
> MySQL server and to do some basic operations.
> http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:80228:200107:popcioh
> jmlbbolpak
> ege
>
> If you need any further assistance, please let us know.
> Thanks in advance
> venu
>
> > -----Original Message-----
> > From: SIMONIN Alexandre [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 30, 2001 9:33 AM
> > To: '[EMAIL PROTECTED]'
> > Cc: '[EMAIL PROTECTED]'
> > Subject: FW: *** HELP *** mySQL connectivity problems
> >
> >
> >
> >
> > > -----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
> >
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
