<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Thanks for t</tt><tt>he suggestions </tt><tt>Peter.</tt><tt><br>
</tt><tt><br>
</tt><tt>That SELECT returns just a single successful row. (The '.'
was just added to the suffix of the </tt><tt>primary &
hostmaster</tt>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<tt> fields as I'm actively trying to debug what's going on).<br>
<br>
===<br>
mysql> SELECT * FROM records WHERE domain_id=457 AND
type='SOA';<br>
+-------+-----------+---------------+------+-------+------+-----------------------------------------------------------------------+-----------+------+----------+<br>
| id | domain_id | name | type | ttl | prio |
content
| ordername | auth | disabled |<br>
+-------+-----------+---------------+------+-------+------+-----------------------------------------------------------------------+-----------+------+----------+<br>
| 35275 | 457 | node-nine.com | SOA | 86400 | NULL |
ns1.node-nine.com. <a class="moz-txt-link-abbreviated" href="mailto:postmaster@node-nine.com">postmaster@node-nine.com</a>. 0 10800 3600 604800
3600 | NULL | NULL | NULL |<br>
+-------+-----------+---------------+------+-------+------+-----------------------------------------------------------------------+-----------+------+----------+<br>
1 row in set (0.00 sec)<br>
===<br>
<br>
the pdnssec command returned a couple duplicate records, which I
just removed, but still seeing the same errors in the logs.<br>
<br>
I've turned on mysql query logging to see if I can find some more
clues. Are there any other queries you can think of that may help
me find the trouble?<br>
<br>
I'm actually even beginning to question whether or not I've got
all the tables & whatnot built correctly. I just added
another new domain and am seeing the same condition.<br>
<br>
-Chris<br>
<br>
</tt>
<div class="moz-cite-prefix">On 2/18/14 10:48 AM, Peter van Dijk
wrote:<br>
</div>
<blockquote
cite="mid:7ED37E7E-E127-4C76-935F-90F9929BBBD8@netherlabs.nl"
type="cite">
<pre wrap="">SELECT * FROM records WHERE domain_id=457 AND type=‘SOA’;</pre>
</blockquote>
<br>
</body>
</html>