[Dspace-tech] Postgres install

[Kevin Weekes]

Good day,
I am in the process of following a dspace installation

I've gone thru the steps for the installation of the pre-requisite software
and they all appear fine.

However, when I try the ant fresh_install command I run into some
difficulties.
The message I get basically is that I can't connect to the database.

I find this odd as the relevant changes were made to the pg_hba and
postgresql.conf files in the /var/lib directory

Can anyone shed some light on my predicament

[Jim Downing]

Hi Kevin,

Which linux distribution are you using. The config files in most
distributions live in /etc/postgresql/ - it's possible you've been
editing the sample config files.

If you still have problems we'll need more detail - exact wording of the
error message and any stack trace, and whether you followed the
instructions to the letter or have made tweaks.

jim

[Jörn Nettingsmeier]

did you restart postgres after changing the config?
it might help to post the relevant lines from your postgres config
files, and the output of netstat -lpn.




--
Jörn Nettingsmeier, EDV-Administrator
Institut für Politikwissenschaft
Universität Duisburg-Essen, Standort Duisburg
Mail: pol-...@uni-duisburg.de, Telefon: 0203/379-2736

[Kevin Weekes]

-----Original Message-----
From: Kevin Weekes
Sent: Thursday, July 29, 2004 12:39 PM
To: 'Jörn Nettingsmeier'
Subject: RE: [Dspace-tech] Postgres install


Thanks everyone for the insights.

I am getting a new error message though:


[dspace@localhost dspace-1.1.1-source]$ ant fresh_install
Buildfile: build.xml
...
setup_database:
[java] 2004-07-28 16:20:00,689 INFO
org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database



load_registries:
[java] 2004-07-28 16:20:13,760 FATAL
org.dspace.administer.RegistryLoader @
anonymous:no_context:error_loading_registries:
[java] java.sql.SQLException: ERROR: SET AUTOCOMMIT TO OFF is no
longer supported

[java] at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
[java] at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection
.java:482)
[java] at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection
.java:461)
[java] at
org.postgresql.jdbc1.AbstractJdbc1Connection.setAutoCommit(AbstractJdbc1Conn
ection.java:957)
[java] at
org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnect
ion.java:237)
[java] at org.dspace.core.Context.<init>(Context.java:103)
[java] at
org.dspace.administer.RegistryLoader.main(RegistryLoader.java:102)



BUILD FAILED
/usr/ds3rdPT/dspace-1.1.1-source/build.xml:258: Java returned: 1

Total time: 1 minute 9 seconds"

I'm a bit new to the whole Linux environment but I'm learning,

Thanks in advance.

[Stuve, David H]

Tricky problem Kevin,

We don't actually issue the 'SET AUTOCOMMIT TO OFF' in our code that I can find, it looks like we only use the JDBC connection.setAutoCommit(false). The most likely cause of your problem is that your database may be a newer version than your driver (postgresql.jar) (in version 7.4 Postgres stopped supporting the above command, but earlier drivers didn't know that and would issue the command.)

Since you're using DSpace 1.1.1 (please plan on upgrading soon. ;-) I bet we bundled the 7.3 driver and it conflicts with your 7.4 installation of Postgres. Try getting the latest postgres driver by downloading it or copying it from your postgres directory if you compiled it yourself, and put it in the lib directory of your 1.1.1 source. Or wait a couple of days and upgrade to 1.2!

Dave

-------------------------------------------------------
This SF.Net email is sponsored by OSTG. Have you noticed the changes on Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, one more big change to announce. We are now OSTG- Open Source Technology Group. Come see the changes on the new OSTG site. www.ostg.com _______________________________________________
DSpace-tech mailing list
DSpac...@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Kevin Weekes]

:D
Thanks David.

I'm continuing to investigate what's really going on with the driver.

And oh yea! Most definitely, I'm waiting patiently for the next stable
release.

Regards,
Kevin A. Weekes.

[Kevin Weekes]

Hey All,
I've managed to resolve the installation issues I faced.

Unfortunately, I had overlooked the co-existence of an older postgres jdbc
driver.
After removing the older postgres jdbc driver, the install worked fine.