Parallels Virtualization and Automation Software

RESOLUTION

In case you are using database on a separate server you also should properly configure MySQL server and PowerDNS server.

• Grant privileges for management node and host running PowerDNS server:

  IP_ADDR_DNS - the address of HSPcomplete node where PowerDNS server is running or IP address of server where PowerDNS installed in case PowerDNS server runs separately from HSPcomplete.

  Run the following SQL commands to grant privileges on database in mysql command shell:

  use aspc;
grant select on dm_zone to pdns@IP_ADDR_DNS;
grant select on dm_record to pdns@IP_ADDR_DNS;
grant select on dm_zone_suspended to pdns@IP_ADDR_DNS;
grant select on dm_record_suspended to pdns@IP_ADDR_DNS;
grant all on pdns_data to pdns@IP_ADDR_DNS;
FLUSH PRIVILEGES;
• Configure PowerDNS server. Please perform the following changes in /etc/powerdns/pdns.conf file:
  • Comment out gmysql-socket parameter
  • Setup parameter gmysql-host=IP_DB_SRV where IP_DB_SRV is IP address of MySQL server.
  • restart PowerDNS server:
    /etc/init.d/pdns restart

After that please review logs of PowerDNS server at /var/log/messages file to make sure PowerDNS successfully connected to database server.