Dspace-1.8.2 Installation on Centos-6.3

Add DSpace User in your System

root@localhost nurahammad~]#useradd dspace

Install prerequisite software

root@localhost nurahammad~]# yum install java-1.6.0-openjdk -y

root@localhost nurahammad~]# yum install tomcat6

root@localhost nurahammad~]# yum install postgresql postgresql-server postgresql-contrib

root@localhost nurahammad~]# service postgresql initdb

root@localhost nurahammad~]# yum install ant ant-nodeps

[root@localhost nurahammad]# /etc/init.d/postgresql start

Configure Postgres to listen localhost

[root@localhost nurahammad]# nano /var/lib/pgsql/data/postgresql.conf

listen_addresses = ‘localhost’ # what IP address(es) to listen on;

[root@localhost nurahammad]# nano /var/lib/pgsql/data/pg_hba.conf

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:

host dspace dspace 127.0.0.1/32 trust

# “local” is for Unix domain socket connections only

local all all trust

Manually Download maven and Install. Maven is not in Default Centos-6.3 source

[root@localhost nurahammad~]# wget http://mirrors.ispros.com.bd/apache/maven/maven-3/3.0.4/binaries/apache-maven-3.0.4-bin.tar.gz

[root@localhost nurahammad]# tar -zxvf apache-maven-3.0.4-bin.tar.gz

[root@localhost nurahammad]# mv apache-maven-3.0.4 /usr/local

[root@localhost nurahammad]# cd /usr/local/

[root@localhost local]# ln -s apache-maven-3.0.4 maven

[root@localhost local]# nano /etc/profile

export M2_HOME=/usr/local/maven

export PATH=${M2_HOME}/bin:${PATH}

Create Database user and Database for DSpace

[root@localhost nurahammad]# su postgres

bash-4.1$ createuser -U postgres -d -A -P dspace

bash-4.1$ exit

[root@localhost nurahammad]# su dspace

[dspace@localhost nurahammad]$ createdb -U dspace -E UNICODE dspace

Download DSpace and configure

[root@localhost nurahammad]# wget http://garr.dl.sourceforge.net/project/dspace/DSpace%20Stable/1.8.2/dspace-1.8.2-src-release.tar.gz

[root@localhost nurahammad]# tar -zxvf dspace-1.8.2-src-release.tar.gz

[root@localhost nurahammad]# cd dspace-1.8.2-src-release/dspace

[root@localhost dspace]#nano config/dspace.cfg

Build DSpace

[root@localhost dspace]# mvn package

Install DSpace

[root@localhost dspace]# cd target/dspace-1.8.2-build/

[root@localhost dspace-1.8.2-build]# ant fresh_install

[echo]

[echo] ====================================================================

[echo] The DSpace code has been installed, and the database initialized.

[echo]

[echo] To complete installation, you should do the following:

[echo]

[echo] * Setup your Web servlet container (e.g. Tomcat) to look for your

[echo] DSpace web applications in: /dspace/webapps/

[echo]

[echo] OR, copy any web applications from /dspace/webapps/ to

[echo] the appropriate place for your servlet container.

[echo] (e.g. ‘$CATALINA_HOME/webapps’ for Tomcat)

[echo]

[echo] * Make an initial administrator account (an e-person) in DSpace:

[echo]

[echo] /dspace/bin/dspace create-administrator

[echo]

[echo] * Start up your servlet container (Tomcat etc.)

[echo]

[echo] You should then be able to access your DSpace’s ‘home page’:

[echo]

[echo] http://localhost:8080/xmlui

[echo]

[echo] You should also be able to access the administrator UI:

[echo]

[echo] http://localhost:8080/xmlui/dspace-admin

[echo] ====================================================================

[echo]

BUILD SUCCESSFUL

Total time: 1 minute 46 seconds

[root@localhost dspace-1.8.2-build]# nano /etc/tomcat6/server.xml

  Change this section
<Host name=”localhost”  appBase=”webapps”
unpackWARs=”true” autoDeploy=”true”
xmlValidation=”false” xmlNamespaceAware=”false”>

As the following
<Host name=”localhost”  appBase=”/dspace/webapps”
unpackWARs=”true” autoDeploy=”true”
xmlValidation=”false” xmlNamespaceAware=”false”>

Then create DSpace Administrator account

[root@localhost dspace-1.8.2-build]# /dspace/bin/dspace create-administrator

Creating an initial administrator account

E-mail address: nurahammad@iub.edu.bd

First name: Nur

Last name: Ahammad

WARNING: Password will appear on-screen.

Password:Password

Again to confirm: Password

Is the above data correct? (y or n): y

Administrator account created

Set Permission and ownership for DSpace

[root@localhost nurahammad]#chmod -R 755 /home/dspace/

[root@localhost nurahammad]#chown -R dspace:dspace /home/dspace/

Finally you can get your Dsapce by pointing the address in your web browser:

http://localhsot:8080/xmlui

OR

http://localhost:8080/jspui

