tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Cavan Morris" <cavan.mor...@worldnet.att.net>
Subject Re: can't access to MySQLfrom java on Linux RedHat 7
Date Tue, 15 Jan 2002 18:02:35 GMT
The example of the JDBC realm for MySQL that comes with Tomcat is incorrect.  The correct method
is below.

<Realm
            className="org.apache.catalina.realm.JDBCRealm"
            debug="99"
        driverName="org.gjt.mm.mysql.Driver"
        connectionURL="jdbc:mysql://host/db"
       connectionName="username" connectionPassword="password"
        userTable="userTable"
             userNameCol="userNameCol"
             userCredCol="userCredCol"
        userRoleTable="userRoleTable"
             roleNameCol="roleNameCol" />

Note that login name and password are separate parameters and are not included in the connectionURL.


----- Original Message ----- 
From: "amol" <achawathe@hotmail.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Sent: Tuesday, January 15, 2002 9:05 AM
Subject: Re: can't access to MySQLfrom java on Linux RedHat 7


> try the string without password it may work
> 
> ----- Original Message -----
> From: "Sajida Kalsoom" <sajida@advcomm.net>
> To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
> Sent: Tuesday, January 15, 2002 3:00 PM
> Subject: Re: can't access to MySQLfrom java on Linux RedHat 7
> 
> 
> > have you  tried using IPAddress instead of localhost in connection string
> ??
> > and remember to add this IPAddress of your linux box in mysql privileges
> > table .
> > ----- Original Message -----
> > From: "Galbayar" <galbayar@mobicom.mn>
> > To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
> > Sent: Tuesday, January 15, 2002 2:22 PM
> > Subject: Re: can't access to MySQLfrom java on Linux RedHat 7
> >
> >
> > > My Connection is
> > >
> >
> mysql=DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql?user=ro
> > > ot&password=password");
> > >  and correctly running on Win2000 but can't working on Linux
> > >
> > > ----- Original Message -----
> > > From: "Sajida Kalsoom" <sajida@advcomm.net>
> > > To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
> > > Sent: Tuesday, January 15, 2002 17:17
> > > Subject: Re: can't access to MySQLfrom java on Linux RedHat 7
> > >
> > >
> > > > add the host name/ipaddress in mysql database named as mysql .
> > > > ----- Original Message -----
> > > > From: "Galbayar" <galbayar@mobicom.mn>
> > > > To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
> > > > Sent: Tuesday, January 15, 2002 2:12 PM
> > > > Subject: can't access to MySQLfrom java on Linux RedHat 7
> > > >
> > > >
> > > > Hello all?
> > > > I'm installed JDK,MySQL,Tomcat on Linux RedHat 7 and all services
> > running
> > > > ok. If i connect to the MySQL from java(use MySQL MM driver) have
> Server
> > > > configuration denied access error.
> > > > How to solve this problem?
> > > >
> > > >
> > > >
> > > > --
> > > > To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> > > > For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
> > > > Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>
> > > >
> > > >
> > >
> > >
> > > --
> > > To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> > > For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
> > > Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>
> > >
> >
> >
> > --
> > To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> > For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
> > Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>
> >
> >
> 
> --
> To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
> Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>
> 
> 


--
To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>


Mime
View raw message