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