[Pdns-users] pdns user owned domains

[frank+pdns at tembo.be]

OK, then let’s go back to my first question:

> Could you tell us where and how you can “see” the users? Do you use some kind of web-frontend?

Frank


> On 28 May 2019, at 13:03, Udayakumar S <uday at connaxis.hosting <mailto:uday at connaxis.hosting>> wrote:
> 
> MariaDB [powerdns]> select * from domains where account = 'ricardo';
> Empty set (0.00 sec)
> 
> MariaDB [powerdns]> describe domains
>     -> ;
> +-----------------+--------------+------+-----+---------+----------------+
> | Field           | Type         | Null | Key | Default | Extra          |
> +-----------------+--------------+------+-----+---------+----------------+
> | id              | int(11)      | NO   | PRI | NULL    | auto_increment |
> | name            | varchar(255) | NO   | UNI | NULL    |                |
> | master          | varchar(128) | YES  |     | NULL    |                |
> | last_check      | int(11)      | YES  |     | NULL    |                |
> | type            | varchar(6)   | NO   |     | NULL    |                |
> | notified_serial | int(11)      | YES  |     | NULL    |                |
> | account         | varchar(40)  | YES  |     | NULL    |                |
> +-----------------+--------------+------+-----+---------+----------------+
> 
> not showing any domains, any clue ?
> 
> On Tue, May 28, 2019 at 4:02 PM frank+pdns--- via Pdns-users <pdns-users at mailman.powerdns.com <mailto:pdns-users at mailman.powerdns.com>> wrote:
> 
> > 
> > In powerdns we can see the users. users are connected to domains. 
> 
> Hi,
> 
> Could you tell us where and how you can “see” the users? Do you use some kind of web-frontend?
> 
> > 
> > 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.
> > 
> > anybody knows, how to list user owned domains from the powerdns DB ?
> 
> It depends on how ricardo’s domains ended up in the system.
> 
> You might want to check if the following SQL query gives you any results:
> 
> select * from domains where account = ‘ricardo’;
> 
> 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…
> 
> Kind Regards,
> 
> 
> Frank Louwers
> PowerDNS Certified Consultant @ Kiwazo.be <http://kiwazo.be/>
> 
> 
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com <mailto:Pdns-users at mailman.powerdns.com>
> https://mailman.powerdns.com/mailman/listinfo/pdns-users <https://mailman.powerdns.com/mailman/listinfo/pdns-users>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20190528/2869e21a/attachment.html>