Time Nick Message 00:45 dcook [off] Well I've had my monthly rant. For me to crawl back into my troll cave :( 03:53 ahmad hlw everyone 03:53 ahmad How are you? 03:54 ahmad I am facing session time out problem with Latest koha installation in Ubuntu 22.04 03:54 ahmad anybody can help me 04:02 ahmad hlw 04:02 ahmad anybody here/ 04:06 ahmad hlw 04:06 ahmad anybody can help 04:06 ahmad :? 05:32 ahmad hlw 05:33 ahmad I am facing session time out problem with Latest koha installation in Ubuntu 22.04 06:55 ahmad hl;w 06:55 ahmad anybody here 06:55 ahmad I am facing session time out problem with Latest koha installation in Ubuntu 22.04 06:55 ahmad someone can help me 06:56 Joubu what's your problem exactly? 07:10 * cait1 waves 07:28 magnuse \o/ 07:32 cait hi magnuse :) 07:32 magnuse guten morgen cait 07:47 aroussos Hello everyone! 07:48 aroussos I am trying to add a new Koha to MARC mapping association (new field 942,h for biblioitems.cn_class) through our "Books" bibliographic MARC framework (clone of the "Default" framework), but it does not register in Koha to MARC mapping. 07:48 aroussos Do I need to do it only through the "Default" bibliographic MARC framework? I thought that making changes to the "Default" framework is not a good idea... 07:51 Joubu aroussos: To edit a mapping you should do it in "Koha to MARC mapping" 07:52 Joubu in new versions of Koha the edition is no longer possible from the frameworks 08:01 aroussos Joubu: Thanks for the prompt reply 08:01 aroussos Joubu: OK, we now tried to add the mapping in "Koha to MARC mapping" 08:01 aroussos Joubu: But because the subfield we want to map to does not yet exist in our clone of the "Default" framework, it still doesn't work 08:02 aroussos Joubu: So, we had to add the new subfield (942$h) in the "Default" framework, in order to register the association in "Koha to MARC mapping" 08:02 aroussos Joubu: (We're on a UNIMARC instance, BTW) 08:04 aroussos Joubu: Interestingly, once we've registered the Koha to MARC mapping, as soon as we created 942$h in our "Books" framework too, it picked up the association automatically 08:24 Joubu yes, the mapping you defined in "Koha to MARC mapping" will be used by all the frameworks 08:26 Joubu which is not what shows the DB structure: the "mapping" is actually the value defined in marc_subfield_structure.kohafield for the default framework 08:30 cait I think there is a bug there in that it silently fails if the subfield/field was not defined yet in the default framework 08:31 gk_ koha opac detail page error- Sorry, the requested page is not available Errot: 500 but works fine in intranet, on Debian 12, MariaDB 10.11.3, Koha 23.05.02 08:37 ahmad I am facing session time out problem with Latest koha installation in Ubuntu 22.04 08:37 cait gk_: is it only that one page or do all detail pages not work? 08:37 ahmad All pages 08:37 cait a common reason for detai page breaking is if the items don't ahve itemtypes set 08:38 gk_ all detail pages do not load 08:38 cait for session timeout check the timeout system preference 08:38 ahmad have checked 08:38 cait do other pages of the OPAC load? 08:38 ahmad have checked system preferences 08:38 ahmad it set 4d and mysqldatabse 08:39 cait not srue about the timeout, but about your deatil pages: do you have anything in OpacHiddenItems? 08:40 ahmad anybody can help regarding timeout problem 08:40 ahmad it set 4d and mysqldatabse 08:41 ahmad I am facing session time out problem with Latest koha installation in Ubuntu 22.04 and Koha 23.05.02 08:45 gk_ all other pages load, but click on title throw error 08:59 MatthewBlenkinsop[m] Morning Koha - As promised at Kohacon I've made some changes to the docs on installing and configuring git-bz to make them more user-friendly for non-devs and remove outdated info. If anyone doesn't currently have it installed locally and wants to give it a try, please do and let me know if any further improvements can be made :) I've only amended sections 1.1 and 1.2, the rest still seems pretty up to date 09:00 MatthewBlenkinsop[m] https://wiki.koha-community.org/wiki/Git_bz_configuration 09:12 ahmad I am facing session time out problem with Latest koha installation in Ubuntu 22.04 and Koha 23.05.02 09:16 paulderscheid[m] Anyone else having problems w/ fetching node_modules rn? 09:25 cait2 ahmad: you didn't answer my question about OpacHiddenItems 09:27 cait MatthewBlenkinsop++ 09:27 cait sorry for ht ename updates... unstable VPN 09:28 ahmad ciat2: not set opachiden item 09:43 gk_ koha opac detail page error- Sorry, the requested page is not available Error: 500 but works fine in intranet, on Debian 12, MariaDB 10.11.3, Koha 23.05.02 09:44 Joubu gk_: looks at the Koha logs on the server 09:45 ahmad I am facing session time out problem with Latest koha installation in Ubuntu 22.04 and Koha 23.05.02 09:45 Joubu ahmad: we don't have answer to your question, you must provide more information 09:45 Joubu ahmad: please stop asking the same question again and again 09:50 angelic Hello to everyone. I need your help about a SQL report. I would be very glad if someone could help. We want a list of users we have discharge. If people on this list have borrowed material, we want them to appear on the list as well. If the person has borrowed more than one material, they can repeat the information in the list. 09:51 ahmad Joubu: you should not say this. you are not only one here to answer the quesions. I have problem. so i am asking 09:53 Joubu what's your problem exactly? (or see https://irc.koha-community.org/koha/2023-08-31#i_2505460 question I've asked you already and you didn't answer) 09:53 Joubu ahmad: ^^ 09:54 ahmad Joubu: my koha logout repetedly. If idle few times it logout but set session perfectly at system preferences 09:55 Joubu angelic: how can they be discharged and have checked out items? Is that possible? 09:55 Joubu ahmad: what's your version of Koha? 09:55 Joubu ahmad: did you restart the different services? memcached + koha-common 09:57 cait angelic: do you use the discharge restriction? as Joubu said it should not be psosible to have checked out items then 09:58 cait but maybe you are using a different workflow? 09:59 cait best to talk about what you exactly need, before making suggestions 09:59 cait (need to know how you discharge, to write the SQL) 09:59 cait or did you mean borrowed in the past maybe? 10:06 cait lunch time, bbiab 10:57 ahmad joubu: Koha 23.05.02 10:57 ahmad Joubu: i am using Koha 23.05.02 11:03 Joubu ok, second question? 11:10 ahmad yes restarted the services 11:11 ahmad restarted Koha plack and memcached 11:24 aroussos ahmad: When the session timeout occurs, do you get something like this screenshot? https://snipboard.io/7BKr6o.jpg 11:27 ahmad aroussos: yes like this 11:27 ahmad https://snipboard.io/7BKr6o.jpg 11:28 oleonard Hi #koha 11:29 ahmad yes 11:29 cait MatthewBlenkinsop++ 11:29 cait hi oleonard 11:29 ahmad hi 11:40 ahmad Hlw 11:40 ahmad everyone 11:41 ahmad I am facing session time out problem with Latest koha installation in Ubuntu 22.04 and Koha 23.05.02 11:42 cait ahmad: have you tried updating the timeout system preference to a different value 11:42 cait ? 11:43 cait I see we have 1d in our setup - and no spaces etc. after 11:45 aroussos ahmad: OK, thanks for confirming. I'd like you to check a couple more items for me please: 11:46 aroussos ahmad: 1) Current date/time in the computer you use to access Koha, and on the server that hosts the ILS. Perhaps the clocks have drifted apart? (this can happen due to NTP issues, for example) 11:47 aroussos ahmad: 2) How is your SessionRestrictionByIP system preference set up? Does your IP address change frequently for some reason? (I think it can theoretically happen if you use IPv6, but then again not so frequently perhaps...) 11:48 aroussos ahmad: 3) You mentioned earlier that you've set SessionStorage => MySQL database. This is a long shot, but I'm wondering if the disk partition that holds your DB has become full somehow? (thus being unable to create new entries in the 'sessions' table) 11:55 oleonard Would it be okay to include a do-not-push updatedatabase with a patch in order to make it easier for testing? I can't remember if that's been done before. I'm thinking it would help someone who wanted to test in a sandbox. 12:14 cait oleonard: I'd say why not :) 12:15 oleonard Thanks cait. During Hackfest I realized that an sql file or a script doesn't work to for sandbox users 12:17 cait if you clearly label it as don't push I see no reason why not to - maybe also as a comment in the file? 12:17 cait tcohen[m] ? 12:17 tcohen[m] hola 12:17 cait hola 12:17 tcohen[m] what's up? 12:17 tcohen[m] I'm finishing my new laptop setup \o/ 12:17 cait congrats :) 12:18 cait was referring to oleonards question: Would it be okay to include a do-not-push updatedatabase with a patch in order to make it easier for testing? I can't remember if that's been done before. I'm thinking it would help someone who wanted to test in a sandbox. 12:18 cait (I allowed it already, so you can#t say no now ;) ) 12:18 oleonard "C'mon dad, mom said I could!!" 12:19 tcohen[m] sure, add a clear '[DO NOT PUSH]' 12:19 cait see ;) 12:20 oleonard cait: It's important to let dad think it was his idea :D 12:21 cait you can tell I lack the experience there... 12:37 magnuse lulz 12:38 magnuse tcohen[m]: i think it was you who mentioned a project to create official docker images for koha? is the wip available somewhere? our tech guys are very interested in running koha with docker, and might be able to contribute at some point 12:55 tcohen[m] look at docker/koha-docker in the community gitlab 12:56 tcohen[m] I plan to publish docker images along with the usual .deb files, on the 23.11 release 12:57 tcohen[m] and then try to do hte same for the *oldstable branches 12:58 tcohen[m] wizzyrea++ 12:58 tcohen[m] wizzyrea++ 12:58 tcohen[m] wizzyrea++ 12:58 tcohen[m] bywater++ 12:58 tcohen[m] bywater++ 12:59 tcohen[m] bywater++ 12:59 tcohen[m] Lots of RAM and CPU for our git server, Joubu 13:00 tcohen[m] and her sysadmin magic to block bots, etc 13:00 Joubu great 13:04 cait did we move it? 13:05 tcohen[m] she did what she had to do 13:08 cait ah, i had confused services/hosts 13:08 cait bywater++ wizzyrea++ 13:13 Joubu 2=>4 CPUs and 8=>16G RAM, is that it? 13:14 tcohen[m] yes 13:14 tcohen[m] no 13:14 tcohen[m] 4 GB => 16 GB 13:14 tcohen[m] but the firewall/fail2ban intervention is key 13:16 Joubu fail2ban was installed IIRC 13:23 tcohen[m] yeah, but it was not catching all the things it does now 13:24 tcohen[m] can you check the (minor) PR on ktd? 13:24 Joubu if you check mine :D 13:24 tcohen[m] I can 13:24 tcohen[m] once RDA is ready 13:24 tcohen[m] :-P 13:24 caroline lol 13:27 mtreskonmuse[m] Hi, I am Matthew Treskon, Metadata Strategist for Project MUSE (platform of JHU Press for many academic university presses). I am new, generally unfamiliar with Koha. Is there interest from the Koha community in our data (holdings data via KBART, MARC records, article data in JATS)? Where would be the best place for me to ask this question? 13:33 ahmad DBD::mysql::db do failed: Unknown or incorrect time zone: 'Asia/Dhaka' at /usr/share/koha/lib/Koha/Database.pm line 117 13:34 caroline mtreskonmuse[m], I can't speak for the whole community, but I think it would fall to each individual library to determine if they want to include the records or not. You could send an email to the mailing list to say that the records are available to any who want to have them 13:35 mtreskonmuse[m] Thanks Caroline, how do I get to the mailing list? 13:35 caroline also, Koha doesn't currently support holdings unfortunately, it's something that is definitely missing, but not enough for someone to sponsor the development it seems 13:36 Joubu mtreskonmuse[m]: https://lists.katipo.co.nz/mailman/listinfo/koha 13:36 caroline mtreskonmuse[m], https://lists.katipo.co.nz/mailman/listinfo/koha 13:36 caroline oops, Jobou is faster ;) 13:38 mtreskonmuse[m] Thanks Caroline, good to know Koha is not holdings based. I can send an inquiry out to the email list but I think you right, it would be up to the library. If the library already is a customer, I imagine they are already familiar with how to get our MARC. However, I can offer MARC for our OA titles 13:38 cait there is develooment, but it lacks testing :) 13:39 cait Bug 20447 - Add support for MARC holdings records 13:39 cait we need more parties interested to make it happen I think 13:40 caroline 688 comments!! 13:40 cait lots of patches yes 13:41 Joubu ahmad: https://dev.mysql.com/doc/refman/8.0/en/mysql-tzinfo-to-sql.html 13:42 cait cya tomorrow 13:59 angelic cait: Hello cait. Yes, they said that those records were available previously. 15:51 oleonard This is interesting: https://phosphoricons.com/ 16:00 paulderscheid[m] Looks good oleonard 17:40 caroline I think someone was asking for the official openlibrary MARC code, i saw it was just added https://www.loc.gov/marc/relators/tn230808src.html 23:23 dcook @later tell caroline Yeah I asked that person to send a request to the Library of Congress to add it and they did! 23:23 huginn dcook: The operation succeeded. 23:28 dcook @later tell mtreskonmuse[m] Have you thought of adding a Z39.50 or SRU endpoint? 23:28 huginn dcook: The operation succeeded. 23:38 tuxayo dcook: hi :) IIRC you knew about some Koha instances running on old OSes. Was it CentOS 6 ? 23:39 dcook RHEL 6 but same diff 23:39 dcook tuxayo: So yup good memory heh 23:40 tuxayo Are they still updating their Koha? 23:41 dcook Yes and no haha 23:41 dcook it's an old custom version. So it'll get security updates but it doesn't get new features. 23:42 dcook At some point, they'll upgrade the OS and then they'll need a newly customized Koha 23:42 dcook What's the root of your question? Looking to have a newer Koha run on an older OS? 23:51 tuxayo dcook: I recalled this instance was an example of why we need to ensure supporting version old perl versions. I don't have a feature in mind that would require more than the current 5.14 (which is more than the 5.10 of RHEL 6 XD). 23:51 tuxayo I was just curious about what would be the bar now. Since this instance is already out of the sysreqs and is not having their Koha updated, it doesn't matter anymore. 23:51 tuxayo To keep that in mind if the question comes up. 23:52 tuxayo I think I've only seen minor stuff that would require > 5.14 23:58 dcook tuxayo: Oh yeah no. I don't think we should be supporting RHEL 6 anymore 23:58 dcook Technically, it looks like there's still "Extended Lifestyle support" for it but any real support for RHEL 6 ended years ago 23:59 dcook I probably argued the opposite in the past, but these days I think it's better to have Koha have modern requirements and that just means people need to keep up