| Time |
S |
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 |
|
Danyon |
<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 |
|
tcohen[m] |
Today I worked on 22.05, and it helped me to do it letter by letter |
| 02:03 |
|
tcohen[m] |
Command .../a*.po |
| 02:03 |
|
tcohen[m] |
Then b*.po and so on |
| 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:04 |
|
tcohen[m] |
Formed |
| 02:04 |
|
tcohen[m] |
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 |
|
tcohen[m] |
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 |
|
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:15 |
|
Danyon |
but the wiki doesn't specify what to do if there are files that show up that aren't expected |
| 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 |
| 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 |
|
dcook |
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 |
|
dcook |
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 |
|
dcook |
I think we do need a validator at some point |
| 06:10 |
|
dcook |
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 |
|
marcelr |
from 2014 |
| 06:11 |
|
marcelr |
basically same idea |
| 06:12 |
|
dcook |
https://metacpan.org/pod/Data::FormValidator |
| 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: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 |
Bug 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 |
|
dcook |
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 |
|
markfrancisonde[m] |
Newbie here about Koha |
| 07:42 |
|
markfrancisonde[m] |
I want to learn how to install and run Koha for our library |
| 07:44 |
|
Joubu |
Hi markfrancisonde[m], welcome! |
| 07:44 |
|
Joubu |
this page is the entry point: https://wiki.koha-community.or[…]/Getting_involved |
| 07:44 |
|
Joubu |
to install Koha on Debian: https://wiki.koha-community.or[…]ki/Koha_on_Debian |
| 07:44 |
|
Joubu |
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 |
|
* cait |
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 |
Bug 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 |
|
cait |
but we might want to just add some checks |
| 08:55 |
|
|
thibaud_g joined #koha |
| 09:53 |
|
marcelr |
Joubu++ |
| 09:53 |
|
marcelr |
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 |
|
tcohen[m] |
happy friday! |
| 11:19 |
|
tcohen[m] |
Nikolay Gospodinov: what do you mean 'the database'? |
| 11:19 |
|
tcohen[m] |
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 |
|
tcohen[m] |
so chances are: |
| 11:22 |
|
tcohen[m] |
- your server is not correctly tuned |
| 11:22 |
|
tcohen[m] |
- phpmyadmin is slow for some reason |
| 11:22 |
|
tcohen[m] |
- 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 |
|
NikolayGospodinov[m] |
The gateway did not receive a timely response from the upstream server or application. |
| 11:22 |
|
NikolayGospodinov[m] |
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 |
|
NikolayGospodinov[m] |
hours* |
| 11:25 |
|
tcohen[m] |
so the same query returned fast, and now doesn't |
| 11:25 |
|
tcohen[m] |
do you have access to the server itself? |
| 11:25 |
|
tcohen[m] |
maybe you can run the query manually |
| 11:25 |
|
tcohen[m] |
to discard backend issues, and you can move to the upper layers |
| 11:26 |
|
NikolayGospodinov[m] |
I have access to the server |
| 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:27 |
|
NikolayGospodinov[m] |
The gateway did not receive a timely response from the upstream server or application. |
| 11:27 |
|
NikolayGospodinov[m] |
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 |
|
tcohen[m] |
dd if=/dev/zero of=benchmark.img bs=1G count=5 status=progress |
| 11:46 |
|
NikolayGospodinov[m] |
i will try |
| 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:50 |
|
tcohen[m] |
looks correct |
| 11:57 |
|
tcohen[m] |
that's enterprise grade SSD to me. Not the problem then |
| 11:57 |
|
tcohen[m] |
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 |
|
tcohen[m] |
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 |
Bug 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 |
|
tcohen[m] |
Joubu++ # grumpy people still gets karma |
| 12:01 |
|
tcohen[m] |
:-P |
| 12:02 |
|
cait |
people doing QA get karma :) |
| 12:03 |
|
cait |
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 |
|
cait |
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 |
|
tcohen[m] |
Joubu: do I have the [m] |
| 12:08 |
|
tcohen[m] |
how do I get rid of it? |
| 12:08 |
|
Joubu |
s/...$// |
| 12:08 |
|
Joubu |
pretty robust regex |
| 12:09 |
|
Joubu |
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 |
|
cait |
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 |
|
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:19 |
|
NikolayGospodinov[m] |
who to do the tuning |
| 12:19 |
|
Joubu |
https://wiki.koha-community.or[…]uide#MySQL_tuning |
| 12:20 |
|
Joubu |
not sure how this is up-to-date however |
| 12:21 |
|
Joubu |
https://github.com/major/MySQLTuner-perl |
| 12:21 |
|
Joubu |
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 |
|
cait |
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 |
|
cait |
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 |
|
Joubu |
#innodb_buffer_pool_size = 8G |
| 13:10 |
|
Joubu |
Try: |
| 13:10 |
|
Joubu |
innodb_buffer_pool_size = 16G |
| 13:10 |
|
Joubu |
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 |
|
NikolayGospodinov[m] |
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 |
|
NikolayGospodinov[m] |
<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 |
|
Joubu |
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 |
|
NikolayGospodinov[m] |
But how can i still use koha and can make sql query in database? |
| 13:50 |
|
NikolayGospodinov[m] |
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 |
|
Joubu |
sorry I cannot help more, I have no idea! |
| 13:53 |
|
NikolayGospodinov[m] |
Ок |
| 13:53 |
|
NikolayGospodinov[m] |
I readed it |
| 13:54 |
|
NikolayGospodinov[m] |
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 |
|
oleonard |
I thought I'd work on Bug 34443, but search results never show up. Only a JS error |
| 16:19 |
|
huginn |
Bug 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 |
|
cait |
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 |
|
oleonard |
An error specific to my data? |
| 16:25 |
|
cait |
I always find the datatables errors very hard to decipher |
| 16:25 |
|
cait |
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 |
|
oleonard |
...or sort2 |
| 16:31 |
|
oleonard |
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 |
|
tcohen[m] |
can we chat on signal? |
| 18:52 |
|
cait |
does someone remember what happened to GoogleIndicTransliteration? |
| 18:53 |
|
cait |
ok, found it |
| 18:53 |
|
tcohen[m] |
what happened? :-D |
| 18:55 |
|
cait |
the Transliteration API was deprecated by Google |
| 18:55 |
|
cait |
bug 26070 |
| 18:55 |
|
huginn |
Bug 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 |
|
tcohen[m] |
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 |
|
tcohen[m] |
all solved cait |
| 19:47 |
|
cait |
just showing you fridolin :) |
| 19:48 |
|
tcohen[m] |
ah, yeah, we used another channel |
| 19:48 |
|
tcohen[m] |
rm/rmaint chat, not QA :-P |
| 19:49 |
|
cait |
I feel locked out now, thx ;) |
| 21:40 |
|
|
fridolin left #koha |
