forum.lissyara.su

Код: Выделить всё

powerdns-2.9.21.1
powerdns-recursor-3.1.7_1
poweradmin-2.1.0
mysql-server-6.0.6
apache-2.2.9_5 

Код: Выделить всё

http://my.server.ip/poweradmin/install

Код: Выделить всё

Alias /poweradmin "/usr/local/www/poweradmin"
<Directory "/usr/local/www/poweradmin">
    Options		Indexes FollowSymLinks MultiViews
    AllowOverride	None
    Order		allow,deny
    Allow from 		all
</Directory>

Код: Выделить всё

./pdns restart
pdns not running?
Starting pdns.
Sep 07 09:01:00 Reading random entropy from '/dev/urandom'
Sep 07 09:01:00 This is module gmysqlbackend.so reporting
Sep 07 09:01:00 This is a standalone pdns
Sep 07 09:01:00 Listening on controlsocket in '/var/run/pdns.controlsocket'
Sep 07 09:01:00 It is advised to bind to explicit addresses with the --local-address option
Sep 07 09:01:00 UDP server bound to 0.0.0.0:53
Sep 07 09:01:00 TCP server bound to 0.0.0.0:53
Sep 07 09:01:00 PowerDNS 2.9.22 (C) 2001-2009 PowerDNS.COM BV (Sep  4 2009, 22:46:02, gcc 4.2.1 20070719  [FreeBSD]) starting up
Sep 07 09:01:00 PowerDNS comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it according to the terms of the GPL version 2.
Sep 07 09:01:00 Set effective group id to 120
Sep 07 09:01:00 Set effective user id to 1002
Sep 07 09:01:00 Creating backend connection for TCP
Sep 07 09:01:00 Master/slave communicator launching
Sep 07 09:01:00 Fatal error in webserver: binding to port 443 on 192.168.100.2: Permission denied
Sep 07 09:01:00 gmysql Connection succesful
Sep 07 09:01:00 gmysql Connection succesful
Sep 07 09:01:00 About to create 3 backend threads for UDP
Sep 07 09:01:00 gmysql Connection succesful

Код: Выделить всё

# Разрешить передачу с .
allow-axfr-ips=0.0.0.0/0

#Разрешить запросы с..
allow-recursion=0.0.0.0/0

# cache-ttl     Seconds to store packets in the PacketCache
cache-ttl=20

# Папка с конфигом
config-dir=/usr/local/etc/pdns

# Отключаем control-console, режим откладки
control-console=no

# Отключаем  daemon
daemon=no

# Указываем наш сервер
default-soa-name=ns1.domain1.net

# default-ttl   Seconds a result is valid if not set otherwise
default-ttl=3600

# Отключаем guardian
guardian=no

# Запускаем и настр. модуль Mysql
launch=gmysql

gmysql-host=127.0.0.1
gmysql-port=3306
gmysql-user=power_admin
gmysql-dbname=powerdns
gmysql-password=master

# Указываем какие ИП слушать
# если вы не используете recursor то можно поставить 0.0.0.0 (все интерфейсы)
local-address=0.0.0.0

# IPv6 я не использую, по этому не ставлю
# local-ipv6=

# Порт который надо слушать
local-port=53

# Логим все
logfile=/var/log/pdns/pdns.log
loglevel=9

# Включаем подержу Master, он же у нас мастер
master=yes

# max-queue-length      Maximum queuelength before considering situation lost
max-queue-length=5000

# Макс. кол-во подключении TCP соед.
max-tcp-connections=10

# Указываем на наш Recursor,
# если вы не ставили PowerDNS-Recursor, то пропускаем
#recursor=127.0.0.1

# Не забудьте создать Юзера pdns принадлежащий группе pdns
setgid=pdns
setuid=pdns

# Включаем подержу slave, у нас есть один slave домен
slave=yes
slave-cycle-interval=600

# smtpredirector        Our smtpredir MX host
smtpredirector=

# soa-expire-default    Default SOA expire
soa-expire-default=604800

# soa-minimum-ttl       Default SOA mininum ttl
soa-minimum-ttl=3600

# soa-refresh-default   Default SOA refresh
soa-refresh-default=10800

# soa-retry-default     Default SOA retry
soa-retry-default=3600

# soa-serial-offset     Make sure that no SOA serial is less than this number
soa-serial-offset=0

# socket-dir    Where the controlsocket will live
socket-dir=/var/run

# use-logfile   Use a log file
use-logfile=yes

# Показываем версию POWERDNS в пакетах - full, anonymous, powerdns or custom
version-string=powerdns

# Включаем ВЕБ сервер для мониторинга
webserver=yes

