Can you run one more? SELECT * FROM records WHERE domain_id = <domain_id>
Aki On Tue, Feb 18, 2014 at 02:08:08PM -0500, Chris Moody wrote: > =====[ master ]===== > mysql> SELECT * FROM records WHERE name = "." OR name = ""; > Empty set (0.00 sec) > ===== > > =====[ slave ]===== > mysql> SELECT * FROM records WHERE name = "." OR name = ""; > Empty set (0.00 sec) > ===== > > Is there some SQL or dig-querying from the slave perspective that I > can try checking? I've tried to piece together the full schema from > the various locations in the docs but am wondering if there's > perhaps not some other underlying trouble. > > I just added a brand new domain and it's giving me the same > behavior. The docs aren't very clear in some places IMHO so I could > very well have missed something. > (also, once I have this sorted out, I'llgladly volunteer to help get > the docs more solidified and clear). > > On the slave, I just nuked the schema and started from scratch. > > ex, some schema is here: > http://doc.powerdns.com/html/generic-mypgsql-backends.html#idp10177984 > but that seems to miss fields like auto_serial & status. > > because as soon as I start the daemon with the schema in the docs, I > see these log errors: > === > Feb 18 19:01:21 nyny-dp-1 pdns[5561]: [OpendbxBackend] execStmt: > Unable to execute query - Unknown column 'd.auto_serial' in 'field > list' > Feb 18 19:05:21 nyny-dp-1 pdns[5561]: [OpendbxBackend] execStmt: > Unable to execute query - Unknown column 'd.status' in 'where > clause' > === > > I found a reference to some schema that includes auto_serial here: > http://www.dwolfix.ru/uctanovka-i-nastroyka-dns-servera-powerdns.html > and then altered tables to include this column. > > Had to do the same exercise to get the 'status' column included as well. > > Cheers, > -Chris > > > On 2/18/14 1:25 PM, Aki Tuomi wrote: > >SELECT * FROM records WHERE name = "." OR name = "" > > _______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
