Hello together,
I'm not sure, if this is a real problem or my thinking is wrong in this case,
so I will try to describe as best as possible ;)
We're currently using PDNS Auth-Servers in version 4.7.3 with MySQL-Backend. In
our management-interface (PowerDNS-Admin), we're using the comment-feature and
in the past I noticed, that the order of this comments in a zone is sometimes
wrong. I found out, that this only appears, when multiple records for the same
name exists (for example, multiple TXT-Records for @). First, I thought, that
this should be a PowerDNS-Admin related problem, but today, I looked into our
PDNS-Database and found out, that there is only a reference to the domain-id
and not to the record-id. Because of this fact, the comments are ordered
"randomly" in our management-interface and can't be clearly assigned to the
correct record.
Can anybody confirm this behaviour or find my fault?
mysql> select * from comments where name like 'komsa.de%' and type = 'TXT';
+------+-----------+----------+------+-------------+---------+----------------------------+
| id | domain_id | name | type | modified_at | account | comment
|
+------+-----------+----------+------+-------------+---------+----------------------------+
| 1369 | 295 | komsa.de | TXT | 1681369360 | | Digicert
Domain-Validation |
| 1370 | 295 | komsa.de | TXT | 1681369360 | |
|
| 1371 | 295 | komsa.de | TXT | 1681369360 | |
|
| 1372 | 295 | komsa.de | TXT | 1681369360 | |
|
| 1373 | 295 | komsa.de | TXT | 1681369360 | | Swiss-Sign
S-MIME |
| 1374 | 295 | komsa.de | TXT | 1681369360 | |
|
6 rows in set (0,00 sec)
thanks and best regards,
Markus
_______________________________________________
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users
