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;
SOGoTimeZone = "Europe/Berlin";
SOGoTimeFormat = "%H:%M";
SOGoFirstDayOfWeek = 1;
SOGoMailMessageCheck = manually;
SOGoMailAuxiliaryUserAccountsEnabled = YES;
SOGoMemcachedHost = "127.0.0.1";
SOGoRefreshViewCheck = every_5_minutes;
WOWorkersCount = 50;
SOGoMaximumMessageSizeLimit = 100240;
SxVMemLimit = 512;
SOGoAppointmentSendEMailNotifications = Yes;
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";
OCSSessionsFolderURL =
"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";
SOGoSMTPAuthenticationType = PLAIN;
SOGoSentFolderName = "INBOX/Sent";
SOGoTrashFolderName = "INBOX/Trash";
SOGoDraftsFolderName = "INBOX/Drafts";
SOGoJunkFolderName = "INBOX/Spam";
SOGoIMAPServer =
"imaps://localhost:143/?tls=YES&tlsVerifyMode=allowInsecureLocalhost";
SOGoIMAPAclConformsToIMAPExt = NO;
SOGoMailCustomFromEnabled = YES;
SOGoAppointmentSendEMailNotifications = YES;
SOGoSieveServer =
"sieve://localhost:4190/?tls=YES&tlsVerifyMode=allowInsecureLocalhost";
SOGoForwardEnabled = YES;
SOGoVacationEnabled = YES;
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
