You can get more information in the log file by setting the log level to DEBUG in dspace/config/log4j.properties
log4j.rootCategory=DEBU, A1 Once you restart tomcat you should see log lines showing SQL statement info. Look for lines DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query … My hunch in your case is that you may not have defined a Group in your Database (via the admin UI) with the name you use in the authentication configuration file dspace/config/modules/authentication-ip.cfg. For each ip.GROUPNAME = …. you must create a corresponding group in the database with the same name. Monika ________________ Monika Mevenkamp phone: 609-258-4161 Lewis Library,Washington Road and Ivy Lane, Princeton University, Princeton, NJ 08544 On Apr 1, 2014, at 4:50 AM, Pushkin Salim <pushkinsa...@gmail.com<mailto:pushkinsa...@gmail.com>> wrote: We have dspace 4.0 , and configured IP authentication and request copy. When "request copy" is used, following error is shown. "Internal server error. The system has experienced an internal error. please try to do what you were doing again......" Log 2014-04-01 15:12:59,460 INFO org.dspace.app.webui.servlet.RequestItemServlet @ anonymous:session_id=45BC90E0D2370BE3BF50E93255A9E245:ip_addr=10.10.48.91:show_requestItem_form:problem=false 2014-04-01 15:13:10,188 WARN org.dspace.app.webui.servlet.DSpaceServlet @ anonymous:session_id=45BC90E0D2370BE3BF50E93255A9E245:ip_addr=10.10.48.91:database_error:org.postgresql.util.PSQLException\colon; ERROR\colon; syntax error at or near ")" Position\colon; 27 org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 27 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1754) at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:671) at org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:447) at org.dspace.app.webui.util.RequestItemManager.getNewToken(RequestItemManager.java:83) at org.dspace.app.webui.util.RequestItemManager.getLinkTokenEmail(RequestItemManager.java:127) at org.dspace.app.webui.servlet.RequestItemServlet.processForm(RequestItemServlet.java:242) at org.dspace.app.webui.servlet.RequestItemServlet.doDSGet(RequestItemServlet.java:83) at org.dspace.app.webui.servlet.RequestItemServlet.doDSPost(RequestItemServlet.java:119) at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:115) at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:73) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:701) Any help? Thanks S.Pushkin CSIR - NIIST ------------------------------------------------------------------------------ _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net<mailto:DSpace-tech@lists.sourceforge.net> https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
------------------------------------------------------------------------------
_______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette