Thanks for the replies guys (and gals?) I got things working by adding the table manually (ummm, shouldn't this be documented somewhere?) and adding a user to the database.
Neither 'plain' nor 'plain-text' were accepted by Sogo, so I changed it to 'md5', which worked. The application was REALLLLLLY slow in loading in the client browser, and I kept on getting these errors in the server logs: could not get DNS name of address 192.168.0.81 in domain <InternetDomain[0x0x82f8e18]> I fixed it by adding my client computer to the /etc/hosts file. I don't understand why, but this seemed to make Sogo happy. So now I can log in, but the page is really ugly. I get the impression that the CSS isn't being loaded. The CSS is there however, because if I look at the source of the page and follow the CSS links, I get pages full of CSS..... I'm lost again.... :-( Bien cordialement, Brian KREULEN E-DEAL -----Message d'origine----- De : Martin Rabl [mailto:[email protected]] Envoyé : jeudi 12 janvier 2012 16:34 À : [email protected] Objet : Re: [SOGo] Authentication using MySQL Am 12.01.2012 15:45, schrieb Brian KREULEN: > How do I do this? Is there something I'm missing? Thanks... 1. Create DB-Table with Auth-Infos like this table (the fields IMHO needed): CREATE TABLE sogo_auth ( c_uid varchar(100) NOT NULL, mail varchar(255) NOT NULL, c_name varchar(255) NOT NULL, c_password varchar(100) NOT NULL, c_cn varchar(255) NOT NULL, c_ou varchar(255) NOT NULL, PRIMARY KEY (c_uid) ) 2. Configure SOGo {authtable} == tablename from (1.) userPasswordAlgorithm => set as you wish, but plain is not good. <key>SOGoUserSources</key> <array> <dict> <key>canAuthenticate</key> <string>YES</string> <key>displayName</key> <string>database_auth</string> <key>id</key> <string>database</string> <key>isAddressBook</key> <string>NO</string> <key>type</key> <string>sql</string> <key>userPasswordAlgorithm</key> <string>md5</string> <key>viewURL</key> <string>mysql://{username}:{password}@localhost:3306/{database}/{authtable}</string> </dict> </array> Should run ... -- Greetings, Martin Rabl -- [email protected] https://inverse.ca/sogo/lists -- [email protected] https://inverse.ca/sogo/lists
