Hello

I’m creating a mail server using postfix + vimbadmin. most of the features work as expected, but I can not forward my mail using aliases feature. I configured the alias for my test user in mysql databases (using vimbadmin) but when I send a mail I don’t receive the mail to the alias.

postconf -n

aliasdatabase = hash:/etc/aliases
aliasmaps = hash:/etc/aliases
bouncequeuelifetime = 1d
brokensaslauthclients = yes
commanddirectory = /usr/sbin
configdirectory = /etc/postfix
contentfilter = smtp-amavis:[127.0.0.1]:10024
daemondirectory = /usr/libexec/postfix
datadirectory = /var/lib/postfix
debugpeerlevel = 2
debuggercommand = PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin ddd $daemondirectory/$processname $processid & sleep 5
headerchecks = regexp:/etc/postfix/headerchecks
htmldirectory = no
inetinterfaces = all
inetprotocols = all
mailowner = postfix
mailqpath = /usr/bin/mailq.postfix
manpagedirectory = /usr/share/man
maximalqueuelifetime = 1d
messagesizelimit = 31457280
milterdefaultaction = accept
milterprotocol = 2
mydestination = $myhostname, localhost.$mydomain, localhost
mydomain = example.com
myhostname = mail.example.com
mynetworks = 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128
newaliasespath = /usr/bin/newaliases.postfix
nonsmtpdmilters = inet:localhost:8891
queuedirectory = /var/spool/postfix
readmedirectory = /usr/share/doc/postfix-2.10.1/READMEFILES
receiveoverrideoptions = noaddressmappings
sampledirectory = /usr/share/doc/postfix-2.10.1/samples
senderbccmaps = hash:/etc/postfix/senderbcc
sendmailpath = /usr/sbin/sendmail.postfix
setgidgroup = postdrop
smtptlscertfile = /etc/mail/fullchain.pem
smtptlsciphers = high
smtptlskeyfile = /etc/privkey.pem
smtptlsmandatoryciphers = high
smtptlssecuritylevel = encrypt
smtptlssessioncachedatabase = btree:${datadirectory}/smtpscache
smtpdmilters = inet:localhost:8891
smtpdrecipientrestrictions = permitmynetworks, permitsaslauthenticated, rejectunauthdestination, checkpolicyservice unix:private/policyd-spf rejectinvalidhostname, rejectunauthpipelining, rejectnonfqdnsender, rejectunknownsenderdomain, rejectnonfqdnrecipient, rejectunknownrecipientdomain, rejectrblclient sbl.spamhaus.org, rejectrblclient zen.spamhaus.org, rejectrblclient cbl.abuseat.org, rejectrblclient bl.spamcop.net, rejectrblclient blackholes.easynet.nl, checkrecipientaccess hash:/etc/postfix/hold, checksenderaccess hash:/etc/postfix/privilegedsendermap, checksenderaccess hash:/etc/postfix/sendermap, checkclientaccess hash:/etc/postfix/clientmap, checkrecipientaccess hash:/etc/postfix/recipientmap, permit
smtpdrelayrestrictions = permitmynetworks permitsaslauthenticated deferunauthdestination, rejectunauthdestination, checkpolicyservice unix:private/policyd-spf
smtpdsaslauthenable = yes
smtpdsaslauthenticatedheader = yes
smtpdsaslpath = private/auth
smtpdsaslsecurityoptions = noanonymous, noplaintext
smtpdsasltlssecurityoptions = noanonymous
smtpdsasltype = dovecot
smtpdtlsauthonly = yes
smtpdtlscertfile = /etc/httpd/conf/ssl/mail/fullchain.pem
smtpdtlsciphers = high
smtpdtlskeyfile = /etc/httpd/conf/ssl/mail/privkey.pem
smtpdtlsmandatoryciphers = high
smtpdtlsmandatoryprotocols = !SSLv2, !SSLv3
smtpdtlssessioncachedatabase = btree:${datadirectory}/smtpdscache
smtpdusetls = yes
tlshighcipherlist = EDH+aRSA:EECDH+aRSA+AESGCM:EECDH+aRSA+SHA384:EECDH+aRSA+SHA256:+AES256:+AES128:+SSLv3:!aNULL:!eNULL:!LOW:!3DES:!MD5:!EXP:!PSK:!DSS:!RC4:!SEED:!ECDSA:AES256-SHA:AES128-SHA:!CAMELLIA
tlspreemptcipherlist = yes
unknownlocalrecipientrejectcode = 550
virtualaliasmaps = mysql:/etc/postfix/mysql/virtualaliasmaps.cf
virtualgidmaps = static:5000
virtualmailboxbase = /var/spool/mail
virtualmailboxdomains = mysql:/etc/postfix/mysql/virtualdomainsmaps.cf
virtualmailboxmaps = mysql:/etc/postfix/mysql/virtualmailboxmaps.cf
virtualtransport = lmtp:unix:private/dovecot-lmtp
virtualuidmaps = static:5000
postconf: warning: /etc/postfix/main.cf: unused parameter: policy-spftimelimit=3600s

cat /etc/postfix/mysql/virtualaliasmaps.cf

user = vimbadmin
password = password
hosts = 127.0.0.1
dbname = vimbadmin
query = SELECT goto FROM alias WHERE address = ’%s’ AND active = ‘1’

I hope someone can help me. Thanks in advance.