DNSmanager DNSSEC

[Mobiaaa]

Исходные данные
DNSmgr последняя бета
mysql база
db EXTINFO Query: 'SELECT domain.status, key.type, key.active, key.next_key, key.published, key.key_tag, key.algorithm, key.size, key.period, key.revoke_time, key.delete_time FROM core_dnssec_domain domain LEFT JOIN core_dnssec_key key ON key.core_dnssec_domain = domain.id WHERE domain.domain = 'hidden.ru' AND domain.view = 'hidden''
db ERROR query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key ON key.core_dnssec_domain = domain.id WHERE domain.domain = 'hidden.ru' AND' at line 1

key - в mysql это зарезервированное слово
Либо берём в `key`, либо меняем имя алиаса в запросе

[Mobiaaa]

UPD: Удаление доменов в DNSmgr тоже отвалилось по той же причине (!!!!)
db EXTINFO Query: 'SELECT key.published FROM core_dnssec_domain domain LEFT JOIN core_dnssec_key key ON key.core_dnssec_domain = domain.id WHERE domain.domain = 'DOMAIN' AND domain.view = 'VIEW' AND key.type = 'ksk''
Jun 14 13:43:39 [27419:52] db ERROR query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key ON key.core_dnssec_domain = domain.id WHERE domain.domain = 'DOMAIN' A' at line 1

[Mobiaaa]

Прошлые ошибки вижу были решены, но не все
dnssec.log при запуске dnssec.rollover
db EXTINFO Query: 'SELECT domain.domain, domain.view, key.identifier, key.type, key.key_tag, key.active, key.next_key, key.algorithm, key.size, key.period, key.activate_time, key.inactive_time, key.delete_time FROM core_dnssec_domain domain LEFT JOIN core_dnssec_key key ON key.core_dnssec_domain = domain.id WHERE (domain.status='signed' OR domain.status='protected') AND domain.type = 'master' ORDER BY key.publish_time'
db ERROR query error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'key ON key.core_dnssec_domain = domain.id WHERE (domain.status='signed' OR doma' at line 1
backtrace EXTINFO ??? (lib/libmysql.so.5.163.0 + 0x0) [*0x404e680d]
backtrace EXTINFO mgr_db::Connection::Query(std::string const&) (lib/libmgrdb.so.5.163.0 + 0xad) [*0x4031ae5b]
....
Проблема та же

[Dasha]

Здравствуйте. Благодарим за информацию, создала задачу на проверку для отдела тестирования.

[Dasha]

Ориентировочно в 5.165 выйдет исправление.