Portál AbcLinuxu, 10. května 2025 05:35
Taky jsme narazili na tenhle problém. Řešení není složité.
1.Doplnit do konfiguračního souboru postfixu (main.cf) následující parametry:
virtual_mailbox_limit_maps = mysqql:/etc/postfix/mysql-vquota.cf
(tím řeknu postfixu, ve které tabulce jsou informaceo tom, kde hledat quotu, nebo jak to říci lépe..)
virtual_overquota_bounce = yes
virtual_maildir_limit_message = "zprava pro odesilatele, ze prijemce je matej a ma preplnenou mailovou schranku"
2.Dále je potřeba vytvořit v uvedené ceste tabulku, která je hodnotou v prvním parametru. V našem případě to vypadá následovně:
# mysql-vquota.cf
user = mailsql // zde musi byt jmeno, pod jakym se přistupuje do MySQL databaze
password = xyz // a k němu příslušné heslo...
dbname = mailsql // jméno databáze, která "drží" tabulky pro postfix
table = users // tabulka, vwe které je požadovaný údaj, tj. naše quota
select_field = quota // jméno pole, jejíž hodnotu chceme (že by quota ??)
where_field = email // pro koho hledáme hodnotu pole "select_field", zde pro konkrétní e-mailový účet
aditional_conditions = and postfix = 'y' // jen zkontroluje, zda uživatel má aktivní (platný) vrtuální účet na daném stroji
hosts = unix:/var/run/mysql/mysgld.sock // komunikační soket, pomocí kterého jednotliví démoni spolu komunikují.
3.Restartovat postfixe, nebo ho nechat natáhnout novou konfiguraci.
Doufám, že jsem to moc nepopletl, prosím o případné zkontrolování a opravu....
Have a good luck...
L.V.
jezevec
# These are only the parameters changed from a default install # see /etc/postfix/main.cf.dist for a commented, fuller version of this file. # These are changed by postfix install script readme_directory = /usr/share/doc/postfix-2.2.5/README_FILES html_directory = /usr/share/doc/postfix-2.2.5/html sendmail_path = /usr/sbin/sendmail.postfix setgid_group = postdrop command_directory = /usr/sbin manpage_directory = /usr/share/man daemon_directory = /usr/lib/postfix #newaliases_path = /usr/bin/newaliases mailq_path = /usr/bin/mailq # User configurable parameters delay_warning_time = 4h smtpd_banner = ESMTP $mail_name ($mail_version) unknown_local_recipient_reject_code = 450 smtp-filter_destination_concurrency_limit = 2 lmtp-filter_destination_concurrency_limit = 2 smtpd_sasl_path = /etc/postfix/sasl:/usr/lib/sasl2 #virtual_alias_maps = hash:/etc/postfix/virtual # our settings #inet_interfaces = all alias_database = hash:/etc/postfix/aliases alias_maps = $alias_database mail_spool_directory = /var/spool/mail home_directory = Maildir/ debug_peer_level = 2 #disable_vrfy_command = yes #show_user_unknown_table_name = no virtual_alias_maps = proxy:mysql:/etc/postfix/mysql_virtual_alias_maps.cf virtual_transport = virtual virtual_minimum_uid = 77 virtual_uid_maps = static:77 virtual_gid_maps = static:77 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 # Additional for quota support virtual_create_maildirsize = yes virtual_mailbox_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 # Omezeni velikosti prilohy a schranky #message_size_limit = 20971520 #mailbox_size_limit = 104857600 # SASL cast broken_sasl_auth_clients = yes #smtpd_recipient_restrictions = permit_sasl_authenticated,permit_mynetworks,reject_unauth_destination smtpd_recipient_restrictions = permit_sasl_authenticated,reject_unauth_destination smtpd_sasl_auth_enable = yes smtpd_sasl_local_domain = www5.domena.tld smtpd_sasl_security_options = noanonymous #smtpd_sasl_authenticated_header = yes #myorigin = $mydomain #mydomain = #mydestination = $myhostname, localhost.$mydomain, $mydomain #mydestination = $myhostname, localhost.$mydomain, $mydomain, mail.$mydomain, posta.$mydomain, webmail.$mydomain receive_override_options = no_address_mappings # TLS cast smtp_use_tls = no smtpd_use_tls = no smtpd_tls_key_file = /etc/postfix/ssl/smtpd.key smtpd_tls_cert_file = /etc/postfix/ssl/smtpd.crt smtpd_tls_CAfile = /etc/postfix/ssl/cacert.pem smtpd_tls_loglevel = 1 smtpd_tls_received_header = yes smtpd_tls_session_cache_timeout = 3600s tls_random_source = dev:/dev/urandom # MyOrigin - kdyz bude posilat maily ze serveru bez domeny, automaticky doplni dany nazev, kdyz neni zvoleno, posila #hostname serveru #myorigin = domena.tld #smtp_tls_loglevel=2 #smtpd_tls_auth_only = no #smtp_use_tls = yes #smtpd_use_tls = yes #smtp_tls_note_starttls_offer = yes #smtpd_tls_key_file = /etc/postfix/ssl/smtpd.key #smtpd_tls_cert_file = /etc/postfix/ssl/smtpd.crt #smtpd_tls_CAfile = /etc/postfix/ssl/cacert.pem #smtpd_tls_loglevel = 1 #smtpd_tls_received_header = yes #smtpd_tls_session_cache_timeout = 3600s #tls_random_source = dev:/dev/urandom #alias_maps = hash:/etc/postfix/aliases #content_filter = lmtp-filter:127.0.0.1:10025maildrop-mysql.config
# hostname - host name of your mysql server hostname 127.0.0.1 port 3306 socket /var/lib/mysql/mysql.sock database postfix dbuser postfix dbpw HESLO dbtable mailbox #not used now #timeout 5 # default_uid - default uid (number only) to use incase uidnumber attribute not # found in users mysql entry default_uidnumber 450 # default_gid - default gid (number only) to use incase gidnumber attribute not # found in users mysql entry default_gidnumber 450 # default_quota - default quota to use incase quota attribute not # found in users mysql entry default_quota 10485760S,10000C # MySQL Field definitions # # This section allows you to specify the actual attributes you # use in your Mysql record # # The example attribute mapping shown below is also the default # mapping used by maildrop in the case that any are missing # UID_FIELD - MySQL attribute which contains the users name (w or w/o domain) uid_field uid # UIDNUMBER_FIELD - MySQL attribute which contains the system uid to deliver # mail as uidnumber_field uidnumber # GIDNUMBER_FIELD - MySQL attribute which contains the system gid to deliver # mail as gidnumber_field gidnumber # MAILDIR_FIELD - MySQL attribute which contains the path to the users # custom maildir maildir_field maildir # HOMEDIRECTORY_FIELD - MySQL attribute which contains the path to the users # home directory homedirectory_field homedir # QUOTA_FIELD - MySQL attribute which contains the users quota quota_field quota # MYSQL_DEFAULT_STATUS_FIELD - MySQL attribute which could be created in the # MySQL entry to set whether or not the user is allowed to receive email on # this box.. # -- looks unused for now; but must be valid column ! (2001-11-03) mailstatus_field vmailstatus # MYSQL_DEFAULT_WHERE_CLAUSE - This is optional ! # It can be set to any fixed string starting with keyword 'AND'. # It will then be appended to the WHERE clause of our query. where_clause ""
Tiskni
Sdílej:
ISSN 1214-1267, (c) 1999-2007 Stickfish s.r.o.