I'm surprised your database.default.url is not equal to something like jdbc:mysql://yourserver:3306/yourdatabasename
Check this out first. And look for default_roles_permissions.sql to populate your db. Emmanuel -----Original Message----- From: stefan [mailto:stefan]On Behalf Of Stefan Krause Sent: mardi 8 janvier 2002 16:47 To: [EMAIL PROTECTED] Subject: problem connecting mysql to jetspeed Hi, I would like to use jetspeed with mysql. Jetspeed worked well with the Hypersonicsql database. I changed the settings in TurbineResources.properties(binary version) to: database.default.driver=org.gjt.mm.mysql.Driver database.default.url=jdbc:mysql:${webappRoot}/WEB-INF/db/jetspeed database.default.username=admin database.default.password=admin database.adaptor=DBMM database.adaptor.DBMM=org.gjt.mm.mysql.Driver Is it necessary to change these settings in the sources and to recompile those? The database on mysql exists with name 'turbine' and user 'admin'. Is this the wrong database name? Do I have to use the populate-scripts or does it jetspeed by itself? Obviously I don't get access to the database when jetspeed tries to add a new user to the database. When I create a new user in Jetspeed I get the following exception: Horrible Exception: java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER): Server configuration denies access to data source at org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:232) at org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:194) at org.apache.turbine.om.security.peer.TurbineUserPeer.(TurbineUserPeer.java:17 5) at org.apache.turbine.services.security.db.DBUserManager.accountExists(DBUserMa nager.java:124) at org.apache.turbine.services.security.BaseSecurityService.accountExists(BaseS ecurityService.java:291) at org.apache.turbine.services.security.TurbineSecurity.accountExists(TurbineSe curity.java:183) at org.apache.jetspeed.modules.actions.CreateNewUserAndConfirm.doPerform(Create NewUserAndConfirm.java:153) at org.apache.turbine.modules.Action.perform(Action.java:87) at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:143) at org.apache.turbine.modules.Page.build(Page.java:90) at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123) at org.apache.turbine.Turbine.doGet(Turbine.java:565) at org.apache.turbine.Turbine.doPost(Turbine.java:655) at javax.servlet.http.HttpServlet.service(HttpServlet.java) at javax.servlet.http.HttpServlet.service(HttpServlet.java) at org.apache.tomcat.facade.ServletHandler.doService(Unknown Source) at org.apache.tomcat.core.Handler.invoke(Unknown Source) at org.apache.tomcat.core.Handler.service(Unknown Source) at org.apache.tomcat.facade.ServletHandler.service(Unknown Source) at org.apache.tomcat.core.ContextManager.internalService(Unknown Source) at org.apache.tomcat.core.ContextManager.service(Unknown Source) at org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Unknown Source) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(Unknown Source) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown Source) at java.lang.Thread.run(Thread.java:484) I would be grateful for an advice. Thanks in advance. Stefan -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
