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]
