On Tue, Dec 23, 2025 at 6:37 PM "Oli Z." <[email protected]> wrote:
> I created the view as described in the documentation, thats what is in use: > > viewURL = "mysql://xxx:[email protected]:3306/postfixadmin/sogo_mailbox"; > > But Sogo still requires a DB, to store data, e.g. calendar information. > And i prefer postgre, thats why i have: > SOGoProfileURL = "postgresql://[email protected]:5433/sogo/sogo_user_profile"; > OCSFolderInfoURL = "postgresql://[email protected]:5433/sogo/sogo_folder_info > "; > OCSSessionsFolderURL = > "postgresql://[email protected]:5433/sogo/sogo_sessions_folder"; > OCSEMailAlarmsFolderURL = > "postgresql://[email protected]:5433/sogo/sogo_alarms_folder"; > OCSAdminURL = "postgresql://[email protected]:5433/sogo/sogo_admin"; > > As mentioned, the sql auth works like a charm, but SOGo somehow fails > _after_ authentication. From the log, i assume it should load some sort > of calendar information or so. > > I can paste the full config if required. > Do you have the following in sogo.conf: SOGoUserSources = ( { type = sql; id = directory; viewURL = "mysql://xxx:[email protected]:3306/postfixadmin/sogo_mailbox "; canAuthenticate = YES; isAddressBook = YES; listRequiresDot = NO; userPasswordAlgorithm = sha512-crypt; <================= Change this!! } ); I have never used a mixed DB setup where some stuff is in MySQL while others are in PostGreSQL. -- 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]
