Errors installing 2.1.7b3 on Linux/Tomcat5.5/Postgres

[Migrated From Jforum.net]

I am installing JForum 2.1.7-b3 on a linux server running Tomcat 5.5 and PostgreSQL 8.1.2.

I got around the "need write support" issue by downloading and putting the "__index.redirect" file in my jforum home directory.

Now, I am getting the following errors while the installer is trying to create database tables:

02:44:20,392  INFO [InstallAction       ] Going to configure the database...
02:44:20,393  INFO [InstallAction       ] Updating key database.connection.password with value jforum
02:44:20,393  INFO [InstallAction       ] Updating key database.connection.dbname with value jforum
02:44:20,393  INFO [InstallAction       ] Updating key database.support.autokeys with value false
02:44:20,393  INFO [InstallAction       ] Updating key database.connection.host with value localhost
02:44:20,393  INFO [InstallAction       ] Updating key database.connection.pool.min with value 10
02:44:20,393  INFO [InstallAction       ] Updating key database.support.subqueries with value true
02:44:20,393  INFO [InstallAction       ] Updating key database.connection.pool.timeout with value 2000
02:44:20,393  INFO [InstallAction       ] Updating key database.connection.port with value 5432
02:44:20,394  INFO [InstallAction       ] Updating key database.connection.username with value jforum
02:44:20,394  INFO [InstallAction       ] Updating key dbencoding with value utf-8
02:44:20,394  INFO [InstallAction       ] Updating key database.connection.string with value jdbc:postgresql://${database.connection.host}:${database.connection.port}/${database.connection.dbname}?user=${database.connection.username}&password=${database.connection.password}
02:44:20,394  INFO [InstallAction       ] Updating key database.connection.pool.max with value 50
02:44:20,394  INFO [InstallAction       ] Updating key dao.driver with value net.jforum.dao.postgresql.PostgresqlDataAccessDriver
02:44:20,394  INFO [InstallAction       ] Updating key database.connection.driver with value org.postgresql.Driver
02:44:20,394  INFO [FileMonitor         ] Watching /opt/tomcat/webapps/jforum/WEB-INF/config/jforum-custom.conf
02:44:20,395  INFO [FileMonitor         ] Watching /opt/tomcat/webapps/jforum/WEB-INF/config/jforum-custom.conf
02:44:20,399  INFO [InstallAction       ] Database configuration ok
02:44:20,399  INFO [InstallAction       ] Going to create tables...
02:44:20,400  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_banlist" does not exist
02:44:20,400  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_banlist_seq" does not exist
02:44:20,400  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_categories" does not exist
02:44:20,400  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_categories_order_seq" does not exist
02:44:20,401  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_categories_seq" does not exist02:44:20,401  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_config" does not exist
02:44:20,401  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_config_seq" does not exist
02:44:20,401  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_forums" does not exist
02:44:20,401  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_forums_seq" does not exist
02:44:20,402  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_groups" does not exist
02:44:20,402  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_groups_seq" does not exist
02:44:20,402  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_posts" does not exist
02:44:20,402  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_posts_seq" does not exist
02:44:20,403  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_posts_text" does not exist
02:44:20,403  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_privmsgs" does not exist
02:44:20,403  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_privmsgs_seq" does not exist
02:44:20,403  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_privmsgs_text" does not exist
02:44:20,404  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_ranks" does not exist
02:44:20,404  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_ranks_seq" does not exist
02:44:20,404  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_role_values" does not exist
02:44:20,405  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_roles" does not exist
02:44:20,405  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_roles_seq" does not exist
02:44:20,405  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_search_results" does not exist
02:44:20,405  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_search_topics" does not exist
02:44:20,406  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_search_wordmatch" does not exist
02:44:20,406  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_search_words" does not exist
02:44:20,406  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_search_words_seq" does not exist
02:44:20,406  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_sessions" does not exist
02:44:20,407  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_smilies" does not exist
02:44:20,407  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_smilies_seq" does not exist
02:44:20,407  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_themes" does not exist
02:44:20,407  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_themes_seq" does not exist
02:44:20,408  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_topics" does not exist
02:44:20,408  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_topics_seq" does not exist
02:44:20,408  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_topics_watch" does not exist
02:44:20,408  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_user_groups" does not exist
02:44:20,408  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_users" does not exist
02:44:20,409  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_users_seq" does not exist
02:44:20,409  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_vote_desc" does not exist
02:44:20,409  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_vote_desc_seq" does not exist
02:44:20,409  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_vote_results" does not exist
02:44:20,410  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_vote_voters" does not exist
02:44:20,410  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_words" does not exist
02:44:20,410  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_words_seq" does not exist
02:44:20,411  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_karma_seq" does not exist
02:44:20,411  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_karma" does not exist
02:44:20,411  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_bookmarks_seq" does not exist
02:44:20,411  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_bookmarks" does not exist
02:44:20,411  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_quota_limit" does not exist
02:44:20,412  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_quota_limit_seq" does not exist
02:44:20,412  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_extension_groups_seq" does not exist
02:44:20,412  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_extension_groups" does not exist
02:44:20,412  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_extensions_seq" does not exist02:44:20,413  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_extensions" does not exist
02:44:20,413  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_attach_seq" does not exist
02:44:20,413  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_attach" does not exist
02:44:20,413  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_attach_desc_seq" does not exist
02:44:20,414  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_attach_desc" does not exist
02:44:20,414  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_attach_quota_seq" does not exist
02:44:20,414  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_attach_quota" does not exist
02:44:20,414  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_banner" does not exist
02:44:20,415  INFO [InstallAction       ] IGNORE: ERROR: sequence "jforum_banner_seq" does not exist
02:44:20,415  INFO [InstallAction       ] IGNORE: ERROR: table "jforum_forums_watch" does not exist
02:44:20,416  INFO [InstallAction       ] Table creation is ok
02:44:20,416 ERROR [InstallAction       ] Error importing data for name               |    setting     |                                         description: java.sql.SQLException: Invalid query: name        |    setting     |                                         description
java.sql.SQLException: Invalid query: name               |    setting     |             description
        at net.jforum.view.install.InstallAction.importTablesData(InstallAction.java:318)
        at net.jforum.view.install.InstallAction.doInstall(InstallAction.java:183)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at net.jforum.Command.process(Command.java:117)
        at net.jforum.view.install.InstallAction.process(InstallAction.java:764)
        at net.jforum.InstallServlet.service(InstallServlet.java:140)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
        at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
        at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
        at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
        at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
        at java.lang.Thread.run(Thread.java:595)

I've tripple-checked the database, database user, and storage space and all are valid. And, no tables are being created in the database by the installer.

Any clues?

Thanks in advance!
Randy
[originally posted on jforum.net by CobbR]