мне надо сделать такой sql запрос в конфиге exim
SQL |
SELECT domain_id, login, domain FROM users, domains WHERE domain_id = id; |
SQL |
login password domain_id yura jghkjsdf 1 bobot dsdsdss 2 vitalik kkjkjkj 2 |
SQL |
id domain 1 newmail.univ.ru 2 testmail.univ.ru |
SQL |
SELECT domain_id, login, domain FROM users, domains WHERE domain_id = id; |
SQL |
+-----------+--------+-----------------------+ | domain_id | login | domain | +-----------+--------+-----------------------+ | 1 | fear | newmail.univ.kiev.ua | | 2 | crysis | testmail.univ.kiev.ua | | 2 | popka | testmail.univ.kiev.ua | +-----------+--------+-----------------------+ |
SQL |
SELECT domain_id, login, domain FROM users, domains WHERE domain_id = id; |
HTML |
virtual_localuser: driver = accept domains = ${lookup mysql{SELECT domain from domains WHERE domain='${domain}'}} local_parts = ${lookup mysql{SELECT login from users WHERE login='${local_part}' AND domain='${domain}'}} |
Цитата (kirik @ 7.07.2009 - 14:56) |
Цо то есть Exim? |