Sounds like the database was not properly created when you ran "ant
fresh_install", do you have a listing of the tables in your database?
-Mark
On Sep 30, 2008, at 11:37 AM, Nigel Pegus wrote:
Hello,
Ive recently installed dspace 1.5 on RHL enterprise v3 update 6. I
am unable to move past the basic install as the system generates an
internal server error.
My dspace log file indicates :
2008-09-30 10:21:29,989 WARN org.dspace.jsp @
anonymous:session_id=444B5F767AF01373ABBDA3109F9FF881:ip_addr=127.0.0.
1:database_error:org.postgresql.util.PSQLException: ERROR: relation
"community" does not exist
org.postgresql.util.PSQLException: ERROR: relation "community" does
not exist
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse
(QueryExecutorImpl.java:1531)
at org.postgresql.core.v3.QueryExecutorImpl.processResults
(QueryExecutorImpl.java:1313)
at org.postgresql.core.v3.QueryExecutorImpl.execute
(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute
(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags
(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery
(AbstractJdbc2Statement.java:258)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery
(DelegatingPreparedStatement.java:93)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery
(DelegatingPreparedStatement.java:93)
at org.dspace.storage.rdbms.DatabaseManager.queryTable
(DatabaseManager.java:169)
at org.dspace.content.Community.findAllTop(Community.java:286)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:104)
at org.apache.jasper.runtime.HttpJspBase.service
(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service
(JspServletWrapper.java:384)
at org.apache.jasper.servlet.JspServlet.serviceJspFile
(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service
(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:228)
at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service
(CoyoteAdapter.java:216)
at org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol
$Http11ConnectionHandler.process(Http11Protocol.java:634)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run
(JIoEndpoint.java:445)
at java.lang.Thread.run(Thread.java:619)
and the postgres log file contains:
LOG: received smart shutdown request
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2008-09-30 10:19:57 AST
LOG: checkpoint record is at 0/42D064
LOG: redo record is at 0/42D064; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 0/606; next OID: 16386
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system is ready
ERROR: relation "community" does not exist
STATEMENT: SELECT * FROM community WHERE NOT community_id IN
(SELECT child_comm_id FROM community2community) ORDER BY name
I have tried
-removing the data folder and recreating it along with the database
-ensure dspace.cfg file includes proper entries
-ensuring postgres.conf listen_address=localhost entry is uncommented
-pg_hba.conf has dspace entry added
-adding another jdbc driver to lib folder (/…/dspace-1.5.1-src-
release/dspace/target/dspace-1.5.1-build.dir/lib)
I am assuming this is some sort of database setup error. Is there
something I have overlooked?
Thanks for any input
Nigel
Nigel Pegus
Systems Unit
The Main Library
The University of the West Indies
6622002x2241
----------------------------------------------------------------------
---
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK & win
great prizes
Grand prize is a trip for two to an Open Source event anywhere in
the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
~~~~~~~~~~~~~
Mark R. Diggory
Home Page: http://purl.org/net/mdiggory/homepage
Blog: http://purl.org/net/mdiggory/blog
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
