[Logo] JForum - Powering Communities
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Top Downloads] Top Downloads   [Groups] Back to home page 
[Register] Register /  [Login] Login 


JForum 2.8.3 is out with various fixes and improvements. Read all about it here

Jforum 2.3.3 and Postgresql 9.1.3 RSS feed
Forum Index » Integration Forum
Author Message
nihilist


Joined: 2012/5/15
Messages: 8
Offline
Hello everybody,

I'm stuck with an error while starting Jforum when linked with a Posgresql database.
Here is the error when accessing the URL http://localhost/jforum-2.3.3/forums/list.page (tomcat web server):
java.lang.NullPointerException

java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source)
net.jforum.ConfigLoader.loadDaoImplementation(ConfigLoader.java:216)
net.jforum.JForum.startApplication(JForum.java:329)
net.jforum.JForum.init(JForum.java:112)


Prior to that, I migrate my database from Oracle to Postgres so I dont need to make a fresh install. I checked all my configuration files but didn't find anything.
SystemGlobals.properties:
# Database type to use

database.driver.name = postgresql


postgresql.properties:
#Sun Jul 26 12:58:14 CST 2009

dao.driver=net.jforum.dao.postgresql.PostgresqlDataAccessDriver
database.driver.name=postgresql
database.connection.driver=org.postgresql.Driver
database.connection.string=jdbc\:postgresql\://${database.connection.host}\:${database.connection.port}/${database.connection.dbname}?user\=${database.connection.username}&password\=${database.connection.password}
database.connection.host=xx.xx.xx.xx
database.connection.port=1531
database.connection.dbname=postgres
database.connection.username=OWN_JFORUM
database.connection.password=XXXXXXXXXX
database.connection.pool.min=5
database.connection.pool.max=50
database.connection.pool.timeout=5000
database.support.autokeys=false
database.support.subqueries=true
dbencoding=utf-8


jforum-custom.conf:
#Installation specific configuration options

#Tue May 15 14:26:04 CEST 2012
container.app=Apache Tomcat
container.version=7
forum.link=http\://localhost/jforum-2.3.3
homepage.link=http\://localhost
i18n.board.default=fr_FR
installed=true
search.indexing.enabled=true


Can someone help me solve this issue?

thanks
nihilist


Joined: 2012/5/15
Messages: 8
Offline
ok, my bad... in fact the Migration Tool Kit included with postgres does not understand "sysdate" properties so he fail to copy table, and especialy JFORUM_USERS.
andowson


Joined: 2011/6/30
Messages: 252
Online
If you do manual installation of JForum 2.3.3 (and earlier version), you need to copy the content of postgresql.properties into jforum-custom.conf.

And this issue has been reported and fixed as issue 31.
nihilist


Joined: 2012/5/15
Messages: 8
Offline
Thanks for the reply !
 
Forum Index » Integration Forum
Go to:   
Mobile view
Powered by JForum 2.8.3 © 2023 JForum Team • Maintained by Andowson Chang and Ulf Dittmer