Hello, are you sure you sogo.conf didn't change? SOGo storage has 2 modes: single-store: One table quiack_appointment/contact for everyone → Trigger by having this in your sogo.conf OCSCacheFolderURL = "mysql://sogobuild:pwd@mariadb:3306/sogo/sogo_cache_folder"; OCSStoreURL = "mysql://sogobuild:pwd@mariadb:3306/sogo/sogo_store"; OCSAclURL = "mysql://sogobuild:pwd@mariadb:3306/sogo/sogo_acl";
Without those settings, it's the legacy mode where each user has their own quick_appointment/contact table. If you were in legacy mode, comments the parameters above. User should see their old events back. Regards, -- Quentin Hivert Lead Dev R&D [email protected] Alinto 19, quai Perrache FR-69002 Lyon https://www.alinto.com Linkedin FR Le Mardi, Juin 16, 2026 15:02 CEST, "Holger Biber" ([email protected]) <[email protected]> a écrit: Hi, I've tried to add several appointments as different users in different calendars. All appointsments are stored in table "sogo_quick_appointment". SELECT * FROM `sogo_quick_appointment` c_folder_id c_name c_uid c_startdate c_enddate c_cycleenddate c_title 412 2CB319-6A311234-1-ABCD50C0.ics 2CB319-6A311234-1-ABCD50C0 1781931600 1781964000 NULL TestTitle_1 465 be35207b-58df-4711-0815-4ce2269f49a5.ics be35207b-58df-4711-0815-4ce2269f49a5 1781773200 1781776800 NULL TestTitle_2 .... Why not to "old" tables with usernames? And possible how to "move" all old appointments to this new table? bye und thanks Holger Am 16.06.2026 um 13:24 schrieb Holger Biber: > Hi, > > after an (nightly) update to SOGo Version 5.12.9 all of my > users didn't see any appointment in their calendars. > The calendars themselves are shown in SOGo-WebUI und e.g. in > Thunderbird. > Calendar-URLs are still the same. > > My system: Ubuntu 24.04, Plesk, dovecot, mysqld 8.0.46 > Some month ago, before upgrading to 24.04. I've tried to install SOGo to > use with Plesk, but I wasn't satisfied with this. > I think from this time, I've two databases: "sogo" an "sogo_12345678" > in my > mysql. > In this second DB I found just these tables: > sogo_acl, sogo_admin, sogo_cache_folder, sogo_folder_info, > sogo_quick_appointment, sogo_quick_contact, sogo_sessions_folder, > sogo_store, sogo_users_view, sogo_user_profile > but no user (user-)tables. > > Today adding a new appointment to my personale calendar I saw that > this wasn't > added to a table with my name (e.g. "sogoMYUSER00112233") like all older > appointments. > I found this new appointment (the title of the appointment) in > database "sogo" > in table "sogo_quick_appointment" with a crypted > c_name ("be35207b-58df-4776-8b81-4ce226da1233.ics") and c_uid > ("be35207b-58df-4776-8b81-4ce226da1233"). > And also in table " sogo_store" with same crypted "c_name". > > Please point me to a solution for my problem, because my users aren't > laughing :( > > Bye and thanks > Holger > > This is my sogo.conf: > { > SOGoLanguage = German; > SOGoTimeZon***=""; > SOGoTimeFormat = "%H:%M"; > SOGoFirstDayOfWeek = 1; > SOGoMailMessageCheck = manually; > SOGoMailAuxiliaryUserAccountsEnabled = YES; > SOGoMemcachedHost = "127.0.0.1"; > SOGoRefreshViewCheck = every_5_minutes; > > WOWorkersCount = 50; > SOGoMaximumMessageSizeLimit = 100240; > SxVMemLimit = 512; > > SOGoAppointmentSendEMailNotification***="" />> > SOGoPasswordChangeEnabled = NO; > > // DB generated by Plesk-installation ? > // SOGoProfileURL = > "mysql://sogoadmin:ADMINPW@localhost:3306/sogo_12345678/sogo_user_profile"; > > SOGoProfileURL = > "mysql://sogoadmin:ADMINPW@localhost:3306/sogo/sogo_user_profile"; > OCSFolderInfoURL = > "mysql://sogoadmin:ADMINPW@localhost:3306/sogo/sogo_folder_info"; > > OCSSession***="" />> > "mysql://sogoadmin:ADMINPW@localhost:3306/sogo/sogo_sessions_folder"; > OCSEMailAlarmsFolderURL = > "mysql://sogoadmin:ADMINPW@localhost:3306/sogo/sogo_alarms_folder"; > OCSStoreURL = > "mysql://sogoadmin:ADMINPW@localhost:3306/sogo/sogo_store"; > OCSAclURL = "mysql://sogoadmin:ADMINPW@localhost:3306/sogo/sogo_acl"; > OCSCacheFolderURL = > "mysql://sogoadmin:ADMINPW@localhost:3306/sogo/sogo_cache_folder"; > > OCSAdminURL = > "mysql://sogoadmin:[email protected]:3306/sogo/sogo_admin"; > > SOGoUserSources = > ( > { > type = sql; > id = directory; > viewURL = > "mysql://sogoadmin:ADMINPW@localhost:3306/sogo/sogo_auth"; > > canAuthenticate = YES; > isAddressBook = YES; > userPasswordAlgorithm = md5; > displayName = "MYNAME"; > } > ); > > SOGoMailingMechanism = smtp; > SOGoSMTPServer = > "smtp://localhost:25/?tls=YES&tlsVerifyMode=allowInsecureLocalhost"; > SOGoSMTPAuthentication***="" />> > SOGoSentFolderName = "INBOX/Sent"; > SOGoTrashFolderName = "INBOX/Trash"; > SOGoDraftsFolderName = "INBOX/Drafts"; > SOGoJunkFolderName = "INBOX/Spam"; > SOGoIMAPServer = > "imaps://localhost:143/?tls=YES&tlsVerifyMode=allowInsecureLocalhost"; > SOGoIMAPAclCon***="" />> SOGoMailCustomFromEnabled = YES; > SOGoAppointmentSendEMailNotification***="" />> > SOGoSieveServer = > "sieve://localhost:4190/?tls=YES&tlsVerifyMode=allowInsecureLocalhost"; > SOGoForwardEnabled = YES; > SOGoVacation***="" />> SOGoSieveScriptsEnabled = YES; > > SOGoCalendarDefaultRoles = ( > PublicDAndTViewer, > ConfidentialDAndTViewer, > PrivateDAndTViewer > ); > SOGoDayEndTime = "18:00"; > SOGoDayStartTime = "07:00"; > SOGoFirstWeekOfYear = January1; > SOGoLoginModule = Mail; > SOGoMailComposeMessageType = text; > > SOGoMailDomain = "MYDOMAIN.de"; > SOGoForceExternalLoginWithEmail = YES; > > SOGoMailSignaturePlacement = below; > SOGoMailReplyPlacement = above; > } > > > -- ______________________________ AUGUST-GRIESE-BERUFSKOLLEG Holger Biber Bereichsleiter - Berufliches Gymnasium - - Informationstechnik - IT-Koordinator Jahnstraße 54-68 32584 Löhne Tel.: 05732 1084-0 Fax: 05732 1084-10 www.agb-loehne.de
