View source for PowerDNS (with SolusVM ) mysql

Some examples for solusvm mysql db

Solusvm DB name looks like some ID.
 mysql

 show databases;
 use <solusvmDBname_likeID> ;
 
 show tables;

show all servers with IP like specified:
  select vserverid, mainipaddress, hostname from vservers  where mainipaddress like '185.31%'; 

show all servers with ip like specified and not disabled:
 select vserverid, mainipaddress, hostname, cachestatus, disabled  from vservers  where mainipaddress like '%185.31%' and disabled='0';

change some record example:
 UPDATE vservers SET mainipaddress = '10.10.10.143' WHERE ctid=5342;

select all servers with ip like specified and join with clients table:

 SELECT clients.emailaddress, clients.clientid, vservers.clientid, vservers.vserverid, vservers.mainipaddress, vservers.hostname, 
 vservers.disabled 
 FROM vservers
 JOIN clients ON clients.clientid=vservers.clientid
 WHERE vservers.mainipaddress like '%185.31%' and disabled='0' ;