DNS not working in ISPconfig3 cluster

[till]

So what am I suppose to do next? "Cause I'm really lost over here...

Do what I suggestes to you in #19 of this thread. Install a postfix binary which supports mysql. The binary that you installed is the postfix binary from the centos main repository which does not support mysql and not the one from the centis plus repository.

[archange]

OK, please follow me:

[root@server1 ~]# yum remove postfix
Loaded plugins: fastestmirror
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package postfix.x86_64 2:2.3.3-2.1.el5_2 set to be erased
--> Finished Dependency Resolution

Dependencies Resolved

================================================== =========================================
Package Arch Version Repository Size
================================================== =========================================
Removing:
postfix x86_64 2:2.3.3-2.1.el5_2 installed 8.3 M

Transaction Summary
================================================== =========================================
Remove 1 Package(s)
Reinstall 0 Package(s)
Downgrade 0 Package(s)

Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Erasing : postfix 1/1
warning: /etc/postfix/main.cf saved as /etc/postfix/main.cf.rpmsave

Removed:
postfix.x86_64 2:2.3.3-2.1.el5_2

Complete!
[root@server1 ~]# yum install postfix
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* addons: lnx.apollo-hw.ro
* base: lnx.apollo-hw.ro
* centosplus: lnx.apollo-hw.ro
* contrib: lnx.apollo-hw.ro
* extras: lnx.apollo-hw.ro
* rpmforge: fr2.rpmfind.net
* updates: lnx.apollo-hw.ro
Reducing CentOS-5 - Plus to included packages only
Finished
Excluding Packages from CentOS-5 - Updates
Finished
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package postfix.x86_64 2:2.3.3-2.1.el5_2 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

================================================== =========================================
Package Arch Version Repository Size
================================================== =========================================
Installing:
postfix x86_64 2:2.3.3-2.1.el5_2 base 3.7 M

Transaction Summary
================================================== =========================================
Install 1 Package(s)
Upgrade 0 Package(s)

Total download size: 3.7 M
Is this ok [y/N]: y
Downloading Packages:
postfix-2.3.3-2.1.el5_2.x86_64.rpm | 3.7 MB 00:03
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : postfix 1/1

Installed:
postfix.x86_64 2:2.3.3-2.1.el5_2

Complete!
[root@server1 ~]#
[root@server1 ~]# /etc/init.d/mysqld restart
Stopping MySQL: [ OK ]
Starting MySQL: [ OK ]
[root@server1 ~]# chkconfig --levels 235 postfix on
[root@server1 ~]# /etc/init.d/postfix start
Starting postfix: [ OK ]
[root@server1 ~]#

At this point, I can send out mail to external mailboxes, but I can't receive any. Reason is because postfix main.cf only accepts localhost connections on port 25, I guess.

See?

]# telnet dtxigaming.com 25
Trying 85.121.201.138...
telnet: connect to address 85.121.201.138: Connection refused
telnet: Unable to connect to remote host: Connection refused

Here is the Mail Error Log:

