Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 1

Displaying posts with tag: aaa (reset)

Cisco Access Registrar ODBC Remote Server KeepAliveTimerInterval
+0 Vote Up -0Vote Down

In a test lab, we ran into a situation where the connection between our Cisco Access Registrar (AAA) server and MySQL server was timing out. This forced the server to reconnect and resulted in the following errors:

 name/radius/1 Error Server 0 ODBC client (DataSource 'my_odbc', Connection 8): SQLExecute failed: SQLState:08S01 NativeError:2006 ErrorText:[MySQL][ODBC 3.51 Driver][mysqld-5.0.21-log] MySQL server has gone away
name/radius/1 Error Server 0 Service odbc has no active remote servers available

Obviously, the MySQL server was still there, but after the wait_timeout expires, the server severs the idle connections. By default, the wait_timeout is set to 8 hours. This is obviously much longer than is usually necessary, but in our test lab, it caused problems every morning.

The fix is

  [Read more...]
Showing entries 1 to 1

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.