[Exim] Verify this?

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: Dan Egli
Ημερομηνία:  
Προς: exim-users
Αντικείμενο: [Exim] Verify this?
Ok. I just want to make sure this is legit before I try it. I am setting up
mail quotas, and I want to have it pull the quota from a MySQL database. Now
I have a table that looks like this
+----------------+-------+----------+
| uname          | quota | pwd      |

+----------------+-------+----------+
| dan            |   250 | <hidden>   |

+----------------+-------+----------+

The quota field is an integer field. My query looks like this:

quota = ${lookup mysql{select quota from mail where
uname='${quote_mysql:local_part}'}{$value}}M

What this is intended to do is scan the database, get the # of megs allowed,
and return it with the M, so in the case above, it would return 250MB
quota.

Is this correct or would this kill me?

Thanks in advance!