Time
S
Nick
Message
11:48 andrewSC joined #dataverse
12:32 pdurbin
Dataverse 4.7 is here! Customization and Community Release - Google Groups - https://groups.google.com/forum/#!msg/dataverse-community/qfcPQWfB3V0/t4WC3k8hAwAJ
12:44 donsizemore joined #dataverse
13:09 jri joined #dataverse
13:10 jri
Hi all, I've a question: Dataverse users are stored in builtinuser table, right ?
13:18 pdurbin
jri: only if their authenticationproviderid in the authenticateduserlookup is "builtin" http://phoenix.dataverse.org/schemaspy/latest/tables/authenticateduserlookup.html . *All* users get a row in the authenticateduser table.
13:19 jri
pdurbin: yes. I have a ghost user :(
13:19 pdurbin
spooky
13:19 jri
Not in builtinuser, but in authenticateduserlookup and authenticateduser talbes
13:20 pdurbin
jri: what is your ghost user's authenticationproviderid in the authenticateduserlookup table?
13:20 jri
builtin
13:21 jri
Is there a way for the user to delete his account ?
13:21 jri
(delete his account himself)
13:22 pdurbin
jri: no, but people have asked for this in the past. Please feel free to create a GitHub issue for this. Would "disable account" be enough or do you really want "delete account"?
13:23 oscardssmith joined #dataverse
13:23 jri
I don't know, I don't need this in fact. I'm juste trying to undestand why the accound disappear
13:23 jri
account*
13:24 pdurbin
Yeah, it sounds like you should delete all traces of the account. You should also check the "roleassignment" table. That's what https://github.com/IQSS/dataverse/issues/1929 is about.
13:25 pdurbin
jri: did you see that we're working on displaying a list of users in a dashboard? See https://github.com/IQSS/dataverse/issues/3614
13:27 jri
Yeah I can see "assigneeidentifier" of the lost user in this table. I can also see logs of modification of this user in authenticateduser. but the user is no more here and can't connect
13:27 jri
strange
13:27 jri
thanks for pointing me this issue, that would be a good feature
13:28 jri
I think I'm gonna say to user to recreate his account... I have no idea
13:29 pdurbin
jri: ok. I'd curious what you get when you run `GET http://$SERVER/api/admin/authenticatedUsers/$identifier
13:29 pdurbin
that's from http://guides.dataverse.org/en/4.6.2/api/native-api.html#admin
13:30 pdurbin
"List user whose identifier (without the @ sign) is passed"
13:33 pdurbin
jri: but yeah, a new account would probably be best, especially since you can't change the username of a user: https://github.com/IQSS/dataverse/issues/1445
13:34 jri
the GET command find the user:
13:34 jri
curl http://localhost:8080/api/admin/authenticatedUsers/Anita%20Beldiman-Moore
13:34 jri
{"status":"OK","data":{"id":190,"identifier":"@Anita Beldiman-Moore","displayName":"Anita Beldiman-Moore","firstName":"Anita","lastName":"Beldiman-Moore","email":"anita.beldimanmoore
13:34 jri
:/
13:36 pdurbin
jri: the "identifier" has a space in it? Uh oh.
13:36 jri
Yep
13:36 pdurbin
jri: you may be suffering from https://github.com/IQSS/dataverse/issues/3752
13:37 pdurbin
'User tried creating an account with username "First Last" type of format.'
13:39 jri
seems to be my issue
13:40 pdurbin
jri: unfortunately, the damage is done already
13:40 jri
ok
13:41 pdurbin
jri: you could leave a comment on that issue asking if advice will be provided on how to do cleanup of borken accounts that were created before the fix has been put in place.
13:41 jri
I can delete this account with API ? and specify to user to not use spaces ?
13:42 pdurbin
jri: I would first check if the account has any role assignments. And I would use the "id" (integer) form of the DELETE
13:43 pdurbin
it looks like you're running 4.6.2: https://catalogues.cdsp.sciences-po.fr
13:43 jri
yep
13:44 pdurbin
here's the "id" (integer) form of the delete: https://github.com/IQSS/dataverse/blob/v4.6.2/src/main/java/edu/harvard/iq/dataverse/api/Admin.java#L681
13:44 pdurbin
id 190 for you
13:46 jri
okay
13:47 jri
let's do it!
13:47 jri
in fact the user creates two accounts, both with a space
13:48 pdurbin
Who puts spaces in usernames? ;)
13:49 jri
Yeah...
13:49 pdurbin
I guess I've been using Unix too long. :)
13:51 pdurbin
"Use lower case and keep it short." http://www.ru.j-npcs.org/usoft/WWW/LJ/Articles/unixtenets.html
13:59 pdurbin
jri: did it work?
13:59 pdurbin
I'm on the edge of my seat. :)
14:07 donsizemore joined #dataverse
14:19 jri
I think it worked pdurbin
14:19 pdurbin
\o/
14:22 jri
Thanks for your help!
14:22 pdurbin
jri: Sure. Do you want to leave any notes on that issue? It might help others.
14:23 jri
Yes
14:23 pdurbin
Cool. While it's fresh in your mind.
14:33 jri
https://github.com/IQSS/dataverse/issues/3752 Is my comment is ok ?
14:39 pdurbin
jri: I just left a comment saying how good your comment is. Thanks!
14:41 pdurbin
jri: I just added you to https://github.com/orgs/IQSS/teams/dataverse-readonly/members but you have to click something.
14:42 jri
thanks :)
14:44 pdurbin
It makes it easier to @mention you in issues.
14:44 jri
Ok :)
14:45 pdurbin
andrewSC bjonnh bret bricas donsizemore want me to add you as well?
14:45 andrewSC
pdurbin: sure :)
14:46 jri
I hope I will not be in to many issues :P
14:46 donsizemore
@pdurbin i'm happy to help, stopped clock and all that
14:47 donsizemore
@pdurbin p.s. on https://github.com/IQSS/dataverse-ansible/issues/5 just want me to delete it?
14:47 pdurbin
donsizemore: well, why is it there? For reference?
14:48 pdurbin
Or to make it so that the repo is 95.9% Perl? :)
14:48 pdurbin
andrewSC: added
14:49 donsizemore
@pdurbin i think it got pushed with a 'git add .' after i moved those variables into a task
14:49 pdurbin
ah, ok
14:50 donsizemore
@pdurbin i need to bump it to 4.7 among other things, so i'll keep a local copy, nuke it, and do a test run
14:50 pdurbin
It was throwing me off so if you would please delete it, I would appreciate it.
14:51 pdurbin
donsizemore: did you get a chance to look at this issue? Rewrite installer in Python · Issue #3937 · IQSS/dataverse - https://github.com/IQSS/dataverse/issues/3937 /cc andrewSC bjonnh bret bret jri
14:52 andrewSC
mmm I haven't..
14:52 donsizemore
@pdurbin i saw it among this weekend's issue bomb =)
14:52 pdurbin
BOOM!
14:56 pdurbin
Comments on that issue are very welcome.
15:03 pameyer joined #dataverse
15:23 donsizemore
@pdurbin who's your local solr expert
15:30 bjonnh
1pdadding where what who?
15:30 bjonnh
pdurbin: where what who? (re pdurbin | andrewSC bjonnh bret bricas donsizemore want me to add you as well?)
15:33 oscardssmith joined #dataverse
15:39 pdurbin
donsizemore: me :(
15:39 pdurbin
bjonnh: I'm offering to add people to https://github.com/orgs/IQSS/teams/dataverse-readonly/members
15:40 donsizemore
@pdurbin solr's gotten wedged on our test server with production data. i'm not done whapping it with a 2-by-4 yet, but i'm mildly curious how it got in this state
15:42 donsizemore
@pdurbin so i'm not asking anything just yet... only curious if anyone has seen dataverse take a LONG time to return to solr localhost curls... i'm going to let it finish, then clear and re-index everything.
15:44 donsizemore
@pdurbin the thing i don't get is that even though i told it to clear everything in the first place, it's somehow re-indexing old data, even though i can see the correct info in the DB
15:45 donsizemore
i may whine about it some more after dim sum.
15:51 bjonnh
pdurbin: I don't know what it is but yes you can add me
16:03 pameyer joined #dataverse
16:07 pdurbin
bjonnh: we add people to the readonly team so that we can more easily @mention them in issues (and maybe assign them work to do!): https://groups.google.com/d/msg/dataverse-community/nMdEGUCOyzE/RtOG3a_HAQAJ :)
16:07 jhand joined #dataverse
16:21 bjonnh
ok
16:21 bjonnh
great
16:26 pdurbin
bjonnh: added
16:33 bjonnh
pdurbin: "You are now a member of Institute for Quantitative Social Science!" great, where is my payroll ;)
16:42 pdurbin
heh
17:13 oscardssmith joined #dataverse
17:22 donsizemore joined #dataverse
17:27 pameyer joined #dataverse
17:51 donsizemore
@pdurbin all is well with solr, BTdubs. dim sum did the trick
17:52 pdurbin
phew
17:52 pdurbin
must be some dim sum
17:52 * pdurbin
needs lunch
17:53 donsizemore
@pdurbin you're welcome in chapel hill any time. we have xiaolongbao!
17:56 * pdurbin
misses searchbot
17:56 pdurbin
yum https://en.wikipedia.org/wiki/Xiaolongbao
18:01 oscardssmith joined #dataverse
18:37 pameyer joined #dataverse
19:07 bsilverstein joined #dataverse
20:35 pameyer joined #dataverse
21:19 donsizemore joined #dataverse
21:52 pameyer joined #dataverse
23:06 pdurbin
nice, http://phoenix.dataverse.org/api/search?q=* works without an API token now that https://github.com/IQSS/dataverse/pull/3940 has been merged
