Re: stuck confused an need help please
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yucca Nel, On 5/24/2010 2:37 PM, Yucca Nel wrote: java.sql.SQLException: Access denied for user ' yucca123_tom'@'localhost' (using password: YES) It looks like you have a leading space before your username. How are you configuring your JDBC connection? Go check to make sure you don't have an embedded space before the name, unless that's what you intended to do. - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkv9kZ0ACgkQ9CaO5/Lv0PA5YwCgrVHS60uDTp+Tg4KHDgcPMOVB AYoAnitqzyIv4rnPYvXYWysOTERSKgQv =ekxc -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: stuck confused an need help please
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yucca Nel, On 5/24/2010 3:28 PM, Yucca Nel wrote: aplogies there are 2 users and both credentials are configured correct one for hibernate and one for tomcat Doesn't Tomcat use Hibernate? Or the other way around? Why not configure Hibernate to use Tomcat's connection pool? what I maen is that my dailyraor username is eg. and everything in mysql gets prepended with xxx like xxx_mydatabase xxx_myusername That's perfectly reasonable, especially if you're on a shared system. xxx_mytable Now that /is/ stupid: your table names shouldn't have to have your username prepended to them. This would seem to be the kind of thing you should have control over. - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkv9kqYACgkQ9CaO5/Lv0PCFxACaAvaeYXnQY+vrcfatH5rDnE/6 OkoAn1s79kcpT+hAmUcx0abcuPuffsKx =0sY0 -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: stuck confused an need help please
From: Christopher Schultz [mailto:ch...@christopherschultz.net] Subject: Re: stuck confused an need help please On 5/24/2010 2:37 PM, Yucca Nel wrote: java.sql.SQLException: Access denied for user ' yucca123_tom'@'localhost' (using password: YES) It looks like you have a leading space before your username. As the OP has been told numerous times. Testing indicated leading spaces were trimmed in some circumstances, but likely not all. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers.
Re: stuck confused an need help please
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chuck, On 5/26/2010 5:36 PM, Caldarale, Charles R wrote: From: Christopher Schultz [mailto:ch...@christopherschultz.net] Subject: Re: stuck confused an need help please On 5/24/2010 2:37 PM, Yucca Nel wrote: java.sql.SQLException: Access denied for user ' yucca123_tom'@'localhost' (using password: YES) It looks like you have a leading space before your username. As the OP has been told numerous times. FWIW, he doesn't seem to be listening. Testing indicated leading spaces were trimmed in some circumstances, but likely not all. - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkv9lfwACgkQ9CaO5/Lv0PCZIQCfVnk42vKvdIYHOuQDxzaA7rIx 5PIAmwabFkQEqlVgSmr31N6dpq8sYluX =p04z -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: stuck confused an need help please
From: Christopher Schultz [mailto:ch...@christopherschultz.net] Subject: Re: stuck confused an need help please FWIW, he doesn't seem to be listening. You noticed... - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers.
Re: stuck confused an need help please
: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
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
Re: stuck confused an need help please
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
Re: stuck confused an need help please
--- On Tue, 5/25/10 at 12:20 AM, Yucca Nel yucca...@live.co.za wrote: I know what the exception is saying but I can only swear that I am providing correct credentials. Did you notice: There is leading white space in the user name: ' yucca123_tom'. - Bob - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: stuck confused an need help please
OK - I have a huge message that I'm going to cut and paste into this one, rather than finding the original and editing it online. I'm going to edit in place and try to point out some issues. I'll ask some questions along the way. I am trying to tweak my web application at thejarbar.org to be bug free. Currrntly here is an issue whn clicking the tutorials button as you can view in your browser. I am getting some kind of exceptions as ell listed in the following stack trace and don't know how to osolve after days of trying. I have been getting mysql SELECT privilege denied exception even though user has all access to database. code deleted . . . although I recommend reworking in with try, catch, and finally blocks. Otherwise you WILL have connection leaks. As a first timer I would likw to know how a typical hibernate webapp is moved from development to production please have a look at the page if you have the time Use the same database names in both cases. Unfortunately, the URL will be different. One way is to parametrize your build to use different hibernate.cfg.xml files. You could also use Ant and appropriate build.properties files. Finally, you could spend some time with Maven. here is a log of all errors related to clicking that link 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) This looks like you cannot even connect. As others have pointed out, there is a space in front of the user name. I'm also a bit confused here. You say (further down or in another message), that you have the JDBC driver in your WEB-INF/lib folder, but this looks like you are using Tomcat's database pooling? If you're using Tomcat's database pooling, do not put the driver jars in WEB-INF/lib. If you're using Hibernate to control the connections, then don't put the driver jars in Tomcat's lib. See this link for a complete explanation of how to set everything up. http://wiki.apache.org/tomcat/TomcatHibernate The only way I was able to sort of reproduce your error was by changing the attribute resource=username in my context.xml file to resource= username. Adding a space to the username property in hibernate.cfg.xml caused no error. Fix your configuration files here. 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. Are you using the database login ID to create tables? This is a very dangerous practice. One slip concerning SQL injection and you'll have a completely destroyed database. 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)) Fix your HQL 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)) Fix your HQL 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)) Fix your HQL 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) This is assigned to a different database user. Are you using multiple
Re: stuck confused an need help please
hello and than you. I will spend next few hours fixing this. I need to fix hibernate catalog too as it is still trying to create tables in my test datatabase probably because catalogs are defined for test database in entity hbm.xml mappings? Do these mappings ususally go in the WEB-INF classes directory or can I put them with other metadata directly in WEB-INF? I am not too sure on the username being incorrect for my credentials defined in xml as I made sure to check for trailing and leading whitespace but will look again.I will also fix the error handle and path to error page Better get to work and many thanks ... :) From: Mark Eggers its_toas...@yahoo.com Sent: Tuesday, May 25, 2010 12:26 PM To: Tomcat Users List users@tomcat.apache.org Subject: Re: stuck confused an need help please OK - I have a huge message that I'm going to cut and paste into this one, rather than finding the original and editing it online. I'm going to edit in place and try to point out some issues. I'll ask some questions along the way. I am trying to tweak my web application at thejarbar.org to be bug free. Currrntly here is an issue whn clicking the tutorials button as you can view in your browser. I am getting some kind of exceptions as ell listed in the following stack trace and don't know how to osolve after days of trying. I have been getting mysql SELECT privilege denied exception even though user has all access to database. code deleted . . . although I recommend reworking in with try, catch, and finally blocks. Otherwise you WILL have connection leaks. As a first timer I would likw to know how a typical hibernate webapp is moved from development to production please have a look at the page if you have the time Use the same database names in both cases. Unfortunately, the URL will be different. One way is to parametrize your build to use different hibernate.cfg.xml files. You could also use Ant and appropriate build.properties files. Finally, you could spend some time with Maven. here is a log of all errors related to clicking that link 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) This looks like you cannot even connect. As others have pointed out, there is a space in front of the user name. I'm also a bit confused here. You say (further down or in another message), that you have the JDBC driver in your WEB-INF/lib folder, but this looks like you are using Tomcat's database pooling? If you're using Tomcat's database pooling, do not put the driver jars in WEB-INF/lib. If you're using Hibernate to control the connections, then don't put the driver jars in Tomcat's lib. See this link for a complete explanation of how to set everything up. http://wiki.apache.org/tomcat/TomcatHibernate The only way I was able to sort of reproduce your error was by changing the attribute resource=username in my context.xml file to resource= username. Adding a space to the username property in hibernate.cfg.xml caused no error. Fix your configuration files here. 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. Are you using the database login ID to create tables? This is a very dangerous practice. One slip concerning SQL injection and you'll have a completely destroyed database. 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)) Fix your HQL 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)) Fix your HQL 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
Re: stuck confused an need help please
They have to be on the classpath. The base configuration file ends up in WEB-INF/classes. I've always put my hbm.xml files alongside the classes they map. Make sure that there is only one copy of your JDBC driver in your classpath as well, and that it's in the right location. /mde/ --- On Tue, 5/25/10, Yucca Nel yucca...@live.co.za wrote: From: Yucca Nel yucca...@live.co.za hello and than you. I will spend next few hours fixing this. I need to fix hibernate catalog too as it is still trying to create tables in my test datatabase probably because catalogs are defined for test database in entity hbm.xml mappings? Do these mappings ususally go in the WEB-INF classes directory or can I put them with other metadata directly in WEB-INF? I am not too sure on the username being incorrect for my credentials defined in xml as I made sure to check for trailing and leading whitespace but will look again.I will also fix the error handle and path to error page - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: stuck confused an need help please
On Mon, May 24, 2010 at 11:37 AM, Yucca Nel yucca...@live.co.za wrote: I have been getting mysql SELECT privilege denied exception even though user has all access to database. There would seem to be a contradiction between the above statement and the first error in your log example :-) 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) I would try to fix that first, personally... -- 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
Re: stuck confused an need help please
yes but I don't know why access I being denied? The credentials I am providing sre 100% correct sn the database user has ALL privileges so could anyone perhaps think o a possible reason why I am getting these errors? I have confirmed with hosting provider that user exists and credentials are correct and they also appear to be lost. I am using correct myswl driver located in WEB-INF/lib -- From: Hassan Schroeder hassan.schroe...@gmail.com Sent: Monday, May 24, 2010 8:53 PM To: Tomcat Users List users@tomcat.apache.org Subject: Re: stuck confused an need help please On Mon, May 24, 2010 at 11:37 AM, Yucca Nel yucca...@live.co.za wrote: I have been getting mysql SELECT privilege denied exception even though user has all access to database. There would seem to be a contradiction between the above statement and the first error in your log example :-) 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) I would try to fix that first, personally... -- 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
Re: stuck confused an need help please
I forgot to mention I am using myswl 5, and tomcat 6 -- From: Yucca Nel yucca...@live.co.za Sent: Monday, May 24, 2010 9:00 PM To: Tomcat Users List users@tomcat.apache.org Subject: Re: stuck confused an need help please yes but I don't know why access I being denied? The credentials I am providing sre 100% correct sn the database user has ALL privileges so could anyone perhaps think o a possible reason why I am getting these errors? I have confirmed with hosting provider that user exists and credentials are correct and they also appear to be lost. I am using correct myswl driver located in WEB-INF/lib -- From: Hassan Schroeder hassan.schroe...@gmail.com Sent: Monday, May 24, 2010 8:53 PM To: Tomcat Users List users@tomcat.apache.org Subject: Re: stuck confused an need help please On Mon, May 24, 2010 at 11:37 AM, Yucca Nel yucca...@live.co.za wrote: I have been getting mysql SELECT privilege denied exception even though user has all access to database. There would seem to be a contradiction between the above statement and the first error in your log example :-) 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) I would try to fix that first, personally... -- 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
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
Re: stuck confused an need help please
Perhaps the real issue herw for mr personally (and I hope anyone using dailyrazor) could answer if it's normal to not be able to use mysql in a production environment where I DON't have to have my dailyrazor username prepended to everything related in mysql? Is this a norm in prodyction environments because I can not configure mysql to mimic my development environment because every name on the server has a stupid name prepended to it. -- From: Yucca Nel yucca...@live.co.za Sent: Monday, May 24, 2010 9:06 PM To: Tomcat Users List users@tomcat.apache.org Subject: Re: stuck confused an need help please I forgot to mention I am using myswl 5, and tomcat 6 -- From: Yucca Nel yucca...@live.co.za Sent: Monday, May 24, 2010 9:00 PM To: Tomcat Users List users@tomcat.apache.org Subject: Re: stuck confused an need help please yes but I don't know why access I being denied? The credentials I am providing sre 100% correct sn the database user has ALL privileges so could anyone perhaps think o a possible reason why I am getting these errors? I have confirmed with hosting provider that user exists and credentials are correct and they also appear to be lost. I am using correct myswl driver located in WEB-INF/lib -- From: Hassan Schroeder hassan.schroe...@gmail.com Sent: Monday, May 24, 2010 8:53 PM To: Tomcat Users List users@tomcat.apache.org Subject: Re: stuck confused an need help please On Mon, May 24, 2010 at 11:37 AM, Yucca Nel yucca...@live.co.za wrote: I have been getting mysql SELECT privilege denied exception even though user has all access to database. There would seem to be a contradiction between the above statement and the first error in your log example :-) 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) I would try to fix that first, personally... -- 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
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
Re: stuck confused an need help please
Oh and my hosting provider sent me a snipped of the cli where they logged in with my credentials so that is not the issue -- 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
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
Re: stuck confused an need help please
On Mon, May 24, 2010 at 12:11 PM, Yucca Nel yucca...@live.co.za wrote: Perhaps the real issue herw for mr personally (and I hope anyone using dailyrazor) could answer if it's normal to not be able to use mysql in a production environment where I DON't have to have my dailyrazor username prepended to everything related in mysql? I have utterly no idea what you're talking about now. there is no cli for myswl using cpanel. You don't have SSH access to your server? Good luck debugging, then; I would never use a hosting provider like that. Oh and my hosting provider sent me a snipped of the cli where they logged in with my credentials so that is not the issue Again, not what the log file is saying. Which, BTW, assuming is a straight copy/paste, includes an interesting space at the front of this ' yucca123_tom'@'localhost' string, which *ALSO* doesn't match the user name in your final example: # mysql --database=yucca123_thejarbar --user=yucca123_hiber -- 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
Re: stuck confused an need help please
Perhapa somwonw can recommend me another hosting provider (will gladly refer them) and one where they don't add silly prefix names o everything done in mysql? -- 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
Re: stuck confused an need help please
aplogies there are 2 users and both credentials are configured correct one for hibernate and one for tomcat what I maen is that my dailyraor username is eg. and everything in mysql gets prepended with xxx like xxx_mydatabase xxx_myusername xxx_mytable From: Hassan Schroeder hassan.schroe...@gmail.com Sent: Monday, May 24, 2010 9:23 PM To: Tomcat Users List users@tomcat.apache.org Subject: Re: stuck confused an need help please On Mon, May 24, 2010 at 12:11 PM, Yucca Nel yucca...@live.co.za wrote: Perhaps the real issue herw for mr personally (and I hope anyone using dailyrazor) could answer if it's normal to not be able to use mysql in a production environment where I DON't have to have my dailyrazor username prepended to everything related in mysql? I have utterly no idea what you're talking about now. there is no cli for myswl using cpanel. You don't have SSH access to your server? Good luck debugging, then; I would never use a hosting provider like that. Oh and my hosting provider sent me a snipped of the cli where they logged in with my credentials so that is not the issue Again, not what the log file is saying. Which, BTW, assuming is a straight copy/paste, includes an interesting space at the front of this ' yucca123_tom'@'localhost' string, which *ALSO* doesn't match the user name in your final example: # mysql --database=yucca123_thejarbar --user=yucca123_hiber -- 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
RE: stuck confused an need help please
it *is* important that you follow the directions provided to you as hassan mentioned you need to go to mysql command prompt and try to open the connection with the username/password mysqlconnect usern...@host mysqlsupply password if you cannot access ALL of the requested tables with each of the required DML operations(insert/update/delete/select) you will then need to run mysqladmin and either 1)create the user 2)grant the user the necessary access(insert/update/delete/select) access to the user you need as these questions are specific to mysql please ask mysql users list if you have any problems with these operations my...@lists.mysql.com Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. From: yucca...@live.co.za To: users@tomcat.apache.org Subject: Re: stuck confused an need help please Date: Mon, 24 May 2010 21:06:13 +0200 I forgot to mention I am using myswl 5, and tomcat 6 -- From: Yucca Nel yucca...@live.co.za Sent: Monday, May 24, 2010 9:00 PM To: Tomcat Users List users@tomcat.apache.org Subject: Re: stuck confused an need help please yes but I don't know why access I being denied? The credentials I am providing sre 100% correct sn the database user has ALL privileges so could anyone perhaps think o a possible reason why I am getting these errors? I have confirmed with hosting provider that user exists and credentials are correct and they also appear to be lost. I am using correct myswl driver located in WEB-INF/lib -- From: Hassan Schroeder hassan.schroe...@gmail.com Sent: Monday, May 24, 2010 8:53 PM To: Tomcat Users List users@tomcat.apache.org Subject: Re: stuck confused an need help please On Mon, May 24, 2010 at 11:37 AM, Yucca Nel yucca...@live.co.za wrote: I have been getting mysql SELECT privilege denied exception even though user has all access to database. There would seem to be a contradiction between the above statement and the first error in your log example :-) 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) I would try to fix that first, personally... -- 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 _ The New Busy is not the old busy. Search, chat and e-mail from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_3
