After compile and install i get only the follow Error
zone mydomain.com/IN: loading zone: creating database: failure
I have testet with the Example from Readme File,
SDB Driver will not work ?? or missconfigured ?
mysqlversion : mysql Ver 14.7 bind version: BIND 9.4.1-P1
named.conf -- cut -- zone "mydomain.com" {
type master; notify no; database "mysqldb dnsdb mydomain localhost root mypass";
};
--------- mysqldump
--- cut ----------
SET FOREIGN_KEY_CHECKS=0;
CREATE DATABASE `dnsdb` CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci';
# # Structure for the `mydomain` table : #
CREATE TABLE `mydomain` ( `name` varchar(255) default NULL, `ttl` int(11) default NULL, `rdtype` varchar(255) default NULL, `rdata` varchar(255) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
# # Data for the `mydomain` table (LIMIT 0,500) #
INSERT INTO `mydomain` (`name`, `ttl`, `rdtype`, `rdata`) VALUES ('mydomain.com',259200,'SOA','mydomain.com. www.mydomain.com. 200309181 28800 7200 86400 28800'), ('mydomain.com',259200,'NS','ns0.mydomain.com.'), ('mydomain.com',259200,'NS','ns1.mydomain.com.'), ('mydomain.com',259200,'MX','10 mail.mydomain.com.'), ('w0.mydomain.com',259200,'A','192.168.1.1'), ('w1.mydomain.com',259200,'A','192.168.1.2'), ('mydomain.com',259200,'Cname','w0.mydomain.com.'), ('mail.mydomain.com',259200,'Cname','w0.mydomain.com.'), ('ns0.mydomain.com',259200,'Cname','w0.mydomain.com.'), ('ns1.mydomain.com',259200,'Cname','w1.mydomain.com.'), ('www.mydomain.com',259200,'Cname','w0.mydomain.com.'), ('ftp.mydomain.com',259200,'Cname','w0.mydomain.com.');
COMMIT; ---------- end ---------------------
thanks for help
Log in to post a comment.
After compile and install i get only the follow Error
zone mydomain.com/IN: loading zone: creating database: failure
I have testet with the Example from Readme File,
SDB Driver will not work ??
or missconfigured ?
mysqlversion : mysql Ver 14.7
bind version: BIND 9.4.1-P1
named.conf
-- cut --
zone "mydomain.com" {
type master;
notify no;
database "mysqldb dnsdb mydomain localhost root mypass";
};
---------
mysqldump
--- cut ----------
SET FOREIGN_KEY_CHECKS=0;
CREATE DATABASE `dnsdb`
CHARACTER SET 'latin1'
COLLATE 'latin1_swedish_ci';
#
# Structure for the `mydomain` table :
#
CREATE TABLE `mydomain` (
`name` varchar(255) default NULL,
`ttl` int(11) default NULL,
`rdtype` varchar(255) default NULL,
`rdata` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Data for the `mydomain` table (LIMIT 0,500)
#
INSERT INTO `mydomain` (`name`, `ttl`, `rdtype`, `rdata`) VALUES
('mydomain.com',259200,'SOA','mydomain.com. www.mydomain.com. 200309181 28800 7200 86400 28800'),
('mydomain.com',259200,'NS','ns0.mydomain.com.'),
('mydomain.com',259200,'NS','ns1.mydomain.com.'),
('mydomain.com',259200,'MX','10 mail.mydomain.com.'),
('w0.mydomain.com',259200,'A','192.168.1.1'),
('w1.mydomain.com',259200,'A','192.168.1.2'),
('mydomain.com',259200,'Cname','w0.mydomain.com.'),
('mail.mydomain.com',259200,'Cname','w0.mydomain.com.'),
('ns0.mydomain.com',259200,'Cname','w0.mydomain.com.'),
('ns1.mydomain.com',259200,'Cname','w1.mydomain.com.'),
('www.mydomain.com',259200,'Cname','w0.mydomain.com.'),
('ftp.mydomain.com',259200,'Cname','w0.mydomain.com.');
COMMIT;
---------- end ---------------------
thanks for help