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@connaxis.hosting > <mailto:uday@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@mailman.powerdns.com <mailto:pdns-users@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@mailman.powerdns.com <mailto:Pdns-users@mailman.powerdns.com> > https://mailman.powerdns.com/mailman/listinfo/pdns-users > <https://mailman.powerdns.com/mailman/listinfo/pdns-users>
_______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users