On 6/12/06, DK <[EMAIL PROTECTED]> wrote:
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
Now I have to change my password
--
Demi