Re: [Dspace-tech] eperson and groups

2015-05-22 Thread Vegard Korvald
That worked like a charm, helix84!

Is it possible to make groups with the CLI, similar to the «user» command for 
creating users, or in any other way script this behavior?


--
Vegard


From: ivan.ma...@gmail.com [mailto:ivan.ma...@gmail.com] On Behalf Of helix84
Sent: Thursday, May 21, 2015 12:57 PM
To: Vegard Korvald
Cc: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] eperson and groups

On Thu, May 21, 2015 at 12:22 PM, Vegard Korvald 
vegard.korv...@usit.uio.nomailto:vegard.korv...@usit.uio.no wrote:
I used SELECT * FROM epersongroup  to get the IDs, but I couldn't seem to 
find the corresponding group name in the database. To find the name I had to 
look it up as an admin on our DSpace page under Access Control-Groups. Is 
there a way to find the IDs and names of the groups in the database?

Sorry about that, I forgot to note that since DSpace 5, the epersongroup table 
changed due to the metadata for all dspace objects feature. You can get the 
same view on the table as in previous versions using this query instead (6 is 
the constant for group):


SELECT e.*, m.text_value AS name FROM epersongroup e

LEFT JOIN metadatavalue m ON (

  m.resource_id = e.eperson_group_id

  AND m.resource_type_id = 6

)


Regards,
~~helix84

Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
--
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Re: [Dspace-tech] eperson and groups

2015-05-21 Thread Vegard Korvald
Thank you, helix84! By using psql I could add an eperson into a group without 
any problems.

I used SELECT * FROM epersongroup  to get the IDs, but I couldn't seem to 
find the corresponding group name in the database. To find the name I had to 
look it up as an admin on our DSpace page under Access Control-Groups. Is 
there a way to find the IDs and names of the groups in the database?


--
Vegard


-Original Message-
From: ivan.ma...@gmail.com [mailto:ivan.ma...@gmail.com] On Behalf Of
helix84
Sent: Tuesday, May 19, 2015 1:15 PM
To: Vegard Korvald
Cc: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] eperson and groups

I don't think it's doable with the currently available CLI commands in DSpace:
https://wiki.duraspace.org/display/DSDOC5x/Managing+User+Accounts


You could, however, use a CLI SQL client (psql) to manipulate membership in
the epersongroup2eperson table. You can find out the user and group IDs
from the eperson and epersongroup table, respectively.

Alternatively, assuming you're using password authentication and want to put
all users into a single group, you can use the login.specialgroup option in
[dspace]/config/modules/authentication-password.cfg. Please note that
special group membership is dynamic - it doesn't appear in the
epersongroup2eperson table, but you can check effective membership in the
profile of a logged in user.


Regards,
~~helix84

Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette


--
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette


[Dspace-tech] eperson and groups

2015-05-19 Thread Vegard Korvald
Hello,

I'm new to DSpace and would be very greatful if one of you could help me with 
an issue.

Is there a way to add an eperson into groups by using the command line tool or 
in any other way script it so that we dont have to do it manually? I know 
there's a solution with LDAP+AD, but unfortunately we can't use this method 
because we can't authenticate with LDAP.


--
Vegard

--
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette


Re: [Dspace-tech] Kerberos and filegroups

2015-05-11 Thread Vegard Korvald
Anyone? I would be really greatful if someone could help me resolve this issue. 

I can shorten the question:
Is it possible to authenticate with Kerberos and still autoregister epersons 
into groups? The best solution for us would be to use unix filegroups to see 
which eperson belongs to which group.


--
Vegard


-Original Message-
From: Vegard Korvald
Sent: Wednesday, April 29, 2015 4:57 PM
To: dspace-tech@lists.sourceforge.net
Subject: Kerberos and filegroups

Hello,

We're considering using DSpace for our researchers who work with videos and
other data. We'll mainly use DSpace as a frontend for metadata in the
database. I have a couple of questions.

1. Is it possible to authenticate with Kerberos? If so, is it also possible to
autoregister a user in a group on the first logon based on unix filegroups or 
AD?
I know that it's possible with LDAP authentication and AD, but we can't use
LDAP as authentication for AD, only Kerberos. The best option for us would be
to authenticate with Kerberos and autoregister users in groups by using unix
filegroups. All users will not be in the same group and one user might be a
member of several groups. Is this possible?

2. I want the files in DSpace to be useable by other software as well. For
example a video in DSpace should not have to be downloaded before the
user can analyze it with a software. DSpace will only be used as a frontend to
the database for metadata purposes and we don't want to store the files as a
38-digit internal ID, unless we have to. We want the users to be able to see
the same files on disk as they see in dspace. This means that the dspace
groups and the filegroups has to be the same. I've looked at Registering
Bitstreams via Simple Archive Format and if I understand it correctly it might
be a solution. It's very important that these files are not available for
everyone on disk. The dspace user should be the owner of the file, and a
filegroup should give some users access to the file on disk for analyzing.
Typically the dspace groups should correspond with the filegroups. Is this
doable with DSpace?

Please let me know if I need to clarify anything.


--
Vegard


--
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette