Hello again,
I found this was already a topic in this list:
https://lists.opendnssec.org/pipermail/opendnssec-user/2017-March/003974.html
Sorry, for that.
I think the explanation for my problem is that the mysql 8 hours default
timeout exceeds. As I have only one zone configured at the moment there
are no queries in the meantime.
I set the wait_timeout value to 86400. I guess this will solve the problem.
Thanks,
Thomas
Am 06.11.2017 um 12:45 schrieb Thomas E.:
Hello!
I running OpenDNSSEC Version 2.1.3 on Debian Jessie with Mysql DB
Version 5.5.58.
The ODS-Enforcer seems to lose connection to the MySQL DB after a
certain amount of time:
Nov 6 02:02:35 ods ods-enforcerd: DB prepare SQL SELECT zone.id,
zone.rev, zone.policyId, zone.name, zone.signconfNeedsWriting,
zone.signconfPath, zone.nextChange, zone.ttlEndDs, zone.ttlEndDk,
zone.ttlEndRs, zone.rollKskNow, zone
.rollZskNow, zone.rollCskNow, zone.inputAdapterType,
zone.inputAdapterUri, zone.outputAdapterType, zone.outputAdapterUri,
zone.nextKskRoll, zone.nextZskRoll, zone.nextCskRoll FROM zone WHERE
zone.name = ?
Nov 6 02:02:35 ods ods-enforcerd: DB prepare Err 2006: MySQL server has
gone away
Has anyone experienced the same issue? Is this somehow related to any
kind of connection-pooling or anything like this?
Thanks a lot,
Thomas
_______________________________________________
Opendnssec-user mailing list
[email protected]
https://lists.opendnssec.org/mailman/listinfo/opendnssec-user
_______________________________________________
Opendnssec-user mailing list
[email protected]
https://lists.opendnssec.org/mailman/listinfo/opendnssec-user
