В письме от 17 марта 2014 09:39:32 пользователь Paul J Stevens написал:
> http://git.dbmail.eu/paul/dbmail/commit/?h=dbmail_3_1&id=33fb54c63a79765297e
> 2c174cb1051bf0d89656a
Sorry, don't work.
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 |
| loe | inet:0.0.0.0/0:5993 | inet:0.0.0.0/0:5995 | loe |
+-------+---------------------+---------------------+--------+
running dbmail-imapd on 5143, 5993 ports
and get:
Mar 17 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] Debug:[db]
db_use_usermap(+921): enabling usermap lookups
Mar 17 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] Debug:[db]
db_usermap_resolve(+3278): checking userid [loe] in usermap
Mar 17 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] Debug:[db]
db_usermap_resolve(+3284): client on inet socket [inet:172.20.1.11:5143]
Mar 17 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] Database:[db]
db_con_get(+263): [0x8079d30] connection from pool
Mar 17 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] 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 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] Database:[db]
db_stmt_set_str(+427): [0x80a7a50] 1:[loe]
Mar 17 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] 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 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] 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 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] 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 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] 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 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] 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 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] Debug:[cidr]
cidr_new(+114): struct cidrfilter {
sock_str: inet:0.0.0.0/0:5995;
socket->sin_addr: 0.0.0.0;
socket->sin_port: 5995;
mask: 0;
};
Mar 17 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] 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 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] Debug:[misc]
dm_sock_compare(+699): clientsock [inet:172.20.1.11:5143] sock_allow[],
sock_deny [inet:0.0.0.0/0:5995] => [1]
Mar 17 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] 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 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] Debug:[cidr]
cidr_new(+114): struct cidrfilter {
sock_str: inet:0.0.0.0/0:5993;
socket->sin_addr: 0.0.0.0;
socket->sin_port: 5993;
mask: 0;
};
Mar 17 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] Database:[db]
db_con_close(+291): [0x8079d30] connection to pool
Mar 17 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] Debug:[db]
db_usermap_resolve(+3337): bestscore [0]
Mar 17 13:31:13 eoks dbmail-imapd[10247]: [0x80a6db0] Debug:[imap]
dbmail_imap_session_handle_auth(+1267): [0x80ad840] trying to validate user
[loe]
Mar 17 13:31:15 eoks dbmail-imapd[10247]: [0x80a6db0] Database:[db]
db_con_get(+263): [0x8079d30] connection from pool
Mar 17 13:31:15 eoks dbmail-imapd[10247]: [0x80a6db0] Database:[db]
db_stmt_prepare(+419): [0x8079d30] [INSERT INTO dbmail_authlog (userid,
service, login_time, logout_time, src_ip, src_port, dst_ip, dst_port, status)
VALUES (?, ?, NOW(), NOW(), ?, ?, ?, ?, ?) ]
Mar 17 13:31:15 eoks dbmail-imapd[10247]: [0x80a6db0] Database:[db]
db_stmt_set_str(+427): [0x80a6bf0] 1:[loe]
Mar 17 13:31:15 eoks dbmail-imapd[10247]: [0x80a6db0] Database:[db]
db_stmt_set_str(+427): [0x80a6bf0] 2:[imap]
Mar 17 13:31:15 eoks dbmail-imapd[10247]: [0x80a6db0] Database:[db]
db_stmt_set_str(+427): [0x80a6bf0] 3:[172.20.4.0]
Mar 17 13:31:15 eoks dbmail-imapd[10247]: [0x80a6db0] Database:[db]
db_stmt_set_int(+433): [0x80a6bf0] 4:[34039]
Mar 17 13:31:15 eoks dbmail-imapd[10247]: [0x80a6db0] Database:[db]
db_stmt_set_str(+427): [0x80a6bf0] 5:[172.20.1.11]
Mar 17 13:31:15 eoks dbmail-imapd[10247]: [0x80a6db0] Database:[db]
db_stmt_set_int(+433): [0x80a6bf0] 6:[5143]
Mar 17 13:31:15 eoks dbmail-imapd[10247]: [0x80a6db0] Database:[db]
db_stmt_set_str(+427): [0x80a6bf0] 7:[failed]
Mar 17 13:31:15 eoks dbmail-imapd[10247]: [0x80a6db0] Database:[db]
db_con_close(+291): [0x8079d30] connection to pool
Mar 17 13:31:15 eoks dbmail-imapd[10247]: [0x80a6db0] Notice:[imap]
dbmail_imap_session_handle_auth(+1289): [0x80ad840] login rejected: user [loe]
from [172.20.4.0:34039]
OK, I try this:
mysql> select * from dbmail_usermap;
+-------+---------------------+---------------------+--------+
| login | sock_allow | sock_deny | userid |
+-------+---------------------+---------------------+--------+
| loe | inet:0.0.0.0/0:5110 | inet:0.0.0.0/0:5143 | loe |
| loe | inet:0.0.0.0/0:5995 | inet:0.0.0.0/0:5993 | loe |
+-------+---------------------+---------------------+--------+
And I get result as expected: can login to 5143 port and can't to 5110
There is bug in testing results from queue.
___
Lapshin Oleg
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
