localhost (since it's my dev machine) flushed privileges← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | 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 | Congrats to JesseM and Lucas on their first release :) | |
| 08:27 | josef_moravec | fridolin++ JesseM++ Lucas++ |
| 08:27 | tuxayo | RMaint++ |
| 08:27 | 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 | 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 | 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 | 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 | 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 | why wont it let me remove instance? | |
| 09:35 | ashimema | pass |
| 09:35 | 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 | 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 | 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 | 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 | Archie^: exactly | |
| 09:49 | ashimema | it should be as simple a |
| 09:49 | `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 | `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 | will mysql find itself what user and hostname is | |
| 09:50 | 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 | then | |
| 09:51 | 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 | ya there is no koha.conf | |
| 09:55 | 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 | both under tag < user> | |
| 10:02 | 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 | Archie^: config/user as database user | |
| 10:18 | 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 | 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_librarylocalhost (since it's my dev machine) flushed privileges |
| 10:24 | 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 | 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 | hmm it seems Koha times outs if i'm trying to upload patron list more than 6k records | |
| 11:10 | the problem is i have 2 libraries with ~ 60k records in each xD | |
| 11:28 | 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 | i must confess i was not aware of it before now :-) | |
| 11:31 | "perldoc misc/import_patrons.pl" should tell you how to use it | |
| 11:32 | 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 | 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 | I know I learned a lot with this first release. Its only going to get easier. ;) | |
| 12:18 | Thanks again for your help ashimema++ | |
| 12:18 | Joubu | good morning #koha |
| 12:18 | ashimema | :) |
| 12:18 | pleasure | |
| 12:18 | 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 | but i where should i include the amount of money person owns to library | |
| 12:26 | cait | it depends |
| 12:26 | if they still have hte items checked out, koha can recalculate the fine, actually it will, if you want it or not | |
| 12:27 | 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 | 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 | 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 | Project Koha_18.05_U18 build #149: ABORTED in 26 min: https://jenkins.koha-community[…]ha_18.05_U18/149/ | |
| 13:38 | 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 | 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 | 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 | @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 | 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 | :) | |
| 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 | tests are in the t/ directories | |
| 14:08 | 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 | you are lucky, it's winter and a long week-end is coming :D | |
| 14:10 | caroline | hehe! |
| 14:10 | 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 | 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 | Project Koha_18.05_D9 build #147: FIXED in 26 min: https://jenkins.koha-community[…]oha_18.05_D9/147/ | |
| 14:47 | Yippee, build fixed! | |
| 14:47 | 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 | 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 |
← Previous day | Today | Next day → | Search | Index
