This in a full installation looks something like this -
dspace=> select count(*) from bitstreamformatregistry;
count
-------
73
(1 row)
......................................
so I would suggest you to do clean_database and then do a
setup_database and finally load_registries step by step.. I understand
that this actually means re-installing the database.. and re-loading
data.
I would have gone for dropping the database itself and restart as in
above lines..
And I also hope that you have mentioned all the diectory related
information correctly in your dspace.sfg file..Anyways this should not
be a problem.
ant help
Buildfile: build.xml
help:
[echo]
[echo] DSpace configuration file
[echo] -----------------------------------
[echo]
[echo] Available targets are:
[echo]
[echo] update --> Update installed code and web
applications without
[echo] touching your config or data
[echo] update_code --> Update compiled code (bin, lib, and
etc directories)
[echo] update_webapps --> Update web applications
[echo]
[echo] init_configs --> Write the configuration files to /dspace/config
[echo] install_code --> Install compiled code into /dspace
[echo]
[echo] fresh_install --> Perform a fresh installation of the software,
[echo] including the databases & config
[echo] setup_database --> Create database tables
[echo] load_registries --> Load metadata & file format registries into the
[echo] database
[echo]
[echo] clean_database --> Remove DSpace database tables, destroying data
[echo]
[echo]
[echo] Available parameters are:
[echo]
[echo] -Dconfig=<path/to/dspace.cfg> -- Where your dspace.cfg
configuration
[echo] is located
[echo] -Dwars=true -- Build .war files when updating web
[echo] applications
[echo]
On 3/28/08, George Vernon <[EMAIL PROTECTED]> wrote:
> Not quite. I get:
>
> dspace_test=> \dt bitstreamregistry
> No matching relations found.
> dspace_test=> \d
> dspace_test=> \dt bitstreamformatregistry
> List of relations
> Schema | Name | Type | Owner
> --------+-------------------------+-------+-------------
> public | bitstreamformatregistry | table | dspace_test
> (1 row)
>
> dspace_test=> \d bitstreamformatregistry
> Table "public.bitstreamformatregistry"
> Column | Type | Modifiers
> ---------------------+------------------------+-----------
> bitstream_format_id | integer | not null
> mimetype | character varying(256) |
> short_description | character varying(128) |
> description | text |
> support_level | integer |
> internal | boolean |
> Indexes:
> "bitstreamformatregistry_pkey" PRIMARY KEY, btree (bitstream_format_id)
> "bitstreamformatregistry_short_description_key" UNIQUE, btree
> (short_description)
>
> dspace_test=> select * from bitstreamformatregistry;
> bitstream_format_id | mimetype | short_description | description |
> support_level | internal
> ---------------------+----------+-------------------+-------------+---------------+----------
> (0 rows)
>
>
>
> ________________________________________
> From: Vishal Kakapuri [EMAIL PROTECTED]
> Sent: 28 March 2008 10:12
> To: Mark Diggory
> Cc: George Vernon; DSpace-tech@lists.sourceforge.net
> Subject: Re: [Dspace-tech] 1.5 install
>
> static String canonicalize(String column){static String
> canonicalize(String column){
> if ("oracle".equals(ConfigurationManager.getProperty("db.name")))
> {
> // oracle requires uppercase
> return column.toUpperCase();
> }
> // postgres default lowercase
> 611 - return column.toLowerCase();
> }
>
> I guess somehow your column is coming null for "bitstreamformatregistry"
> Do you data something like this in this table:
>
>
> dspace=> \dt bitstreamformatregistry
> List of relations
> Schema | Name | Type | Owner
> --------+-------------------------+-------+--------
> public | bitstreamformatregistry | table | dspace
> (1 row)
>
> dspace=> \d bitstreamformatregistry
> Table "public.bitstreamformatregistry"
> Column | Type | Modifiers
> ---------------------+------------------------+-----------
> bitstream_format_id | integer | not null
> mimetype | character varying(256) |
> short_description | character varying(128) |
> description | text |
> support_level | integer |
> internal | boolean |
> Indexes:
> "bitstreamformatregistry_pkey" PRIMARY KEY, btree (bitstream_format_id)
> "bitstreamformatregistry_short_description_key" UNIQUE, btree
> (short_description)
>
> dspace=> select * from bitstreamformatregistry;
> bitstream_format_id | mimetype
> | short_description
> | description
> | support_level | internal
> ---------------------+---------------------------------------------------------------------------+---------------------------
> ---------+----------------------------------------------------------------------+---------------+----------
> 1 | application/octet-stream
> | Unknown
> | Unknown data format
> | 0 | f
> 2 | text/plain
> | License
> | Item-specific license agreed upon to submission
> | 1 | t
> 3 | application/pdf
> | Adobe PDF
> .................
> .................
>
> Regards,
> Vishal
>
>
> On 3/28/08, Mark Diggory <[EMAIL PROTECTED]> wrote:
> > Hello George,
> >
> > I just ran a test on my workstation to do a fresh install of DSpace
> > 1.5.0 and was successful. So I suspect it is something with your
> > environment/configuration. Can you give me more detail about your
> > setup (database version, OS)? Are those 4 tables the only ones
> > created? there should be 40.
> >
> > Cheers,
> > Mark
> >
> >
> > On Mar 27, 2008, at 9:13 AM, George Vernon wrote:
> >
> > > Trying a test install and getting the following error at the 'ant
> > > fresh install'. Has anyone else come across this?
> > >
> > >
> > >
> > >
> > >
> > > (log.init.config)
> > >
> > > [java] 2008-03-27 15:02:51,479 FATAL
> > > org.dspace.administer.RegistryLoader @
> > > anonymous::error_loading_registries:
> > >
> > > [java] java.lang.NullPointerException
> > >
> > > [java] at org.dspace.storage.rdbms.TableRow.canonicalize
> > > (TableRow.java:611)
> > >
> > > [java] at org.dspace.storage.rdbms.TableRow.hasColumn
> > > (TableRow.java:110)
> > >
> > >
> > >
> > >
> > >
> > > The tables appear to have been created correctly:
> > >
> > >
> > >
> > > dspace_test=> \dt
> > >
> > > List of relations
> > >
> > > Schema | Name | Type | Owner
> > >
> > > --------+----------------------------+-------+-------------
> > >
> > > public | bi_2_dis | table | dspace_test
> > >
> > > public | bi_2_dmap | table | dspace_test
> > >
> > > .
> > >
> > > .
> > >
> > > public | workflowitem | table | dspace_test
> > >
> > > public | workspaceitem | table | dspace_test
> > >
> > > (40 rows)
> > >
> > >
> > >
> > > dspace_test=>
> > >
> > >
> > >
> > > The full response from ant was:
> > >
> > >
> > >
> > > [EMAIL PROTECTED]:/usr/local/dspace_test/dspace/target/
> > > dspace-1.5.0-build.dir> ant fresh_install
> > >
> > > Buildfile: build.xml
> > >
> > >
> > >
> > > init_installation:
> > >
> > > [mkdir] Created dir: /home/dspace_test/bin
> > >
> > > [mkdir] Created dir: /home/dspace_test/config
> > >
> > > [mkdir] Created dir: /home/dspace_test/lib
> > >
> > > [mkdir] Created dir: /home/dspace_test/webapps
> > >
> > > [mkdir] Created dir: /home/dspace_test/assetstore
> > >
> > > [mkdir] Created dir: /home/dspace_test/handle-server
> > >
> > > [mkdir] Created dir: /home/dspace_test/search
> > >
> > > [mkdir] Created dir: /home/dspace_test/log
> > >
> > > [mkdir] Created dir: /home/dspace_test/upload
> > >
> > > [mkdir] Created dir: /home/dspace_test/reports
> > >
> > >
> > >
> > > init_configs:
> > >
> > > [copy] Copying 43 files to /home/dspace_test/config
> > >
> > >
> > >
> > > setup_database:
> > >
> > > [java] 2008-03-27 15:02:40,880 INFO
> > > org.dspace.core.ConfigurationManager @ Loading system provided
> > > config property (-Ddspace.configuration): config/dspace.cfg
> > >
> > > [java] 2008-03-27 15:02:40,884 INFO
> > > org.dspace.core.ConfigurationManager @ Using default log4j provided
> > > log configuration,if uninitended, check your dspace.cfg for
> > > (log.init.config)
> > >
> > > [java] 2008-03-27 15:02:40,884 INFO
> > > org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
> > >
> > > [java] 2008-03-27 15:02:49,029 INFO
> > > org.dspace.core.ConfigurationManager @ Loading system provided
> > > config property (-Ddspace.configuration): config/dspace.cfg
> > >
> > > [java] 2008-03-27 15:02:49,033 INFO
> > > org.dspace.core.ConfigurationManager @ Using default log4j provided
> > > log configuration,if uninitended, check your dspace.cfg for
> > > (log.init.config)
> > >
> > >
> > >
> > > load_registries:
> > >
> > > [java] 2008-03-27 15:02:50,956 INFO
> > > org.dspace.core.ConfigurationManager @ Loading system provided
> > > config property (-Ddspace.configuration): config/dspace.cfg
> > >
> > > [java] 2008-03-27 15:02:50,960 INFO
> > > org.dspace.core.ConfigurationManager @ Using default log4j provided
> > > log configuration,if uninitended, check your dspace.cfg for
> > > (log.init.config)
> > >
> > > [java] 2008-03-27 15:02:51,479 FATAL
> > > org.dspace.administer.RegistryLoader @
> > > anonymous::error_loading_registries:
> > >
> > > [java] java.lang.NullPointerException
> > >
> > > [java] at org.dspace.storage.rdbms.TableRow.canonicalize
> > > (TableRow.java:611)
> > >
> > > [java] at org.dspace.storage.rdbms.TableRow.hasColumn
> > > (TableRow.java:110)
> > >
> > > [java] at org.dspace.storage.rdbms.TableRow.setColumn
> > > (TableRow.java:466)
> > >
> > > [java] at org.dspace.storage.rdbms.DatabaseManager.insert
> > > (DatabaseManager.java:589)
> > >
> > > [java] at org.dspace.storage.rdbms.DatabaseManager.create
> > > (DatabaseManager.java:384)
> > >
> > > [java] at org.dspace.content.BitstreamFormat.create
> > > (BitstreamFormat.java:400)
> > >
> > > [java] at org.dspace.administer.RegistryLoader.loadFormat
> > > (RegistryLoader.java:203)
> > >
> > > [java] at
> > > org.dspace.administer.RegistryLoader.loadBitstreamFormats
> > > (RegistryLoader.java:169)
> > >
> > > [java] at org.dspace.administer.RegistryLoader.main
> > > (RegistryLoader.java:107)
> > >
> > >
> > >
> > > BUILD FAILED
> > >
> > > /usr/local/dspace_test/dspace/target/dspace-1.5.0-build.dir/
> > > build.xml:424: Java returned: 1
> > >
> > >
> > >
> > > Total time: 11 seconds
> > >
> > > ----------------------------------------------------------------------
> > > ---
> > > 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
> >
> >
> > -------------------------------------------------------------------------
> > 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
> >
>
-------------------------------------------------------------------------
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
