I've never seen the sogo sources, so I'm guessing here that this and the previous sql-update scripts are not installed automatically by "make install". You probably will find them in the sources in some "doc" directory or something similar. The RPM version of sogo has those files included.
Best Regards Krzysztof Dnia 2023-05-10, o godz. 16:27:44 "Odhiambo Washington" ([email protected]) <[email protected]> napisał(a): > 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" <[email protected]> > 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" ( > > [email protected]) <[email protected]> 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 <[email protected]> > > > 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" > > > > ([email protected]) 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] > > > > -- Krzysiek
