• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

org.hsqldb.jdbcDriver error on 2.1.7 install on tomcat 5.5

 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That's because they assume you are following directions to the 'T' for the upgrade. One of the instructions was to copy over the new 2.1.7 directory over your existing 2.1.6 directory (which contains the hsqldb jar file).

I hardily agree the good folks at jforum should focus on making upgrades much less painful since the ease of initial setup is a primary reason folks select JForum in the first place.

- Good luck.
[originally posted on jforum.net by dferrero]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ouch, the jar is in fact missing.

We'll update the release to this this.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You never updated the release, the jar is still missing. I had to grab it out of the 2.1.6 zip file.
[originally posted on jforum.net by mattcoz]
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic