Re: Forwarding mails to multiple mailboxes

What should dbmail-users -l xxxx at xxxxx dot comm be
displaying if I
correctly setup mail forwarding using the -t switch?

Jamie

On 8/25/05, Jamie Doherty <jamiedohertygmail.com> wrote:
> I have pasted the session:
> 
> [rootmachine ~]# dbmail-users -c xxxxx at xxxxx -t yyyyy
at yyyyy
> Opening connection to database...
> Opening connection to authentication...
> Ok. Connected
> Performing changes for user [xxxxx at xxxxx]...
> Done
> [rootmachine ~]# dbmail-users -l xxxxx at xxxxx
> Opening connection to database...
> Opening connection to authentication...
> Ok. Connected
> Info for user [xxxxx at xxxxx]
> User ID         : 11
> Username        : xxxxx at xxxxx
> Client ID       : 0
> Max. mailboxsize: 0.00 MB
> Quotum used     : 0.06 MB (inf%)
> 
> Aliases:
> 
> [rootmachine ~]#
> 
> Everything looks just as if the user was just created. 
What shoud it
> be displaying?
> 
> Jamie
> 
> On 8/25/05, Paul J Stevens <paulnfg.nl> wrote:
> > If you're trying to add a forward for 'user at
domain dot com' what does
> > the output of dbmail-users -l 'user at domain dot
com' have to say?
> >
> > Jamie Doherty wrote:
> > > I am trying to forward emails to multiple
mailboxes using the command:
> > >
> > > dbmail-users -c user at domain dot com -t 2nd
at domain dot com.
> > >
> > > Nothing is happening, I don't see any new
entries in the alias table
> > > and emails are being delivered.  I am running
dbmail 2.0.4 and using
> > > qmail to deliver to dbmail (is that my
problem?)
> > >
> > > Jamie
> > >
_______________________________________________
> > > Dbmail mailing list
> > > Dbmaildbmail.org
> > > htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> > >
> >
> > --
> > 
____________________________________________________________
____
> >  Paul Stevens                                     
paul at nfg.nl
> >  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
> >  The Netherlands________________________________http://www.nfg.nl
> > _______________________________________________
> > Dbmail mailing list
> > Dbmaildbmail.org
> > htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
>
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Jamie,

Forget about dbmail-users. Look at the tables directly.
dbmail-users
won't show *everything*. In fact it doesn't show forwards at
all (in 2.0).


if you want to have multiple users receive the same address:

1) two local dbmail users receive foobar.com

dbmail_users:

userid                 | user_idnr
-----------------------+-------------------------
john                   | 3
barbara                | 4

dbmail_aliases:

alias                  | deliver_to
-----------------------+-------------------------
foobar.com            | 3
foobar.com            | 4


equivalent but convoluted:

alias                  | deliver_to
-----------------------+-------------------------
johnhere.org          | 3
barbarahere.org       | 4
foobar.com            | johnhere.org
foobar.com            | barbarahere.org


2) foobar.com forwarded to two external addresses

alias                  | deliver_to
-----------------------+-------------------------
foobar.com            | johnthere.org
foobar.com            | barbarathere.org


Lookups are fully recursive, so anything in the deliver_to
field is
looked up in dbmail_users.user_idnr, and if that doesn't
yield a valid
result, it is matched against dbmail_aliases.alias. If that
matches the
whole cycle is restarted with the result.

And this goes on and on, until either a user_idnr is found
(local
delivery), or a address is found which doesn't belong to a
local user
(external forward), or until the maximum recursion level is
reached (error).

capice?

Now what is *your* setup? I'm guessing you're confused
because you're
using addresses as userids. (which makes sense, in a
way...).

And pulleez, be done with the at dot com trip'n. Some
clarity will help;
'someuser at blah dot com' is *not* a valid userid --
'someuserblah.com' *is*. Feel free to anonymize, but leave the
syntax
intact.


