You have to execute the Turbine's mysql schema for role and permission.
You can find it in turbine project.
I used mysql for my Jetspeed
:)
Frans
At 02:40 AM 9/21/2001 -0700, you wrote:
>hi there !
>
> I agree that this mail is slightly off-track...but
>still ..since jetspeed uses turbine for databases
>pooling and other jobs...i think i may be able to get
>my answer here.
>!)
>
> I am trying to have Mysql as database for jetspeed
>but am unable to get it run as of now. I 'll be highly
>thankful if u cud guide me here.
>
> I am using Apache 1.3.11
> Tomcat 3.2.2
> Win NT 4.0 workstation
> Jetspeed (latest)
> mysql 3.23.41(as NT service )
>
>I had recently decided to shift from HSQL to MySQL for
>my jetspeed
>database.
>it used to run well on hsql.
>so...I installed Mysql, run mysql
>scripts(turbine-mysql.sql ,
>populate-mysql.sql , and MySQL_calendar_v1.0.sql) to
>create the
>necessary
>tables in the database (database name= mysql ).
>Next I , changed my TurbineResources.Properties as
>under...
>
>#database.default.driver=org.hsql.jdbcDriver
>#database.default.url=jdbc:HypersonicSQL:${webapp.dir}/WEB-INF/db/jetspe
>ed
>#database.default.username=sa
>#database.default.password=
>
>database.default.driver=org.gjt.mm.mysql.Driver
>database.default.url=jdbc:mysql://localhost:3306/mysql
>
>database.default.username=root
>database.default.password=
>
>database.adaptor=DBMM
>database.adaptor.DBMM=org.gjt.mm.mysql.Driver
>
>#database.adaptor=DBHypersonicSQL
>#database.adaptor.DBHypersonicSQL=org.hsql.jdbcDriver
>
>my WEB-INF/lib and WEB-INF/db contains mysql.jar(107
>kb) and
>mm.mysql-2.0.4-bin.jar(108kb).
>
>Next I restarted both the mysql service and tomcat.
>now , when I try to get user=admin
>password=jetspeed or the
>other
>default user from jetspeed I am sent to the home page
>with my
>jetspeed/log
>showing the following error.....
>
>[Thu Sep 20 15:59:59 GMT+05:30 2001] -- ERROR --
>Turbine.handleException:
>null
>[Thu Sep 20 15:59:59 GMT+05:30 2001] -- ERROR --
> Exception: java.lang.NoClassDefFoundError
> Stack Trace follows:
> java.lang.NoClassDefFoundError
> at
>org.apache.turbine.services.security.db.DBUserManager.accountExists(DBUs
>erMa
>nager.java:124)
> at
>org.apache.turbine.services.security.BaseSecurityService.accountExists(B
>aseS
>ecurityService.java:292)
> at
>org.apache.turbine.services.security.TurbineSecurity.accountExists(Turbi
>neSe
>curity.java:183)
> at
>org.apache.jetspeed.modules.actions.CreateNewUserAndConfirm.doPerform(Cr
>eate
>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:14
>3)
> 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:447)
> at
>org.apache.turbine.Turbine.doPost(Turbine.java:537)
> at
>javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> at
>javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
>org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
> at
>org.apache.tomcat.core.Handler.service(Handler.java:287)
> at
>org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
> at
>org.apache.tomcat.core.ContextManager.internalService(ContextManager.jav
>a:79
>7)
> at
>org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
> at
>org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(H
>ttpC
>onnectionHandler.java:213)
> at
>org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416
>)
> at
>org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:50
>1)
> at java.lang.Thread.run(Thread.java:484)
>
>i don't know where have i erred and earnestly request
>you to look into
>the
>matter and suggest.
>
>i also have the following doubts , which I request you
>to clear;
>
>1)now my web-inf/db directory has the same old
>jetspeed.script,
>jetspeed.backup,jetspeed.data,jetspeed.properties ,
>manageDB(MS-DOS
>batch
>file !)
> are these to be changed also....with what ?
>2)is it because of some database user permission ???
>
>3)is it because of some name-clash in the database
>...I mean I have
>created
>all the tables in the database "mysql". shud I use
>some other name(like
>jetspeed or turbine instead ?)
>
>and finally if it is not too much to ask , can u
>please send me your
>configuration settings, so that I may compare them
>with mine.
>
>thanking in advance and awaiting a reply ,
>
>
>regards,
>
>Sumit
>
>
>
>__________________________________________________
>Terrorist Attacks on U.S. - How can you help?
>Donate cash, emergency relief information
>http://dailynews.yahoo.com/fc/US/Emergency_Information/
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
