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. That kind of sounds like what is going on. David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 -----Original Message----- From: Koha-devel <koha-devel-bounces@lists.koha-community.org> On Behalf Of Michael Kuhn Sent: Saturday, 4 September 2021 7:59 PM To: Michael Hafen (TECH) <michael.hafen@washk12.org> Cc: Koha-devel <koha-devel@lists.koha-community.org> Subject: Re: [Koha-devel] Immediate logout in Koha 21.05.02 (03?) Hi Michael You wrote:
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. 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]/) If it's "mysql", then you should be able to delete everything from the > session table.
That's something to try anyway.
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.
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.
This didn't change anything. However, the login process was somewhat complicated (but originally did work). I had to open an SSH tunnel as follows: ssh -p 33 -t root@host1 ssh -C -g -L 10080:kohahost:80 -L 18080:kohahost:8080 -J root@host2 koha@kohahost Like this access via http://host1:8080 was possible (but was looging me out after every click on a link as described). 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. Best wishes & thanks for your hints: Michael -- 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
On Thu, Sep 2, 2021 at 7:22 AM Michael Kuhn <mik@adminkuhn.ch <mailto:mik@adminkuhn.ch>> wrote:
Hi
As written on this list on 26 August I tried to install Koha 21.05.03 but after the installation Koha said the installed version was "21.05.02.003". Jonathan Druart wrote this comes from
commit 8ea80995c590dad86c43df636456640d3aa84bab Increment version for 21.05.03 release
-$VERSION = "21.05.02.002"; +$VERSION = "21.05.02.003";
Today I updated a Koha 18.11.05 database into this Koha 21.05.02.003 installation. After restarting memcached I executed "sudo koha-upgrade-schema instancename" - the output looked OK and ended with the following lines:
Upgrade to 21.05.02.000 done [12:15:20]: Koha 21.05.02 release Upgrade to 21.05.02.001 done [12:15:20]: Bug 28567 - Set to NULL empty branches fields Upgrade to 21.05.02.002 done [12:15:20]: Bug 28813 - Update delivery_note to failure_code in message_queue Upgrade to 21.05.02.003 done [12:15:20]: Bug 28872 - Update syspref values from on and off to 1 and 0
It seems even if I installed Koha 21.05.03 it only upgraded to Koha 21.05.02.
I don't know if there is any connection but whatever, I was able to open the staff client and to login - but as soon as I click on any link I'm logged out immediately. I am able to login again and then advance to the next link but then I'm logged out again etc ad infinitum. It is not possible to change any system preference (internal server error) or search for any users.
File "plack-error.log" sometimes tells me, without a timestamp:
new(): failed: query object HASH(0x555f47cfad30) does not support cookie() and param() methods: Can't call method "cookie" on unblessed reference at /usr/share/perl5/CGI/Session.pm line 707.
File "plack-intranet-error.log" says:
[2021/09/02 13:33:36] [WARN] Odd number of elements in anonymous hash at /usr/share/koha/intranet/cgi-bin/catalogue/search.pl <http://search.pl> line 577.
Can anyone please give me a hint how to solve this problem?
Best wishes: Michael -- 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 <mailto:mik@adminkuhn.ch> · W www.adminkuhn.ch <http://www.adminkuhn.ch> _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org <mailto:Koha-devel@lists.koha-community.org> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel <https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel> website : https://www.koha-community.org/ <https://www.koha-community.org/> git : https://git.koha-community.org/ <https://git.koha-community.org/> bugs : https://bugs.koha-community.org/ <https://bugs.koha-community.org/>
-- Michael Hafen Washington County School District Technology Department Systems Analyst
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/