Jamie Doherty wrote:
> What should dbmail-users -l xxxx at xxxxx dot comm be
displaying if I
> correctly setup mail forwarding using the -t switch?
> 
> Jamie
> 
> On 8/25/05, Jamie Doherty <jamiedohertygmail.com> wrote:
> 
>>I have pasted the session:
>>
>>[rootmachine ~]# dbmail-users -c xxxxx at xxxxx
-t yyyyy at yyyyy
>>Opening connection to database...
>>Opening connection to authentication...
>>Ok. Connected
>>Performing changes for user [xxxxx at xxxxx]...
>>Done
>>[rootmachine ~]# dbmail-users -l xxxxx at xxxxx
>>Opening connection to database...
>>Opening connection to authentication...
>>Ok. Connected
>>Info for user [xxxxx at xxxxx]
>>User ID         : 11
>>Username        : xxxxx at xxxxx
>>Client ID       : 0
>>Max. mailboxsize: 0.00 MB
>>Quotum used     : 0.06 MB (inf%)
>>
>>Aliases:
>>
>>[rootmachine ~]#
>>
>>Everything looks just as if the user was just
created.  What shoud it
>>be displaying?
>>
>>Jamie
>>
>>On 8/25/05, Paul J Stevens <paulnfg.nl> wrote:
>>
>>>If you're trying to add a forward for 'user at
domain dot com' what does
>>>the output of dbmail-users -l 'user at domain
dot com' have to say?
>>>
>>>Jamie Doherty wrote:
>>>
>>>>I am trying to forward emails to multiple
mailboxes using the command:
>>>>
>>>>dbmail-users -c user at domain dot com -t
2nd at domain dot com.
>>>>
>>>>Nothing is happening, I don't see any new
entries in the alias table
>>>>and emails are being delivered.  I am
running dbmail 2.0.4 and using
>>>>qmail to deliver to dbmail (is that my
problem?)
>>>>
>>>>Jamie
>>>>____________________________________________
___
>>>>Dbmail mailing list
>>>>Dbmaildbmail.org
>>>>htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>>>>
>>>
>>>--
>>>
____________________________________________________________
____
>>> Paul Stevens                                   
  paul at nfg.nl
>>> NET FACILITIES GROUP                    
GPG/PGP: 1024D/11F8CD31
>>> The
Netherlands________________________________http://www.nfg.nl
>>>_______________________________________________
>>>Dbmail mailing list
>>>Dbmaildbmail.org
>>>htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>>>
>>
> _______________________________________________
> Dbmail mailing list
> Dbmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> 

-- 
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Paul,

After analyzing the tables, I went ahead and added foobar.com
as an
alias to the 2 mailboxes I wanted delivery to and that
worked
perfectly.  Your help is appreciated!

Jamie

On 9/5/05, Paul J Stevens <paulnfg.nl> wrote:
> Jamie,
> 
> Forget about dbmail-users. Look at the tables directly.
dbmail-users
> won't show *everything*. In fact it doesn't show
forwards at all (in 2.0)..
> 
> 
> if you want to have multiple users receive the same
address:
> 
> 1) two local dbmail users receive foobar.com
> 
> dbmail_users:
> 
> userid                 | user_idnr
> -----------------------+-------------------------
> john                   | 3
> barbara                | 4
> 
> dbmail_aliases:
> 
> alias                  | deliver_to
> -----------------------+-------------------------
> foobar.com            | 3
> foobar.com            | 4
> 
> 
> equivalent but convoluted:
> 
> alias                  | deliver_to
> -----------------------+-------------------------
> johnhere.org          | 3
> barbarahere.org       | 4
> foobar.com            | johnhere.org
> foobar.com            | barbarahere.org
> 
> 
> 2) foobar.com forwarded to two external addresses
> 
> alias                  | deliver_to
> -----------------------+-------------------------
> foobar.com            | johnthere.org
> foobar.com            | barbarathere.org
> 
> 
> Lookups are fully recursive, so anything in the
deliver_to field is
> looked up in dbmail_users.user_idnr, and if that
doesn't yield a valid
> result, it is matched against dbmail_aliases.alias. If
that matches the
> whole cycle is restarted with the result.
> 
> And this goes on and on, until either a user_idnr is
found (local
> delivery), or a address is found which doesn't belong
to a local user
> (external forward), or until the maximum recursion
level is reached (error).
> 
> capice?
> 
> Now what is *your* setup? I'm guessing you're confused
because you're
> using addresses as userids. (which makes sense, in a
way...).
> 
> And pulleez, be done with the at dot com trip'n. Some
clarity will help;
> 'someuser at blah dot com' is *not* a valid userid --
> 'someuserblah.com' *is*. Feel free to anonymize,
but leave the syntax
> intact.
> 
> 
> Jamie Doherty wrote:
> > What should dbmail-users -l xxxx at xxxxx dot comm
be displaying if I
> > correctly setup mail forwarding using the -t
switch?
> >
> > Jamie
> >
> > On 8/25/05, Jamie Doherty <jamiedohertygmail.com> wrote:
> >
> >>I have pasted the session:
> >>
> >>[rootmachine ~]# dbmail-users -c xxxxx at xxxxx
-t yyyyy at yyyyy
> >>Opening connection to database...
> >>Opening connection to authentication...
> >>Ok. Connected
> >>Performing changes for user [xxxxx at xxxxx]...
> >>Done
> >>[rootmachine ~]# dbmail-users -l xxxxx at xxxxx
> >>Opening connection to database...
> >>Opening connection to authentication...
> >>Ok. Connected
> >>Info for user [xxxxx at xxxxx]
> >>User ID         : 11
> >>Username        : xxxxx at xxxxx
> >>Client ID       : 0
> >>Max. mailboxsize: 0.00 MB
> >>Quotum used     : 0.06 MB (inf%)
> >>
> >>Aliases:
> >>
> >>[rootmachine ~]#
> >>
> >>Everything looks just as if the user was just
created.  What shoud it
> >>be displaying?
> >>
> >>Jamie
> >>
> >>On 8/25/05, Paul J Stevens <paulnfg.nl> wrote:
> >>
> >>>If you're trying to add a forward for 'user
at domain dot com' what does
> >>>the output of dbmail-users -l 'user at
domain dot com' have to say?
> >>>
> >>>Jamie Doherty wrote:
> >>>
> >>>>I am trying to forward emails to
multiple mailboxes using the command:
> >>>>
> >>>>dbmail-users -c user at domain dot com
-t 2nd at domain dot com.
> >>>>
> >>>>Nothing is happening, I don't see any
new entries in the alias table
> >>>>and emails are being delivered.  I am
running dbmail 2.0.4 and using
> >>>>qmail to deliver to dbmail (is that my
problem?)
> >>>>
> >>>>Jamie
>
>>>>____________________________________________
___
> >>>>Dbmail mailing list
> >>>>Dbmaildbmail.org
> >>>>htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> >>>>
> >>>
> >>>--
> >>>
____________________________________________________________
____
> >>> Paul Stevens                              
       paul at nfg.nl
