I think I solved this problem to replace the Realm part of server.xml like
this.
connectionURL="jdbc:mysql://localhost/authority"
connectionName="test"
connectionPassword="test"
Not using this style like...
connectionURL="jdbc:mysql://localhost/authority?user=test;password=test"
============================================================================
=
Question)
What case is it, when i see this message?
"HTTP Status 503 - This application is not currently available
The requested service (This application is not currently available) is not
currently available. "
What do I do for it? Why is this happened?
Thanks in advance,
Sung-Gu
----- Original Message -----
From: "Park, Sung-Gu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 21, 2001 8:02 PM
Subject: an installation error with mySQL
> I made my authority database on mySQL for tomcat 4.0-b4 dev.
> And the user and user_pass field in the users table and
> user_roles in the user_roles table are made.
> There is no @localhost user though,
> I got an error probably related to catalina.policy or
> the problem with database like the below?
>
> What do I solve for it?
>
> Thanks in advance,
>
> Sung-Gu
>
>
> P.S.: the error message is like :
>
> Starting service Tomcat-Standalone
> Apache Tomcat/4.0-b4-dev
> Catalina.start: LifecycleException: Exception opening database
connection:
> java
> .sql.SQLException: Cannot load connection class 'java.sql.SQLException:
> General e
> rror: Access denied for user: '@localhost' to database 'authority''.
> LifecycleException: Exception opening database connection:
> java.sql.SQLExceptio
> n: Cannot load connection class 'java.sql.SQLException: General error:
> Access den
> ied for user: '@localhost' to database 'authority''.
> at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:561)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1044)
> at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:253)
>
> at
> org.apache.catalina.core.StandardService.start(StandardService.java:35
> 3)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:458)
>
> at org.apache.catalina.startup.Catalina.start(Catalina.java:712)
> at org.apache.catalina.startup.Catalina.execute(Catalina.java:634)
> at org.apache.catalina.startup.Catalina.process(Catalina.java:177)
> at java.lang.reflect.Method.invoke(Native Method)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:179)
> ----- Root Cause -----
> java.sql.SQLException: Cannot load connection class
'java.sql.SQLException:
> Gener
> al error: Access denied for user: '@localhost' to database 'authority''.
> at org.gjt.mm.mysql.Driver.connect(Driver.java)
> at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:506)
> at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:559)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1044)
> at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:253)
>
> at
> org.apache.catalina.core.StandardService.start(StandardService.java:35
> 3)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:458)
>
> at org.apache.catalina.startup.Catalina.start(Catalina.java:712)
> at org.apache.catalina.startup.Catalina.execute(Catalina.java:634)
> at org.apache.catalina.startup.Catalina.process(Catalina.java:177)
> at java.lang.reflect.Method.invoke(Native Method)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:179)
>
>
