kohadevbox:koha(21.11.x-security)$ git grep PERL **/*.po misc/translator/po/ms-MY-installer-MARC21.po:msgstr "PERLEMBAGAAN UNIT ENTRI"← 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-kohakohadevbox:koha(21.11.x-security)$ git grep PERL **/*.po misc/translator/po/ms-MY-installer-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
