[Dspace-general] RE: [Dspace-tech] Postgres install

[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

-----Original Message-----
From: dspace-tech-admin at lists.sourceforge.net [mailto:dspace-tech-admin at lists.sourceforge.net] On Behalf Of Kevin Weekes
Sent: Thursday, July 29, 2004 11:43 AM
To: dspace-general at mit.edu; dspace-tech at lists.sourceforge.net
Subject: FW: [Dspace-tech] Postgres install




-----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 at 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.

-----Original Message-----
From: Jörn Nettingsmeier [mailto:pol-admin at uni-duisburg.de]
Sent: Monday, July 26, 2004 8:04 AM
To: Kevin Weekes
Cc: 'dspace-tech at lists.sourceforge.net'
Subject: Re: [Dspace-tech] Postgres install


Kevin Weekes wrote:
> 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

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-admin at uni-duisburg.de, Telefon: 0203/379-2736


-------------------------------------------------------
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
DSpace-tech at lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech