hi raje !
  thanx fro your reply.
  i did as u had said that is...1) changed my TR.P settings as per your
inline instructions.
                                         2) ran turbine-mysql.sql and
populate-mysql.sql
                                         but now when i access user admin in
jetspeed i get the following error on my screen.

Horrible Exception: java.lang.Error: Error in
BasePeer.initTableSchema(TURBINE_USER): no scale for non-numeric data types
 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.<clinit>(TurbineUserPeer
.java:175)
 at
org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager
.java:158)
 at
org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager
.java:246)
 at
org.apache.turbine.services.security.BaseSecurityService.getAuthenticatedUse
r(BaseSecurityService.java:312)
 at
org.apache.turbine.services.security.TurbineSecurity.getAuthenticatedUser(Tu
rbineSecurity.java:199)
 at
org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUser.java:111)
 at org.apache.turbine.modules.Action.perform(Action.java:87)
 at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
 at
org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java:143
)
 at org.apache.turbine.modules.Action.perform(Action.java:87)
 at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
 at org.apache.turbine.Turbine.doGet(Turbine.java:393)
 at org.apache.turbine.Turbine.doPost(Turbine.java:537)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:772)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
 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.java:79
7)
 at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
 at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.java:213)
 at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
 at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
 at java.lang.Thread.run(Thread.java:484)


please help.

TIA

sumit
----- Original Message -----
From: "Rajeswari Venkatachalam" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Sumit Ranjan"
<[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 10:10 PM
Subject: RE: mysql


> step 1: configure TurbineRes.props as shown below:
>
> #database.default.driver=org.hsql.jdbcDriver
> #database.default.url=jdbc:HypersonicSQL:${webapp.dir}/WEB-INF/db/jetspeed
> #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
>
> step 2: Run sql script for mysql. This creates database needed by
> turbine/jetspeed. scripts are located in:
> C:\Jetspeed\jakarta-jetspeed\src\sql\external
>
> Thats it.
>
> -Raje
>
> > -----Original Message-----
> > From: Paul Lewis [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, September 05, 2001 12:37 PM
> > To: [EMAIL PROTECTED]; Sumit Ranjan
> > Subject: Re: mysql
> >
> >
> >
> > ----- Original Message -----
> > From: Sumit Ranjan <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, September 05, 2001 3:16 PM
> > Subject: mysql
> >
> >
> > > hi all !
> > >   i want to use mysql in place of hsql.
> > >   please tell me how to go about it.
> > >
> > > thanx
> > >
> > > Sumit Ranjan
> > >
> > >
> > >
> > >
> > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail:
> > [EMAIL PROTECTED]
> > >
> >
> > I'm pretty new to Jetspeed myself but from reading through
> > the docs I think
> > you need to
> > to alter the database.default parameters. These are in the
> > turbine.resources.properties file located in
> > <path_to_jetspeed>\web-inf\ conf\TurbineResources.properties.
> >
> > Presuming your classpath is set up correctly that should sort out your
> > problem.
> >
> > Ian Lewis
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>


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

Reply via email to