On Fri, 2003-07-11 at 09:39, Jesse Norell wrote:
> Hello,
> 
>   You only have one entry in the aliases table for each user?
> (select alias,deliver_to from aliases where alias = '[EMAIL PROTECTED]')
> If so, try turning up the TRACE_LEVEL to 5 under SMTP section of
> dbmail.conf and provide that same info.
> 
> Jesse

Thank you all for your time on this. The issue was my own typo. When I
put the trace level on 5 this time I noticed that it was trying to
deliver to a recipient "-u". 

My custom script runs through spamc and uses the "-e" option to pipe
directly to dbmail-smtp. Unfortunately I put the -u option for spamc
after the dbmail-smtp command, so my line was like this:

cat - | spamc -f -e /usr/sbin/dbmail-smtp -d $recipient -u $recipient

Yeah, silly mistake. I had checked out the tracelevel 5 before, but just
missed this.

Thanks again!
--
Ryan

> ---- Original Message ----
> From: Ryan Parr <[email protected]>
> To: [email protected]
> Subject: Re: [Dbmail] [dbmail-smtp] Two of every message [was dbmail-pop3d]
> Sent: 11 Jul 2003 09:29:09 -0600
> 
> > On Thu, 2003-07-10 at 18:19, Jeff Brenton wrote:
> > > Hello Ryan,
> > > 
> > > RP> For some reason all e-mails are being delivered to the client
> > > RP> twice. I have literally no idea where to go with this. I've
> > > RP> searched google and the dbmail archives and have come up empty
> > > RP> handed, though perhaps I've been searching the wrong terminology.
> > > 
> > > RP> userid: [EMAIL PROTECTED]
> > > RP> alias: [EMAIL PROTECTED] delivered to:
> > > RP> [EMAIL PROTECTED]
> > > 
> > > RP> I had decided that this was the way to setup mass virtual domains,
> > > RP> but is this the best way? My users are accustomed to using their
> > > RP> complete e-mail address to login.
> > > 
> > > Does the alias table entry have '[EMAIL PROTECTED]' in the
> > > deliver_to column, or the number of the inbox for this user? If it
> > > doesn't have the mailbox ID number, it may be looping to deliver...
> > 
> > My mistake, the deliver_to column is indeed pointing to the user_idnr
> > field. So that's correct. From watching the logs it looks like it's
> > actually inserting the message twice. The relevant lines from the posted
> > log output being:
> > 
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: insert_messages(): message
> > id=8891, size=822 is inserted
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: insert_messages(): message
> > id=8890, size=822 is inserted
> > 
> > Does this ring any bells for anyone? Or is this a known bug by any
> > chance? If more info is needed I'm happy to provide it.
> > 
> > Thanks again!
> > --
> > Ryan
> > 
> > 
> > Relevant Log Output
> > ========================================================
> > Jul 11 09:22:02 mail1 postfix/smtpd[12272]: connect from
> > tjc-hq[24.117.177.127]
> > Jul 11 09:22:02 mail1 postfix/smtpd[12272]: A98127000C:
> > client=tjc-hq[24.117.177.127]
> > Jul 11 09:22:03 mail1 postfix/cleanup[12274]: A98127000C:
> > message-id=<[EMAIL PROTECTED]>
> > Jul 11 09:22:03 mail1 postfix/qmgr[12270]: A98127000C:
> > from=<[EMAIL PROTECTED]>, size=635, nrcpt=1 (queue active)
> > Jul 11 09:22:03 mail1 spamd[12805]: connection from mail1 [127.0.0.1] at
> > port 48450
> > Jul 11 09:22:03 mail1 spamd[12280]: processing message
> > <[EMAIL PROTECTED]> for dbmail:511.
> > Jul 11 09:22:03 mail1 postfix/smtpd[12272]: disconnect from
> > tjc-hq[24.117.177.127]
> > Jul 11 09:22:04 mail1 spamd[12280]: clean message (-0.7/6.0) for
> > dbmail:511 in 1.1 seconds, 617 bytes.
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): starting
> > procedure
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): found [DBMAIL]
> > tag
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): no value
> > specified for service item [].
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): item [host]
> > value [localhost] added
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): item [user]
> > value [dbmail] added
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): item [pass]
> > value [mailm0nkey] added
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): item [db] value
> > [dbmail] added
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): no value
> > specified for service item [].
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): item
> > [TRACE_LEVEL] value [0] added
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): service [DBMAIL]
> > added
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): config for
> > [DBMAIL] read, found [5] items
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): starting
> > procedure
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): found [SMTP] tag
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): item [SENDMAIL]
> > value [/usr/sbin/sendmail] added
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): item
> > [DBMAIL_FROM_ADDRESS] value [EMAIL PROTECTED] added
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): item
> > [POSTMASTER] value [EMAIL PROTECTED] added
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): item
> > [AUTO_NOTIFY] value [no] added
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): item
> > [AUTO_REPLY] value [yes] added
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): item
> > [TRACE_LEVEL] value [0] added
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): service [SMTP]
> > added
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: ReadConfig(): config for
> > [SMTP] read, found [6] items
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: GetConfigValue(): searching
> > value for config item [trace_level]
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: GetConfigValue(): found value
> > [0]
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: insert_messages(): message
> > id=8891, size=822 is inserted
> > Jul 11 09:22:04 mail1 dbmail/smtp[12279]: insert_messages(): message
> > id=8890, size=822 is inserted
> > Jul 11 09:22:04 mail1 postfix/pipe[12276]: A98127000C:
> > to=<[EMAIL PROTECTED]>, relay=dbmail, delay=2, status=sent
> > (thejamescompany.com)
> > 
> > 
> > _______________________________________________
> > Dbmail mailing list
> > [email protected]
> > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> > 
> -- End Original Message --
> 
> 
> --
> Jesse Norell
> jesse (at) kci.net
> 
> 
> _______________________________________________
> Dbmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
> 

Reply via email to