Sep 9 05:45:09 server1 postfix/postfix-script: stopping the Postfix mail system
Sep 9 05:45:09 server1 postfix/master[32752]: terminating on signal 15
Sep 9 05:48:33 server1 postfix/postfix-script: fatal: the Postfix mail system is not running
Sep 9 05:48:34 server1 sendmail[7302]: alias database /etc/aliases rebuilt by root
Sep 9 05:48:34 server1 sendmail[7302]: /etc/aliases: 77 aliases, longest 10 bytes, 779 bytes total
Sep 9 05:48:34 server1 postfix/postfix-script: starting the Postfix mail system
Sep 9 05:48:34 server1 postfix/master[7348]: daemon started -- version 2.3.3, configuration /etc/postfix
Sep 9 05:50:01 server1 dovecot: pop3-login: Disconnected (no auth attempts): rip=127.0.0.1, lip=127.0.0.1, secured
Sep 9 05:50:01 server1 dovecot: imap-login: Disconnected (no auth attempts): rip=127.0.0.1, lip=127.0.0.1, secured
Sep 9 05:50:01 server1 postfix/smtpd[7442]: connect from localhost.localdomain[127.0.0.1]
Sep 9 05:50:01 server1 postfix/smtpd[7442]: lost connection after CONNECT from localhost.localdomain[127.0.0.1]
Sep 9 05:50:01 server1 postfix/smtpd[7442]: disconnect from localhost.localdomain[127.0.0.1]
Sep 9 05:54:17 server1 dovecot: auth-worker(default): mysql: Connected to localhost (dbispconfig)
Sep 9 05:54:17 server1 dovecot: IMAP(archange@dtxigaming.com): Disconnected: Logged out bytes=44/709
Sep 9 05:54:17 server1 dovecot: imap-login: Login: user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Sep 9 05:54:20 server1 dovecot: IMAP(archange@dtxigaming.com): Disconnected: Logged out bytes=261/1896
Sep 9 05:54:20 server1 dovecot: imap-login: Login: user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Sep 9 05:54:21 server1 dovecot: imap-login: Login: user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Sep 9 05:54:21 server1 dovecot: IMAP(archange@dtxigaming.com): Disconnected: Logged out bytes=289/1368
Sep 9 05:54:26 server1 dovecot: imap-login: Login: user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Sep 9 05:54:26 server1 dovecot: IMAP(archange@dtxigaming.com): Disconnected: Logged out bytes=79/687
Sep 9 05:55:02 server1 postfix/smtpd[7688]: connect from localhost.localdomain[127.0.0.1]
Sep 9 05:55:02 server1 postfix/smtpd[7688]: lost connection after CONNECT from localhost.localdomain[127.0.0.1]
Sep 9 05:55:02 server1 postfix/smtpd[7688]: disconnect from localhost.localdomain[127.0.0.1]
Sep 9 05:55:02 server1 dovecot: pop3-login: Disconnected (no auth attempts): rip=127.0.0.1, lip=127.0.0.1, secured
Sep 9 05:55:02 server1 dovecot: imap-login: Disconnected (no auth attempts): rip=127.0.0.1, lip=127.0.0.1, secured
Sep 9 05:57:51 server1 dovecot: IMAP(archange@dtxigaming.com): Disconnected: Logged out bytes=306/3093
Sep 9 05:57:51 server1 dovecot: imap-login: Login: user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Sep 9 05:57:59 server1 dovecot: IMAP(archange@dtxigaming.com): Disconnected: Logged out bytes=142/1550
Sep 9 05:57:59 server1 dovecot: imap-login: Login: user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Sep 9 05:58:02 server1 dovecot: IMAP(archange@dtxigaming.com): Disconnected: Logged out bytes=142/1550
Sep 9 05:58:02 server1 dovecot: imap-login: Login: user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Sep 9 05:58:16 server1 sendmail[7860]: o899w5Ta007860: Authentication-Warning: server1.arenahosting.org: apache set sender to archange@dtxigaming.com using -f
Sep 9 05:58:26 server1 sendmail[7860]: o899w5Ta007860: from=archange@dtxigaming.com, size=565, class=0, nrcpts=1, msgid=<25858.212.93.151.155.1284026285.squirrel@arenahosting.org>, relay=apache@localhost
Sep 9 05:58:27 server1 postfix/smtpd[7863]: connect from localhost.localdomain[127.0.0.1]
Sep 9 05:58:27 server1 postfix/smtpd[7863]: 0AAF7BF400BF: client=localhost.localdomain[127.0.0.1]
Sep 9 05:58:27 server1 postfix/cleanup[7866]: 0AAF7BF400BF: message-id=<25858.212.93.151.155.1284026285.squirrel@arenahosting.org>
Sep 9 05:58:27 server1 sendmail[7860]: o899w5Ta007860: to=gabriel.stan@megaprofil.ro, ctladdr=archange@dtxigaming.com (48/48), delay=00:00:22, xdelay=00:00:01, mailer=relay, pri=30565, relay=[127.0.0.1] [127.0.0.1], dsn=2.0.0, stat=Sent (Ok: queued as 0AAF7BF400BF)
Sep 9 05:58:27 server1 postfix/qmgr[7350]: 0AAF7BF400BF: from=, size=1053, nrcpt=1 (queue active)
Sep 9 05:58:27 server1 postfix/smtpd[7863]: disconnect from localhost.localdomain[127.0.0.1]
Sep 9 05:58:28 server1 dovecot: imap-login: Login: user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Sep 9 05:58:28 server1 dovecot: IMAP(archange@dtxigaming.com): Disconnected: Logged out bytes=656/459
Sep 9 05:58:30 server1 dovecot: imap-login: Login: user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Sep 9 05:58:30 server1 dovecot: IMAP(archange@dtxigaming.com): Disconnected: Logged out bytes=306/3498
Sep 9 05:58:43 server1 postfix/smtp[7867]: 0AAF7BF400BF: to=, relay=mail.megaprofil.ro[212.93.151.155]:25, delay=16, delays=0.06/0.01/16/0.03, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as 4F5602FF8003)
Sep 9 05:58:43 server1 postfix/qmgr[7350]: 0AAF7BF400BF: removed
Sep 9 05:59:28 server1 dovecot: IMAP(archange@dtxigaming.com): Disconnected: Logged out bytes=79/687
Sep 9 05:59:28 server1 dovecot: imap-login: Login: user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Sep 9 06:00:01 server1 postfix/smtpd[7863]: connect from localhost.localdomain[127.0.0.1]
Sep 9 06:00:01 server1 postfix/smtpd[7863]: lost connection after CONNECT from localhost.localdomain[127.0.0.1]
Sep 9 06:00:01 server1 postfix/smtpd[7863]: disconnect from localhost.localdomain[127.0.0.1]
Sep 9 06:00:01 server1 dovecot: pop3-login: Disconnected (no auth attempts): rip=127.0.0.1, lip=127.0.0.1, secured
Sep 9 06:00:01 server1 dovecot: imap-login: Disconnected (no auth attempts): rip=127.0.0.1, lip=127.0.0.1, secured

