Send Koha-devel mailing list submissions to
    koha-devel@lists.koha-community.org

To subscribe or unsubscribe via the World Wide Web, visit
    https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
or, via email, send a message with subject or body 'help' to
    koha-devel-request@lists.koha-community.org

You can reach the person managing the list at
    koha-devel-owner@lists.koha-community.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha-devel digest..."


Today's Topics:

1. Re: Immediate logout in Koha 21.05.02 (03?)
(dcook@prosentient.com.au)
2. Re: Immediate logout in Koha 21.05.02 (03?) (Michael Kuhn)
3. Re: Immediate logout in Koha 21.05.02 (03?) (Katrin Fischer)


----------------------------------------------------------------------

Message: 1
Date: Mon, 6 Sep 2021 09:42:55 +1000
From: <dcook@prosentient.com.au>
To: "'Michael Kuhn'" <mik@adminkuhn.ch>, "'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?)
Message-ID: <0fbb01d7a2af$c063c720$412b5560$@prosentient.com.au>
Content-Type: text/plain;    charset="utf-8"

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/




------------------------------

Message: 2
Date: Mon, 6 Sep 2021 09:26:15 +0200
From: Michael Kuhn <mik@adminkuhn.ch>
To: dcook@prosentient.com.au
Cc: 'Koha-devel' <koha-devel@lists.koha-community.org>, "'Michael
    Hafen (TECH)'" <michael.hafen@washk12.org>
Subject: Re: [Koha-devel] Immediate logout in Koha 21.05.02 (03?)
Message-ID: <c91adabb-ca33-101a-ee84-60ade77b3b14@adminkuhn.ch>
Content-Type: text/plain; charset=utf-8; format=flowed

Hi David

> 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.

Both base URL preferences are empty. HTTPS is not in use at the moment.

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 · W www.adminkuhn.ch


------------------------------

Message: 3
Date: Mon, 6 Sep 2021 10:56:13 +0200
From: Katrin Fischer <katrin.fischer.83@web.de>
To: koha-devel@lists.koha-community.org
Subject: Re: [Koha-devel] Immediate logout in Koha 21.05.02 (03?)
Message-ID: <f4791138-0939-0c73-50b6-4d33ac8bec5b@web.de>
Content-Type: text/plain; charset=utf-8; format=flowed

Hi Michael,

have you tried if setting them makes a difference?

Another pref that comes to mind is "timeout".

Hope this helps,

Katrin

On 06.09.21 09:26, Michael Kuhn wrote:
> Hi David
>
> > 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.
>
> Both base URL preferences are empty. HTTPS is not in use at the moment.
>
> Best wishes: Michael


------------------------------

Subject: Digest Footer

_______________________________________________
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/


------------------------------

End of Koha-devel Digest, Vol 190, Issue 6
******************************************