Dual instance problem with mysql

[Laurent Rayssiguier]

Hello,

I try to setup an email server with 2 instances.
My server have 2 IP address and each instance listen on one of them.

The relay_domains and relay_recipient_maps were stored in a mysql
database.

With the first instance which read /etc/postfix/main.cf, no problem. The
postfix daemon start without problem.

With the second instance....
Feb 2 16:19:36 relay1 postfix-second/master[22404]: warning:
/usr/lib/postfix/qmgr: bad command startup -- throttling Feb 2 16:20:36
relay1 postfix-second/qmgr[22509]: fatal: dict_open: unsupported
dictionary type: mysql: Is the postfix-mysql package installed?
Feb 2 16:20:37 relay1 postfix-second/master[22404]: warning: process
/usr/lib/postfix/qmgr pid 22509 exit status 1 Feb 2 16:20:37 relay1
postfix-second/master[22404]: warning: /usr/lib/postfix/qmgr: bad
command startup -- throttling

When I try to verify mysql support, I found this :
root@relay1:/usr/src# postconf -c /etc/postfix-second -m btree cidr
environ hash internal nis proxy regexp sdbm static tcp unix

No mysql support...

root@relay1:/usr/src# postconf -c /etc/postfix -m btree cidr environ
hash internal mysql nis proxy regexp sdbm static tcp unix

Mysql support is find correctly.

My server is a Debian SQUEEZE with postfix :
root@relay1:/usr/src# dpkg -l |grep postfix
ii postfix 2.7.1-1+squeeze1
High-performance mail transport agent
ii postfix-mysql 2.7.1-1+squeeze1
MySQL map support for Postfix

I try to start the second instance without the mysql directives and
postfix start correctly.

I try to find with my friend Google someone who had solve a problem like
this, but I can't find another case.
Please help !!

Best regards
Laurent RAYSSIGUIER

PS : Sorry for my English which can be a little bit ridiculous :-))

[Denis Dordoigne]

Bonjour Laurent,

> My server is a Debian SQUEEZE with postfix

Debian utilise des variables d'environnement et des options de démarrage
pour activer ou désactiver les modules. As-tu adapté le script
/etc/init.d/postfix pour ton besoin ? Essaie de faire un "bash -x
/etc/init.d/postfix start" pour voir tout ce qu'il initialise et si
c'est compatible avec la configuration de ton second postfix.

Bonne continuation,

--
Denis Dordoigne
Membre de l'April - promouvoir et défendre le logiciel libre - april.org
Rejoignez maintenant plus de 5 000 personnes, associations,
entreprises et collectivités qui soutiennent notre action

[Laurent RAYSSIGUIER]

Bonjour Denis,

> Debian utilise des variables d'environnement et des options de démarrage pour
> activer ou désactiver les modules. As-tu adapté le script /etc/init.d/postfix
> pour ton besoin ? Essaie de faire un "bash -x /etc/init.d/postfix start" pour
> voir tout ce qu'il initialise et si c'est compatible avec la configuration de
> ton second postfix.

Je met ci-dessous le résultat de ta requête, mais même sans utiliser le
script de démarrage et en faisant postfix -c /etc/postfix-second start;
j'ai le même symptome.

