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 > >
