Is there no one out there authenticating with postgresql? Multiple domains?
Begin forwarded message: > From: Jeff Folk <[email protected]> > Date: November 10, 2010 3:35:22 PM CST > To: [email protected] > Subject: sql auth and IMAP hostname > > 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
