Administrace komentářů

Nevim cim to je, pro nekoho mozna prkotina, ale rad bych se zeptal, jestli mi poradi nekdo s tim, ze kdyz mam vytvoreny mailbox v mysql, poslu na nej nejaky e-mail, doruci se v poradku. Ale az si vytvorim alias a polsu na tento alias nejaky e-mail, zobrazi se mi Invalid user specified. Zkousel jsem i primo maildrop -d user@domena.tld a pise to same, takze je jasne, ze je nejaky problem, proc mi maildrop nenacita take muj alias Dokazete mi prosim nekdo poradit, kdyz mam v tabulce mailbox e-mailove adresy, hesla, maildir, quoty a v tabulce alias aliasy pro dane domeny?

v main.cf mam:

...
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_gid_maps = static:5000
#mailbox_command = /usr/bin/procmail -f -a "$USER"
#mailbox_command = /usr/bin/maildrop-mysql -d "$USER" -f "$SENDER" "$EXTENSION"
maildrop_destination_recipient_limit=1
#virtual_transport = maildrop
transport_maps = proxy:mysql:/etc/postfix/mysql_transport.cf
#virtual_transport = virtual
virtual_transport = $transport_maps
#virtual_minimum_uid = 77
virtual_uid_maps = static:5000
virtual_mailbox_base = /home/vmail
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
#virtual_mailbox_limit = 51200000
#relay_domains = proxy:mysql:/etc/postfix/mysql_relay_domains_maps.cf

# Additional for quota support
virtual_create_maildirsize = yes
virtual_mailbox_extended = yes
virtual_maildir_extended = yes
virtual_mailbox_limit_maps = proxy:mysql:/etc/postfix/mysql_virtual_mailbox_limit_maps.cf
proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps
  $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains
  $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps
  $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks
  $virtual_mailbox_limit_maps
virtual_mailbox_limit_override = yes
virtual_maildir_limit_message = Prominte, ale misto pro schranku bylo prekroceno.
virtual_overquota_bounce = yes
....

a

maildrop-mysql.config

hostname	127.0.0.1
port		3306
socket		/var/lib/mysql/mysql.sock
database	postfix
dbuser		postfix
dbpw		postfixHESLO
dbtable		mailbox

#timeout		5
default_uidnumber	5000
default_gidnumber	5000
default_quota	10485760S,500C
uid_field		username
uidnumber_field		5000
gidnumber_field		5000
maildir_field		maildir
homedirectory_field	'/home/vmail'
quota_field		concat(quota,'S')

takze vubec nevim jak rozchodit alias z tabulky alias a ne z tabulky mailbox