В письме от 16 марта 2014 14:49:30 пользователь Paul J Stevens написал:
> On 14-03-14 16:27, Oleg L. wrote:
> > When I insert data acording doc/README.usermap
> > I allow to insert only 1 string per user
> > When I insert 2 strings (allow/deny to different ports) user can't login
>
> Can you be more specific.
Hello
OK, I insert 2 rows in dbmail_usermap:
+---------+--------------------+--------------------+---------+
| login | sock_allow | sock_deny | userid |
+-----------+--------------------+--------------------+---------+
| backup | inet:0.0.0.0/0:143 | inet:0.0.0.0/0:110 | backup |
| backup | inet:0.0.0.0/0:993 | inet:0.0.0.0/0:995 | backup |
+---------+--------------------+--------------------+---------+
When I try to login both on 143 and 993 ports, I can't
Example of connect to 172.20.1.11 to port 993:
Mar 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] Debug:[db]
db_use_usermap(+921): enabling usermap lookups
Mar 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] Debug:[db]
db_usermap_resolve(+3278): checking userid [backup] in usermap
Mar 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] Debug:[db]
db_usermap_resolve(+3284): client on inet socket [inet:172.20.1.11:993]
Mar 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] Database:[db]
db_con_get(+263): [0x8079d30] connection from pool
Mar 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] 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 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] Database:[db]
db_stmt_set_str(+427): [0xb14426f0] 1:[backup]
Mar 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] Debug:[cidr]
cidr_new(+114): struct cidrfilter {
sock_str: inet:0.0.0.0/0:110;
socket->sin_addr: 0.0.0.0;
socket->sin_port: 110;
mask: 0;
};
Mar 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] Debug:[cidr]
cidr_new(+114): struct cidrfilter {
sock_str: inet:172.20.1.11:993;
socket->sin_addr: 172.20.1.11;
socket->sin_port: 993;
mask: 32;
};
Mar 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] Debug:[misc]
dm_sock_compare(+699): clientsock [inet:172.20.1.11:993] sock_allow[],
sock_deny [inet:0.0.0.0/0:110] => [1]
Mar 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] Debug:[cidr]
cidr_new(+114): struct cidrfilter {
sock_str: inet:172.20.1.11:993;
socket->sin_addr: 172.20.1.11;
socket->sin_port: 993;
mask: 32;
};
Mar 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] Debug:[cidr]
cidr_new(+114): struct cidrfilter {
sock_str: inet:0.0.0.0/0:143;
socket->sin_addr: 0.0.0.0;
socket->sin_port: 143;
mask: 0;
};
Mar 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] Debug:[cidr]
cidr_new(+114): struct cidrfilter {
sock_str: inet:0.0.0.0/0:995;
socket->sin_addr: 0.0.0.0;
socket->sin_port: 995;
mask: 0;
};
Mar 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] Debug:[cidr]
cidr_new(+114): struct cidrfilter {
sock_str: inet:172.20.1.11:993;
socket->sin_addr: 172.20.1.11;
socket->sin_port: 993;
mask: 32;
};
Mar 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] Debug:[misc]
dm_sock_compare(+699): clientsock [inet:172.20.1.11:993] sock_allow[],
sock_deny [inet:0.0.0.0/0:995] => [1]
Mar 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] Debug:[cidr]
cidr_new(+114): struct cidrfilter {
sock_str: inet:172.20.1.11:993;
socket->sin_addr: 172.20.1.11;
socket->sin_port: 993;
mask: 32;
};
Mar 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] Debug:[cidr]
cidr_new(+114): struct cidrfilter {
sock_str: inet:0.0.0.0/0:993;
socket->sin_addr: 0.0.0.0;
socket->sin_port: 993;
mask: 0;
};
Mar 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] Database:[db]
db_con_close(+291): [0x8079d30] connection to pool
Mar 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] Debug:[db]
db_usermap_resolve(+3337): bestscore [0]
Mar 16 21:16:49 eoks dbmail-imapd[6113]: [0x80a6cf0] Debug:[imap]
dbmail_imap_session_handle_auth(+1267): [0xb166ab38] trying to validate user
[backup]
Mar 16 21:16:51 eoks dbmail-imapd[6113]: [0x80a6cf0] Database:[db]
db_con_get(+263): [0x8079d30] connection from pool
Mar 16 21:16:51 eoks dbmail-imapd[6113]: [0x80a6cf0] 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 16 21:16:51 eoks dbmail-imapd[6113]: [0x80a6cf0] Database:[db]
db_stmt_set_str(+427): [0xb14b74f0] 1:[backup]
Mar 16 21:16:51 eoks dbmail-imapd[6113]: [0x80a6cf0] Database:[db]
db_stmt_set_str(+427): [0xb14b74f0] 2:[imap]
Mar 16 21:16:51 eoks dbmail-imapd[6113]: [0x80a6cf0] Database:[db]
db_stmt_set_str(+427): [0xb14b74f0] 3:[172.20.32.2]
Mar 16 21:16:51 eoks dbmail-imapd[6113]: [0x80a6cf0] Database:[db]
db_stmt_set_int(+433): [0xb14b74f0] 4:[49999]
Mar 16 21:16:51 eoks dbmail-imapd[6113]: [0x80a6cf0] Database:[db]
db_stmt_set_str(+427): [0xb14b74f0] 5:[172.20.1.11]
Mar 16 21:16:51 eoks dbmail-imapd[6113]: [0x80a6cf0] Database:[db]
db_stmt_set_int(+433): [0xb14b74f0] 6:[993]
Mar 16 21:16:51 eoks dbmail-imapd[6113]: [0x80a6cf0] Database:[db]
db_stmt_set_str(+427): [0xb14b74f0] 7:[failed]
Mar 16 21:16:51 eoks dbmail-imapd[6113]: [0x80a6cf0] Database:[db]
db_con_close(+291): [0x8079d30] connection to pool
Mar 16 21:16:51 eoks dbmail-imapd[6113]: [0x80a6cf0] Notice:[imap]
dbmail_imap_session_handle_auth(+1289): [0xb166ab38] login rejected: user
[backup] from [172.20.32.2:49999]
So, how can I setup dbmail_usermap to allow user access to imap (both 143 and
993 ports) and disallow to pop3 (both 110 and 995 ports)?
Thanks for help
___
Lapshin Oleg
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
