2020-04-30T00:25:24 -heroes-bot- PROBLEM: MySQL WSREP recv on galera3.infra.opensuse.org - CRIT wsrep_local_recv_queue_avg = 59.806620 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=galera3.infra.opensuse.org&service=MySQL%20WSREP%20recv 2020-04-30T04:43:26 -heroes-bot- PROBLEM: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS CRITICAL: DB postgres total waiting locks: 4 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks 2020-04-30T04:53:27 -heroes-bot- RECOVERY: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS OK: DB postgres total=8 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks 2020-04-30T11:36:42 cboltz: Hi Christian! Hope you are doing well. As you have helped me last time, I got e-mails from old progress instance today. Seems that it got magically spawned again =) 2020-04-30T11:37:06 interesting[tm], let me check... 2020-04-30T11:43:06 ah, there's a cronjob that (seems to) send the reminder mails (and you are probably not the only recipient of those mails) 2020-04-30T11:43:09 disabled now 2020-04-30T11:49:32 interestingly, there is no such cronjob on the new server - https://progress.opensuse.org/issues/66277 opened 2020-04-30T11:49:47 tuanpembual: can you please have a look at this? 2020-04-30T11:59:42 sure 2020-04-30T12:30:45 cboltz: Thanks again for the help! 2020-04-30T12:31:16 cboltz: yeah, there were couple of people complaining on rocket chat, so they also appreciate your help ;) 2020-04-30T12:32:13 you should warn them that the sillence will end once tuanpembual has enabled the reminder mails on the new server ;-) 2020-04-30T12:32:50 cboltz: =D 2020-04-30T12:41:19 I think here link of plugin https://github.com/f0y/due_date_reminder 2020-04-30T12:41:41 or difference? 2020-04-30T12:42:45 *it is true. Lets me do something :D 2020-04-30T13:21:47 cboltz: 2020-04-30T13:21:58 I add new plugins. 2020-04-30T13:22:10 https://github.com/mintow/cuckoos 2020-04-30T13:22:19 I need help for testing this reminder. 2020-04-30T13:30:57 Do you guys have a testing instance providing "OpenID Connect" or something that we could try openQA against to be ready for any new authentication setup? 2020-04-30T13:49:56 lcp, Eighth_Doctor, et al, we are planning to make the Forums read-only on the 10th of May, on the 11th Accenture have scheduled a final dump and transfer to Per. 2020-04-30T13:57:26 -heroes-bot- PROBLEM: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS CRITICAL: DB postgres total locks: 59 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks 2020-04-30T14:02:40 tuanpembual: what exactly do you need help for? 2020-04-30T14:03:20 (I'd guess the way to test is 1) install the plugin 2) set a due date in a ticket and 3) wait for mail - but maybe I'm thinking too simple ;-) 2020-04-30T14:06:44 okurz: LCP and I have an OIDC endpoint on sso.opensuse.org 2020-04-30T14:07:17 malcolmlewis: we are as ready as we can be, whether we end up using SUSE or openSUSE accounts, you don't need to worry :P 2020-04-30T14:07:27 LCP can generate you the client credentials, just send an email to admin@o.o so we can track it 2020-04-30T14:07:34 obviously you can guess what my preference is, but oh well 2020-04-30T14:08:18 tuanpembual: you might also want to have a look at https://github.com/MicroHealthLLC/due_date_reminder which is an updated version of the plugin we used before (description says for redmine 3.2.x, hopefully 3.4.x doesn't differ too much) 2020-04-30T14:09:33 okurz: an if you want to use OpenID and not OpenID Connect, using sso.opensuse.org should work (except we don't have accounts to really use that with) 2020-04-30T14:10:02 LCP: well, we can create a few test accounts manually 2020-04-30T14:10:30 cboltz never mind. I try another scenario. Get error some like `NameError: uninitialized constant ReminderMailer` 2020-04-30T14:10:31 yeah, except people have to have access to internal VPN to do the initial password change 2020-04-30T14:10:59 oh right, I forgot about that 2020-04-30T14:14:19 cboltz do you receive reminder email? 2020-04-30T14:15:48 not really - but that's probably because I don't have tickets with a due date assigned 2020-04-30T14:18:22 as a sidenote - our "old" plugin has an interesting fork tree, and some of the forks mention compability to redmine 3.x or even 4.x 2020-04-30T14:19:30 those are https://github.com/ilya-il/due_date_reminder https://github.com/maiklindner/due_date_reminder https://github.com/terenaa/redmine-due-date-reminder-plugin https://github.com/webgradus/due_date_reminder and https://github.com/MicroHealthLLC/due_date_reminder 2020-04-30T14:19:53 thanks for link 2020-04-30T14:22:36 lcp, yup thanks for all you (and the rest of the Heroes) hard work, it's appreciated 2020-04-30T15:01:03 cboltz, kl_eisbaer: where is connect hosted, does me asking for access to the machine even make sense? 2020-04-30T15:01:39 lcp: according to our Salt docu, it's connect.infra.opensuse.org ... 2020-04-30T15:02:00 we had a look at freeipa's capabilities in regards to alias assignment with postfix, and it seems we can just replace that part of connect with freeipa too 2020-04-30T15:02:20 freeipa does so many things we have between connect and the account system it's crazy 2020-04-30T15:03:33 kl_eisbaer: I might ask for it then, I would migrate aliases and other connect-bound stuff to freeipa with the account system too 2020-04-30T15:04:46 lcp: as you have access to Gitlab, you should be able to "answer" the "access to connect" question yourself ;-) 2020-04-30T15:07:26 -heroes-bot- RECOVERY: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS OK: DB postgres total=21 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks 2020-04-30T15:07:34 it's not that easy - it's a SLE 11 which means sudo doesn't work, so lcp will need an addition to /root/.ssh/authorized_keys 2020-04-30T15:07:52 (login as user works, and most things should be visible without root permissions) 2020-04-30T15:09:49 also, being admin in the connect.o.o web interface might be more helpful to see which fields we have in the user profile 2020-04-30T15:39:09 kl_eisbaer: https://monitor.opensuse.org/icinga/ tells me "It appears as though you do not have permission to view information for any of the hosts you requested...", so I can't do much 2020-04-30T15:40:38 okurz[m]: can you please check https://monitor.opensuse.org/icingaweb2/ instead? - I am currently migrating away from the old installation... 2020-04-30T15:43:21 okurz[m]: https://monitor.opensuse.org/icingaweb2/monitoring/host/show?host=openqa.infra.opensuse.org 2020-04-30T15:43:29 or https://monitor.opensuse.org/icingaweb2/monitoring/host/services?host=openqa.infra.opensuse.org 2020-04-30T15:43:42 should give you some information 2020-04-30T15:44:33 cboltz: I always hated that back then `tree` wasn't a standard command >:D 2020-04-30T15:44:38 but sudo, pls 2020-04-30T15:46:37 cboltz: also, I assume that machine still uses the same stuff to setup aliases as it appears to in the connect repo on github? 2020-04-30T15:51:41 cboltz error gone. 2020-04-30T15:52:00 it should working, but need someone to reproduce error. 2020-04-30T15:52:13 to verify 2020-04-30T15:58:49 okurz[m] 2020-04-30T15:59:10 I am forget about issue redmine_project_specific_email_sender 2020-04-30T15:59:42 can you explain again how reproduce error at setting? 2020-04-30T15:59:44 thanks 2020-04-30T16:18:39 lcp: ssh root@boosters.i.o.o - sudo won't work on SLE 11 2020-04-30T16:20:37 okurz[m] cboltz outbout email fixed. :D 2020-04-30T16:21:03 need used forking plugin, found somewhere on github. 2020-04-30T16:21:05 :D 2020-04-30T16:25:53 ah, boosters, sounds familiar 2020-04-30T16:39:59 tuanpembual: as long as you remember / write down what "somewhere" means - fine :-) 2020-04-30T16:42:07 sure, I update readme at redmine-doc on gitlab. 2020-04-30T16:42:19 thanks! 2020-04-30T16:45:18 tuanpembual: for the project specific email sender: 2020-04-30T16:45:41 - there should be a field to set the sender address in the settings of each project (not only in the global redmine settings) 2020-04-30T16:45:53 - if an address is set there, it should be used ;-) 2020-04-30T16:46:11 https://progress.opensuse.org/projects/opensuse-admin/settings/outbound_email 2020-04-30T16:46:21 can you access this page? 2020-04-30T16:47:01 yes, looks good 2020-04-30T17:00:36 Great news 2020-04-30T17:29:33 cboltz: I gotta say, the setup on connect is highly interesting™︎ 2020-04-30T17:30:50 eh, I will be glad to get rid of the rest of it tbh 2020-04-30T18:38:19 yes, interesting? is a good description ;-) 2020-04-30T18:38:36 if you need a guide to understand the server setup, I can probably help 2020-04-30T18:38:56 but my understanding of the connect.o.o php code is very limited - I only grepped it one or two times 2020-04-30T18:39:25 BTW: do you also want admin permissions on the connect.o.o frontend so that you can see all the fields in the user profile? 2020-04-30T18:39:39 could be easier than reverse-engeneering that from the database ;-) 2020-04-30T18:40:13 (maybe we don't need to keep all those fields, but knowing what we have today can't hurt) 2020-04-30T18:44:31 sure 2020-04-30T18:45:53 https://connect.opensuse.org/pg/profile/hellcp/edit/ should give you some ;-) additional fields now 2020-04-30T18:46:43 most important: some fields for the opensuse.org email alias (keep them "Public", otherwise the alias breaks) 2020-04-30T18:50:12 alright, got it 2020-04-30T18:51:27 the email stuff being self-service will make maintenance over this easier most likely 2020-04-30T18:52:17 yes, but OTOH - on average, I need 5 minutes per month for that, so the savings are limited ;-) 2020-04-30T18:52:25 although people will have above and beyond the amount of things they will be able to set with email stuff 2020-04-30T18:52:48 between the main email, bugzilla email and alias target