From: Alejandro Cabrera Obed (acabrerasintys.gov.ar)
Date: Fri Jul 27 2007 - 09:52:46 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

John Beaver wrote:
> Alejandro Cabrera Obed wrote:
>> Dear people, I want to use policyd in order to set up message size
>> limits to my virtual domain mail users. I installed postfix-policyd,
>> configured postfix-policyd.conf for sender throttling, setup de throttle
>> table from mysql with users/message_sizes but I don't know how to set up
>> the main.cf from postfix.
>>
>> In my actual main.cf I have:
>>
>> smtpd_recipient_restrictions =
>> check_recipient_access hash:/etc/postfix/access
>> check_policy_service inet:127.0.0.1:10031
>> permit_mynetworks
>> reject_unauth_destination
>>
>> What rules do I have to add in the smtpd_recipient_restrictions and in
>> which order ???
>
> I answered you on the policyd list but I guess your still having issues.
> One thing I did not mention which could be an issue with you. Most
> email clients (read outlook, outlook express, and others) do NOT
> provide the size of the email during transmission.
>
> Check out this message for a solution for sender based quota's.
> http://sourceforge.net/mailarchive/message.php?msg_name=4446886E.1050908%40leaveittobeaver.net
>
>
> Here is the thread for all the gory details.
> http://sourceforge.net/mailarchive/forum.php?thread_name=443D67DF.1030903%40seven.com.br&forum_name=policyd-users
>
>
>
> John Beaver

John and people from the list, thanks for your help. I was reading and
trying again with the postfix & postfix-policyd packages in order to do
only *THROTTLING*. I put in my main.cf as you mentioned:

smtpd_recipient_restrictions =
        check_recipient_access hash:/etc/postfix/access
        permit_mynetworks
        reject_unauth_destination

smtpd_end_of_data_restrictions =
        check_policy_service inet:127.0.0.1:10031
        permit_mynetworks

In postfix-policyd.conf I established the default message size limit:

SENDERMSGSIZE=2840000

But when I send a message to outbound using the ICEDOVE 1.5 mail client
I get the error: "The size of the message exceeds the global size limit
(10240000 bytes) of the server"....but my default limit was established
to 2840000 as I said, and it's not read I think. The 10240000 bytes is
the postfix default message size limikt, and this is read.....and
nothing appears in the debug log.

When I send a message without attach and send it to myself:

Jul 27 11:37:01 mail2 postfix/smtpd[32683]: connect from unknown[10.4.4.4]
Jul 27 11:37:01 mail2 postfix/smtpd[32683]: 7456C3DA9:
client=unknown[10.4.4.4]
Jul 27 11:37:01 mail2 postfix/cleanup[32236]: 7456C3DA9:
message-id=<46AA05A6.8090505sintys.gov.ar>
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 select(): fd 11 is
ready for read
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd 11: w_read: returning
-2 after reading 484 bytes
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][0]:request=smtpd_access_policy
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][1]:protocol_state=end-of-message
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][2]:protocol_name=esmtp
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][3]:client_address=10.64.64.42
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][4]:client_name=unknown
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][5]:reverse_client_name=unknown
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][6]:helo_name=[10.64.64.42]
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][7]:sender=acabrerasintys.gov.ar
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][8]:recipient=acabrerasintys.gov.ar
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][9]:recipient_count=1
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][10]:queue_id=7456c3da9
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][11]:instance=7fab.46aa030d.6f8fa.0
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][12]:size=114229
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][13]:etrn_domain=
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][14]:sasl_method=
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][15]:sasl_username=
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][16]:sasl_sender=
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][17]:ccert_subject=
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][18]:ccert_issuer=
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][19]:ccert_fingerprint=
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][20]:encryption_protocol=_policy
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][21]:encryption_cipher=-o
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][22]:encryption_keysize=0
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][23]: encryption_protocol=.54.222
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][24]:encryption_cipher==0
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
policy_array[11][25]:encryption_keysize=0
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 host_array[11][0]:
unknown
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 host_array[11][2]:
10.4.4.4
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 host_array[11][3]:
10.4.4.%
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 host_array[11][4]:
10.4.%.%
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 host_array[11][5]:
10.%.%.%
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 host_array[11][6]:
acabrera
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 host_array[11][7]:
sintys.gov.ar
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 host_array[11][8]:
acabrera
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 host_array[11][9]:
sintys.gov.ar
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
triplet_array[11][0]: 10.4.4
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
triplet_array[11][1]: acabrerasintys.gov.ar
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
triplet_array[11][2]: acabrerasintys.gov.ar
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
triplet_array[11][3]: 114229
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
triplet_array[11][5]: 10.4.4.4
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11
triplet_array[11][6]: 7fab.46aa030d.6f8fa.0
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 checking throttle
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 db_charquery():
SELECT _from,_count_max,_count_cur,_date,_quota_cur,_quota_max,
_time_limit,_mail_size,_count_tot,_rcpt_max,_rcpt_cur,_rcpt_tot,
_log_warn, _log_panic, _abuse_tot FROM throttle WHERE
_from='acabrerasintys.gov.ar' OR _from='sintys.gov.ar' ORDER BY
_priority DESC LIMIT 1
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 0 data:
acabrerasintys.gov.ar (recieved)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 0 data:
acabrerasintys.gov.ar (extracted)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 1 data: 0
(recieved)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 1 data: 0
(extracted)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 2 data: 4
(recieved)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 2 data: 4
(extracted)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 3 data:
1185546169 (recieved)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 3 data:
1185546169 (extracted)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 4 data: 7746
(recieved)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 4 data: 7746
(extracted)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 5 data: 0
(recieved)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 5 data: 0
(extracted)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 6 data: 0
(recieved)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 6 data: 0
(extracted)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 7 data:
16000000 (recieved)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 7 data:
16000000 (extracted)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 8 data: 11
(recieved)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 8 data: 11
(extracted)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 9 data: 0
(recieved)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 9 data: 0
(extracted)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 10 data: 4
(recieved)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 10 data: 4
(extracted)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 11 data: 11
(recieved)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 11 data: 11
(extracted)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 12 data: 0
(recieved)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 12 data: 0
(extracted)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 13 data: 0
(recieved)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 13 data: 0
(extracted)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 14 data: 0
(recieved)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 14 data: 0
(extracted)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11, db_optquery():
SELECT COUNT(_instance) from throttle_from_instance WHERE
_instance='7fab.46aa030d.6f8fa.0'
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 0 data: 0
(recieved)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 row: 0 data: 0
(extracted)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 db_doquery():
INSERT DELAYED INTO throttle_from_instance (_instance,_expire) VALUES
('7fab.46aa030d.6f8fa.0',1185547021)
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 checking throttle-from
Jul 27 11:37:01 mail2 postfix-policyd: rcpt=227, throttle=update(a),
host=10.64.64.42, from=acabrerasintys.gov.ar,
to=acabrerasintys.gov.ar, size=114229/16000000, quota=121975/250000000,
count=5/512(12), rcpt=5/3600(12), threshold=0%|0%|0%
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 db_doquery():
UPDATE throttle SET _rcpt_cur=_rcpt_cur+1, _rcpt_tot=_rcpt_tot+1,
_quota_cur=_quota_cur+114229, _count_cur=_count_cur+1,
_count_tot=_count_tot+1, _abuse_cur=0 WHERE _from='acabrerasintys.gov.ar'
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 select(): fd 11 is
ready for write
Jul 27 11:37:01 mail2 postfix-policyd: DEBUG: fd: 11 returning after 14
bytes of data written

I'll appreciatte your help.

Regards,

Alejandro

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]