mydns - as slave DNS server form master database

[Franz]

I create script which enable second ISPconfig3 server, which is connected to master ISPconfig3, to act as slave DNS.

all zones are created in master server, and with this script you can transfer(mirror) dns data to second server every 10 min via cron.

Here is the script (http://blog.it-podrska.info/2009/09/mydns-slave-dns-server-from-master-ispconfig3-database/)

[mhpcomputerservices]

Hi Franz

I'm trying to get your script working on my multiserver setup.

ISPC3 3.0.1.6
Master - Ubuntu 8.10 x64
Secondary - Ubuntu 9.04 x64

I have followed the instructions.

Edited on secondary server - /etc/mydns.conf
Created on secondary server - /root/dns_transfer.sh
(Copied user names/passwords on secondary server from /usr/local/ispconfig/server/lib/config.inc.php into dns_transfer.sh)

When I run ./dns_transfer.sh I get - ERROR 1142 (42000) at line 1: SELECT command denied to user 'ispcsrv2'@'xxxx.xxxxx.co.uk' for table 'dns_soa'

(I've xxxx'd out my server names in this post)

Is there anything I should be doing differently?

Thanks
Marc

[Franz]

what are names of databases on master and slave server?

what is main database on slave server for ispconfig?

[stars]

I suppose Franz posted a script for configuration:

server no 1 - ispconfig3 - ns1
server no 2 - no ispconfig, just mydns - ns2

If you have multiserver config using ispconfig 3 on both servers - Franz's script is not for you.

And referring to second part:

SELECT command denied to user 'ispcsrv2'@'xxxx.xxxxx.co.uk' for table 'dns_soa'

Check on server1 mysql user `ispcsrv` - if he has rights to access table `dns_soa` and if he can connect from `xxx.xxxxx.co.uk` host.

regards
Stars

[Franz]

I suppose Franz posted a script for configuration:

server no 1 - ispconfig3 - ns1
server no 2 - no ispconfig, just mydns - ns2

If you have multiserver config using ispconfig 3 on both servers - Franz's script is not for you.



why not ? I have iscponfig on second server, I just copy data for mydns to second server to act as slave, as ISPconfig does not have dns replication jet.

[lano]

When I had two ISPC servers, I did database replication described here http://www.howtoforge.com/forums/showthread.php?p=197079#post197079
I only replicate DNS tables.
Now I have ISPC3 as master and MyDNS as slave, and I will write tutorial and post it here soon.
Hope it helps.

[SamTzu]

Check out this script that does the same...
http://www.how2forge.org/forums/showthread.php?t=40595

Perhaps we can combine our efforts?