<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Courier;
panose-1:2 0 5 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Menlo;
panose-1:2 11 6 9 3 8 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:16.0pt;
font-family:Courier;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Courier;}
p.p1, li.p1, div.p1
{mso-style-name:p1;
margin:0in;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Menlo;
color:black;}
span.s1
{mso-style-name:s1;}
p.p2, li.p2, div.p2
{mso-style-name:p2;
margin:0in;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Menlo;
color:#400BD9;}
span.s2
{mso-style-name:s2;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoPlainText"><span style="font-size:12.0pt">On 4/9/19, 14:17, "Brian Candler" <b.candler@pobox.com> wrote:<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt">>You first need to create a database (e.g. "create database pdns;") and then select it ("use pdns;")<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black">I added these steps. To try to figure out what next, here is some detail on where I am. (I am using HTML mail so I can color code what’s going on. Red I typed to terminal, green is the output,
black is commentary.)<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black">Goal: Replicate the steps on
<a href="https://doc.powerdns.com/authoritative/guides/basic-database.html">https://doc.powerdns.com/authoritative/guides/basic-database.html</a>, going towards using pdnsutil's secure-zone to turn on DNSSEC signing.<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black">I loaded MariaDB on Ubuntu ...(I’m not savvy enough to know the difference between sqlite, mysql and Maria, if that’s the weakness, let me know) ... to the point where this happens:<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:#70AD47"># </span><span style="font-size:12.0pt;color:red">mysql -u root<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:#70AD47">Welcome to the MariaDB monitor. Commands end with ; or \g.<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:#70AD47">Your MariaDB connection id is 49<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:#70AD47">Server version: 10.0.38-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:#70AD47"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:#70AD47">Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:#70AD47"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:#70AD47">Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:#70AD47"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:#70AD47">MariaDB [(none)]></span><span style="font-size:12.0pt;color:red"><o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black">Note - there's no password. When I did the 'apt install' line a few days ago, it never stopped for a password. This will come up later.<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black">In /etc/powerdns, I have pdns.conf and have these lines:<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#B42419">con</span></b><span style="font-family:Courier;color:black">fig-dir=/etc/powerdns<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#B42419">inc</span></b><span style="font-family:Courier;color:black">lude-dir=/etc/powerdns/pdns.d<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#B42419">loc</span></b><span style="font-family:Courier;color:black">al-port=8053<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#B42419">pre</span></b><span style="font-family:Courier;color:black">vent-self-notification=yes<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#B42419">sec</span></b><span style="font-family:Courier;color:black">urity-poll-suffix=<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#B42419">set</span></b><span style="font-family:Courier;color:black">gid=pdns<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#B42419">set</span></b><span style="font-family:Courier;color:black">uid=pdns<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#B42419">ver</span></b><span style="font-family:Courier;color:black">sion-string=full<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#B42419">wri</span></b><span style="font-family:Courier;color:black">te-pid=yes<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#B42419">bin</span></b><span style="font-family:Courier;color:black">d-check-interval=300<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#B42419">loc</span></b><span style="font-family:Courier;color:black">al-address=127.0.0.1<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#B42419">mas</span></b><span style="font-family:Courier;color:black">ter=yes<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#B42419">set</span></b><span style="font-family:Courier;color:black">gid=pdns<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#B42419">set</span></b><span style="font-family:Courier;color:black">uid=pdns<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#B42419">lau</span></b><span style="font-family:Courier;color:black">nch=gmysql<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#B42419">gmy</span></b><span style="font-family:Courier;color:black">sql-host=127.0.0.1<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#B42419">gmy</span></b><span style="font-family:Courier;color:black">sql-user=root<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#B42419">gmy</span></b><span style="font-family:Courier;color:black">sql-dbname=pdns<o:p></o:p></span></p>
<p class="p2"><span class="s1"><span style="font-size:12.0pt;font-family:Courier">#gmysql-password=mysecretpassword</span></span><span style="font-size:12.0pt;font-family:Courier"><o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black">I use service pdns start and stop to run PowerDNS. One note – the password is commented out as there’s no password for the MariaDB as it is installed. (I wouldn’t stand for this in a real
environment.)<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black">In MariaDB (continuing above) I added the create and use lines and then cut and pasted the configuration from the web page mentioned above:<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:#70AD47">MariaDB [(none)]></span><span style="font-family:Courier;color:black">
</span><span style="font-family:Courier;color:red">create database pdns;</span><span style="font-family:Courier;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#70AD47">Query OK, 1 row affected (0.00 sec)</span></b><span style="font-family:Courier;color:#70AD47"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:#70AD47">MariaDB [(none)]></span><span style="font-family:Courier;color:black">
</span><span style="font-family:Courier;color:red">use pdns;</span><span style="font-family:Courier;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#70AD47">Database changed</span></b><span style="font-family:Courier;color:#70AD47"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:#70AD47">MariaDB [pdns]></span><span style="font-family:Courier;color:black">
</span><span style="font-family:Courier;color:red">CREATE TABLE domains (<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:red"> -> id INT AUTO_INCREMENT,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:red"> -> name VARCHAR(255) NOT NULL,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:red"> -> master VARCHAR(128) DEFAULT NULL,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:red"> -> last_check INT DEFAULT NULL,<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black">...<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:#70AD47">MariaDB [pdns]></span><span style="font-family:Courier;color:black">
</span><span style="font-family:Courier;color:red">CREATE UNIQUE INDEX namealgoindex ON tsigkeys(name, algorithm);</span><span style="font-family:Courier;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#70AD47">Query OK, 0 rows affected (0.00 sec)</span></b><span style="font-family:Courier;color:#70AD47"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#70AD47">Records: 0 Duplicates: 0 Warnings: 0</span></b><span style="font-family:Courier;color:#70AD47"><o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black">I then go on to fill in some data, more copy-and-paste from the website:<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:#70AD47">MariaDB [pdns]></span><span style="font-family:Courier;color:black">
</span><span style="font-family:Courier;color:red">INSERT INTO domains (name, type) values ('example.com', 'NATIVE');<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#70AD47">Query OK, 1 row affected (0.00 sec)</span></b><span style="font-family:Courier;color:#70AD47"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:black">...(skipping over what’s in the webpage example)...<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:#70AD47">MariaDB [pdns]></span><span style="font-family:Courier;color:black">
</span><span style="font-family:Courier;color:red">INSERT INTO records (domain_id, name, content, type,ttl,prio)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:red"> -> VALUES (1,'example.com','mail.example.com','MX',120,25);</span><span style="font-family:Courier;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:Courier;color:#70AD47">Query OK, 1 row affected (0.00 sec)</span></b><span style="font-family:Courier;color:#70AD47"><o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black">I then ‘</span><span style="font-size:12.0pt;color:red">service pdns start</span><span style="font-size:12.0pt;color:black">’ and look in syslogs:<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:red">tail -f /var/log/syslog | grep "pdns"<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black">...<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:#70AD47">Apr 10 12:27:56
</span><span style="font-family:Courier;color:black">$host</span><span style="font-family:Courier;color:#70AD47">
<b>pdns</b>[10489]: Guardian is launching an instance<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:#70AD47">Apr 10 12:27:56
</span><span style="font-family:Courier;color:black">$host</span><span style="font-family:Courier;color:#70AD47">
<b>pdns</b>[10489]: Reading random entropy from '/dev/urandom'<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:#70AD47">Apr 10 12:27:56
</span><span style="font-family:Courier;color:black">$host</span><span style="font-family:Courier;color:#70AD47">
<b>pdns</b>[10489]: Loading '/usr/lib/x86_64-linux-gnu/<b>pdns</b>/libgmysqlbackend.so'<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:#70AD47">Apr 10 12:27:56
</span><span style="font-family:Courier;color:black">$host</span><span style="font-family:Courier;color:#70AD47">
<b>pdns</b>[10489]: Unable to load module '/usr/lib/x86_64-linux-gnu/<b>pdns</b>/libgmysqlbackend.so': /usr/lib/x86_64-linux-gnu/<b>pdns</b>/libgmysqlbackend.so: cannot open shared object file: No such file or directory<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:#70AD47">Apr 10 12:27:56
</span><span style="font-family:Courier;color:black">$host</span><span style="font-family:Courier;color:#70AD47">
<b>pdns</b>[10489]: DNSBackend unable to load module in gmysql<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:#70AD47">Apr 10 12:27:57
</span><span style="font-family:Courier;color:black">$host</span><span style="font-family:Courier;color:#70AD47">
<b>pdns</b>[10485]: Our <b>pdns</b> instance exited with code 1, respawning<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:#70AD47"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:Courier;color:black">My question is ... I’m following the instructions on the page (and with help from the list), yet I can’t replicate the page’s results. What do I need to ‘learn’ here?<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
</body>
</html>