> (Using password: NO)
That looks suspect - is your password = "NO"

>  '[EMAIL PROTECTED]'

is that a valid server name ?

Send us your TurbineResource.properties - I can try it out on my mySQL


----- Original Message -----
From: "Patel, Satish" <[EMAIL PROTECTED]>
To: "'Jetspeed Users List'" <[EMAIL PROTECTED]>
Sent: Tuesday, January 08, 2002 9:48 AM
Subject: RE: problem connecting mysql to jetspeed


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



--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to