I am running 5.8.0 on FreeBSD and unless I logout, my session stays logged in.
On my Ubuntu server, I run 5.5.1 with same table and no problem. Is this an issue with installation from source then? I don't have this file - sql-update-5.5.1_to_5.6.0.sh - in my system. On Wed, May 10, 2023 at 3:33 PM "Krzysztof Mrozowicz" <users@sogo.nu> wrote: > Once I applied the proposed solution, I asked myself a similar question > and I found that there is a script provided with sogo, called > sql-update-5.5.1_to_5.6.0.sh which contains the following: > > echo "Converting c_value from VARCHAR(255) to VARCHAR(4096) in > sessions table ($sessiontable)" > mysql -v $mysqlargs -e "ALTER TABLE $sessiontable MODIFY c_value > VARCHAR(4096);" > > I already changed it to "text" and it works, but maybe VARCHAR(4096) also > does the job? > > Best Regards > Krzysztof > > W dniu: Środa, Maj 10, 2023 09:40 IST, "Odhiambo Washington" ( > odhia...@gmail.com) <users@sogo.nu> napisał(a): > > > Looking at my 5.8.0 setup, and my table: > > > > SQL> show create table sogo_sessions_folder: > > > > sogo_sessions_folder | CREATE TABLE `sogo_sessions_folder` ( > > `c_id` varchar(255) NOT NULL, > > `c_value` varchar(255) NOT NULL, > > `c_creationdate` int(11) NOT NULL, > > `c_lastseen` int(11) NOT NULL, > > PRIMARY KEY (`c_id`) > > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 > > > > So I want to ask: Is the change of c_value type from varchar to text > > documented in some ChangeLog that I missed? > > And how does it affect the logged in session expiry? > > > > > > On Tue, May 9, 2023 at 9:13 PM Yaisel Cruz Zuñiga <users@sogo.nu> wrote: > > > > > Hi, > > > > > > 1. The MySQL database. Change the column type of c_value: > > > mysql -u root > > > use sogo; > > > alter table sogo_sessions_folder modify column c_value text; > > > > > > El 9/5/23 a las 6:33, "Krzysztof Mrozowicz" (krzysz...@mrozowicz.eu) > > > escribió: > > > > Hi, > > > > a few months ago I noticed that I get auto logged out from the SOGo > web > > > interface after around 1-2 minutes. Earlier I had to logout manually > and > > > the session was open for days (as far as I remember). Has something > change > > > in SOGo? Is there a way to restore the previous behavior? > > > > > > > > Regards > > > > Krzysztof > > > > ________________________________ > > > ________________________________ > > > > > > Universidad de Cienfuegos “Carlos Rafael Rodríguez” > > > #MiCasaUCf #EvaluaciónInstitucional2023 > > > #InspiramosLaExcelenciaEnElSaber<https://www.ucf.edu.cu/?p=12413> > > > > > > > > > -- > > Best regards, > > Odhiambo WASHINGTON, > > Nairobi,KE > > +254 7 3200 0004/+254 7 2274 3223 > > "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) > > [How to ask smart questions: > > http://www.catb.org/~esr/faqs/smart-questions.html] > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
