New installation of 2.1.7 on
tomcat 5.5.20 on Linux
On running the install I get:
JForum 2.1.7 installation Error
Error while trying to configure the database. Please check if parameters like username, password and host are correct and try again.
org.hsqldb.jdbcDriver
Assuming that I clobbered the hsqldb database, how do I reinitialize it and start over?
On the installation form, are the db username and password the values I want the installation program to create?
On attempting to start jforum I get the exeption: net.jforum.exceptions.DatabaseException: Error while trying to start the database: java.lang.ClassNotFoundException: org.hsqldb.jdbcDriver
Do I need to do something additional to install hsqldb?
-------------------------------------
Got it working, I think.
hsqldb appears to be missing from the jrorum 2.1.7 zip file.
Downloaded current version from
http://www.hsqldb.org/
cp /home/stryon/Downloads/zip/hsqldb/lib/* /home/deploy/webapps/conferences/WEB-INF/lib
Edited WEB-INF/config/database/hsqldb/hsqldb_data_dump.sql
[root@gsn2prodapp hsqldb]# diff hsqldb_data_dump.sql hsqldb_data_dump.sql.save
137,138c137,138
< INSERT INTO jforum_roles (role_id, name, group_id) VALUES (38, 'perm_html_disabled', 1);
<br /> < INSERT INTO jforum_roles (role_id, name, group_id) VALUES (39, 'perm_html_disabled', 2);
<br /> ---
<br /> > INSERT INTO jforum_roles (role_id, name, group_id) VALUES (38, 'perm_html_disabled', 1, 0);
<br /> > INSERT INTO jforum_roles (role_id, name, group_id) VALUES (39, 'perm_html_disabled', 2, 0);
------------------------------------------------
Thanks,
Steve
[originally posted on jforum.net by stryon]