| 1 | # mysql lookups - expects specific data |
| 2 | exim -d-all+lookup -be |
| 3 | ${lookup mysql {select name from them where id='ph10';}} |
| 4 | ${lookup mysql {select name from them where id='ph10';}} |
| 5 | ${lookup mysql {select name from them where id='xxxx';}} |
| 6 | ${lookup mysql {select name from them where id='nothing';}} |
| 7 | ${lookup mysql {select id,name from them where id='nothing';}} |
| 8 | ${lookup mysql {delete from them where id='nonexist';}} |
| 9 | ${lookup mysql {select * from them where id='quote';}} |
| 10 | ${lookup mysql {select * from them where id='filter';}} |
| 11 | ${lookup mysql {select * from them where id='quote2';}} |
| 12 | ${lookup mysql {select * from them where id='nlonly';}} |
| 13 | ${lookup mysql {servers=x:localhost; select name from them where id='ph10';}} |
| 14 | ${lookup mysql {servers=localhost:x; select name from them where id='ph10';}} |
| 15 | ${lookup mysql {servers=localhost/test/root/:x; select name from them where id='ph10';}} |
| 16 | ${lookup mysql {servers=HOST_IPV4/test/root/:localhost; select name from them where id='ph10';}} |
| 17 | **** |
| 18 | exim -d -bh 10.0.0.0 |
| 19 | mail from:<a@b> |
| 20 | rcpt to:<c@d> |
| 21 | quit |
| 22 | **** |
| 23 | exim -odi -d ph10 |
| 24 | Test message |
| 25 | . |
| 26 | **** |