12 thoughts on “Dspace-1.8.2 Installation on Centos-6.3

  1. Nur vai,How can we install dspace and koha in a same Operating system in same pc? Have any advise from you?

  2. when i execute this commande
    [root@localhost dspace-1.8.2-build]# ant fresh_install

    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:981)
    [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:68)
    [java] 2013-03-14 02:25:09,206 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: relation “mrc_result_fk_idx” already exists
    [java] org.postgresql.util.PSQLException: ERROR: relation “mrc_result_fk_idx” already exists
    [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:981)
    [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:68)
    [java] 2013-03-14 02:25:09,211 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: relation “checksum_history” already exists
    [java] org.postgresql.util.PSQLException: ERROR: relation “checksum_history” already exists
    [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:981)
    [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:68)
    [java] 2013-03-14 02:25:09,213 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: relation “ch_result_fk_idx” already exists
    [java] org.postgresql.util.PSQLException: ERROR: relation “ch_result_fk_idx” already exists
    [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:981)
    [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:68)
    [java] 2013-03-14 02:25:09,216 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “checksum_results_pkey”
    [java] org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “checksum_results_pkey”
    [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:981)
    [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:68)
    [java] 2013-03-14 02:25:09,218 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “checksum_results_pkey”
    [java] org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “checksum_results_pkey”
    [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:981)
    [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:68)
    [java] 2013-03-14 02:25:09,219 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “checksum_results_pkey”
    [java] org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “checksum_results_pkey”
    [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:981)
    [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:68)
    [java] 2013-03-14 02:25:09,220 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “checksum_results_pkey”
    [java] org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “checksum_results_pkey”
    [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:981)
    [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:68)
    [java] 2013-03-14 02:25:09,222 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “checksum_results_pkey”
    [java] org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “checksum_results_pkey”
    [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:981)
    [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:68)
    [java] 2013-03-14 02:25:09,223 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “checksum_results_pkey”
    [java] org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “checksum_results_pkey”
    [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:981)
    [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:68)
    [java] 2013-03-14 02:25:09,224 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “checksum_results_pkey”
    [java] org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “checksum_results_pkey”
    [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:981)
    [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:68)
    [java] 2013-03-14 02:25:09,228 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “checksum_results_pkey”
    [java] org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “checksum_results_pkey”
    [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:981)
    [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:68)
    [java] 2013-03-14 02:25:09,230 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “checksum_results_pkey”
    [java] org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “checksum_results_pkey”
    [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:981)
    [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:68)
    [java] 2013-03-14 02:25:09,232 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: relation “harvested_collection” already exists
    [java] org.postgresql.util.PSQLException: ERROR: relation “harvested_collection” already exists
    [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:981)
    [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:68)
    [java] 2013-03-14 02:25:09,233 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: relation “harvested_collection_fk_idx” already exists
    [java] org.postgresql.util.PSQLException: ERROR: relation “harvested_collection_fk_idx” already exists
    [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:981)
    [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:68)
    [java] 2013-03-14 02:25:09,235 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: relation “harvested_item” already exists
    [java] org.postgresql.util.PSQLException: ERROR: relation “harvested_item” already exists
    [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:981)
    [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:68)
    [java] 2013-03-14 02:25:09,236 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: relation “harvested_item_fk_idx” already exists
    [java] org.postgresql.util.PSQLException: ERROR: relation “harvested_item_fk_idx” already exists
    [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:981)
    [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:68)
    [java] 2013-03-14 02:25:09,758 INFO org.dspace.core.ConfigurationManager @ Loading system provided config property (-Ddspace.configuration): config/dspace.cfg
    [java] 2013-03-14 02:25:09,769 INFO org.dspace.core.ConfigurationManager @ Using default log4j provided log configuration,if unintended, check your dspace.cfg for (log.init.config)
    [java] Started: 1363253109753
    [java] Ended: 1363253110178
    [java] Elapsed time: 0 secs (425 msecs)

    load_registries:
    [java] 2013-03-14 02:25:10,477 INFO org.dspace.core.ConfigurationManager @ Loading system provided config property (-Ddspace.configuration): config/dspace.cfg
    [java] 2013-03-14 02:25:10,482 INFO org.dspace.core.ConfigurationManager @ Using default log4j provided log configuration,if unintended, check your dspace.cfg for (log.init.config)
    [java] 2013-03-14 02:25:10,957 FATAL org.dspace.administer.RegistryLoader @ anonymous::error_loading_registries:
    [java] org.postgresql.util.PSQLException: ERROR: syntax error at or near “RETURNING”
    [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
    [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
    [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
    [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    [java] at org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1755)
    [java] at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:675)
    [java] at org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:451)
    [java] at org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:403)
    [java] at org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:172)
    [java] at org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:138)
    [java] at org.dspace.administer.RegistryLoader.main(RegistryLoader.java:75)
    [java] Error:
    [java] – ERROR: syntax error at or near “RETURNING”

    BUILD FAILED
    /root/dspace-1.8.2-src-release/dspace/target/dspace-1.8.2-build/build.xml:826: Java returned: 1

    Total time: 4 seconds
    [root@localhost dspace-1.8.2-build]#

Leave a comment