Time 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/media/v3/download/matrix.org/guwjSViAbwTppViEYxBBWhtN>) 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/media/v3/download/matrix.org/QojTfkhlppiGudawMEFfLHPM>) 02:15 thomas63[m] and in the terminal using... (full message at <https://matrix.org/_matrix/media/v3/download/matrix.org/OLydNMufXOOqLvUynczsBKzu>) 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/media/v3/download/matrix.org/rDkwrTGKMDWbumHJTaXUcjOW>) 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/media/v3/download/matrix.org/AytCcsfTeCBmTlVcbCwABadq>) 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 o/ 06:07 magnuse \o/ 06:15 ashimema \o 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 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 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 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 04Bug https://bugs.koha-community.org/bugzilla3/show_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: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.org/job/Koha_Master_My8/lastCompletedBuild/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 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33576 major, P5 - low, ---, nick, Needs Signoff , Records are not indexed when imported if using Elasticsearch 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-community/koha-dpkg-docker/-/blob/master/pbuilder.sh 13:55 mtj echo "deb http://debian.koha-community.org/koha $RELEASE main buster" > /etc/apt/sources.list.d/koha.list 14:01 mtj tcohen: that apt line works for me 14:02 tcohen yes but 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: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 tcohen ktd --selenium --es7 --plugin --sso pull 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-build-pkg/-/blob/master/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: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/desktop/install/mac-install/ 15:43 tcohen ^^ that's where I read about Rosetta 15:46 tcohen later #koha, running to the doctor 16:09 MatthewBlenkinsop[m] I'm running Docker Desktop v4.14 and have Rosetta installed 16:20 reiveune bye 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: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 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 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