tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Parsons Technical Services" <parsonstechni...@earthlink.net>
Subject Re: Very Straneg problem with MySQL-Connector
Date Fri, 25 Feb 2005 00:20:45 GMT
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" <monkiboy@free.fr>
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: tomcat-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message