> As it says: "General MySQL knowledge is assumed". But searching for "mysql
> create database" and "mysql grant privileges" should help.
Coming at this as a complete novice in databases, it would help if the PowerDNS
instructions had a pointer. (I know it isn't the job to teach me databases,
but I'm just trying to exercise the DNS functions associated with PowerDNS.)
For 'mysql create database' I was led to do this:
# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 47
Server version: 10.0.38-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
...and then lifting from the page:
https://docs.powerdns.com/authoritative/guides/basic-database.html
MariaDB [(none)]> CREATE TABLE domains (
-> id INT AUTO_INCREMENT,
-> name VARCHAR(255) NOT NULL,
-> master VARCHAR(128) DEFAULT NULL,
-> last_check INT DEFAULT NULL,
-> type VARCHAR(6) NOT NULL,
-> notified_serial INT UNSIGNED DEFAULT NULL,
-> account VARCHAR(40) CHARACTER SET 'utf8' DEFAULT NULL,
-> PRIMARY KEY (id)
-> ) Engine=InnoDB CHARACTER SET 'latin1';
ERROR 1046 (3D000): No database selected
...It seems I'm missing some sort of a SELECT statement...
MariaDB [(none)]>
MariaDB [(none)]> CREATE UNIQUE INDEX name_index ON domains(name);
ERROR 1046 (3D000): No database selected
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]> CREATE TABLE records (
-> id BIGINT AUTO_INCREMENT,
-> domain_id INT DEFAULT NULL,
-> name VARCHAR(255) DEFAULT NULL,
-> type VARCHAR(10) DEFAULT NULL,
-> content VARCHAR(64000) DEFAULT NULL,
-> ttl INT DEFAULT NULL,
-> prio INT DEFAULT NULL,
-> disabled TINYINT(1) DEFAULT 0,
-> ordername VARCHAR(255) BINARY DEFAULT NULL,
-> auth TINYINT(1) DEFAULT 1,
-> PRIMARY KEY (id)
-> ) Engine=InnoDB CHARACTER SET 'latin1';
ERROR 1046 (3D000): No database selected
MariaDB [(none)]>
MariaDB [(none)]> CREATE INDEX nametype_index ON records(name,type);
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> CREATE INDEX domain_id ON records(domain_id);
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> CREATE INDEX ordername ON records (ordername);
ERROR 1046 (3D000): No database selected
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]> CREATE TABLE supermasters (
-> ip VARCHAR(64) NOT NULL,
-> nameserver VARCHAR(255) NOT NULL,
-> account VARCHAR(40) CHARACTER SET 'utf8' NOT NULL,
-> PRIMARY KEY (ip, nameserver)
-> ) Engine=InnoDB CHARACTER SET 'latin1';
ERROR 1046 (3D000): No database selected
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]> CREATE TABLE comments (
-> id INT AUTO_INCREMENT,
-> domain_id INT NOT NULL,
-> name VARCHAR(255) NOT NULL,
-> type VARCHAR(10) NOT NULL,
-> modified_at INT NOT NULL,
-> account VARCHAR(40) CHARACTER SET 'utf8' DEFAULT NULL,
-> comment TEXT CHARACTER SET 'utf8' NOT NULL,
-> PRIMARY KEY (id)
-> ) Engine=InnoDB CHARACTER SET 'latin1';
ERROR 1046 (3D000): No database selected
MariaDB [(none)]>
MariaDB [(none)]> CREATE INDEX comments_name_type_idx ON comments (name, type);
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> CREATE INDEX comments_order_idx ON comments (domain_id,
modified_at);
ERROR 1046 (3D000): No database selected
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]> CREATE TABLE domainmetadata (
-> id INT AUTO_INCREMENT,
-> domain_id INT NOT NULL,
-> kind VARCHAR(32),
-> content TEXT,
-> PRIMARY KEY (id)
-> ) Engine=InnoDB CHARACTER SET 'latin1';
ERROR 1046 (3D000): No database selected
MariaDB [(none)]>
MariaDB [(none)]> CREATE INDEX domainmetadata_idx ON domainmetadata (domain_id,
kind);
ERROR 1046 (3D000): No database selected
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]> CREATE TABLE cryptokeys (
-> id INT AUTO_INCREMENT,
-> domain_id INT NOT NULL,
-> flags INT NOT NULL,
-> active BOOL,
-> content TEXT,
-> PRIMARY KEY(id)
-> ) Engine=InnoDB CHARACTER SET 'latin1';
ERROR 1046 (3D000): No database selected
MariaDB [(none)]>
MariaDB [(none)]> CREATE INDEX domainidindex ON cryptokeys(domain_id);
ERROR 1046 (3D000): No database selected
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]> CREATE TABLE tsigkeys (
-> id INT AUTO_INCREMENT,
-> name VARCHAR(255),
-> algorithm VARCHAR(50),
-> secret VARCHAR(255),
-> PRIMARY KEY (id)
-> ) Engine=InnoDB CHARACTER SET 'latin1';
ERROR 1046 (3D000): No database selected
MariaDB [(none)]>
MariaDB [(none)]> CREATE UNIQUE INDEX namealgoindex ON tsigkeys(name,
algorithm);
ERROR 1046 (3D000): No database selected
MariaDB [(none)]>
MariaDB [(none)]>
...From the same page,
I added this from the top:
launch=gmysql
gmysql-host=127.0.0.1
gmysql-user=root
gmysql-dbname=pdns
gmysql-password=mysecretpassword
and then 'service start pdns'
I see this error message in each spawn...
Unable to load module '/usr/lib/x86_64-linux-gnu/pdns/libgmysqlbackend.so':
/usr/lib/x86_64-linux-gnu/pdns/libgmysqlbackend.so: cannot open shared object
file: No such file or directory
I figure there's a configuration gap here, but can't find it.
_______________________________________________
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users
