Mailing List Archive: pop3 before smtp

pop3 before smtp

Jun 26, 2003, 6:38 AM

Post #1 of 3 (885 views)

Hi,

i was trying to set up a pop3 before smtp authentification with dbmail
and postfix, and if i enable
"POP_BEFORE_SMTP=yes" in /etc/dbmail.conf i recognized that dbmail tries
to write into the dbmail database table dbmail.pbsp, but it seems that
this table doesn't exist and also isn't generated by the sql scripts
from dbmail....
So, postfix also isn't able to read from this table...

"db_query(): mysql_real_query failed: Table 'dbmail.pbsp' doesn't exist"

I would appreciate any hint :)

bernhard.strobl@bluebull.com

pop3 before smtp [ In reply to ]

bernhard.strobl at bluebull

Jun 26, 2003, 6:45 AM

Post #2 of 3 (863 views)

Permalink

ok i found pop_before_smtp.mysql

sorry for the inconvenience

Re: pop3 before smtp [ In reply to ]

aaron at engr

Jun 26, 2003, 9:33 AM

Post #3 of 3 (856 views)

Permalink

Actually, I'd like to suggest that for 1.2, we cat *mysql >> one_big.mysql
I think that it would be prudent to have all of the tables present even if
not used, that was making a configuration change doesn't mysteriously
break everything.

Or, another thought I had, was resurrecting the dbmail-config program as a
config checking script. So for example, if you have pop_before_smtp turned
on, and you run dbmail-config, it will make sure that the table exists.

This could also be used as an upgrade script (or maybe have it be a
separate entity, dbmail-update? anyhow...) and the upgrade script will
do a little diff between the tables currently running and the tables as
described for the new version and suggest what needs to be alter'd to get
your database upgraded to the new version.

Aaron

On Thu, 26 Jun 2003, Bernhard Strobl wrote:

> ok i found pop_before_smtp.mysql
>
> sorry for the inconvenience
>
>

Mailing List Archive

Attached Files:

Attached Files: