Daily Quota report empty

[dbau]

Hello,
I used Falko's "Virtual Users And Domains With Postfix, Courier And MySQL (+
SMTP-AUTH, Quota, SpamAssassin, ClamAV) howto on Debian, everything works nicely - great howto by the way - only the daily quota report looks a bit anemic every time:

====begin====
DAILY QUOTA REPORT:

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

--
My Company

====end====

There are multiple virtual domains and users in the mysql database,
and the virtual_mailbox_base variable in main.cf is set to /home/vmail.

Thanks for any hints/pointers,

Daniel

[falko]

Did you save the quota_notify script with Unix linebreaks?
Also make sure you produced no syntax error when you modified the script.

[dbau]

Thanks for your fast response, Falko!
I used 'wget' to download the file, and after I edited the variables at the top I issued the command 'chmod 755 quota_notify'. (I did the entire procedure a couple of times during troubleshooting.) I also couldn't find any syntax errors. Could it be that the quota patch for Postfix wasn't applied correctly by me? Is there a way to find out, and would it be possible to (re-)apply the patch?
Daniel

[falko]

I think the script works independently from the Postfix quota patch.
Do you get any errors when you run
/usr/local/sbin/quota_notify
on the shell?

[dbau]

No errors...

debian:~#
debian:~# /usr/local/sbin/quota_notify
debian:~#

All I get is the (almost) empty Daily Quota Report email.

Daniel

[falko]

To be honest I don't know what's wrong... :confused:

[rafota]

This is because the mailbox is nearly empty (integer percent is zero).

Edit "/usr/local/sbin/quota_notify" and change:


close(QF);
next if (! $used);
my $percent = int($used / $quota * 100);
$lusers{$user} = $percent unless not $percent;


by:


close(QF);
next if (! $used);
my $percent = int($used / $quota * 100);
$lusers{$user} = $percent;


and the report becomes:

DAILY QUOTA REPORT:

----------------------------------------------
| % USAGE | ACCOUNT NAME |
----------------------------------------------
| 0 | user@domain.com |
----------------------------------------------

[justiceiro_df]

This is because the mailbox is nearly empty (integer percent is zero).

Edit "/usr/local/sbin/quota_notify" and change:


close(QF);
next if (! $used);
my $percent = int($used / $quota * 100);
$lusers{$user} = $percent unless not $percent;


by:


close(QF);
next if (! $used);
my $percent = int($used / $quota * 100);
$lusers{$user} = $percent;


and the report becomes:

DAILY QUOTA REPORT:

----------------------------------------------
| % USAGE | ACCOUNT NAME |
----------------------------------------------
| 0 | user@domain.com |
----------------------------------------------


I' ve made this sujest chanche but still not work. As told, I execute in shell lines, I have no errors. And got a empty mail. My virtual home isn´t in /home/vmail. I made a separate partition to it. It's could be the problem ???

[gonzalezmfrank]

it doesnt work to me too...

my virtual_mailbox_base variable in main.cf is set to /home/vmail too and there are some domain and users there..

[dedez]

I've the same problem, my daily report dosn't show ANY user!!

Any idea on what's wrong?

[falko]

Do you get any errors when you run
/usr/local/sbin/quota_notify
manually?

[dedez]

..i've got NO errors running the script..it simply generate the report, without any users listed..
i've take a look inside the script and it seams it look for
/home/vmail/domain.com/user/maildirsize
but in my users dir i've no "maildirsize" file..

[dedez]

gotcha!
in your tutorial you made a little mistake..
you write

postconf -e 'virtual_mailbox_extended = yes'


but this is wrong..it should be

postconf -e 'virtual_maildir_extended = yes'


hope this help

[falko]

Thanks! I've had this in my recent Fedora 10 guide already, but I've now corrected it in my other guides as well. :)