On 2006-11-24 at 13:12 +1300, Craig Whitmore wrote: > And these work fine.. but how do I convert these queries to mysql versions? > so I can put the data into a database like the domains? > > hostlist rbl_whitelist = net-iplsearch;/etc/exim4/rbl_whitelist
Are you locked into MySQL? PostgreSQL provides rather more support for other data-types. You could use "cidr" as a column type to hold cidr blocks in the same format that Exim uses and then the network address comparators and functions for doing lookups such as "is contained within". Order and Limit as desired. Sections 8.8 and 9.11 of <URL:http://www.postgresql.org/docs/8.1/static/sql.html>. > hostlist high_ratelimit = partial-lsearch;/etc/exim4/high_ratelimit My SQL-fu is weak enough that I don't think I could write a pure query for this; instead I'd just write a stored procedure to loop through replacing leading components with '*' and returning the first match found, else NULL if none found. (Not without swearing a lot though, I wouldn't; it's been a couple of years since I last wrote stored procedures so I'd spend my time with browser tabs pointed at various bits of the language reference; hence no example here). -Phil -- ## List details at http://www.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://www.exim.org/eximwiki/
