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
