On Tuesday 06 of July 2004 14:35, Leonel Nunez wrote:
> What I did is
>
> Add user to the users table
> add alias to the aliases table
> add a mailbox to the mailboxes table
INSERT INTO users VALUES
(1,'[EMAIL PROTECTED]@__','',0,0,0,'md5','1979-11-03
22:05:58',NULL);
INSERT INTO users VALUES (2,'test','XXX',0,0,17574480,'','2004-07-02
12:51:38',1);
INSERT INTO users VALUES (4,'foo','XXX',0,0,0,'','0000-00-00 00:00:00',0);
INSERT INTO aliases VALUES (1,'[EMAIL PROTECTED]','2',0);
INSERT INTO aliases VALUES (3,'[EMAIL PROTECTED]','4',0);
INSERT INTO mailboxes VALUES (1,2,'INBOX',1,1,1,1,1,0,0,0,2);
INSERT INTO mailboxes VALUES (2,1,'INBOX',1,1,1,1,1,0,0,0,2);
INSERT INTO mailboxes VALUES (3,2,'Trash',0,0,0,0,0,0,0,0,2);
INSERT INTO mailboxes VALUES (4,2,'Sent',0,0,0,0,0,0,0,0,2);
INSERT INTO mailboxes VALUES (5,2,'Draft',0,0,0,0,0,1,0,0,2);
INSERT INTO mailboxes VALUES (6,4,'INBOX',1,1,1,1,1,0,0,0,2);
INSERT INTO mailboxes VALUES (7,4,'Draft',0,0,0,0,0,1,0,0,2);
INSERT INTO mailboxes VALUES (8,4,'Trash',0,0,0,0,0,0,0,0,2);
INSERT INTO mailboxes VALUES (9,4,'Sent',0,0,0,0,0,0,0,0,2);
And it just doesn't work. The user gets no mail from sendmail.
By the way, sendmail sends out a whole lot of logs, among others:
Jul 6 17:11:03 daimonion dbmail/lmtpd[2515]: dbmysql.c,db_query: executing
query [SELECT deliver_to FROM aliases WHERE lower(alias) =
lower('@arista.ath.cx')]
Jul 6 17:11:03 daimonion dbmail/lmtpd[2515]: authsql.c,auth_check_user_ext:
user @arista.ath.cx not in aliases table
Jul 6 17:11:03 daimonion dbmail/lmtpd[2515]: dsn.c, dsnuser_resolve_list:
domain [EMAIL PROTECTED] found total of [0] aliases
WTF?
--
tomasz k. jarzynka / 601 706 601 / tomee(a-t)kadu(d-o-t)net
"There are two major products that come out of Berkeley: LSD and UNIX. We
don't believe this to be a coincidence.
-- Jeremy S. Anderson "
