| 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 |
