Hi folks
Did anyone manage to authenticate via MySQL backend.
I followed the documentation but gut an error message:
defaults write SOGoUserSources '({type = sql;id = directory;viewURL =
"mysql://mail:m...@localhost:3306/mail/sogo_view";canAuthenticate =
YES;isAddressBook = YES;userPasswordAlgorithm = none;})'
2010-09-14 23:18:18.450 defaults[22753] File NSDictionary.m: 628. In
-[NSDictionary initWithContentsOfFile:] Contents of file
'/home/sogo/GNUstep/Defaults/.GNUstepDefaults' does not contain a dictionary
defaults write: domain is not a dictionary!
I have no idea what is wrong with my syntax.
The view i am referring to "sogo_view" looks like:
select concat(`virtual_users`.`user`,'@',`virtual_domains`.`name`) AS
`c_uid`,concat(`virtual_users`.`user`,'@',`virtual_domains`.`name`) AS
`c_name`,`virtual_users`.`password` AS
`c_password`,concat(`virtual_users`.`sn`,'
',`virtual_users`.`givenName`) AS
`c_cn`,concat(`virtual_users`.`user`,'@',`virtual_domains`.`name`) AS
`mail`,`virtual_users`.`department` AS
`department`,`virtual_users`.`pphone` AS `telephoneNumber` from
(`virtual_users` left join `virtual_domains`
on((`virtual_users`.`domain_id` = `virtual_domains`.`id`)))
Any ideas ?
--
Mit freundlichem Gruß
Carsten Laun-De Lellis
Dipl.-Ing. Elektrotechnik
Certified Information Systems Auditor (CISA)
Hauptstrasse 13
D-67705 Trippstadt
Phone: +49 (6306) 992140
Mobile: +49 (151) 27530865
email: [email protected]
--
[email protected]
https://inverse.ca/sogo/lists
