<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body>A new request with request id 16045 has been created by koha-devel-request@lists.koha-community.org. Short info on the request is : <br><br>Title : Koha-devel Digest, Vol 190, Issue 6<br>Category : <br>Description : <div>Send Koha-devel mailing list submissions to<br> koha-devel@lists.koha-community.org<br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>or, via email, send a message with subject or body 'help' to<br> koha-devel-request@lists.koha-community.org<br><br>You can reach the person managing the list at<br> koha-devel-owner@lists.koha-community.org<br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Koha-devel digest..."<br><br><br>Today's Topics:<br><br> 1. Re: Immediate logout in Koha 21.05.02 (03?)<br> (dcook@prosentient.com.au)<br> 2. Re: Immediate logout in Koha 21.05.02 (03?) (Michael Kuhn)<br> 3. Re: Immediate logout in Koha 21.05.02 (03?) (Katrin Fischer)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Mon, 6 Sep 2021 09:42:55 +1000<br>From: <dcook@prosentient.com.au><br>To: "'Michael Kuhn'" <mik@adminkuhn.ch>, "'Michael Hafen \(TECH\)'"<br> <michael.hafen@washk12.org><br>Cc: "'Koha-devel'" <koha-devel@lists.koha-community.org><br>Subject: Re: [Koha-devel] Immediate logout in Koha 21.05.02 (03?)<br>Message-ID: <0fbb01d7a2af$c063c720$412b5560$@prosentient.com.au><br>Content-Type: text/plain; charset="utf-8"<br><br>What's your base URL system preferences? If they're HTTPS, then a Secure Cookie should be set I think, which won't be sent over a HTTP connection.<br><br>That kind of sounds like what is going on. <br><br>David Cook<br>Senior Software Engineer<br>Prosentient Systems<br>Suite 7.03<br>6a Glen St<br>Milsons Point NSW 2061<br>Australia<br><br>Office: 02 9212 0899<br>Online: 02 8005 0595<br><br>-----Original Message-----<br>From: Koha-devel <koha-devel-bounces@lists.koha-community.org> On Behalf Of Michael Kuhn<br>Sent: Saturday, 4 September 2021 7:59 PM<br>To: Michael Hafen (TECH) <michael.hafen@washk12.org><br>Cc: Koha-devel <koha-devel@lists.koha-community.org><br>Subject: Re: [Koha-devel] Immediate logout in Koha 21.05.02 (03?)<br><br>Hi Michael<br><br>You wrote:<br><br> > Seems to be a problem with the session. Do you know what the session > store sys pref (SessionStorage) is set to? If not you can get that > from the database in the systempreferences table.<br> > If it's "tmp", then I would suggest deleting all the files in the > session store directory > (/var/lib/koha/[instance]/tmp/cgisess_koha_[instance]/)<br> > If it's "mysql", then you should be able to delete everything from the > session table.<br> ><br> > That's something to try anyway.<br><br>The preference was set to "Memcached server". I have now changed that to "MySQL database" but the problem persists. However, there was no such problem as long as the Koha 21.05 database was empty - it only appears since I loaded the Koha 18.11 database and updated it to Koha 21.05.<br><br> > System Preferences can be changed in the database too, when the Staff > interface isn't working; like in this case. You will need to restart > the memcached service to flush the changed sys pref. Might need to > "koha-plack --restart [instance]" as well.<br><br>This didn't change anything.<br><br>However, the login process was somewhat complicated (but originally did work). I had to open an SSH tunnel as follows:<br><br>ssh -p 33 -t root@host1 ssh -C -g -L 10080:kohahost:80 -L<br>18080:kohahost:8080 -J root@host2 koha@kohahost<br><br>Like this access via http://host1:8080 was possible (but was looging me out after every click on a link as described).<br><br>The system administrator now opened the firewall and gave me direct access to the staff client, now access via http://kohahost:8080 is possible and it works as expected.<br><br>Best wishes & thanks for your hints: Michael<br>--<br>Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch<br><br><br><br>> On Thu, Sep 2, 2021 at 7:22 AM Michael Kuhn <mik@adminkuhn.ch <br>> <mailto:mik@adminkuhn.ch>> wrote:<br>> <br>> Hi<br>> <br>> As written on this list on 26 August I tried to install Koha 21.05.03<br>> but after the installation Koha said the installed version was<br>> "21.05.02.003". Jonathan Druart wrote this comes from<br>> <br>> commit 8ea80995c590dad86c43df636456640d3aa84bab<br>> Increment version for 21.05.03 release<br>> <br>> -$VERSION = "21.05.02.002";<br>> +$VERSION = "21.05.02.003";<br>> <br>> Today I updated a Koha 18.11.05 database into this Koha 21.05.02.003<br>> installation. After restarting memcached I executed "sudo<br>> koha-upgrade-schema instancename" - the output looked OK and ended with<br>> the following lines:<br>> <br>> Upgrade to 21.05.02.000 done [12:15:20]: Koha 21.05.02 release<br>> Upgrade to 21.05.02.001 done [12:15:20]: Bug 28567 - Set to NULL<br>> empty<br>> branches fields<br>> Upgrade to 21.05.02.002 done [12:15:20]: Bug 28813 - Update<br>> delivery_note to failure_code in message_queue<br>> Upgrade to 21.05.02.003 done [12:15:20]: Bug 28872 - Update syspref<br>> values from on and off to 1 and 0<br>> <br>> It seems even if I installed Koha 21.05.03 it only upgraded to Koha<br>> 21.05.02.<br>> <br>> I don't know if there is any connection but whatever, I was able to<br>> open<br>> the staff client and to login - but as soon as I click on any link I'm<br>> logged out immediately. I am able to login again and then advance to<br>> the<br>> next link but then I'm logged out again etc ad infinitum. It is not<br>> possible to change any system preference (internal server error) or<br>> search for any users.<br>> <br>> File "plack-error.log" sometimes tells me, without a timestamp:<br>> <br>> new(): failed: query object HASH(0x555f47cfad30) does not support<br>> cookie() and param() methods: Can't call method "cookie" on unblessed<br>> reference at /usr/share/perl5/CGI/Session.pm line 707.<br>> <br>> File "plack-intranet-error.log" says:<br>> <br>> [2021/09/02 13:33:36] [WARN] Odd number of elements in anonymous<br>> hash<br>> at /usr/share/koha/intranet/cgi-bin/catalogue/search.pl<br>> <http://search.pl> line 577.<br>> <br>> Can anyone please give me a hint how to solve this problem?<br>> <br>> Best wishes: Michael<br>> --<br>> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis<br>> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz<br>> T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch<br>> <mailto:mik@adminkuhn.ch> · W www.adminkuhn.ch <http://www.adminkuhn.ch><br>> _______________________________________________<br>> Koha-devel mailing list<br>> Koha-devel@lists.koha-community.org<br>> <mailto:Koha-devel@lists.koha-community.org><br>> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>> <https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel><br>> website : https://www.koha-community.org/<br>> <https://www.koha-community.org/><br>> git : https://git.koha-community.org/ <https://git.koha-community.org/><br>> bugs : https://bugs.koha-community.org/<br>> <https://bugs.koha-community.org/><br>> <br>> <br>> <br>> --<br>> Michael Hafen<br>> Washington County School District Technology Department Systems <br>> Analyst<br>> <br><br><br>_______________________________________________<br>Koha-devel mailing list<br>Koha-devel@lists.koha-community.org<br>https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/<br><br><br><br><br>------------------------------<br><br>Message: 2<br>Date: Mon, 6 Sep 2021 09:26:15 +0200<br>From: Michael Kuhn <mik@adminkuhn.ch><br>To: dcook@prosentient.com.au<br>Cc: 'Koha-devel' <koha-devel@lists.koha-community.org>, "'Michael<br> Hafen (TECH)'" <michael.hafen@washk12.org><br>Subject: Re: [Koha-devel] Immediate logout in Koha 21.05.02 (03?)<br>Message-ID: <c91adabb-ca33-101a-ee84-60ade77b3b14@adminkuhn.ch><br>Content-Type: text/plain; charset=utf-8; format=flowed<br><br>Hi David<br><br> > What's your base URL system preferences? If they're HTTPS, then a<br> > Secure Cookie should be set I think, which won't be sent over a HTTP<br> > connection.<br> ><br> > That kind of sounds like what is going on.<br><br>Both base URL preferences are empty. HTTPS is not in use at the moment.<br><br>Best wishes: Michael<br>-- <br>Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis<br>Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz<br>T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch<br><br><br>------------------------------<br><br>Message: 3<br>Date: Mon, 6 Sep 2021 10:56:13 +0200<br>From: Katrin Fischer <katrin.fischer.83@web.de><br>To: koha-devel@lists.koha-community.org<br>Subject: Re: [Koha-devel] Immediate logout in Koha 21.05.02 (03?)<br>Message-ID: <f4791138-0939-0c73-50b6-4d33ac8bec5b@web.de><br>Content-Type: text/plain; charset=utf-8; format=flowed<br><br>Hi Michael,<br><br>have you tried if setting them makes a difference?<br><br>Another pref that comes to mind is "timeout".<br><br>Hope this helps,<br><br>Katrin<br><br>On 06.09.21 09:26, Michael Kuhn wrote:<br>> Hi David<br>><br>> > What's your base URL system preferences? If they're HTTPS, then a<br>> > Secure Cookie should be set I think, which won't be sent over a HTTP<br>> > connection.<br>> ><br>> > That kind of sounds like what is going on.<br>><br>> Both base URL preferences are empty. HTTPS is not in use at the moment.<br>><br>> Best wishes: Michael<br><br><br>------------------------------<br><br>Subject: Digest Footer<br><br>_______________________________________________<br>Koha-devel mailing list<br>Koha-devel@lists.koha-community.org<br>https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>website : https://www.koha-community.org/<br>git : https://git.koha-community.org/<br>bugs : https://bugs.koha-community.org/<br><br><br>------------------------------<br><br>End of Koha-devel Digest, Vol 190, Issue 6<br>******************************************<br></div><br><br>NOTE: You are receiving this mail because, the Requester/Technician wanted you to get notified on this request creation.<br></body></html>