i'm gonna need some help installing JForum

[Randall Twede]

i have Tomcat running. i am reading the instructions for installing JForum.
Directory permissions: all the directories are there and allow writing except WEB-INF/jforumLuceneIndex(not there). the instructions are for 2.1.8 and i have 2.1.9 so i don't think that is a problem. my first problem is the database. i haven't created one for about 10 years so i am very rusty on that. i have Open Office so i can use that or i can get MySQL. in either case, should i choose HSQLDB? any instructions for creating the database would be greatly appreciated since i cant do anything until that part is correct.

[robert crowther]

Recent dicussion on the type of database to use,

https://coderanch.com/t/622939/jforum/Mild-warning-suggestion-develop-Oracle

Upshot: HSQLDB is marvellous for a trial, as you need nothing installed, barely any Java setup at all (not words you will hear too often). But is not recommended for production.

I do appreciate the trouble in setting up a database, from scratch, for non-professionals and others without help behind them, I do. It's a grind. But if you feel from the start you will be using JForum, you may as well do it now. JForum can work with any DB having Java connectors, (Derby, Postgre, MySQL...). I really recommend biting the bullet and finding instructions for your OS and environment. Do the job thoroughly, because JForum has both an installer, and it's manual setup through proprty files is about as good as it gets.

Extra thouught - if you have no overwhelming inclination towards one database or another, consider how you might be deploying the forum. I know it's a long way in the future, but consider which databases are are supported by the deployment method. Otherwise, you might wind up having to migrate data from one DB to anotther...

Rob

[Randall Twede]

thanks rob. it will not be for production. it will just be to learn about JForum so i can help out here some(if needed). i will check out the link you posted. i will also look around for tutorials. i was very good at normalization and the rest when i was in school. that was a long time ago but it should come back quickly.

JForum can work with any DB having Java connectors

i am guessing Open Office will fit that requirement so i think i will go with it.