<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Francisco Hernando on Medium]]></title>
        <description><![CDATA[Stories by Francisco Hernando on Medium]]></description>
        <link>https://medium.com/@fhc.silv?source=rss-402b3a1a06ec------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*yk1e52W7D7kyJlQSC-durQ.jpeg</url>
            <title>Stories by Francisco Hernando on Medium</title>
            <link>https://medium.com/@fhc.silv?source=rss-402b3a1a06ec------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 05:02:20 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@fhc.silv/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Running PowerDNS in the local environment with PowerDNS-Admin]]></title>
            <link>https://medium.com/@fhc.silv/running-powerdns-in-the-local-environment-with-powerdns-admin-d4872c793a9b?source=rss-402b3a1a06ec------2</link>
            <guid isPermaLink="false">https://medium.com/p/d4872c793a9b</guid>
            <dc:creator><![CDATA[Francisco Hernando]]></dc:creator>
            <pubDate>Thu, 12 Aug 2021 13:07:20 GMT</pubDate>
            <atom:updated>2021-08-13T17:16:13.607Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*JzukMQw_TlTta-VkqlJGUw.png" /></figure><h3><strong>Introduction</strong></h3><p>Power DNS is an alternative Open Source DNS server. It can be used with many different databases like MariaDB, MySQL, SQLite3, etc.</p><p>This article intends to show how we can use power DNS with a docker container. First of all, we need to create a docker-compose.yml file with the structure for that.</p><p>In this example, we used a Ubuntu 20.04 version, but you can use it on windows too.</p><h4><strong>Docker Installation</strong></h4><p>You can get a correct Docker version based on your OS at:</p><pre><a href="https://www.docker.com/get-started">https://www.docker.com/get-started</a></pre><p>For Linux Ubuntu:</p><pre><strong>engine</strong><br>https://docs.docker.com/engine/install/ubuntu/</pre><pre><strong>compose</strong><br>https://docs.docker.com/compose/install/</pre><h4>Compose file</h4><p>After installing Docker and docker-compose, you can create a <strong>docker-compose.yml </strong>in a proper directory. It’s possible to download compose file <a href="https://github.com/uhernfr/powerdns-docker/blob/2f34ca9f07b452b695da829e4d7fdeba7185102b/docker-compose.yml">here</a></p><pre>pdns:<br>  #build: pdns<br>  image: interlegis/powerdns:4.4.0<br>  links:<br>    - &quot;mysql:mysql&quot;<br>  ports:<br>    - &quot;53:53&quot;<br>    - &quot;53:53/udp&quot;<br>    - &quot;8088:8081&quot;<br>  environment:<br>    - PDNSCONF_API_KEY=a_strong_api_key<br>    - PDNSCONF_DNSUPDATE=yes<br>    - SECALLZONES_CRONJOB=yes<br><br>mysql:<br>  image: bitnami/mariadb:10.1.14-r3<br>  environment:<br>    - MARIADB_ROOT_PASSWORD=mysqlrootpw<br>    - MARIADB_REPLICATION_MODE=master<br>    - MARIADB_REPLICATION_USER=repl_user<br>    - MARIADB_REPLICATION_PASSWORD=repl_password<br>    - MARIADB_DATABASE=pdns <br>    - MARIADB_USER=pdns<br>    - MARIADB_PASSWORD=pdnspw<br>  volumes:<br>    - dnsmasterdb:/bitnami/mariadb<br>  ports:<br>    - 3306:3306<br><br>pdns-mysql:<br>  image: mysql:5.6<br>  container_name: pdns-mysql<br>  restart: always<br>  environment:<br>    - MYSQL_ROOT_HOST=%<br>    - MYSQL_ROOT_PASSWORD=Safe4root123<br>    - MYSQL_DATABASE=pdns-admin<br>    - MYSQL_USER=pdns<br>    - MYSQL_PASSWORD=pdnspass<br>  volumes:<br>    - $PWD/mysql-data:/var/lib/mysql<br><br>powerdns-admin:<br>  image: ngoduykhanh/powerdns-admin:latest<br>  ports:<br>    - &quot;9393:8000&quot;<br>  links:<br>    - pdns-mysql<br>    - pdns<br>  environment:<br>    - SECRET_KEY=admin<br>    - BIND_ADDRESS=0.0.0.0<br>    - PORT=8000<br>    - SQLALCHEMY_DATABASE_URI=mysql://pdns:pdnspass@pdns-mysql/pdns-admin<br>    - GUINCORN_TIMEOUT=60<br>    - GUNICORN_WORKERS=2<br>    - GUNICORN_LOGLEVEL=DEBUG<br>    #- =eqjkwleuiy8yhhdhjasjdkakji9uy</pre><p>Every service can be described as follow:</p><pre><strong>pdns</strong> -&gt; DNS server</pre><pre><strong>mysql</strong> -&gt; database for powerDns. It will include tables for domains, zones, etc</pre><pre><strong>pdns-mysql </strong>-&gt; database for powerdns-admin</pre><pre><strong>powerdns-admin</strong> -&gt; admin for interaction with powerdns</pre><p>To run it, type:</p><pre>docker-compose up</pre><h4>PowerDNS-Admin</h4><p>If everything is correct you will be able to access PowerDNS-Admin, at <a href="http://localhost:9393/"><strong>http://localhost:9393/</strong></a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/824/1*ephBWl42g56fKpym28fJoQ.png" /></figure><p>You need to create a user for the first access. Use Create an Account option</p><p>After login, you will see a dashboard, but you need to indicate your PowerDNS server to admin. You can do that at the <strong>Settings/PDNS</strong> option.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/781/1*jSIV5BJTye3PPLGgyJzgiQ.png" /></figure><pre><strong>PDNS API URL</strong> - set the name of pdns server&#39;s name (service name present in docker-compose.yml) and port. In this case, <a href="http://pdns:8081/"><strong>http://pdns:8081/</strong></a></pre><pre><strong>PDNS API KEY</strong> - the security api key (PDNSCONF_API_KEY) In this example <strong>a_strong_api_key</strong></pre><pre><strong>PDNS VERSION</strong> - PDNS image version (<strong>4.4.0</strong>)</pre><h4><strong>Workaround</strong></h4><p>We have to create a new field into a database to avoid an error on domain creation.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*nFF2a83IU4UV2AbNq5fhQg.png" /></figure><p>So we need to create a connection to MariaDB (you can use an editor like DBeaver for example), then you can log in as follow:</p><pre><strong>server</strong>: localhost <br><strong>port</strong>: 3306<br><strong>username</strong>: pdns<br><strong>password</strong>:pdnspw<br><strong>database</strong>: pdns</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/491/1*CV5p-R4nFJRx7yAY4e8__g.png" /><figcaption>Add field published type bool (it will be converted to tinyint)</figcaption></figure><p>you can also use SQL script:</p><pre>ALTER TABLE <strong>pdns.domains</strong> ADD <strong>published</strong> BOOL NULL;</pre><p>Now you will be able to create a new domain</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*29RwNHgE1ttdzbYGlRQiiQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9QqjYBK0j3hl936u-8h9Cw.png" /></figure><h4><strong>Conclusion</strong></h4><p>Now we have a functional PowerDNS server and its admin.<br>This docker-compose was created as a join of multiples tests (I spend some time trying to make it works). <br>I’ll be happy if this article could help someone.</p><p>See you!</p><h4><strong>References</strong></h4><pre><a href="https://github.com/interlegis/docker-powerdns">https://github.com/interlegis/docker-powerdns</a></pre><pre><a href="https://github.com/pschiffe/docker-pdns">https://github.com/pschiffe/docker-pdns</a></pre><pre><a href="https://github.com/ngoduykhanh/PowerDNS-Admin">https://github.com/ngoduykhanh/PowerDNS-Admin</a></pre><pre><a href="https://rodrigolira.eti.br/gerenciando-o-powerdns-com-o-powerdns-admin/">https://rodrigolira.eti.br/gerenciando-o-powerdns-com-o-powerdns-admin</a></pre><pre><a href="https://github.com/poweradmin/poweradmin">https://github.com/poweradmin/poweradmin</a></pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d4872c793a9b" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>