Hello;
I have been playing around with SOGo and like it very much. I originally set my
installation up using LDAP authentication, and had things working just right,
even Cal/Card DAV sync with our Macs and iPhones...
Well, I want to be able to handle multiple domains, and figured that sql auth
would be much easier to administer (since I couldn't figure out how to add the
second domain to my LDAP server). I created a postgresql database and view for
authentication of my first domain with the following fields:
Field name Type Array? Allow nulls?
c_uid varchar(20) No No
c_name varchar(20) No Yes
c_password varchar(20) No Yes
c_cn varchar(50) No Yes
mail varchar(100) No Yes
I can authenticate into SOGo with any of the three users defined in the
database, calendar data and contact data is still there, but in the mail
section the IMAP account has been set to localhost (not editable) instead of
the SOGoIMAPServer defined in the defaults file. What have I done wrong in my
UserSources??
My defaults config:
{
NSGlobalDomain = {
};
sogod = {
SOGoProfileURL =
"postgresql://sogo:s...@localhost:5432/sogo/sogo_user_profile";
OCSFolderInfoURL =
"postgresql://sogo:s...@localhost:5432/sogo/sogo_folder_info";
SOGoACLsSendEMailNotifications = YES;
WOWorkersCount = 3;
SOGoMailingMechanism = smtp;
SOGoSMTPServer = box1.qzoneinc.net;
SOGoMailAuxiliaryUserAccountsEnabled = YES;
domains = {
qzoneinc.com = {
SOGoMailDomain = qzoneinc.com;
SOGoFoldersSendEMailNotifications = YES;
SOGoAppointmentSendEMailNotifications = YES;
SOGoSentFolderName = Sent;
SOGoTrashFolderName = Trash;
SOGoDraftsFolderName = Drafts;
SOGoIMAPServer = imaps://box1.qzoneinc.net:993;
SOGoLanguage = English;
SOGoTimeZone = America/Chicago;
SOGoUserSources = (
{
type = sql;
id = directory;
viewURL =
"postgresql://sogo:[email protected]:5432/qz_auth/qz_view";
canAuthenticate = YES;
isAddressbook = NO;
userPasswordAlgorithm = none;
}
);
};
};
};
}--
[email protected]
https://inverse.ca/sogo/lists
