Paul
2016-08-03 13:21:25 UTC
Hello
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 =
'***@address.com';
***@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 ***@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.i
d FROM sasl_aliases,aliases WHERE aliases.address=sasl_aliases.address
AND alias
es.address='%s'"
Any pointers or suggestions
Paul Enlund
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 =
'***@address.com';
***@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 ***@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.i
d FROM sasl_aliases,aliases WHERE aliases.address=sasl_aliases.address
AND alias
es.address='%s'"
Any pointers or suggestions
Paul Enlund