You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by "Park, Sung-Gu" <je...@thinkfree.com> on 2001/04/21 13:02:53 UTC

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)

Re: A latest nigtly build error with MySQL

Posted by Arnaud Dostes - NTI <ad...@nti-sa.com>.
Transactions ARE NOT supported on mySQL.

On the latest versions, transaction-like actions can be performed, but you
got to use special workarounds. I recommend reading the doc on mysql.com on
transactions.

----- Original Message -----
From: "Noel E. Lecaros" <sp...@mozcom.com>
To: <to...@jakarta.apache.org>
Sent: Tuesday, April 24, 2001 2:56 PM
Subject: Re: A latest nigtly build error with MySQL


> I'm just speculating, but are transactions supported in the version of
MySQL
> you are using?
>
> "Park, Sung-Gu" wrote:
>
> > The error message is like :
> >
> > Starting service Tomcat-Standalone
> > Apache Tomcat/4.0-b4-dev
> > Catalina.start: LifecycleException:  Exception opening database
connection:
> > jav
> > a.sql.SQLException: Cannot disable AUTO_COMMIT
> > LifecycleException:  Exception opening database connection:
> > java.sql.SQLExcepti
> > on: Cannot disable AUTO_COMMIT
> >         at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:609)
> >         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:3
> > 53)
> >         at
> > org.apache.catalina.core.StandardServer.start(StandardServer.java:458
> > )
> >         at org.apache.catalina.startup.Catalina.start(Catalina.java:718)
> >         at
org.apache.catalina.startup.Catalina.execute(Catalina.java:640)
> >         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 disable AUTO_COMMIT
> >         at
org.gjt.mm.mysql.Connection.setAutoCommit(Connection.java:396)
> >         at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:540)
> >         at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:607)
> >         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:3
> > 53)
> >         at
> > org.apache.catalina.core.StandardServer.start(StandardServer.java:458
> > )
> >         at org.apache.catalina.startup.Catalina.start(Catalina.java:718)
> >         at
org.apache.catalina.startup.Catalina.execute(Catalina.java:640)
> >         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)

Re: A latest nigtly build error with MySQL

Posted by "Noel E. Lecaros" <sp...@mozcom.com>.
I'm just speculating, but are transactions supported in the version of MySQL
you are using?

"Park, Sung-Gu" wrote:

> The error message is like :
>
> Starting service Tomcat-Standalone
> Apache Tomcat/4.0-b4-dev
> Catalina.start: LifecycleException:  Exception opening database connection:
> jav
> a.sql.SQLException: Cannot disable AUTO_COMMIT
> LifecycleException:  Exception opening database connection:
> java.sql.SQLExcepti
> on: Cannot disable AUTO_COMMIT
>         at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:609)
>         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:3
> 53)
>         at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:458
> )
>         at org.apache.catalina.startup.Catalina.start(Catalina.java:718)
>         at org.apache.catalina.startup.Catalina.execute(Catalina.java:640)
>         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 disable AUTO_COMMIT
>         at org.gjt.mm.mysql.Connection.setAutoCommit(Connection.java:396)
>         at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:540)
>         at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:607)
>         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:3
> 53)
>         at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:458
> )
>         at org.apache.catalina.startup.Catalina.start(Catalina.java:718)
>         at org.apache.catalina.startup.Catalina.execute(Catalina.java:640)
>         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)

A latest nigtly build error with MySQL

Posted by "Park, Sung-Gu" <je...@thinkfree.com>.
The error message is like :

Starting service Tomcat-Standalone
Apache Tomcat/4.0-b4-dev
Catalina.start: LifecycleException:  Exception opening database connection:
jav
a.sql.SQLException: Cannot disable AUTO_COMMIT
LifecycleException:  Exception opening database connection:
java.sql.SQLExcepti
on: Cannot disable AUTO_COMMIT
        at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:609)
        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:3
53)
        at
org.apache.catalina.core.StandardServer.start(StandardServer.java:458
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:718)
        at org.apache.catalina.startup.Catalina.execute(Catalina.java:640)
        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 disable AUTO_COMMIT
        at org.gjt.mm.mysql.Connection.setAutoCommit(Connection.java:396)
        at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:540)
        at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:607)
        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:3
53)
        at
org.apache.catalina.core.StandardServer.start(StandardServer.java:458
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:718)
        at org.apache.catalina.startup.Catalina.execute(Catalina.java:640)
        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)

Re: an installation error with mySQL

Posted by "Park, Sung-Gu" <je...@thinkfree.com>.
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" <je...@thinkfree.com>
To: <to...@jakarta.apache.org>
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)
>
>