[Pdns-users] gmysql is using wrong domain_id

[Thiago Farina]

On Fri, Feb 26, 2016 at 3:03 PM, Laszlo Toth <laszlo.toth at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20160228/5766ba6e/attachment.html>