[2024-feb-29] Sad news: Eric Layton aka Nocturnal Slacker aka vtel57 passed away on Feb 26th, shortly after hospitalization. He was one of our Wiki's most prominent admins. He will be missed.

Welcome to the Slackware Documentation Project

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

talk:howtos:network_services:postfix_dovecot_mysql:postfix [2015/09/14 14:20 (UTC)] – created timtalk:howtos:network_services:postfix_dovecot_mysql:postfix [2017/04/02 02:50 (UTC)] (current) – corrected mistake in virtual mailbox config file 23.54.19.31
Line 4: Line 4:
 </code> </code>
 before postfix is installed, as postfix has its own sendmail executable to provide functionality for other programs which expect to use sendmail. --- //[[wiki:user:tim|Tim Dickson]] 2015/09/14 14:13// before postfix is installed, as postfix has its own sendmail executable to provide functionality for other programs which expect to use sendmail. --- //[[wiki:user:tim|Tim Dickson]] 2015/09/14 14:13//
 +
 +
 +====== Mistake in the virtual mailbox configuration: ======
 +
 +
 +To use mysql on a remote server, I had to replace "host" with "hosts" in the virtual mailbox configurations--postfix defaults to 'localhost' anyways, which is why this error goes undetected, but want something besides the default value, and this error must be fixed as thus:  
 +
 +<code>
 +emacs /etc/postfix/mysql-virtual-mailbox-domains.cf
 +
 +# Enter the following lines #
 +user= mailuser
 +password = {your mailuser password}
 +hosts = {mysql server's ip address}
 +dbname = mailserver
 +query = SELECT 1 FROM virtual_domains WHERE name='%s'
 +</code>
 +
 +(the revision is the "s" that was added to "host") -- slac.in.the.box

Trace:

talk:howtos:network_services:postfix_dovecot_mysql:postfix ()