[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[tpop3d-discuss] auth_mysql problem
From: |
Tomasz Matuszewski |
Subject: |
[tpop3d-discuss] auth_mysql problem |
Date: |
Sat, 6 Sep 2003 13:50:58 +0200 |
User-agent: |
Mutt/1.4.1i |
Helou!
I need your help :)
I have tpop3d with mysql, and everything works fine with password in
plaintext, but i want have password encrypted by mysql. And i have
this:
listen-address: 0.0.0.0
max-children: 20
log-facility: local1
auth-mysql-enable:yes
auth-mysql-mail-group:mail
auth-mysql-hostname:localhost
auth-mysql-username:postfix
auth-mysql-password:postfix
auth-mysql-database:mail
auth-mysql-pass-query: SELECT CONCAT('/home/artnet/testmail/',
'$(local_part)'), \
CONCAT('{mysql}',haslo), 'postfix', 'bsd' FROM skrzynki WHERE \
nazwa = '$(local_part)' AND domena = '$(domain)' AND alias=''
My table skrzynki in database mail
mysql> select * from skrzynki;
+--------------+-------------+-------+------------------+
| nazwa | domena | alias | haslo |
+--------------+-------------+-------+------------------+
| testowekonto | poczta.test | | 64924b706b5a77e0 |
+--------------+-------------+-------+------------------+
1 row in set (0.00 sec)
And this i have in logs:
Sep 6 13:32:23 omicron tpop3d[40116]: password: address@hidden; address@hidden
has password type
mysql, but hash is of incorrect length 23 (expecting 8 or 16)
Sep 6 13:32:23 omicron tpop3d[40116]: auth_mysql_new_user_pass:
address@hidden; address@hidden failed l ogin with wrong password
mysql hash is 16 lenght, but with {mysql} it has exactly 23... what is
wrong?
--
Tomasz Matuszewski, address@hidden, gg: 895856, tel: +48(605)052-627
"Słowa donosiciela są jak smaczne kąski: zapadają do głebii
wnętrzności" Księga Przysłów
- [tpop3d-discuss] auth_mysql problem,
Tomasz Matuszewski <=
- Re: [tpop3d-discuss] auth_mysql problem, Jakob Hirsch, 2003/09/06
- Message not available
- Re: [tpop3d-discuss] auth_mysql problem, Jakob Hirsch, 2003/09/06
- Re: [tpop3d-discuss] auth_mysql problem, Jens Liebchen (ppp-design), 2003/09/06
- Re: [tpop3d-discuss] auth_mysql problem, Jakob Hirsch, 2003/09/06
- Re: [tpop3d-discuss] auth_mysql problem, Jens Liebchen (ppp-design), 2003/09/07
- Re: [tpop3d-discuss] auth_mysql problem, Chris Lightfoot, 2003/09/07
- Re: [tpop3d-discuss] auth_mysql problem, Jakob Hirsch, 2003/09/07
Re: [tpop3d-discuss] auth_mysql problem, Chris Lightfoot, 2003/09/06