Re: [Dspace-tech] Help with mod_jk, SSL, and local authority cert

2015-01-30 Thread Mark H. Wood
Perhaps the code cannot recognize that the cert. you provided is the one it wants. It could be a host name resolution problem. -- Mark H. Wood Lead Technology Analyst University Library Indiana University - Purdue University Indianapolis 755 W. Michigan Street Indianapolis, IN 46202

Re: [Dspace-tech] Best approach to bulk delete empty collections

2015-01-30 Thread Joseph Greene
Hi Steven, collection2item contains 2 values, collection_id and item_id -- it maps all items to any collections they are in (a many to many relationship between item and collection. The owning collection is in the item record. So a mapped item is one that appears twice or more in

[Dspace-tech] How to count submissions within an interval?

2015-01-30 Thread Mark H. Wood
I wanted to double-check: given DSpace 4.0 with PostgreSQL, should this not give me the number of Items submitted in the year 2014? SELECT COUNT(*) FROM metadatavalue WHERE metadata_field_id = (SELECT metadata_field_id FROM metadatafieldregistry WHERE metadata_schema_id = 1 AND

[Dspace-tech] Use of DSpace 4.1 SearchService to get SQL like distict query

2015-01-30 Thread John Preston
I am trying to use the SearchService to retrieve all the distinct values of a metadata field for items in a collection. I understand from various posts that solr should have such a capability using facet searches, however I am having a problem wrapping my head around how to use the DiscoverQuery

Re: [Dspace-tech] More question on Stats logging on DSpace-CRIS 4.1.2

2015-01-30 Thread Pablo Buenaposada
1-I will look the next week, what I can said you now is that for me seems work, I can see researcher with visits by the web, mostly from USA (robots?) and from my location (me?), so seems that something is counting. 2-Where are those reports created? no idea mate. -- View this message in

[Dspace-tech] running checker with --prune gives SQLException

2015-01-30 Thread Monika C. Mevenkamp
This is DSPACE 1.8 (with minimal changes in the checker code - aka I pushed the DB connection up in the call stack so it is shared instead of being recreated each time the DB is touched) /dspace/bin/dspace checker -p Problem pruning results: ORA-30036: unable to extend segment by 8 in undo

[Dspace-tech] Help with mod_jk, SSL, and local authority cert

2015-01-30 Thread Andrew Reid
Hi all -- I'm having an issue with a local development copy of DSpace 3.2, which I set up to try out some development ideas. It's xmlui. What I did was, I copied over a production system, including the postgres database and LDAP authentication, and all the DSpace app files, ran the

[Dspace-tech] Best approach to bulk delete empty collections (DSpace 4.2)

2015-01-30 Thread Steven Hayles
Hi We have a DSpace 4.2 instance with many empty collections. What's the best approach to finding and deleting them? Thanks Steven Hayles Systems Analyst IT Services, University of Leicester, Propsect House, 94 Regent Rd, Leicester, LE1 7DA, UK T: +44 (0)116 229 7950 E: s...@le.ac.uk The

[Dspace-tech] Bulk withdraw tool?

2015-01-30 Thread Joseph Greene
Hi, I have a list of item_ids based on an sql query, e.g. item_id -- 2 3 15 23 ... (582 rows) I'd like to withdraw the items from DSpace. I assume it isn't safe to just change the item.withdrawn field to 'true' (side effects for solr, oai_pmh, etc). Is this correct? Does anyone have or

[Dspace-tech] R: Mirage 2

2015-01-30 Thread Massimiliano Cilurzo
Hi Andrea, We have installed git on our machine and we have configured git to use https (git config --global url. https://github.com/ https://github.com/.insteadOf git://github.com/). Then we have used the mvn command: mvn clean package -P

[Dspace-tech] R: R: Mirage 2

2015-01-30 Thread Massimiliano Cilurzo
Hi, Yes we are running as root user. We tried to run as dspace but we had some errors. So we choosed to use root user. I will try with another user. Thanks Best regards Massimiliano -Messaggio originale- Da: sn...@buntblock.de [mailto:sn...@buntblock.de] Inviato: venerdì 30 gennaio 2015

Re: [Dspace-tech] R: R: Mirage 2

2015-01-30 Thread Sean Carte
For what it's worth, I've got the same error and I'm running mvn as the dspace user. I suspect the problem is due to the firewall here. Following Andrea's suggestion of changing git to use https did allow maven to download more things, but still not enough. Sean On 30 January 2015 at 13:06,

Re: [Dspace-tech] Best approach to bulk delete empty collections

2015-01-30 Thread Joseph Greene
Hello Steven, As a start here is a query that will identify empty collections: select collection_id, name from collection where collection_id not in (select distinct collection_id from collection2item); To my knowledge that should work on 1.4.2's database (was on 1.4.2 recently enough).

Re: [Dspace-tech] Best approach to bulk delete empty collections

2015-01-30 Thread Joseph Greene
Actually that query was a little restrictive. This may be better: select collection_id, name from collection where collection_id not in (select owning_collection from item where in_archive = true and withdrawn = false); So any collection that shows 0 items live, but may have withdrawn items

Re: [Dspace-tech] R: R: Mirage 2

2015-01-30 Thread Hilton Gibson
Same problem with me. *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 30 January 2015 at 13:19, Sean Carte sean.ca...@gmail.com wrote: For