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
