Hello, Thanks for information Andreas,
For all postfix users be careful when you write down, it should be like below. sql_hostnames: (xx.xx.xx.xx:3306,yy.yy.yy.yy:3306) Regards Vahric -----Original Message----- From: owner-postfix-us...@postfix.org [mailto:owner-postfix-us...@postfix.org] On Behalf Of Andreas Winkelmann Sent: Monday, February 16, 2009 10:24 AM To: postfix-users@postfix.org Subject: Re: SMTP-AUTH but use more then one mysql server > -- content of /usr/lib/sasl2/smtpd.conf -- > > pwcheck_method: auxprop > > mech_list: login plain > > auxprop_plugin: sql > > sql_hostnames: xx.xx.xx.xx > > sql_user: --- replaced --- > > sql_passwd: --- replaced --- > > sql_database: merakdb > > sql_select: select U_Password from users where U_Mailbox = '%...@%r' > > log_level: 7 > > > > Everything is working but I have another problem . > > Behind postfix I have more then one smtp server, each smtp server are have > own domains and they are unique. > > I would like to query each mysql server step by step > > I tested all below, but it did not work ! , anybody have a knowledge about > it ? > > sql_hostnames: xx.xx.xx.xx yy.yy.yy.yy > > sql_hostnames: xx.xx.xx.xx;yy.yy.yy.yy > > sql_hostnames: xx.xx.xx.xx:yy.yy.yy.yy >From the Cyrus-SASL Docs (docs/options.html): sql_hostnames SQL plugin Comma separated list of SQL servers (in host[:port] format). none (engine dependent) I think the red flashing thing here is "Comma". -- Andreas
