How about you wipe clean everything to do with SOGo and install it cleanly? Also, can you please share the output of 'select * from users' (hoping your table that stores the usernames, passwords is called users). Remember to mask the sensitive details. Also the output of 'describe sogo_auth_view' or whatever you called it. If it's working on mine, I suppose it should work on yours. PS: Sorry, I couldn't look over the whole thread again for the above details. It's already 36 thread elements.
On Tue, Jan 20, 2026 at 12:39 PM "Oli Z." <[email protected]> wrote: > So the error is something else that is going wrong. Because there is no > error in the log, except the error deep in the application that leads to > the http 500, after i logged in successfuly. I hope someone from Alinto > can take a look at that. > > Am 19.01.26 um 14:01 schrieb Washington Odhiambo ([email protected]): > > For all the required fields, you'll see an error in sogo.log if they > > are missing. > > > > On Mon, Jan 19, 2026 at 3:44 PM "Oli Z." <[email protected]> wrote: > > > > Hi, unfortunately that email went into my spam folder because of that > > tinyurl link. Thats interesting, so it can not be the objective-c > > library anymore. > > > > My view has c_uid, c_name, c_cn, mail and c_password. Are the other > > fields _required_ or are they optional? Because the documentation > > only > > states those i have as required. > > > > Am 16.01.26 um 17:46 schrieb Washington Odhiambo ([email protected] > ): > > > Hi Oli, > > > > > > I installed Postfixadmin and decided to authenticate against it > > while > > > also using it for SOGo to store its tables. > > > > > > I have put the configs (sogo.conf, sogo-nginx.conf) and the > > sogo.log here: > > > https://tinyurl.com/9pdnkcwr > > > > > > Under that path, you will also find a folder called "Screenshots" > > > where you'll see proof that it is truly working. Nothing stops you > > > from pointing your SOGoUserSources to your MySQL database, IMHO, as > > > long as you create the VIEW there. > > > > > > Best regards, > > > > > > PS: The files will be deleted after a few days. > > > > > > > > > > > > On Tue, Jan 13, 2026 at 10:57 AM "Oli Z." <[email protected]> wrote: > > > > > > I also do not use the package from Alinto, i have no > > subscription, > > > i use > > > the official debian packages. Have you been able to > authenticate > > > against > > > that? Can you share the log after successfull authentication? > > > > > > Am 06.01.26 um 14:04 schrieb Washington Odhiambo > > ([email protected]): > > > > Please remember, I was responding to Quentin's question about > > > "Debian > > > > repo directly -> https://packages.debian.org/trixie/sogo"; > > > > This package is not from Alinto, as he stated. > > > > So in my case I suppose he doesn't need the debug info, > > which I > > > > believe he only needed for the SOGo packaged by Alinto. > > > > > > > > root@debianPC:/home/wash/public_html# cat > > /etc/apt/sources.list > > > > deb http://ftp.us.debian.org/debian trixie main > > > > > > > > The details you asked for are below: > > > > > > > > root@debianPC:/home/wash# uname -a > > > > Linux debianPC.wash.lan 6.12.57+deb13-amd64 #1 SMP > > PREEMPT_DYNAMIC > > > > Debian 6.12.57-1 (2025-11-05) x86_64 GNU/Linux > > > > > > > > root@debianPC:/home/wash# cat /etc/os-release > > > > PRETTY_NAME="Debian GNU/Linux 13 (trixie)" > > > > NAME="Debian GNU/Linux" > > > > VERSION_ID="13" > > > > VERSION="13 (trixie)" > > > > VERSION_CODENAME=trixie > > > > DEBIAN_VERSION_FULL=13.2 > > > > ID=debian > > > > HOME_URL="https://www.debian.org/"; > > > > SUPPORT_URL="https://www.debian.org/support"; > > > > BUG_REPORT_URL="https://bugs.debian.org/"; > > > > > > > > root@debianPC:/home/wash# cat /etc/debian_version > > > > 13.2 > > > > > > > > root@debianPC:/home/wash# dpkg -l | grep -i sogo > > > > ii sogo 5.12.1-3 > > > > amd64 Scalable groupware > > server > > > > ii sogo-activesync 5.12.1-3 > > > > amd64 Scalable groupware > > server - > > > > ActiveSync module > > > > ii sogo-common 5.12.1-3 > > > > all Scalable groupware > > server - > > > > common files > > > > > > > > root@debianPC:/home/wash# systemctl status sogo > > > > ● sogo.service - SOGo is a groupware server > > > > Loaded: loaded (/usr/lib/systemd/system/sogo.service; > > enabled; > > > > preset: enabled) > > > > Active: active (running) since Tue 2026-01-06 > > 12:44:26 EAT; 2h > > > > 58min ago > > > > Invocation: b45caa89337948bda6b8450b3087dfed > > > > Docs: > > https://sogo.nu/files/docs/SOGoInstallationGuide.html > > > > Process: 1270846 ExecStart=/usr/sbin/sogod > -WOWorkersCount > > > > ${PREFORK} -WOPidFile /run/sogo/sogo.pid -WOLogFile > > > > /var/log/sogo/sogo.log (code=exited, status=0/SUCCESS) > > > > Main PID: 1270856 (sogod) > > > > Tasks: 4 (limit: 4460) > > > > Memory: 53M (peak: 55M) > > > > CPU: 11.297s > > > > CGroup: /system.slice/sogo.service > > > > ├─1270856 /usr/sbin/sogod -WOWorkersCount 3 > > -WOPidFile > > > > /run/sogo/sogo.pid -WOLogFile /var/log/sogo/sogo.log > > > > ├─1270858 /usr/sbin/sogod -WOWorkersCount 3 > > -WOPidFile > > > > /run/sogo/sogo.pid -WOLogFile /var/log/sogo/sogo.log > > > > ├─1270859 /usr/sbin/sogod -WOWorkersCount 3 > > -WOPidFile > > > > /run/sogo/sogo.pid -WOLogFile /var/log/sogo/sogo.log > > > > └─1270860 /usr/sbin/sogod -WOWorkersCount 3 > > -WOPidFile > > > > /run/sogo/sogo.pid -WOLogFile /var/log/sogo/sogo.log > > > > > > > > Jan 06 12:44:26 debianPC.wash.lan systemd[1]: Starting > > > sogo.service - > > > > SOGo is a groupware server... > > > > Jan 06 12:44:26 debianPC.wash.lan systemd[1]: Started > > > sogo.service - > > > > SOGo is a groupware server. > > > > root@debianPC:/home/wash# > > > > > > > > root@debianPC:/home/wash/public_html# systemctl stop sogo > > > > root@debianPC:/home/wash/public_html# cp /dev/null > > > /var/log/sogo/sogo.log > > > > root@debianPC:/home/wash/public_html# systemctl start sogo > > > > root@debianPC:/home/wash/public_html# less > > /var/log/sogo/sogo.log > > > > Jan 06 16:01:17 sogod [1358483]: version 5.12.1 -- starting > > > > Jan 06 16:01:17 sogod [1358483]: vmem size check enabled: > > shutting > > > > down app when vmem > 4096 MB. Currently at 94 MB > > > > *Jan 06 16:01:17 sogod [1358483]: > > > > <0x0x556965133650[SOGoProductLoader]> SOGo products loaded > > from > > > > '/usr/lib/x86_64-linux-gnu/GNUstep/SOGo':* > > > > Jan 06 16:01:17 sogod [1358483]: > > > <0x0x556965133650[SOGoProductLoader]> > > > > MailPartViewers.SOGo, PreferencesUI.SOGo, CommonUI.SOGo, > > > > AdministrationUI.SOGo, MailerUI.SOGo, SchedulerUI.SOGo, > > > > ActiveSync.SOGo, Contacts.SOGo, MainUI.SOGo, ContactsUI.SOGo, > > > > Mailer.SOGo, Appointments.SOGo > > > > Jan 06 16:01:17 sogod [1358483]: All products loaded - > current > > > memory > > > > usage at 102 MB > > > > Jan 06 16:01:17 sogod [1358483]: > > <0x0x556965156c90[WOWatchDog]> > > > > listening on 127.0.0.1:20000 <http://127.0.0.1:20000> > > <http://127.0.0.1:20000> > > > <http://127.0.0.1:20000> > > > > Jan 06 16:01:17 sogod [1358483]: > > <0x0x556965156c90[WOWatchDog]> > > > > watchdog process pid: 1358483 > > > > Jan 06 16:01:17 sogod [1358483]: > > > <0x0x7fb5de2b20e0[WOWatchDogChild]> > > > > watchdog request timeout set to 10 minutes > > > > Jan 06 16:01:17 sogod [1358483]: > > <0x0x556965156c90[WOWatchDog]> > > > > preparing 3 children > > > > Jan 06 16:01:17 sogod [1358483]: > > <0x0x556965156c90[WOWatchDog]> > > > child > > > > spawned with pid 1358484 > > > > Jan 06 16:01:17 sogod [1358483]: > > <0x0x556965156c90[WOWatchDog]> > > > child > > > > spawned with pid 1358485 > > > > Jan 06 16:01:17 sogod [1358483]: > > <0x0x556965156c90[WOWatchDog]> > > > child > > > > spawned with pid 1358486 > > > > Jan 06 16:01:22 sogod [1358485]: > > <0x0x5569651934a0[WOHttpAdaptor]> > > > > notified the watchdog that we are ready > > > > Jan 06 16:01:22 sogod [1358486]: > > <0x0x5569651934a0[WOHttpAdaptor]> > > > > notified the watchdog that we are ready > > > > Jan 06 16:01:23 sogod [1358484]: > > <0x0x5569651934a0[WOHttpAdaptor]> > > > > notified the watchdog that we are ready > > > > /var/log/sogo/sogo.log > > > > > > > > > > > > I am using the same. With MySQL for authentication and > > > PostgreSQL for > > > > SOGo stuff storage. > > > > I am using Nginx, not Apache. My Nginx.conf: > > > > https://paste.ubuntu.com/p/fDrZtX5FQ5/ > > > > My sogo.conf: I already shared it - > > > > > > > > > > > > On Tue, Jan 6, 2026 at 3:36 PM "Oli Z." <[email protected]> > wrote: > > > > > > > > Could you add those debug flags, run it and then send > > them to > > > > Quentin? > > > > IMO this should not be possible that it runs for you > > when its a > > > > problem > > > > in the ObjectiveC-Library. Can you tell me what you > > exactly did? > > > > How did > > > > you install SOGo? > > > > > > > > Please provide: > > > > uname -a > > > > dpkg -l | grep -i sogo > > > > your apache2 config > > > > your sogo config > > > > > > > > Thanks! > > > > > > > > Am 06.01.26 um 10:56 schrieb Washington Odhiambo > > > ([email protected]): > > > > > I tested it on a Debian Trixie VM and it's working > > fine - > > > so far. > > > > > > > > > > > > > > > > > > > > On Mon, Jan 5, 2026 at 6:32 PM qhivert > > <[email protected]> wrote: > > > > > > > > > > Hello, > > > > > > > > > > After some exchange with Oli and new logs files, > > it seems > > > > there is > > > > > a problem > > > > > with a method defined by the gnustep objective-c > > > library. I know > > > > > there has > > > > > been some changes with Gnustep/objective-c in > > Debian 13. > > > > > > > > > > Alinto doesn't provide a Sogo package for Debian 13 > > > yet but > > > > there > > > > > is one in > > > > > Debian repo directly -> > > > https://packages.debian.org/trixie/sogo > > > > > > > > > > Has anyone use it successfully ? > > > > > > > > > > Cheers, > > > > > -- > > > > > Quentin Hivert || Alinto || R&D Lead Developer > > > > > 19 Quai Perrache 69002 Lyon > > > > > www.alinto.com <http://www.alinto.com> > > <http://www.alinto.com> > > > <http://www.alinto.com> <http://www.alinto.com> > > > > > > > > > > -----Original Message----- > > > > > From: [email protected] > > <[email protected]> On > > > Behalf Of > > > > > qhivert > > > > > Sent: lundi 5 janvier 2026 14:41 > > > > > To: [email protected] > > > > > Subject: RE: [SOGo] Debian 13 / SOGo / 500 error > > > > > > > > > > Well, no errors in your log, I've tested your > > > sogo.conf and it > > > > > works well... > > > > > > > > > > Either there is something very obvious that I don't > > > see, or you > > > > > found a very > > > > > peculiar bug. > > > > > > > > > > Put that in your sogo.conf and reproduce the > > problem. > > > > > > > > > > SoObjectRequestHandlerDebugEnabled = YES; > > > > > SoSelectorInvocationDebugEnabled = YES; > > > > > SoDebugRequestClassification = YES; > > > > > SoDebugObjectTraversal = YES; > > > > > SOGoDebugRequests = YES; > > > > > ImapDebugEnabled = YES; > > > > > ImapLogEnabled = YES; > > > > > MySQL4DebugEnabled = YES; > > > > > SOGoUIxDebugEnabled = YES; > > > > > SoObjectMethodDispatcherDebugEnabled = YES; > > > > > SoPageInvocationDebugEnabled = YES; > > > > > SoRendererDebugEnabled = YES; > > > > > WOLogComponents = YES; > > > > > WODebugComponentLookup = YES; > > > > > WODebugResourceLookup = YES; > > > > > SoProductResourceManagerDebugEnabled = YES; > > > > > WOResourceURLAssociationDebugEnabled = YES; > > > > > WEResourceManagerDebugEnabled = YES; > > > > > NGLogDefaultLogLevel = "ALL"; > > > > > > > > > > Then send me the log directly (not here) in an > > attachment > > > > file please. > > > > > > > > > > Regards, > > > > > -- > > > > > Quentin Hivert || Alinto || R&D Lead Developer > > > > > 19 Quai Perrache 69002 Lyon > > > > > www.alinto.com <http://www.alinto.com> > > <http://www.alinto.com> > > > <http://www.alinto.com> <http://www.alinto.com> > > > > > > > > > > -----Original Message----- > > > > > From: [email protected] > > <[email protected]> On > > > Behalf Of > > > > > "Oli Z." > > > > > Sent: lundi 5 janvier 2026 12:37 > > > > > To: [email protected] > > > > > Subject: Re: [SOGo] Debian 13 / SOGo / 500 error > > > > > > > > > > update: it added now that table (empty) after > > setting > > > > > SOGoEnableEMailAlarms > > > > > to YES, but still the same error. > > > > > > > > > > Am 05.01.26 um 12:17 schrieb "Oli Z." > > ([email protected]): > > > > > > Thanks, that sounds reasonable, but the > > > documentation says > > > > this is > > > > > > only required if SOGoEnableEMailAlarms is set. > > I did not > > > > set this > > > > > > flag. I added now: > > > > > > OCSEMailAlarmsFolderURL = > > > > > > > > "mysql://xx:xxx@localhost/sogo/sogo_alarms_folder"; > > > - and: > > > > > > OCSAdminURL = > > > "mysql://xx:xxx@localhost/sogo/sogo_admin"; > > > > > > > > > > > > Because i also found an error because of missing > > > OCSAdminURL. > > > > > > Unfortunately, the error still exists. It > > added now the > > > > sogo_admin > > > > > > table but not the sogo_alarms_folder > > > > > > > > > > > > Am 05.01.26 um 10:35 schrieb qhivert > > > ([email protected]): > > > > > >> Hello, > > > > > >> I think the table for alarm is missing in > > this case: > > > > > >> OCSEMailAlarmsFolderURL > > > > > >> > > > > > > > > > > > > > > > > > > > > -- > > > > > Best regards, > > > > > Odhiambo WASHINGTON, > > > > > Nairobi,KE > > > > > +254 7 3200 0004/+254 7 2274 3223 > > > > > In an Internet failure case, the #1 suspect is a > > > constant: DNS. > > > > > "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 > > > > In an Internet failure case, the #1 suspect is a > > constant: DNS. > > > > "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 > > > In an Internet failure case, the #1 suspect is a constant: DNS. > > > "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 > > In an Internet failure case, the #1 suspect is a constant: DNS. > > "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 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
