Network/DNS - Revision history

Eadam: /* GeoIP database */

2012-06-24T11:44:26Z

GeoIP database

Eadam: /* MySQL */

2012-06-24T11:42:23Z

MySQL

Eadam: /* Configuration */

2012-06-24T11:41:39Z

Configuration

Eadam: /* Installation (Debian) */

2012-06-24T11:37:59Z

Installation (Debian)

Eadam: /* MySQL */

2012-06-24T11:37:31Z

MySQL

Eadam: /* PowerDNS */

2012-06-24T11:34:57Z

PowerDNS

Eadam: /* GeoIP database */

2012-06-24T11:32:17Z

GeoIP database

Eadam: /* GeoIP database */

2012-06-24T11:31:56Z

GeoIP database

Eadam: /* Bind */

2012-06-23T22:41:36Z

Bind

Eadam at 22:37, 23 June 2012

2012-06-23T22:37:40Z

@@ Line 176: / Line 176: @@
 exit 0
 </pre>
 == PowerDNS ==

@@ Line 260: / Line 260: @@
 <pre>
 INSERT INTO `domains` VALUES (1,'lunasys.fr',NULL,NULL,'NATIVE',NULL,NULL);
-INSERT INTO `records` VALUES (3,1,'as.www.lunasys.fr','A','3.1.1.1',600,NULL,NULL),(4,1,'us.www.lunasys.fr','A','2.1.1.1',600,NULL,NULL),(5,1,'eu.www.lunasys.fr','A','4.1.1.1',600,NULL,NULL);
+INSERT INTO `records` VALUES (3,1,'as.www.lunasys.fr','A','3.1.1.1',600,NULL,NULL),
 </pre>

@@ Line 76: / Line 76: @@
 </pre>
-'''geoip/us.lunasys.fr.hosts''':
+Create the log directory:
 <pre>
 $TTL	86400 ; 24 hours could have been written as 24h or 1d

@@ Line 177: / Line 177: @@
 Install the package (tested in squeeze):
-  apt-get install pdns-server pdns-backend-geo pdns-backend-mysql
+  apt-get install pdns-server pdns-backend-geo pdns-backend-mysql mysql-server
 === General Configuration ===

@@ Line 207: / Line 207: @@
 === MySQL ===
-MySQL tables (and samples):
+Create the base MySQL tables (and samples):
 <pre>
 DROP TABLE IF EXISTS `domains`;
 CREATE TABLE `domains` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
@@ Line 223: / Line 221: @@
    UNIQUE KEY `name_index` (`name`)
 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
 DROP TABLE IF EXISTS `records`;
 CREATE TABLE `records` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
@@ Line 244: / Line 237: @@
    KEY `domain_id` (`domain_id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
 DROP TABLE IF EXISTS `supermasters`;
 CREATE TABLE `supermasters` (
    `ip` varchar(25) NOT NULL,
@@ Line 258: / Line 246: @@
 </pre>
-In '''pdns.d/pdns.local''', add:
+Then, in '''pdns.d/pdns.local''', add:
 <pre>
 gmysql-host=127.0.0.1
-gmysql-user=root
+gmysql-user=pdns
 gmysql-password=<pass>
 gmysql-dbname=pdns
 </pre>
 === Geo ===

@@ Line 172: / Line 172: @@
 == PowerDNS ==
 === General Configuration ===
-/etc/powerdns/pdns.conf
+Setup basic configuration in '''/etc/powerdns/pdns.conf''':
 <pre>
 allow-recursion=127.0.0.1

@@ Line 99: / Line 99: @@
 Then write the GeoIP.acl and GeoIPv6.acl files with the following scripts.
-These scripts are from [[http://phix.me/geodns/]]
+These scripts are from [http://phix.me/geodns/ here].
 '''geoip.sh''':

← Older revision		Revision as of 11:31, 24 June 2012
Line 98:		Line 98:

	Then write the GeoIP.acl and GeoIPv6.acl files with the following scripts.		Then write the GeoIP.acl and GeoIPv6.acl files with the following scripts.
		+
		+	These scripts are from [[http://phix.me/geodns/]]

	'''geoip.sh''':		'''geoip.sh''':

@@ Line 1: / Line 1: @@
 == Bind ==
-'''named.conf''':
+=== Configuration ===
 <pre>
 </pre>
-'''named.conf.local''':
+Replace the content of '''named.conf.local''' by:
 <pre>
 include "/etc/bind/geoip/GeoIP.acl";
@@ Line 91: / Line 95: @@
 </pre>
 == PowerDNS ==

← Older revision		Revision as of 22:37, 23 June 2012
Line 1:		Line 1:
		+	== Bind ==
		+
		+	'''named.conf''':
		+	<pre>
		+	</pre>
		+
		+	'''named.conf.local''':
		+	<pre>
		+	include "/etc/bind/geoip/GeoIP.acl";
		+	include "/etc/bind/geoip/GeoIPv6.acl";
		+
		+	logging {
		+	channel simple_log {
		+	file "/var/log/named/bind.log" versions 3 size 5m;
		+	//severity client;
		+	print-time yes;
		+	print-severity yes;
		+	print-category yes;
		+	};
		+	category default{
		+	simple_log;
		+	};
		+	};
		+
		+
		+	view "America" {
		+	match-clients { US; CA; };
		+	recursion no;
		+	include "/etc/bind/named.conf.default-zones";
		+	//include "/etc/bind/named.conf.zones";
		+	zone "lunasys.fr" {
		+	type master;
		+	file "/etc/bind/geoip/us.lunasys.fr.hosts";
		+	};
		+	};
		+
		+
		+	view "Asia" {
		+	match-clients { HK; CN; };
		+	recursion no;
		+	include "/etc/bind/named.conf.default-zones";
		+	//include "/etc/bind/named.conf.zones";
		+	zone "lunasys.fr" {
		+	type master;
		+	file "/etc/bind/geoip/as.lunasys.fr.hosts";
		+	};
		+	};
		+
		+
		+	view "Europe" {
		+	match-clients { FR; };
		+	recursion no;
		+	include "/etc/bind/named.conf.default-zones";
		+	//include "/etc/bind/named.conf.zones";
		+	zone "lunasys.fr" {
		+	type master;
		+	file "/etc/bind/geoip/eu.lunasys.fr.hosts";
		+	};
		+	};
		+
		+
		+	view "Default" {
		+	match-clients { any; };
		+	recursion no;
		+	include "/etc/bind/named.conf.default-zones";
		+	//include “/etc/bind/named.conf.zones";
		+	zone "lunasys.fr" {
		+	type master;
		+	file "/etc/bind/geoip/us.lunasys.fr.hosts";
		+	};
		+	};
		+	</pre>
		+
		+	'''geoip/us.lunasys.fr.hosts''':
		+	<pre>
		+	$TTL 86400 ; 24 hours could have been written as 24h or 1d
		+	$ORIGIN lunasys.fr.
		+	@ 1D IN SOA ns1.lunasys.fr. hostmaster.lunasys.fr. (
		+	2002022401 ; serial
		+	3H ; refresh
		+	15 ; retry
		+	1w ; expire
		+	3h ; minimum
		+	)
		+	IN NS ns1.lunasys.fr. ; in the domain
		+	IN MX 10 mail.google.com.
		+	; server host definitions
		+	ns1 IN A 198.245.55.128
		+	yuki IN A 103.5.15.123
		+	yuko IN A 198.245.55.128
		+	</pre>
		+
		+
	== PowerDNS ==		== PowerDNS ==