Stephen,
The setting for "database.default.url" tells the MM JDBC driver how to connect
to the database. Assuming:
* your database is on machine "192.168.10.10",
* you've got the database called "turbine_db"
* your valid db username is "[EMAIL PROTECTED]"
* your valid db passwrod is "dbpass"
* Your setting up turbine on the machine "thishost.org"
your settings would be:
database.default.driver=org.gjt.mm.mysql.Driver
database.default.url=jdbc:mysql://192.168.10.10/turbine
database.default.username=dbuser
database.default.password=dbpass
Also, you should reference the API doc with the MM drivers called "Driver.html"
int the directory:
doc/apidoc/org/gjt/mm/mysql/Driver.html
Hope this helps.
-Craig
Stephen Adkins wrote:
> Hi,
>
> I am trying to get Turbine up and running on my system
> and I ran into what I am sure is a very simple problem.
>
> I have
>
> * RedHat 6.0 (with upgraded glibc-2.1.2-11)
> * Blackdown Java JDK 1.1.7 v3
> * JServ 1.1
> * Apache 1.3.9
> * MySQL 3.22.30
> * mm.mysql.jdbc-1.2b (MySQL JDBC drivers)
> * Apache-ECS-20000129
> * Apache-Turbine-20000129
> * village-1.1
> * JSDK2.0
> * jaf-1.0.1
> * javamail-1.1.2
> * jndi-1.2.1
>
> I read the "install.txt" for Turbine, and
> I tried to configure the TurbineResources.properties file
> correctly but I don't know what to set for "database.default.url".
>
> I consulted the "org.apache.turbine.db*" package for more information
> but I was unable to discern anything.
>
> Predictably, I am getting the correct login screen at
>
> http://raven.officevision.com:8080/servlets/Turbine
>
> but when I try to log in with "turbine"/"turbine", I get a blank
> screen and errors in the logs (see below). I did create the
> database tables as required (including the creation of the "turbine"
> visitor). I also created a database user named "turbine".
> One thing I never did was specify anywhere what database
> ("OV001") I was supposed to connect to.
>
> Can anyone help my with the particular setting of
> database.default.url?
>
> Thanks,
> Stephen
>
> =========================================
> excerpt from TurbineResources.properties.
> =========================================
>
> # These are your database settings, look in the
> # org.apache.turbine.db* package for more information.
> database.default.driver=org.gjt.mm.mysql.Driver
> database.default.url=jdbc:oracle:thin:@localhost:1521:ORCL
> database.default.username=turbine
> database.default.password=turbine
> database.maxConnections=8
> database.expiryTime=3600000
>
> =========================================
> jserv.log
> =========================================
>
> /usr/ov/devel/apache/logs> tail jserv.log
> [04/02/2000 23:51:19:811 CST] Turbine: init
> [04/02/2000 23:51:19:855 CST] Turbine: Turbine init()!
> [04/02/2000 23:51:20:952 CST] java.lang.Error: Error in
> BasePeer.initTableSchema(): No suitable driver
> at
> org.apache.jserv.JServConnection.processRequest(JServConnection.java:320)
> at org.apache.jserv.JServConnection.run(JServConnection.java:188)
> at java.lang.Thread.run(Thread.java)
> [04/02/2000 23:53:11:608 CST] java.lang.Error: Error in
> BasePeer.initTableSchema(): No suitable driver
> at
> org.apache.jserv.JServConnection.processRequest(JServConnection.java:320)
> at org.apache.jserv.JServConnection.run(JServConnection.java:188)
> at java.lang.Thread.run(Thread.java)
>
> =========================================
> error_log
> =========================================
>
> sequoia[spadkins]:/usr/ov/devel/apache/logs> tail error_log
> DbBrokerImpl: Is now turned on.
> java.lang.Error: Error in BasePeer.initTableSchema(): No suitable driver
> at
> org.apache.jserv.JServConnection.processRequest(JServConnection.java:320)
> at org.apache.jserv.JServConnection.run(JServConnection.java:188)
> at java.lang.Thread.run(Thread.java)
>
> =========================================
> jserv.properties
> =========================================
>
> wrapper.classpath=/usr/local/src/Apache-Jyve-20000129/bin/jyve.jar
> wrapper.classpath=/usr/local/src/Apache-Turbine-20000129/bin/turbine-2.0.jar
> wrapper.classpath=/usr/local/src/Apache-ECS-20000129/bin/ecs-1.2.jar
> wrapper.classpath=/usr/local/src/village-1.1/village-1.1.jar
> wrapper.classpath=/usr/local/javamail-1.1.2/mail.jar
> wrapper.classpath=/usr/local/jaf-1.0.1/activation.jar
> wrapper.classpath=/usr/local/jndi-1.2.1/lib/jndi.jar
> wrapper.classpath=/usr/ov/devel/apache/libexec/ApacheJServ.jar
> wrapper.classpath=/usr/local/JSDK2.0/lib/jsdk.jar
> wrapper.classpath=/usr/local/src/mm.mysql.jdbc-1.2b/mysql_uncomp.jar
> wrapper.classpath=/usr/local/java/lib/classes.zip
>
> =========================================
> mysql session - demonstrates the DB is OK
> =========================================
>
> /usr/ov/devel> mysql -u turbine -pturbine
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 10 to server version: 3.22.30
>
> Type 'help' for help.
>
> mysql> select * from user where username = 'turbine';
> ERROR 1046: No Database Selected
> mysql> connect mysql
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Connection id: 11
> Current database: mysql
>
> mysql> select * from user where user = 'turbine';
> +-----------+---------+------------------+-------------+-------------+------
> -------+-------------+-------------+-----------+-------------+--------------
> -+--------------+-----------+------------+-----------------+------------+---
> ---------+
> | Host | User | Password | Select_priv | Insert_priv |
> Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv |
> Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv |
> Index_priv | Alter_priv |
> +-----------+---------+------------------+-------------+-------------+------
> -------+-------------+-------------+-----------+-------------+--------------
> -+--------------+-----------+------------+-----------------+------------+---
> ---------+
> | localhost | turbine | 14ef247378046918 | Y | Y | Y
> | Y | Y | Y | Y | Y
> | Y | Y | N | Y | Y | Y
> |
> +-----------+---------+------------------+-------------+-------------+------
> -------+-------------+-------------+-----------+-------------+--------------
> -+--------------+-----------+------------+-----------------+------------+---
> ---------+
> 1 row in set (0.00 sec)
>
> mysql> use OV001
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Database changed
> mysql> show tables;
> +-----------------+
> | Tables in OV001 |
> +-----------------+
> | Permission |
> | RolePermission |
> | UserRole |
> | Visitor |
> | VisitorRole |
> +-----------------+
> 5 rows in set (0.00 sec)
>
> mysql> select * from Visitor;
> +-----------+---------+----------------+------------+-----------+----------+
> ----------+------+-------+------------+---------+-------------+-------+-----
> -----+------+------+-------+-------+----------------+---------+-------------
> ---+------------+
> | VISITORID | LOGINID | PASSWORD_VALUE | FIRST_NAME | LAST_NAME | ADDRESS1
> | ADDRESS2 | CITY | STATE | POSTALCODE | COUNTRY | CITIZENSHIP | PHONE |
> ALTPHONE | FAX | CELL | PAGER | EMAIL | MODIFIED | CREATED |
> LASTLOGIN | OBJECTDATA |
> +-----------+---------+----------------+------------+-----------+----------+
> ----------+------+-------+------------+---------+-------------+-------+-----
> -----+------+------+-------+-------+----------------+---------+-------------
> ---+------------+
> | 1 | turbine | turbine | | | NULL
> | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
> NULL | NULL | NULL | NULL | NULL | 20000204220636 | NULL |
> 00000000000000 | NULL |
> +-----------+---------+----------------+------------+-----------+----------+
> ----------+------+-------+------------+---------+-------------+-------+-----
> -----+------+------+-------+-------+----------------+---------+-------------
> ---+------------+
> 1 row in set (0.00 sec)
>
> mysql> quit
> Bye
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
