Virtual Alias maps

[Etienne Pretorius]

Hello List,

I have a email address say staff@domain that maps perfectly to all its 
intended recipients,
but on the same machine I have user1@domain that is suppose to map to 
user1@domain,user2@domain but it does not.

I have looked at the virtual_alias_map setting and executed the sql 
query manually and it shows

user1@domain,user2@domain

Which is correct.

So I am in need of advise of where to check where the problem might be 
and I can post relevant configuration parameters as nessary.

MASTER.CF

# Before-queue SMTP server. Receive mail from the network and
# pass it to the content filter on localhost port 10024.
smtp      inet  n       -       n       -       80      smtpd
          -o smtpd_proxy_filter=127.0.0.1:10024
          -o receive_override_options=no_address_mappings
          -o smtpd_soft_error_limit=3
          -o smtpd_hard_error_limit=3
          -o smtpd_delay_reject=no
          -o anvil_rate_time_unit=60s
          -o smtpd_client_connection_rate_limit=5
          -o smtpd_client_connection_count_limit=12
          -o smtpd_client_event_limit_exceptions=$mynetworks,$smtp_networks
#
# After-queue SMTP server. Receive mail from the content filter
# on localhost port 10025.
#
127.0.0.1:10025 inet    n       -       n       -       -       smtpd
    -o content_filter=
    -o local_recipient_maps=
    -o relay_recipient_maps=
    -o smtpd_restriction_classes=
    -o smtpd_delay_reject=no
    -o smtpd_client_restrictions=permit_mynetworks,reject
    -o smtpd_helo_restrictions=
    -o smtpd_sender_restrictions=
    -o smtpd_recipient_restrictions=permit_mynetworks,reject
    -o smtpd_data_restrictions=reject_unauth_pipelining
    -o smtpd_end_of_data_restrictions=
    -o mynetworks_style=host
    -o mynetworks=127.0.0.1
    -o strict_rfc821_envelopes=yes
    -o smtpd_error_sleep_time=0
    -o smtpd_soft_error_limit=1001
    -o smtpd_hard_error_limit=1000
    -o smtpd_client_connection_count_limit=0
    -o smtpd_client_connection_rate_limit=0
    -o 
receive_override_options=no_header_body_checks,no_unknown_recipient_checks

MAIN.CF
virtual_alias_maps = mysql:/etc/postfix/mysql.virtualaliases.cf

MYSQL.VIRTUALALIASES.CF
user                 = <SOMEUSER>
password         = <SOMEPASSWD>
dbname           = <SOMEDATABASE>
table                = postfix_virtual
select_field      = Destination
where_field      = EmailAddr
hosts                = 127.0.0.1

MYSQL:
mysql> select Destination from postfix_virtual where 
EmailAddr='user1@domain';
+--------------------------------------------------+
| Destination                                      |
+--------------------------------------------------+
| user1@domain,user2@domain     |
+--------------------------------------------------+
1 row in set (0.00 sec)

Kind Regards,
Etienne Pretorius