[Pdns-users] [E] Re: How to update IP address of records

[Chhavi Mittal]

Hello,

This ALIAS approach is exactly what I was looking for. Thank you for
sharing it.! I tried to set it up and now have both pdns authoritative and
recursor servers running on my host and I have added following entries in
my DB but when I try to do 'dig' on 'example.net' to get the recursor to
return me IP address of the alias its not returning anything at all.
Please help!!

+--------+-----------+----------------------------+------+---------+------+------+-------------+----------+-----------+------+

| id     | domain_id | name                       | type | content | ttl  |
prio | change_date | disabled | ordername | auth |

+--------+-----------+----------------------------+------+---------+------+------+-------------+----------+-----------+------+

| 669948 |      1888 | mywebapp.paas-provider.net | A    | 0.0.0.1 | 1200
|    0 |        NULL |        0 | NULL      |    1 |

| 669946 |      1888 | example.net | ALIAS | mywebapp.paas-provider.net
                                        | 1800 |    0 |        NULL |
  0 | NULL      |    1 |

+--------+-----------+----------------------------+------+---------+------+------+-------------+----------+-----------+------+



DIG Response:

dig @127.0.0.1 example.net


; <<>> DiG 9.11.4-P2-RedHat-9.11.4-26.P2.el7_9.3 <<>> @127.0.0.1 example.net

; (1 server found)

;; global options: +cmd

;; Got answer:

;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 47700

;; flags: qr aa rd; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 1

;; WARNING: recursion requested but not available


;; OPT PSEUDOSECTION:

; EDNS: version: 0, flags:; udp: 1680

;; QUESTION SECTION:

;example.net. IN A


I am expecting the A record to return 0.0.0.1 as the answer.


pdns.conf


launch=gmysql
> gmysql-host=localhost
> gmysql-user=powerdns
> gmysql-password=xxxxxx
> gmysql-dbname=powerdns
> resolver=127.0.0.1:8699
> setuid=pdns
> setgid=pdns


recursor.conf

> local-port=8699
>
forward-zones=.=127.0.0.1




Best,

Chhavi

On Tue, Mar 23, 2021 at 10:48 AM Brian Candler <b.candler at pobox.com> wrote:

> On 23/03/2021 17:29, Chhavi Mittal via Pdns-users wrote:
> > Yes, I didn't realize that the 'content' column is not indexed. It's
> > actually a much bigger problem then.
> > Is there any other smarter way to perform IP address updates?
>
> As well as CNAME, have you looked at the ALIAS pseudo-RR type?
>
>
> https://urldefense.proofpoint.com/v2/url?u=https-3A__doc.powerdns.com_authoritative_guides_alias.html&d=DwICaQ&c=sWW_bEwW_mLyN3Kx2v57Q8e-CRbmiT9yOhqES_g_wVY&r=zhXmtZOB8qouWS1ukhEyCOSrM390DVZ1dg-asUtrEKo&m=0wuKF86HjkpvlRMTNg95Qi4ynx7xgXe_HYZzpyJLKvQ&s=DlKpgJ0pQMVY_DFRgdvc0x7kvTf7h1NRrTjfxnmBcGA&e=
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20210325/3419c826/attachment.htm>