Re: [Dspace-tech] 1.5 install
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
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
Re: [Dspace-tech] 1.5 install
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
