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
