Are you sure your db is named turbine and not Turbine? Don't know if it
matters, but I do not see much else that could be wrong.
John McNally
----- Original Message -----
From: Markku Yli-Pentila <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 05, 2000 12:26 AM
Subject: can't login into turbine - exception: java.sql.SQLException
> Hello,
> I can't login to turbine as user 'turbine'. I checked that there was user
> turbine defined, but when I try to login - I get to login screen well, but
> when trying to push login button, I get empty screen and errors that
> follows... my database is mysql.
>
> database definitions are:
> database.default.driver=org.gjt.mm.mysql.Driver
> database.default.url=jdbc:mysql://localhost/turbine
>
> database.default.username=<our user>
> database.default.password=<our password>
>
> # 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
> (I commented the rest of adaptors out for testing purposes, no difference)
> database turbine in mysql contains following tables:
> +-------------------+
> | Tables in turbine |
> +-------------------+
> | ID_TABLE |
> | Permission |
> | RolePermission |
> | UserRole |
> | Visitor |
> | VisitorRole |
> +-------------------+
> 6 rows in set (0.00 sec)
> Errors that come into turbine.log:
> [Wed Apr 05 08:21:21 GMT+03:00 2000] -- ERROR --
> Exception: java.sql.SQLException: General Error: 79
> Stack Trace follows:
> java.sql.SQLException: General Error: 79
> at org.gjt.mm.mysql.Connection.<init>(Connection.java:189)
> at org.gjt.mm.mysql.Driver.connect(Driver.java:119)
> at java.sql.DriverManager.getConnection(DriverManager.java:453)
> at java.sql.DriverManager.getConnection(DriverManager.java:155)
> at
> org.apache.turbine.util.db.pool.DBMM.getConnection(DBMM.java:88)
> at
> org.apache.turbine.util.db.pool.ConnectionPool.getNewConnection(Conne
> ctionPool.java:180)
> at
> org.apache.turbine.util.db.pool.ConnectionPool.getConnection(Connecti
> onPool.java:141)
> at
> org.apache.turbine.util.db.pool.DBBroker.getConnection(DBBroker.java:
> 167)
> at
> org.apache.turbine.util.db.pool.DBBroker.getConnection(DBBroker.java:
> 124)
> at
> org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:207
> )
> at
> org.apache.turbine.om.user.peer.TurbineUserPeer.<clinit>(TurbineUserP
> eer.java:146)
> at
> org.apache.turbine.om.user.TurbineUser.retrieveFromStorage(TurbineUse
> r.java:309)
> 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.build(LoginUser.java:96)
> at
> org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:111)
> at Turbine.doGet(Turbine.java:264)
> at Turbine.doPost(Turbine.java:394)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:277)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:309)
> at
> org.apache.jserv.JServConnection.processRequest(JServConnection.java:
> 314)
> at org.apache.jserv.JServConnection.run(JServConnection.java:188)
> at java.lang.Thread.run(Thread.java:475)
> [Wed Apr 05 08:21:21 GMT+03:00 2000] -- ERROR --
> Exception: java.lang.Error: Error in BasePeer.initTableSchema():
> Genera
> l Error: 79
> Stack Trace follows:
> java.lang.Error: Error in BasePeer.initTableSchema(): General
> Error: 79
> at
> org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:222
> )
> at
> org.apache.turbine.om.user.peer.TurbineUserPeer.<clinit>(TurbineUserP
> eer.java:146)
> at
> org.apache.turbine.om.user.TurbineUser.retrieveFromStorage(TurbineUse
> r.java:309)
> 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.build(LoginUser.java:96)
> at
> org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:111)
> at Turbine.doGet(Turbine.java:264)
> at Turbine.doPost(Turbine.java:394)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:277)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:309)
> at
> org.apache.jserv.JServConnection.processRequest(JServConnection.java:
> 314)
> at org.apache.jserv.JServConnection.run(JServConnection.java:188)
> at java.lang.Thread.run(Thread.java:475)
>
> What to do to stop this happening and to get working with Turbine?
>
>
> >
>
> --
> --------------------------------------------------------------------------
> Markku Yli-Pentila, Kauhajoki Media Net, admin
> www: http://www.kauhajoki.fi/~markkuyp/
>
>
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
