ruaok: there is another explanation for how the oauth_client row was deleted
2017-10-17 29030, 2017
bitmap
1. all OAuth clients are associated with a user. if Gentlecat set things up, then the officebrainz client was likely associated with his user account. according to IRC logs, he added the client: https://chatlogs.metabrainz.org/brainzbot/metabra…
2017-10-17 29006, 2017
bitmap
2. the oauth_client table REFERENCES "user" (id) ON DELETE CASCADE
2017-10-17 29006, 2017
bitmap
3. Gentlecat's MeB account no longer exists, so it was deleted by someone, which could have been done through the admin UI by you or him or Quesito
2017-10-17 29002, 2017
bitmap
4. when his account was deleted, all rows in oauth_client that referenced his account were also silently deleted due to the CASCADE (I've tested this locally via the admin UI)
2017-10-17 29044, 2017
bitmap
FTR I asked him about this and he said he doesn't remember deleting his account through the admin UI and hasn't touched the database directly since long before he left
2017-10-17 29057, 2017
bitmap
there are no container or nginx logs from sep. or early oct. to see when his account was deleted, but even so, it's easy to see how that could have had an unintended effect
2017-10-17 29042, 2017
nawcom has quit
2017-10-17 29007, 2017
nawcom joined the channel
2017-10-17 29017, 2017
Slurpee has quit
2017-10-17 29045, 2017
Darkloke joined the channel
2017-10-17 29037, 2017
Darkloke has left the channel
2017-10-17 29043, 2017
khan joined the channel
2017-10-17 29033, 2017
Rotab joined the channel
2017-10-17 29056, 2017
gcilou has quit
2017-10-17 29038, 2017
samj1912
Morning o/
2017-10-17 29002, 2017
MajorLurker
Good evening samj1912
2017-10-17 29021, 2017
khan has quit
2017-10-17 29007, 2017
spuniun has quit
2017-10-17 29057, 2017
khan joined the channel
2017-10-17 29035, 2017
ruaok
bitmap: I deleted his account, but only AFTER I fixed three sets of OAuth keys.
2017-10-17 29023, 2017
ruaok
Given that there is no admin view of OAuth keys and that I was really pissed, I deleted his account to see what else would break. Nothing else broke and the case was closed for me.
2017-10-17 29002, 2017
pprkut
win 47
2017-10-17 29009, 2017
agentsim_ has quit
2017-10-17 29036, 2017
agentsim joined the channel
2017-10-17 29027, 2017
UmkaDK has quit
2017-10-17 29008, 2017
agentsim has quit
2017-10-17 29039, 2017
UmkaDK joined the channel
2017-10-17 29039, 2017
arbenina joined the channel
2017-10-17 29020, 2017
agentsim joined the channel
2017-10-17 29036, 2017
agentsim has quit
2017-10-17 29045, 2017
D4RK-PH0ENiX joined the channel
2017-10-17 29032, 2017
d4rkie has quit
2017-10-17 29037, 2017
zas
Mooooin
2017-10-17 29035, 2017
rsh joined the channel
2017-10-17 29043, 2017
UmkaDK_ joined the channel
2017-10-17 29057, 2017
UmkaDK has quit
2017-10-17 29037, 2017
ruaok
moin, welcome back.
2017-10-17 29040, 2017
ruaok
are home yet?
2017-10-17 29047, 2017
zas
not yet, at mom's house, driving to home this afternoon
2017-10-17 29019, 2017
zas
arrived later yesterday, because my one-hour flight from Zurich was converted to a 4 hours mix of plane/bus/waiting time ...
2017-10-17 29030, 2017
ruaok
that sucks. :(
2017-10-17 29059, 2017
rsh
hello everyone, it's Rashi. I am new to metabrainz. I want to contribute to Listen Brainz. Could you please help me how should I start?
2017-10-17 29015, 2017
zas
Swiss was kind enough to provide me vouchers... 60 CHF of beer ;)
2017-10-17 29049, 2017
ruaok
ffs, this day is already fired.
2017-10-17 29053, 2017
zas
Hey rsh, welcome
2017-10-17 29004, 2017
ruaok
airbnb found against us about the damn washer.
2017-10-17 29015, 2017
ruaok
we owe $214 for something we didn't break.
2017-10-17 29019, 2017
zas
huh?
2017-10-17 29028, 2017
ruaok
I'n not going to rent from them in the future, this is BS.
2017-10-17 29043, 2017
zas
dont they have insurance for this kind of issues ?
2017-10-17 29055, 2017
rsh
hi zas , thank you!
2017-10-17 29056, 2017
ruaok
they should, I guess.
2017-10-17 29012, 2017
ruaok
but the washer was broken when we arrived. and they blamed us for it.
2017-10-17 29029, 2017
zas
ofc... bastards
2017-10-17 29057, 2017
ruaok
I guess you need to test and every damn little thing before you check into a place.
2017-10-17 29031, 2017
zas
it's almost impossible, how do can you check a washer machine on arrival ?
2017-10-17 29042, 2017
zas
s/do//
2017-10-17 29003, 2017
D4RK-PH0ENiX has quit
2017-10-17 29031, 2017
D4RK-PH0ENiX joined the channel
2017-10-17 29055, 2017
ruaok
sigh. really quite sick of my job right now.
2017-10-17 29007, 2017
ruaok
just dealing with BS. piles and piles of it.
2017-10-17 29016, 2017
zas
:(
2017-10-17 29030, 2017
zas
how can we help ?
2017-10-17 29030, 2017
ruaok
I'm off to paris tomorrow. I might just leave my laptop at home and not be online for a week and take a break.
2017-10-17 29043, 2017
ruaok
keep MB running while I am gone. :)
2017-10-17 29052, 2017
ruaok
not sure what might happen over the weekend though. :)
2017-10-17 29058, 2017
zas
ahah, trying ;))
2017-10-17 29026, 2017
ruaok
also, zas: they mistakenly reserved a hotel room for me for the last two nights. not sure if I can get out of that. I'll keep ya posted when I get there.
2017-10-17 29044, 2017
zas
i'll be at Paris on Friday, around 10:30
2017-10-17 29005, 2017
zas
for the hotel, well, it can be more confortable than the shared room at Gerard's flat... ;)
2017-10-17 29018, 2017
zas
Btw, i think i'll go to Fosdem in 2018, Feb, anyone planned to go ?
I'm out shopping for diwali, I'll ping you later today if you are free :)
2017-10-17 29038, 2017
reosarevok
ruaok: IIRC he's at a wedding
2017-10-17 29048, 2017
ruaok
ah, ok
2017-10-17 29053, 2017
reosarevok
What did you need?
2017-10-17 29024, 2017
ruaok
a brainstorming discussion on how to handle contractor conflicts like the one with quesito.
2017-10-17 29044, 2017
zas
samj1912: i'll drive back to my home soon, so i'll be offline for few hours
2017-10-17 29044, 2017
ruaok
we need to discuss this in public I guess, but given the nature of it it can be really hard. since it involves private stuff.
2017-10-17 29037, 2017
Dalek_ joined the channel
2017-10-17 29054, 2017
ruaok
this shit is draining me and I'm sick of being the punching bag for everyone
2017-10-17 29056, 2017
Dalek_ has quit
2017-10-17 29037, 2017
reosarevok
That's definitely a conversation that needs to happen, yes
2017-10-17 29044, 2017
reosarevok
If you're planning to go travel and keep away from your laptop as I read, maybe it makes sense to have it after you're back? Then everyone can think about how they think this should be dealt with and present it during the discussion
2017-10-17 29046, 2017
CatQuest
but like, what is the problem, does she want more money or what?
2017-10-17 29018, 2017
CatQuest
because i relly approve of this beign public, as soemone who isn't in the know, on the outside, this is jsut "stuff isn't owkring"....and that is it, us we have no insight in what the problem is, so we cna actulaly hlpe or mitigate or whatever
2017-10-17 29005, 2017
ruaok
before I delve into details, I want to establish a game plan. I just dont know where to start and I'm really burnt out.
2017-10-17 29019, 2017
CatQuest
take a break, things will look better after a break
2017-10-17 29048, 2017
ruaok
next 3 days are in paris for a music conference. all work.
2017-10-17 29013, 2017
drsaunde joined the channel
2017-10-17 29037, 2017
arbenina_ joined the channel
2017-10-17 29057, 2017
spuniun joined the channel
2017-10-17 29057, 2017
Slurpee joined the channel
2017-10-17 29057, 2017
Slurpee has quit
2017-10-17 29057, 2017
Slurpee joined the channel
2017-10-17 29050, 2017
drsaunde has quit
2017-10-17 29011, 2017
jwf|matrix
samj1912, zas: re, FOSDEM: I was planning to submit a MB talk of some kind, we should maybe start a scratch pad for any of these ideas so we don't overlap. :)
2017-10-17 29014, 2017
ruaok
just be aware that it can be hard to get a talk accepted. while we are all open source and shit, we're not a critical piece of infrastructure that really benefits FOSDEM attendees.
