Hello and thank you, one user (yucca123_tom) for container managed security for tomcat and another for my application using hibernate (yucca123_hiber) I keep making sure that I provide ALL privileges and correct credentials in metedata but see same results?

I know what the exception is saying but I can only swear that I am providing correct credentials.

--------------------------------------------------
From: "Bob Hall" <rfha...@yahoo.com>
Sent: Tuesday, May 25, 2010 9:15 AM
To: "Tomcat Users List" <users@tomcat.apache.org>
Subject: Re: stuck confused an need help please



--- On Mon, 5/24/10 at 11:52 PM, Yucca Nel <yucca...@live.co.za> wrote:

Could someone please help me understand what thia stack
trace is saying?

catalina.log
File Type: ASCII English text, with very long lines

INFO main org.apache.catalina.startup.Catalina -
Initialization processed in 875 ms
INFO main org.apache.catalina.core.StandardService -
Starting service Catalina
INFO main org.apache.catalina.core.StandardEngine -
Starting Servlet Engine: Apache Tomcat/6.0.20
ERROR main
org.apache.catalina.core.ContainerBase.[Catalina] -
Exception opening database connection
java.sql.SQLException: Access denied for user ' yucca123_tom'@'localhost' (using password: YES)

There is leading white space in the user name: ' yucca123_tom'.

There are also errors in your DDL SQL that will need to be fixed after
your app is able to connect to the DB.

ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate
- ALTER command denied to user 'yucca123_hiber'@'localhost'
for table 'usercomments'
ERROR TP-Processor2
org.hibernate.util.JDBCExceptionReporter - SELECT command
denied to user 'yucca123_hiber'@'localhost' for table
'usercomments'

Don't know why there are two DB users in play:
 yucca123_tom and yucca123_hiber

Apparently, the latter was able to connect to MySQL  but could not
access a table.  Are you sure the table exists?  Did you grant select
on the table to yucca123_hiber?

- Bob




---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Reply via email to