Virtual mailboxes

Mon Jan 13 03:28:27 EST 2003

Hello

Talking about virtual domains or virtual mailboxes. I have a linux box with
sasl 2.1.9 and cyrus 2.1.9, Sasl was compiled with support for MySLQ like
this.

export LIBS="-lz"
./configure --prefix=/usr/local --disable-krb4 --disable-gssapi --with-dbpat
h=/etc/sasldb2 \
--with-dblib=berkeley --with-bdb-libdir=/usr/local/BerkeleyDB.4.1/lib \
--with-dbd-incdir=/usr/local/BerkeleyDB.4.1/include --disable-otp --disable-
pwcheck \
--enable-plain --with-mysql

The configure process looks fine, and the same for make and make install
command.

After that, cyrus-imapd-2.1.9 is compiled and installed with the following
options

./configure --prefix=/usr/local --with-state=/var/state --with-dbdir=/usr/lo
cal/BerkeleyDB.4.1 \
--with-auth=unix --enable-sieve --enable-server --with-perl=/usr/bin/perl --
without-krb \
--disable-gssapi --with-sasl=/usr/local/lib/sasl2
make depend
make all CFLAGS=-O
make install

And here is my problem, i planning to configure imap with virtual domains
support , firts i´m trying to use the sasldb2 but i can´t (sorry, i´m a
newbie). Then, looking for some materials in internet, i found
the --with-mysql options in saslv2 and is that i trying today :).

here is my imapd.conf file

servername: xxx.net
configdirectory: /var/imap/xxx.net
partition-default: /var/spool/imap/xxx.net
admins: cyrus root
altnamespace: yes
allowanonymouslogin: no
allowplaintext: yes
#sasl_mech_list: PLAIN
sasl_pwcheck_method: auxprop
sasl_mysql_user: mail
sasl_mysql_passwd: xxx
sasl_mysql_hostnames: localhost
sasl_mysql_database: mail
sasl_mysql_statement: select password from accountuser where username = '%u'
and domain_name = '%r'
sasl_mysql_verbose: yes

In mysql server i have  a database named mail and i have added for it

mysql>use mysql;
mysql>insert into user (host,user,password,..............) values
('localhost','mail','xxx');
mysql>use mail;
mysql>insert into accountuser (unsername,password,domain) values
('cyrus',PASSWORD('test'),'xxx.net');

That´s all that i have configure but the log look very ugly when a try to
log with cyradm.

#su cyrus
#cyradm 192.168.1.172

Jan 13 10:16:50 llus imapd[28754]: mysql plugin try and connect to localhost
Jan 13 10:16:50 llus imapd[28754]: mysql plugin couldnt connect to any host
Jan 13 10:16:50 llus imapd[28754]: unable to open Berkeley db /etc/sasldb2:
No such file or directory
Jan 13 10:16:50 llus imapd[28754]: unable to open Berkeley db /etc/sasldb2:
No such file or directory
Jan 13 10:16:50 llus imapd[28754]: mysql plugin Parse the username cyrus
Jan 13 10:16:50 llus imapd[28754]: mysql plugin try and connect to a host
Jan 13 10:16:50 llus imapd[28754]: mysql plugin try and connect to localhost
Jan 13 10:16:50 llus imapd[28754]: mysql plugin couldnt connect to any host
Jan 13 10:16:50 llus imapd[28754]: badlogin: factorysoft.net[192.168.1.172]
plaintext cyrus SASL(-13): user not found: checkpass failed
ene 13 10:17:03 llus su(pam_unix)[28757]: session closed for user cyrus

i think the problem can be the mech used to insert the password into the
user table

can any one advise about my problem?

thanks in advanced

Danny

----- Original Message -----
From: "Ken Murchison" <ken at oceana.com>
To: "Joe Ellis" <joee at lithodyne.net>
Cc: <info-cyrus at lists.andrew.cmu.edu>
Sent: Friday, January 10, 2003 11:33 PM
Subject: Re: Virtual mailboxes

> If you want to try 2.2 from CVS, you want to check out tag
> cyrus-imapd-2_2
>
>
>
> Joe Ellis wrote:
> >
> > Yeah.  thats exactly what I want.  ...i just built a new mail server too
> > using cyrus-imap 2.1.11.
> >
> > Thanks.
> >
> > Ken Murchison wrote:
> > > Sounds to me like you want virtual domain support.  This is part of
> > > Cyrus 2.2 (which is in CVS).  Here is some docs:
> > >
> > >
http://bugzilla.andrew.cmu.edu/cgi-bin/cvsweb.cgi/~checkout~/src/cyrus/doc/A
ttic/install-virtdomains.html?rev=1.1.2.5&content-type=text/html&hideattic=0
> > >
> > >
> > > Joe Ellis wrote:
> > >
> > >>Is there a way to have cyrus deliver mail to a mailbox based on the
domain?
> > >>
> > >>for example, if joee at lithodyne.net has mail deliverd, it goes to
> > >>user/lithodyne.net/joee.  If joee at andrew.cmu.edu has mail delivered,
it
> > >>goes to user/andrew.cmu.edu/joee.
> > >>
> > >>I'm trying to eliminate usernames as the email address.  Currently, I
> > >>have cyrus setup so the mailbox is user/joee at lithodyne.net.  So the
> > >>username is joee at lithodyne.net and not just joee.  I'd like to have
the
> > >>user as joee no matter what domain.
> > >>
> > >>I use postfix as the mta.  Maybe I should write a wrapper for deliver
so
> > >>postfix will extract the username and domain and pass the correct
> > >>mailbox to cyrus.
> > >>
> > >>Anyone doing this?
> > >>
> > >>I hope I'm clear on what I'm asking.
> > >>
> > >>--
> > >>Joe Ellis
> > >>http://www.lithodyne.net
> > >>Jas 5:7,8
> > >
> > >
> >
> > --
> > Joe Ellis
> > http://www.lithodyne.net
> > Jas 5:7,8
>
> --
> Kenneth Murchison     Oceana Matrix Ltd.
> Software Engineer     21 Princeton Place
> 716-662-8973 x26      Orchard Park, NY 14127
> --PGP Public Key--    http://www.oceana.com/~ken/ksm.pgp
>
>