You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by peri <er...@hotmail.com> on 2007/04/19 22:05:02 UTC
I get this error message while starting tomcat
Hi,
I'm a new user on tomcat. I'm using tomcat on my local machine for some
application. I use tomcat version 4.1 MySql version 4.1.22 as database and
eclipse 3.2 as ide. while I start tomcat on eclipse I got this error
messsage:
INFO: Initializing, config='ApplicationResources', returnNull=true
19-Apr-2007 23:00:16 org.apache.struts.action.ActionServlet
initModuleDataSources
SEVERE: Initializing application data source musiccollecton
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Access denied for user
'theDatabaseUserN'@'localhost' (using password: YES))
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at
org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:959)
at
org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:1087)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:879)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:767)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3483)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3709)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:776)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:759)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:537)
at
org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:260)
at org.apache.catalina.core.StandardHost.install(StandardHost.java:730)
at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:625)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:374)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:784)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:330)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1155)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:696)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1147)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:310)
at org.apache.catalina.core.StandardService.start(StandardService.java:449)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2212)
at org.apache.catalina.startup.Catalina.start(Catalina.java:458)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:345)
at org.apache.catalina.startup.Catalina.process(Catalina.java:129)
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:585)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:150)
Caused by: java.sql.SQLException: Access denied for user
'theDatabaseUserN'@'localhost' (using password: YES)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3700)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1203)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2572)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
... 32 more
Could anyone help me to solve this exception. Before installing MySQL I
didn't get this error messge.
Thank you very much
Perihan
--
View this message in context: http://www.nabble.com/I-get-this-error-message-while-starting-tomcat-tf3609467.html#a10085885
Sent from the Tomcat - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: I get this error message while starting tomcat
Posted by Orlando Reis <re...@gmail.com>.
And don't forget to use the -h flag to specify the host you are connecting
to on mysql command line.
That might be different, having a FQDN or localhost.
Try logging on your mysql database and very the mysql.user and mysql.dbtables.
Orlando
On 4/20/07, David Smith <dn...@cornell.edu> wrote:
>
> Seems pretty straight forward -- the user/host/password combo you
> provided isn't valid on your mysql server. Keep in mind mysql doesn't
> just check username and password, it also checks where you are logging
> in from (the host). You can test the login credentials by using the
> mysql command line client from a command shell on your system.
>
> --David
>
> peri wrote:
> > Hi,
> > I'm a new user on tomcat. I'm using tomcat on my local machine for some
> > application. I use tomcat version 4.1 MySql version 4.1.22 as database
> and
> > eclipse 3.2 as ide. while I start tomcat on eclipse I got this error
> > messsage:
> > INFO: Initializing, config='ApplicationResources', returnNull=true
> > 19-Apr-2007 23:00:16 org.apache.struts.action.ActionServlet
> > initModuleDataSources
> > SEVERE: Initializing application data source musiccollecton
> > org.apache.commons.dbcp.SQLNestedException: Cannot create
> > PoolableConnectionFactory (Access denied for user
> > 'theDatabaseUserN'@'localhost' (using password: YES))
> > at
> > org.apache.commons.dbcp.BasicDataSource.createDataSource(
> BasicDataSource.java:1225)
> > at
> > org.apache.commons.dbcp.BasicDataSource.setLogWriter(
> BasicDataSource.java:959)
> > at
> > org.apache.struts.action.ActionServlet.initModuleDataSources(
> ActionServlet.java:1087)
> > at org.apache.struts.action.ActionServlet.init(ActionServlet.java
> :472)
> > at javax.servlet.GenericServlet.init(GenericServlet.java:212)
> > at
> > org.apache.catalina.core.StandardWrapper.loadServlet(
> StandardWrapper.java:879)
> > at org.apache.catalina.core.StandardWrapper.load(
> StandardWrapper.java:767)
> > at
> > org.apache.catalina.core.StandardContext.loadOnStartup(
> StandardContext.java:3483)
> > at
> > org.apache.catalina.core.StandardContext.start(StandardContext.java
> :3709)
> > at
> > org.apache.catalina.core.ContainerBase.addChildInternal(
> ContainerBase.java:776)
> > at org.apache.catalina.core.ContainerBase.addChild(
> ContainerBase.java:759)
> > at org.apache.catalina.core.StandardHost.addChild(
> StandardHost.java:537)
> > at
> > org.apache.catalina.core.StandardHostDeployer.install(
> StandardHostDeployer.java:260)
> > at org.apache.catalina.core.StandardHost.install(StandardHost.java
> :730)
> > at
> > org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java
> :625)
> > at org.apache.catalina.startup.HostConfig.deployApps(
> HostConfig.java:374)
> > at org.apache.catalina.startup.HostConfig.start(HostConfig.java
> :784)
> > at
> > org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
> :330)
> > at
> > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> LifecycleSupport.java:119)
> > at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> :1155)
> > at org.apache.catalina.core.StandardHost.start(StandardHost.java
> :696)
> > at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> :1147)
> > at org.apache.catalina.core.StandardEngine.start(
> StandardEngine.java:310)
> > at org.apache.catalina.core.StandardService.start(
> StandardService.java:449)
> > at org.apache.catalina.core.StandardServer.start(
> StandardServer.java:2212)
> > at org.apache.catalina.startup.Catalina.start(Catalina.java:458)
> > at org.apache.catalina.startup.Catalina.execute(Catalina.java:345)
> > at org.apache.catalina.startup.Catalina.process(Catalina.java:129)
> > 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:585)
> > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:150)
> > Caused by: java.sql.SQLException: Access denied for user
> > 'theDatabaseUserN'@'localhost' (using password: YES)
> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798)
> > at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3700)
> > at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1203)
> > at com.mysql.jdbc.Connection.createNewIO(Connection.java:2572)
> > at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
> > at
> > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
> :266)
> > at
> > org.apache.commons.dbcp.DriverConnectionFactory.createConnection(
> DriverConnectionFactory.java:38)
> > at
> > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(
> PoolableConnectionFactory.java:294)
> > at
> > org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(
> BasicDataSource.java:1247)
> > at
> > org.apache.commons.dbcp.BasicDataSource.createDataSource(
> BasicDataSource.java:1221)
> > ... 32 more
> > Could anyone help me to solve this exception. Before installing MySQL I
> > didn't get this error messge.
> > Thank you very much
> > Perihan
> >
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
Re: I get this error message while starting tomcat
Posted by David Smith <dn...@cornell.edu>.
Seems pretty straight forward -- the user/host/password combo you
provided isn't valid on your mysql server. Keep in mind mysql doesn't
just check username and password, it also checks where you are logging
in from (the host). You can test the login credentials by using the
mysql command line client from a command shell on your system.
--David
peri wrote:
> Hi,
> I'm a new user on tomcat. I'm using tomcat on my local machine for some
> application. I use tomcat version 4.1 MySql version 4.1.22 as database and
> eclipse 3.2 as ide. while I start tomcat on eclipse I got this error
> messsage:
> INFO: Initializing, config='ApplicationResources', returnNull=true
> 19-Apr-2007 23:00:16 org.apache.struts.action.ActionServlet
> initModuleDataSources
> SEVERE: Initializing application data source musiccollecton
> org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (Access denied for user
> 'theDatabaseUserN'@'localhost' (using password: YES))
> at
> org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
> at
> org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:959)
> at
> org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:1087)
> at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472)
> at javax.servlet.GenericServlet.init(GenericServlet.java:212)
> at
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:879)
> at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:767)
> at
> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3483)
> at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:3709)
> at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:776)
> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:759)
> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:537)
> at
> org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:260)
> at org.apache.catalina.core.StandardHost.install(StandardHost.java:730)
> at
> org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:625)
> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:374)
> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:784)
> at
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:330)
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1155)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:696)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1147)
> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:310)
> at org.apache.catalina.core.StandardService.start(StandardService.java:449)
> at org.apache.catalina.core.StandardServer.start(StandardServer.java:2212)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:458)
> at org.apache.catalina.startup.Catalina.execute(Catalina.java:345)
> at org.apache.catalina.startup.Catalina.process(Catalina.java:129)
> 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:585)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:150)
> Caused by: java.sql.SQLException: Access denied for user
> 'theDatabaseUserN'@'localhost' (using password: YES)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798)
> at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3700)
> at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1203)
> at com.mysql.jdbc.Connection.createNewIO(Connection.java:2572)
> at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
> at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
> at
> org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
> at
> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
> at
> org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
> at
> org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
> ... 32 more
> Could anyone help me to solve this exception. Before installing MySQL I
> didn't get this error messge.
> Thank you very much
> Perihan
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: I get this error message while starting tomcat
Posted by Rashmi Rubdi <ra...@gmail.com>.
Hi Perihan,
On 4/19/07, peri <er...@hotmail.com> wrote:
>
> Hi,
> I'm a new user on tomcat. I'm using tomcat on my local machine for some
> application. I use tomcat version 4.1 MySql version 4.1.22 as database and
> eclipse 3.2 as ide. while I start tomcat on eclipse I got this error
> messsage:
> INFO: Initializing, config='ApplicationResources', returnNull=true
> 19-Apr-2007 23:00:16 org.apache.struts.action.ActionServlet
> initModuleDataSources
The overall error indicates that the application is configured to use
connection pooling.
This document http://tomcat.apache.org/tomcat-4.1-doc/jndi-datasource-examples-howto.html
will help you understand the various connection pooling related
parameters for your version of Tomcat.
> SEVERE: Initializing application data source musiccollecton
> org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (Access denied for user
> 'theDatabaseUserN'@'localhost' (using password: YES))
According to the above error, it appears that the JDBC connection
string is incorrect.
Use Google and find out the correct syntax for JDBC connection string
for your version of MySQL and check to see if the user name and
password are correct.
Also, try to connect to the database independent of Connection
Pooling, that is with DriverManager and see if you get a connection,
that will help you in verifying the connection string is correct.
> Could anyone help me to solve this exception. Before installing MySQL I
> didn't get this error messge.
> Thank you very much
> Perihan
-Rashmi
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org