Hy, You need the Postgres >= 8.2 I had to install the postgresql84 and postgresql84-server
Sorry my poor english. Good luck, Gleise On 02/04/2011 11:18 AM, Lennert Holvoet wrote: > Hello, > > while trying to install DSpace 1.7 on CentOS 5.5 I keep having problems > while running 'ant fresh_install' > > Installed prerequisites: > Ant 1.8.2 - Maven 3.0.2 - Tomcat 7.0.6 - JDK 6u21 - Postgres 8.1 > > This is the output I get: > > [dspace@dp1356-03 dspace-1.7.0-build.dir]$ ant fresh_install > > Buildfile: > > /usr/local/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir/build.xml > > init_installation: > > init_configs: > > test_database: > > [java] 2011-02-03 06:31:51,399 INFO > > org.dspace.core.ConfigurationManager @ Loading system provided config > > property (-Ddspace.configuration): config/dspace.cfg > > [java] 2011-02-03 06:31:51,418 INFO > > org.dspace.core.ConfigurationManager @ Using default log4j provided log > > configuration,if unintended, check your dspace.cfg for (log.init.config) > > [java] > > [java] Attempting to connect to database: > > [java] - URL: jdbc:postgresql://localhost:5432/dspace > > [java] - Driver: org.postgresql.Driver > > [java] - Username: dspace > > [java] - Password: duserd > > [java] - Schema: null > > [java] > > [java] Testing connection... > > [java] Connected successfully! > > [java] > > setup_database: > > [java] 2011-02-03 06:31:52,455 INFO > > org.dspace.core.ConfigurationManager @ Loading system provided config > > property (-Ddspace.configuration): config/dspace.cfg > > [java] 2011-02-03 06:31:52,476 INFO > > org.dspace.core.ConfigurationManager @ Using default log4j provided log > > configuration,if unintended, check your dspace.cfg for (log.init.config) > > [java] 2011-02-03 06:31:52,476 INFO > > org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database > > [java] 2011-02-03 06:31:54,045 INFO > > org.dspace.core.ConfigurationManager @ Loading system provided config > > property (-Ddspace.configuration): config/dspace.cfg > > [java] 2011-02-03 06:31:54,062 INFO > > org.dspace.core.ConfigurationManager @ Using default log4j provided log > > configuration,if unintended, check your dspace.cfg for (log.init.config) > > [java] Started: 1296732714038 > > [java] Ended: 1296732714354 > > [java] Elapsed time: 0 secs (316 msecs) > > load_registries: > > [java] 2011-02-03 06:31:55,251 INFO > > org.dspace.core.ConfigurationManager @ Loading system provided config > > property (-Ddspace.configuration): config/dspace.cfg > > [java] 2011-02-03 06:31:55,268 INFO > > org.dspace.core.ConfigurationManager @ Using default log4j provided log > > configuration,if unintended, check your dspace.cfg for (log.init.config) > > [java] Error: > > [java] - ERROR: syntax error at or near "RETURNING" > > [java] 2011-02-03 06:31:55,779 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) > > BUILD FAILED > > /usr/local/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir/build.xml:809: > > Java returned: 1 > > Total time: 6 seconds > > [dspace@dp1356-03 dspace-1.7.0-build.dir]$ > > > (same output in text file: > http://dl.dropbox.com/u/1075783/DB-UHasselt/ant_error) > > Is it possible to help me finish this DSpace installation? > I hope I have provided enough information. > > Kind Regards > Lennert Holvoet > > Hasselt University Library > lennert.holv...@uhasselt.be > > ------------------------------------------------------------------------------ > The modern datacenter depends on network connectivity to access resources > and provide services. The best practices for maximizing a physical server's > connectivity to a physical network are well understood - see how these > rules translate into the virtual world? > http://p.sf.net/sfu/oracle-sfdevnlfb > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech > > -- Atenciosamente, ------------------------------- Gleise S. O. Teixeira Analista de TI DC - UFSCar 3351-8590 ------------------------------- -- Checked by MailScanner ------------------------------------------------------------------------------ The modern datacenter depends on network connectivity to access resources and provide services. The best practices for maximizing a physical server's connectivity to a physical network are well understood - see how these rules translate into the virtual world? http://p.sf.net/sfu/oracle-sfdevnlfb _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech