I am also getting below error does anybody know why?? I have created the database jetspeed and gave all privileges to user from local host named sa and no password. why doesn't this work?? please help....Paul or David.
thanks, Horrible Exception: java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER): Invalid authorization specification: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) 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(ServletHandler.java) at org.apache.tomcat.core.Handler.invoke(Handler.java) at org.apache.tomcat.core.Handler.service(Handler.java) at org.apache.tomcat.facade.ServletHandler.service(ServletHandler.java) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java) at org.apache.tomcat.core.ContextManager.service(ContextManager.java) at org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Http10I nterceptor.java) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a) at java.lang.Thread.run(Thread.java:484) -----Original Message----- From: Emmanuel Bardet [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 12:05 PM To: Jetspeed Users List Subject: RE: problem connecting mysql to jetspeed 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]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
