[prev in list] [next in list] [prev in thread] [next in thread]
List: pdns-users
Subject: Re: [Pdns-users] gmysql is using wrong domain_id
From: Thiago Farina <tfransosi () gmail ! com>
Date: 2016-02-28 18:50:31
Message-ID: CACnwZYcFAFvJVYz_9Dx5iJ-rWrAT6WHHsfx2UqXZS9Bs6pkYqw () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
On Fri, Feb 26, 2016 at 3:03 PM, Laszlo Toth <laszlo.toth@linguamatics.com>
wrote:
> Hi,
>
> I have a strange problem:
> I have 2 pdns servers using the same MySQL database. One is working fine
> but the other is returning no results. SQL traffic analysis via tcpdump
> showed the reason for having no results is because pdns is using wrong
> domain IDs.
>
> domains table:
> +----+-----------------+
> | id | name |
> +----+-----------------+
> | 1 | foo.local |
> | 2 | 10.in.addr.arpa |
> +----+-----------------+
>
> records table:
>
> +------+-----------+-------------------------+------+------------------------+
> | id | domain_id | name | type | content
> |
>
> +------+-----------+-------------------------+------+------------------------+
> | 1 | 1 | dnstest.site.foo.local | A | 10.6.0.16
> |
> | 2 | 2 | 16.0.6.10.in-addr.arpa | PTR |
> dnstest.site.foo.local |
>
> +------+-----------+-------------------------+------+------------------------+
>
> When I query for the A record it is using domain_id = 2, when I query the
> PTR it is using domain_id = 1 to query the database for the record in
> question.
>
> Is it possible to show us this behavior through 'dig' command?
If there is a bug, maybe it is better to file a bug in
https://github.com/PowerDNS/pdns/issues/new,
with reproducible steps.
--
Thiago Farina
[Attachment #5 (text/html)]
<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Feb \
26, 2016 at 3:03 PM, Laszlo Toth <span dir="ltr"><<a \
href="mailto:laszlo.toth@linguamatics.com" \
target="_blank">laszlo.toth@linguamatics.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">Hi,<br>
<br>
I have a strange problem:<br>
I have 2 pdns servers using the same MySQL database. One is working fine but the \
other is returning no results. SQL traffic analysis via tcpdump showed the reason for \
having no results is because pdns is using wrong domain IDs.<br> <br>
domains table:<br>
+----+-----------------+<br>
> id | name |<br>
+----+-----------------+<br>
> 1 | foo.local |<br>
> 2 | 10.in.addr.arpa |<br>
+----+-----------------+<br>
<br>
records table:<br>
+------+-----------+-------------------------+------+------------------------+<br>
> id | domain_id | name | type | content \
> |<br>
+------+-----------+-------------------------+------+------------------------+<br>
> 1 | 1 | dnstest.site.foo.local | A | 10.6.0.16 \
> |<br>
> 2 | 2 | 16.0.6.10.in-addr.arpa | PTR | dnstest.site.foo.local \
> |<br>
+------+-----------+-------------------------+------+------------------------+<br>
<br>
When I query for the A record it is using domain_id = 2, when I query the PTR it is \
using domain_id = 1 to query the database for the record in question.<br> \
<br></blockquote><div>Is it possible to show us this behavior through 'dig' \
command?</div><div><br></div><div>If there is a bug, maybe it is better to file a bug \
in <a href="https://github.com/PowerDNS/pdns/issues/new">https://github.com/PowerDNS/pdns/issues/new</a>,</div><div>with \
reproducible steps.</div></div><div><br></div>-- <br><div \
class="gmail_signature">Thiago Farina</div> </div></div>
[Attachment #6 (text/plain)]
_______________________________________________
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic