← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
Time | Nick | Message |
---|---|---|
00:44 | mtj | hey #koha |
00:44 | thomas63[m]: you want some SQL like this... | |
00:44 | update borrowers set email = regexp_replace(email, '\@vodafone.co.nz$', '@one.co.nz' ); | |
00:46 | (perhaps try on a test db 1st) | |
00:47 | thomas63[m] | hi mtj... (full message at <https://matrix.org/_matrix/med[…]AbwTppViEYxBBWhtN>) |
00:47 | or is this really the only line I need? | |
00:49 | mtj | thomas63[m]: its basically it :) |
00:50 | you will need to access your mysql/mariadb database 1st | |
00:50 | thomas63[m] | sounds cool, thanks so much |
00:50 | Will try during the weekend and let you know! | |
00:50 | mtj | $ sudo koha-mysql mykoha123 |
00:51 | MariaDB [koha_mykoha123]> update borrowers set email = regexp_replace(email, '\@vodafone.co.nz$', '@one.co.nz' ); | |
00:52 | 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 | update borrowers set emailpro = regexp_replace( emailpro, '\@vodafone.co.nz$', '@one.co.nz' ); | |
00:53 | 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 | 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 | 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 | 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 | although I am on a demo db, it's a 1:1 copy of a live productive one | |
02:40 | 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 | 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 | thomas63[m]: your demo system is missing that file ^ | |
03:50 | thomas63[m] | no, it exists |
03:50 | it exists on production as well, and it's identical | |
03:50 | 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 | 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 | i think they have added it to the wrong section of the file | |
03:58 | grep -ir init-file /etc/* | |
03:58 | 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 | WORKS !! Thanks a lot | |
04:09 | 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 | I am seeing failures from basic_workflow.t, not auth | |
06:36 | @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 | 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 | 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 | and jquery.barrating.min.js.map | |
09:04 | do you see them too in your console when hitting opac ? | |
09:06 | hmm could it be the load of the server ? | |
09:09 | it has to do something with a wrong path not including the version perhaps ? | |
09:16 | "GET /opac-tmpl/lib/bootstrap/js/bootstrap.bundle.min.js.map HTTP/1.1" 404 | |
09:17 | it looks for .map ! | |
09:17 | where can I correct this ? | |
09:22 | Joubu | we are building the map files only when using the build pipeline for devs |
09:23 | nope, that's for css | |
09:23 | marcelr | do you see that warn in dev console ? |
09:23 | 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 | In production builds you omit it for performance. | |
09:27 | marcelr | but it is causing 404s |
09:27 | 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 | 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 | (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.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 | we ran inot it during training this week, so can verify it's an issue in 22.11.04 | |
10:32 | or more... confirm | |
10:36 | MatthewBlenkinsop[m] | Done - pushed to 22.11.05 |
10:36 | cait | thank you |
10:37 | the library I am training is trackign 22.11 right now, so that will make them happy | |
10:37 | but everyone using the feature too of course | |
10:42 | ashimema | 7 years of coding on that one again.. |
10:42 | oop | |
10:46 | cait joined #koha | |
10:52 | oleonard | o/ |
11:08 | cait1 | hi oleonard |
11:47 | mtj | hey #koha |
11:48 | tcohen: hiya, whats the 22.11 error you are getting for packages? | |
11:52 | is there a log somewhere? | |
12:05 | cait1 | hi mtj |
12:05 | tcohen: around? | |
12:05 | (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 | 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 | 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 | keep them coming :) | |
12:34 | tcohen | hola #koha o/ |
12:34 | marcelr: https://jenkins.koha-community[…]Build/testReport/ | |
12:37 | 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.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 | so 22.11+ | |
13:04 | 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 | 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 | I was trying to get into a VPN to do it remotely | |
13:32 | 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 | 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 | but fails for koha-dpkg | |
14:05 | tcohen | the build-git-snapshot step is failing |
14:05 | that initial one, building the base.tgz isn't | |
14:09 | testing 22.05.11 | |
14:12 | 22.05 fails because of this: | |
14:12 | Reading state information... | |
14:12 | E: Unable to locate package libtest-dbix-class-perl | |
14:13 | 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 | not sure why it got removed from oldstable :/ | |
14:21 | 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 | 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:25 | 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 | thx for letting me crash your meeting | |
14:40 | MatthewBlenkinsop[m] | I'm running KTD on a mac, M2 though |
14:40 | 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 | on the docker command | |
14:47 | 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 | 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 | tcohen: i have had some issues starting ktd with ktd --es7 up and ktd --selenium up | |
14:52 | it ...exits | |
14:52 | early on | |
14:53 | does that ring any bell? | |
14:53 | 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 | it's been like that... for about a week now | |
14:57 | i did the full program... git pull, ktd pull etc. | |
15:00 | tcohen | cait: I start my work day my doing |
15:00 | 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 | yeah, it seems you are missing a `ktd down` | |
15:00 | cait1 | oh |
15:01 | i didn't know i needed to extra pull them | |
15:01 | 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 | 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 | I can do that | |
15:03 | hm your command gives me an error | |
15:03 | tcohen | interesting |
15:03 | 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 | just use ktd --es7 up | |
15:04 | leave the other options alone | |
15:05 | mtj: so... | |
15:05 | back to the original question heh | |
15:05 | how are you building 22.11+ | |
15:05 | because yarn doesn't seem to work inside a pbuilder base.tgz inside Docker | |
15:06 | cait | tcohen: looking better this time |
15:06 | 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 | because docker errors are harder to parse for humans | |
15:08 | cait | maybe the docker system prune did the trick? |
15:08 | it's working now :) | |
15:08 | 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 | have the notes from Marseillle, just didn't get to do it yet | |
15:10 | thx for the help, commands noted for next time :) | |
15:10 | selenium worked too | |
15:11 | mtj | tcohen: will try to take another look tmrw, im off to bed |
15:11 | ..but im curious why yarn would fail in a docker?! | |
15:14 | https://gitlab.com/mjames/koha[…]/prep-pbuilder.sh | |
15:15 | tcohen: if you are curious, take a look at my pbuilder prep stuff ^ | |
15:16 | mkdir -p /nonexistent/.yarn | |
15:16 | mkdir -p /nonexistent/.cache/yarn | |
15:16 | perhaps that stuff helps? ^ | |
15:16 | 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 | 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 | 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 | MatthewBlenkinsop[m]: are you using Docker with Rosetta2? | |
15:31 | and what about you oleonard | |
15:32 | oleonard | Rosetta2? |
15:34 | Oh I see | |
15:34 | I can try it | |
15:37 | 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 | https://docs.docker.com/deskto[…]tall/mac-install/ | |
15:43 | ^^ that's where I read about Rosetta | |
15:46 | 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 | Running curl directly against the unix socket just hangs | |
16:35 | restarting either apache2 or plack seems to resolve it for a while | |
16:36 | i'm not finding much in the logs that points to a cause | |
16:43 | 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 | 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 | tcohen where did you see that? | |
17:30 | tcohen | I was trying to find a prior paste from mtj |
17:30 | switched computer so was going backwards in number | |
17:30 | (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 | we've recently deleted (moved to trash) a bunch of borrowers and anonymised their checkout histories and assigned them to a borrower. | |
19:13 | 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 | 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 | ./bin/ktd down ; ./bin/ktd pull ; ./bin/ktd up | |
21:54 | 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 |
← Previous day | Today | Next day → | Search | Index