# ИП каторую надо слушать я указал на локальную сеть
webserver-address=192.168.100.2

# Пасс на веб сервер он мне не нужен
# webserver-password=

# Порт на веб сервер, смотрите чтобы он не был занять другой ПО, например
# Apache
webserver-port=443

webserver-print-arguments=yes

Код: Выделить всё

sockstat | grep 443

Код: Выделить всё

sockstat | grep 443
www      httpd      1334  4  tcp4   *:443                 *:*
www      httpd      950   4  tcp4   *:443                 *:*
www      httpd      949   4  tcp4   *:443                 *:*
www      httpd      948   4  tcp4   *:443                 *:*
www      httpd      947   4  tcp4   *:443                 *:*
www      httpd      946   4  tcp4   *:443                 *:*
www      httpd      945   4  tcp4   *:443                 *:*
www      httpd      944   4  tcp4   *:443                 *:*
root     httpd      872   4  tcp4   *:443                 *:*

Код: Выделить всё

# Порт на веб сервер, смотрите чтобы он не был занять другой ПО, например
# Apache
webserver-port=443

Код: Выделить всё

 ./etc/rc.subr

############################
pdns_uid=120;
pdns_gid=120;
############################

name=pdns

Код: Выделить всё

SET SESSION sql_mode='ANSI';

CREATE TABLE "domains" (
	"id" INTEGER NOT NULL AUTO_INCREMENT,
	"name" VARCHAR(255) NOT NULL,
	"type" VARCHAR(6) NOT NULL,
	"master" VARCHAR(40) NOT NULL DEFAULT '',
	"account" VARCHAR(40) NOT NULL DEFAULT '',
	"last_check" INTEGER DEFAULT NULL,
	"notified_serial" INTEGER DEFAULT NULL,
	"auto_serial" INTEGER NOT NULL DEFAULT 0,
	"status" CHAR(1) NOT NULL DEFAULT 'A',
CONSTRAINT "pdns_pk_domains_id"
	PRIMARY KEY ("id"),
CONSTRAINT "pdns_unq_domains_name"
	UNIQUE ("name")
) type=InnoDB;

CREATE INDEX "pdns_idx_domains_status_type" ON "domains" ("status","type");



CREATE TABLE "records" (
	"id" INTEGER NOT NULL AUTO_INCREMENT,
	"domain_id" INTEGER NOT NULL,
	"name" VARCHAR(255) NOT NULL,
	"type" VARCHAR(6) NOT NULL,
	"content" VARCHAR(255) NOT NULL,
	"ttl" INTEGER DEFAULT NULL,
	"prio" INTEGER DEFAULT NULL,
	"change_date" INTEGER(11) DEFAULT NULL,
CONSTRAINT "pdns_pk_records_id"
	PRIMARY KEY ("id"),
CONSTRAINT "pdns_fk_records_domainid"
	FOREIGN KEY ("domain_id")
	REFERENCES "domains" ("id")
	ON UPDATE CASCADE
	ON DELETE CASCADE
) type=InnoDB;


 

CREATE INDEX "pdns_idx_records_name_type" ON "records" ("name","type");
CREATE INDEX "pdns_idx_records_type" ON "records" ("type");



CREATE TABLE "supermasters" (
	"ip" VARCHAR(40) NOT NULL,
	"nameserver" VARCHAR(255) NOT NULL,
	"account" VARCHAR(40) NOT NULL DEFAULT ''
);

CREATE INDEX "pdns_idx_smaster_ip_ns" ON "supermasters" ("ip","nameserver");



GRANT SELECT ON "supermasters" TO "powerdns";
GRANT ALL ON "domains" TO "powerdns";
GRANT ALL ON "records" TO "powerdns";



DELIMITER :

CREATE TRIGGER "pdns_trig_records_insert"
AFTER INSERT ON "records"
FOR EACH ROW BEGIN
	UPDATE "domains" d SET d."auto_serial" = d."auto_serial" + 1
	WHERE d."id" = NEW."domain_id";
END;:

CREATE TRIGGER "pdns_trig_records_update"
AFTER UPDATE ON "records"
FOR EACH ROW BEGIN
	UPDATE "domains" d SET d."auto_serial" = d."auto_serial" + 1
	WHERE d."id" = NEW."domain_id";
END;:

CREATE TRIGGER "pdns_trig_records_delete"
AFTER DELETE ON "records"
FOR EACH ROW BEGIN
	UPDATE "domains" d SET d."auto_serial" = d."auto_serial" + 1
	WHERE d."id" = OLD."domain_id";
END;:

DELIMITER ;

