On Wed, Mar 10, 2010 at 10:05 AM, Simon <grem...@gmail.com> wrote: > Hi There, > > Currently we are using postfix (2.5.5-1.1) on debian lenny sasl support > thus: > > # cat smtpd.conf > auxprop_plugin: sql > mech_list: plain login cram-md5 digest-md5 > sql_engine: mysql > sql_hostnames: xxx.xxx.xxx.xxx > sql_user: xxxx > sql_passwd: xxxx > sql_database: xxxx > sql_select: select passwd from xxxx_users where userid ='%u > > Which works well! I was wondering if there is a way we can add another > source to the mix so that postfix would check 2 seperate > servers/databases/tables with a different table structure on the second > mysql server? >
Hi - in thinking further about this.. we simply created a mysql view table with the combination of both sources of data and changed our details to use that new view table. Simon