Mysql local_recipient_maps Problem

permalink · #1 (**permalink**) 05-11-2004

This is a multi-part message in MIME format.

------=_NextPart_000_0000_01C436FF.6E55E5A0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi folks,

I need to finally fix the problem with my postfix implantation . Everything
works fine but mail to non-existant address is STILL being accepted despite
have a mysql lookup for "local_recipient_maps".

The followings is the result of two postmap tests.

[user@server postfix]# /usr/bbin/postmap -v -q phil
mysql:/etc/postfix/mysql-rec

ipients.cf

postmap: mysqlname_parse(): set username to 'dbusername'

postmap: mysqlname_parse(): set password to '****'

postmap: mysqlname_parse(): set database name to 'dbname'

postmap: mysqlname_parse(): set table name to 'accounts'

postmap: mysqlname_parse(): set select_field to 'username'

postmap: mysqlname_parse(): set where_field to 'username'

postmap: mysqlname_parse(): set additional_conditions to 'and status = '2''

postmap: mysqlname_parse(): adding host '127.0.0.1' to list of mysql server
host

s

postmap: dict_open: mysql:/etc/postfix/mysql-recipients.cf

postmap: dict_mysql_lookup using sql query: select username from accounts
where

username = 'phil' and status = '2'

postmap: dict_mysql: attempting to connect to host 127.0.0.1

postmap: dict_mysql: successful connection to host 127.0.0.1

postmap: dict_mysql: successful query from host 127.0.0.1

postmap: dict_mysql_lookup: retrieved 1 rows

phil

[user@server postfix]# /usr/bbin/postmap -v -q doesnotexist
mysql:/etc/postfix/m

ysql-recipients.cf

postmap: mysqlname_parse(): set username to 'dbusername'

postmap: mysqlname_parse(): set password to '****'

postmap: mysqlname_parse(): set database name to 'dbname'

postmap: mysqlname_parse(): set table name to 'accounts'

postmap: mysqlname_parse(): set select_field to 'username'

postmap: mysqlname_parse(): set where_field to 'username'

postmap: mysqlname_parse(): set additional_conditions to 'and status = '2''

postmap: mysqlname_parse(): adding host '127.0.0.1' to list of mysql server
host

s

postmap: dict_open: mysql:/etc/postfix/mysql-recipients.cf

postmap: dict_mysql_lookup using sql query: select username from accounts
where

username = 'doesnotexist' and status = '2'

postmap: dict_mysql: attempting to connect to host 127.0.0.1

postmap: dict_mysql: successful connection to host 127.0.0.1

postmap: dict_mysql: successful query from host 127.0.0.1

postmap: dict_mysql_lookup: retrieved 0 rows

Can someone please advise what is wrong with this map .

Having read the following from "LOCAL_RECIPIENT_README"

NOTE: a lookup table should always return a result when the address exists,
and

should always return "not found" when the address does not exist. In

particular, a zero-length result does not count as a "not found" result.

What exactly does return "not found" mean ??? Retrieved 0 rows ?????

Regards,

Phil,

Sheffield.

------=_NextPart_000_0000_01C436FF.6E55E5A0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>

</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Hi folks,<o:p></o:p>

<o:p> </o:p>

I need to finally fix the problem with my =
postfix implantation
… Everything works fine but mail to non-existant address is STILL =
being
accepted despite have a mysql lookup for =
“local_recipient_maps”.<o:p></o:p>

<o:p> </o:p>

The followings is the result of two postmap =
tests.<o:p></o:p>

<o:p> </o:p>

[user@server postfix]# /usr/bbin/postmap -v -q =
phil
mysql:/etc/postfix/mysql-rec<o:p></o:p>

ipients.cf<o:p></o:p>

postmap: mysqlname_parse(): set username to =
'dbusername'<o:p></o:p>

postmap: mysqlname_parse(): set password to =
'****'<o:p></o:p>

postmap: mysqlname_parse(): set database name =
to 'dbname'<o:p></o:p>

postmap: mysqlname_parse(): set table name to
'accounts'<o:p></o:p>

postmap: mysqlname_parse(): set select_field =
to
'username'<o:p></o:p>

postmap: mysqlname_parse(): set where_field to
'username'<o:p></o:p>

postmap: mysqlname_parse(): set =
additional_conditions
to 'and status =3D '2''<o:p></o:p>

postmap: mysqlname_parse(): adding host =
'127.0.0.1'
to list of mysql server host<o:p></o:p>

s<o:p></o:p>

postmap: dict_open:
mysql:/etc/postfix/mysql-recipients.cf<o:p></o:p>

postmap: dict_mysql_lookup using sql query: =
select
username from accounts where<o:p></o:p>

username =3D 'phil' and status =3D =
'2'<o:p></o:p>

postmap: dict_mysql: attempting to connect to =
host
127.0.0.1<o:p></o:p>

postmap: dict_mysql: successful connection to =
host
127.0.0.1<o:p></o:p>

postmap: dict_mysql: successful query from =
host
127.0.0.1<o:p></o:p>

postmap: dict_mysql_lookup: retrieved 1 =
rows<o:p></o:p>

phil<o:p></o:p>

[user@server postfix]# /usr/bbin/postmap -v -q
doesnotexist mysql:/etc/postfix/m<o:p></o:p>

ysql-recipients.cf<o:p></o:p>=

postmap: mysqlname_parse(): set username to =
'dbusername'<o:p></o:p>

postmap: mysqlname_parse(): set password to =
'****'<o:p></o:p>

postmap: mysqlname_parse(): set database name =
to 'dbname'<o:p></o:p>

postmap: mysqlname_parse(): set table name to
'accounts'<o:p></o:p>

postmap: mysqlname_parse(): set select_field =
to
'username'<o:p></o:p>

postmap: mysqlname_parse(): set where_field to
'username'<o:p></o:p>

postmap: mysqlname_parse(): set =
additional_conditions
to 'and status =3D '2''<o:p></o:p>

postmap: mysqlname_parse(): adding host =
'127.0.0.1'
to list of mysql server host<o:p></o:p>

s<o:p></o:p>

postmap: dict_open: =
mysql:/etc/postfix/mysql-recipients.cf<o:p></o:p>

postmap: dict_mysql_lookup using sql query: =
select
username from accounts where<o:p></o:p>

username =3D 'doesnotexist' and status =3D =
'2'<o:p></o:p>

postmap: dict_mysql: attempting to connect to =
host
127.0.0.1<o:p></o:p>

postmap: dict_mysql: successful connection to =
host 127.0.0.1<o:p></o:p>

postmap: dict_mysql: successful query from =
host
127.0.0.1<o:p></o:p>

postmap: dict_mysql_lookup: retrieved 0 =
rows<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

Can someone please advise what is wrong with =
this map
…<o:p></o:p>

<o:p> </o:p>

Having read the following from =
“LOCAL_RECIPIENT_README”<o:p></o:p>

<o:p> </o:p>

NOTE: a lookup table should always return a =
result
when the address exists, and<o:p></o:p>

should always return "not found" =
when the
address does not exist. In<o:p></o:p>

particular, a zero-length result does not =
count as a
"not found" result.<o:p></o:p>

<o:p> </o:p>

What exactly does return “not =
found” mean
???  Retrieved 0 rows ?????<o:p></o:p>

<o:p> </o:p>

Regards,<o:p></o:p>

<o:p> </o:p>

Phil,<o:p></o:p>

<o:p> </o:p>

Sheffield.<o:p></o:p>

</div>

</body>

</html>

------=_NextPart_000_0000_01C436FF.6E55E5A0--

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode