IRC log for #koha, 2018-12-21

All times shown according to UTC.

Time S Nick Message
00:55 barton joined #koha
01:36 cait1 joined #koha
04:49 alexbuckley joined #koha
04:57 PRAVIN joined #koha
05:51 Dahlia joined #koha
06:10 chris1 joined #koha
06:42 fridolin joined #koha
06:54 calire joined #koha
07:20 laurence joined #koha
07:37 alexbuckley joined #koha
07:48 alex_a joined #koha
07:49 alex_a bonjour
07:51 AndrewIsh joined #koha
07:56 marcelr joined #koha
07:56 marcelr hi #koha
07:59 reiveune joined #koha
07:59 reiveune hello
08:04 fridolin joined #koha
08:12 josef_moravec joined #koha
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:39 alex_a joined #koha
08:42 magnuse happy solstice, #koha!
08:53 tuxayo :o
08:53 tuxayo indeed
09:03 paul_p joined #koha
09:15 andreashm joined #koha
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:29 marcelr joined #koha
09:31 Archie^ lol i cant remove instance :D
09:31 ashimema https://github.com/Koha-Commun[…]-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[…]oha_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-Commun[…]-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:21 kohaputti joined #koha
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:49 kohaputti joined #koha
10:59 Archie^ Hey guys what does 952$o Koha full call number stand for? there is no description for it
11:06 cait joined #koha
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/[…]dcb3ead9a;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 andreashm joined #koha
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:34 calire left #koha
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:47 laurence left #koha
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[…]Koha_18.11_D8/11/
12:47 alex_a joined #koha
12:48 koha-jenkins Project Koha_18.11_D9 build #11: SUCCESS in 28 min: https://jenkins.koha-community[…]Koha_18.11_D9/11/
12:57 fridolin1 joined #koha
12:57 Archie^ so a thing i realised today import_patrons.pl works for ~ 10k customers and then turns off
12:58 fridolin1 left #koha
12:59 fridolin1 joined #koha
13:02 Dyrcona joined #koha
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[…]oha_18.11_U18/10/
13:20 koha-jenkins Project Koha_18.05_D8 build #149: STILL UNSTABLE in 29 min: https://jenkins.koha-community[…]oha_18.05_D8/149/
13:29 ashimema nice one Joubu
13:31 marcelr joined #koha
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[…]oha_18.05_D9/146/
13:37 koha-jenkins Project Koha_18.05_U18 build #149: ABORTED in 26 min: https://jenkins.koha-community[…]ha_18.05_U18/149/
13:38 koha-jenkins Project Koha_18.05_D8 build #150: ABORTED in 26 sec: https://jenkins.koha-community[…]oha_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:49 chris1 joined #koha
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:02 Archie^ joined #koha
14:02 Freddy_Enrique joined #koha
14:03 Archie^ damn i think i broke something again. Dropdown menus show me blank white screens
14:06 caroline joined #koha
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[…]_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/[…]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[…]oha_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 coyas joined #koha
14:29 JesseM Joubu++
14:30 Freddy_Enrique oh...
14:37 Margaret joined #koha
14:38 coyas joined #koha
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[…]oha_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[…]ha_18.05_U18/150/
14:50 alex_a joined #koha
15:36 Margaret joined #koha
15:37 Margaret_ joined #koha
15:48 reiveune bye
15:48 reiveune left #koha
16:12 Dyrcona joined #koha
16:20 fridolin1 left #koha
17:37 Freddy_Enrique left #koha
17:55 paul_p left #koha
19:12 Margaret joined #koha
21:29 koha-jenkins Project Koha_18.05_D8 build #152: SUCCESS in 23 min: https://jenkins.koha-community[…]oha_18.05_D8/152/
21:30 lukeG joined #koha
21:30 koha-jenkins Project Koha_18.05_D9 build #148: SUCCESS in 26 min: https://jenkins.koha-community[…]oha_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[…]ha_18.05_U18/151/
22:25 lukeG joined #koha

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary