Time  Nick             Message
07:49 alex_a           bonjour
07:56 marcelr          hi #koha
07:59 reiveune         hello
08:19 Archie^          Good morning Koha People!
08:19 * fridolin       releasing v17.11.13
08:19 fridolin         XMas edition :)
08:22 ashimema         :)
08:24 ashimema         Congrats to JesseM and Lucas on their first release :)
08:27 josef_moravec    fridolin++ JesseM++ Lucas++
08:27 tuxayo           RMaint++
08:27 tuxayo           fridolin++ JesseM++ Lucas++ ashimema++
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:36 Archie^          Hey guys what does 952$o Koha full call number stand for? there is no description for it
08:42 magnuse          happy solstice, #koha!
08:53 tuxayo           :o
08:53 tuxayo           indeed
09:16 * andreashm      waves
09:23 calire           hi andreashm
09:23 andreashm        hi calire!
09:25 ashimema         hola #koha
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:27 ashimema         not sure what you're asking there Archie^
09:27 Archie^          i went into mysql and removed db.
09:28 Archie^          then i created a new db with the same name
09:28 ashimema         I'd make sure you've got your new db set to utf8mb4
09:28 Archie^          how to do that?
09:28 ashimema         add the mysql user and give them permissions upon it
09:28 ashimema         are you restoring onto it or just installing afresh
09:29 Archie^          i want it to be a fresh db
09:31 Archie^          lol i cant remove instance :D
09:31 ashimema         https://github.com/Koha-Community/Koha/blob/master/debian/scripts/koha-create#L623-L628
09:31 ashimema         that's pretty much what Koha does to create  fresh db in the packages
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:34 Archie^          ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
09:34 Archie^          why wont it let me remove instance?
09:35 ashimema         pass
09:35 ashimema         sql permissions
09:36 Archie^          but i 'm under root
09:36 josef_moravec    Archie^: you are linux root, but mysql has its own user permissions management
09:37 Archie^          but i can't call koha-remove  from under mysql
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:43 Archie^          right so
09:44 ashimema         sorry.. in a meeting now
09:44 ashimema         but you look like your in safe hands
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:45 Archie^          but apperantly that was a foolish idea :D
09:46 * ashimema       doesn't think that was a terrible idea
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:47 * ashimema       goes back to his meeting
09:48 josef_moravec    Archie^: koha-create tries to acces mysql using login and password from /etc/mysql/koha-common.cnf
09:48 josef_moravec    but you don't have to destroy and create whole koha instance
09:48 Archie^          right, i guess i just need to add priveleges to db
09:48 josef_moravec    when you just remove the db, and create it manually, it should work as ashimema says
09:49 josef_moravec    Archie^: exactly
09:49 ashimema         it should be as simple a
09:49 ashimema         `DROP 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         `CREATE DATABASE $name`
09:49 josef_moravec    Archie^: ashimema send you link, where the needed command are shown...
09:50 ashimema         `GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`@'$mysql_hostname';`
09:50 ashimema         `FLUSH PRIVILEGES`
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 Archie^          will mysql find itself what user and hostname is
09:50 Archie^          or should i specify it ?
09:50 ashimema         you'll need to specify
09:50 josef_moravec    you should specify it
09:50 ashimema         `mysql -uroot -pwhatever` to connect in the first place
09:50 ashimema         then
09:51 ashimema         use the user and password from your original koha config
09:51 josef_moravec    mysqldb will be koha_<instance>
09:51 ashimema         `/etc/koha/sites/whatever/koha.conf`
09:54 Archie^          1 sec, gonna try
09:55 Archie^          ya there is no koha.conf
09:55 Archie^          here is koha-conf.xml
09:55 josef_moravec    Archie^: that is  what you need
10:01 Archie^          there are 2 There is kohauser and koha_library
10:01 Archie^          both under tag < user>
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:17 josef_moravec    Archie^: you need the config/database value as database name
10:17 josef_moravec    Archie^: config/user as database user
10:18 josef_moravec    Archie^: and config/pass as database password
10:22 Archie^          hmm should i restart mysql after that?
10:23 josef_moravec    Archie^: you need at least flush privileges
10:23 josef_moravec    Archie^: but it does not harm to restart mysql ;)
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: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 josef_moravec    Archie^: restart memcached and plack
10:27 Archie^          awwwwww yisssssssss it worked. josef_moravec, ashimema you are my saviours.  :*
10:27 josef_moravec    Archie^: :D
10:27 Archie^          also it says plack is not running for my instance
10:27 Archie^          for some reason plack has no permision for my koha-conf
10:28 josef_moravec    Archie^: can you access web installer now?
10:29 Archie^          yes
10:59 Archie^          Hey guys what does 952$o Koha full call number stand for? there is no description for it
11:07 Archie^          hey cait
11:10 Archie^          hmm it seems Koha times outs if i'm trying to upload patron list more than 6k records
11:10 Archie^          the problem is i have 2 libraries with ~ 60k records in each xD
11:28 Archie^          can i  just insert into borrowers table? or should i always use csv import from koha gui?
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:31 magnuse          i must confess i was not aware of it before now :-)
11:31 magnuse          "perldoc misc/import_patrons.pl" should tell you how to use it
11:32 magnuse          in a package install it should be at /usr/share/koha/bin/, i think
11:32 Archie^          oh sweet
11:33 Archie^          but i guess if i'm inserting via perl file i need to run indexing agian, huh?
11:34 magnuse          no, indexing is only for bib records and items
11:34 Archie^          what about authorities?
11:34 magnuse          yeah, them too
11:35 magnuse          and if you migrate active loans you need to reindex for them to show properly in results lists
11:42 Archie^          yeah the loans are the biggest headache. i cant understand them neither in koha nor in other library :/
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:51 * magnuse        needs lunch
12:14 JesseM           Morning
12:15 ashimema         JesseM++
12:15 JesseM           Thanks ashimema and everyone else.
12:17 JesseM           I know I learned a lot with this first release. Its only going to get easier. ;)
12:18 JesseM           Thanks again for your help ashimema++
12:18 Joubu            good morning #koha
12:18 ashimema         :)
12:18 ashimema         pleasure
12:18 ashimema         thanks for taking the maint branch on :)
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:25 Archie^          but i where should i include the amount of money person owns to library
12:26 cait             it depends
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:27 cait             if it's old fines not linked to issues, you want to fill accountlines
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: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:57 Archie^          so a thing i realised today import_patrons.pl works for ~ 10k customers and then turns off
13:08 Joubu            JesseM: FYI I pushed the koha-testing-docker's PR #101, it triggered the rebuild of the docker's images.
13:09 Joubu            the pipeline should continue and 18.05 jobs will start soon, we will see if it fixes the different failures
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: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:29 ashimema         nice one Joubu
13:36 JesseM           Thanks Joubu.  Fingers crossed
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: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: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:47 Archie^          ok i found a an issue in KOHA
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: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: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 huginn           Joubu: Error: No closing quotation
13:52 Joubu            really
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: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 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:56 Joubu            Archie^: what's the value of the syspref dateformat?
13:59 Archie^          a hmm it seems it sets itself to mm/dd/yyyy by default
13:59 Archie^          my mistake
13:59 josef_moravec    Archie^: it is default value
14:03 Archie^          damn i think i broke something again. Dropdown menus show me blank white screens
14:06 Freddy_Enrique   Hi everyone _
14:06 Freddy_Enrique   :)
14:06 caroline         Good morning everyone!
14:06 * Freddy_Enrique waves
14:08 caroline         What is a test and how do I make one? re bug 21953
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 kidclamp         hi caroline
14:08 kidclamp         tests are in the t/ directories
14:08 kidclamp         they are unit tests - perl code that verifies functions return the expected results
14:09 caroline         I don't know perl, can I still do a test?
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 Joubu            nope
14:09 kidclamp         if you can understand enought o fake it :-)
14:09 Joubu            but you can learn perl first
14:10 Joubu            you are lucky, it's winter and a long week-end is coming :D
14:10 caroline         hehe!
14:10 caroline         I'm not sure learning perl is on my holiday todo list ;)
14:10 Joubu            caroline: I will take a look and try to provide a test for you (while you are learning perl)
14:10 kidclamp         Joubu++
14:11 caroline         I will look at your test to see
14:17 koha-jenkins     Yippee, build fixed!
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 ashimema         everything is awesome
14:19 caroline         Joubu, there is no "model" test?
14:20 Joubu            they really depend on what you want to test
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:21 Joubu            JesseM: 18.05_D8 is green! I am starting manually the runs for D9 and U18 right now
14:29 JesseM           Joubu++
14:30 Freddy_Enrique   oh...
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: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/
15:48 reiveune         bye
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/
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: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/