On 06-09-11 20:26, David B. wrote:
> when I install from packages in debian squeeze,
> my daemon name is dbmail-lmtpd NOT
> dbmail-lmtp.
As it should be.
>
> in the config instruction on postfix you state that
> I should add:
>
> dbmail-lmtp unix - - n - - lmtp
>
> into master.cf
>
> and
>
> virtual_transport = dbmail-lmtp:<host>:<port>
>
> presumably it should look like this in my file:
> virtual_transport = dbmail-lmtp:localhost:24
Correct.
>
> The question is whether the problem might be that
> the should read:
>
> dbmail-lmtpd unix - - n - - lmtp
>
> and
>
> virtual_transport = dbmail-lmtpd:localhost:24
What problem?
In this case 'dbmail-lmtp' is a symbolic name, *not* a reference to any
binary executable.
Personally I don't mess with master.cf at all. Just leave the default
lmtp entry as-is. Nothing wrong with it. You might want to tweak the
maxproc field, since the default (50) might be a bit high.
If you do leave master.cf as is, and dbmail-lmtpd is running on
localhost, main.cf should read
virtual_transport = lmtp:localhost:24
> respectively?
>
> Also, the section where you state I should put:
Where did you find this information? I don't think it's in the debian
package...
>
> user = <SQL-username>
> password = <SQL-password>
> hosts = <SQL-host>
> dbname = <SQL-database>
> query = SELECT DISTINCT 1 FROM dbmail_aliases WHERE alias= '%s';
>
> into
> /etc/postfix/sql-virtual_mailbox_maps.cf
>
> if I am using a postgresql database, is very confusing to say the least.
> At least I think that is what I am supposed to do.
>
> You have no examples on how that info is to be supplied. Should it look
> something like this?
>
> user = dbmail # or should be be user postgres?
> password = #no password used
> hosts = localhost
> dbname = dbmail
> query = SELECT DISTINCT 1 FROM dbmail_aliases WHERE alias= '%s';
>
> sorry to bother.
Well, I don't really see the problem. If you follow the postgres
instructions in INSTALL you will notice that we advise you to set a
password on the dbmail database owner, and use TCP/IP connections to
connect to the database.
One thing missing in INSTALL is that you must configure postgresql to
allow password enabled connections over the network. One way is to make
sure you have something like the following around the end of your
pg_hba.conf:
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin
* Premium Hosting Services and Web Application Consultancy *
www.nfg.nl/[email protected]/+31.85.877.99.97
________________________________________________________________
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
