tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John M. Hollingsworth <jmh_tom...@cox.net>
Subject Auth errors
Date Thu, 01 Jan 1970 00:00:00 GMT
Hello.  I'm using Tomcat 4.0.3 against a MySQL MyISAM database for authentication.  Suddenly,
I'm getting back "Access denied for user", but the user is valid, as is the table.

Here's a snippet of my server.xml


      <!-- Because this Realm is here, an instance will be shared globally -->

      <!-- <Realm className="org.apache.catalina.realm.MemoryRealm" /> -->

      <!-- Replace the above Realm with one of the following to get a Realm
           stored in a database and accessed via JDBC -->


      <Realm  className="org.apache.catalina.realm.JDBCRealm" debug="99"
             driverName="org.gjt.mm.mysql.Driver"
          connectionURL="jdbc:mysql://localhost/tomcatusers?user=zoidburg;password=alien"
              userTable="authusers" userNameCol="user_name" userCredCol="user_pass"
          userRoleTable="authroles" roleNameCol="user_role" />

I have tried re-adding the user to my table, and I have tried dropping the table and building
a new one.  Nothing seems to be working.

Here is the copy of the stout.log:
Create Catalina server
Starting service Tomcat-Standalone
Apache Tomcat/4.0.3
Catalina.start: LifecycleException:  Exception opening database connection:  java.sql.SQLException:
Invalid authorization specification: Access denied for user: 'jmhollin;password@localhost'
(Using password: NO)
LifecycleException:  Exception opening database connection:  java.sql.SQLException: Invalid
authorization specification: Access denied for user: 'zoidburg;password@localhost' (Using
password: NO)
	at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343)
	at org.apache.catalina.core.StandardService.start(StandardService.java:388)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:506)
	at org.apache.catalina.startup.CatalinaService.start(CatalinaService.java:261)
	at org.apache.catalina.startup.CatalinaService.execute(CatalinaService.java:172)
	at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.catalina.startup.BootstrapService.main(BootstrapService.java:428)
----- Root Cause -----
java.sql.SQLException: Invalid authorization specification: Access denied for user: 'zoidburg;password@localhost'
(Using password: NO)
	at org.gjt.mm.mysql.MysqlIO.init(Unknown Source)
	at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
	at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown Source)
	at org.gjt.mm.mysql.Driver.connect(Unknown Source)
	at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:548)
	at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343)
	at org.apache.catalina.core.StandardService.start(StandardService.java:388)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:506)
	at org.apache.catalina.startup.CatalinaService.start(CatalinaService.java:261)
	at org.apache.catalina.startup.CatalinaService.execute(CatalinaService.java:172)
	at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.catalina.startup.BootstrapService.main(BootstrapService.java:428)


--
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