[tpop3d-discuss] newbie in using tpop3

[Giuseppe Di Pierri]

ok, thanks Ghris.

now I have installed on freebsd4.7-release the exim-4.10-1 (with-mysql
active and default configuration) and tpop3 (most recent).

I locally created the mysql database 'mail' and the its tables:
--- start of tpop3.conf file ---
create table domain (
        domain_name varchar(255) primary key, # domain name
        unix_user varchar(255),               # which Unix user owns files
etc.
        password_hash varchar(255),           # admin password for this
domain
        path varchar(255),                    # base path for this domain
        max_popbox int                        # maximum number of popboxes
in
) ;                                           # this domain

# local POP boxes (virtual)
create table popbox (
        domain_name varchar(255) not null,    # domain this refers to
        local_part varchar(255) not null,     # username for this POP box
        password_hash varchar(255),           # hash of this user's password
        mbox_name varchar(255),               # appended to domain.path
        primary key (domain_name(8), local_part(8))
) ;

insert into domain values ('bordeaux',
'<myuser>','<mypassword>','/var/mail/bordeaux',1000);
insert into popbox values ('bordeaux', 'pino','upino','pino');
insert into popbox values ('bordeaux', 'pino1','upino','pino1');
insert into popbox values ('bordeaux', 'pino2','upino','pino2');
--- end of db ----

I configured tpop3.conf file as follows:
--- start of tpop3.conf file ---
listen-address: 0.0.0.0
max-children: 20

mailbox: bsd:/var/mail/$(domain)/$(user)

auth-mysql-enable: yes

auth-mysql-hostname: localhost

auth-mysql-database: mail

auth-mysql-username:

auth-mysql-password:

auth-mysql-pass-query: \
SELECT CONCAT(domain.path, '/', popbox.mbox_name),
          popbox.password_hash, domain.unix_user, 'bsd'
      FROM popbox, domain
      WHERE popbox.local_part = $(local_part)
      AND popbox.domain_name = $(domain)
      AND popbox.domain_name = domain.domain_name
--- end of tpop3.conf file ---
[no password and user is needed to have access to the database 'mail']

I killed -HUP the tpop3 pid.

1. Now should I configure exim to have access to the database 'mail'? and
how?

2. How to put everything together and see my great mail server taking off?

Thanks in advance for being patient and for your help.

pino

> -----Original Message-----
> From: tpop3d-discuss-admin@lists.beasts.org
> [mailto:tpop3d-discuss-admin@lists.beasts.org]On Behalf Of Chris
> Lightfoot
> Sent: Donnerstag, 9. Januar 2003 12:55
> To: dipierri@arpage.ch
> Cc: tpop3d-discuss@lists.beasts.org
> Subject: Re: [tpop3d-discuss] newbie in using tpop3
>
>
> On Thu, Jan 09, 2003 at 12:32:50PM +0100, Giuseppe Di Pierri wrote:
> > Hi everybody,
> >
> > I'm a newbie user of tpop3 (and of many other things :-( ), thus help is
> > appreciated.
> >
> > My need is to have a complete mail server (pop and smtp) whos
> administration
> > is a web application that accesses a mysql database (create new
> domain or
> > user and thing like that).
> >
> > Can I use tpop3 and sendmail together in order to achieve this goal?
> > or do I have to install things like exim or something else?
>
> It's certainly possible to have sendmail decide how to do
> deliveries based on a MySQL database. I don't know how to
> do it, though, and the support is built in to exim and is
> very easy to use. My guess is that you'd be better to use
> exim, if you haven't much experience of sendmail.
>
> --
> ``Her vocabulary was as bad as, like, whatever.''
>   (allegedly found in a high school essay)
>
> _______________________________________________
> tpop3d-discuss mailing list
> tpop3d-discuss@lists.beasts.org
> http://lists.beasts.org/mailman/listinfo/tpop3d-discuss
>