Wednesday, I noted that following the directions to modify the Oracle database schema didn't succeed. In trying to actually run the application, I am getting Oracle database errors, such as the following from the DEBUG dspace.log. The Oracle database is on a different server than Dspace (if that makes any difference) and my question is, and how exactly should I go about correctly modifying the schema to support 1.4.2? Help, please?
2007-06-14 10:24:01,789 DEBUG org.dspace.app.webui.servlet.DSpaceServlet @ anony mous:session_id=10A8FC192584AD4492DAB59FAE579200:ip_addr=128.125.69.171: http_req uest:-- URL Was: http://cassandra.usc.edu:8180/dspace/forgot -- Method: POST -- Parameters were: -- email: "[EMAIL PROTECTED]" -- step: "1" -- submit: "I Forgot My Password" 2007-06-14 10:24:01,805 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "select * from EPERSON where email = ? " 2007-06-14 10:24:02,461 INFO org.dspace.app.webui.servlet.RegisterServlet @ ano nymous:session_id=10A8FC192584AD4492DAB59FAE579200:ip_addr=128.125.69.17 1:sendto ken_forgotpw:[EMAIL PROTECTED] 2007-06-14 10:24:02,480 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "select * from REGISTRATIONDATA where email = ? " 2007-06-14 10:24:02,722 WARN org.dspace.app.webui.servlet.DSpaceServlet @ anony mous:session_id=10A8FC192584AD4492DAB59FAE579200:ip_addr=128.125.69.171: database _error:java.sql.SQLException: ORA-02289: sequence does not exist java.sql.SQLException: ORA-02289: sequence does not exist at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java: 830) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav a:2391) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:2672) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java: 572) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt atement.java:205) Brian A. Helstien, SISD, MLS, Director, Special Technologies Initiatives, IDM, University Libraries x06913 University of Southern California, (213) 740-6913 Los Angeles, California, 90089 [EMAIL PROTECTED] Information is independent of media or format -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, June 14, 2007 12:19 PM To: [email protected] Subject: DSpace-tech Digest, Vol 14, Issue 30 Send DSpace-tech mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/dspace-tech or, via email, send a message with subject or body 'help' to [EMAIL PROTECTED] You can reach the person managing the list at [EMAIL PROTECTED] When replying, please edit your Subject line so it is more specific than "Re: Contents of DSpace-tech digest..." Today's Topics: 1. Postgres Error--MAJOR BOO BOO (Jeffrey Trimble) 2. Re: Postgres Error--MAJOR BOO BOO (James Rutherford) ---------------------------------------------------------------------- Message: 1 Date: Thu, 14 Jun 2007 12:25:44 -0400 From: Jeffrey Trimble <[EMAIL PROTECTED]> Subject: [Dspace-tech] Postgres Error--MAJOR BOO BOO To: [email protected] Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset="us-ascii"; format=flowed Okay, Not to get into the gory details, but here's what I'm getting when I start postgres: Starting PostgreSQL: /usr/local/pgsql/bin/pg_ctl: error while loading shared lib raries: libreadline.so.4: cannot open shared object file: No such file or direct ory Is something missing? Any ideas? TIA, Jeffrey A. Trimble Systems Librarian Youngstown State University Youngstown, OH [EMAIL PROTECTED] (330) 941-2483 http://digital.maag.ysu.edu http://www.maag.ysu.edu http://jupiter.ysu.edu ------------------------------ Message: 2 Date: Thu, 14 Jun 2007 17:32:54 +0100 From: James Rutherford <[EMAIL PROTECTED]> Subject: Re: [Dspace-tech] Postgres Error--MAJOR BOO BOO To: Jeffrey Trimble <[EMAIL PROTECTED]> Cc: [email protected] Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=us-ascii You'll probably find that you updated libreadline and now that shared object is no longer available because it's now called libreadline.so.5. It usually lives in /lib. Do you have any libreadline.so* in /lib? Your package management system shouldn't have let this happen, and it's probably worth filing a bug report unless you've installed any of these components by hand. It's hard to propose a fix without knowing more details about your system. cheers, Jim On Thu, Jun 14, 2007 at 12:25:44PM -0400, Jeffrey Trimble wrote: > Okay, Not to get into the gory details, but here's what I'm getting > when I start > postgres: > > Starting PostgreSQL: /usr/local/pgsql/bin/pg_ctl: error while loading > shared lib > raries: libreadline.so.4: cannot open shared object file: No such file > or direct ory > > Is something missing? Any ideas? > > TIA, > > > Jeffrey A. Trimble > Systems Librarian > Youngstown State University > Youngstown, OH > [EMAIL PROTECTED] > (330) 941-2483 > http://digital.maag.ysu.edu > http://www.maag.ysu.edu > http://jupiter.ysu.edu > > > > > ---------------------------------------------------------------------- > --- This SF.net email is sponsored by DB2 Express Download DB2 Express > C - the FREE version of DB2 express and take control of your XML. No > limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech -- James Rutherford | Hewlett-Packard Limited registered Office: Research Engineer | Cain Road, HP Labs | Bracknell, Bristol, UK | Berks +44 117 312 7066 | RG12 1HN. [EMAIL PROTECTED] | Registered No: 690597 England The contents of this message and any attachments to it are confidential and may be legally privileged. If you have received this message in error, you should delete it from your system immediately and advise the sender. To any recipient of this message within HP, unless otherwise stated you should consider this message and attachments as "HP CONFIDENTIAL". ------------------------------ ------------------------------------------------------------------------ - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ------------------------------ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech End of DSpace-tech Digest, Vol 14, Issue 30 ******************************************* ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
