Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 7th July 2010, 18:32
damir damir is offline
Senior Member
Join Date: Jun 2006
Posts: 375
Thanks: 11
Thanked 51 Times in 42 Posts
Default ISPC 3, powerdns, mysql replication not working.

Hi all,

Im trying to install PowerDNS as DNS server instead of MyDNS. Test environment includes two servers. One server has ISPConfig installed, powerdns and mysql. Server 2 has Powerdns and mysql installed.

Everything is working fine except replication of mysql with powerdns database that ISPConfig has created.

Replication is working fine with other test databases but not with the PowerDNS database that was created by ISPConfig installer.

If i create new table in powerdns database it's replicated fine but if i create new DNS data through ISPconfig panel than that newly created data is not replicated. It's inserted correctly but tables containg new records is not replicated to server 2.

It seems that something is weird with powerdns database that is created by ISPConfig installer.

Anyone with ispconfig, powerdns mysql replication experience?
Reply With Quote
Sponsored Links
Old 7th July 2010, 20:15
till till is offline
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts

Looks as you mix up something here. ISPConfig uses a builtin replication mechanism and not the mysql replication. If you configure mysql replication manually beside the ispconfig replication, the system will fail as it creates a conflict. To fix this, remove the mysql replication as it is not nescessary. Then install one ispconfig master server and as many ispconfig slave servers as you need and ispconfig will replicate all nescessary configuration data between these databases. If you use powerdns, then the powerdns databse and plugin has to be on the slave that runs powerdns and ispconfig will replicate the data from the slave database event based into the powerdns database.
Till Brehm
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Old 8th July 2010, 10:24
damir damir is offline
Senior Member
Join Date: Jun 2006
Posts: 375
Thanks: 11
Thanked 51 Times in 42 Posts

Thanx for the reply Till.

I thought that powerdns db should be replicated through mysql replication. My bad.

Installing two ISPConfig Powerdns slaves and choosing slave 2 to be mirror of slave 1 replicates Powerdns correctly. Damn whole day went in troubleshooting and it was that easy. Well at least i learned everything that is in Mysql replication

Now i have connected two DNS server to existing multi server setup and it works like charm.

Thanx again Till.
Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Squirrelmail login failure Cracklefish Installation/Configuration 9 30th June 2010 21:38
MySQL Database Replication - can't upgrade kpm HOWTO-Related Questions 6 18th April 2010 04:54
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 14:58
mysql replication issues Jamesk5 Server Operation 8 23rd September 2006 15:40
PHP & MySQL working, but AREN'T WORKING???? lipp9000 Installation/Configuration 4 21st July 2006 18:01

All times are GMT +2. The time now is 23:14.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.