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:
OR
Heya i’m for the first time here. I found this board and I find It really useful & it helped me out a lot. I hope to give something back and aid others like you aided me.
Welcome to my blog
Nur vai,How can we install dspace and koha in a same Operating system in same pc? Have any advise from you?
Please explain what type of difficulties are facing?
hola, realice todos los pasos exitosamente, pero al final al tratar de acceder a http://localhost:8080/jspui o http://localhost:8080/xmlui no puedo, me dice que NO SE PUEDE CONECTAR, no se si me podrias decir la razón, gracias 😀
p.d. muy buen tutorial, gracias 😛
Please write in English
Please explain what type of difficulties are you facing for installing koha and DSpace in same PC?
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]#
Try with creating new DSpace database. First delete your previous Dspace database then create new datbase.
Delete your old database and create new one then try