Custom variable in SQL Auxprop options

From: Asfihani (no email)
Date: Wed Mar 23 2005 - 02:16:51 EST

  • Next message: Thomas Bolioli: "Cyrus/LDAP/Krb5 design questions"

    Dear Gurus,

    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?

    Thank you,

    Regards,
    Asfihani


  • Next message: Thomas Bolioli: "Cyrus/LDAP/Krb5 design questions"





    Hosted Email Solutions

    Invaluement Anti-Spam DNSBLs



    Powered By FreeBSD   Powered By FreeBSD