...

Sep 9 06:05:25 server1 postfix/smtp[8229]: connect to mail.dtxigaming.com[85.121.201.138]: Connection refused (port 25)
Sep 9 06:05:25 server1 postfix/smtp[8229]: 128D0BF400B0: to=, relay=none, delay=78677, delays=78666/0.02/11/0, dsn=4.4.1, status=deferred (connect to mail.dtxigaming.com[85.121.201.138]: Connection refused)
Sep 9 06:05:25 server1 postfix/smtp[8230]: connect to mail.arenahosting.org[85.121.201.138]: Connection refused (port 25)
Sep 9 06:05:25 server1 postfix/smtp[8230]: 7910ABF400BC: to=, relay=none, delay=7470, delays=7459/0.01/11/0, dsn=4.4.1, status=deferred (connect to mail.arenahosting.org[85.121.201.138]: Connection refused)
Sep 9 06:05:25 server1 postfix/smtp[8231]: connect to mail.dtxigaming.com[85.121.201.138]: Connection refused (port 25)
Sep 9 06:05:25 server1 postfix/smtp[8231]: 9A143BF400AC: to=, relay=none, delay=81749, delays=81738/0.01/11/0, dsn=4.4.1, status=deferred (connect to mail.dtxigaming.com[85.121.201.138]: Connection refused)

What am I missing?

[archange]

Please, anyone, help!

[till]

Most likely the reinstall has overwritten some config files. Download ispconfig tar.gz and run the update.php script and choose to reconfigure services.

[archange]

Originally Posted by archange

I found a similar problem in a post and both of you (Till & Falko) have suggested to run an ISPconfig update. So i did. And it got me back to:

postfix/qmgr[26418]: fatal: unsupported dictionary type: mysql

I'm stuck in a loop.

I already tried this - remember? Then I get the error about "unsupported dictionary mysql"

[falko]

What's in /etc/yum.repos.d/CentOS-Base.repo? I guess the wrong Postfix package got installed.

[archange]

@Falko:

# CentOS-Base.repo
#
# The mirror system uses the connecting IP address of the client and the
# update status of each mirror to pick mirrors that are updated to and
# geographically close to the client.  You should use this for CentOS updates
# unless you are manually picking other mirrors.
#
# If the mirrorlist= does not work for you, as a fall back you can try the
# remarked out baseurl= line instead.
#
#

[base]
name=CentOS-$releasever - Base
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os
#baseurl=http://mirror.centos.org/centos/$releasever/os/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5

#released updates
[updates]
name=CentOS-$releasever - Updates
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=updates
#baseurl=http://mirror.centos.org/centos/$releasever/updates/$basearch/
exclude=postfix
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5

#packages used/produced in the build but not released
[addons]
name=CentOS-$releasever - Addons
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=addons
#baseurl=http://mirror.centos.org/centos/$releasever/addons/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5

#additional packages that may be useful
[extras]
name=CentOS-$releasever - Extras
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=extras
#baseurl=http://mirror.centos.org/centos/$releasever/extras/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5

#additional packages that extend functionality of existing packages
[centosplus]
name=CentOS-$releasever - Plus
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=centosplus
#baseurl=http://mirror.centos.org/centos/$releasever/centosplus/$basearch/
gpgcheck=1
enabled=1
includepkgs=postfix
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5

#contrib - packages by Centos Users
[contrib]
name=CentOS-$releasever - Contrib
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=contrib
#baseurl=http://mirror.centos.org/centos/$releasever/contrib/$basearch/
gpgcheck=1
enabled=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5

Question: how could it be the wrong postfix package, I mean, right now I can send, but not receive?

Still, I wish you were right, so i can finally get this over with
*fingers crossed*

[till]

Originally Posted by archange

I already tried this - remember? Then I get the error about "unsupported dictionary mysql"

I know, but the order of actions matters! You have to do this after the postfix binary with mysql support has been installed to reconfigure the newly installed postfix.

Question: how could it be the wrong postfix package, I mean, right now I can send, but not receive?

The mysql database is not queried when a email is sent, it is only queried when a email is received.

[archange]

@Falko: shere genius. I may have found the glitch: not having included:

[base]
[...]
exclude=postfix

I just reinstalled postfix and already I can see it's a different version: postfix-2.3.3-2.1.centos.mysql_pgsql.x86_64.rpm as opposed to postfix.x86_64 2:2.3.3-2.1.el5_2.
Also postgresql.x86_64 0:8.1.21-1.el5_5.1 got installed too.

@Till

I understand; I reinstalled the correct postfix binary, I will update ISPconfig ASAP.

Wish me luck!

[archange]

Falko, Till, Thank you! I can finally breathe again xD