mydns - as slave DNS server form master database

Discussion in 'Tips/Tricks/Mods' started by Franz, Sep 22, 2009.

  1. Franz

    Franz Member

    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
     
  2. mhpcomputerservices

    mhpcomputerservices Member HowtoForge Supporter

    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
     
  3. Franz

    Franz Member

    what are names of databases on master and slave server?

    what is main database on slave server for ispconfig?
     
    Last edited: Oct 28, 2009
  4. stars

    stars New Member

    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:

    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
     
  5. Franz

    Franz Member

    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.
     
  6. lano

    lano New Member

  7. SamTzu

    SamTzu Member HowtoForge Supporter

Share This Page