Hi,
I followed the given instructions, and got the Turbine servlet running till
the login screen. But when I enter the login-id and password, it can not
connect to the MySQL database. It throws the following exception:
Exception: java.lang.Error: Error in BasePeer.initTableSchema(Visitor):
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.security.AccessControlException)
at
org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:225)
at
org.apache.turbine.om.user.peer.TurbineUserPeer.<clinit>(TurbineUserPeer.jav
a:146)
at
org.apache.turbine.om.user.TurbineUser.retrieveFromStorage(TurbineUser.java:
345)
at
org.apache.turbine.om.user.peer.UserFactory.getUser(UserFactory.java:113)
at
org.apache.turbine.om.user.peer.UserFactory.getUser(UserFactory.java:88)
at
org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUser.java:96)
at org.apache.turbine.modules.Action.perform(Action.java:77)
at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:111)
at Turbine.doGet(Turbine.java, Compiled Code)
at Turbine.doPost(Turbine.java:387)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:747)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
at com.sun.server.ServletState.callService(ServletState.java:226)
at
com.sun.server.ServletManager.callServletService(ServletManager.java:936)
at
com.sun.server.http.servlet.InvokerServlet.service(InvokerServlet.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
at com.sun.server.ServletState.callService(ServletState.java:226)
at
com.sun.server.ServletManager.callServletService(ServletManager.java:936)
at
com.sun.server.ProcessingState.invokeTargetServlet(ProcessingState.java:423)
at
com.sun.server.http.HttpProcessingState.execute(HttpProcessingState.java:79)
at com.sun.server.http.stages.Runner.process(Runner.java:79)
at
com.sun.server.ProcessingSupport.process(ProcessingSupport.java:294)
at com.sun.server.Service.process(Service.java:204)
at
com.sun.server.http.HttpServiceHandler.handleRequest(HttpServiceHandler.java
:374)
at
com.sun.server.http.HttpServiceHandler.handleRequest(HttpServiceHandler.java
:166)
at com.sun.server.HandlerThread.run(HandlerThread.java:162)
I've MySQL running on the default port. I've run the required scripts as per
the Intall document.
Also, here's the relevant clippings from the modified
TurbineResources.properties file:
--------------------------------
# These are your database settings, look in the
# org.apache.turbine.util.db.pool.* packages for more information.
#### ORACLE
#database.default.driver=oracle.jdbc.driver.OracleDriver
#database.default.url=jdbc:oracle:thin:@localhost:1521:ORCL
#### MySQL MM Driver
database.default.driver=org.gjt.mm.mysql.Driver
database.default.url=jdbc:mysql://localhost/turbine
database.default.username=dbUser
database.default.password=dbPass
# The number of database connections to cache in the ConnectionPool.
database.maxConnections=3
# The time in milliseconds that database connections will be cached.
# Default: one hour
database.expiryTime=3600000
# These are the supported jdbc-drivers and their adaptors.
# These properties are used by the DBFactory.
database.adaptor=DBMM
database.adaptor.DBMM=org.gjt.mm.mysql.Driver
database.adaptor=DBWeblogic
database.adaptor.DBWeblogic=weblogic.jdbc.pool.Driver
database.adaptor=DBOracle
database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver
database.adaptor=DBInstantDB
database.adaptor.DBInstantDB=jdbc.idbDriver
database.adaptor=DBPostgres
database.adaptor.DBPostgres=postgresql.Driver
database.adaptor=DBDB2Net
database.adaptor.DBDB2Net=COM.ibm.db2.jdbc.net.DB2Driver
database.adaptor=DBDB2App
database.adaptor.DBDB2App=COM.ibm.db2.jdbc.app.DB2Driver
database.adaptor=DBSybase
database.adaptor.DBSybase=com.sybase.jdbc.SybDriver
--------------------------------
I've also set the classpath for mysql classes.
Where could else, I be going wrong?
Your help is appreciated.
Thanks,
Hement
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
