÷ ðÔÎ, 16.04.2004, × 16:27, Ilja Booij ÐÉÛÅÔ:
I disagree here below an example not the worker:
./dbmail-adduser a oracle@bkh.inforus.com secret 0 25000000
anton@bkh.inforus.com root@bkh.inforus.com
mail -s test anton@bkh.inforus.com ......
and in log
Apr 16 01:50:57 bkh dbmail/smtp[12147]: dboracle.c,db_query: executing
query [SELECT user_idnr FROM users WHERE userid='anton@bkh.inforus.com']
Apr 16 01:50:57 bkh dbmail/smtp[12147]: dboracle.c,db_free_result
Apr 16 01:50:57 bkh dbmail/smtp[12147]: authsql.c,auth_check_user_ext:
checking user [anton@bkh.inforus.com] in alias table
Apr 16 01:50:57 bkh dbmail/smtp[12147]: authsql.c,auth_check_user_ext:
checks [-1]
Apr 16 01:50:57 bkh dbmail/smtp[12147]: dboracle.c,db_query: executing
query [SELECT deliver_to FROM aliases WHERE lower(alias) =
lower('anton@bkh.inforus.com')]
Apr 16 01:50:57 bkh dbmail/smtp[12147]: authsql.c,auth_check_user_ext:
into checking loop
Apr 16 01:50:57 bkh dbmail/smtp[12147]: authsql.c,auth_check_user_ext:
checking user anton@bkh.inforus.com to 36
Apr 16 01:50:57 bkh dbmail/smtp[12147]: authsql.c,auth_check_user_ext:
checking user [36]
in alias table
Apr 16 01:50:57 bkh dbmail/smtp[12147]: authsql.c,auth_check_user_ext:
checks [1]
Apr 16 01:50:57 bkh dbmail/smtp[12147]: dboracle.c,db_query: executing
query [SELECT deliver_to FROM aliases WHERE lower(alias) = lower('36')]
Apr 16 01:50:57 bkh dbmail/smtp[12147]: authsql.c,auth_check_user_ext:
adding [36] to deliver_to address
Apr 16 01:50:57 bkh dbmail/smtp[12147]: dboracle.c,db_free_result
Apr 16 01:50:57 bkh dbmail/smtp[12147]: dboracle.c,db_get_result: (row =
1,field = 0) bigger then size of result set
Apr 16 01:50:57 bkh dbmail/smtp[12147]: authsql.c,auth_check_user_ext:
checking user anton@bkh.inforus.com to (null)
Apr 16 01:50:57 bkh dbmail/smtp[12147]: authsql.c,auth_check_user_ext:
checking user [(null)] in alias table
Apr 16 01:50:57 bkh dbmail/smtp[12147]: authsql.c,auth_check_user_ext:
checks [1]
Apr 16 01:50:57 bkh dbmail/smtp[12147]: dboracle.c,db_query: executing
query [SELECT deliver_to FROM aliases WHERE lower(alias) =
lower('(null)')]
> On Fri, 2004-04-16 at 00:58, Anton Nekhoroshih wrote:
> > On mine are incorrectly created aliases at creation of users.
> > It should seems to me it to be so: (see attach)
>
> Ah, I see what you mean now. As a matter of fact, the behaviour as it
> was was the right behaviour.
>
> In the deliver_to field of the aliases table, a number is inserted
> whenever it's a 'local' alias, pointed directly to a mailbox. Otherwise,
> a string is used to denote a different alias (possibly to an external
> address).
>
> This is not the most elegant setup, but it works perfectly.
>
> Ilja
>
>
> _______________________________________________
> Dbmail-dev mailing list
> Dbmail-dev@dbmail.org
> http://twister.fastxs.net/mailman/listinfo/dbmail-dev
>