<div dir="ltr"><div dir="ltr"><font color="#000000">Hello,</font><div><font color="#000000"><br></font></div><div><font color="#000000">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 '<a href="http://example.net/" target="_blank">example.net</a>' to get the recursor to return me IP address of the alias its not returning anything at all.</font></div><div><font color="#000000">Please help!!</font></div><div><font color="#000000"><br></font></div><div><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000">+--------+-----------+----------------------------+------+---------+------+------+-------------+----------+-----------+------+</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000">| id | domain_id | name | type | content | ttl | prio | change_date | disabled | ordername | auth |</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000">+--------+-----------+----------------------------+------+---------+------+------+-------------+----------+-----------+------+</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000">| 669948 | 1888 | <a href="http://mywebapp.paas-provider.net/" target="_blank">mywebapp.paas-provider.net</a> | A | 0.0.0.1 | 1200 | 0 | NULL | 0 | NULL | 1 |</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><font color="#000000">| 669946 | 1888 | <a href="http://example.net/" target="_blank">example.net</a> | ALIAS | <a href="http://mywebapp.paas-provider.net/" target="_blank">mywebapp.paas-provider.net</a> | 1800 | 0 | NULL | 0 | NULL | 1 |<span style="font-variant-ligatures:no-common-ligatures"><br></span></font></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000">+--------+-----------+----------------------------+------+---------+------+------+-------------+----------+-----------+------+<br></font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000"><br></font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000"><br>DIG Response:<br><br></font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000">dig @<a href="http://127.0.0.1/" target="_blank">127.0.0.1</a> <a href="http://example.net/" target="_blank">example.net</a></font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo;min-height:20px"><font color="#000000"><span style="font-variant-ligatures:no-common-ligatures"></span><br></font></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000">; <<>> DiG 9.11.4-P2-RedHat-9.11.4-26.P2.el7_9.3 <<>> @<a href="http://127.0.0.1/" target="_blank">127.0.0.1</a> <a href="http://example.net/" target="_blank">example.net</a></font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000">; (1 server found)</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000">;; global options: +cmd</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000">;; Got answer:</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000">;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 47700</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000">;; flags: qr aa rd; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 1</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000">;; WARNING: recursion requested but not available</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo;min-height:20px"><font color="#000000"><span style="font-variant-ligatures:no-common-ligatures"></span><br></font></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000">;; OPT PSEUDOSECTION:</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000">; EDNS: version: 0, flags:; udp: 1680</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000">;; QUESTION SECTION:</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><span style="font-variant-ligatures:no-common-ligatures"><font color="#000000">;<a href="http://example.net/" target="_blank">example.net</a>.<span style="white-space:pre-wrap"> </span><span style="white-space:pre-wrap"> </span><span style="white-space:pre-wrap"> </span>IN<span style="white-space:pre-wrap"> </span>A</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo;min-height:20px"><font color="#000000"><span style="font-variant-ligatures:no-common-ligatures"></span></font></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><font color="#000000"><br></font></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><font color="#000000">I am expecting the A record to return 0.0.0.1 as the answer.</font></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><font color="#000000"><br></font></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><font color="#000000">pdns.conf</font></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><font color="#000000"><br></font></p><blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" class="gmail_quote"><font color="#000000">launch=gmysql<br>gmysql-host=localhost<br>gmysql-user=powerdns<br>gmysql-password=xxxxxx<br>gmysql-dbname=powerdns<br>resolver=<a href="http://127.0.0.1:8699">127.0.0.1:8699</a><br>setuid=pdns<br>setgid=pdns</font></blockquote><p></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><font color="#000000"><br></font></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><font color="#000000">recursor.conf<br></font></p><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><font color="#000000">local-port=8699<br></font></blockquote><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><font color="#000000">forward-zones=.=127.0.0.1 </font></blockquote><div style=""><font color="#000000"> </font></div><p></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><font color="#000000"><br></font></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><font color="#000000">Best,</font></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;font-family:Menlo"><font color="#000000">Chhavi</font></p></div><input name="virtru-metadata" type="hidden" value="{"email-policy":{"state":"closed","expirationUnit":"days","disableCopyPaste":false,"disablePrint":false,"disableForwarding":false,"enableNoauth":false,"persistentProtection":false,"expandedWatermarking":false,"expires":false,"isManaged":false},"attachments":{},"compose-id":"3","compose-window":{"secure":false}}"></div><br><div class="gmail_quote" style=""><div dir="ltr" class="gmail_attr">On Tue, Mar 23, 2021 at 10:48 AM Brian Candler <<a href="mailto:b.candler@pobox.com">b.candler@pobox.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On 23/03/2021 17:29, Chhavi Mittal via Pdns-users wrote:<br>
> Yes, I didn't realize that the 'content' column is not indexed. It's <br>
> actually a much bigger problem then.<br>
> Is there any other smarter way to perform IP address updates?<br>
<br>
As well as CNAME, have you looked at the ALIAS pseudo-RR type?<br>
<br>
<a href="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=" rel="noreferrer" target="_blank">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=</a> <br>
<br>
</blockquote></div></div>