Hi!
I followed the following steps for 2 tier dspace implementation.
(1) In pg_hba.confg I gave
# TYPE DATABASE USER CIDR-ADDRESS METHOD
host all all 155.69.24.194/32 md5
(2) In Postgresql.confg I gave
listen_addresses = '*'
(3) when "ant fresh_install" was given from client machine, the DB
connection error was not seen but build was not successful. I just
copied the war files to Tomcat webapp folder. Accessing and browsing
items was fine. But submitting a new item gives an internal error. Since
I have not properly build DSpace, the log file was not seen. I am
attaching the command line output when I execute "ant fresh_install".
The error starts with "PSQLException: ERROR: function "getnextid"
already exists with same argument types". Please suggest.
Thanks,
Jayan
Buildfile: build.xml
compile:
install_code:
build_wars:
init_configs:
setup_database:
[java] 2007-04-02 15:15:16,344 INFO
org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
[java] 2007-04-02 15:15:16,359 INFO
org.dspace.core.ConfigurationManager @ DSpace logging installed using
log4j.properties
[java] 2007-04-02 15:15:16,531 WARN
org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception:
org.postgresql.util.PSQLException: ERROR: function "getnextid" already
exists with same argument types
[java] org.postgresql.util.PSQLException: ERROR: function
"getnextid" already exists with same argument types
[java] at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu
torImpl.java:1548)
[java] at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp
l.java:1316)
[java] at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
191)
[java] at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:452)
[java] at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:337)
[java] at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:329)
[java] at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.
java:261)
[java] at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.
java:261)
[java] at
org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:11
36)
[java] at
org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java
:71)
[java] 2007-04-02 15:15:16,531 WARN
org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception:
org.postgresql.util.PSQLException: ERROR: relation
"bitstreamformatregistry_seq" already exists
[java] org.postgresql.util.PSQLException: ERROR: relation
"bitstreamformatregistry_seq" already exists
[java] at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu
torImpl.java:1548)
[java] at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp
l.java:1316)
[java] at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
191)
[java] at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:452)
[java] at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:337)
[java] at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:329)
[java] at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.
java:261)
[java] at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.
java:261)
[java] at
org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:11
36)
[java] at
org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java
:71)
[java] 2007-04-02 15:15:16,531 WARN
org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception:
org.postgresql.util.PSQLException: ERROR: relation "fileextension_seq"
already exists
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
