Awesome, I finally got it working :)
Thank you so much!
Joey.
----- Original Message -----
From: <sharun@???>
To: "Joey Olson" <joey@???>
Cc: <exim-users@???>
Sent: Wednesday, July 24, 2002 5:53 AM
Subject: Re: [Exim] exim, virtual users & mysql
> It is not difficult.
> U'll need to add:
> 1. In ACL_check_rcpt section: condition, that checks
> validity of RCPT To: user
> Looks like:
>
> deny domains = yourdomain.tld
> !condition = \
> ${lookup mysql{select username from user where
username='$local_part'}{yes}{no}}
> message = <$local_part@$domain>... no such user
>
> you may spcify another checks (deleted mailbox, over quota, etc..) and
> acl_check_rcpt for your virtual domains must ends with:
>
> accept domains = yourdomain.tld
> endpass
> verify = recipient
>
> 2. In routers section: router, that points mail for virtual domains
> to virtuser_delivery transport
>
> that's easy:
> virtdomain:
> driver = accept
> transport = virtual_delivery
> domains = yourdomain.tld
>
> 3. In transport section: specify transpor, that put mail
> to virtual user dir.
>
> virtual_delivery:
> driver = appendfile
> file = /var/mail/$local_part
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Here you must specify SELECT from your
database,
> that points exim where to store mail for $local_part
> delivery_date_add
> envelope_to_add
> return_path_add
> group = somegroup
> user = someuser
> mode = 0660
>
> Of course, you may specify domain_list in 'domains=' and serving unlimited
> numbers of virtual domains by that cheme.
>
>
> Joey Olson wrote:
> > Greetings All,
> >
> > I would like to install/configure exim to deliver mail to virtual users
who
> > do not have an actual account on the machine (no entry for them in
> > /etc/passwd).
> >
> > I currently have all their account information (username, password,
domain
> > name etc) stored in a mysql database and have a web based login area
that
> > authenticates/interacts with it fine. I would like to have exim set up
so
> > when mail for joey@??? comes in, it checks to see if joey
exists in
> > the mysql table and if so, it puts the mail into
> > /var/spool/mail/virtualuser/joey (Helping a friend set up a hotmail-like
> > service).
> >
> > >From the docs I have looked at, I know it is possible, I just haven't
found
> > a clear-cut guide/doc detailing how to do so.
> >
> > If you would be so kind to point me in the proper direction, it would be
> > much appreciated.
> >
> > Thanks a bunch,
> > Joey.
> >
> >
> >
> >
> >
> > --
> >
> > ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim
details at
http://www.exim.org/ ##
> >
>
> --
> VVS56-RIPE
>
> --
>
> ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim
details at
http://www.exim.org/ ##
>
