HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   mysql replication for tables dns_rr dns_soa (http://www.howtoforge.com/forums/showthread.php?t=34409)

grungy 2nd May 2009 02:26

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?

grungy 2nd May 2009 02:34

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



All times are GMT +2. The time now is 18:05.

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