| Time |
S |
Nick |
Message |
| 02:19 |
|
tcohen |
@later tell cait I have raised the VPS issue to Contabo as there's a storage server issue on the Jenkins/Wiki server |
| 02:19 |
|
huginn` |
tcohen: The operation succeeded. |
| 04:05 |
|
|
schnydszch joined #koha |
| 06:24 |
|
|
lmstrand joined #koha |
| 07:04 |
|
|
schnydszch joined #koha |
| 07:26 |
|
|
reiveune joined #koha |
| 07:27 |
|
reiveune |
hello |
| 07:30 |
|
Joubu |
things still down even with the server up again, we need tcohen back |
| 07:40 |
|
magnuse |
\o/ |
| 07:54 |
|
|
thibaud_g joined #koha |
| 07:58 |
|
|
lds joined #koha |
| 08:00 |
|
|
fridolin joined #koha |
| 08:00 |
|
fridolin |
hellow |
| 08:00 |
|
fridolin |
https://jenkins.koha-community.org/ problem ? |
| 08:00 |
|
fridolin |
I get PR_CONNECT_RESET_ERROR |
| 08:02 |
|
|
schnydszch joined #koha |
| 08:02 |
|
|
cait joined #koha |
| 08:03 |
|
Joubu |
yes fridolin, jenkins, wiki, everything that is hosted on the portainer server |
| 08:04 |
|
cait |
good morning all |
| 08:04 |
|
cait |
tcohen left me a note that he has raised an issue with the hoster (wiki, jenkins) |
| 08:05 |
|
cait |
let's hope they resolve it soon |
| 08:05 |
|
Joubu |
it's solved |
| 08:06 |
|
Joubu |
the server is back, but I don't know how to restart the web server |
| 08:07 |
|
fridolin |
great |
| 08:07 |
|
fridolin |
Bug 36215 needs a review, unless I'm wrong |
| 08:07 |
|
huginn` |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=36215 normal, P5 - low, ---, martin.renvoize, Pushed to master , Bookings calendar only shows bookings within RESTdefaultPageSize |
| 08:09 |
|
cait |
fridolin: i think you are right, Nick caught the second, but not the first occurrence |
| 08:09 |
|
cait |
I'll do a follow-up in a bit |
| 08:10 |
|
fridolin |
great |
| 08:11 |
|
cait |
frido, there is a patch for a database update I messed up on top of master - can you please take care it gets into next release? |
| 08:12 |
|
cait |
36232 - I know you are workign through all of them just don't want that to be lost (feeling responsible) |
| 08:17 |
|
fridolin |
Bug 36232 |
| 08:17 |
|
huginn` |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=36232 blocker, P5 - low, ---, mhby87, Pushed to master , Error fixing OAI-PMH:AutoUpdateSetsEmbedItemData syspref name on the DB |
| 08:17 |
|
fridolin |
Yep seen it :D |
| 08:19 |
|
fridolin |
And pushed for 23.11.04 |
| 08:21 |
|
cait |
thanks :) you are the best! |
| 08:24 |
|
cait |
fridolin++ |
| 08:34 |
|
magnuse |
fridolin++ cait++ |
| 08:53 |
|
davidnind |
FYI - I don't know much about security for the web, but the recently released "Copenhagen Book" (an open source guide on implementing auth for the web) may be of use as a general reference for developers. It covers sessions, CSRF protection, passkeys, OAuth, 2FA, email verification, and password reset. https://thecopenhagenbook.com/ |
| 09:46 |
|
|
eugene_ joined #koha |
| 10:26 |
|
|
fribeiro joined #koha |
| 10:38 |
|
magnuse |
davidnind: cool project! |
| 10:49 |
|
|
philor joined #koha |
| 10:57 |
|
paulderscheid[m] |
morning #koha |
| 11:00 |
|
cait |
bit late :D |
| 11:00 |
|
paulderscheid[m] |
Thanks for the resource davidnind-away :D __Go__od read |
| 11:01 |
|
paulderscheid[m] |
Yeah, worked too long yesterday. |
| 11:01 |
|
paulderscheid[m] |
Crunch time |
| 11:01 |
|
cait |
your breakfast is my lunch time :) bbiab! |
| 11:03 |
|
paulderscheid[m] |
o/ |
| 11:08 |
|
|
Zahid[m] joined #koha |
| 11:08 |
|
Zahid[m] |
hi everyone |
| 11:13 |
|
Zahid[m] |
my old koha server was running koha 16.05 version it creating mail logs file in var/log/mail.log and mail.err and it is increasing every minute from mb to GB and still growing about 50GB right now. i want to know is there any way to stop. i have checked the system preference but didnot find any thing or service to stop. is there any other way to stop this? any help will be appreciated |
| 11:22 |
|
paulderscheid[m] |
Kill the mail server |
| 11:23 |
|
paulderscheid[m] |
I read a story about recursive auto-responding filling the disk in the 90s or 2000s. But that’s probably not it. |
| 11:36 |
|
tcohen |
hola #koha o/ |
| 11:38 |
|
tcohen |
Joubu: it got back, but RO |
| 11:39 |
|
tcohen |
I've made a manual fsck through VNC |
| 11:39 |
|
tcohen |
and has just restarted |
| 11:39 |
|
tcohen |
I can teach anyone how to restart any of the services |
| 11:40 |
|
tcohen |
it is done through Portainer |
| 11:43 |
|
tcohen |
we are back online |
| 11:43 |
|
tcohen |
and jenkins running |
| 11:46 |
|
cait |
tcohen++ thanks! |
| 11:54 |
|
tcohen |
cait: I will trigger the exploded Master jobs again |
| 11:55 |
|
tcohen |
has anyone bisected the failed tests? |
| 11:56 |
|
cait |
tcohen: thank you, hope we will get non-exploded results |
| 11:56 |
|
cait |
I couldn#t see the last results yet, because the server was down |
| 11:56 |
|
cait |
so not sure which tests gave us trouble this time |
| 11:57 |
|
cait |
tcohen: i think maybe it just didn't finish before the server went down? D11 is green for a change and it wasn't before I think |
| 11:59 |
|
tcohen |
it's t/db_dependent/api/v1/transfer_limits.t |
| 12:02 |
|
tcohen |
will be working on DB_IMAGE=mysql:8.0 ktd --es7 --plugin up -d |
| 12:02 |
|
tcohen |
today |
| 12:03 |
|
tcohen |
in case I can find that error |
| 12:03 |
|
* tcohen |
switches DB version and OS every now and then |
| 12:05 |
|
cait |
cool :) |
| 12:06 |
|
cait |
tcohen: bug is here: https://bugs.koha-community.or[…]_bug.cgi?id=36277 |
| 12:06 |
|
huginn` |
Bug 36277: normal, P5 - low, ---, chris, NEW , t/db_dependent/api/v1/transfer_limits.t is failing |
| 12:07 |
|
tcohen |
(y) |
| 12:13 |
|
tcohen |
cait: we might need to add some debugging code in master if we cannot reproduce locally |
| 12:21 |
|
tcohen |
cait, are you familiar with the run_tests.pl script? |
| 12:22 |
|
Joubu |
tcohen: it's caused by a slow response I'd say, it says "timeout" |
| 12:26 |
|
|
fridolin joined #koha |
| 12:43 |
|
cait |
tcohen: only as far as using it for the cypress tests |
| 12:47 |
|
Joubu |
tcohen: bug 36177 has been pushed yesterday. It adds a new node module. |
| 12:47 |
|
huginn` |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=36177 critical, P5 - low, ---, jonathan.druart, RESOLVED FIXED, We need integration tests to cover CSRF checks |
| 12:47 |
|
Joubu |
Can you confirm me that I need to rebuild the images manually? |
| 12:48 |
|
Joubu |
they have been rebuilt yesterday it seems |
| 12:49 |
|
|
lds joined #koha |
| 12:53 |
|
Joubu |
tcohen: I am rebuilding them from gitlab |
| 12:54 |
|
tcohen |
ok, thanks for the heads up |
| 12:54 |
|
tcohen |
perl -Mt::lib::TestBuilder -e 'my $builder = t::lib::TestBuilder->new; foreach my $i (1..1000) { $builder->build_object({ class => 'Koha::Libraries' }); }' |
| 12:54 |
|
tcohen |
I did that to trigger the slowness... |
| 12:54 |
|
Joubu |
lol |
| 12:54 |
|
tcohen |
because this is a loop inside a loop on libraries |
| 12:55 |
|
tcohen |
I'm just gonna say it is not slow enough to make tests fail. |
| 12:55 |
|
tcohen |
so I guess it is a problem with the node |
| 12:56 |
|
Joubu |
yes I noticed that, but we are not expecting a lot of entries in the table, or there are leftover from selenium tests |
| 12:56 |
|
Joubu |
ok |
| 12:56 |
|
cait |
tcohen++ Joubu++ |
| 12:56 |
|
cait |
thanks for the help! |
| 12:57 |
|
Joubu |
it failed on different nodes |
| 12:57 |
|
Joubu |
Docker_9 and Docker_11 at least |
| 12:57 |
|
tcohen |
yes, 1000 was a bit drastic heh |
| 13:01 |
|
|
Dyrcona joined #koha |
| 13:06 |
|
|
khall_ joined #koha |
| 13:07 |
|
|
khall joined #koha |
| 13:20 |
|
|
wizzyrea joined #koha |
| 13:23 |
|
pastebot |
Someone at 127.0.0.1 pasted "tcohen" (34 lines) at https://paste.koha-community.org/39543 |
| 13:39 |
|
cait |
Process 380508 dead! sounds drastic |
| 14:01 |
|
|
edveal joined #koha |
| 14:15 |
|
magnuse |
tcohen: looks like i finally managed to build myself a .deb, by being in the root of my koha clone, checking out the 23.05.x branch and running this: sudo RELEASE=23.05 VERSION=23.05 EMAIL=magnus libriotech.no ~/code/koha-dpkg-docker/build.sh |
| 14:15 |
|
magnuse |
but then it's not actually using docker, is it? |
| 14:21 |
|
tcohen |
magnuse: and you installed nodejs and stuff |
| 14:21 |
|
tcohen |
ah mo |
| 14:21 |
|
tcohen |
it is all in the base.tgz |
| 14:21 |
|
tcohen |
sounds good to me |
| 14:22 |
|
magnuse |
i did try a lot of different things, but in the end i guess i basically just ran build.sh |
| 14:24 |
|
tcohen |
that's good, magnuse |
| 14:24 |
|
magnuse |
and i'm not 100% sure why i suddenly got past the "aborting due to unexpected upstream changes", but as long as it works... |
| 14:24 |
|
magnuse |
need to test the deb now, of course ;-) |
| 14:24 |
|
tcohen |
the Docker itself is just packing a few things so the host OS doesn't need to have them installed |
| 14:24 |
|
tcohen |
build.sh was patched by khall to take care of that |
| 14:24 |
|
tcohen |
https://gitlab.com/koha-commun[…]type=heads#L86-88 |
| 14:25 |
|
tcohen |
what we've seen at some point, is permissions get messed up because the Docker runs as root |
| 14:25 |
|
tcohen |
and then, commiting fails, etc |
| 14:27 |
|
magnuse |
yeah, there were some ownership issues in kohaclone along the way |
| 14:32 |
|
magnuse |
hm, there's a number of debs, akshuly. koha_23.05-1_all.deb + /debs/koha-{common,core,deps,full,perldeps}_23.05-1_all.deb |
| 14:32 |
|
tcohen |
magnuse I'd expect build.sh to succeed on the task |
| 14:32 |
|
tcohen |
especially if run by root |
| 14:32 |
|
magnuse |
which ones are actually needed? common and core are 47M, the others are 3-4K in size |
| 14:37 |
|
tcohen |
all but full? |
| 14:38 |
|
magnuse |
ok, i'll experiment in a virtualbox or something |
| 14:38 |
|
magnuse |
thanks! |
| 14:39 |
|
wajasu |
well, i was trying to run koha-testing-docker with rootless podman. its a no go. since it pulls in the yarn node_modules stuff in the container, when it build the css and js, it wants to write to the koha volume/dir in the container and has no right permission. so running as root makes it work. |
| 14:39 |
|
paulderscheid[m] |
Hi general question: should I be aware of any koha-specific caveats when using triggers in the database? |
| 14:40 |
|
paulderscheid[m] |
Just because there are none by default. Thought there might be a reason for that. |
| 14:40 |
|
paulderscheid[m] |
Hope it is simply: no need. |
| 14:42 |
|
cait |
I think we just don't use triggers |
| 14:42 |
|
paulderscheid[m] |
Why do you even want to run it rootless wajasu? |
| 14:43 |
|
paulderscheid[m] |
Thanks cait. That's good. |
| 14:43 |
|
cait |
maybe there was a problem with early mysql versions? at least I am nto aware of a discussion |
| 14:46 |
|
tcohen |
we don't use triggers because each DB engine uses a different syntax for that... and some people think we should support PostgreSQL |
| 14:46 |
|
tcohen |
if we picked to just support MySQL, we could use CHECK() constraints instead of doing some nasty things in the code |
| 14:46 |
|
paulderscheid[m] |
That makes perfect sense. |
| 14:46 |
|
tcohen |
does it? |
| 14:46 |
|
tcohen |
:-D |
| 14:47 |
|
tcohen |
I mean, I love Postgres, just don't think it is so much gain for the constraints it poses to us |
| 14:47 |
|
cait |
as long as it#s not because we plan on supporting Oracle... |
| 14:48 |
|
tcohen |
whatever we support, it needs to be worth the effort |
| 14:48 |
|
paulderscheid[m] |
Me too, but I don't think it's realistic for the foreseeable future.. |
| 14:48 |
|
paulderscheid[m] |
Yeah, basically what you said tcohen |
| 14:50 |
|
paulderscheid[m] |
Ah, btw with 'That makes perfect sense' I meant your explanation not supporting postgres. |
| 14:50 |
|
tcohen |
I have a customer that would love to run Koha with SQL Server |
| 14:50 |
|
tcohen |
which is a very mature DB engine with much more capabilities |
| 14:50 |
|
paulderscheid[m] |
Why? |
| 14:51 |
|
tcohen |
because they are government, and they bought all the M$ stack for all the infrastructure |
| 14:51 |
|
paulderscheid[m] |
Support? |
| 14:51 |
|
paulderscheid[m] |
My condolences |
| 14:51 |
|
tcohen |
I mean |
| 14:52 |
|
ashimema |
LOL |
| 14:53 |
|
tcohen |
we were lucky they accepted us to host Koha so they don't have an 'uncertified DB engine' on their infra |
| 14:54 |
|
paulderscheid[m] |
Cringe |
| 14:55 |
|
paulderscheid[m] |
If I had a dollar for all yet to be discovered M$ CVE's, I could stop working |
| 14:56 |
|
paulderscheid[m] |
Or rather exploits, because they have yet to be discovered |
| 14:57 |
|
paulderscheid[m] |
But it's the same here in Germany. OS infra gets killed w/ fire every time a single roadblock pops up. |
| 14:58 |
|
Joubu |
I would be rich already if there were bounties for patching Koha sec bugs... |
| 14:58 |
|
Joubu |
or simply discovering :D |
| 14:58 |
|
paulderscheid[m] |
Haha :D |
| 14:59 |
|
khall |
magnuse I was able to build the packages. Here's the command I used based on what I do and what you passed to tcohen : git checkout v23.05.09 && sudo rm -rf /tmp/debs/koha* && rm -rf * && git reset --hard && docker run --volume=/home/kyle/repos/koha:/koha --volume=/tmp/debs:/debs --privileged --env VERSION="23.05.09~1" --env RELEASE="23.05" --env DEB_BUILD_OPTIONS="nocheck" koha/koha-dpkg:master |
| 15:00 |
|
tcohen |
khall++ |
| 15:00 |
|
tcohen |
thanks for confirming |
| 15:00 |
|
Joubu |
(maybe git clean -d -f better than rm -rf * && git reset --hard?) |
| 15:01 |
|
tcohen |
git clean -f -x -d |
| 15:01 |
|
tcohen |
? |
| 15:04 |
|
tcohen |
I'm tweaking the docs |
| 15:04 |
|
tcohen |
input on that is welcome magnuse, khall |
| 15:05 |
|
khall |
tcohen I didn't even know about those options. TIL :) |
| 15:05 |
|
wajasu |
paulderscheid: I just develop with podman these days. It's convenient for me. I dont need to worry as much about pulling various projects in and work a bug. Just want to protect my root on my dev box. |
| 15:06 |
|
wajasu |
it works with rootful podman, so i can make an exception. |
| 15:06 |
|
wajasu |
that 4Gb repo makes me smile though. |
| 15:07 |
|
paulderscheid[m] |
Alright that makes sense, I have used podman for a while as an experiment w/ ktd but went back to docker. |
| 15:08 |
|
wajasu |
i tried userns_mode=keep-id to get the rootless podman to run as my id, but it takes forever to chmod every file in the koha mounted volume/dir. |
| 15:09 |
|
paulderscheid[m] |
Yeah, probably not the best experience. |
| 15:09 |
|
paulderscheid[m] |
I have really gotten into nix the past few weeks. |
| 15:09 |
|
paulderscheid[m] |
Want to try getting koha to run as a nix flake later this year. |
| 15:11 |
|
wajasu |
paulderscheid: i saw a talk on some fosscon docker guy mentioning docker watch. it basically copies/syncs you external files (i.e. git) into your container), watching them for changes. I wonder if that would help speed things. |
| 15:13 |
|
paulderscheid[m] |
If you have any success, update the podman section in the wiki please :D |
| 15:15 |
|
wajasu |
https://youtu.be/u1q8AyNMxd4?t=1121 docker watch hot reload, sync from host to container. |
| 15:15 |
|
tcohen |
khall++ |
| 15:18 |
|
paulderscheid[m] |
Wow that's actually pretty awesome. |
| 15:19 |
|
tcohen |
magnuse: new push on koha-dpkg-docker |
| 15:19 |
|
tcohen |
[master bca6b30] Update README a couple years of pushes later :-D 1 file changed, 48 insertions(+), 69 deletions(-) |
| 15:22 |
|
paulderscheid[m] |
Thanks for sharing wajasu |
| 15:26 |
|
wajasu |
i may have time to try it out on my old box that has docker. |
| 16:43 |
|
|
khall joined #koha |
| 16:45 |
|
|
khall_ joined #koha |
| 17:00 |
|
NikolayGospodinov[m] |
Do you happen to have information about a library with Koha that is taking out a Library Fund Movement Book? |
| 17:39 |
|
reiveune |
bye |
| 17:40 |
|
|
reiveune left #koha |
| 17:52 |
|
JasonGreene[m] |
good day. Trying to change the barcode on a book and tried to follow this https://www.youtube.com/watch?v=y0QXWPMbBFc |
| 17:52 |
|
JasonGreene[m] |
yet in koha 23 I cand find the "edit" link when looking at an item.. any ideas? |
| 17:52 |
|
JasonGreene[m] |
never mind.. I found it :-) |
| 17:55 |
|
JasonGreene[m] |
well I found it yet when I change the "p - Barcode" field I don't see a "save' link only Add or save as temp ... is there a "save" link? |
| 18:24 |
|
|
cait joined #koha |
| 18:30 |
|
ashimema |
@later tell cait are you still struggling to apply bookings bugs.. I was really hoping to see them in master by now |
| 18:30 |
|
huginn` |
ashimema: The operation succeeded. |
| 18:36 |
|
davidnind |
Jason Greene: There are several ways to edit the items attached to a record. I normally go 1) Edit > Edit items from the record page (normal view) 2) In the table with the list of items, click the Actions button then select Edit 3) Title above the form should say 'Edit item #XXXX / Barcode XXXXXX 4) Make changes 5) Options at the bottom of the form are 'Save changes', 'Add a new item', 'Cancel' |
| 18:50 |
|
davidnind |
Screenshot https://snipboard.io/YXIJPk.jpg |
| 18:54 |
|
JasonGreene[m] |
<davidnind> "Jason Greene: There are several..." <- I got 1) Edit 2)Edit record and I see 1 through 9 buttons under the top " Editing Anne of Green Gables c.4 Three Volumes In One (Record number 6876) |
| 18:54 |
|
JasonGreene[m] |
I'm lost |
| 19:01 |
|
davidnind |
You are editing the record, not the items. When you are viewing a record, select Edit (it is a dropdown list) > Edit items. https://snipboard.io/xu5Uqf.jpg |
| 19:05 |
|
davidnind |
Alternatively, in the table with the list of holdings, select the Edit button at the far right to bring up the form to edit that specific item https://snipboard.io/jWmDCq.jpg |
| 19:09 |
|
|
cait joined #koha |
| 19:19 |
|
|
lukeg joined #koha |
| 19:27 |
|
davidnind |
I'm probably being too basic here: there are two parts to a catalog record (at a really basic level), and these are edited in two different places... (full message at <https://matrix.org/_matrix/med[…]JESoWWMzllAcBpWEV>) |
| 19:40 |
|
JasonGreene[m] |
I understand... I think I found that I imported the books twice using the same csv... human problem. So my thoughts are to remove ALL itmes and start the import over. Is there a web page way to delete all items or is it only in mysql ? |
| 19:50 |
|
davidnind |
You could use the Batch item deletion and Batch record deletion tools from the Cataloging home page. For items, you could get the details from either a report or use the Item search screen (Search > Item search at the very top of the staff interface home page). |
| 19:52 |
|
davidnind |
Did you end up with a record for each item (that is, two records for Book A), or duplicated items for each record (a record for Book A, with two items exactly the same?) |
| 19:56 |
|
JasonGreene[m] |
Not sure... I search on a book name and get several books show up ... some are No physical items for this record or No items |
| 19:58 |
|
JasonGreene[m] |
Before I remove everything, can you search for a barcode |
| 19:58 |
|
JasonGreene[m] |
from the patron page |
| 20:01 |
|
davidnind |
no, but you can use the catalog search and enter the barcode |
| 20:05 |
|
davidnind |
you can also use the item search (Search > Item search > Barcode search (near the bottom of the form)) |
| 20:25 |
|
JasonGreene[m] |
thanks\ |
| 22:05 |
|
dcook |
. |
