[Dspace-tech] database_schema_14-15.sql:- ERROR!!!!!

[Nikhil George]

Hello all,

I was trying to upgrade my DSpace from 1.3.2 version to DSpace 1.7.0.
thanks for the help from u guys fro the initial start...
Now i'm stuck somewhere else...that is changing database schema from 1.3 to
1.4 was sucessful but 1.4 to 1.5 give me errors:

psql -f database_schema_13-14.sql dspace2 -U dspace
ran successfully
psql -f database_schema_14-15.sql dspace2 -U dspace
returned me some error, mainly :

psql:database_schema_14-15.sql:135: ERROR:  column "submitter" does not
exist
psql:database_schema_14-15.sql:136: ERROR:  column "admin" does not exist
psql:database_schema_14-15.sql:159: ERROR:  relation
"epersongroup2workspaceitem" does not exist
psql:database_schema_14-15.sql:160: ERROR:  relation
"epersongroup2workspaceitem" does not exist

Can i ignore these errors and proceed to 1.5 to 1.6 up-gradation
or shld i correct it now before proceeding ,
Please advice. Also kindly tell me if u guys have any idea abt how
to rectify this error.
Thnks in advance


*Thanks & Regards,*
*
*
*Nikhil George *
*Net-X Technologies*
*Kochi - Kerala, India

*
--
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network 
management toolset available today.  Delivers lowest initial 
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] Upgrading form DSpace 1.3.2 to 1.6

[Nikhil George]

yes i tried tatand it says the owner of dspace database is dspace user
itself...

*Thanks & Regards,*
*
*
*Nikhil George *
*Net-X Technologies*
*Kochi India*
*.*



On Mon, Apr 25, 2011 at 9:43 PM, Mark H. Wood  wrote:

> On Mon, Apr 25, 2011 at 01:59:05PM +0530, Nikhil George wrote:
> > psql:database_schema_13-14.sql:59: ERROR:  permission denied for relation
> > epersongroup
>
> It looks as though database user 'dspace' doesn't own or have
> permission to alter the objects in that database.  The first thing I'd
> do is use 'psql -l' to see what DB user owns the database itself.
>
> --
> Mark H. Wood, Lead System Programmer   mw...@iupui.edu
> Asking whether markets are efficient is like asking whether people are
> smart.
>
>
> --
> Fulfilling the Lean Software Promise
> Lean software platforms are now widely adopted and the benefits have been
> demonstrated beyond question. Learn why your peers are replacing JEE
> containers with lightweight application servers - and what you can gain
> from the move. http://p.sf.net/sfu/vmware-sfemails
> ___
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
>
--
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network 
management toolset available today.  Delivers lowest initial 
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] Upgrading form DSpace 1.3.2 to 1.6

[Nikhil George]

hello,

i tried to upgrade the database step by step(for upgrading my DSpace form
1.3.2 to 1.7.0) using the scripts in
the dspace-1.7.0-release/dspace/etc/postgres/

i issue the command: psql -f database_schema_13-14.sql dspace -h localhost
-U dspace

and i got errors...
please help...below is my output

psql:database_schema_13-14.sql:59: NOTICE:  CREATE TABLE / PRIMARY KEY will
create implicit index "group2group_pkey" for table "group2group"
psql:database_schema_13-14.sql:59: ERROR:  permission denied for relation
epersongroup
psql:database_schema_13-14.sql:75: NOTICE:  CREATE TABLE / PRIMARY KEY will
create implicit index "group2groupcache_pkey" for table "group2groupcache"
psql:database_schema_13-14.sql:75: ERROR:  permission denied for relation
epersongroup
psql:database_schema_13-14.sql:91: NOTICE:  CREATE TABLE / PRIMARY KEY will
create implicit index "metadataschemaregistry_pkey" for table
"metadataschemaregistry"
psql:database_schema_13-14.sql:91: NOTICE:  CREATE TABLE / UNIQUE will
create implicit index "metadataschemaregistry_namespace_key" for table
"metadataschemaregistry"
psql:database_schema_13-14.sql:101: NOTICE:  CREATE TABLE / PRIMARY KEY will
create implicit index "metadatafieldregistry_pkey" for table
"metadatafieldregistry"
psql:database_schema_13-14.sql:112: NOTICE:  CREATE TABLE / PRIMARY KEY will
create implicit index "metadatavalue_pkey" for table "metadatavalue"
psql:database_schema_13-14.sql:112: ERROR:  permission denied for relation
item
psql:database_schema_13-14.sql:115: ERROR:  relation "metadatavalue" does
not exist
psql:database_schema_13-14.sql:116: ERROR:  relation "metadatavalue" does
not exist
psql:database_schema_13-14.sql:126: ERROR:  permission denied for relation
dctyperegistry
psql:database_schema_13-14.sql:130: ERROR:  relation "metadatavalue" does
not exist
LINE 1: INSERT INTO MetadataValue (item_id, metadata_field_id, text_...
^
psql:database_schema_13-14.sql:132: ERROR:  must be owner of relation
dcvalue
psql:database_schema_13-14.sql:139: ERROR:  relation "metadatavalue" does
not exist
LINE 5:   FROM MetadataValue, MetadataFieldRegistry
   ^
psql:database_schema_13-14.sql:142: ERROR:  relation "metadatavalue" does
not exist
LINE 1: ...'metadatavalue_seq', max(metadata_value_id)) FROM metadatava...
 ^
psql:database_schema_13-14.sql:145: ERROR:  must be owner of relation
dctyperegistry
psql:database_schema_13-14.sql:151: ERROR:  must be owner of relation
bitstream
psql:database_schema_13-14.sql:152: ERROR:  column "size_bytes" of relation
"bitstream" does not exist
LINE 1: UPDATE bitstream SET size_bytes = size;
 ^
psql:database_schema_13-14.sql:153: ERROR:  must be owner of relation
bitstream
psql:database_schema_13-14.sql:165: NOTICE:  CREATE TABLE / PRIMARY KEY will
create implicit index "checksum_results_pkey" for table "checksum_results"
psql:database_schema_13-14.sql:185: NOTICE:  CREATE TABLE / PRIMARY KEY will
create implicit index "most_recent_checksum_pkey" for table
"most_recent_checksum"
psql:database_schema_13-14.sql:185: ERROR:  permission denied for relation
bitstream
psql:database_schema_13-14.sql:200: NOTICE:  CREATE TABLE will create
implicit sequence "checksum_history_check_id_seq" for serial column
"checksum_history.check_id"
psql:database_schema_13-14.sql:200: NOTICE:  CREATE TABLE / PRIMARY KEY will
create implicit index "checksum_history_pkey" for table "checksum_history"
psql:database_schema_13-14.sql:291: ERROR:  relation "most_recent_checksum"
does not exist
LINE 1: insert into most_recent_checksum
^
psql:database_schema_13-14.sql:302: ERROR:  relation "most_recent_checksum"
does not exist
LINE 1: update most_recent_checksum
   ^
psql:database_schema_13-14.sql:322: ERROR:  relation "most_recent_checksum"
does not exist
LINE 14: from most_recent_checksum;
  ^
psql:database_schema_13-14.sql:336: ERROR:  must be owner of relation
community
psql:database_schema_13-14.sql:353: NOTICE:  CREATE TABLE / PRIMARY KEY will
create implicit index "itemsbysubject_pkey" for table "itemsbysubject"
psql:database_schema_13-14.sql:353: ERROR:  permission denied for relation
item
psql:database_schema_13-14.sql:356: ERROR:  relation "itemsbysubject" does
not exist
psql:database_schema_13-14.sql:365: ERROR:  relation "itemsbysubject" does
not exist
LINE 3: FROM ItemsBySubject, Collection2Item
 ^
psql:database_schema_13-14.sql:374: ERROR:  relation "itemsbysubject" does
not exist
LINE 3: FROM ItemsBySubject, Communities2Item


*Th

Re: [Dspace-tech] [Dspace-general] Upgrading form DSpace 1.3.2 to 1.6

[Nikhil George]

Thank you very much for the response.

Did u do up gradation from 1.3 to 1.6 or between some other later
versions..?

I was also thinking the about the same procedure...but some where where i
read we can't jump directly form 1.3 to 1.6...

It says that there 'll be some problem like index un matching and so we have
to go up each version that is from 1.3 to 1.4, 1.4 to 1.5, 1.5 to 1.6.

