Hmmmm.... Evidently something was missing from the configuration, as I see the following message in the logs:
No protocol handler was valid for the URL /SOGo/. If you are using a DSO version of mod_proxy, make sure the proxy submodules are included in the configuration using LoadModule. After some googling, it seems that I have to enable some proxy sub modules, like proxy_http and proxy_connect. I enabled proxy_ftp, but I think I can get rid of that. Everything seems to be working! Thanks! Now I just have to connect our application up to Sogo using CalDav..... next challenge! Bien cordialement, Brian KREULEN E-DEAL -----Message d'origine----- De : Martin Rabl [mailto:[email protected]] Envoyé : jeudi 12 janvier 2012 20:03 À : [email protected] Objet : Re: [SOGo] Authentication using MySQL Did you configure the apache proxy as documented? --- Martin Rabl Am 12.01.2012 um 19:50 schrieb Brian KREULEN <[email protected]>: > 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 -- [email protected] https://inverse.ca/sogo/lists -- [email protected] https://inverse.ca/sogo/lists
