#metabrainz

/

      • shivam-kapila
        Maybe give them a warning mail to change email if its allowed
      • 2020-05-18 13918, 2020

      • Freso
        I’d wager that anyone with the ability to set up an MB bot would also be able to make an e-mail/forwarding e-mail to use for it.
      • 2020-05-18 13920, 2020

      • yvanzo
        I don’t think we should block it, but just disallow it in user policy, and have automated checks.
      • 2020-05-18 13924, 2020

      • alastairp
        Freso: yeah, that
      • 2020-05-18 13931, 2020

      • Freso
        alastairp: That’s my experience so far.
      • 2020-05-18 13948, 2020

      • reosarevok
        yvanzo: my other idea was to allow it, but email the account admins every time someone registers an account with an already used email
      • 2020-05-18 13949, 2020

      • pristine__
        Hey
      • 2020-05-18 13954, 2020

      • reosarevok
        To check for sockpuppetry etc
      • 2020-05-18 13954, 2020

      • pristine__
        Is the meeting over?
      • 2020-05-18 13908, 2020

      • alastairp
        reosarevok: sounds like a lot of work for one poor person
      • 2020-05-18 13909, 2020

      • reosarevok
        But seeing there's 20k, I'm not sure whether that wouldn't be too crazy an amount of emails :/
      • 2020-05-18 13915, 2020

      • pristine__
        There was some intern problem here
      • 2020-05-18 13919, 2020

      • pristine__
        Internet*
      • 2020-05-18 13925, 2020

      • yvanzo
        +1 alastairp
      • 2020-05-18 13933, 2020

      • Freso
        Re: b) Existing accounts. I expect an amount of these to be spammers/sockpuppets that we haven’t discovered yet. Hopefully we’ll get more tools to invesitgate these as SpamBrainz develops.
      • 2020-05-18 13935, 2020

      • alastairp
        my feeling is that preventing it from now-on is a reasonable solution
      • 2020-05-18 13940, 2020

      • Freso
        For now, I’d say grandfather them in.
      • 2020-05-18 13949, 2020

      • Freso
        We can review later.
      • 2020-05-18 13949, 2020

      • ruaok
        +1
      • 2020-05-18 13906, 2020

      • alastairp
        it does mean that you can't do stuff like a unique constraint to force it, but maybe if we delete sockpuppets we'll end up with only a small amount of accounts (??!?)
      • 2020-05-18 13920, 2020

      • Mr_Monkey
        Regarding b) Can we send an email asked for confirmation that the account is active, and block all but one account otherwise?
      • 2020-05-18 13922, 2020

      • Freso
        alastairp: That was what I was trying to get at. :p
      • 2020-05-18 13928, 2020

      • reosarevok
        Ok. So for bots, ask them to mail us and we can change their email, for anything else, just block it, for existing ones, just let them be?
      • 2020-05-18 13948, 2020

      • Freso
        alastairp: If it turns out to be ~10 legit e-mails that share >1 account, we can probably figure something out.
      • 2020-05-18 13910, 2020

      • reosarevok
        Does everyone agree with that course of action?
      • 2020-05-18 13913, 2020

      • Freso
        reosarevok: And ignore +-mails for now.
      • 2020-05-18 13919, 2020

      • Freso
        But yes, I agree with that. +1
      • 2020-05-18 13924, 2020

      • ruaok
        +1
      • 2020-05-18 13927, 2020

      • alastairp
        it sounds like most people are generally in agreement with this, and implementation details can be worked out outside-of-meeting
      • 2020-05-18 13928, 2020

      • alastairp
        +1
      • 2020-05-18 13930, 2020

      • reosarevok
        bitmap, yvanzo ?
      • 2020-05-18 13933, 2020

      • zas
        +1
      • 2020-05-18 13942, 2020

      • yvanzo
        not really convinced yet
      • 2020-05-18 13951, 2020

      • reosarevok
        yvanzo: what would be your alternative?
      • 2020-05-18 13903, 2020

      • reosarevok
        (if you don't have it yet we can talk about it later :) )
      • 2020-05-18 13906, 2020

      • yvanzo
        there are too many details to be discussed for a decision here
      • 2020-05-18 13918, 2020

      • Freso
        Notification e-mail to mb-account-admin when a duplicate e-mail is used?
      • 2020-05-18 13923, 2020

      • bitmap
        I'm fine with leaving existing ones + blocking new ones, I think
      • 2020-05-18 13933, 2020

      • reosarevok
        yvanzo: you can comment on the ticket, which is...
      • 2020-05-18 13940, 2020

      • reosarevok
      • 2020-05-18 13940, 2020

      • BrainzBot
        MBS-10835: Disallow creating new accounts with an e-mail already in use
      • 2020-05-18 13944, 2020

      • bitmap
        we could also have an admin page that shows accounts with dupe emails and/or show "linked" accounts on their user page
      • 2020-05-18 13959, 2020

      • reosarevok
        (I guess after this pristine__ can quickly give her review? :) )
      • 2020-05-18 13921, 2020

      • Freso
        I’d be happy both with outright blocking but also with tools (mail notifications, "report" page) showing the information.
      • 2020-05-18 13931, 2020

      • reosarevok
        I'll leave a note on the ticket saying most people liked that blocking option but that we're not fully decided yet
      • 2020-05-18 13941, 2020

      • reosarevok
        And then let's see what yvanzo and others come up with :)
      • 2020-05-18 13910, 2020

      • Freso
        Please just don’t let this wait for SpamBrainz. It is needed (much) sooner.
      • 2020-05-18 13926, 2020

      • reosarevok
        Yeah, I'd like to have a decision by next meeting
      • 2020-05-18 13930, 2020

      • yvanzo
        We can take action against existing sockpuppets much sooner.
      • 2020-05-18 13932, 2020

      • bitmap
        though I wonder if people are just going to create sockpuppets anyway and this makes the lazy ones easy to find
      • 2020-05-18 13935, 2020

      • Freso
        I don’t care how hacky a (temporary) solution is, as long as it’s working.
      • 2020-05-18 13958, 2020

      • Freso
        bitmap: Some of the sockpuppets I’ve dealt with have used new mails for every account already.
      • 2020-05-18 13907, 2020

      • Freso
        So yeah, it won’t help for all of them.
      • 2020-05-18 13918, 2020

      • Freso
        But it’ll help with some, which is better than what we have now…
      • 2020-05-18 13915, 2020

      • Freso
        Anyway, I think reosarevok’s resolution is correct, so let’s touch base on this maybe next week again.
      • 2020-05-18 13934, 2020

      • Freso
        So pristine__, want to give a quick review before we wrap up the meting?
      • 2020-05-18 13953, 2020

      • reosarevok
        rdswift: I certainly wouldn't want all but the oldest to be disabled for my own case, that seems to have 3 edits :D
      • 2020-05-18 13909, 2020

      • Freso
        I guess no pristine__ review.
      • 2020-05-18 13914, 2020

      • Freso
        Alright.
      • 2020-05-18 13924, 2020

      • Freso
        Thank you everyone for your time!
      • 2020-05-18 13926, 2020

      • Freso
        </BANG>
      • 2020-05-18 13930, 2020

      • yvanzo
        Thanks Freso!
      • 2020-05-18 13957, 2020

      • Mr_Monkey
        Thanks Freso
      • 2020-05-18 13915, 2020

      • alastairp
        jmp_music: if you want to be included in the weekly meetings, tell Freso and he will add you to his list. then someone can call on you as we go through the reviews
      • 2020-05-18 13920, 2020

      • BrainzGit
        [bookbrainz-site] MonkeyDo merged pull request #423 (master…add-user-in-search): search: add 'editor' type in the search result https://github.com/bookbrainz/bookbrainz-site/pul…
      • 2020-05-18 13940, 2020

      • travis-ci joined the channel
      • 2020-05-18 13940, 2020

      • travis-ci
        Project bookbrainz-site build #2983: passed in 3 min 14 sec: https://travis-ci.org/bookbrainz/bookbrainz-site/…
      • 2020-05-18 13940, 2020

      • travis-ci has left the channel
      • 2020-05-18 13943, 2020

      • Freso
        ^ anyone else too. :) I should make a list of all the GSoC students actually, so you can be called on.
      • 2020-05-18 13958, 2020

      • Mr_Monkey
        prabal ^
      • 2020-05-18 13959, 2020

      • alastairp
        Mr_Monkey: I was thinking about your player, especially as you said adding youtube
      • 2020-05-18 13907, 2020

      • Mr_Monkey
        Yes?
      • 2020-05-18 13911, 2020

      • alastairp
        https://tickets.metabrainz.org/browse/AB-312 has been annoying reosarevok for who knows how long
      • 2020-05-18 13911, 2020

      • BrainzBot
        AB-312: Either improve or remove the YouTube matching
      • 2020-05-18 13916, 2020

      • alastairp
        could be neat to include it there
      • 2020-05-18 13953, 2020

      • Mr_Monkey
        Now that you have React that might be possible, although I'll have to admit I don't think it'll work any better than on AB
      • 2020-05-18 13901, 2020

      • Mr_Monkey
        Limitations of the youtube search
      • 2020-05-18 13902, 2020

      • yvanzo
        Yup, diru1100 is usually in, was probably just not available today ^
      • 2020-05-18 13926, 2020

      • alastairp
        right, but a good match on spotify is much better than a mediocre match on youtube
      • 2020-05-18 13936, 2020

      • alastairp
        so, start with spotify and fall back on yt only if not found
      • 2020-05-18 13908, 2020

      • Mr_Monkey
        Right. That works for users with a spotify account. Otherwise, the Spotify fallback is a 30 second snippet of the track.
      • 2020-05-18 13927, 2020

      • diru1100
        Hey, sorry about not being part of the meeting. Had some internet issues.
      • 2020-05-18 13931, 2020

      • Mr_Monkey
        But I assume yes, we'll eventually want to integrate BrainzPlayer on AB (as well as on MB, Cb, …)
      • 2020-05-18 13934, 2020

      • sumedh has quit
      • 2020-05-18 13950, 2020

      • BrainzGit
        [bookbrainz-site] MonkeyDo opened pull request #427 (master…new-tab): fix: fix mentions of "open in a new tab" https://github.com/bookbrainz/bookbrainz-site/pul…
      • 2020-05-18 13959, 2020

      • travis-ci joined the channel
      • 2020-05-18 13959, 2020

      • travis-ci
        Project bookbrainz-site build #2984: passed in 3 min 5 sec: https://travis-ci.org/bookbrainz/bookbrainz-site/…
      • 2020-05-18 13959, 2020

      • travis-ci has left the channel
      • 2020-05-18 13900, 2020

      • alastairp
        cool, all of those ideas sound great
      • 2020-05-18 13952, 2020

      • _lucifer
        hi ruaok, I want to setup Firebase TestLab in conjunction to the CI. It allows the app to be tested on actual devices. It requires to set up a GCP with billing enabled. I only intend to use the free quota. Can you setup a google cloud project with editor access for me?
      • 2020-05-18 13905, 2020

      • diru1100
        Freso: kindly add to me to regular list, will be joining in every upcoming meeting.
      • 2020-05-18 13954, 2020

      • jmp_music has quit
      • 2020-05-18 13913, 2020

      • Freso
        diru1100, jmp_music, and others: Actually, scratch my last message: add yourselves, please ;) https://wiki.musicbrainz.org/User:Freso/MetaBrain…
      • 2020-05-18 13920, 2020

      • Freso
        Guess I missed jmp.
      • 2020-05-18 13939, 2020

      • alastairp
        I'm meeting with him on Wednesday, I'll remind him
      • 2020-05-18 13921, 2020

      • yvanzo
        bitmap: anything I can help with the afterafter upgrade?
      • 2020-05-18 13922, 2020

      • Freso
        Cheers.
      • 2020-05-18 13929, 2020

      • shivam-kapila
        ruaok: Anything you want to discuss about or guide me before we start tomorrow?
      • 2020-05-18 13903, 2020

      • bitmap
        yvanzo: if the blog looks good you could publish that and tag the release if you don't mind
      • 2020-05-18 13906, 2020

      • BrainzGit
        [bookbrainz-site] MonkeyDo merged pull request #427 (master…new-tab): fix: fix mentions of "open in a new tab" https://github.com/bookbrainz/bookbrainz-site/pul…
      • 2020-05-18 13930, 2020

      • bitmap
        maybe we should have a jira versions and list some tickets there... pretty sure there were some about PG extensions
      • 2020-05-18 13924, 2020

      • bitmap
        nvm I see a Postgres 12 one already, I'll add things there
      • 2020-05-18 13949, 2020

      • ruaok
        shivam-kapila: naw, let's touch base tomorrow.
      • 2020-05-18 13920, 2020

      • yvanzo
        bitmap: I can tag production I guess?
      • 2020-05-18 13924, 2020

      • shivam-kapila
        Okay. :)
      • 2020-05-18 13925, 2020

      • bitmap
        yeah
      • 2020-05-18 13933, 2020

      • ruaok
        _lucifer: hmm. I'd rather not. we had this little snafu where we ended up with $21,000 bill from google big query
      • 2020-05-18 13955, 2020

      • ruaok
        we didn't have to pay it, but it was a hassle.
      • 2020-05-18 13904, 2020

      • travis-ci joined the channel
      • 2020-05-18 13904, 2020

      • travis-ci
        Project bookbrainz-site build #2986: failed in 3 min 20 sec: https://travis-ci.org/bookbrainz/bookbrainz-site/…
      • 2020-05-18 13904, 2020

      • travis-ci has left the channel
      • 2020-05-18 13912, 2020

      • ruaok
        if you only plan to use the free tier, can you not use a personal card?
      • 2020-05-18 13931, 2020

      • _lucifer
        Yeah, I'll try with that
      • 2020-05-18 13953, 2020

      • shivam-kapila
        You also get 300USD credits for a safe side
      • 2020-05-18 13949, 2020

      • shivam-kapila
        I dont know if that will add to previous account or you are eligible only once for credits but published google actions also gives 300USD credits.
      • 2020-05-18 13959, 2020

      • _lucifer
        I think its for new accounts for only but i'llcheckthat just in case
      • 2020-05-18 13912, 2020

      • sumedh joined the channel
      • 2020-05-18 13938, 2020

      • Mr_Monkey
        Well done again bitmap for the update today, that was really smooth !
      • 2020-05-18 13955, 2020

      • Mr_Monkey
        And thanks ruaok for reminding me BB would be affected. Woops !
      • 2020-05-18 13908, 2020

      • bitmap
        <3
      • 2020-05-18 13915, 2020

      • bitmap
        thanks for all the help today too
      • 2020-05-18 13929, 2020

      • Mr_Monkey
        And now, government mandated outside time.
      • 2020-05-18 13945, 2020

      • alastairp
        Mr_Monkey: govt _approved_ :)
      • 2020-05-18 13952, 2020

      • alastairp
        they're not making you go out, I think :)
      • 2020-05-18 13939, 2020

      • olafurw joined the channel
      • 2020-05-18 13941, 2020

      • olafurw
        Hey, love the service, quick question. How can I do a query like the "associated singles/EPs" on this page, https://musicbrainz.org/release-group/1cfc9a17-1f…
      • 2020-05-18 13922, 2020

      • olafurw
        I have the db setup on my end, just playing with the data, it would be enough to show me the query on github, find it a bit tricky to search for since I'm not that versed in perl
      • 2020-05-18 13903, 2020

      • ruaok
        Mr_Monkey: did you upgrade any BB parts?
      • 2020-05-18 13913, 2020

      • ruaok
        I just restarted everything and it just worked. all of it.
      • 2020-05-18 13923, 2020

      • ruaok
        ok, off a walk!
      • 2020-05-18 13930, 2020

      • ruaok
        thanks for the productive and fun day, team!
      • 2020-05-18 13957, 2020

      • olafurw
        I think I found the inverse, if I have a recording, in what release group it appears on, sub appears_on in Data/Recording.pm
      • 2020-05-18 13923, 2020

      • CatQuest
        Mr_Monkey: this is weird. it seems https://tickets.metabrainz.org/browse/BB-470 is fixed now??
      • 2020-05-18 13924, 2020

      • BrainzBot
        BB-470: Work sorting in editions
      • 2020-05-18 13918, 2020

      • Guest74203 has quit
      • 2020-05-18 13930, 2020

      • reosarevok
        olafurw: that's a relationship, so the table you want is l_release_group_release_group
      • 2020-05-18 13951, 2020

      • olafurw
        cheers!
      • 2020-05-18 13915, 2020

      • reosarevok
      • 2020-05-18 13951, 2020

      • olafurw
        YES! I was too focused on the main big relationship picture.
      • 2020-05-18 13956, 2020

      • olafurw
        Thanks!
      • 2020-05-18 13953, 2020

      • BrainzGit
        [musicbrainz-docker] yvanzo merged pull request #146 (master…pg12): PostgreSQL 12 upgrade with one-off script https://github.com/metabrainz/musicbrainz-docker/…
      • 2020-05-18 13903, 2020

      • djikstra has quit
      • 2020-05-18 13904, 2020

      • BrainzGit
        [musicbrainz-docker] release v-2020-05-18-postgres12 has been published by yvanzo: https://github.com/metabrainz/musicbrainz-docker/…
      • 2020-05-18 13941, 2020

      • olafurw
        reosarevok: bingo, thank you again, this was exactly what I was missing.
      • 2020-05-18 13958, 2020

      • yvanzo
      • 2020-05-18 13920, 2020

      • cleo joined the channel
      • 2020-05-18 13956, 2020

      • cleo is now known as Guest99647
      • 2020-05-18 13938, 2020

      • sumedh has quit
      • 2020-05-18 13917, 2020

      • alastairp
        great to see that the musicbrainz extensions are no longer needed
      • 2020-05-18 13918, 2020

      • sumedh joined the channel