OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
RE : Quite strange issue with Postfix/Mysql integration. Does not take into consideration the username in the query toward mysql only the domain :-( - FIXED

From: Cyril Drouin - Bysoft (cyril.drouinbysoft.fr)
Date: Mon May 03 2004 - 11:23:01 CDT


I fixed it thanks to your email :-)
Finally, I found my mystake it was in the transport settings.
I forced Maildrop by default and now emails are correctly delivered.

transport_maps = static:maildrop

I have another issue with Maildrop now I will start another thread about
that.

Thanks again,

Cyril

-----Message d'origine-----
De : owner-postfix-userspostfix.org
[mailto:owner-postfix-userspostfix.org] De la part de Magnus Bäck
Envoyé : dimanche 2 mai 2004 23:01
À : postfix-userspostfix.org
Objet : Re: Quite strange issue with Postfix/Mysql integration. Does not
take into consideration the username in the query toward mysql only the
domain :-(

On Sunday, May 02, 2004 at 22:39 CEST,
     Cyril Drouin - Bysoft <cyril.drouinbysoft.fr> wrote:

> I had a box fully functionnal but I wanted to change my Mysql database
> in order to support more feature and now , as usual, it does not work
> anymore :-(
>
> I got a really strange issue. Postfix cannor receive any mail I got the
> following issue
>
> May 2 22:20:23 bisrvmail postfix/smtp[478]: BBBCF81C0CD:
> to=<pierrenumerique-plus.com>, relay=127.0.0.1[127.0.0.1], delay=1,
> status=sent (250 2.6.0 Ok, id=31319-07, from MTA: 250 Ok: queued as
> 8FCEF81C0CF)
> May 2 22:20:23 bisrvmail postfix/local[482]: 8FCEF81C0CF:
> to=<pierrenumerique-plus.com>, relay=local, delay=0, status=bounced
> (unknown user: "pierre")

local(8) does not find a user "pierre" on your system. What does

   getent passwd pierre

return? Nothing, I presume. numerique-plus.com is a virtual mailbox
domain, yes?

[...]

> alias_database = hash:/etc/postfix/aliases
> append_dot_mydomain = no

Are you sure you know what you're doing when setting this to "no"?

> biff = no
> command_directory = /usr/sbin
> config_directory = /etc/postfix
> content_filter = smtp-amavis:[127.0.0.1]:10024
> daemon_directory = /usr/libexec/postfix
> debug_peer_level = 2
> local_recipient_maps = $virtual_mailbox_maps $virtual_maps
> proxy:unix:passwd.byname

No, this is not correct. It seems you do not understand the different
address classes. Read ADDRESS_CLASS_README.

> mail_owner = postfix
> mailbox_command = procmail -a "$EXTENSION"
> mailbox_size_limit = 0
> mailq_path = /usr/bin/mailq
> manpage_directory = /usr/local/man
> mydestination = $virtual_mailbox_domain

Again, this is not correct. mydestination lists which domains that are
considered local and subject to local(8) delivery. Virtual mailbox
domains are not local domains. Also, it's "virtual_mailbox_domains".

[...]

--
Magnus Bäck
magnusdsek.lth.se