Only problem with this setup is that it would break Quotas. My mail table
has a NUMERIC column for Quotas, not Character. That is why the M was
outside the entire expression. The table contains the number of megabytes
allowed in the quota. If you can figure out a way to convert it using the
numeric value that would be much appreciated! Otherwise, when it selects the
quota, it will get values like Quota = 25 instead of Quota = 25M. I'm not so
sure Exim would like that.
----- Original Message -----
From: "Odhiambo G. Washington" <wash@???>
To: "Dan Egli" <dan@???>
Cc: "Odhiambo Washington" <wash@???>; <exim-users@???>
Sent: Monday, November 04, 2002 12:31 AM
Subject: Re: [Exim] Convert4r4 script
> * Dan Egli <dan@???> [20021104 08:40]: wrote:
> > Sure. Why not.
> >
> > http://shortcircuit.dyndns.org/exim.conf
>
>
> Hello Dan,
>
> Actually, your config file was easy to convert. It did not give me any
problems
> with the script.
>
> All I did was a slight modification:
>
> I Changed:
>
> quota = ${lookup mysql{select quota from mail where
uname='${local_part}'}{$value}{5}}M
>
>
> To:
>
> quota = ${lookup mysql{select quota from mail where
uname='${local_part}'}{$value}{5M}}
>
> in your local delivery director and then run the script
>
> ./convert4r4 < exim.conf > dan-egli-exim.conf
>
> I have not checked the output file to make sure it would work. This is
work for you
> on your server now.
>
> I have posted your file at
http://ns2.wananchi.com/~wash/Eximstats/exim.conf
> You can copy it from there.
>
>
> NB: If that mysql password in there is the valid one for your server, then
it's
> time to change it ;-)
>
>
>
>
> -Wash
>
> S y s t e m s A d m i n i s t r a t o r
> --
>
> ------=====================================-------
> |*| Odhiambo Washington Wananchi Online Ltd |*|
> |*| E: WASH@??? www.wananchi.com |*|
> |*| P: (+254)2 313 985-9 1st Floor Loita Hse |*|
> |*| F: (+254)2 313 922 Loita St., NAIROBI |*|
> ------=====================================-------
> ++
> The buffalo isn't as dangerous as everyone makes him out to be.
> Statistics prove that in the United States more Americans are killed in
> automobile accidents than are killed by buffalo.
> -- Art Buchwald
>
