Re: [Dspace-tech] database error dspace 1.5
Thanks for the input, I deleted my data , dspace install and dspace-source folders then recreated database and re-installed dspace this time the system works as expected. Nigel From: Mark Diggory [mailto:[EMAIL PROTECTED] On Behalf Of Mark Diggory Sent: Tuesday, September 30, 2008 10:57 PM To: Nigel Pegus Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] database error dspace 1.5 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(QueryExecu torImpl.java:1531) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp l.java:1313) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java: 188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme nt.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb c2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St atement.java:258) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat ingPreparedStatement.java:93) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat ingPreparedStatement.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.ja va: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(Applica tionFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:228) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.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:2 16) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:84 4) 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
[Dspace-tech] database error dspace 1.5
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(QueryExecu torImpl.java:1531) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp l.java:1313) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java: 188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme nt.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb c2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St atement.java:258) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat ingPreparedStatement.java:93) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat ingPreparedStatement.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.ja va: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(Applica tionFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:228) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.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:2 16) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:84 4) 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=100url=/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] cannot select e-person
From: Nigel Pegus Sent: Thursday, June 05, 2008 10:07 AM To: 'dspace-tech@lists.sourceforge.net' Subject: cannot select e-person I thought I would add some recent observations to my issue... I have restored my Main Server to its unedited state, however this is the current situation: 1) If you attempt to select an eperson for editing in Internet Explorer an error message is displayed in lower left hand corner of browser. These are the details of that error message It indicates the following : Line 56 Char 5 Error. 'window.document.forms.2.eperson_id' is null or not an object 2) If a Mozilla Firefox browser is used to access the restored dspace instance the error DOES NOT occur. 3) On another server that has the edited JSP pages, the forms entry in Utils.js are edited (as described in prior posting to tech-list) the server works initially in BOTH Mozilla AND Internet Explorer when editing/selecting epersons but will then fail after a period of time despite NO changes being made to the server.. I hope that sheds some more light on this phenomena. Thanks for any input, Nigel -Original Message- From: Nigel Pegus Sent: Thursday, June 05, 2008 8:53 AM To: 'Glenn Bunton' Subject: RE: [Dspace-tech] cannot select e-person Thanks for the input, I tried a quick fix of that forms issue by manually changing all the form[0] entries to form[1] in my header.jsp. Problem is that it works initially but after about 1 to 2 hrs the error returns I can't see any reason for this to happen... some sort of cashing issue?? Thanks, Nigel -Original Message- From: Glenn Bunton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2008 4:44 PM To: Nigel Pegus Subject: Re: [Dspace-tech] cannot select e-person Hi Nigel, I'm not sure if this will help but we have somewhat similar problems when we first started using dspace. I learned that it had to do with the location of form items on that page. We had customized the page and put some code at the top for a search box. We had to take it back out because I learned the eperson form items have to be the highest level form items on the page locationally in order to work. Don't ask me why because I don't know. If you did some customization and added some other form items on your eperson jsp pages that might be a place to look. Good luck. == Mr. Glenn Bunton Head of Systems Development Old Dominion University Libraries Norfolk, Virginia 23529 [EMAIL PROTECTED] (757) 683-5952 === Nigel Pegus [EMAIL PROTECTED] uwi.edu To Sent by: dspace-tech@lists.sourceforge.net dspace-tech-bounc cc [EMAIL PROTECTED] rge.net Subject [Dspace-tech] cannot select e-person 06/04/2008 04:34 PM Hello, I am unable to select e-persons on my dspace 1.4.1 servers. I have read short term solution suggestions and attempted them both - 1) ensuring java script entry for utils.js is present and I have not included any further references to java scripts 2) I edited the utils.js file and changed all window.document.forms[0] references to window.document.forms[1] this seamed to solve the problem but for a limited time only. The selection of e-persons problem appears to start once you edit the default-header.jsp. As such I have only been able to restore normal access to epersons by restoring all the edited Jsps or ensuring that I edit window.document.forms[0] as indicated above (but this option does not solve the problem permanently, as e-persons are no longer accessible after a while despite no changes being made to the server). Does anyone have any experience with this problem persisting beyond the suggested fixes?? Nigel Pegus Systems Unit The Main Library The University of the West Indies 6622002x2241 - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace
[Dspace-tech] cannot select e-person
Hello, I am unable to select e-persons on my dspace 1.4.1 servers. I have read short term solution suggestions and attempted them both - 1) ensuring java script entry for utils.js is present and I have not included any further references to java scripts 2) I edited the utils.js file and changed all window.document.forms[0] references to window.document.forms[1] this seamed to solve the problem but for a limited time only. The selection of e-persons problem appears to start once you edit the default-header.jsp. As such I have only been able to restore normal access to epersons by restoring all the edited Jsps or ensuring that I edit window.document.forms[0] as indicated above (but this option does not solve the problem permanently, as e-persons are no longer accessible after a while despite no changes being made to the server). Does anyone have any experience with this problem persisting beyond the suggested fixes?? Nigel Pegus Systems Unit The Main Library The University of the West Indies 6622002x2241 - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Unplanned user access
Hi Mike, Possibly I have been experimenting with users advancing to the point where they can click on the open button for a specific item but the system would then bar entry AFTER clicking the open button (had I gone further). I would have assumed that they had access to the item having gotten by stages where they would normally be presented with the login screen or authorization required prompt I will try to recreate the circumstances and verify what in fact has been happening. Thanks again, Nigel -Original Message- From: Michael White [mailto:[EMAIL PROTECTED] Sent: Monday, May 26, 2008 11:28 AM To: Nigel Pegus Cc: dspace-tech@lists.sourceforge.net Subject: RE: Unplanned user access Hi Nigel, my concern is that unprivileged users accessing the item form the outside will in certain cases get access to restricted content In my experience I don't think this can happen - even if I'm looking at a cached version of a page that seems to suggest I'm logged on when I'm not, as soon as I click to try and access protected content, the authentication/authorisation bits of DSpace kick in and start looking for a valid authentication context - as this context isn't actually there (despite what the cached version of the page is telling me), I can't get access to the protected content . . . and see themselves logged in as a privileged user... Again, I don't *think* this can happen - as Christophe pointed out, it's not DSpace that is serving a cached version of the page, but the browser reusing a locally cached version - so a user will only see themselves logged on if they (or someone else) has previously logged on to the system, and then logged off again, in the same browser session . . . I've certainly not heard of anything like the scenarios you describe actually happening - the problems I hear about are usually the other way around - I've had numerous enquiries from our workflow staff relating to things like the Edit button not being visible on an item view page - these are always problems relating to a cached version of the item view page - they access an item page, then subsequently log on and go back to that page, but don't get access to the admin features (the give away is always the absence of the Logged in as message). Hope that helps. Mike Michael White eLearning Developer Centre for eLearning Development (CeLD) S7, The Library University of Stirling Stirling SCOTLAND FK9 4LA Email: [EMAIL PROTECTED] Tel: +44 (0) 1786 466877 Fax: +44 (0) 1786 466880 http://www.is.stir.ac.uk/celd/ -- The University of Stirling (a charity registered in Scotland, number SC 011159) is a university established in Scotland by charter at Stirling, FK9 4LA. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not disclose, copy or deliver this message to anyone and any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Unplanned user access
Mike, Thanks for your input. I haven't had any other responses yet so I'm assuming this is not something that has happened allot. I tried what you suggested and it does work! (ctrl refresh brings up correct status of page) but my concern is that unprivileged users accessing the item form the outside will in certain cases get access to restricted content and see themselves logged in as a privileged user... Thanks again for your input, Nigel -Original Message- From: Michael White [mailto:[EMAIL PROTECTED] Sent: Monday, May 26, 2008 9:47 AM To: Nigel Pegus Cc: dspace-tech@lists.sourceforge.net Subject: Re: Unplanned user access Hi Nigel, You wrote: While experimenting with groups and restricting user access to various collections I noted that it is possible to log out the system then attempt to access an item in a collection which is not normally publicly accessible. The system will indicated that the user that created the item is logged in one instance and in another similar experiment a user who was made part of a group with the required access rights will then appear as logged on thus allowing the unprivileged user access to the item. Has anyone encountered this before?? Not sure if you got a response to this as I've been off for a while so doing a very high speed trawl through a couple of weeks worth of various mailing lists . . . Anyway, this may or may not be related, but one thing that still catches me out occasionally is the caching of DSpace pages - we have an embargo feature implemented that only allows admins access to embargoed items. If I log on as Admin, access a restricted item's Simple Metadata page (from where I can open the item), log out, then revisit the item display page I find that is says that I'm still logged on (my email address shows in the top left even though I've logged out and the link to the item is still displayed) - however, this is just a cached version of the page, and if I attempt to open the item, I get (correctly) taken to our You can't access this item but you can request it from the original depositor page . . . Whenever I encounter something like this (appearing to be logged on when I don't think I am, or vice versa), I use Ctrl-refresh (hold down the Ctrl key whilst clicking the browser refresh) and that forces the page to completely reload (rather than using the cached version). As I say, may not be related to what you're experiencing, but thought I'd mention it just in case :-) Regards, Mike Michael White eLearning Developer Centre for eLearning Development (CeLD) S7, The Library University of Stirling Stirling SCOTLAND FK9 4LA Email: [EMAIL PROTECTED] Tel: +44 (0) 1786 466877 Fax: +44 (0) 1786 466880 http://www.is.stir.ac.uk/celd/ http://www.is.stir.ac.uk/celd/ -- The University of Stirling (a charity registered in Scotland, number SC 011159) is a university established in Scotland by charter at Stirling, FK9 4LA. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not disclose, copy or deliver this message to anyone and any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Backup Failure
Hello all, I am running dspace 1.4.1 on linux enterprise Version 3 update 6 have just tried copying the data folder and assetstore folder form my test server to the production server to test a Backup procedure. I am now unable to start the postgres database. I Backed up the original production data and assetstore folders then deleted them and copied over the test server ones, I noted that I had to re assign the assetstore to the dspace user as the root user for some reason came up as the owner after the copy. I Also had to make the postgres user the owner of the data folder again. Now when I return to the original data and assetstore folders I get the same error... I get this error when trying to start postgres database: pg_ctl: another server may be running; trying to start server anyway pg_ctl: could not start server Examine the log output. Also I am unable to locate the postgres log file, this is my postgres start up command /usr/local/pgsql/bin/pg_ctl -D /dbdata/data -l logfile start Can anyone point me in the direction of the postgres logfile? The dspace log file reflects what looks like two general errors (Ive pasted them below) when trying to run cronjobs for checksum / filter media / DailyReportEmailer I'm not sure what cronjob is generating the errors, but of course these errors are in response to my moving the data and assetstore folders coupled with root taking ownership of the folders. I am now unclear as to why I cannot restart postgres even after restoring the original folders and ensuring the original owners are assigned. Does anyone have any input on this issue?? Thanks, Nigel 2008-02-12 20:00:08,121 WARN org.dspace.jsp @ anonymous:session_id=F3F09DDEDAC04171EF9B9991C178C8EA:ip_addr=192.168.25 4.3:database_error:org.postgresql.util.PSQLException: ERROR: could not open relation 1663/16386/1259: Permission denied org.postgresql.util.PSQLException: ERROR: could not open relation 1663/16386/1259: Permission denied at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu torImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp l.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java: 191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme nt.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb c2Statement.java:337) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St atement.java:236) at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getPrimaryKeys(Abstra ctJdbc2DatabaseMetaData.java:2941) at org.dspace.storage.rdbms.DatabaseManager.retrieveColumnInfo(DatabaseMana ger.java:1530) at org.dspace.storage.rdbms.DatabaseManager.getColumnInfoInternal(DatabaseM anager.java:1498) at org.dspace.storage.rdbms.DatabaseManager.getColumnInfo(DatabaseManager.j ava:890) at org.dspace.storage.rdbms.DatabaseManager.getColumnNames(DatabaseManager. java:963) at org.dspace.storage.rdbms.DatabaseManager.process(DatabaseManager.java:12 23) at org.dspace.storage.rdbms.TableRowIterator.next(TableRowIterator.java:151 ) at org.dspace.content.Community.findAllTop(Community.java:275) at org.apache.jsp.index_jsp._jspService(index_jsp.java:92) 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.ja va: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(Applica tionFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:228) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.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:2 16) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:84 4) 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:595) Nigel
Re: [Dspace-tech] Backup Failure
Hello again Jeff I have been experimenting with the grep command on my test server and production server. The command to start the database seams to execute but when I check for a process ID I do not get one for postmaster and I verified there is no postmaster.pid file in data this time. Is there another step I am missing to restart the database?? Thanks again, Nigel From: Jeffrey Trimble [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 13, 2008 2:33 PM To: Nigel Pegus Subject: Re: [Dspace-tech] Backup Failure Nigel, You have a postmaster.pid file that needs to be deleted. Delete it and start your postgres. Things should return to normal --jeff Jeffrey Trimble Systems Librarian Maag Library Youngstown State University 330-941-2483 (Office) [EMAIL PROTECTED] http://www.maag.ysu.edu http://digital.maag.ysu.edu On Feb 13, 2008, at 1:21 PM, Nigel Pegus wrote: Hello all, I am running dspace 1.4.1 on linux enterprise Version 3 update 6 have just tried copying the data folder and assetstore folder form my test server to the production server to test a Backup procedure. I am now unable to start the postgres database. I Backed up the original production data and assetstore folders then deleted them and copied over the test server ones, I noted that I had to re assign the assetstore to the dspace user as the root user for some reason came up as the owner after the copy. I Also had to make the postgres user the owner of the data folder again. Now when I return to the original data and assetstore folders I get the same error... I get this error when trying to start postgres database: pg_ctl: another server may be running; trying to start server anyway pg_ctl: could not start server Examine the log output. Also I am unable to locate the postgres log file, this is my postgres start up command /usr/local/pgsql/bin/pg_ctl -D /dbdata/data -l logfile start Can anyone point me in the direction of the postgres logfile? The dspace log file reflects what looks like two general errors (Ive pasted them below) when trying to run cronjobs for checksum / filter media / DailyReportEmailer I'm not sure what cronjob is generating the errors, but of course these errors are in response to my moving the data and assetstore folders coupled with root taking ownership of the folders. I am now unclear as to why I cannot restart postgres even after restoring the original folders and ensuring the original owners are assigned. Does anyone have any input on this issue?? Thanks, Nigel 2008-02-12 20:00:08,121 WARN org.dspace.jsp @ anonymous:session_id=F3F09DDEDAC04171EF9B9991C178C8EA:ip_addr=192.168.25 4.3:database_error:org.postgresql.util.PSQLException: ERROR: could not open relation 1663/16386/1259: Permission denied org.postgresql.util.PSQLException: ERROR: could not open relation 1663/16386/1259: Permission denied at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu torImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp l.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java: 191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme nt.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb c2Statement.java:337) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St atement.java:236) at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getPrimaryKeys(Abstra ctJdbc2DatabaseMetaData.java:2941) at org.dspace.storage.rdbms.DatabaseManager.retrieveColumnInfo(DatabaseMana ger.java:1530) at org.dspace.storage.rdbms.DatabaseManager.getColumnInfoInternal(DatabaseM anager.java:1498) at org.dspace.storage.rdbms.DatabaseManager.getColumnInfo(DatabaseManager.j ava:890) at org.dspace.storage.rdbms.DatabaseManager.getColumnNames(DatabaseManager. java:963) at org.dspace.storage.rdbms.DatabaseManager.process(DatabaseManager.java:12 23) at org.dspace.storage.rdbms.TableRowIterator.next(TableRowIterator.java:151 ) at org.dspace.content.Community.findAllTop(Community.java:275) at org.apache.jsp.index_jsp._jspService(index_jsp.java:92) 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.ja va: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(Applica tionFilterChain.java:290
Re: [Dspace-tech] Handle Server fails to connect on dspace 1.4.1
Hello Yin, I have a system with an internal IP mapped to an external IP both of which CNRI are aware of(we had a test server that worked fine..). The prefix entry seams fine in config file and it doesn't look like there any hanging java threads.. The version of Java I used conflicted with a default java that came with our O/S originally but that was solved by making an entry in the Environmental Variables I am thinking about changing the java now... I have included below an entry I noticed in the handle-server error log when I start the handle-server. There is no notification of an error otherwise... I am wandering what socket closed is referring to.? Thanks again for any input Nigel 2008/01/04 02:52:47 GMT 25 Started new run. Saving global values to: /root/.handle/root_info 2008/01/04 02:52:48 GMT 50 unspecified max_handlers count, using default: 200 2008/01/04 02:52:48 GMT 50 unspecified max_handlers count, using default: 200 2008/01/04 02:52:48 GMT 50 unspecified max_handlers count, using default: 200 2008/01/04 02:52:56 GMT 25 Shutting down server at Fri Jan 04 14:52:56 GMT 2008 Error (java.lang.ThreadDeath) writing class net.handle.server.HdlTcpInterface: Error handling request: java.net.SocketException: Socket closed to error log. 2008/01/04 02:52:56 GMT 75 class net.handle.server.HdlHttpInterface: Error handling request: java.net.SocketException: Socket closed java.net.SocketException: Socket closed at java.net.PlainSocketImpl.socketAccept(Native Method) at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:384) at java.net.ServerSocket.implAccept(ServerSocket.java:450) at java.net.ServerSocket.accept(ServerSocket.java:421) at net.handle.server.HdlTcpInterface.serveRequests(HdlTcpInterface.java:155 ) at net.handle.server.NetworkInterface.run(NetworkInterface.java:150) at java.lang.Thread.run(Thread.java:595) ~ -Original Message- From: Yin Latt [mailto:[EMAIL PROTECTED] Sent: Thursday, January 03, 2008 6:19 PM To: dspace-tech@lists.sourceforge.net Cc: Nigel Pegus Subject: RE: DSpace-tech Digest, Vol 21, Issue 3 Hi Nigel, 1. Do you have different IP address for external and internal firewall? Here is some info for handle installation http://www.linuxtraining.org.uk/blogger.html#two 2. When you edit prefix in dspace.cfg, please make sure there is no extra space or hidden character behind your handle prefix (2139) 3. Checking any java hanging process that was left by your previous stop/start of your handle server. Hope this will help. Cheers, Yin Yin Digital Services University of Auckland Library Phone +64-9-3737599 Ext 88251 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, 3 January 2008 9:21 a.m. To: dspace-tech@lists.sourceforge.net Subject: DSpace-tech Digest, Vol 21, Issue 3 Send DSpace-tech mailing list submissions to dspace-tech@lists.sourceforge.net 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. Re: Handle Server fails to connect on dspace 1.4.1 (Nigel Pegus) 2. not displaying all three questions on Submit:Describe this Item (Maike Dulk) -- Message: 1 Date: Wed, 2 Jan 2008 14:06:45 -0400 From: Nigel Pegus [EMAIL PROTECTED] Subject: Re: [Dspace-tech] Handle Server fails to connect on dspace 1.4.1 To: Claudia J?rgen [EMAIL PROTECTED] Cc: dspace-tech@lists.sourceforge.net Message-ID: [EMAIL PROTECTED] Content-Type: text/plain; charset=iso-8859-1 Hello and Happy New Yr to you too Claudia :) I edited dspace.cfg but could not get make-handle-config to run so I ran command dspace/bin/dsrun net.handle.server.SimpleSetup /dspace/handle-server which was listed in older instructions to create the handle server config..that worked... then started server with command dspace/bin/dsrun net.handle.server.Main /dspace/handle-server. I sent the new sitebndl to CNRI and they updated our records. They are getting a cannot connect error but we have verified the ports 2641 and 8000 are open so we are at somewhat of a standstill on options.. Thanks for your response, Nigel -Original Message- From: Claudia J?rgen [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 02, 2008 12:30 PM To: Nigel Pegus Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Handle Server fails to connect on dspace 1.4.1 Hi Nigel, first a Happy New Year. So you edited dspace.cfg to include the handle prefix and then ran dspace]/bin/make-handle-config and started the handle
Re: [Dspace-tech] Handle Server fails to connect on dspace 1.4.1
Hello and Happy New Yr to you too Claudia :) I edited dspace.cfg but could not get make-handle-config to run so I ran command dspace/bin/dsrun net.handle.server.SimpleSetup /dspace/handle-server which was listed in older instructions to create the handle server config..that worked... then started server with command dspace/bin/dsrun net.handle.server.Main /dspace/handle-server. I sent the new sitebndl to CNRI and they updated our records. They are getting a cannot connect error but we have verified the ports 2641 and 8000 are open so we are at somewhat of a standstill on options.. Thanks for your response, Nigel -Original Message- From: Claudia Jürgen [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 02, 2008 12:30 PM To: Nigel Pegus Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Handle Server fails to connect on dspace 1.4.1 Hi Nigel, first a Happy New Year. So you edited dspace.cfg to include the handle prefix and then ran dspace]/bin/make-handle-config and started the handle server with [dspace]/bin/start-handle-server. Did you register the sitebndl.zip with http://hdl.handle.net/4263537/5014 after you ran make-handle-config? Claudia Nigel Pegus schrieb: Hi Hello, I have confirmed that ports 2641 and 8000 had been opened.. Telnet is off on my Linux system but I can connect to the system using ssh and a program called putty. I'm assuming the ports are therefore not an issue. Tried running the handle update prefix script also, even though the prefix was already correct and we hadn't made any entries prior to setting up handle server(I had edited the config file in advance with our pre existing prefix from our test server). Any more insight will be greatly appreciated Thanks for your input Nigel -Original Message- From: Graham Triggs [mailto:[EMAIL PROTECTED] Sent: Monday, December 24, 2007 1:16 PM To: Nigel Pegus Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Handle Server fails to connect on dspace 1.4.1 Hi, Can you telnet to that machine / ports - both from the machine itself, from the wider network, and from the even wider internet? Then you'll know if there is a firewall / port binding issue, which would be the most obvious / easiest to resolve problem. Next, check that you actually have handles with the correct prefix in the database - if you've got old items prior to receiving a prefix, you have to ensure that they are migrated to the prefix (/dspace/bin/update-handle-prefix). G Nigel Pegus wrote: Hello all, I am running dspace 1.4.1 on Linux Enterprise AS v3 update6 I originally had a problem setting up the handle server with the provided script, having gotten around that (I ran command /dspace/bin/dsrun net.handle.server.Main /dspace/handle-server instead of /dspace/bin/make-handle-config) I am unable to resolve any handles. I have updated my config.dct with the required entries (see contents below). I noted that I had to create the storage_type and storage_class entries as opposed to just filling in the appropriate vals after the = sign and wandered if that is a sign of a setup problem on my end... To the best of my knowledge ports 2641 and 8000 are opened to the wider internet. Is there something I have overlooked? num_threads = 15 bind_port = 2641 backlog = 5 log_accesses = yes } log_save_config = { log_save_weekday = N/A log_save_time = 02:00:00 log_save_directory = /dspace/handle-server/logs log_save_interval = Monthly } no_udp_resolution = y interfaces = ( hdl_udp hdl_tcp hdl_http ) server_config = { server_admins = ( 300:0.NA/2139 ) replication_admins = ( 300:0.NA/2139 ) max_session_time = 8640 this_server_id = 1 max_auth_time = 6 backup_admins = ( 300:0.NA/2139 ) case_sensitive = no storage_type = CUSTOM storage_class = org.dspace.handle.HandlePlugin } } Thanks for any input, **/Nigel Pegus/** **/Main Library, Systems Unit/** **/The University of the West Indies/** **/ext: 2241/** - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech This email has been scanned by Postini. For more information please visit http://www.postini.com - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go
[Dspace-tech] Handle Server fails to connect on dspace 1.4.1
Hello all, I am running dspace 1.4.1 on Linux Enterprise AS v3 update6 I originally had a problem setting up the handle server with the provided script, having gotten around that (I ran command /dspace/bin/dsrun net.handle.server.Main /dspace/handle-server instead of /dspace/bin/make-handle-config) I am unable to resolve any handles. I have updated my config.dct with the required entries (see contents below). I noted that I had to create the storage_type and storage_class entries as opposed to just filling in the appropriate vals after the = sign and wandered if that is a sign of a setup problem on my end... To the best of my knowledge ports 2641 and 8000 are opened to the wider internet. Is there something I have overlooked? num_threads = 15 bind_port = 2641 backlog = 5 log_accesses = yes } log_save_config = { log_save_weekday = N/A log_save_time = 02:00:00 log_save_directory = /dspace/handle-server/logs log_save_interval = Monthly } no_udp_resolution = y interfaces = ( hdl_udp hdl_tcp hdl_http ) server_config = { server_admins = ( 300:0.NA/2139 ) replication_admins = ( 300:0.NA/2139 ) max_session_time = 8640 this_server_id = 1 max_auth_time = 6 backup_admins = ( 300:0.NA/2139 ) case_sensitive = no storage_type = CUSTOM storage_class = org.dspace.handle.HandlePlugin } } Thanks for any input, Nigel Pegus Main Library, Systems Unit The University of the West Indies ext: 2241 - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Handle Server install error dspace 1.4.1
Hello, I have recently installed dspace 1.4.1 on Linux AS version 3 update 6 with Java 1.5.0, apache ant 1.7.0 and postgresql-8.2.3. I have also made and verified required entries in dspace.cfg file (handle prefix and handle server directory path). To setup the Handle Server using simple setup Writing simple Handle server configuration I run the following command: ./make-handle-config I then get the following error: Error setting up the server: java.lang.NullPointerException java.lang.NullPointerException at net.handle.server.SimpleSetup.responseToPrompt(SimpleSetup.java:930) at net.handle.server.SimpleSetup.getIPAddress(SimpleSetup.java:572) at net.handle.server.SimpleSetup.main(SimpleSetup.java:96) ./make-handle-config: line 90: /dspace/handle-server/config.dct: No such file or directory ./make-handle-config: line 99: /tmp/handleconfig6179: No such file or directory The dspace/handle-server folder is empty and the dspace handle server log has only this entry: Error reading configuration: java.io.FileNotFoundException: /dspace/handle-server/config.dct (No such file or directory) From older installations I think the handle-server folder is then populated with numerous entries, one of which is the config.dct file so I do not think this is really an issue I may be wrong but I suspect that Java is not working as it should for some reason and creating the config.dct file Can anyone offer any input on the cause/solution to the error indicated above? Thanks, Nigel Pegus Main Library, Systems Unit The University of the West Indies ext: 2241 - SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech