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 don't have a column
mail.
Any ideas?
The mail column MUST be defined.
Regards,
--
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
