From: Asfihani (no email)
Date: Wed Mar 23 2005 - 02:16:51 EST
First, sorry for my poor english :-)
After succesfully configured SASL with MySQL support with Postfix, now
I have faced with problem on how to authenticated against several
tables. Actually, it was IMail (from Ipswitch) MTA configured with
ODBC driver (MySQL). Each domain accounts are stored in different
tables, unfortunately the tables name is quite different format, I
mean with underscored instead dotted (eg. domain_tld instead
domain.tld). Thus, I can't use a statement like this :
sql_select: SELECT password FROM '%r' WHERE mailaddr = '%u@%r'
Because '%r' will return FQDN table instead underscored table :-). The
question is, is it possible to create a new "variable" based on realm
value with subtituted dot with underscore?