Setting up x planner plus using Tomcat
Hi, I am trying to configure Tomcat so that I can run x-planner plus on it. I have been following some tutorials but don't seem to be getting anywhere with it. Im getting what looks like some database errors when running Tomcat with my xplanner plus application in the web apps dir. If the xplanner app is not there then I do not getting any errors. Also the example applications seem to work fine. The errors that I am getting are sql.SQLException: User not found: XPLANNER I have created a user using this script in mysql GRANT ALL PRIVILEGES ON xplanner.* TO 'xplanner'@'localhost' IDENTIFIED BY 'xp' WITH GRANT OPTION; Also in the xplanner file : xplanner.properties xplanner-custom.properties I have changed the connection part to this: # Hibernate MySQL Configuration hibernate.dialect=com.technoetic.xplanner.db.hibernate.XPlannerMySQLDialect hibernate.connection.driver_class=com.mysql.jdbc.Driver hibernate.connection.dbname=xplanner hibernate.connection.url=jdbc:mysql://localhost/ hibernate.connection.username=xplanner hibernate.connection.password=xp xplanner.migration.databasetype=mysql xplanner.migration.patchpath=patches:com.technoetic.xplanner.upgrade:com.technoetic.xplanner.security.install Any advice would be much appreciated Thanks in advance -- View this message in context: http://old.nabble.com/Setting-up-x-planner-plus-using-Tomcat-tp26680216p26680216.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Setting up x planner plus using Tomcat
Given that the samples run fine, this doesn't look like a Tomcat issue. I suspect you'd have better luck on a MySQL, Hibernate or x-planner list. I'm slightly bemused that the username in the error message is in UPPERCASE when you've specified it in lower case - is something assuming particular case-sensitivity on MySQL? - Peter 2009/12/7 joe_sad joesadd...@gmail.com Hi, I am trying to configure Tomcat so that I can run x-planner plus on it. I have been following some tutorials but don't seem to be getting anywhere with it. Im getting what looks like some database errors when running Tomcat with my xplanner plus application in the web apps dir. If the xplanner app is not there then I do not getting any errors. Also the example applications seem to work fine. The errors that I am getting are sql.SQLException: User not found: XPLANNER I have created a user using this script in mysql GRANT ALL PRIVILEGES ON xplanner.* TO 'xplanner'@'localhost' IDENTIFIED BY 'xp' WITH GRANT OPTION; Also in the xplanner file : xplanner.properties xplanner-custom.properties I have changed the connection part to this: # Hibernate MySQL Configuration hibernate.dialect=com.technoetic.xplanner.db.hibernate.XPlannerMySQLDialect hibernate.connection.driver_class=com.mysql.jdbc.Driver hibernate.connection.dbname=xplanner hibernate.connection.url=jdbc:mysql://localhost/ hibernate.connection.username=xplanner hibernate.connection.password=xp xplanner.migration.databasetype=mysql xplanner.migration.patchpath=patches:com.technoetic.xplanner.upgrade:com.technoetic.xplanner.security.install Any advice would be much appreciated Thanks in advance -- View this message in context: http://old.nabble.com/Setting-up-x-planner-plus-using-Tomcat-tp26680216p26680216.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Setting up x planner plus using Tomcat
After much fustration I managed to get it working but thanks for your help it was greatly appreciated. Peter Crowther wrote: Given that the samples run fine, this doesn't look like a Tomcat issue. I suspect you'd have better luck on a MySQL, Hibernate or x-planner list. I'm slightly bemused that the username in the error message is in UPPERCASE when you've specified it in lower case - is something assuming particular case-sensitivity on MySQL? - Peter 2009/12/7 joe_sad joesadd...@gmail.com Hi, I am trying to configure Tomcat so that I can run x-planner plus on it. I have been following some tutorials but don't seem to be getting anywhere with it. Im getting what looks like some database errors when running Tomcat with my xplanner plus application in the web apps dir. If the xplanner app is not there then I do not getting any errors. Also the example applications seem to work fine. The errors that I am getting are sql.SQLException: User not found: XPLANNER I have created a user using this script in mysql GRANT ALL PRIVILEGES ON xplanner.* TO 'xplanner'@'localhost' IDENTIFIED BY 'xp' WITH GRANT OPTION; Also in the xplanner file : xplanner.properties xplanner-custom.properties I have changed the connection part to this: # Hibernate MySQL Configuration hibernate.dialect=com.technoetic.xplanner.db.hibernate.XPlannerMySQLDialect hibernate.connection.driver_class=com.mysql.jdbc.Driver hibernate.connection.dbname=xplanner hibernate.connection.url=jdbc:mysql://localhost/ hibernate.connection.username=xplanner hibernate.connection.password=xp xplanner.migration.databasetype=mysql xplanner.migration.patchpath=patches:com.technoetic.xplanner.upgrade:com.technoetic.xplanner.security.install Any advice would be much appreciated Thanks in advance -- View this message in context: http://old.nabble.com/Setting-up-x-planner-plus-using-Tomcat-tp26680216p26680216.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org -- View this message in context: http://old.nabble.com/Setting-up-x-planner-plus-using-Tomcat-tp26680216p26682691.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org