On Tue, 2004-07-06 at 09:16, Tomek Jarzynka wrote:
> 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?
I'm using postfix and dbmail 1.2.8x
I see you are using lmtp try changing to smtp
--
,''`. Leonel Nunez
: :' : http://enelserver.com
`. `' DEBIAN GNU/LINUX
`- A REAL FREE OS
