Time Nick Message 21:31 koha-jenkins Project Koha_18.05_U18 build #151: FAILURE in 2 min 1 sec: https://jenkins.koha-community.org/job/Koha_18.05_U18/151/ 21:30 koha-jenkins Project Koha_18.05_D9 build #148: SUCCESS in 26 min: https://jenkins.koha-community.org/job/Koha_18.05_D9/148/ 21:29 koha-jenkins Project Koha_18.05_D8 build #152: SUCCESS in 23 min: https://jenkins.koha-community.org/job/Koha_18.05_D8/152/ 15:48 reiveune bye 14:47 koha-jenkins Project Koha_18.05_U18 build #150: FIXED in 26 min: https://jenkins.koha-community.org/job/Koha_18.05_U18/150/ 14:47 koha-jenkins Yippee, build fixed! 14:47 koha-jenkins Project Koha_18.05_D9 build #147: FIXED in 26 min: https://jenkins.koha-community.org/job/Koha_18.05_D9/147/ 14:47 koha-jenkins Yippee, build fixed! 14:30 Freddy_Enrique oh... 14:29 JesseM Joubu++ 14:21 Joubu JesseM: 18.05_D8 is green! I am starting manually the runs for D9 and U18 right now 14:20 caroline I did borrow "A librarian's guide to programming languages" on my ereader last week and it has perl in it... maybe I will come back from the holidays know perl ;) 14:20 Joubu they really depend on what you want to test 14:19 caroline Joubu, there is no "model" test? 14:17 ashimema everything is awesome 14:17 koha-jenkins Project Koha_18.05_D8 build #151: FIXED in 22 min: https://jenkins.koha-community.org/job/Koha_18.05_D8/151/ 14:17 koha-jenkins Yippee, build fixed! 14:11 caroline I will look at your test to see 14:10 kidclamp Joubu++ 14:10 Joubu caroline: I will take a look and try to provide a test for you (while you are learning perl) 14:10 caroline I'm not sure learning perl is on my holiday todo list ;) 14:10 caroline hehe! 14:10 Joubu you are lucky, it's winter and a long week-end is coming :D 14:09 Joubu but you can learn perl first 14:09 kidclamp if you can understand enought o fake it :-) 14:09 Joubu nope 14:09 kidclamp http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=t/db_dependent/Items.t;h=bc7aaa9feb215af2a7abf56a2fe0d3a6d8366024;hb=refs/heads/master 14:09 caroline I don't know perl, can I still do a test? 14:08 kidclamp they are unit tests - perl code that verifies functions return the expected results 14:08 kidclamp tests are in the t/ directories 14:08 kidclamp hi caroline 14:08 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21953 minor, P5 - low, ---, koha-bugs, Signed Off , Term "Lost item" untranslatable 14:08 caroline What is a test and how do I make one? re bug 21953 14:06 * Freddy_Enrique waves 14:06 caroline Good morning everyone! 14:06 Freddy_Enrique :) 14:06 Freddy_Enrique Hi everyone _ 14:03 Archie^ damn i think i broke something again. Dropdown menus show me blank white screens 13:59 josef_moravec Archie^: it is default value 13:59 Archie^ my mistake 13:59 Archie^ a hmm it seems it sets itself to mm/dd/yyyy by default 13:56 Joubu Archie^: what's the value of the syspref dateformat? 13:53 huginn Joubu: The operation succeeded. 13:53 Joubu @later tell tcohen I guess it comes from the "H/5 * * * *" in the "build triggers" config part. You can see the mess in runs 17 to 23 for 18.05 bionic. 13:53 huginn Joubu: The operation succeeded. 13:53 Joubu @later tell tcohen But as we have only 2 jenkin's nodes working now, and that they were used to build koha_1811, the start of the pipelines were waiting. Every 5 min a new one were created, we ended up with ton of jobs "waiting for next available executor". 13:53 huginn Joubu: The operation succeeded. 13:53 Joubu @later tell tcohen Just pushed (Dec 21nd) koha-testing-docker PR #101 to see if it fixes 18.05. It triggered the rebuild of docker's image for 18.05, 18.11 and master, for the 3 distros, as expected. 13:52 Joubu really 13:52 huginn Joubu: Error: No closing quotation 13:52 Joubu next available executor". I guess it comes from the "H/5 * * * *" in the "build triggers" config part. You can see the mess in runs 17 to 23 for 18.05 bionic. 13:52 Joubu @later tell tcohen Just pushed (Dec 21nd) koha-testing-docker PR #101 to see if it fixes 18.05. It triggered the rebuild of docker's image for 18.05, 18.11 and master, for the 3 distros, as expected. But as we have only 2 jenkin's nodes working now, and that they were used to build koha_1811, the start of the pipelines were waiting. Every 5 min a new one were created, we ended up with ton of jobs "waiting for 13:48 Archie^ how do i change time format during checkout in checked out on. right now it seems it is in MM.DD.YYYY 13:47 Archie^ ok i found a an issue in KOHA 13:38 koha-jenkins Project Koha_18.05_D8 build #150: ABORTED in 26 sec: https://jenkins.koha-community.org/job/Koha_18.05_D8/150/ 13:37 koha-jenkins Project Koha_18.05_U18 build #149: ABORTED in 26 min: https://jenkins.koha-community.org/job/Koha_18.05_U18/149/ 13:37 koha-jenkins Project Koha_18.05_D9 build #146: ABORTED in 16 min: https://jenkins.koha-community.org/job/Koha_18.05_D9/146/ 13:36 JesseM Thanks Joubu. Fingers crossed 13:29 ashimema nice one Joubu 13:20 koha-jenkins Project Koha_18.05_D8 build #149: STILL UNSTABLE in 29 min: https://jenkins.koha-community.org/job/Koha_18.05_D8/149/ 13:10 koha-jenkins Project Koha_18.11_U18 build #10: SUCCESS in 29 min: https://jenkins.koha-community.org/job/Koha_18.11_U18/10/ 13:09 Joubu the pipeline should continue and 18.05 jobs will start soon, we will see if it fixes the different failures 13:08 Joubu JesseM: FYI I pushed the koha-testing-docker's PR #101, it triggered the rebuild of the docker's images. 12:57 Archie^ so a thing i realised today import_patrons.pl works for ~ 10k customers and then turns off 12:48 koha-jenkins Project Koha_18.11_D9 build #11: SUCCESS in 28 min: https://jenkins.koha-community.org/job/Koha_18.11_D9/11/ 12:41 koha-jenkins Project Koha_18.11_D8 build #11: SUCCESS in 21 min: https://jenkins.koha-community.org/job/Koha_18.11_D8/11/ 12:27 cait if it's old fines not linked to issues, you want to fill accountlines 12:26 cait if they still have hte items checked out, koha can recalculate the fine, actually it will, if you want it or not 12:26 cait it depends 12:25 Archie^ but i where should i include the amount of money person owns to library 12:25 Archie^ so if i undertand correctly all i need to do in Koha is insert into issues and link the item with itemnumber 12:18 ashimema thanks for taking the maint branch on :) 12:18 ashimema pleasure 12:18 ashimema :) 12:18 Joubu good morning #koha 12:18 JesseM Thanks again for your help ashimema++ 12:17 JesseM I know I learned a lot with this first release. Its only going to get easier. ;) 12:15 JesseM Thanks ashimema and everyone else. 12:15 ashimema JesseM++ 12:14 JesseM Morning 11:51 * magnuse needs lunch 11:51 magnuse we can help you understand how they work in Koha, but it is probably best to understand how they work in the other system first... 11:42 Archie^ yeah the loans are the biggest headache. i cant understand them neither in koha nor in other library :/ 11:35 magnuse and if you migrate active loans you need to reindex for them to show properly in results lists 11:34 magnuse yeah, them too 11:34 Archie^ what about authorities? 11:34 magnuse no, indexing is only for bib records and items 11:33 Archie^ but i guess if i'm inserting via perl file i need to run indexing agian, huh? 11:32 Archie^ oh sweet 11:32 magnuse in a package install it should be at /usr/share/koha/bin/, i think 11:31 magnuse "perldoc misc/import_patrons.pl" should tell you how to use it 11:31 magnuse i must confess i was not aware of it before now :-) 11:31 magnuse Archie^: there is a command line tool: http://git.koha-community.org/gitweb/?p=koha.git;a=history;f=misc/import_patrons.pl;h=5a7916b62015db1e0165cafd5b069dcdcb3ead9a;hb=HEAD 11:28 Archie^ can i just insert into borrowers table? or should i always use csv import from koha gui? 11:10 Archie^ the problem is i have 2 libraries with ~ 60k records in each xD 11:10 Archie^ hmm it seems Koha times outs if i'm trying to upload patron list more than 6k records 11:07 Archie^ hey cait 10:59 Archie^ Hey guys what does 952$o Koha full call number stand for? there is no description for it 10:29 Archie^ yes 10:28 josef_moravec Archie^: can you access web installer now? 10:27 Archie^ for some reason plack has no permision for my koha-conf 10:27 Archie^ also it says plack is not running for my instance 10:27 josef_moravec Archie^: :D 10:27 Archie^ awwwwww yisssssssss it worked. josef_moravec, ashimema you are my saviours. :* 10:24 josef_moravec Archie^: restart memcached and plack 10:24 Archie^ but it still shows on my intra page software error: DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_library.borrowers' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 92 10:24 Archie^ josef_moravec: it shows under <config> <database>koha_library</database, <user>koha_library</user> i've granted koha_library.* (library being name of my instance) to koha_library@localhost (since it's my dev machine) flushed privileges 10:23 josef_moravec Archie^: but it does not harm to restart mysql ;) 10:23 josef_moravec Archie^: you need at least flush privileges 10:22 Archie^ hmm should i restart mysql after that? 10:18 josef_moravec Archie^: and config/pass as database password 10:17 josef_moravec Archie^: config/user as database user 10:17 josef_moravec Archie^: you need the config/database value as database name 10:02 Archie^ should i add both? if yes then i guess there is a specific passowrd i need to use that is under xlm file 10:01 Archie^ both under tag < user> 10:01 Archie^ there are 2 There is kohauser and koha_library 09:55 josef_moravec Archie^: that is what you need 09:55 Archie^ here is koha-conf.xml 09:55 Archie^ ya there is no koha.conf 09:54 Archie^ 1 sec, gonna try 09:51 ashimema `/etc/koha/sites/whatever/koha.conf` 09:51 josef_moravec mysqldb will be koha_<instance> 09:51 ashimema use the user and password from your original koha config 09:50 ashimema then 09:50 ashimema `mysql -uroot -pwhatever` to connect in the first place 09:50 josef_moravec you should specify it 09:50 ashimema you'll need to specify 09:50 Archie^ or should i specify it ? 09:50 Archie^ will mysql find itself what user and hostname is 09:50 Archie^ the only thing that confuses me here https://github.com/Koha-Community/Koha/blob/master/debian/scripts/koha-create#L623-L628 --- mysqluser and hostname 09:50 ashimema `FLUSH PRIVILEGES` 09:50 ashimema `GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`@'$mysql_hostname';` 09:49 josef_moravec Archie^: ashimema send you link, where the needed command are shown... 09:49 ashimema `CREATE DATABASE $name` 09:49 * andreashm had to dig deep into our patron cards, RFID and how UID are formatted yersterday. Brain scrambled, needs a cookie. =) 09:49 ashimema `DROP DATABASE $name` 09:49 ashimema it should be as simple a 09:49 josef_moravec Archie^: exactly 09:48 josef_moravec when you just remove the db, and create it manually, it should work as ashimema says 09:48 Archie^ right, i guess i just need to add priveleges to db 09:48 josef_moravec but you don't have to destroy and create whole koha instance 09:48 josef_moravec Archie^: koha-create tries to acces mysql using login and password from /etc/mysql/koha-common.cnf 09:47 * ashimema goes back to his meeting 09:47 ashimema once the permissions are all good koha should display the onboarding wizard etc and you can build your new db using it. 09:46 * ashimema doesn't think that was a terrible idea 09:45 Archie^ but apperantly that was a foolish idea :D 09:45 Archie^ josef_moravec: can you elaborate on this a little bit? I had way to much corrupted data so i wanted to create a fresh new db. the idea was i remove old db, create new one with the same name 09:44 ashimema but you look like your in safe hands 09:44 ashimema sorry.. in a meeting now 09:43 Archie^ right so 09:38 josef_moravec Archie^: but it calls mysql and uses mysql's root user, the configuration for used user is somewhere in /etc/mysql I believe 09:37 Archie^ but i can't call koha-remove from under mysql 09:36 josef_moravec Archie^: you are linux root, but mysql has its own user permissions management 09:36 Archie^ but i 'm under root 09:35 ashimema sql permissions 09:35 ashimema pass 09:34 Archie^ why wont it let me remove instance? 09:34 Archie^ ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) 09:31 koha-jenkins Project Koha_17.11_D8 build #131: SUCCESS in 28 min: https://jenkins.koha-community.org/job/Koha_17.11_D8/131/ 09:31 ashimema that's pretty much what Koha does to create fresh db in the packages 09:31 ashimema https://github.com/Koha-Community/Koha/blob/master/debian/scripts/koha-create#L623-L628 09:31 Archie^ lol i cant remove instance :D 09:29 Archie^ i want it to be a fresh db 09:28 ashimema are you restoring onto it or just installing afresh 09:28 ashimema add the mysql user and give them permissions upon it 09:28 Archie^ how to do that? 09:28 ashimema I'd make sure you've got your new db set to utf8mb4 09:28 Archie^ then i created a new db with the same name 09:27 Archie^ i went into mysql and removed db. 09:27 ashimema not sure what you're asking there Archie^ 09:25 Archie^ ok, so let's say i deleted my entire database (for test purposes) re-created new empyt db with the same name. what else i should do? 09:25 ashimema hola #koha 09:23 andreashm hi calire! 09:23 calire hi andreashm 09:16 * andreashm waves 08:53 tuxayo indeed 08:53 tuxayo :o 08:42 magnuse happy solstice, #koha! 08:36 Archie^ Hey guys what does 952$o Koha full call number stand for? there is no description for it 08:28 ashimema me is now looking forward to the new year.. I think 19.05 is set to be a great release with lots of cool stuff in the pipeline :) 08:27 tuxayo fridolin++ JesseM++ Lucas++ ashimema++ 08:27 tuxayo RMaint++ 08:27 josef_moravec fridolin++ JesseM++ Lucas++ 08:24 ashimema Congrats to JesseM and Lucas on their first release :) 08:22 ashimema :) 08:19 fridolin XMas edition :) 08:19 * fridolin releasing v17.11.13 08:19 Archie^ Good morning Koha People! 07:59 reiveune hello 07:56 marcelr hi #koha 07:49 alex_a bonjour