> >>> NET FACILITIES GROUP                    
GPG/PGP: 1024D/11F8CD31
> >>> The
Netherlands________________________________http://www.nfg.nl
>
>>>_______________________________________________
> >>>Dbmail mailing list
> >>>Dbmaildbmail.org
> >>>htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> >>>
> >>
> > _______________________________________________
> > Dbmail mailing list
> > Dbmaildbmail.org
> > htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
> 
> --
> 
____________________________________________________________
____
>  Paul Stevens                                      paul
at nfg.nl
>  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
>  The Netherlands________________________________http://www.nfg.nl
>
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

I have installed DBMail 2.0.7 STABLE on FreeBSD 5.3.

I have followed the directions in INSTALL. Everything works
until I try 
to add a user.

"Opening connection to database...
Failed. Could not connect to database (check log)
Command failed."

Here's the output in /var/log/maillog:
Sep  9 12:35:03 host dbmail/adduser[37229]:
dbpgsql.ci,db_connect: 
PQconnectdb failed: FATAL:  missing or erroneous pg_hba.conf
file HINT:
  See server log for details.

I start/stop postgres from /usr/local/etc/rc.d/010.pgsql.sh.
Here's the 
relevant section:

prefix=/usr/local
.. /etc/rc.subr
load_rc_config postgresql
postgresql_enable=${postgresql_enable:-"NO"}
postgresql_flags=${postgresql_flags:-"-w -s -m fast -l
/usr/local/pgsql/postgresql.log"}
postgresql_user=pgsql
eval
postgresql_data=${postgresql_data:-"~$
/data"}
postgresql_class=${postgresql_class:-"default"}
name=postgresql
rcvar=`set_rcvar`
command=$/bin/pg_ctl
command_args="-D $ $
$1"

Here is pertinent part of my etc/dbmail.conf

host=localhost          # host for database, set to
localhost if
sqlport=
sqlsocket=
user=dbmail             # user to connect as to database
pass=secret           # password for user to database
db=dbmail               # name of database
TRACE_LEVEL=5

/usr/local/pgsql/data/pg_hba.conf

local   all     all                                    trust


I've gotten past this point before, I don't know what's
different.

Postgres is not logging anything to
/usr/local/pgsql/postgres.log. It is 
empty. I don't know how to fix this.

Still, I cannot imagine what would be wrong with
pg_hba.conf. I can 
successfully use psql from the command line. I've tried
multiple
pg_hba.conf configurations, they all reflect properly when
using psql.

Any ideas? Thanks.

Ross Gohlke
http://www.grinz.com





_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail