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