-
Type:
Bug
-
Status: Resolved
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: OpenDNSSEC 2.0
-
Fix Version/s: None
-
Component/s: Configuration, Distribution
-
Labels:None
-
Environment:
FreeBSD 11, trying to upgrade opendnssec 1.4.12 to 2.0.3
There are more than one problem here, I'll report the packaging ones on freebsd's BTS. (missing schema.mysql in the port, $SCHEMA in convert_mysql doesn't exist)
the mysql_convert.sql script cannot work with MariaDB 10 (nor in any mysql), for (at least) two reasons:
- line 677: strftime() doesn't exist on mysql: ERROR 1305 (42000) at line 664: FUNCTION opendnssec2.strftime does not exist, it can be replaced by UNIX_TIMESTAMP():
{{- WHERE CAST(strftime("%s", REMOTE.dnsseckeys.active) + policy.signaturesValidityDefault as INTEGER) < strftime("%s", "now"));
+ WHERE CAST(UNIX_TIMESTAMP(REMOTE.dnsseckeys.active) + policy.signaturesValidityDefault as INTEGER) < UNIX_TIMESTAMP());}} - line 664: ERROR 1093 (HY000) at line 664: Table 'keyState' is specified twice, both as a target for 'UPDATE' and as a separate source for data - DBA power needed here…