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)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3996)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2142)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:781)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)
at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:703)
at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:775)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1037)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at
org.apache.catalina.core.StandardService.start(StandardService.java:516)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
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:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
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:597)
at
org.apache.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:177)
INFO main org.apache.catalina.core.StandardContext - The listener
"com.sun.faces.config.ConfigureListener" is already configured for this
context. The duplicate definition has been ignored.
INFO main org.apache.catalina.core.StandardContext - The listener
"com.sun.faces.config.ConfigureListener" is already configured for this
context. The duplicate definition has been ignored.
INFO main org.apache.catalina.startup.Catalina - Server startup in 1842 ms
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful:
create table jarbartest.user_roles (user_name varchar not null, role_name
varchar not null, primary key (user_name, role_name))
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate - You have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'not null, role_name varchar
not null, primary key (user_name, role_name))' at line 1
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful:
create table jarbartest.usercomments (commentID int unsigned not null,
commentMade varchar not null, dateMade datetime not null, flagged bit not
null, page_id varchar not null, made_by varchar(20) not null, primary key
(commentID))
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate - You have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'not null, dateMade datetime
not null, flagged bit not null, page_id varchar not ' at line 1
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful:
create table jarbartest.users (user_name varchar not null, first_name
varchar not null, last_name varchar not null, user_email varchar not null,
ip_address varchar not null, user_pass varchar not null, primary key
(user_name))
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate - You have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'not null, first_name
varchar not null, last_name varchar not null, user_email va' at line 1
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful:
alter table jarbartest.usercomments add index FKAA77CEBF792FED2F (made_by),
add constraint FKAA77CEBF792FED2F foreign key (made_by) references
jarbartest.users (user_name)
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'
ERROR TP-Processor2
org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org].[/].[Faces
Servlet] - Servlet.service() for servlet Faces Servlet threw exception
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command
denied to user 'yucca123_hiber'@'localhost' for table 'usercomments'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at
org.bar.jar.backing.tutorialIndexBacking.getAllUnflaggedComments(tutorialIndexBacking.java:22)
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:597)
at javax.el.BeanELResolver.getValue(BeanELResolver.java:62)
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:54)
at
com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:72)
at org.apache.el.parser.AstValue.getValue(AstValue.java:118)
at
org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
at
org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:101)
at javax.faces.component.UIData.getValue(UIData.java:614)
at javax.faces.component.UIData.getDataModel(UIData.java:1145)
at javax.faces.component.UIData.setRowIndex(UIData.java:451)
at
com.sun.faces.renderkit.html_basic.TableRenderer.encodeBegin(TableRenderer.java:77)
at
javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:813)
at javax.faces.component.UIData.encodeBegin(UIData.java:983)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:928)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:933)
at
com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:266)
at
com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:197)
at
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
ERROR TP-Processor2
org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org].[/].[jsp]
- Servlet.service() for servlet jsp threw exception
java.lang.RuntimeException: Cannot find FacesContext
at
javax.faces.webapp.UIComponentClassicTagBase.getFacesContext(UIComponentClassicTagBase.java:1855)
at
javax.faces.webapp.UIComponentClassicTagBase.setJspId(UIComponentClassicTagBase.java:1672)
at org.apache.jsp.oops_jsp._jspx_meth_f_005fview_005f0(oops_jsp.java:93)
at org.apache.jsp.oops_jsp._jspService(oops_jsp.java:67)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:438)
at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:416)
at
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:271)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
ERROR TP-Processor2
org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org] -
Exception Processing ErrorPage[exceptionType=java.lang.Throwable,
location=/oops.jsp]
org.apache.jasper.JasperException: java.lang.RuntimeException: Cannot find
FacesContext
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:418)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:438)
at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:416)
at
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:271)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.RuntimeException: Cannot find FacesContext
at
javax.faces.webapp.UIComponentClassicTagBase.getFacesContext(UIComponentClassicTagBase.java:1855)
at
javax.faces.webapp.UIComponentClassicTagBase.setJspId(UIComponentClassicTagBase.java:1672)
at org.apache.jsp.oops_jsp._jspx_meth_f_005fview_005f0(oops_jsp.java:93)
at org.apache.jsp.oops_jsp._jspService(oops_jsp.java:67)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
... 22 more
The way I read it is that my user has some privileges denied and I keep
tring to create a new user each time and get same exceptions!
Each time the new user is given all privileges.
--------------------------------------------------
From: "Yucca Nel" <yucca...@live.co.za>
Sent: Monday, May 24, 2010 9:19 PM
To: "Tomcat Users List" <users@tomcat.apache.org>
Subject: Re: stuck confused an need help please
here is copy of email sent from hosting provider ...
Dear Customer,
We see no permisson problems with your database:
#
mysql --database=yucca123_thejarbar --user=yucca123_hiber --password=myPass
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10872472
Server version: 5.0.90-community MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
mysql> select * from usercomments;
Empty set (0.00 sec)
Please doublecheck your application configuration and make sure that
you're using correct database login info. Also please note that Tomcat
restart is required after each configuration update.
Let us know if there any questions we can help you with, or confirm that
we may close this ticket.
Best regards,
DailyRazor TechSupport Team.
Ticket Details
===================
Ticket ID: IWI-526778
Department: Technical Support Dept.
Priority: High
Status: Waiting for confirmation
--------------------------------------------------
From: "Yucca Nel" <yucca...@live.co.za>
Sent: Monday, May 24, 2010 9:14 PM
To: "Tomcat Users List" <users@tomcat.apache.org>
Subject: Re: stuck confused an need help please
there is no cli for myswl using cpanel. Only php mysql admin and I know I
am using the credentials provided when I created the user in php admin
--------------------------------------------------
From: "Hassan Schroeder" <hassan.schroe...@gmail.com>
Sent: Monday, May 24, 2010 9:10 PM
To: "Tomcat Users List" <users@tomcat.apache.org>
Subject: Re: stuck confused an need help please
On Mon, May 24, 2010 at 12:00 PM, Yucca Nel <yucca...@live.co.za> wrote:
The credentials I am providing sre 100% correct
Not according to the log file you sent.
Are you saying that you have successfully logged in to MySQL from
the command line on the server using those credentials?
--
Hassan Schroeder ------------------------ hassan.schroe...@gmail.com
twitter: @hassan
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
