#1  
Old 23rd November 2007, 21:10
40esp 40esp is offline
Member
 
Join Date: Jun 2007
Posts: 50
Thanks: 5
Thanked 2 Times in 2 Posts
Default postfix myysql quota

postfix is not applying quota given in mysql.

I followed this guide:http://howtoforge.com/virtual-users-...-mysql-fedora8

everything works great now, except for quota!
I made sure i followed the guide and i built and packaged postfix like the guide said to patch postfix to allow quota.

well I set the default quota, and It says unlimitted quota, according to my roundcube webmail installation.

postfix reads users and domains from mysql, but not quota.

how do i fix this?
Reply With Quote
Sponsored Links
  #2  
Old 24th November 2007, 18:45
40esp 40esp is offline
Member
 
Join Date: Jun 2007
Posts: 50
Thanks: 5
Thanked 2 Times in 2 Posts
Default

heres the tail end of my postfix main.cnf

Quote:
myhostname = 71-13-92-138.static.bycy.mi.charter.com
mynetworks = 127.0.0.0/8
virtual_alias_domains =
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_mailbox_base = /home/vmail
virtual_uid_maps = static:5000
virtual_gid_maps = static:5000
smtpd_sasl_auth_enable = yes
broken_sasl_auth_clients = yes
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination
smtpd_use_tls = yes
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
virtual_create_maildirsize = yes
virtual_mailbox_extended = yes
virtual_mailbox_limit_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
virtual_mailbox_limit_override = yes
virtual_maildir_limit_message = "The user you are trying to reach is over quota."
virtual_overquota_bounce = yes
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
content_filter = amavis:[127.0.0.1]:10024
receive_override_options = no_address_mappings
Reply With Quote
  #3  
Old 24th November 2007, 19:03
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

Any errors in your mail log?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #4  
Old 24th November 2007, 19:11
40esp 40esp is offline
Member
 
Join Date: Jun 2007
Posts: 50
Thanks: 5
Thanked 2 Times in 2 Posts
Default

where and how exactly do i get to that log?
Reply With Quote
  #5  
Old 24th November 2007, 19:24
40esp 40esp is offline
Member
 
Join Date: Jun 2007
Posts: 50
Thanks: 5
Thanked 2 Times in 2 Posts
Default

/var/log/maillog shows no errors.
Reply With Quote
  #6  
Old 25th November 2007, 13:02
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

I'm not sure where Roundcube gets the quota information from. But you can test if quota is working by simply sending an email that is bigger than the space that is left for the recipient account.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 25th November 2007, 16:08
40esp 40esp is offline
Member
 
Join Date: Jun 2007
Posts: 50
Thanks: 5
Thanked 2 Times in 2 Posts
Default

i just got the quota report email that came with the howto.

DAILY QUOTA REPORT:

----------------------------------------------
| % USAGE | ACCOUNT NAME |
----------------------------------------------

--



nothing is showing. no numbers, nothing. and i have quota setup for the email.
Reply With Quote
  #8  
Old 26th November 2007, 18:27
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

You might have to modify the /usr/local/sbin/quota_notify script, as shown on http://www.howtoforge.com/virtual-us...ubuntu-7.10-p5
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
The Following User Says Thank You to falko For This Useful Post:
luchs3 (25th July 2008)
  #9  
Old 25th July 2008, 14:30
luchs3 luchs3 is offline
Member
 
Join Date: Sep 2007
Posts: 68
Thanks: 7
Thanked 0 Times in 0 Posts
Default

does the setup script normally ask for the mysql server when it updates a System?
Reply With Quote
  #10  
Old 26th July 2008, 11:33
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
 
Default

What setup script?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Postfix Quota Notification Email Script asyadiqin Installation/Configuration 14 23rd July 2010 13:35
postfix + dovecot + postfixadmin - problem with quota kosta Server Operation 3 24th August 2007 22:08
Centos 4.4 32bit Hangs, High Server load 3cwired_com Server Operation 11 16th November 2006 15:47
Verify email setup meekish Installation/Configuration 28 27th October 2006 15:36
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs k1piee HOWTO-Related Questions 14 1st October 2006 13:46


All times are GMT +2. The time now is 05:09.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.