mysql problem........

[chaloo banda <ch...@hotmail.com>]

hi all !

  i am trying to use mysql as the database for jetspeed.
  i have configured the TR.P as under...

database.default.driver=org.gjt.mm.mysql.Driver
database.default.url=jdbc:mysql://localhost:3306/jetspeed

database.default.username=ranjanwa
database.default.password=password
(i have checked with mysqladmin that my database runs with the above user
name and password ! )

database.adaptor=DBMM
database.adaptor.DBMM=org.gjt.mm.mysql.Driver

database.idbroker.cleverquantity=true

next i created all the tables as given in src/sql/external/turbine-mysql.sql
and populated them with the values given in populate-mysql.sql
(these i did manually...and checked that the tables exist and are
populated.)

i have mm.mysql-2.0.4-bin (jar file) in jetspeed/web-inf/lib and in
web-inf/db . i also have mm.mysql-2.0.4(not bin !) in my tomcat/lib.

now i start mysql(i have tried to run it in stand-alone as well as in
service mode !), start jetspeed .the first page comes well. but when i try
to access any of the default user (admin or turbine ) or try to create new
user it takes me to the home page(and not the expected confirmation key page
! )...and my jetspeed.log gives the following error....

Wed Sep 12 16:49:20 GMT+05:30 2001] -- ERROR -- Turbine.handleException:
Error in BasePeer.initTableSchema(TURBINE_USER): Cannot connect to MySQL
server on localhost:3306. Is there a MySQL server running on the
machine/port you are trying to connect to? (java.net.ConnectException)
[Wed Sep 12 16:49:20 GMT+05:30 2001] -- ERROR --
Exception:  java.lang.Error: Error in
BasePeer.initTableSchema(TURBINE_USER): Cannot connect to MySQL server on
localhost:3306. Is there a MySQL server running on the machine/port you are
trying to connect to? (java.net.ConnectException)
Stack Trace follows:
java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER): Cannot
connect to MySQL server on localhost:3306. Is there a MySQL server running
on the machine/port you are trying to connect to?
(java.net.ConnectException)
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)
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.getAuthenticatedUser(BaseSecurityService.java:313)
at
org.apache.turbine.services.security.TurbineSecurity.getAuthenticatedUser(TurbineSecurity.java:199)
at
org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUser.java:103)
at org.apache.turbine.modules.Action.perform(Action.java:87)

and ...

[Wed Sep 12 17:01:51 GMT+05:30 2001] -- INFO -- Entering JLoginUser action
[Wed Sep 12 17:01:51 GMT+05:30 2001] -- ERROR -- Turbine.handleException:
null
[Wed Sep 12 17:01:51 GMT+05:30 2001] -- ERROR --
Exception:  java.lang.NoClassDefFoundError
Stack Trace follows:
java.lang.NoClassDefFoundError
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.getAuthenticatedUser(BaseSecurityService.java:313)
at
org.apache.turbine.services.security.TurbineSecurity.getAuthenticatedUser(TurbineSecurity.java:199)
at
org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUser.java:103)
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: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.java:797)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)

i am simply at my wits end trying to find out where did i go wrong.
is this a problem of wrong mysql installation(but i followed the manual !)as
with hsql i had my jetspeed running real smooth.

or is this some permission mismatch for mysql ?

in my jetspeed/web-inf/db i have the attached files. please have a look at
them and suggest.

  i am using mysql3.23.41
             jetspeed(latest)
             tomcat 3.2.2
             apache 1.3.11
             windows NT 4.0 workstation

I apologize for sending so long a mail and that too with attachments !

please accept my thanx in advance,

CB


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp