This fixed my 4.2 test system/
http://wiki.lib.sun.ac.za/index.php/SUNScholar/Prepare_Ubuntu/S06#Step_6.5:_Setup_PostgreSQL_dspace_DB_user_password.2C_ownership_and_privileges
Cheers
hg
*Hilton Gibson*
Ubuntu Linux Systems Administrator
JS Gericke Library
Room 1025C
Stellenbosch University
Private Bag X5036
Stellenbosch
7599
South Africa
Tel: +27 21 808 4100 | Cell: +27 84 646 4758
On 26 September 2014 18:43, ʚïɞ...liss ...εïз <[email protected]> wrote:
>
> Hi Wally, and the rest of list
>
> I check the database and tables and it seems that all have the same owner. I
> also just discovered that just will not let me upload records when I use
> metadata 'editor' and 'citation' but if I do not use I can upload both new
> collections as in previous.
>
> I do not know if it is due to the system or database
>
>
> Listado de relaciones
> Esquema | Nombre | Tipo | Dueño
> ---------+--------------------------------+-----------+--------
> public | bi_2_dis | tabla |
> dspace
> public | bi_2_dis_seq | secuencia | dspace
> public | bi_2_dmap | tabla |
> dspace
> public | bi_2_dmap_seq secuencia | dspace
> public | bi_4_dis | tabla |
> dspace
> public | bi_4_dis_seq | secuencia | dspace
> public | bi_4_dmap | tabla |
> dspace
> public | bi_4_dmap_seq | secuencia | dspace
> public | bi_item | tabla
> | dspace
> public | bi_item_seq | secuencia | dspace
> public | bi_withdrawn | tabla |
> dspace
> public | bi_withdrawn_seq | secuencia | dspace
> public | bitstream | tabla
> | dspace
> public | bitstream_seq | secuencia | dspace
> public | bitstreamformatregistry | tabla | dspace
> public | bitstreamformatregistry_seq | secuencia | dspace
> public | bundle | tabla
> | dspace
> public | bundle2bitstream | tabla |
> dspace
> public | bundle2bitstream_seq | secuencia | dspace
> public | bundle_seq | secuencia |
> dspace
> public | checksum_history | tabla |
> dspace
> public | checksum_history_check_id_seq | secuencia | dspace
> public | checksum_results | tabla |
> dspace
> public | collection | tabla
> | dspace
> public | collection2item | tabla
> | dspace
> public | collection2item_seq | secuencia | dspace
> public | collection_item_count | tabla |
> dspace
> public | collection_seq | secuencia |
> dspace
> public | communities2item | tabla |
> dspace
> public | communities2item_seq | secuencia | dspace
> public | community |
> tabla | dspace
> public | community2collection | tabla |
> dspace
> public | community2collection_seq | secuencia | dspace
> public | community2community | tabla |
> dspace
> public | community2community_seq | secuencia | dspace
> public | community2item | vista
> | dspace
> public | community_item_count | tabla |
> dspace
> public | community_seq | secuencia |
> dspace
> public | dcvalue | vista
> | dspace
> public | dcvalue_seq | secuencia
> | dspace
> public | dcvalue |
> vista | dspace
> public | dcvalue_seq | secuencia
> | dspace
> public | doi |
> tabla | dspace
> public | doi_seq | secuencia
> | dspace
> public | eperson | tabla
> | dspace
> public | eperson_seq | secuencia
> | dspace
> public | epersongroup | tabla
> | dspace
> public | epersongroup2eperson | tabla |
> dspace
> public | epersongroup2eperson_seq | secuencia | dspace
> public | epersongroup2workspaceitem | tabla | dspace
> public | epersongroup2workspaceitem_seq | secuencia | dspace
> public | epersongroup_seq | secuencia |
> dspace
> public | fileextension | tabla
> | dspace
> public | fileextension_seq | secuencia |
> dspace
> public | group2group | tabla
> | dspace
> public | group2group_seq | secuencia |
> dspace
> public | group2groupcache | tabla |
> dspace
> public | group2groupcache_seq | secuencia | dspace
> public | handle | tabla
> | dspace
> public | handle_seq | secuencia |
> dspace
> public | harvested_collection | tabla |
> dspace
> public | harvested_collection_seq | secuencia | dspace
> public | harvested_item | tabla
> | dspace
> public | harvested_item_seq | secuencia | dspace
> public | history_seq | secuencia |
> dspace
> public | historystate_seq | secuencia |
> dspace
> public | item | tabla
> | dspace
> public | item2bundle | tabla
> | dspace
> public | item2bundle_seq | secuencia | dspace
> public | item_seq | secuencia |
> dspace
> public | metadatafieldregistry | tabla |
> dspace
> public | metadatafieldregistry_seq | secuencia | dspace
> public | metadataschemaregistry | tabla | dspace
> public | metadataschemaregistry_seq | secuencia | dspace
> public | metadatavalue | tabla |
> dspace
> public | metadatavalue_seq | secuencia | dspace
> public | most_recent_checksum | tabla | dspace
> public | registrationdata | tabla
> | dspace
> public | registrationdata_seq | secuencia | dspace
> public | requestitem | tabla
> | dspace
> public | requestitem_seq | secuencia | dspace
> public | resourcepolicy | tabla
> | dspace
> public | resourcepolicy_seq | secuencia | dspace
> public | subscription | tabla
> | dspace
> public | subscription_seq | secuencia |
> dspace
> public | tasklistitem |
> tabla | dspace
> public | tasklistitem_seq | secuencia |
> dspace
> public | versionhistory | tabla
> | dspace
> public | versionhistory_seq | secuencia | dspace
> public | versionitem | tabla
> | dspace
> public | versionitem_seq | secuencia | dspace
> public | webapp | tabla
> | dspace
> public | webapp_seq | secuencia | dspace
> public | workflowitem | tabla |
> dspace
> public | workflowitem_seq | secuencia | dspace
> public | workspaceitem | tabla |
> dspace
> public | workspaceitem_seq | secuencia | dspace
> (95 filas)
>
>
>
>
>
> ------------------------------
> Date: Fri, 26 Sep 2014 10:50:20 -0400
> From: [email protected]
> To: [email protected]
> Subject: Re: [Dspace-tech] FW: 4.2 dspace don't allow to upload records
>
> I had this problem and it turned out that dspace was not the owner of some
> of the tables in the postgres database. I dumped the database to a text
> file and then went in with an editor and made sure dspace owned all the
> tables related to the application. Then reimported the database. That
> fixed it.
>
> - Wally
>
> Wally Grotophorst
> Associate University Librarian
> George Mason University
> Fairfax, Virginia 22030
> (703) 993-9005
>
>
> ʚïɞ...liss ...εïз wrote:
>
>
> sorry... I'm sending the logs
> ------------------------------
> Date: Thu, 25 Sep 2014 18:43:01 -0400
> Subject: Re: [Dspace-tech] 4.2 dspace don't allow to upload records
> From: [email protected]
> To: [email protected]
>
> Attached the log please!
> Em 25/09/2014 12:58, "ʚïɞ...liss ...εïз" <[email protected]> escreveu:
>
> hi all,
> I've installed dspace v4.2 but I made the migration of the database I
> had in dspace 1.8 and everything ok I can upload records but when I create
> a new collection sometimes I can upload and sometimes I can't
>
> I don't know what I must do in postgresql
>
>
> ------------------------------------------------------------------------------
> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
>
> http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
> List Etiquette:
> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>
>
> ------------------------------------------------------------------------------
> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog
> Analyzerhttp://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
>
> _______________________________________________
> DSpace-tech mailing
> [email protected]https://lists.sourceforge.net/lists/listinfo/dspace-tech
> List Etiquette:
> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>
>
>
> ------------------------------------------------------------------------------
> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
>
> http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
> List Etiquette:
> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