Код: Выделить всё

powerdns-2.9.22_2   An advanced DNS server with multiple backends including SQL
powerdns-recursor-3.2 An advanced DNS recursor

Код: Выделить всё

Deprecated: Assigning the return value of new by reference is deprecated in /usr/local/share/pear/MDB2.php on line 393
Strict Standards: Redefining already defined constructor for class MDB2_Driver_Common in /usr/local/share/pear/MDB2.php on line 1357
Deprecated: Assigning the return value of new by reference is deprecated in /usr/local/share/pear/MDB2.php on line 2647
Strict Standards: Redefining already defined constructor for class MDB2_Result_Common in /usr/local/share/pear/MDB2.php on line 3458
Strict Standards: Redefining already defined constructor for class MDB2_Row in /usr/local/share/pear/MDB2.php on line 3929
Strict Standards: Redefining already defined constructor for class MDB2_Statement_Common in /usr/local/share/pear/MDB2.php on line 3986
Strict Standards: Redefining already defined constructor for class MDB2_Module_Common in /usr/local/share/pear/MDB2.php on line 4278
Strict Standards: Non-static method PEAR::setErrorHandling() should not be called statically in /usr/local/www/poweradmin/inc/database.inc.php on line 31
Strict Standards: Non-static method MDB2::connect() should not be called statically in /usr/local/www/poweradmin/inc/database.inc.php on line 77
Strict Standards: Non-static method MDB2::factory() should not be called statically in /usr/local/share/pear/MDB2.php on line 436
Strict Standards: Non-static method MDB2::parseDSN() should not be called statically in /usr/local/share/pear/MDB2.php on line 379
Strict Standards: Non-static method MDB2::loadClass() should not be called statically in /usr/local/share/pear/MDB2.php on line 388
Strict Standards: Non-static method MDB2::classExists() should not be called statically in /usr/local/share/pear/MDB2.php on line 330
Strict Standards: Non-static method PEAR::isError() should not be called statically in /usr/local/share/pear/MDB2.php on line 389
Strict Standards: Non-static method MDB2::parseDSN() should not be called statically, assuming $this from incompatible context in /usr/local/share/pear/MDB2.php on line 2353
Strict Standards: Non-static method MDB2::setOptions() should not be called statically in /usr/local/share/pear/MDB2.php on line 395
Strict Standards: Non-static method PEAR::isError() should not be called statically in /usr/local/share/pear/MDB2.php on line 396
Strict Standards: Non-static method PEAR::isError() should not be called statically in /usr/local/share/pear/MDB2.php on line 437
Strict Standards: Non-static method MDB2::areEquals() should not be called statically, assuming $this from incompatible context in /usr/local/share/pear/MDB2/Driver/mysql.php on line 563
Strict Standards: Non-static method PEAR::isError() should not be called statically in /usr/local/share/pear/MDB2.php on line 442
Strict Standards: Non-static method MDB2::isError() should not be called statically in /usr/local/www/poweradmin/inc/database.inc.php on line 80

Код: Выделить всё

advsrv# pkg_info | grep php
php5-5.3.2_1        PHP Scripting Language
php5-bz2-5.3.2_1    The bz2 shared extension for php
php5-ctype-5.3.2_1  The ctype shared extension for php
php5-filter-5.3.2_1 The filter shared extension for php
php5-gd-5.3.2_1     The gd shared extension for php
php5-gettext-5.3.2_1 The gettext shared extension for php
php5-mbstring-5.3.2_1 The mbstring shared extension for php
php5-mcrypt-5.3.2_1 The mcrypt shared extension for php
php5-mysql-5.3.2_1  The mysql shared extension for php
php5-openssl-5.3.2_1 The openssl shared extension for php
php5-session-5.3.2_1 The session shared extension for php
php5-xml-5.3.2_1    The xml shared extension for php
php5-zip-5.3.2_1    The zip shared extension for php
php5-zlib-5.3.2_1   The zlib shared extension for php
phpMyAdmin-3.3.3    A set of PHP-scripts to manage MySQL over the web

advsrv# pkg_info | grep pear
pear-1.9.0          PEAR framework for PHP
pear-DB-1.7.13,1    PEAR Database Abstraction Layer
pear-MDB2-2.5.0.b2  PEAR database abstraction layer
pear-MDB2_Driver_mysql-1.5.0.b2 PEAR mysql MDB2 driver

Код: Выделить всё

include_path="/usr/local/share/pear"

Код: Выделить всё

error-reporting = E_ALL | E_STRICT

Код: Выделить всё

error_reporting = E_COMPILE_ERROR|E_ERROR|E_CORE_ERROR