The database user and password are not specific to the MySQL driver, so
these lines don't show up in the TurbineResources.properties file around the
MySQL stuff, but you do need to set the user ID and password for MySQL:
database.default.username=dbUser
database.default.password=dbPass
Obviously, change those to the correct user ID and password.
Also, make sure that you run the included SQL scripts to create the
appropriate tables. I needed to change my scripts slightly to make SURE
that the ID used the correct DB.
Under docs/schemas, modified the beginning of MySQL_id_table.sql,
MySQL_users_roles_permissions.sql, and default_roles_permissions.sql so that
the very first executable line is
USE Turbine;
Assuming MySQL is in your path:
mysqladmin -u user -ppassword -h localhost create Turbine
mysql -u user -ppassword < MySQL_id_table.sql
mysql -u user -ppassword < MySQL_users_roles_permissions.sql
mysql -u user -ppassword < default_roles_permissions.sql
I hope that this helps you. What you're getting is not precisely the same
exception that I got, but I fixed everything when I put in the right user ID
and password ;-)
Will Stranathan
>From: "Mahesh" <[EMAIL PROTECTED]>
>Reply-To: "Turbine" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: Turbine with MySQL
>Date: Fri, 23 Jun 2000 19:02:08 +0900
>
>Hi,
>
>I am new to Turbine Framework. I am trying to Install Turbine and use MySQL
>as database. I am using Apache with JServ. When I try to login after the
>installation of Turbine I am getting following error.
>
>Steps I followed:
>1. Installed MySQL in C:\mysql
>2. Run the sql files for MySQL provided to create the turbine database and
>tables.
>3. I modified the TurbineResources.properties files as
>**********************************************************************
>#### MySQL MM Driver
>database.default.driver=org.gjt.mm.mysql.Driver
>#database.default.url=jdbc:mysql://localhost/DATABASENAME
>database.default.url=jdbc:mysql://localhost:/turbine
>**********************************************************************
>
>When I try to give the User and Password as "turbine" try to log in it is
>giving following error.
>****************************************************************************
>************************
>Turbine - A Servlet Framework for building Secure Dynamic Websites.
>
>
>There has been an error! Please review the exception below for more
>information.
>Get/Post Data:
>screen= DefaultScreen
>password= turbine
>action= LoginUser
>submit= Login
>username= turbine
>
>The exception is:
>java.lang.Error: Error in BasePeer.initTableSchema(Visitor): Communication
>link failure: Bad handshake
> at org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:218)
> at
>org.apache.turbine.om.user.peer.TurbineUserPeer.(TurbineUserPeer.java:146)
> at
>org.apache.turbine.om.user.TurbineUser.retrieveFromStorage(TurbineUser.java:
>346)
> 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:288)
> at Turbine.doPost(Turbine.java:388)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:521)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
> at
>org.apache.jserv.JServConnection.processRequest(JServConnection.java:317)
> at org.apache.jserv.JServConnection.run(JServConnection.java:188)
> at java.lang.Thread.run(Thread.java:484)
>
>java.lang.Error: Error in BasePeer.initTableSchema(Visitor): Communication
>link failure: Bad handshake
>
>
>Turbine - A Servlet Framework for building Secure Dynamic Websites.
>
>****************************************************************************
>************************
>
>I would like to know where I am doing wrong. Any help in this regard would
>be of great help.
>
>Thanks,
>Mahesh
>
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