root@relay1:~# bash -x /etc/init.d/postfix start
+ PATH=/bin:/usr/bin:/sbin:/usr/sbin
+ DAEMON=/usr/sbin/postfix
+ NAME=Postfix
+ TZ=
+ unset TZ
+ SYNC_CHROOT=y
+ test -f /etc/default/postfix
+ test -x /usr/sbin/postfix
+ test -f /etc/postfix/main.cf
+ . /lib/lsb/init-functions
++ FANCYTTY=
++ '[' -e /etc/lsb-base-logging.sh ']'
++ true
+ case "$1" in
+ log_daemon_msg 'Starting Postfix Mail Transport Agent' postfix
+ '[' -z 'Starting Postfix Mail Transport Agent' ']'
+ log_daemon_msg_pre 'Starting Postfix Mail Transport Agent' postfix
+ :
+ '[' -z postfix ']'
+ echo -n 'Starting Postfix Mail Transport Agent: postfix'
Starting Postfix Mail Transport Agent: postfix+ log_daemon_msg_post
'Starting Po
stfix Mail Transport Agent' postfix
+ :
++ running
+++ postconf -h queue_directory
++ queue=/var/spool/postfix
++ '[' -f /var/spool/postfix/pid/master.pid ']'
+++ sed 's/ //g' /var/spool/postfix/pid/master.pid
++ pid=22369
+++ sed 's/.* -> //; s/\/[^\/]*$//'
+++ ls -l /proc/22369/exe
++ dir=
++ '[' X = X/usr/lib/postfix ']'
+ RUNNING=
+ '[' -n '' ']'
++ tr A-Z a-z
++ postconf -h myorigin
+ MYORIGIN='$mydomain'
+ '[' 'X$mydomain' '!=' 'X$mydomain' ']'
+ '[' 'X$mydomain' = Xubuntu.com ']'
+ '[' 'X$mydomain' = Xdebian.org ']'
++ awk '/^[0-9a-z]/ && ($5 ~ "[-yY]") { print "y"; exit}'
/etc/postfix/master.cf
+ NEED_CHROOT=y
+ '[' -n y ']'
+ '[' -n y ']'
++ umask
+ oldumask=0022
+ umask 022
++ postconf -h queue_directory
+ cd /var/spool/postfix
+ '[' -f /etc/ssl/certs/ca-certificates.crt ']'
++ postconf -h smtp_use_tls
+ smtp_use_tls=no
++ postconf -h smtp_enforce_tls
+ smtp_enforce_tls=no
++ postconf -h smtpd_use_tls
+ smtpd_use_tls=no
++ postconf -h smtpd_use_tls
+ smtpd_enforce_tls=no
+ case
:$smtp_use_tls:$smtp_enforce_tls:$smtpd_use_tls:$smtpd_enforce_tls: in
++ postconf -h local_recipient_maps
+ local_maps='proxy:unix:passwd.byname $alias_maps'
+ '[' 'Xproxy:unix:passwd.byname $alias_maps' '!=' 'X $alias_maps' ']'
+ '[' 'Xproxy:unix:passwd.byname $alias_maps' = 'X $alias_maps' ']'
+ FILES='etc/localtime etc/services etc/resolv.conf etc/hosts
etc/
nsswitch.conf etc/nss_mdns.config'
+ for file in '$FILES'
+ '[' -d etc ']'
+ '[' -f /etc/localtime ']'
+ rm -f etc/localtime
+ cp /etc/localtime etc/localtime
+ '[' -f etc/localtime ']'
+ chmod a+rX etc/localtime
+ for file in '$FILES'
+ '[' -d etc ']'
+ '[' -f /etc/services ']'
+ rm -f etc/services
+ cp /etc/services etc/services
+ '[' -f etc/services ']'
+ chmod a+rX etc/services
+ for file in '$FILES'
+ '[' -d etc ']'
+ '[' -f /etc/resolv.conf ']'
+ rm -f etc/resolv.conf
+ cp /etc/resolv.conf etc/resolv.conf
+ '[' -f etc/resolv.conf ']'
+ chmod a+rX etc/resolv.conf
+ for file in '$FILES'
+ '[' -d etc ']'
+ '[' -f /etc/hosts ']'
+ rm -f etc/hosts
+ cp /etc/hosts etc/hosts
+ '[' -f etc/hosts ']'
+ chmod a+rX etc/hosts
+ for file in '$FILES'
+ '[' -d etc ']'
+ '[' -f /etc/nsswitch.conf ']'
+ rm -f etc/nsswitch.conf
+ cp /etc/nsswitch.conf etc/nsswitch.conf
+ '[' -f etc/nsswitch.conf ']'
+ chmod a+rX etc/nsswitch.conf
+ for file in '$FILES'
+ '[' -d etc ']'
+ '[' -f /etc/nss_mdns.config ']'
+ '[' -f etc/nss_mdns.config ']'
+ rm -f usr/lib/zoneinfo/localtime
+ mkdir -p usr/lib/zoneinfo
+ ln -sf /etc/localtime usr/lib/zoneinfo/localtime
+ rm -f lib/libnss_compat-2.11.3.so lib/libnss_compat.so.2
lib/libnss_dns-2.11.3
.so lib/libnss_dns.so.2
lib/libnss_files-2.11.3.so lib/libnss_files.so.2 lib/lib

nss_hesiod-2.11.3.so lib/libnss_hesiod.so.2 lib/libnss_nis-2.11.3.so
lib/libnss_
nisplus-2.11.3.so lib/libnss_nisplus.so.2
lib/libnss_nis.so.2
+ tar xf -
+ tar cf - /lib/libnss_compat-2.11.3.so /lib/libnss_compat.so.2
/lib/libnss_dns-
2.11.3.so /lib/libnss_dns.so.2
/lib/libnss_files-2.11.3.so /lib/libnss_files.so.
2
/lib/libnss_hesiod-2.11.3.so /lib/libnss_hesiod.so.2
/lib/libnss_nis-2.11.3.so
/lib/libnss_nisplus-2.11.3.so
/lib/libnss_nisplus.so.2 /lib/libnss_nis.so.2
+ umask 0022
+ start-stop-daemon --start --exec /usr/sbin/postfix --
quiet-quick-start
+ log_end_msg 0
+ '[' -z 0 ']'
+ retval=0
+ log_end_msg_pre 0
+ :
+ log_use_fancy_output
+ TPUT=/usr/bin/tput
+ EXPR=/usr/bin/expr
+ '[' -t 1 ']'
+ '[' xxterm '!=' x ']'
+ '[' xxterm '!=' xdumb ']'
+ '[' -x /usr/bin/tput ']'
+ '[' -x /usr/bin/expr ']'
+ /usr/bin/tput hpa 60
+ /usr/bin/tput setaf 1
+ '[' -z ']'
+ FANCYTTY=1
+ case "$FANCYTTY" in
+ true
++ /usr/bin/tput setaf 1
+ RED=''
++ /usr/bin/tput setaf 3
+ YELLOW=''
++ /usr/bin/tput op
+ NORMAL=''
+ '[' 0 -eq 0 ']'
+ echo .
.
+ log_end_msg_post 0
+ :
+ return 0
+ exit 0
root@relay1:~#

Bonne journée,
Laurent

--
Laurent Rayssiguier
http://linuxtips.castres-wireless.org

[Laurent RAYSSIGUIER]

Problème résolu par Wietse
J'avais zappé un fichier dynamic-maps.cf...
Une fois copié, c'est bon.

Laurent RAYSSIGUIER:
> >If you have DEBIAN-like Postfix, perhaps their Postfix dynamic map
> >configuration file needs to be copied to the config directory of
> >every second etc. instance. That would be a bug in the DEBIAN
> >distribution. The postfix.org has no dynamically-linked maps.

> The configuration files aren't links, but real files.

Then, copy the dynamic-maps.cf file (or whatever) by hand, and file a
DEBIAN bugreport so that you won't have to copy them in the future.

Wietse

Merci de votre aide
Cordialement,