| View previous topic :: View next topic |
| Author |
Message |
unaos
n00b
Joined: 06 Apr 2006
Posts: 64
Location: brovary,UA
|
 Posted: Thu Oct 26, 2006 12:14 pm Post subject: dovecot auth failed (domain is empty) |
 |
|
Buenos dias!
Recently dovecot setup was started, and here is the first results - the domain string transmited from user is empty.
here is my confs
dovecot-sql.conf
| Code: |
driver = mysql
connect = host=localhost dbname=exim user=exim password=exim
default_pass_scheme = CRYPT
password_query = SELECT `username` as `user`, `password` FROM `mailbox` WHERE `username` = '%n@%d' AND `active`='1'
user_query = SELECT `maildir` AS `home`, 26 AS `uid`, 26 AS `gid` FROM `mailbox` WHERE `username` = '%n@%d' AND `active`='1'
|
and the mysql check
| Code: |
mysql> SELECT * FROM mailbox WHERE username='test@domain.com';
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 441
Current database: exim
+------------------+------------------------------------+-----------+-------------------+-------+-------------+---------------------+---------------------+--------+
| username | password | name | maildir | quota | domain | created | modified | active |
+------------------+------------------------------------+-----------+-------------------+-------+-------------+---------------------+---------------------+--------+
| test@domain.com | $1$8546bee7$S6F7u9XadQM81XaRMUp2w0 | Tester TT | test@domain.com/ | 0 | domain.com | 2006-10-24 15:22:51 | 2006-10-25 11:59:05 | 1 |
+------------------+------------------------------------+-----------+-------------------+-------+-------------+---------------------+---------------------+--------+
1 row in set (0.01 sec)
|
and the dovecot logs
| Code: |
dovecot: Oct 25 12:49:01 Info: auth(default): client in: AUTH 1 PLAIN service=POP3 lip=10.10.0.1 rip=10.10.0.7resp=<hidden>
dovecot: Oct 25 12:49:01 Info: auth-worker(default): sql(test,10.10.0.7): query: SELECT `username` as `user`, `password` FROM `mailbox` WHERE `username` = 'test@' AND `active`='1'
dovecot: Oct 25 12:49:01 Info: auth-worker(default): sql(test,10.10.0.7): unknown user
dovecot: Oct 25 12:49:02 Info: auth(default): client out: FAIL 1 user=test
|
the system info:
edge dovecot # dig -t mx domain.com
;; QUESTION SECTION:
;domain.com. IN MX
;; ANSWER SECTION:
domain.com. 604800 IN MX 10 mx.domain.com.
edge dovecot # nslookup mx.domain.com
Server: 10.10.0.1
Address: 10.10.0.1#53
mx.talisman.ua canonical name = ns.domain.com.
Name: ns.domain.com
Address: 10.10.0.1
edge dovecot # hostname -f
edge
edge dovecot # cat /etc/resolv.conf
nameserver 10.10.0.1
domain domain.com
search domain.com
isnt `hostname -f` suppoused to produce something like ns.domain.com ??
_________________
house of mystic lies |
|
| Back to top |
|
 |
unaos
n00b
Joined: 06 Apr 2006
Posts: 64
Location: brovary,UA
|
|
| Back to top |
|
|
magic919
Advocate
Joined: 17 Jun 2005
Posts: 2182
Location: Berkshire, UK
|
| Posted: Sat Oct 28, 2006 5:26 pm Post subject: |
|
|
Why not
| Quote: |
.... WHERE username = '%u'
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Networking & Security
