On 6/11/06, Paul J Stevens <[EMAIL PROTECTED]> wrote:
DK wrote:
> On 5/1/06, Paul J Stevens <[EMAIL PROTECTED]> wrote:
>>
>> Demi wrote:
>> > I saw something called auto_create_mailbox (mysql & pgsql) in the
>> > archive dating back to 2002.
>> > Was wondering what todays status is on that and how to do it.
>> > At the moment dbMail does not create any mailboxes for me.
>> > I would need the usual plus INBOX/Spam.
>>
>> 'dbmail-smtp -u username -m mailboxname' will happily create new
>> mailboxes and subscribe the user in question to it.
>>
>> It has done this for a very long time already.
>>
>
> Hi Paul,
> Sorry it took me so long to reply.
> I just created a user test and tried following but it just sits there
> and doesn't create anything.
> dbmail-smtp -v -u test -m Spam
>
> Don't see what I could be doing wrong. I tried with and without -v
Now why would you expect that to make any kind of difference at all? Try
running with a level 5 trace and post some logs.
Here is the log with smtp trace level 5:
Jun 12 05:42:32 safe dbmail/smtp[12399]: GetConfigValue(): searching
value for config item [host]
Jun 12 05:42:32 safe dbmail/smtp[12399]: GetConfigValue(): found value
[localhost]
Jun 12 05:42:32 safe dbmail/smtp[12399]: GetConfigValue(): searching
value for config item [db]
Jun 12 05:42:32 safe dbmail/smtp[12399]: GetConfigValue(): found value [dbmail]
Jun 12 05:42:32 safe dbmail/smtp[12399]: GetConfigValue(): searching
value for config item [user]
Jun 12 05:42:32 safe dbmail/smtp[12399]: GetConfigValue(): found value [script]
Jun 12 05:42:32 safe dbmail/smtp[12399]: GetConfigValue(): searching
value for config item [pass]
Jun 12 05:42:32 safe dbmail/smtp[12399]: GetConfigValue(): found value [0711]
Jun 12 05:42:32 safe dbmail/smtp[12399]: GetConfigValue(): searching
value for config item [sqlport]
Jun 12 05:42:32 safe dbmail/smtp[12399]: GetConfigValue(): found value [3306]
Jun 12 05:42:32 safe dbmail/smtp[12399]: GetConfigValue(): searching
value for config item [sqlsocket]
Jun 12 05:42:32 safe dbmail/smtp[12399]: GetConfigValue(): found value
[/var/run/mysqld/mysqld.sock]
Jun 12 05:42:32 safe dbmail/smtp[12399]: GetConfigValue(): searching
value for config item [trace_level]
Jun 12 05:42:32 safe dbmail/smtp[12399]: GetConfigValue(): found value [5]
Jun 12 05:42:32 safe dbmail/smtp[12399]: dbmysql.c,db_query: executing
query [SELECT 1=1 FROM dbmail_physmessage LIMIT 1 OFFSET 0]
The command you use should insert the mail into the Spam box and create
it first if necessary. With or without the -v.
>
> Here is what I like to do:
> Create user, alias, mailbox Draft, Send, Trash, Spam
> Create Spam filter to deliver direct to Spam folder
>
> I guess the only way to do the spam delivery is via mysql
Meaning?
--
Demi
