On Wed, Aug 03, 2016 at 02:21:25PM +0100, Paul wrote: > I am having problems with creating a new mysql lookup statement > which queries 2 tables for valid sasl login names > > The new query is > > cat peq.sql > > SELECT aliases.id,sasl_aliases.id FROM sasl_aliases,aliases WHERE > aliases.address = sasl_aliases.address AND aliases.address = > 't...@address.com';
That's fine I suppose, but it's not valid syntax for a Postfix mysql_table(5) query file. > paule@cedar:~# mysql -u mailuser -p maildb <peq.sql > Enter password: > username1 username2 > > Which is what I believe I need ie returning a white spaced list of > valid login names for t...@address.com. > > However postfix coughs and fails with this query. log shows > > Aug 3 14:17:46 larch postfix/submit/smtpd[21172]: fatal: > /etc/postfix/mysql/new.cf, line 4: missing '=' after attribute > name: "SELECT aliases.id,sasl_aliases.id FROM sasl_aliases,aliases > WHERE aliases.address=sasl_aliases.address AND > aliases.address='%s'" > > > Any pointers or suggestions http://www.postfix.org/MYSQL_README.html http://www.postfix.org/mysql_table.5.html Your query file would generally have these lines: user = ... password = ... dbname = ... and then your query: query = SELECT aliases.id,sasl_aliases.id FROM sasl_aliases,aliases WHERE aliases.address=sasl_aliases.address AND aliases.address='%s' -- http://rob0.nodns4.us/ Offlist GMX mail is seen only if "/dev/rob0" is in the Subject: