Re: [tpop3d-discuss] TPOP3D+VMAIL-SQL+MAILDIR

[Odhiambo Washington]

* Chris Lightfoot <address@hidden> [20020224 14:55]: wrote:
> On Sun, Feb 24, 2002 at 02:43:48PM +0300, Odhiambo Washington wrote:
> > I have several virtual accounts whose mail is in
> > /var/spool/virtual/$(domain)/$(user).
> > I manage these accounts using vmail-sql.
> > 
> > I am wondering if someone has already done this such that the mail can be
> > delivered to a maildir format for virtual users, something almost the same -
> > /var/spool/virtual/$(domain)/$(user)/Maildir
> > 
> > It would appear that to do this one has to change the
> > code for vmail-sql and tpop3d and even modify the MTA
> > configuration (I use Exim) to deliver to Maildir, yes?
> 
> You don't need to modify the tpop3d code-- just change the
> rows in the database to refer to .../Maildir, change the
> auth-mysql-...-query directives in the config file to
> return `maildir' rather than `bsd', and away you go. You
> can also mix mailbox types by putting the mailbox type in
> another database field.


Hmm, easier said than done 'by me'. The only SQL that I know
so far I learnt when it became apparent that the solution I was
working on would use tpop3d+vmail-sql. I will brood over this for
a few days to see if I can come out with something. One other thing
in my situation is to try and see if courier-imap will be able to
access those mailboxes while at the same time also accessing the
ones for those users who have home directories on the same system.
I am just starting up with courier-imap so that I can kick out
imap-uw.

Seems quite complicated for me on a Sunday afternoon<G>

> You may need to make minor changes to the vmail-sql code.

Looks like it's gonna be a big issue for me this one. No knowledge
of perl....

> > My main plan is to give these virtual users webmail
> > access using courier-imap (authmysql).
> 
> OK. My long term plan is to implement an IMAP server for
> this application. But this will obviously make some
> demands upon my Copious Free Time(TM).

Take it easy, man. You're doing a wonderful job already. 


-Wash

S y s t e m s   A d m i n.

-- 
Odhiambo Washington  <address@hidden>    "The box said 'Requires
Wananchi Online Ltd.  www.wananchi.com      Windows 95, NT, or better,'
Tel: 254 2 313985-9   Fax: 254 2 313922     so I installed FreeBSD."   
GSM: 254 72 743 223   GSM: 254 733 744 121  This sig is McQ!  :-)

++
Miss, n.:
        A title with which we brand unmarried women to indicate that
they are in the market.
                -- Ambrose Bierce, "The Devil's Dictionary"