[Dspace-tech] different database on the same server
Hi, I want to setup two dspace instances on the same server. These two instances should use different database, and this claims that one of the databases should not be called *dspace*. If I want to create a database with a name rather than *dspace*, which is still used by an instance of dspace, where of the src should I make a change? I niticed that there are entries in dspace.cfg about the username and password of the database, but I think leaving these two without changing will be OK. Is there anyone else did this before? Thanks Wang Jiahui - 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
Re: [Dspace-tech] Problem with indexing 1.4.2 (update)
Hi George, you should remove /usr/local/tomcat/webapps/dspace/WEB-INF/classes /usr/local/tomcat/webapps/dspace-oai/WEB-INF/classes from your CLASSPATH. dsrun sets its java environment itself, see FULLPATH=$CLASSPATH:$JARS:$DSPACEDIR/config If you got DSpace 1.3.2 in Tomcat and set the tomcat classes in the CLASSPATH they will be found and used before the DSpace jars you actually need. sunny greetings Claudia Jürgen George Kozak schrieb: Hi... This is an update to the indexing problem that I wrote about a problem with DSpace 1.4.2 When I did an index-all, I got the following error: Indexing all Items in DSpaceERROR: Relation dctyperegistry does not exist Several people suggested that I had a CLASSPATH problem. Sure enough, in my .cshrc profile in my CLASSPATH I had /usr/local/tomcat/webapps/dspace/WEB-INF/classes and /usr/local/tomcat/webapps/dspace-oai/WEB-INF/classes AND since I had compiled my 1.4.2 release BUT had not uploaded to Tomcat, yet, the classes of the old version of DSpace were being called. Thanks to all those who wrote to me. Does anyone have any ideas as to what I'm doing wrong? *** George Kozak Coordinator Web Development and Management Digital Media Group 501 Olin Library Cornell University 607-255-8924 *** [EMAIL PROTECTED] - 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 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
Re: [Dspace-tech] different database on the same server
When I changed the entry and run the fresh_install task, I got this exception: [java] 2007-09-12 21:56:24,493 FATAL org.dspace.administer.RegistryLoader @ anonymous::error_loading_registries: [java] org.postgresql.util.PSQLException: ERROR: duplicate key violates uni que constraint bitstreamformatregistry_short_description_key [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse (QueryExecutorImpl.java:1512) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults (Query ExecutorImpl.java:1297) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute (QueryExecuto rImpl.java:188) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute (AbstractJ dbc2Statement.java:437) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags( AbstractJdbc2Statement.java:353) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate (Abs tractJdbc2Statement.java:307) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUp date(DelegatingPreparedStatement.java:101) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUp date(DelegatingPreparedStatement.java:101) [java] at org.dspace.storage.rdbms.DatabaseManager.execute (DatabaseMana ger.java:1492) [java] at org.dspace.storage.rdbms.DatabaseManager.update (DatabaseManag er.java:853) [java] at org.dspace.content.BitstreamFormat.update( BitstreamFormat.jav a:588) [java] at org.dspace.administer.RegistryLoader.loadFormat (RegistryLoade r.java:214) [java] at org.dspace.administer.RegistryLoader.loadBitstreamFormats (Reg istryLoader.java:169) [java] at org.dspace.administer.RegistryLoader.main( RegistryLoader.java :107) BUILD FAILED Is there any more places I need to make a change? 2007/9/12, Mark H. Wood [EMAIL PROTECTED]: In [dspace]/config/dspace.cfg, find the property 'db.url'. That specifies which database to connect. If you're using PostgreSQL, it looks something like this: db.url = jdbc:postgresql://localhost:5432/dspace Replace dspace with the name of the database you want to use. Likewise, if you wanted to put your database(s) on a different host, you would replace localhost with the name or address of that host, and if you for some reason wanted to run PostgreSQL on a different port you'd replace 5432. You can indeed use the same username and password for all of your DSpace databases, so long as that database user is authorized for appropriate access to each of them. Whether you *should* is another question, one which only you can answer. I create separate credentials for every production DSpace instance. I have one production box with three DSpace instances, and a development-environmnent box with, oh, probably a dozen by now. I was hesitant at first, but it works well. -- Mark H. Wood, Lead System Programmer [EMAIL PROTECTED] Typically when a software vendor says that a product is intuitive he means the exact opposite. - 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 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
Re: [Dspace-tech] different database on the same server
Hello, Am 12.09.2007 um 16:03 schrieb wang jiahui: When I changed the entry and run the fresh_install task, I got this exception: [java] 2007-09-12 21:56:24,493 FATAL org.dspace.administer.RegistryLoader @ anonymous::error_loading_registries: I remember that I had this error once as well. I cant remember what the problem was but it was probably something too stupid to write down because I dont have it in my records. I guess I just removed the db, created again and ran fresh_install again, but thats not sure. Now for what I actually wanted to tell: There is a quite elaborate page in the wiki with a subject like Installing a test and a live instance on the same server or such, which describes several ways to do so with various degrees of separation (for one developer or several developers and so on), but which basically all rely on the same procedure that you try to use. I guess you will find more valuable details there. Bye, Christian - 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
Re: [Dspace-tech] different database on the same server
I attached my dspace.cfg file. Here I want to create a database named *vom*, leaving the usename and password as *dspace*. Thanks 2007/9/12, Desmond Elliott [EMAIL PROTECTED]: Could you attach your dspace.cfg please? wang jiahui wrote: When I changed the entry and run the fresh_install task, I got this exception: [java] 2007-09-12 21:56:24,493 FATAL org.dspace.administer.RegistryLoader @ anonymous::error_loading_registries: [java] org.postgresql.util.PSQLException: ERROR: duplicate key violates uni que constraint bitstreamformatregistry_short_description_key [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse (QueryExecutorImpl.java:1512) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(Query ExecutorImpl.java:1297) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecuto rImpl.java:188) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ dbc2Statement.java:437) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags( AbstractJdbc2Statement.java :353) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(Abs tractJdbc2Statement.java:307) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUp date(DelegatingPreparedStatement.java :101) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUp date(DelegatingPreparedStatement.java:101) [java] at org.dspace.storage.rdbms.DatabaseManager.execute(DatabaseMana ger.java:1492) [java] at org.dspace.storage.rdbms.DatabaseManager.update(DatabaseManag er.java:853) [java] at org.dspace.content.BitstreamFormat.update(BitstreamFormat.jav a:588) [java] at org.dspace.administer.RegistryLoader.loadFormat(RegistryLoade r.java:214) [java] at org.dspace.administer.RegistryLoader.loadBitstreamFormats(Reg istryLoader.java:169) [java] at org.dspace.administer.RegistryLoader.main (RegistryLoader.java :107) BUILD FAILED Is there any more places I need to make a change? 2007/9/12, Mark H. Wood [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]: In [dspace]/config/dspace.cfg, find the property 'db.url'. That specifies which database to connect. If you're using PostgreSQL, it looks something like this: db.url = jdbc:postgresql://localhost:5432/dspace Replace dspace with the name of the database you want to use. Likewise, if you wanted to put your database(s) on a different host, you would replace localhost with the name or address of that host, and if you for some reason wanted to run PostgreSQL on a different port you'd replace 5432. You can indeed use the same username and password for all of your DSpace databases, so long as that database user is authorized for appropriate access to each of them. Whether you *should* is another question, one which only you can answer. I create separate credentials for every production DSpace instance. I have one production box with three DSpace instances, and a development-environmnent box with, oh, probably a dozen by now. I was hesitant at first, but it works well. -- Mark H. Wood, Lead System Programmer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Typically when a software vendor says that a product is intuitive he means the exact opposite. - 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 mailto:DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- ��玫录��禄�� - 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-tec - 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.cfg Description: Binary data
Re: [Dspace-tech] different database on the same server
On Wed, Sep 12, 2007 at 10:45:19PM +0800, wang jiahui wrote: The dspace.cfg file is ought to be right since that the destination dir name is exactly what I set in the file. I can guarantee that one of three thigns are happening: 1. the database already exists with content in it (maybe from a previous install that you forgot about) 2. ant is using the incorrect dspace.cfg 3. the db.url specified in your dspace.cfg is incorrect Remember, if your new db is called dspace-foo, your dspace.cfg should have something like this: db.url = jdbc:postgresql://localhost:5432/dspace-foo cheers, Jim -- 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: 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
Re: [Dspace-tech] different database on the same server
The problem is that the fresh_install is loading the wrong (old) dspace.cfg so it's trying to connect to the existing database, so it's having problems with duplicate values. Pass the correct path to the new config by calling ant -Dconfig=/path/to/new/dspace.cfg fresh_install. Jim On Wed, Sep 12, 2007 at 04:34:46PM +0200, Christian Voelker wrote: Hello, Am 12.09.2007 um 16:03 schrieb wang jiahui: When I changed the entry and run the fresh_install task, I got this exception: [java] 2007-09-12 21:56:24,493 FATAL org.dspace.administer.RegistryLoader @ anonymous::error_loading_registries: I remember that I had this error once as well. I cant remember what the problem was but it was probably something too stupid to write down because I dont have it in my records. I guess I just removed the db, created again and ran fresh_install again, but thats not sure. Now for what I actually wanted to tell: There is a quite elaborate page in the wiki with a subject like Installing a test and a live instance on the same server or such, which describes several ways to do so with various degrees of separation (for one developer or several developers and so on), but which basically all rely on the same procedure that you try to use. I guess you will find more valuable details there. Bye, Christian - 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 -- 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: 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
Re: [Dspace-tech] different database on the same server
The dspace.cfg file is ought to be right since that the destination dir name is exactly what I set in the file. And sorry for the duplicate message. 2007/9/12, James Rutherford [EMAIL PROTECTED]: The problem is that the fresh_install is loading the wrong (old) dspace.cfg so it's trying to connect to the existing database, so it's having problems with duplicate values. Pass the correct path to the new config by calling ant -Dconfig=/path/to/new/dspace.cfg fresh_install. Jim On Wed, Sep 12, 2007 at 04:34:46PM +0200, Christian Voelker wrote: Hello, Am 12.09.2007 um 16:03 schrieb wang jiahui: When I changed the entry and run the fresh_install task, I got this exception: [java] 2007-09-12 21:56:24,493 FATAL org.dspace.administer.RegistryLoader @ anonymous::error_loading_registries: I remember that I had this error once as well. I cant remember what the problem was but it was probably something too stupid to write down because I dont have it in my records. I guess I just removed the db, created again and ran fresh_install again, but thats not sure. Now for what I actually wanted to tell: There is a quite elaborate page in the wiki with a subject like Installing a test and a live instance on the same server or such, which describes several ways to do so with various degrees of separation (for one developer or several developers and so on), but which basically all rely on the same procedure that you try to use. I guess you will find more valuable details there. Bye, Christian - 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 -- 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: 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
Re: [Dspace-tech] different database on the same server
Hi Wang, in the config file you attached the name of the db in the db.url is wrong. Supposing you created a database called vom owned by the user dspace the line db.url = jdbc:postgresql://localhost:5432/dspace should be db.url = jdbc:postgresql://localhost:5432/vom Furthermore in the dspace.cfg you provided you must fill in dspace.url dspace.hostname mail.server and the mail addresses with the correct values for your installation hope that helps Claudia wang jiahui schrieb: I attached my dspace.cfg file. Here I want to create a database named *vom*, leaving the usename and password as *dspace*. Thanks 2007/9/12, Desmond Elliott [EMAIL PROTECTED]: Could you attach your dspace.cfg please? wang jiahui wrote: When I changed the entry and run the fresh_install task, I got this exception: [java] 2007-09-12 21:56:24,493 FATAL org.dspace.administer.RegistryLoader @ anonymous::error_loading_registries: [java] org.postgresql.util.PSQLException: ERROR: duplicate key violates uni que constraint bitstreamformatregistry_short_description_key [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse (QueryExecutorImpl.java:1512) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(Query ExecutorImpl.java:1297) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecuto rImpl.java:188) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ dbc2Statement.java:437) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags( AbstractJdbc2Statement.java :353) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(Abs tractJdbc2Statement.java:307) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUp date(DelegatingPreparedStatement.java :101) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUp date(DelegatingPreparedStatement.java:101) [java] at org.dspace.storage.rdbms.DatabaseManager.execute(DatabaseMana ger.java:1492) [java] at org.dspace.storage.rdbms.DatabaseManager.update(DatabaseManag er.java:853) [java] at org.dspace.content.BitstreamFormat.update(BitstreamFormat.jav a:588) [java] at org.dspace.administer.RegistryLoader.loadFormat(RegistryLoade r.java:214) [java] at org.dspace.administer.RegistryLoader.loadBitstreamFormats(Reg istryLoader.java:169) [java] at org.dspace.administer.RegistryLoader.main (RegistryLoader.java :107) BUILD FAILED Is there any more places I need to make a change? 2007/9/12, Mark H. Wood [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]: In [dspace]/config/dspace.cfg, find the property 'db.url'. That specifies which database to connect. If you're using PostgreSQL, it looks something like this: db.url = jdbc:postgresql://localhost:5432/dspace Replace dspace with the name of the database you want to use. Likewise, if you wanted to put your database(s) on a different host, you would replace localhost with the name or address of that host, and if you for some reason wanted to run PostgreSQL on a different port you'd replace 5432. You can indeed use the same username and password for all of your DSpace databases, so long as that database user is authorized for appropriate access to each of them. Whether you *should* is another question, one which only you can answer. I create separate credentials for every production DSpace instance. I have one production box with three DSpace instances, and a development-environmnent box with, oh, probably a dozen by now. I was hesitant at first, but it works well. -- Mark H. Wood, Lead System Programmer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Typically when a software vendor says that a product is intuitive he means the exact opposite. - 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 mailto:DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- ��玫录��禄�� - 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-tec - This SF.net email is
[Dspace-tech] Internal server errors on My DSpace pages
Hi all. We have been having some problems with pages in the My DSpace area of our repository. We haven't been able to reproduce the problem through navigating My DSpace, but it will occur when we link directly to one of the pages. An example is below, but we have found that a similar error occurs when we visit other pages such as perform-task.jsp, preview-task.jsp. An internal server error occurred on http://images.swinburne.edu.au: Date: 9/2/07 10:53 PM Session ID: 13841C924E857E80CF960BD3D9BE4464 -- URL Was: http://images.swinburne.edu.au/mydspace/subscriptions.jsp -- Method: HEAD -- Parameters were: Exception: java.lang.NullPointerException at org.apache.jsp.mydspace.subscriptions_jsp._jspService(subscriptions_jsp.java:83) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675) at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) Any help with this would be appreciated. Thanks, Shaun. Swinburne University of Technology CRICOS Provider Code: 00111D NOTICE This e-mail and any attachments are confidential and intended only for the use of the addressee. They may contain information that is privileged or protected by copyright. If you are not the intended recipient, any dissemination, distribution, printing, copying or use is strictly prohibited. The University does not warrant that this e-mail and any attachments are secure and there is also a risk that it may be corrupted in transmission. It is your responsibility to check any attachments for viruses or defects before opening them. If you have received this transmission in error, please contact us on +61 3 9214 8000 and delete it immediately from your system. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. Please consider the environment before printing this email. - 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
Re: [Dspace-tech] different database on the same server
Thank you all, and sorry for this stupid mistake. 2007/9/12, Claudia Jürgen [EMAIL PROTECTED]: Hi Wang, in the config file you attached the name of the db in the db.url is wrong. Supposing you created a database called vom owned by the user dspace the line db.url = jdbc:postgresql://localhost:5432/dspace should be db.url = jdbc:postgresql://localhost:5432/vom Furthermore in the dspace.cfg you provided you must fill in dspace.url dspace.hostname mail.server and the mail addresses with the correct values for your installation hope that helps Claudia wang jiahui schrieb: I attached my dspace.cfg file. Here I want to create a database named *vom*, leaving the usename and password as *dspace*. Thanks 2007/9/12, Desmond Elliott [EMAIL PROTECTED]: Could you attach your dspace.cfg please? wang jiahui wrote: When I changed the entry and run the fresh_install task, I got this exception: [java] 2007-09-12 21:56:24,493 FATAL org.dspace.administer.RegistryLoader @ anonymous::error_loading_registries: [java] org.postgresql.util.PSQLException: ERROR: duplicate key violates uni que constraint bitstreamformatregistry_short_description_key [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse (QueryExecutorImpl.java:1512) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults (Query ExecutorImpl.java:1297) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute (QueryExecuto rImpl.java:188) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute (AbstractJ dbc2Statement.java:437) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags ( AbstractJdbc2Statement.java :353) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate (Abs tractJdbc2Statement.java:307) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUp date(DelegatingPreparedStatement.java :101) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUp date(DelegatingPreparedStatement.java:101) [java] at org.dspace.storage.rdbms.DatabaseManager.execute (DatabaseMana ger.java:1492) [java] at org.dspace.storage.rdbms.DatabaseManager.update (DatabaseManag er.java:853) [java] at org.dspace.content.BitstreamFormat.update( BitstreamFormat.jav a:588) [java] at org.dspace.administer.RegistryLoader.loadFormat (RegistryLoade r.java:214) [java] at org.dspace.administer.RegistryLoader.loadBitstreamFormats (Reg istryLoader.java:169) [java] at org.dspace.administer.RegistryLoader.main ( RegistryLoader.java :107) BUILD FAILED Is there any more places I need to make a change? 2007/9/12, Mark H. Wood [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]: In [dspace]/config/dspace.cfg, find the property 'db.url'. That specifies which database to connect. If you're using PostgreSQL, it looks something like this: db.url = jdbc:postgresql://localhost:5432/dspace Replace dspace with the name of the database you want to use. Likewise, if you wanted to put your database(s) on a different host, you would replace localhost with the name or address of that host, and if you for some reason wanted to run PostgreSQL on a different port you'd replace 5432. You can indeed use the same username and password for all of your DSpace databases, so long as that database user is authorized for appropriate access to each of them. Whether you *should* is another question, one which only you can answer. I create separate credentials for every production DSpace instance. I have one production box with three DSpace instances, and a development-environmnent box with, oh, probably a dozen by now. I was hesitant at first, but it works well. -- Mark H. Wood, Lead System Programmer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Typically when a software vendor says that a product is intuitive he means the exact opposite. - 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 mailto:DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- ��玫录��禄�� - 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/