* [sisyphus] dovecot & mysql
@ 2006-04-24 5:04 Oleg Sukhanov
0 siblings, 0 replies; only message in thread
From: Oleg Sukhanov @ 2006-04-24 5:04 UTC (permalink / raw)
To: ALT Linux Sisyphus discussion list
[-- Attachment #1: Type: text/plain, Size: 119 bytes --]
Никак не удаётся забрать из базы пароль юзера.
Пытался по всякому - никак.
Как это лечить? Юзер в базе точно есть.
[-- Attachment #2: dovecot --]
[-- Type: text/plain, Size: 3959 bytes --]
black@cdmz ~ $ telnet localhost 110
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
+OK Dovecot ready.
user test@cdmz.ufk23.fsfk.local
+OK
pass PAwz3tYR
-ERR [IN-USE] Internal login failure. Refer to server log for more information.
Connection closed by foreign host.
Apr 24 14:34:35 cdmz dovecot: auth(default): client in: AUTH^I1^IPLAIN^Iservice=POP3^Isecured^Ilip=127.0.0.1^Irip=127.0.0.1^Iresp=AHRlc3RAY2Rtei51ZmsyMy5mc2ZrLmxvY2FsAFBBd3ozdFlS
Apr 24 14:34:35 cdmz dovecot: auth-worker(default): sql(test@cdmz.ufk23.fsfk.local,127.0.0.1): query: SELECT password FROM users WHERE login = 'test@cdmz.ufk23.fsfk.local' AND domain = 'cdmz.ufk23.fsfk.local' AND status = '1'
Apr 24 14:34:35 cdmz dovecot: auth(default): client out: OK^I1^Iuser=test@cdmz.ufk23.fsfk.local
Apr 24 14:34:35 cdmz dovecot: auth(default): master in: REQUEST^I1^I11188^I1
Apr 24 14:34:35 cdmz dovecot: auth(default): passwd(test@cdmz.ufk23.fsfk.local,127.0.0.1): unknown user
Apr 24 14:34:35 cdmz dovecot: auth(default): userdb(test@cdmz.ufk23.fsfk.local,127.0.0.1): user not found from userdb
Apr 24 14:34:35 cdmz dovecot: auth(default): master out: NOTFOUND^I1
Apr 24 14:34:35 cdmz dovecot: pop3-login: Internal login failure: user=<test@cdmz.ufk23.fsfk.local>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
mysql> SELECT password FROM users WHERE login = 'test@cdmz.ufk23.fsfk.local' AND domain='cdmz.ufk23.fsfk.local' AND status = '1';
+----------+
| password |
+----------+
| PAwz3tYR |
+----------+
1 row in set (0.00 sec)
Apr 24 14:56:59 cdmz dovecot: auth(default): client in: AUTH^I1^IPLAIN^Iservice=POP3^Isecured^Ilip=127.0.0.1^Irip=127.0.0.1^Iresp=AHRlc3RAY2Rtei51ZmsyMy5mc2ZrLmxvY2FsAFBBd3ozdFlS
Apr 24 14:56:59 cdmz dovecot: auth-worker(default): sql(test@cdmz.ufk23.fsfk.local,127.0.0.1): query: SELECT password FROM users WHERE login = 'test@cdmz.ufk23.fsfk.local' AND domain = 'cdmz.ufk23.fsfk.local' AND status = '1'
Apr 24 14:56:59 cdmz dovecot: auth-worker(default): sql(test@cdmz.ufk23.fsfk.local,127.0.0.1): unknown user
Apr 24 14:57:00 cdmz dovecot: auth(default): client out: FAIL^I1^Iuser=test@cdmz.ufk23.fsfk.local
Apr 24 14:57:07 cdmz dovecot: auth(default): client in: AUTH^I2^IPLAIN^Iservice=POP3^Isecured^Ilip=127.0.0.1^Irip=127.0.0.1^Iresp=AHRlc3QAUEF3ejN0WVI=
Apr 24 14:57:07 cdmz dovecot: auth-worker(default): sql(test,127.0.0.1): query: SELECT password FROM users WHERE login = 'test@' AND domain = '' AND status = '1'
Apr 24 14:57:07 cdmz dovecot: auth-worker(default): sql(test,127.0.0.1): unknown user
Apr 24 14:57:08 cdmz dovecot: auth(default): client out: FAIL^I2^Iuser=test
Apr 24 14:57:12 cdmz dovecot: pop3-login: Disconnected: user=<test>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
black@cdmz ~ $ telnet localhost 110
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
+OK Dovecot ready.
user test@cdmz.ufk23.fsfk.local
+OK
pass PAwz3tYR
-ERR Authentication failed.
user test
+OK
pass PAwz3tYR
-ERR Authentication failed.
^]
telnet> quit
Connection closed.
mysql> SELECT password FROM users WHERE login = 'test' AND domain='cdmz.ufk23.fsfk.local' AND status = '1';
+----------+
| password |
+----------+
| PAwz3tYR |
+----------+
1 row in set (0.00 sec)
dovecot.conf:
# SQL database
passdb sql {
# Path for SQL configuration file, see doc/dovecot-sql.conf for example
args = /etc/dovecot/dovecot-mysql.conf
}
userdb sql {
# Path for SQL configuration file, see doc/dovecot-sql.conf for example
args = /etc/dovecot/dovecot-mysql.conf
}
dovecot-mysql.conf:
driver = mysql
connect = host=127.0.0.1 dbname=exim user=sqlmail password=XXXXXXXXX
password_query = SELECT password FROM users WHERE login = '%n@%d' AND domain = '%d' AND status = '1'
ðÒÏÂÏ×ÁÌ É ÔÁË:
password_query = SELECT password FROM users WHERE login = '%n' AND domain = '%d' AND status = '1'
user_query = SELECT uid, gid FROM users WHERE login = '%n' AND domain = '%d'
^ permalink raw reply [flat|nested] only message in thread
only message in thread, other threads:[~2006-04-24 5:04 UTC | newest]
Thread overview: (only message) (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2006-04-24 5:04 [sisyphus] dovecot & mysql Oleg Sukhanov
ALT Linux Sisyphus discussions
This inbox may be cloned and mirrored by anyone:
git clone --mirror http://lore.altlinux.org/sisyphus/0 sisyphus/git/0.git
# If you have public-inbox 1.1+ installed, you may
# initialize and index your mirror using the following commands:
public-inbox-init -V2 sisyphus sisyphus/ http://lore.altlinux.org/sisyphus \
sisyphus@altlinux.ru sisyphus@altlinux.org sisyphus@lists.altlinux.org sisyphus@lists.altlinux.ru sisyphus@lists.altlinux.com sisyphus@linuxteam.iplabs.ru sisyphus@list.linux-os.ru
public-inbox-index sisyphus
Example config snippet for mirrors.
Newsgroup available over NNTP:
nntp://lore.altlinux.org/org.altlinux.lists.sisyphus
AGPL code for this site: git clone https://public-inbox.org/public-inbox.git