*** Pali has quit IRC | 00:42 | |
*** M4rtinK has quit IRC | 02:51 | |
*** sixwheeledbeast^ has quit IRC | 05:37 | |
*** sixwheeledbeast has joined #maemo-meeting | 05:40 | |
*** Oksana has quit IRC | 06:48 | |
*** Oksana_ has joined #maemo-meeting | 06:57 | |
*** reinob has joined #maemo-meeting | 07:21 | |
*** Oksana_ is now known as Oksana | 08:51 | |
*** jskarvad has joined #maemo-meeting | 10:16 | |
*** jskarvad has quit IRC | 12:33 | |
*** jskarvad has joined #maemo-meeting | 13:49 | |
reinob | juiceme: you there? | 16:23 |
---|---|---|
reinob | I'm on step (2) of your instructions (updating karma). However how I can I know who needs a manual karma update? | 16:23 |
reinob | your example (mosen with karma=0) is not even in the electorate table.. | 16:24 |
reinob | OK I've inserted mosen into electorate with the right karma and talk_id (I left creation_date as NULL, expected it would be automatically populated..) | 16:37 |
reinob | for the candidates I've also updated the karma, although it's not necessary | 16:37 |
reinob | now on to step (3) but at 17:00 | 16:38 |
*** jskarvad has quit IRC | 17:10 | |
reinob | it's OK now. I had understood step (2) to refer to the electorate table instead of midgard_users; | 18:47 |
reinob | sorry for the mixup | 18:47 |
*** freemangordon1 has quit IRC | 20:50 | |
*** freemangordon has joined #maemo-meeting | 20:50 | |
*** Pali has joined #maemo-meeting | 21:07 | |
*** M4rtinK has joined #maemo-meeting | 21:46 | |
*** Win7Mac has joined #maemo-meeting | 22:00 | |
Win7Mac | knock knock... | 22:13 |
reinob | hallo | 22:20 |
reinob | in the end I've managed to do the election set-up today. I'm only missing the voting token generation, which is not so clear (to me) | 22:22 |
reinob | hopefully juiceme can clear that up | 22:22 |
Win7Mac | hi reinob! | 22:23 |
Win7Mac | thanks! | 22:23 |
reinob | just to confirm: we have 6 candidates: juiceme, win7mac, pichlo, eekkelund, mosen and reinob | 22:24 |
reinob | that about right? :) | 22:24 |
Win7Mac | yeah | 22:24 |
reinob | OK. In any case juiceme will check the database to make sure I didn't mix up | 22:24 |
Win7Mac | yes, you should contact directly | 22:25 |
reinob | I think he will show up here sooner or later | 22:25 |
Win7Mac | yes, I mean you probably shouldn't discuss it publicly | 22:26 |
Win7Mac | the technical matters | 22:26 |
reinob | ah OK | 22:26 |
*** M4rtinK has quit IRC | 22:28 | |
juiceme | hi! | 22:29 |
juiceme | reinob, Win7Mac, | 22:30 |
Win7Mac | hi juiceme! | 22:30 |
reinob | hey juiceme! | 22:30 |
reinob | I was just answering your e-mail when I saw you pop-up here | 22:30 |
juiceme | reinob just checked database | 22:30 |
juiceme | yes | 22:30 |
juiceme | reinob, so you actually inserted the record for mosen... odd | 22:31 |
juiceme | it was not gathered from midgard ? | 22:31 |
reinob | I inserted it in electorate, but then saw that it was already in midgard_users, so I deleted it and did step (3). | 22:31 |
reinob | Yes it was. I just mixed up one table with the other. I thought step (2) referred to electorate and not to midgard_users | 22:32 |
reinob | it was all OK | 22:32 |
juiceme | yes, the electorate update builds the midgard_users table | 22:32 |
juiceme | ok, good it was sorted out :) | 22:32 |
reinob | (Win7Mac, Juiceme: OK to discuss technical matters here? no passwords of course..) | 22:32 |
juiceme | reinob true, if we need to discuss delicate things then we can go to maemo-admin channel or do 1to1 | 22:33 |
reinob | OK | 22:33 |
juiceme | but probably no need | 22:33 |
juiceme | so, have you started to create the election nyet? | 22:34 |
reinob | the last step about the tokens, I'm not sure I did it correctly. election_anon_tokens where election_id=45 (the id of the new election) is empty | 22:34 |
Win7Mac | okunless delicate ;) | 22:34 |
reinob | it's all done except the tokens | 22:34 |
juiceme | I'll check the webfrontend, just a moment | 22:35 |
reinob | aha, but election_tmp_tokens has the 5529 tokens. sounds right. | 22:36 |
juiceme | so, have you done "Create New Election" yet? | 22:37 |
reinob | yes! :) | 22:37 |
juiceme | as I see no election in the list | 22:37 |
reinob | in http://maemo.org/vote/admin.php you don't see "Community Council Election Q2 2016"? | 22:38 |
juiceme | nope | 22:38 |
juiceme | hmm | 22:38 |
reinob | (cache issue?) | 22:38 |
juiceme | maybe I need to logout and in | 22:38 |
reinob | it even has an id ;-) (45) | 22:38 |
juiceme | heh, now I see it! | 22:39 |
Win7Mac | it's already online http://maemo.org/vote/ | 22:39 |
juiceme | was not really logged in, just had old tab open in firefox :) | 22:40 |
reinob | OK! | 22:40 |
juiceme | ok, just a moment I'll check the content of the election :) | 22:40 |
juiceme | dates seem to be OK :) | 22:42 |
Win7Mac | now wait a sec please | 22:44 |
juiceme | Win7Mac, yes? | 22:44 |
Win7Mac | 23:59:59 UTC is for deadlines only, not for starting | 22:45 |
Win7Mac | here http://maemo.org/vote/ it reads *Starting 2016-04-25 23:59:59 UTC* | 22:45 |
juiceme | ah, that's true | 22:45 |
juiceme | should be 00:00:01 ? | 22:45 |
Win7Mac | yes | 22:46 |
Win7Mac | or 00:00:00 | 22:46 |
reinob | yup (or 00:00:00) | 22:46 |
reinob | ;) | 22:46 |
Win7Mac | ;) | 22:47 |
reinob | I think I did it because I saw the one for Q2 2015 was like that (maybe I didn't see it right) | 22:47 |
juiceme | well could be it was not correct there :) | 22:47 |
reinob | should I correct that (not that we do it both simultaneously) | 22:47 |
juiceme | reinob, do that, please, I am checking if the tempalte is OK. | 22:48 |
juiceme | template I mean | 22:48 |
reinob | done | 22:49 |
juiceme | since last time we kind-of botshed it, the system supports the new direct voting links but the template contained wrong url | 22:49 |
Win7Mac | probably do a test election first? | 22:49 |
juiceme | I am wuite sure I *did* correct the template but just to be sure... | 22:50 |
reinob | do you know where the e-mail template is stored? didn't find it in the db | 22:50 |
juiceme | it is in the automailer directory :) | 22:50 |
juiceme | you bet I searched for it a *long* time the first time! | 22:50 |
Win7Mac | all this knowledge must be saved somehow | 22:51 |
juiceme | yes, documentation helps but it is a pain to keep it up-to-date | 22:51 |
juiceme | reinob, check content of /usr/local/bin/cronmailer/templates/ | 22:52 |
reinob | for now it seems to be well-documented. I've taken some notes and then I may update the wiki if anything is not clear enough | 22:52 |
reinob | juiceme: yes, that's the text I wrote (adapted) | 22:53 |
juiceme | yes, I believe the link is correct. in the last election it was | 22:54 |
reinob | 5 members (because we're six candidates). 6 month. tmo thread OK. wiki link OK. login URL I don't know if correct or not | 22:54 |
juiceme | URL: http://maemo.org/vote/?election_id=44&email=<email>&token=<token> | 22:54 |
reinob | (it's taken from 2015Q2) | 22:54 |
juiceme | and now it is | 22:54 |
juiceme | URL: http://maemo.org/vote/vote.php?election_link=45&email=<email>&token=<token> | 22:54 |
juiceme | and the new one looks correct to me :) | 22:54 |
Win7Mac | what about adding ending time so it displays here? http://maemo.org/vote/ | 22:55 |
reinob | if only we knew where the page is stored.. | 22:56 |
juiceme | Win7Mac it's automatic :) | 22:56 |
juiceme | so if we want to change it, need to update scripts again :) | 22:57 |
reinob | could be done. I have a busy rest of the week but maybe @weekend | 22:58 |
Win7Mac | it'd be just a nice-to-have | 22:58 |
juiceme | yes. | 22:59 |
juiceme | OK, looks good to me. | 22:59 |
juiceme | I think we should launch it now! | 22:59 |
reinob | what about the tokens? I'm not sure where they should be. if you say it's OK then good. | 22:59 |
juiceme | ah, they should be OK, it says "This election has 5529 tokens" | 23:00 |
juiceme | but just a minute I'll check the DB | 23:01 |
reinob | ah OK I didn't remember having seen that. I thought the interface still wanted something from me and I didn't know what exactly ;-) | 23:01 |
juiceme | yep, seems OK; | 23:03 |
juiceme | mysql> | 23:03 |
juiceme | mysql> select count(*) from election_tmp_tokens where election_id=45; | 23:03 |
juiceme | +----------+ | 23:03 |
juiceme | | count(*) | | 23:03 |
juiceme | +----------+ | 23:03 |
juiceme | | 5529 | | 23:03 |
juiceme | +----------+ | 23:03 |
juiceme | 1 row in set (0.00 sec) | 23:03 |
juiceme | mysql> | 23:03 |
reinob | go up to 21:36. I said that already. I love it when things double-check :) | 23:04 |
juiceme | so go to the "Make/Clone/Mail Tokens" menu and hit "batch mail" | 23:04 |
juiceme | ah, of course :) | 23:05 |
juiceme | but double-check is our motto here | 23:05 |
Win7Mac | ;) | 23:06 |
reinob | "Tokens have been batched to mail" | 23:06 |
juiceme | Lovely! | 23:06 |
reinob | yeah! | 23:06 |
reinob | how are the e-mails actually sent? is MTA running on same server? | 23:07 |
juiceme | Now, as it happens there will probably be few persons crying that they do not receive the election mail. | 23:07 |
juiceme | yes, cronmailer via smtp | 23:07 |
juiceme | but as it happens, some people have lost/changed their mail (has happened before) | 23:08 |
juiceme | ans some people have no Garage account, only TMO (and still think they are able to vote) | 23:08 |
Win7Mac | guys, all links on this page are dead... http://maemo.org/vote/ | 23:09 |
juiceme | and some people have garage account OK, but have not linked to TMO and have Karma less than 10 in the books | 23:09 |
Win7Mac | oh sorry, not the important ones I guess | 23:09 |
juiceme | Win7Mac? | 23:09 |
reinob | only 3 people have karma < 10 | 23:09 |
juiceme | ah, you checked that already | 23:10 |
juiceme | did you calculate what the karma should be? | 23:10 |
reinob | nope | 23:10 |
juiceme | the formula is on one of the election pages, | 23:10 |
reinob | I don't know how (but something tells me I will learn that soon.. ;) | 23:10 |
juiceme | :) | 23:10 |
reinob | ah you mean manually? | 23:10 |
juiceme | well many things are taken into account | 23:11 |
juiceme | yes | 23:11 |
reinob | then in principle I could do that | 23:11 |
juiceme | but unless garage&TMO accounts are linked, karma gathers very slowly | 23:11 |
juiceme | since TMO gives lots of karma easily | 23:11 |
juiceme | TMO karma is calculated as sqrt(number-of-posts) + 8 * sqrt(number-of-thanks) | 23:12 |
reinob | OK if linked all is OK and if unlinked then only TMO-karma has to be manually added. The non-TMO-karma is assumed to be always correct? (hope so!) | 23:13 |
juiceme | otherwice, if not linked, you get karma only from wiki edits, package testing on garage, package uploads on garage, plus some other erelated actions | 23:13 |
juiceme | non-TMO is always correct. | 23:14 |
juiceme | but, the process to calculate it is fairly slow. There are about 30k accounts, and the Karma calculator slowly crawls thru all | 23:14 |
juiceme | it takes more than 2 weeks to go thru all :) | 23:15 |
reinob | maybe I can optimize that someday | 23:15 |
juiceme | hopefully! | 23:15 |
reinob | select count(*) from outbound_email where formname="election-45" | 23:15 |
reinob | goes slowly (cronmailer sleeps 3 seconds per e-mail) | 23:15 |
juiceme | I think there was some attempt to fix it, but it was not very succesful | 23:16 |
juiceme | cronmailer is fast compared to karma calulator | 23:16 |
reinob | but why >9000 e-mails for 5529 electorate? | 23:16 |
juiceme | it is not bu cron, insteaad a midgard plugin :) | 23:16 |
reinob | but it sends via mail.maemo.org who should be doing the queueing. it makes no sense for cronmailer to be "polite" to mail.maemo.org. it's only submitting e-mails for transmission | 23:17 |
reinob | plus it deletes from the table whether delivered or not (to MTA anyway). so there's a big risk of losing track of undelivered e-mails | 23:17 |
reinob | give me a week off and I'll clean up!!! | 23:17 |
juiceme | reinob, all this is correct! | 23:18 |
juiceme | you're welcome to fix it, if you have the time :) | 23:18 |
juiceme | what I think, it probably has some legacy reason why it works like that... | 23:18 |
juiceme | dating from when Maemo was hosted on different provider, maybe? | 23:19 |
reinob | could be.. | 23:19 |
juiceme | regarding why the email amount is > 5529... | 23:21 |
juiceme | good question. | 23:21 |
juiceme | possibility of duplicates? | 23:21 |
reinob | I hope I didn't already click on the "batch mail" button already this afternoon? | 23:22 |
juiceme | well... | 23:22 |
reinob | yup lots of duplicates | 23:23 |
reinob | (not all of them though..) | 23:23 |
juiceme | mysql> | 23:23 |
juiceme | mysql> select count(*) from outbound_email where username like "juiceme"; | 23:23 |
juiceme | +----------+ | 23:23 |
juiceme | | count(*) | | 23:23 |
juiceme | +----------+ | 23:23 |
reinob | my sql-fu doesn't help much now | 23:23 |
juiceme | | 2 | | 23:23 |
juiceme | +----------+ | 23:23 |
juiceme | 1 row in set (0.05 sec) | 23:23 |
juiceme | mysql> | 23:23 |
juiceme | yes, duplicates | 23:23 |
reinob | I did select * order by email | 23:23 |
juiceme | but hey, no problem | 23:24 |
reinob | shit. I thought I'd never become a spammer | 23:24 |
reinob | I feel dirty now :) | 23:24 |
juiceme | it'll just send a reminder email :) | 23:24 |
juiceme | dont' be, can happen to anybody :) | 23:24 |
juiceme | I guess people will understand | 23:25 |
juiceme | just blame the computer! | 23:25 |
reinob | quick: how can I delete all dups right now so that most people will only get a single email? | 23:25 |
juiceme | hmm... can't remember offhand | 23:27 |
juiceme | sure a sql query exists to do that, google might help | 23:28 |
juiceme | "mysql how to delete duplicates" maybe? | 23:29 |
reinob | did that but all replies seem to be pretty complicated | 23:29 |
juiceme | but have to specify duplicate of key "username" for example, not exact duplicate row | 23:29 |
juiceme | I'll check if I can meke sense of that | 23:30 |
*** M4rtinK has joined #maemo-meeting | 23:31 | |
reinob | something like select distinct ... into a temp table and then swap temp with real | 23:31 |
juiceme | well yes, but it could be done in place I think | 23:33 |
reinob | would be better but.. | 23:33 |
reinob | if you want I can try doing create temporary table as (select distinct email,username,tmp_token,formname from outbound_email; | 23:33 |
reinob | and then wipe the table and repopulate it from the temp table | 23:34 |
reinob | hoping that cronmailer won't get confused | 23:34 |
juiceme | what about "delete from outbound_email using outbound_email, outbound_email e1 where outbound_email.id > e1.id and outbound_email.username = e1.username;" | 23:36 |
reinob | I have created unique_email table. only no id field | 23:36 |
reinob | my sql is too rusty to comprehend that :) looks OK though and I have a backup in my unique_email table so lets go wild | 23:36 |
juiceme | your method is probably better | 23:36 |
reinob | your place or my place? | 23:36 |
juiceme | cronmailer won't be confused | 23:37 |
reinob | so I do: delete from outbound_email; | 23:37 |
reinob | and then how to a insert from unique_email into outbound_email? | 23:37 |
juiceme | as it takes a batch of rows and then waits, just check when that happens and then quickly do the swap | 23:37 |
reinob | but my knowledge is not enough to do the actual swap.. | 23:38 |
reinob | I'm more like a theoretical engineer | 23:38 |
juiceme | :) | 23:38 |
reinob | ah insert into newtable (col1,col2) select (col1,col2) from oldtable | 23:39 |
reinob | sounds OK | 23:39 |
reinob | I'll go for it now | 23:39 |
juiceme | ah, you mean how to insert content of your unique table back into email table? | 23:39 |
reinob | yes | 23:39 |
juiceme | yes, that does it | 23:39 |
reinob | shit | 23:40 |
reinob | (elections@db) [maemoelections]> insert into outbound_email (email,username,tmp_token,formname) select (email,username,tmp_token,formname) from unique_email; | 23:40 |
reinob | ERROR 1241 (21000): Operand should contain 1 column(s) | 23:40 |
reinob | now it worked! | 23:41 |
reinob | didn't need (..) on the right-hand side | 23:41 |
reinob | it worked!!!!!!! | 23:41 |
juiceme | yes, you have now 5529 entries in the table :) | 23:41 |
juiceme | ah, somebody is going to be double-mailed anyway :) | 23:42 |
reinob | yeah but we spotted it soon enough and thank god for that 3-second delay! :) | 23:42 |
juiceme | true again | 23:43 |
reinob | BTW do you know who has access to mail.maemo.org? | 23:43 |
juiceme | not too many mails got sent on the 1st roung | 23:43 |
reinob | would like to throw an eye in there.. | 23:43 |
juiceme | ask on #maemo-admin? | 23:43 |
reinob | yup. maybe I shouldn't get too much into this. separation of powers and such | 23:44 |
juiceme | this is community effort, I'd not be too worried | 23:44 |
reinob | anyway, it's getting late and tomorrow I have a hearing with (against) Microsoft, so I need to be awake :) | 23:45 |
reinob | GA meeting announcement? | 23:45 |
juiceme | true. time to go to bed | 23:45 |
juiceme | yes, I thnk that needs to be done still before this council says goodbye | 23:46 |
juiceme | reinob, good luck with the Microsofties! :) | 23:46 |
reinob | peterleinchen, Win7Mac: I think we needed some german-fu for this :) | 23:46 |
juiceme | yes, that is what I thought | 23:47 |
reinob | cronmailer does every 5 minutes 40 e-mails with 3-second delay | 23:48 |
reinob | do you mind if I tweak that a bit? | 23:48 |
reinob | like every 5 minutes 200 e-mails with 1-second delay? | 23:48 |
juiceme | I think it could be speeded up a little | 23:48 |
juiceme | it does only 480 mails per hour | 23:49 |
juiceme | which means that 5500 mails takes 11h | 23:49 |
Win7Mac | yes, I'll ask peterleinchen about progress with GA announcement | 23:50 |
juiceme | well not too bad I think... I thought it could take longer | 23:50 |
reinob | with 200 e-mails per 5-minutes it's 2400 per hour, so a bit more than 2 hours | 23:50 |
juiceme | so maybe not tweak that yet | 23:50 |
reinob | deal? | 23:50 |
juiceme | aaa I mnot sure | 23:50 |
juiceme | :) | 23:50 |
reinob | I leave it light it is then | 23:50 |
juiceme | 11h is not that bad | 23:50 |
juiceme | since there's a week to go | 23:51 |
reinob | good. Then someday I can check with techstaff about limits and queues | 23:51 |
juiceme | let's just keep it that way | 23:51 |
juiceme | yes | 23:51 |
juiceme | besides, 480 mails per hour, that sounds a bit like 480mph | 23:52 |
reinob | :) | 23:52 |
juiceme | and that's quite a speed | 23:52 |
juiceme | :P | 23:52 |
juiceme | anywa, time for bed | 23:52 |
reinob | yup me too. good night. WIn7Mac if you still there: good night as well! | 23:52 |
juiceme | nite all! | 23:53 |
Win7Mac | thanks & gnite | 23:54 |
Generated by irclog2html.py 2.15.1 by Marius Gedminas - find it at mg.pov.lt!