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]
