В письме от 17 марта 2014 11:47:22 пользователь Paul J Stevens написал:
> On 17-03-14 10:47, Oleg L. wrote:
>
> > В письме от 17 марта 2014 09:39:32 пользователь Paul J Stevens написал:
> >
> >> http://git.dbmail.eu/paul/dbmail/commit/?h=dbmail_3_1&id=33fb54c63a797652
> >> 97e
2c174cb1051bf0d89656a
> >
> >
> > Sorry, don't work.
>
>
> Please try again:
>
> http://git.dbmail.eu/paul/dbmail/commit/?h=dbmail_3_1&id=f5d7564b7d6c694bf03
> 832145dab8a04df0125ac
With:
mysql> select * from dbmail_usermap;
+-------+---------------------+---------------------+--------+
| login | sock_allow | sock_deny | userid |
+-------+---------------------+---------------------+--------+
| loe | inet:0.0.0.0/0:5143 | inet:0.0.0.0/0:5110 | loe |
+-------+---------------------+---------------------+--------+
I can login to 5143 port and to 5110 port , both ;(
Log from pop3d:
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Debug:[db]
db_use_usermap(+921): enabling usermap lookups
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Debug:[db]
db_usermap_resolve(+3278): checking userid [loe] in usermap
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Debug:[db]
db_usermap_resolve(+3284): client on inet socket [inet:172.20.1.11:5110]
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_con_get(+263): [0x8066d30] connection from pool
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_stmt_prepare(+419): [0x8066d30] [SELECT login, sock_allow, sock_deny,
userid FROM dbmail_usermap WHERE login in (?,'ANY') ORDER BY sock_allow,
sock_deny]
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_stmt_set_str(+427): [0x8096948] 1:[loe]
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Debug:[cidr]
cidr_new(+114): struct cidrfilter {
sock_str: inet:0.0.0.0/0:5110;
socket->sin_addr: 0.0.0.0;
socket->sin_port: 5110;
mask: 0;
};
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Debug:[cidr]
cidr_new(+114): struct cidrfilter {
sock_str: inet:172.20.1.11:5110;
socket->sin_addr: 172.20.1.11;
socket->sin_port: 5110;
mask: 32;
};
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Debug:[misc]
dm_sock_compare(+699): clientsock [inet:172.20.1.11:5110] sock_allow[],
sock_deny [inet:0.0.0.0/0:5110] => [0]
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_con_close(+291): [0x8066d30] connection to pool
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Debug:[db]
db_usermap_resolve(+3326): access denied
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_con_get(+263): [0x8066d30] connection from pool
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_stmt_prepare(+419): [0x8066d30] [SELECT user_idnr FROM dbmail_users WHERE
lower(userid) = lower(?)]
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_stmt_set_str(+427): [0x8098518] 1:[loe]
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_con_close(+291): [0x8066d30] connection to pool
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_con_get(+263): [0x8066d30] connection from pool
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_query(+363): [0x8066d30] [SELECT passwd, encryption_type FROM dbmail_users
WHERE user_idnr = 3840]
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
log_query_time(+307): last query took [0.000] seconds
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_con_close(+291): [0x8066d30] connection to pool
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Debug:[auth]
auth_validate(+370): validating using plaintext passwords
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_con_get(+263): [0x8066d30] connection from pool
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_begin_transaction(+542): BEGIN
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_exec(+330): [0x8066d30] [UPDATE dbmail_users SET last_login = '2014-03-17
15:02:32' WHERE user_idnr = 3840]
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
log_query_time(+307): last query took [0.000] seconds
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_commit_transaction(+549): COMMIT
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_con_close(+291): [0x8066d30] connection to pool
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_con_get(+263): [0x8066d30] connection from pool
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_stmt_prepare(+419): [0x8066d30] [INSERT INTO dbmail_authlog (userid,
service, login_time, logout_time, src_ip, src_port, dst_ip, dst_port, status)
VALUES (?, ?, NOW(), NOW(), ?, ?, ?, ?, ?) ]
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_stmt_set_str(+427): [0x8098788] 1:[loe]
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_stmt_set_str(+427): [0x8098788] 2:[pop3]
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_stmt_set_str(+427): [0x8098788] 3:[172.20.4.0]
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_stmt_set_int(+433): [0x8098788] 4:[34784]
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_stmt_set_str(+427): [0x8098788] 5:[172.20.1.11]
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_stmt_set_int(+433): [0x8098788] 6:[5110]
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_stmt_set_str(+427): [0x8098788] 7:[active]
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Database:[db]
db_con_close(+291): [0x8066d30] connection to pool
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Debug:[pop3]
_pop3_session_authenticated(+336): validation OK, building a session for user
[loe]
There is
Mar 17 15:02:32 eoks dbmail-pop3d[18198]: [0x8059400] Debug:[db]
db_usermap_resolve(+3326): access denied
but pop3d don't close connection
When using 5143 port (imapd):
Mar 17 15:02:59 eoks dbmail-imapd[18214]: [0x80a6d80] Database:[db]
db_stmt_prepare(+419): [0x8079d30] [SELECT login, sock_allow, sock_deny,
userid FROM dbmail_usermap WHERE login in (?,'ANY') ORDER BY sock_allow,
sock_deny]
Mar 17 15:02:59 eoks dbmail-imapd[18214]: [0x80a6d80] Database:[db]
db_stmt_set_str(+427): [0x80af158] 1:[loe]
Mar 17 15:02:59 eoks dbmail-imapd[18214]: [0x80a6d80] Debug:[cidr]
cidr_new(+114): struct cidrfilter {
sock_str: inet:0.0.0.0/0:5110;
socket->sin_addr: 0.0.0.0;
socket->sin_port: 5110;
mask: 0;
};
Mar 17 15:02:59 eoks dbmail-imapd[18214]: [0x80a6d80] Debug:[cidr]
cidr_new(+114): struct cidrfilter {
sock_str: inet:172.20.1.11:5143;
socket->sin_addr: 172.20.1.11;
socket->sin_port: 5143;
mask: 32;
};
Mar 17 15:02:59 eoks dbmail-imapd[18214]: [0x80a6d80] Debug:[misc]
dm_sock_compare(+699): clientsock [inet:172.20.1.11:5143] sock_allow[],
sock_deny [inet:0.0.0.0/0:5110] => [1]
Mar 17 15:02:59 eoks dbmail-imapd[18214]: [0x80a6d80] Debug:[cidr]
cidr_new(+114): struct cidrfilter {
sock_str: inet:172.20.1.11:5143;
socket->sin_addr: 172.20.1.11;
socket->sin_port: 5143;
mask: 32;
};
Mar 17 15:02:59 eoks dbmail-imapd[18214]: [0x80a6d80] Debug:[cidr]
cidr_new(+114): struct cidrfilter {
sock_str: inet:0.0.0.0/0:5143;
socket->sin_addr: 0.0.0.0;
socket->sin_port: 5143;
mask: 0;
};
Mar 17 15:02:59 eoks dbmail-imapd[18214]: [0x80a6d80] Database:[db]
db_con_close(+291): [0x8079d30] connection to pool
Mar 17 15:02:59 eoks dbmail-imapd[18214]: [0x80a6d80] Debug:[db]
db_usermap_resolve(+3337): bestscore [32]
Mar 17 15:02:59 eoks dbmail-imapd[18214]: [0x80a6d80] Debug:[db]
db_usermap_resolve(+3348): best match: [loe] -> [loe]
Mar 17 15:02:59 eoks dbmail-imapd[18214]: [0x80a6d80] Debug:[db]
db_usermap_resolve(+3362): [loe] maps to [loe]
Mar 17 15:02:59 eoks dbmail-imapd[18214]: [0x80a6d80] Database:[db]
db_con_get(+263): [0x8079d30] connection from pool
Mar 17 15:02:59 eoks dbmail-imapd[18214]: [0x80a6d80] Database:[db]
db_stmt_prepare(+419): [0x8079d30] [SELECT user_idnr FROM dbmail_users WHERE
lower(userid) = lower(?)]
Mar 17 15:02:59 eoks dbmail-imapd[18214]: [0x80a6d80] Database:[db]
db_stmt_set_str(+427): [0x80af1b0] 1:[loe]
Mar 17 15:02:59 eoks dbmail-imapd[18214]: [0x80a6d80] Database:[db]
db_con_close(+291): [0x8079d30] connection to pool
Mar 17 15:02:59 eoks dbmail-imapd[18214]: [0x80a6d80] Database:[db]
db_con_get(+263): [0x8079d30] connection from pool
Mar 17 15:02:59 eoks dbmail-imapd[18214]: [0x80a6d80] Database:[db]
db_query(+363): [0x8079d30] [SELECT passwd, encryption_type FROM dbmail_users
WHERE user_idnr = 3840]
___
Lapshin Oleg
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
