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? 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:[email protected]> [email protected] From: Ludovic Marcotte [mailto:[email protected]] Sent: Thursday, January 13, 2011 6:41 PM To: [email protected] Subject: Re: [SOGo] Problems with authentication On 11-01-13 11:41 AM, Carsten Laun-De Lellis wrote: <key>SOGoAUserSources</key> ^- problem. -- Ludovic Marcotte [email protected] :: +1.514.755.3630 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) -- [email protected] https://inverse.ca/sogo/lists
