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/vse0120000070mrt/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/vse0120000070mrt/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/vse0120000070mrt/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/vse0120000070mrt/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/vse0120000070mrt/direct/01/
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
