IRC log for #koha, 2023-08-04

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time Nick Message
01:01 fridolin joined #koha
01:58 Danyon joined #koha
01:59 Danyon Hi all, am just in the process of fixing translation errors for 21.11.23 release and i've come across an error across 3 different files that i'm a bit confused about if anyone had any input
01:59 <failure message="msgfmt failure">misc/translator/po/si-messages-js.po:7: invalid nplurals value  msgfmt: found 2 fatal errors
02:00 tcohen[m] There's a header to be added. Look at the security 22.05 branch fix
02:01 Danyon Ah I see, i'll take a look now thank you
02:02 tcohen[m] So... (full message at <https://matrix.org/_matrix/med[…]WoPPpCASSqSKOdWYM>)
02:03 Today I worked on 22.05, and it helped me to do it letter by letter
02:03 Command .../a*.po
02:03 Then b*.po and so on
02:04 I know Russian has more than one plural form, but there are cases in which things are not correctly fitness
02:04 Formed
02:04 Just mark #, fuzzy
02:05 Danyon Yep thank you, have already fixed the majority of the errors with fuzzy, just those 3 were new to me
02:06 tcohen[m] I used Google translate with some lol, it was fun
02:06 Good night!
02:07 Danyon Good night!
02:14 Danyon joined #koha
02:14 Danyon Hi Sorry to be back so soon! The header change worked great but now when checking for possible XSS attempts I find the following:
02:14 kohadev-koha@kohadevbox:koha(21.11.x-security)$ git grep PERL **/*.po misc/translator/po/ms-MY-i​nstaller-MARC21.po:msgstr "PERLEMBAGAAN UNIT ENTRI"
02:15 but the wiki doesn't specify what to do if there are files that show up that aren't expected
02:20 It doesn't /look/ like an XSS attempt to me, just looks like a word that includes the word PERL in it, i'm tempted to ignore it but would love a second opinion
05:58 dcook joined #koha
05:58 reiveune joined #koha
06:00 reiveune hello
06:00 wahanui bonjour, reiveune
06:02 dcook salut reiveune
06:04 marcelr joined #koha
06:04 marcelr o/
06:06 Joubu Danyon: yes, it's a false positive, you can ignore it
06:07 marcelr hi Joubu
06:07 Joubu marcelr: hi!
06:08 * dcook waves to people
06:08 dcook Alas I haven't had any Koha time today :|
06:08 Although I think I might have a crack at one of yours Joubu..
06:09 Joubu not really mine :D
06:09 marcelr hi dcook
06:09 wahanui hi dcook are you around?
06:09 dcook hehe
06:09 * dcook waves to marcelr
06:10 marcelr will have a look at the secu reports
06:10 dcook <3
06:10 I have something good coming down the pipes I think
06:10 marcelr although i miss my Validator :)
06:10 dcook Today just didn't go the way I hoped it would
06:10 I think we do need a validator at some point
06:10 Let me point you at something I inherited from someone else once upon a time..
06:11 marcelr i found an old Validator module on BZ already too
06:11 from 2014
06:11 basically same idea
06:12 dcook https://metacpan.org/pod/Data::FormValidator
06:12 I think it's outdated now and wouldn't be super easy to add into our current code but it's interesting
06:13 marcelr ok i was planning to have a look at cpan too
06:16 Joubu PedroAmorim[m]: Are you going to work on bug 34276?
06:16 huginn 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=34276 blocker, P5 - low, ---, koha-bugs, NEW , upgrading 23.05 to 23.05.002
06:40 fridolin joined #koha
06:55 dcook marcelr: It works quite well in a MVC situation
06:55 And where you have generic forms for CRUD
06:58 marcelr ok
07:02 cait joined #koha
07:03 marcelr hi cait
07:14 puphaus[m] joined #koha
07:41 markfrancisonde[m] joined #koha
07:41 markfrancisonde[m] Good day everyone!
07:41 Newbie here about Koha
07:42 I want to learn how to install and run Koha for our library
07:44 Joubu Hi markfrancisonde[m], welcome!
07:44 this page is the entry point: https://wiki.koha-community.or[…]/Getting_involved
07:44 to install Koha on Debian: https://wiki.koha-community.or[…]ki/Koha_on_Debian
07:44 for a dev environment (docker container): https://gitlab.com/koha-commun[…]a-testing-docker/
07:46 markfrancisonde[m] thanks.. by the way, I am also a librarian.
07:52 * cait waves
07:52 is also a librarian, so you are not alone ;)
08:13 paulderscheid[m] morning #koha
08:18 PedroAmorim[m] Joubu: re 34276 I wasn't planning to, not in the short-term anyway. At the time of initial reports, I gave it a couple shots at reproducing and I wasn't able to, then I moved on
08:30 cait bug 34276
08:30 huginn 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=34276 blocker, P5 - low, ---, koha-bugs, NEW , upgrading 23.05 to 23.05.002
08:30 cait we had too many reports on that one, i think we just haven't figured out how
08:30 but we might want to just add some checks
08:55 thibaud_g joined #koha
09:53 marcelr Joubu++
09:53 will have a look, but not now anymore
10:09 Joubu are they time travelling or felt into a black hole?
10:10 thibaud_glt joined #koha
10:50 NikolayGospodinov[m] joined #koha
10:50 NikolayGospodinov[m] Hello! I have Koha installed on a server. The database is 50 GB in size. The problem is that Kohata is very slow and I can't download reports
11:09 M3muskateers[m] joined #koha
11:18 tcohen[m] joined #koha
11:18 tcohen[m] hola #koha o/
11:18 happy friday!
11:19 Nikolay Gospodinov: what do you mean 'the database'?
11:19 marcelr: thanks for all the hard work
11:20 NikolayGospodinov[m] I access the database through phpMyAdmin
11:21 tcohen[m] go on
11:21 NikolayGospodinov[m] it works very slowly
11:21 tcohen[m] mysql/mariadb is pretty fast
11:22 so chances are:
11:22 - your server is not correctly tuned
11:22 - phpmyadmin is slow for some reason
11:22 - your query is not good
11:22 NikolayGospodinov[m] now i tried to download a report from Koha and it shows me: Gateway Timeout
11:22 The gateway did not receive a timely response from the upstream server or application.
11:22 Apache/2.4.57 (Debian) Server at 192.168.1.155 Port 8080
11:22 tcohen[m] phpmyadmin is an external service, connecting through a network socket
11:23 NikolayGospodinov[m] Two ago the download was working fine
11:23 hours*
11:25 tcohen[m] so the same query returned fast, and now doesn't
11:25 do you have access to the server itself?
11:25 maybe you can run the query manually
11:25 to discard backend issues, and you can move to the upper layers
11:26 NikolayGospodinov[m] I have access to the server
11:27 In Koha the query returned the required information, but when I tried to export it to csv, showed me: Gateway Timeout
11:27 The gateway did not receive a timely response from the upstream server or application.
11:27 Apache/2.4.57 (Debian) Server at 192.168.1.155 Port 8080
11:30 Joubu how many rows are returned by the query?
11:30 NikolayGospodinov[m] 5735
11:32 Joubu You can extend the timeout of the web server, but 5k rows should not be a problem
11:32 NikolayGospodinov[m] I think so too. That is why I do not understand why works so slow
11:34 tcohen[m] it depends on how wide the rows are, but yeah, I cannot imagine anything too big
11:35 NikolayGospodinov[m] This is my Database Server Information:... (full message at <https://matrix.org/_matrix/med[…]iyVsqJOQCVlobpWMB>)
11:41 tcohen[m] can you run something like this on the server?
11:41 dd if=/dev/zero of=benchmark.img bs=1G count=5 status=progress
11:46 NikolayGospodinov[m] i will try
11:47 When I run it, it shows: 4294967296 bytes (4.3 GB, 4.0 GiB) copied, 7 s, 596 MB/s
11:50 tcohen[m] looks correct
11:57 that's enterprise grade SSD to me. Not the problem then
11:57 did you already run the query manually to check how long it takes?
11:57 NikolayGospodinov[m] Where to run it
11:58 tcohen[m] post the output for
11:58 koha-list
11:58 wahanui koha-list is what you want
11:59 MatthewBlenkinsop[m] joined #koha
11:59 MatthewBlenkinsop[m] Joubu: new patch on bug 34417
11:59 huginn 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=34417 enhancement, P5 - low, ---, jonathan.druart+koha, NEW , ERM's breadcrumb (Vue) does not display the entity's name
12:00 tcohen[m] Matthew Blenkinsop++
12:00 cait marcelr++
12:01 tcohen[m] marcelr++
12:01 Joubu++ # grumpy people still gets karma
12:01 :-P
12:02 cait people doing QA get karma :)
12:03 now I missed PedroAmorim
12:04 Joubu I havent said anything!
12:04 cait we can feel your grumpy vibe :P
12:05 Joubu I've even worked on csrf this morning, that's unfair :D
12:05 NikolayGospodinov[m] <tcohen[m]> "did you already run the query..." <- I ran the query directly through the server command window. I'm still waiting for it to run
12:05 cait heh
12:05 Joubu++
12:06 tcohen[m] Joubu: I know, and I'm very happy. Just messing with you
12:06 * tcohen[m] is happy this morning
12:06 Joubu always easier on Fridays
12:07 tcohen[m] Nikolay Gospodinov: we are reaching the point in which I think your query might be to blame
12:07 Joubu where are [m] people??
12:07 NikolayGospodinov[m] NikolayGospodinov[m]: the query returned a result after 2 min 37.703 sec
12:07 tcohen[m] you should share it on https://paste.koha-community.org
12:07 Joubu: do I have the [m]
12:08 how do I get rid of it?
12:08 Joubu s/...$//
12:08 pretty robust regex
12:09 NikolayGospodinov[m]: using the MariaDB CLI?
12:10 NikolayGospodinov[m] tcohen[m]: https://paste.koha-community.org/24364
12:10 Joubu that's certainly ExtractValue
12:11 cait depends on the amount of data and how much RAM the database has I think
12:12 NikolayGospodinov[m] But I need the information from biblio_metadata.metadata
12:12 tcohen[m] Ah, how is your RAM doing?
12:12 cait maybe try tuning the db to use more RAM
12:13 and how many records do you have in your db?
12:16 NikolayGospodinov[m] This is for the RAM:              total        used        free      shared  buff/cache   available... (full message at <https://matrix.org/_matrix/med[…]hYsKUskmMnRiuiEQw>)
12:17 cait 15 million records is a lot
12:19 we ahd a lot of issues with the item search on a much smaller database of 1,7 million and it all went away with tuning the dabase/more RAM
12:19 NikolayGospodinov[m] who to do the tuning
12:19 Joubu https://wiki.koha-community.or[…]uide#MySQL_tuning
12:20 not sure how this is up-to-date however
12:21 https://github.com/major/MySQLTuner-perl
12:21 never tried it!
12:22 cait mysqltuner is prtty common for this I think
12:26 Joubu MatthewBlenkinsop[m]: 34417 - I am trying something
12:28 NikolayGospodinov[m] <cait> "we ahd a lot of issues with..." <- For such a big database what value to give to innodb_buffer_pool_size
12:30 cait I am not a sysadmin sorry
12:31 NikolayGospodinov[m] cait: This is my 50-server.cnf. Now the value is 8 GB: https://paste.koha-community.org/24365
12:31 cait 8 seems small fo that many
12:31 the tool shoudl suggest you something
12:38 emlam joined #koha
12:53 cait hi emlam :)
12:53 emlam hi cait!
12:58 khall joined #koha
13:02 NikolayGospodinov[m] I change innodb_buffer_pool_size=23GB, then i tried to restart mariadb, and i get error that MariaDB server is down
13:07 Joubu MatthewBlenkinsop[m]: I've attached an alternative patch, for discussion
13:08 cait maybe try incresing in smaller steps?
13:09 I am not usually the one to do the tuning, so not sure about the settings and such
13:10 Joubu NikolayGospodinov[m]: did you notice that the line was commented?
13:10 #innodb_buffer_pool_size = 8G
13:10 Try:
13:10 innodb_buffer_pool_size = 16G
13:10 without '#'!
13:14 Dyrcona joined #koha
13:16 Joubu @later tell paulderscheid[m] https://www.reddit.com/r/perl/[…]/perl_ide_github/
13:16 huginn Joubu: The operation succeeded.
13:18 NikolayGospodinov[m] <Joubu> "Nikolay Gospodinov: did you..." <- I did what you say. I still can not restart mariadb
13:18 But I can use Koha and I can access the database via phpmyadmin
13:20 Joubu you have a syntax error in the config file?
13:21 NikolayGospodinov[m] Where? I can not see it
13:22 Joubu I don't know, it's just a guess
13:22 NikolayGospodinov[m] I can not see any syntax error
13:23 Joubu which error do you get?
13:24 NikolayGospodinov[m] i just change 8 to 16 end remove the #. Then I try to restart it. Should apache server be stopped before trying to restart mariadb
13:29 <Joubu> "which error do you get?" <-  mariadb.service - MariaDB 10.11.3 database server... (full message at <https://matrix.org/_matrix/med[…]crZVAcZHBCmGagPYS>)
13:33 Joubu you need to search for the error in: sudo journalctl -xe
13:34 rangi[m] joined #koha
13:35 NikolayGospodinov[m] Joubu: I did it. It shows:  An ExecStart= process belonging to unit mariadb.service has exited.... (full message at <https://matrix.org/_matrix/med[…]HaMAyGcVVFMEiACnL>)
13:36 Joubu disk space?
13:37 I don't know really, there is nothing relevant there, search in /var/log/mysql
13:39 NikolayGospodinov[m] I do not hava /var/log/mysql
13:42 khall_ joined #koha
13:42 Joubu see https://serverfault.com/questi[…]more-on-debian-10
13:49 NikolayGospodinov[m] I do not know why i can not reset mariadb
13:50 But how can i still use koha and can make sql query in database?
13:50 I am using it just now
13:51 Joubu df -h?
13:51 NikolayGospodinov[m] This is what i get: Filesystem      Size  Used Avail Use% Mounted on... (full message at <https://matrix.org/_matrix/med[…]URPPtEtdpKASZcwcn>)
13:53 Joubu did you read the previous link?
13:53 sorry I cannot help more, I have no idea!
13:53 NikolayGospodinov[m] Ок
13:53 I readed it
13:54 Does not help, but i can use koha which is great 😁
14:40 reiveune bye
14:40 reiveune left #koha
15:00 bag joined #koha
15:42 cait left #koha
16:04 cait joined #koha
16:19 oleonard The patron search popup isn't working at all for me.
16:19 I thought I'd work on Bug 34443, but search results never show up. Only a JS error
16:19 huginn 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=34443 minor, P5 - low, ---, oleonard, ASSIGNED , Spelling: Patron search pop-up Sort1: should be Sort 1:
16:20 oleonard Uncaught TypeError: can't access property "aDataSort", e[i] is undefined
16:22 cait ouch
16:22 wonder what it could be - i think it did work at some point
16:23 oleonard Hmm.... works in the random sandbox I found
16:23 An error specific to my data?
16:25 cait I always find the datatables errors very hard to decipher
16:25 if you search for one specitic patron, does that work?
16:27 oleonard Hmm... maybe it's specifically related to doing a search on Sort1
16:30 ...or sort2
16:31 But after a sort1 or sort2 search fails, other previously-working searches fail too
16:39 cait hm
18:17 aroussos joined #koha
18:23 fridolin joined #koha
18:52 tcohen[m] fridolin: around?
18:52 can we chat on signal?
18:52 cait does someone remember what happened to GoogleIndicTransliteration?
18:53 ok, found it
18:53 tcohen[m] what happened? :-D
18:55 cait the Transliteration API was deprecated by Google
18:55 bug 26070
18:55 huginn 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=26070 normal, P5 - low, ---, oleonard, CLOSED FIXED, Google Transliterate API has been deprecated
18:56 cait I didn't find the bug, until I asked here... (the usual)
19:04 tcohen[m] rubber ducking
19:04 mtj: how far did you get with your jenkins+security sutffs?
19:12 fridolin I was AFK sorry
19:47 cait tcohen[m] ^
19:47 tcohen[m] ¿
19:47 all solved cait
19:47 cait just showing you fridolin :)
19:48 tcohen[m] ah, yeah, we used another channel
19:48 rm/rmaint chat, not QA :-P
19:49 cait I feel locked out now, thx ;)
21:40 fridolin left #koha

← Previous day | Today | Next day → | Search | Index

koha1