IRC log for #koha, 2023-04-21

All times shown according to UTC.

Time S Nick Message
00:44 mtj hey #koha
00:44 mtj thomas63[m]: you want some SQL like this...
00:44 mtj update borrowers set email = regexp_replace(email, '\@vodafone.co.nz$', '@one.co.nz' );
00:46 mtj (perhaps try on a test db 1st)
00:47 thomas63[m] hi mtj... (full message at <https://matrix.org/_matrix/med[…]AbwTppViEYxBBWhtN>)
00:47 thomas63[m] or is this really the only line I need?
00:49 mtj thomas63[m]: its basically it :)
00:50 mtj you will need to access your mysql/mariadb database 1st
00:50 thomas63[m] sounds cool, thanks so much
00:50 thomas63[m] Will try during the weekend and let you know!
00:50 mtj $ sudo koha-mysql mykoha123
00:51 mtj MariaDB [koha_mykoha123]> update borrowers set email = regexp_replace(email, '\@vodafone.co.nz$', '@one.co.nz' );
00:52 mtj thomas63[m]: aah, there are *3* email fields, so you should update each
00:53 thomas63[m] and how?
00:53 mtj update borrowers set email    = regexp_replace( email, '\@vodafone.co.nz$', '@one.co.nz' );
00:53 mtj update borrowers set emailpro = regexp_replace( emailpro, '\@vodafone.co.nz$', '@one.co.nz' );
00:53 mtj update borrowers set B_email  = regexp_replace( B_email, '\@vodafone.co.nz$', '@one.co.nz' );
00:54 thomas63[m] you have a backslash in front of the first @, but not in front of the 2nd one. Is that correct?
00:54 mtj yes ^
00:54 thomas63[m] looks easier that expected ;-)
00:55 mtj looks like the slash is probably not required, but it also does not hurt :)
01:01 mtj thomas63[m]: good luck, if you get stuck you can always ask for help here 🐹
02:12 thomas63[m] I am kind of stuck....... (full message at <https://matrix.org/_matrix/med[…]lppiGudawMEFfLHPM>)
02:15 thomas63[m] and in the terminal using... (full message at <https://matrix.org/_matrix/med[…]fXOOqLvUynczsBKzu>)
02:33 davidnind thomas63: koha-list should give you the names of any instances you have
02:35 thomas63[m] ok, it shows 'library'... (full message at <https://matrix.org/_matrix/med[…]KMDWbumHJTaXUcjOW>)
02:35 thomas63[m] so the installation looks weird...
02:39 davidnind I'm assuming you can access the staff interface and OPAC, and login?
02:39 thomas63[m] yes, that works
02:40 thomas63[m] although I am on a demo db, it's a 1:1 copy of a live productive one
02:40 thomas63[m] I get the same error messages on the productive one, but it is productive and runs
02:44 davidnind sorry, I don't know enough about mysql/mariadb to know what it means
02:44 davidnind can you access mysql with the root user and password?
02:45 thomas63[m] thanks anyway, at least I know now the real instance name
03:48 mtj mysql: [ERROR] unknown variable 'init-file=/var/lib/mysql/init-file_koha.sql'.
03:49 mtj thomas63[m]: your demo system is missing that file ^
03:50 thomas63[m] no, it exists
03:50 thomas63[m] it exists on production as well, and it's identical
03:50 thomas63[m] I get the same error message on production
03:50 mtj aah, at least you have consistency
03:50 thomas63[m] yes I do
03:51 thomas63[m] I thought there is maybe an error in that file
03:56 mtj thomas63[m]: the previous sysadmin has added that line to the mysql config file
03:57 mtj i think they have added it to the wrong section of the file
03:58 mtj grep  -ir  init-file /etc/*
03:58 mtj line should been in the [mysqld] section, not the [client] section
04:02 thomas63[m] it is, it is the only line even... (full message at <https://matrix.org/_matrix/med[…]TeCBmTlVcbCwABadq>)
04:03 mtj thomas63[m]: change to [mysqld] , restart mysql
04:04 thomas63[m] ahh I see, ok, will try
04:08 thomas63[m] WORKS !! Thanks a lot
04:09 thomas63[m] the replace worked now as well
04:38 mtj congrats 🍕🐷🍺
05:35 davidnind mtj++
06:00 marcelr joined #koha
06:00 marcelr o/
06:07 magnuse \o/
06:15 ashimema \o
06:26 cait joined #koha
06:28 cait1 joined #koha
06:35 Joubu tcohen: which selenium tests?
06:36 Joubu I am seeing failures from basic_workflow.t, not auth
06:36 Joubu @later tell tcohen which selenium tests? I am seeing failures from basic_workflow.t, not auth.
06:36 huginn Joubu: The operation succeeded.
06:41 marcelr Joubu: are you planning to work on 24975 now ? or can I look further ?
06:43 reiveune joined #koha
06:43 reiveune hello
06:54 Joubu marcelr: I will have a look in a bit, yes
06:54 Joubu I'd like to clean the itemtype code in the controllers
06:58 cait1 good morning good people of #koha :)
06:59 marcelr hi cait of koha
06:59 Joubu o/
07:18 ashimema I'm having a head down in bookings day today. Now it's rebased and most errors fixed I need to revisit the specs and end to end test it to ensure its all solid
07:18 cait1 fingers crossed ashimema :)
07:19 cait1 trianing ILL this morning
07:38 AnkeB joined #koha
08:49 magnuse ashimema++
08:49 ashimema ?
09:03 marcelr anyone have a clue what causes source map errors on bootstrap.bundle.min.js.map ?
09:03 marcelr and jquery.barrating.min.js.map
09:04 marcelr do you see them too in your console when hitting opac ?
09:06 marcelr hmm could it be the load of the server ?
09:09 marcelr it has to do something with a wrong path not including the version perhaps ?
09:16 marcelr "GET /opac-tmpl/lib/bootstrap/js/​bootstrap.bundle.min.js.map HTTP/1.1" 404
09:17 marcelr it looks for .map !
09:17 marcelr where can I correct this ?
09:22 Joubu we are building the map files only when using the build pipeline for devs
09:23 Joubu nope, that's for css
09:23 marcelr do you see that warn in dev console ?
09:23 marcelr does it impact js execution some how ?
09:26 paulderscheid[m] No
09:26 marcelr hmm i am seeing it in 21.11 now too
09:26 paulderscheid[m] This is just for having a view of the js source in a unminified version.
09:27 paulderscheid[m] In production builds you omit it for performance.
09:27 marcelr but it is causing 404s
09:27 marcelr can you just remove the source mapping url at the end ?
09:28 paulderscheid[m] Hmm, can we somehow include this in dev but not in prod?
09:28 marcelr might be harder
09:28 paulderscheid[m] True
09:29 marcelr we still have that asset tric with version numbers around it too ?
09:42 paulderscheid[m] What trick do you mean marcelr ?
09:44 marcelr the thing we are doing with those version numbers adding and stripping
09:44 marcelr to force updates
09:58 cait joined #koha
10:06 AnkeB Hi! Is it possible to set the amount of authorized values displayed in the staff client from 20 to something else (50, 100, or all)? This would make it a lot more comfy.
10:06 AnkeB (the default, I mean, of course).
10:11 Joubu the table is not in the "table settings" admin page, so no (unless you do it in JS I guess)
10:21 cait MatthewBlenkinsop[m]: can you please push the bug fix from bug 33574? It doesn't affect strings
10:21 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=33574 major, P5 - low, ---, martin.renvoize, Pushed to master , Restriction type is not stored, all restrictions fall back to MANUAL
10:30 MatthewBlenkinsop[m] <cait> "Matthew Blenkinsop: can you..." <- Just having a look now
10:31 cait thx!
10:31 cait we ran inot it during training this week, so can verify it's an issue in 22.11.04
10:32 cait or more... confirm
10:36 MatthewBlenkinsop[m] Done - pushed to 22.11.05
10:36 cait thank you
10:37 cait the library I am training is trackign 22.11 right now, so that will make them happy
10:37 cait but everyone using the feature too of course
10:42 ashimema 7 years of coding on that one again..
10:42 ashimema oop
10:46 cait joined #koha
10:52 oleonard o/
11:08 cait1 hi oleonard
11:47 mtj hey #koha
11:48 mtj tcohen: hiya, whats the 22.11 error you are getting for packages?
11:52 mtj is there a log somewhere?
12:05 cait1 hi mtj
12:05 cait1 tcohen: around?
12:05 cait1 (also looking for him)
12:09 mtj hi cait1, have you tried saying his name 3 times?
12:10 cait1 I am a little scard of doing it :)
12:10 cait1 not ure what the error was, but I am training on a 22.11.04 this week - update seems to have worked there
12:11 mtj aah nice! i think tomas was talking about a problem specific to koha-dpkg
12:12 Joubu aude_c[m]: regarding your PR for 24151 (pseudonymization) - I would add a big warning to NOT COPY the bcrypt_settings you are using in the manual
12:12 Joubu I am afraid someone could reuse it just because they want it to work
12:21 cait1 oleonard: will the template wrappers et cever end? :)
12:24 oleonard cait1: Only 5 or 6 patches left in the breadcrumb series!
12:24 cait1 oh that's awesome
12:24 cait1 keep them coming :)
12:34 tcohen hola #koha o/
12:34 tcohen marcelr: https://jenkins.koha-community[…]Build/testReport/
12:37 tcohen oleonard++
12:39 cait1 hola
12:41 tcohen Joubu: it was the basic workflow, but it was failing on $s->auth locally
12:42 Joubu did you search for the error on bugzilla?
12:43 aude_c[m] Joubu Thanks, I will add that!!
13:01 tcohen marcelr: can you take a look at bug 33576
13:01 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=33576 major, P5 - low, ---, nick, Needs Signoff , Records are not indexed when imported if using Elasticsearch
13:02 cabillman[m] joined #koha
13:03 mtj hola tcohen, are any koha-dpkg branches known to work?
13:03 tcohen mtj: it's yarn that doesn't work
13:04 tcohen so 22.11+
13:04 tcohen is failing
13:07 mtj ah ok, ill take a look
13:10 caroline Joubu, aude_c[m] if we muddle the key, would that prevent it from working even if they copy-paste it? ex change a couple of numbers and letters so that it's not really a key
13:13 Joubu no, it's just a password
13:16 caroline Ok thanks!  I thought it was like an API key or something
13:16 aude_c[m] maybe I should make clear in the warning that it's not secure to use that one?
13:21 mtj tcohen: i'm getting koha-dpkg build fails on 21.11.18 and 22.05.11 - lots of pkg dependency errors
13:21 tcohen what command are you running?
13:21 tcohen for 22.05.11, for example
13:22 mtj docker run --volume=/home/mason/git/koha:/koha --volume=/home/mason/tmp/debs:/debs --volume /proc:/proc --privileged --env VERSION="22.05.11" --env RELEASE="22.05" koha/koha-dpkg:master
13:23 caroline Joubu, does bcrypt expect a certain length? If we remove a couple of characters will it still be valid?
13:23 pastebot "mtj" at 127.0.0.1 pasted "The following packages have unmet dependencies:" (17 lines) at https://paste.koha-community.org/6677
13:24 mtj tcohen: could you try a 22.05.11 build too, pls?
13:32 tcohen sure
13:32 tcohen I was trying to get into a VPN to do it remotely
13:32 tcohen because my internet s*ks
13:35 Joubu caroline: I don't think so (don't remember to be honest), but I think it's good to provide an example that is working, however it needs a warning to tell that it should not be used in production
13:37 caroline OK. I don't think it's necessary to provide a working example, just to know what it's supposed to look like when you run the command. But I don't mind either way
13:48 tcohen mtj: the RELEASE  variable is used to pick the right repository for dependencies
13:49 tcohen do those dependency failures ring any bell on you?
13:53 mtj hmm, no.. it looks like those deps should install ok
13:54 tcohen https://gitlab.com/koha-commun[…]aster/pbuilder.sh
13:55 mtj echo "deb http://debian.koha-community.org/koha $RELEASE main buster" > /etc/apt/sources.list.d/koha.list
13:57 oleonard joined #koha
14:01 mtj tcohen: that apt line works for me
14:02 tcohen yes but
14:02 lukeg joined #koha
14:02 mtj echo "deb http://debian.koha-community.org/koha 22.05 main buster" > /etc/apt/sources.list.d/koha.list
14:03 mtj but fails for koha-dpkg
14:05 tcohen the build-git-snapshot step is failing
14:05 tcohen that initial one, building the base.tgz isn't
14:09 tcohen testing 22.05.11
14:12 tcohen 22.05 fails because of this:
14:12 tcohen Reading state information...
14:12 tcohen E: Unable to locate package libtest-dbix-class-perl
14:13 tcohen mtj: https://paste.koha-community.org/6687
14:16 oleonard is there a KTD version working on M1 macs right now?
14:16 tcohen MatthewBlenkinsop[m] had it working
14:18 oleonard MatthewBlenkinsop[m]: through magic?
14:18 mtj tcohen: libtest-dbix-class-perl should be added to koha repo now
14:20 mtj not sure why it got removed from oldstable :/
14:21 mtj oleonard: if you fetch/pull the latest ktd, it should 'just work'
14:22 oleonard mtj cool, I'll try it!
14:22 mtj aah, only master bullseye and focal images have been added, so far
14:22 mtj oleonard: do you need other os/koha version combos?
14:23 oleonard mtj I don't know I was happy with the "just work" idea :)
14:24 tcohen mtj: still the same dependency issues I pasted
14:37 kidclamp sorry i cut you off cait
14:37 tcohen :-D
14:39 cait1 all good - i talk too much :)
14:40 cait1 thx for letting me crash your meeting
14:40 MatthewBlenkinsop[m] I'm running KTD on a mac, M2 though
14:40 MatthewBlenkinsop[m] But should still work for an M1
14:40 tcohen cait++
14:41 oleonard cait1 you were a meeting guest star?
14:42 ashimema did you switch to the main ktd repo yet matt.. or are you still tracking mtj's?
14:43 tcohen he tried the changes we did to the ktd command
14:44 mtj tcohen: is there a way to skip tests for koha-dpkg?
14:44 tcohen it should honor the SKIP_TESTS variable?
14:46 mtj ah yep, my notes say  DEB_BUILD_OPTIONS=nocheck tooo
14:47 tcohen --env DEB_BUILD_OPTIONS="nocheck"
14:47 tcohen on the docker command
14:47 tcohen that is
14:47 mtj sure
14:47 cait1 oleonard i probably not qualify for that
14:48 MatthewBlenkinsop[m] <ashimema> "did you switch to the main ktd..." <- I'm on the main KTD repo
14:48 ashimema nice one, glad that's all working now
14:48 tcohen that reminds me, we need to make it use the arm64 ES
14:49 ashimema oooh, good call
14:49 tcohen I'll need a tester
14:49 tcohen heh
14:50 * ashimema has finally started writing his hackfest review blogpost with aude_c
14:50 ashimema it's turning into a monster.. we did sooooo much!
14:52 cait1 ashimema: sounds like a good activity then :)
14:52 cait1 tcohen: i have had some issues starting ktd with ktd --es7 up and ktd --selenium up
14:52 cait1 it ...exits
14:52 cait1 early on
14:53 cait1 does that ring any bell?
14:53 cait1 when I do a ktd down ktd up it works fine
14:53 tcohen what is the error?
14:53 cait1 on the wrong computer now, let me get back to you in a little bit
14:54 cait1 left #koha
14:55 cait joined #koha
14:55 cait don't be afraid of doubled up cait...
14:55 oleonard I always feel reassured by multiple caits
14:56 cait tcohen: https://paste.koha-community.org/6692
14:57 cait it's been like that... for about a week now
14:57 cait i did the full program... git pull, ktd pull etc.
15:00 tcohen cait: I start my work day my doing
15:00 tcohen ktd down # just in case
15:00 bag joined #koha
15:00 tcohen ktd --selenium --es7 --plugin --sso pull
15:00 cait1 joined #koha
15:00 tcohen ktd --selenium --es7 --plugin --sso up -d
15:00 tcohen yeah, it seems you are missing a `ktd down`
15:00 cait1 oh
15:01 cait1 i didn't know i needed to extra pull them
15:01 cait1 no i did the ktd down
15:01 cait and it finished with green checkmarks everywher
15:01 tcohen the 'orphan containers' warning is suspicious
15:01 cait e
15:02 cait i'll do the command onw that you wrote earlier, but I did the ktd down before trying to start it every time
15:02 tcohen docker system prune just in case?
15:02 cait i usually to ktd down, git pull (koha), git pull ktd, ktd pull... everyt ime before I start working
15:02 cait I can do that
15:03 cait hm your command gives me an error
15:03 tcohen interesting
15:03 tcohen mtj: I confirm the nocheck made 22.05.11 build perfectly fine
15:04 cait https://paste.koha-community.org/6695
15:04 mtj tcohen: yep me too
15:04 tcohen cait: is PLUGIN_REPO set?
15:04 tcohen just use ktd --es7 up
15:04 tcohen leave the other options alone
15:05 tcohen mtj: so...
15:05 tcohen back to the original question heh
15:05 tcohen how are you building 22.11+
15:05 tcohen because yarn doesn't seem to work inside a pbuilder base.tgz inside Docker
15:06 cait tcohen: looking better this time
15:06 cait PLUGIN_REPO not set yet
15:06 tcohen it only makes sense to use --plugin if you have the variable set
15:06 cait that makes sense :)
15:07 tcohen I'll make the ktd command bail out if the variable is not set
15:07 tcohen because docker errors are harder to parse for humans
15:08 cait maybe the docker system prune did the trick?
15:08 cait it's working now :)
15:08 cait I'll test with selenium too
15:09 mtj tcohen: hmm, im not building in docker - but a xen guest, with pbuilder
15:09 tcohen add export PLUGIN_REPO=/home/kfischer​/git/koha-plugin-slnp-ill to your bashrc
15:09 cait it's not there yet, but I will
15:09 cait have the notes from Marseillle, just didn't get to do it yet
15:10 cait thx for the help, commands noted for next time :)
15:10 cait selenium worked too
15:11 mtj tcohen: will try to take another look tmrw, im off to bed
15:11 mtj ..but im curious why yarn would fail in a docker?!
15:14 mtj https://gitlab.com/mjames/koha[…]/prep-pbuilder.sh
15:15 mtj tcohen: if you are curious, take a look at my pbuilder prep stuff ^
15:16 mtj mkdir -p /nonexistent/.yarn
15:16 mtj mkdir -p /nonexistent/.cache/yarn
15:16 mtj perhaps that stuff helps? ^
15:16 mtj perhaps that stuff helps? ^
15:17 cait1 tcohen++
15:20 mtj ciao cait1 🐹
15:21 cait1 now idea where that one went...
15:26 tcohen ohh
15:27 tcohen cait1: it is hard to help people debug docker problems, it is not really KTD but docker, and a growing number of different setups
15:27 tcohen that's why we are aiming to improve the `ktd` command and have most people use the same thing
15:27 cait1 I don't use docker for anytihng else...so I don't really know much about it
15:27 pastebot "oleonard" at 127.0.0.1 pasted "KTD failure on M1 Mac" (12 lines) at https://paste.koha-community.org/6698
15:28 Dyrcona joined #koha
15:29 oleonard I don't know if there's anything relevant in that snippet of output... I can dig for more if anyone has suggestions
15:29 tcohen oleonard: thanks, bag had the exact same error
15:31 tcohen MatthewBlenkinsop[m]: are you using Docker with Rosetta2?
15:31 tcohen and what about you oleonard
15:32 oleonard Rosetta2?
15:34 oleonard Oh I see
15:34 oleonard I can try it
15:37 oleonard Now instead of the "Couldn't create the mpm-accept mutex" part I see "Trace/breakpoint trap"
15:43 tcohen we really need MatthewBlenkinsop[m] to share his setup
15:43 tcohen https://docs.docker.com/deskto[…]tall/mac-install/
15:43 tcohen ^^ that's where I read about Rosetta
15:46 tcohen later #koha, running to the doctor
15:57 oleonard_ joined #koha
16:09 MatthewBlenkinsop[m] I'm running Docker Desktop v4.14 and have Rosetta installed
16:20 reiveune bye
16:20 reiveune left #koha
16:35 cabillman[m] I have a fresh koha 22.11 install from debian packages where plack will randomly stop responding to requests. The server itself isn't overloaded since I'm currently the only one who can access it.
16:35 cabillman[m] Running curl directly against the unix socket just hangs
16:35 cabillman[m] restarting either apache2 or plack seems to resolve it for a while
16:36 cabillman[m] i'm not finding much in the logs that points to a cause
16:43 cabillman[m] any thoughts on how to potentially diagnose it?
17:11 dpk left #koha
17:17 oleonard MatthewBlenkinsop[m] did you run into a "Trace/breakpoint trap" error? I can't get it to work
17:27 pastebot "oleonard" at 127.0.0.1 pasted "Different error if I immediately re-run 'ktd up'" (14 lines) at https://paste.koha-community.org/6725
17:28 tcohen how did you reach that, oleonard?
17:29 tcohen WTF: https://paste.koha-community.org/6710
17:29 oleonard tcohen I followed the instructions for installing Rosetta2, made sure it was enabled in Docker. Did 'docker system prune -a -f'. Ran 'ktd up'
17:29 oleonard tcohen where did you see that?
17:30 tcohen I was trying to find a prior paste from mtj
17:30 tcohen switched computer so was going backwards in number
17:30 tcohen (instead of using the log)
17:57 oleonard for what it's worth, this appears near the start of the 'ktd up' output: " ! koha The requested image's platform (linux/amd64) does not match the detected host platform (linux/arm64/v8) and no specific platform was requested"
19:10 tundunf joined #koha
19:10 tundunf hi all :)
19:12 tundunf we've recently deleted (moved to trash) a bunch of borrowers and anonymised their checkout histories and assigned them to a borrower.
19:13 tundunf Now that their checkout histories have been assigned to an anon borrower, would we be able to permanently delete these users without any consequences?
19:19 davidnind tundunf: I think(but I'm probably wrong) that removing this would affect any statistical reports you may have
19:20 caroline I don't think anything references the deletedborrowers table
19:21 oleonard no, but you might want to use data from deletedborrowers in reports
19:25 cait it doesn't affect functionality, but you should check for reporting
19:26 cait anonymizing them again might be something to look into (not built into Koha yet I think) -  keeping branch, category and such maybe
19:31 oleonard joined #koha
21:02 oleonard joined #koha
21:48 mtj oleonard: are you on the master branch of ktd repo, at latest commit 2672028 ?
21:50 mtj ./bin/ktd down ; ./bin/ktd pull ; ./bin/ktd up
21:54 mtj cabillman[m]: what are the specs of your system? how many cpu cores and ram?
21:56 oleonard Thanks for checking in mtj, I'm about to walk out so I'll have to try later!
21:58 mtj oleonard: np, your last error suggests that you dont have the latest ./bin/ktd version

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary