Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 2nd May 2009, 01:26
grungy grungy is offline
Senior Member
 
Join Date: Dec 2008
Posts: 166
Thanks: 14
Thanked 15 Times in 10 Posts
Default mysql replication for tables dns_rr dns_soa

I have 3 ispconfig servers - multiserver environment. I want to have one master DNS server and all other serves would serve the same data, which is replicated from the master. The mysql replication is setup so that only tables dns_rr dns_soa are replicated to other two dbispconfig databases and it works great. Except that the local mydns daemon can not read the two tables because of the server ID. The sql query goes like this:

Code:
SELECT id,origin,ns,mbox,serial,refresh,retry,expire,minimum,ttl,active FROM dns_soa WHERE origin='domain.com.' AND server_id = 3;
but since the tables dns_rr dns_soa have data from server 1, that is the row server_id has value of 1....and the query looks from ID 3 the query is empty.

how to fix this?
Reply With Quote
Sponsored Links
  #2  
Old 2nd May 2009, 01:34
grungy grungy is offline
Senior Member
 
Join Date: Dec 2008
Posts: 166
Thanks: 14
Thanked 15 Times in 10 Posts
Default

figured it out in mydns.conf


Code:
soa-where = server_id = 1               # Extra WHERE clause for SOA queries
rr-where =  server_id = 1               # Extra WHERE clause for RR queries
Reply With Quote
Reply

Bookmarks

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
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
LAMP System Fedora Core 6 MySQL start error gavino HOWTO-Related Questions 13 21st November 2007 19:13
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
ISPConfig server also a MySQL replication slave jamesh Installation/Configuration 1 2nd August 2006 09:59
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 12:54.


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