[Kea-users] 1.3.0 beta not working with mysql

Thomas Markwalder tmark at isc.org
Fri Oct 6 12:00:36 UTC 2017


Hi Bill:

I've attached a test patch if you're willing.   Per MariaDB the max
value for --wait-timeout is 2147483, and we are exceeding that.  I'm
wondering if our attempt to set it is failing silently.   The patch I
sent you attempts to set it to a number well under their max but much
larger than their default.

Thanks,

Thomas



-------------- next part --------------
diff --git a/src/lib/dhcpsrv/mysql_connection.cc b/src/lib/dhcpsrv/mysql_connection.cc
index 827c46571..5987ae572 100644
--- a/src/lib/dhcpsrv/mysql_connection.cc
+++ b/src/lib/dhcpsrv/mysql_connection.cc
@@ -1,4 +1,4 @@
-// Copyright (C) 2012-2017 Internet Systems Consortium, Inc. ("ISC")
+e/ Copyright (C) 2012-2017 Internet Systems Consortium, Inc. ("ISC")
 //
 // This Source Code Form is subject to the terms of the Mozilla Public
 // License, v. 2.0. If a copy of the MPL was not distributed with this
@@ -172,7 +172,7 @@ MySqlConnection::openDatabase() {
     }
 
     // Make sure we have a large idle time window ... say 30 days...
-    const char *wait_time = "SET SESSION wait_timeout = 30 * 86400";
+    const char *wait_time = "SET SESSION wait_timeout = 214000";
     result = mysql_options(mysql_, MYSQL_INIT_COMMAND, wait_time);
     if (result != 0) {
         isc_throw(DbOpenError, "unable to set wait_timeout " <<


More information about the Kea-users mailing list