Hi Ludovic
I defined now the mail column, but no change. I also set up a very basic configuration (new .GNUstepDefaults attached) Now I got the following error message: The proxy server received an invalid response from an upstream server. The proxy server could not handle the request <http://www.delellis.biz/SOGo/> GET /SOGo/. The log file shows [Thu Jan 13 21:59:17 2011] [error] [client 88.128.91.217] (20014)Internal error: proxy: error reading status line from remote server 127.0.0.1 [Thu Jan 13 21:59:17 2011] [error] [client 88.128.91.217] proxy: Error reading from remote server returned by /SOGo/ Any ideas ? The .GNUstepDefaults: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE plist PUBLIC "-//GNUstep//DTD plist 0.9//EN" "http://www.gnustep.org/plist-0_9.xml";> <plist version="0.9"> <dict> <key>NSGlobalDomain</key> <dict> </dict> <key>sogod</key> <dict> <key>OCSFolderInfoURL</key> <string>mysql://sogo:sogo@localhost:3306/sogo/sogo_folder_info</string> <key>SOGoAppointmentSendEMailNotifications</key> <string>YES</string> <key>SOGoLanguage</key> <string>English</string> <key>SOGoLoginModule</key> <string>Calendar</string> <key>SOGoMailDomain</key> <string>delellis.net</string> <key>SOGoProfileURL</key> <string>mysql://sogo:sogo@localhost:3306/sogo/sogo_user_profile</string> <key>SOGoTimeZone</key> <string>Europe/Berlin</string> <key>SOGoUserSources</key> <array> <dict> <key>canAuthenticate</key> <string>YES</string> <key>displayName</key> <string>SOGo Users</string> <key>id</key> <string>users</string> <key>isAddressBook</key> <string>YES</string> <key>type</key> <string>sql</string> <key>userPasswordAlgorithm</key> <string>none</string> <key>wqviewURL</key> <string>mysql://sogo:sogo@localhost:3306/sogo/sogo_mail_auth</string> </dict> </array> </dict> </dict> </plist> 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: <mailto:carsten.laun-delel...@delellis.net> carsten.delel...@delellis.net From: Ludovic Marcotte [mailto:lmarco...@inverse.ca] Sent: Thursday, January 13, 2011 9:04 PM To: users@sogo.nu Subject: Re: [SOGo] Problems with authentication On 11-01-13 2:58 PM, Carsten Laun-De Lellis wrote: Hi Basti, hi Ludovic Thank you for your hints. After I wrote the first email I found the misconfiguration myself. But though I fixed it I still receive error messages. In the sogo.log I found the following message: Jan 13 20:54:57 sogod [30626]: [ERROR] <0x0x1044c180[SQLSource]> could not run SQL 'SELECT * FROM sogo_mail_auth WHERE c_uid = 'carsten.delellis' OR LOWER(mail) = 'carsten.delellis'': <MySQL4Exception: 0x10496460> NAME:ExecutionFailed REASON:Unknown column 'mail' in 'where clause' 127.0.0.1 - - [13/Jan/2011:20:54:57 GMT] "GET /SOGo/carsten.delellis HTTP/1.1" 404 45/0 0.004 - - 8K My table looks like: mysql> desc sogo_mail_auth; +------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+-------+ | c_uid | varchar(255) | NO | PRI | NULL | | | c_password | varchar(255) | NO | | NULL | | | c_name | varchar(255) | YES | | NULL | | | c_cn | varchar(255) | YES | | NULL | | +------------+--------------+------+-----+---------+-------+ 4 rows in set (0.00 sec) So I have no idea where this message comes from. I dont have a column mail. Any ideas? The mail column MUST be defined. Regards, -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
