<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">OK, then let’s go back to my first question:<div class=""><br class=""></div><div class=""><blockquote type="cite" class=""><div class="gmail_quote"><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding-left: 1ex;">Could you tell us where and how you can “see” the users? Do you use some kind of web-frontend?<br class=""></blockquote></div></blockquote><div class=""><br class=""></div>Frank</div><div class=""><br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On 28 May 2019, at 13:03, Udayakumar S <<a href="mailto:uday@connaxis.hosting" class="">uday@connaxis.hosting</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">MariaDB [powerdns]> select * from domains where account = 'ricardo';<br class=""><b class="">Empty set (0.00 sec)<br class=""></b><br class="">MariaDB [powerdns]> describe domains<br class=""> -> ;<br class="">+-----------------+--------------+------+-----+---------+----------------+<br class="">| Field | Type | Null | Key | Default | Extra |<br class="">+-----------------+--------------+------+-----+---------+----------------+<br class="">| id | int(11) | NO | PRI | NULL | auto_increment |<br class="">| name | varchar(255) | NO | UNI | NULL | |<br class="">| master | varchar(128) | YES | | NULL | |<br class="">| last_check | int(11) | YES | | NULL | |<br class="">| type | varchar(6) | NO | | NULL | |<br class="">| notified_serial | int(11) | YES | | NULL | |<br class="">| account | varchar(40) | YES | | NULL | |<br class="">+-----------------+--------------+------+-----+---------+----------------+<br class=""><div class=""><br class=""></div><div class="">not showing any domains, any clue ?</div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, May 28, 2019 at 4:02 PM frank+pdns--- via Pdns-users <<a href="mailto:pdns-users@mailman.powerdns.com" class="">pdns-users@mailman.powerdns.com</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><br class="">
> <br class="">
> In powerdns we can see the users. users are connected to domains. <br class="">
<br class="">
Hi,<br class="">
<br class="">
Could you tell us where and how you can “see” the users? Do you use some kind of web-frontend?<br class="">
<br class="">
> <br class="">
> I have a user ricardo , the user ricardo has a lot of domains connected, but he says he misses some that he can not see.<br class="">
> <br class="">
> anybody knows, how to list user owned domains from the powerdns DB ?<br class="">
<br class="">
It depends on how ricardo’s domains ended up in the system.<br class="">
<br class="">
You might want to check if the following SQL query gives you any results:<br class="">
<br class="">
select * from domains where account = ‘ricardo’;<br class="">
<br class="">
Does that return the list of “ricardo’s domains”? If so, then look for a domain that’s missing from ricardo’s list (eg: ‘mydomain.tld’), and check the account on that domain…<br class="">
<br class="">
Kind Regards,<br class="">
<br class="">
<br class="">
Frank Louwers<br class="">
PowerDNS Certified Consultant @ <a href="http://Kiwazo.be" class="">Kiwazo.be</a><br class="">
<br class="">
<br class="">
_______________________________________________<br class="">
Pdns-users mailing list<br class="">
<a href="mailto:Pdns-users@mailman.powerdns.com" target="_blank" class="">Pdns-users@mailman.powerdns.com</a><br class="">
<a href="https://mailman.powerdns.com/mailman/listinfo/pdns-users" rel="noreferrer" target="_blank" class="">https://mailman.powerdns.com/mailman/listinfo/pdns-users</a><br class="">
</blockquote></div>
</div></blockquote></div><br class=""></div><div class=""></div></body></html>