Re: Very Straneg problem with MySQL-Connector

[Parsons Technical Services]

For networking localhost=127.0.0.1=monkinetwork
But when you attach to the database it sends the machine name in Linux and 
under MySQL localhost<>127.0.0.1<>monkinetwork and so you have to put in the 
location that is identified. When your app talks to MySQL, it tells MySQL it 
is calling from machine X, in your case the machine name is monkinetwork. 
Had you not named the machine it would have sent localhost if it was bound 
to the loopback address. And if that was not bound it would have sent the 
127.0.0.1. You may also want to watch that if you bind Tomcat to an IP it 
may send that IP to MySQL if the machine name is not available. When you go 
across the network it will also use the IP of the machine. The easy way to 
tell is from the error.

"Access denied for user 'root'@'monkinetwork' (using password: YES)"
You were running Tomcat as root and the machine name is monkinetwork.
Hope this helps.
Doug
----- Original Message ----- 
From: "monkiboy" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Sent: Thursday, February 24, 2005 5:04 PM
Subject: Re: Very Straneg problem with MySQL-Connector


Thank you for trying to help me everybody !
I read carefully your answer and it look like I have problem with
privileges. My problem is resolved !
The first thing I did is :
Comment this line on "my.cnf" file : # bind 127.0.0.1
Then the second thing that I made (with your advice) : is to try to 
connect
on MySQL with User and not with the root.

GRANT ALL PRIVILEGES ON testdb.* to 'test'@'localhost' IDENTIFIED BY 
'test';
Doesn't work but when I did that :
GRANT ALL PRIVILEGES ON testBDD.* to 'test'@'monkinetwork' IDENTIFIED BY
'test';
It's worked.
It's look like I had to grant privilege on monkinetwork... It's very 
strange
and I can't understand, I don't know why I had to do that...

Best Regards.
monkiboy
OK, the problem normally does not come from the driver, just try this:
from your freshly installed MySQL database, remove the test database and
also the test user from the database permissions table and from any
global user definitions, then flush-privileges and you should be ready
to go.
Drew.
On Thu, 2005-02-24 at 03:01, monkiboy wrote:
> Hi everybody!
> I have a weird problem to use the MySQL-connector under Linux (Debian).
I heard it can come from Tomcat.
> I have no problem in windows XP, all is working fine !
> But under Linux when I try to connect to mysql throught mysql-connector
wrote in a Servlet I have this message :
>
> Message: Invalid authorization specification message from server:
"Access denied for user 'root'@'monkinetwork' (using password: YES)"
> SQLState: 28000
> ErrorCode: 1045
>
> I am Using : Tomcat 5.0.28
> MySQL-Connector version is : mysql-connector-java-3.0.15-ga-bin.jar
>
> JDK Version : 1_5_0_01. Servlet-Examples and JSP works fine! So I don't
think the problem come from JDK.
>
> MySQL version : MySQL-SERVER-4.1.9-2 : All is working under console 
> mode
!
>
> Here's My Servlet TESt1.java:
>
>
> Code:
>
>
> import java.io.*;
> import javax.servlet.*;
> import javax.servlet.http.*;
> import java.sql.*;
> import java.sql.DriverManager;
>
> public class TEST1 extends HttpServlet {
> public void doGet(HttpServletRequest request, HttpServletResponse
response)
> throws ServletException, IOException  {
>
>     response.setContentType("text/html");
>     PrintWriter out = response.getWriter();
>
>    String url = "jdbc:mysql://localhost:3306/HeroDB";
>    String user = "root";
>    String password = "password";
>
> try{
>     Class.forName("com.mysql.jdbc.Driver");
>     out.println("<br> DRIVERS JDBC : OK!");
>     Connection connection =
DriverManager.getConnection(url,user,password);
>
>     out.println("<br> Database connection : OK!");
>
>     }
> catch (ClassNotFoundException e)
>       {
>          out.println("Error with JDBC Drivers !");
>       }
> catch(SQLException ex) {
>
>
>         out.println("<br> ERROR MESSAGE <br>");
>    while (ex != null) {
>
>                 out.println("<br>Message: " + ex.getMessage ());
>
>                 out.println("<br>SQLState: "  + ex.getSQLState ());
>
>                 out.println("<br>ErrorCode: "  + ex.getErrorCode ());
>
>                 ex = ex.getNextException();
>       out.println("");
>    }
> }
>
>
> }
> }
>
>
>
> AND THE HTML PAGE in order to access to the Servlet :
>
> Code:
>
> <HTML>
> <HEAD>
> <TITLE>DataBase Test</TITLE>
> </HEAD>
> <BODY BGCOLOR="#FDF5E6">
> <H2 ALIGN="CENTER">DataBase TEST</H2>
>
> <FORM ACTION="http://localhost:8080/TEST1";>
> <CENTER>
> <INPUT TYPE="SUBMIT" VALUE = "CONNEXION TEST">
> </CENTER>
> </FORM>
>
> </BODY>
> </HTML>
>
> Theses codes works very well under windows, but under linux system here
what I've got :
>
> DRIVERS JDBC : OK!
> ERROR MESSAGE
> Message: Invalid authorization specification message from server:
"Access denied for user 'root'@'monkinetwork' (using password: YES)"
> SQLState: 28000
> ErrorCode: 1045
>
> Well, the web.xml file is well configured.
>
> Anyway : I already tried with class: org.gjt.mm.mysql.driver, but I 
> have
the same message error !
>
> By the way, it's very strange that I can play with MySQL under the
terminal but not throught tomcat.
> Any suggestions please , because it's giving me a very hard time ! ?
> Thank you !
> ++
> monkiboy
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]