diff options
| -rw-r--r-- | packages/powerdns.xml | 208 |
1 files changed, 181 insertions, 27 deletions
diff --git a/packages/powerdns.xml b/packages/powerdns.xml index e236e35d..70643f7b 100644 --- a/packages/powerdns.xml +++ b/packages/powerdns.xml @@ -3,9 +3,6 @@ <name>nmap</name> <donotsave>true</donotsave> <preoutput>yes</preoutput> - <additional_files_needed> - <item>http://www.pfsense.com/packages/config/powerdns.schema</item> - </additional_files_needed> <!-- Menu is where this packages menu will appear --> <menu> <name>PowerDNS</name> @@ -16,28 +13,185 @@ <!-- Do not save invokes a simple input menu and will not update the configuration database. --> <fields> - </fields> - <custom_php_deinstall_command> - system("rm -rf /usr/local/pgsql"); - system("/usr/sbin/pw userdel pgsql"); - system("/usr/bin/killall -9 postgres"); - echo "<p>"; - echo "Reboot required... One moment..."; - echo "<p>"; - system("/sbin/shutdown -r now"); - </custom_php_deinstall_command> - <custom_php_install_command> - echo "<pre>"; - echo "Creating DB..."; - system("/usr/bin/su -l pgsql -c initdb"); - echo "Starting DB..."; - system("/usr/local/etc/rc.d/010.pgsql.sh start"); - system("/usr/bin/su -l pgsql -c \"dropdb powerdns\" "); - system("/usr/bin/su -l pgsql -c \"createdb powerdns\" "); - echo "Creating DB Schema..."; - system("cat /usr/local/pkg/powerdns.schema | /usr/bin/su -l pgsql -c \"psql powerdns\" "); - system("cat /usr/local/www/powerdnsadmin-0.3/docs/postgresql.sql | /usr/bin/su -l pgsql -c \"psql powerdns\" "); - </custom_php_install_command> - <custom_add_php_command> - </custom_add_php_command> + <field> + <fielddescr>pgsql Password</fielddescr> + <fieldname>password</fieldname> + <description>Enter the pgsql users password.</description> + <type>password</type> + </field> + <field> + <fielddescr>pgsql Password AGAIN</fielddescr> + <fieldname>passwordagain</fieldname> + <type>password</type> + </field> + <field> + <fielddescr>IP Address</fielddescr> + <fieldname>ipaddress</fieldname> + <type>input</type> + <value>0.0.0.0</value> + <description>(0.0.0.0 to bind to all)</description> + </field> + <field> + <fielddescr>Cache Time to Live</fielddescr> + <fieldname>cachettl</fieldname> + <type>input</type> + <value>20</value> + <description>Recommended value: 20</description> + </field> + <field> + <fielddescr>Master</fielddescr> + <fieldname>master</fieldname> + <type>select</type> + <options> + <option><name>Yes</name><value>yes</value></option> + <option><name>No</name><value>no</value></option> + </options> + </field> + <field> + <fielddescr>Slave</fielddescr> + <fieldname>slave</fieldname> + <type>select</type> + <options> + <option><name>No</name><value>no</value></option> + <option><name>Yes</name><value>yes</value></option> + </options> + </field> + </fields> + <custom_php_deinstall_command> + system("/usr/local/bin/pg_ctl -m immediate"); + system("rm -rf /usr/local/pgsql"); + system("/usr/sbin/pw userdel pgsql"); + system("/usr/bin/killall -9 postgres"); + echo "<p>"; + echo "Reboot required... One moment..."; + echo "<p>"; + system("/sbin/shutdown -r now"); + </custom_php_deinstall_command> + <custom_php_install_command> + echo "<pre>"; + echo "Creating DB..."; + system("/usr/bin/su -l pgsql -c initdb"); + system("/usr/local/etc/rc.d/010.pgsql.sh start"); + system("/usr/bin/su -l pgsql -c \"dropdb powerdns\" "); + system("/usr/bin/su -l pgsql -c \"createdb powerdns\" "); + $fout = fopen("/usr/local/pkg/powerdns.schema","w"); + /* DATABASE SCHEMA */ + fwrite($fout, "create table domains (\n"); + fwrite($fout, "id SERIAL PRIMARY KEY,\n"); + fwrite($fout, "name VARCHAR(255) NOT NULL,\n"); + fwrite($fout, "master VARCHAR(20) DEFAULT NULL,\n"); + fwrite($fout, "last_check INT DEFAULT NULL,\n"); + fwrite($fout, "type VARCHAR(6) NOT NULL,\n"); + fwrite($fout, "notified_serial INT DEFAULT NULL,\n"); + fwrite($fout, "account VARCHAR(40) DEFAULT NULL\n"); + fwrite($fout, ");\n"); + fwrite($fout, "CREATE UNIQUE INDEX name_index ON domains(name);\n"); + fwrite($fout, "CREATE TABLE records (\n"); + fwrite($fout, " id SERIAL PRIMARY KEY,\n"); + fwrite($fout, " domain_id INT DEFAULT NULL,\n"); + fwrite($fout, " name VARCHAR(255) DEFAULT NULL,\n"); + fwrite($fout, " type VARCHAR(6) DEFAULT NULL,\n"); + fwrite($fout, " content VARCHAR(255) DEFAULT NULL,\n"); + fwrite($fout, " ttl INT DEFAULT NULL,\n"); + fwrite($fout, " prio INT DEFAULT NULL,\n"); + fwrite($fout, " change_date INT DEFAULT NULL,\n"); + fwrite($fout, " CONSTRAINT domain_exists\n"); + fwrite($fout, " FOREIGN KEY(domain_id) REFERENCES domains(id)\n"); + fwrite($fout, " ON DELETE CASCADE\n"); + fwrite($fout, ");\n"); + fwrite($fout, "CREATE INDEX rec_name_index ON records(name);\n"); + fwrite($fout, "CREATE INDEX nametype_index ON records(name,type);\n"); + fwrite($fout, "CREATE INDEX domain_id ON records(domain_id);\n"); + fwrite($fout, "create table supermasters (\n"); + fwrite($fout, " ip VARCHAR(25) NOT NULL,\n"); + fwrite($fout, " nameserver VARCHAR(255) NOT NULL,\n"); + fwrite($fout, " account VARCHAR(40) DEFAULT NULL\n"); + fwrite($fout, ");\n"); + fwrite($fout, "GRANT SELECT ON supermasters TO pgsql;\n"); + fwrite($fout, "GRANT ALL ON domains TO pgsql;\n"); + fwrite($fout, "GRANT ALL ON domains_id_seq TO pgsql;\n"); + fwrite($fout, "GRANT ALL ON records TO pgsql;\n"); + fwrite($fout, "GRANT ALL ON records_id_seq TO pgsql;\n"); + fclose($fout); + system("cat /usr/local/pkg/powerdns.schema | /usr/bin/su -l pgsql -c \"psql powerdns\" "); + echo "Installation completed!"; + </custom_php_install_command> + <custom_add_php_command> + if($password == $passwordagain) { + $fd = popen("/usr/sbin/pw usermod -n pgsql -H 0", "w"); + $salt = md5(time()); + $crypted_pw = crypt($_POST['password'],$salt); + fwrite($fd, $crypted_pw); + pclose($fd); + $fout = fopen("/usr/local/etc/pdns.conf","w"); + fwrite($fout, "launch=gpgsql\n"); + fwrite($fout, "gpgsql-host=127.0.0.1\n"); + fwrite($fout, "gpgsql-dbname=powerdns\n"); + fwrite($fout, "fwrite($fout, "gpgsql-user=pgsql\n"); + fwrite($fout, "gpgsql-password=" . $_POST['password'] . "\n"); + fwrite($fout, "chroot=/var/empty\n"); + fwrite($fout, "disable-tcp=no\n"); + fwrite($fout, "guardian=yes\n"); + fwrite($fout, "webserver=yes\n"); + fwrite($fout, "webserver-address=127.0.0.1\n"); + fwrite($fout, "webserver-port=8081\n"); + fwrite($fout, "local-address=" . $ipaddress . "\n";"); + fwrite($fout, "master=" . $POST['master'] . "\n"); + fwrite($fout, "slave=" . $POST['slave'] . "\n"); + fwrite($fout, "cache-ttl=" . $POST['cachettl'] . "\n"); + /* XXX: TODO */ + fwrite($fout, "# allow-axfr-ips=\n"); + fwrite($fout, "# allow-recursion=\n"); + fwrite($fout, "# config-dir=/etc\n"); + fwrite($fout, "# config-name=\n"); + fwrite($fout, "# control-console=no\n"); + fwrite($fout, "# default-soa-name=ns.example.com\n"); + fwrite($fout, "# disable-axfr=no\n"); + fwrite($fout, "# distributor-threads=3\n"); + fwrite($fout, "# fancy-records=no\n"); + fwrite($fout, "# launch=\n"); + fwrite($fout, "# lazy-recursion=yes\n"); + fwrite($fout, "# load-modules=\n"); + fwrite($fout, "# local-ipv6=\n"); + fwrite($fout, "# local-port=53\n"); + fwrite($fout, "# log-dns-details=\n"); + fwrite($fout, "# log-failed-updates=\n"); + fwrite($fout, "# logfile=pdns.log\n"); + fwrite($fout, "# logging-facility=\n"); + fwrite($fout, "# loglevel=4\n"); + fwrite($fout, "# max-queue-length=5000\n"); + fwrite($fout, "# max-tcp-connections=10\n"); + fwrite($fout, "# module-dir=/usr/local/bin/../lib\n"); + fwrite($fout, "# negquery-cache-ttl=60\n"); + fwrite($fout, "# only-soa=org\n"); + fwrite($fout, "# out-of-zone-additional-processing=no\n"); + fwrite($fout, "# query-cache-ttl=20\n"); + fwrite($fout, "# query-logging=no\n"); + fwrite($fout, "# queue-limit=1500\n"); + fwrite($fout, "# receiver-threads=1\n"); + fwrite($fout, "# recursive-cache-ttl=10\n"); + fwrite($fout, "# recursor=no\n"); + fwrite($fout, "# setgid=\n"); + fwrite($fout, "# setuid=\n"); + fwrite($fout, "# skip-cname=no\n"); + fwrite($fout, "# slave=no\n"); + fwrite($fout, "# slave-cycle-interval=60\n"); + fwrite($fout, "# soa-minimum-ttl=3600\n"); + fwrite($fout, "# soa-serial-offset=0\n"); + fwrite($fout, "# socket-dir=/var/run\n"); + fwrite($fout, "# strict-rfc-axfrs=no\n"); + fwrite($fout, "# urlredirector=127.0.0.1\n"); + fwrite($fout, "# use-logfile=no\n"); + fwrite($fout, "# webserver-password=\n"); + fwrite($fout, "# webserver-print-arguments=no\n"); + fwrite($fout, "# wildcard-url=no\n"); + fwrite($fout, "# wildcards=\n"); + fclose($fout); + system("/usr/local/bin/pg_ctl -m smart"); + system("/usr/local/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start"); + } else { + echo "Passwords do not much! + exit; + } + </custom_add_php_command> </packagegui>
\ No newline at end of file |