DirectAdmin # custom zone.conf fix security

user warning: Unknown column 'u.signature_format' in 'field list' query: SELECT c.cid as cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, c.homepage, u.uid, u.name AS registered_name, u.signature, u.signature_format, u.picture, u.data, c.thread, c.status FROM comments c INNER JOIN users u ON c.uid = u.uid WHERE c.nid = 21 AND c.status = 0 ORDER BY c.thread DESC LIMIT 0, 30 in /home/cmsdd/domains/cmsdd.com/public_html/modules/comment/comment.module on line 992.

#cd /usr/local/directadmin/data/templates
#cp zone.conf custom/
#cd custom
#nano zone.conf

original file
------------------------------------------------------------
zone "|DOMAIN|" { type master; file "|PATH|/|DOMAIN|.db"; };
------------------------------------------------------------

edit to
------------------------------------------------------------
zone "|DOMAIN|" { allow-transfer { trusted-servers; }; type master; file "|PATH|/|DOMAIN|.db"; };
------------------------------------------------------------
Ctrl + x
press y
enter

edit /etc/named.conf
old config
-----------------------------------------------------------
options {
directory "/var/named";
dump-file "/var/named/data/cache_dump.db";
statistics-file "/var/named/data/named_stats.txt";
};
include "/etc/rndc.key";

zone "localhost.localdomain.com" { type master; file "/var/named/localhost.localdomain.com.db"; };
----------------------------------------------------------

edit to
----------------------------------------------------------
acl trusted-servers {
127.0.0.1;
};

options {
allow-recursion {
localnets;
};
directory "/var/named";
dump-file "/var/named/data/cache_dump.db";
statistics-file "/var/named/data/named_stats.txt";
};
include "/etc/rndc.key";

zone "da02.9dbd.com" { allow-transfer { trusted-servers; }; type master; file "/var/named/localhost.localdomain.com.db"; };
-----------------------------------------------------------
Ctrl + x
press y
enter

#service named restart

how to test