i just want to make sure about the procedure before starting.

*Thanks & Regards,*
*
*
*Nikhil George *
*Net-X Technologies*
Cochin, Kerala, India


On Tue, Apr 19, 2011 at 2:17 PM, Mpirirwe Byanagwa Stephen <
smpiri...@dicts.mak.ac.ug> wrote:

> I advise that u installe another instance of dspacewith the latea st
> version on a separate server.
>
>
>
> Then
>
> 1.   Make a Postgresql dump of the old database
>
> 2.   Restore it on the new server
>
> 3.   Copy assetstore from old to new
>
> 4.   Reindex
>
> 5.   Test
>
>
>
> This work for me..
>
>
>
>
>
> *From:* Nikhil George [mailto:nik...@netx.co.in]
> *Sent:* Tuesday, April 19, 2011 10:04 AM
> *To:* dspace-gene...@lists.sourceforge.net;
> dspace-tech@lists.sourceforge.net
> *Subject:* [Dspace-general] Upgrading form DSpace 1.3.2 to 1.6
>
>
>
> Hello all,
>
>
>
> Currently i have a running installation of Dpsace and it is thought to be
> of ver 1.3.2.
>
> I have to upgrade it to 1.6.2 .
>
>
>
> Few things i like to get advice from u guys are as follows:
>
>
>
> First:
>
> Is there any way to find the correct dspace version from the installation
> directory files(we do't have any records of previous Dspace installation)
>
>
>
> Second:
>
> Does a simple copying and restoring of asseststore and database wrks for
> the upgrading process..?
>
>
>
> please advice..
>
>
> Thanks & Regards,
>
>
>
> Nikhil George
>
> Net-X Technologies
>
> Cochin, Kerela, India
>
>
>
--
Benefiting from Server Virtualization: Beyond Initial Workload 
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve 
application availability and disaster protection. Learn more about boosting 
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Dspace-tech] Upgrading form DSpace 1.3.2 to 1.6

[Nikhil George]

Hello all,

Currently i have a running installation of Dpsace and it is thought to be of
ver 1.3.2.
I have to upgrade it to 1.6.2 .

Few things i like to get advice from u guys are as follows:

First:
Is there any way to find the correct dspace version from the installation
directory files(we do't have any records of previous Dspace installation)

Second:
Does a simple copying and restoring of asseststore and database wrks for the
upgrading process..?

please advice..

*Thanks & Regards,*
*
*
*Nikhil George *
*Net-X Technologies*
Cochin, Kerela, India
--
Benefiting from Server Virtualization: Beyond Initial Workload 
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve 
application availability and disaster protection. Learn more about boosting 
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Dspace-tech] "Feedback Problem in XMLUI" :- org.dspace.authorize.AuthorizeException:

[Nikhil George]

Hello all,

I have been battling with problems regarding the Feedback of dspace.
the error i get when i click on the feedback link is :-

*org.dspace.authorize.AuthorizeException: The feedback mail page may only be
invoked from another DSpace page*

I googled about it and found many articles saying that the problem may be
because of the dspace.hostname.
Ii corrected all according to the articles, but still no luck.

Below mentioned are my settings in dspace.cfg

*dspace.hostname = www.abc.in*
*
*
*dspace.baseUrl = http://www.abc.in*
*
*
*dspace.url = ${dspace.baseUrl}*


www.abc.in is the FDN of my server.

Help appreciated..!!


*Thanks & Regards,*
*
*
*Nikhil George *
*Net-X Technologies*
*46/1256C, Padivattom Road
Vennala P O , Kochi - 682028
Ph: 0484 3214138.*
--
Enable your software for Intel(R) Active Management Technology to meet the
growing manageability and security demands of your customers. Businesses
are taking advantage of Intel(R) vPro (TM) technology - will your software 
be a part of the solution? Download the Intel(R) Manageability Checker 
today! http://p.sf.net/sfu/intel-dev2devmar___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Dspace-tech] How to Integrate Captcha with Dspace...

[Nikhil George]

Hi,
I'm a newbie to Dspace, i would like to knw how i can integrate
captacha(Jcaptcha or kaptcha) to dspace log in.
Thanks in advance...
NIkhil
--

___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech