Yes. MySQL has wait_timeout set to 8 hours. See last option: http://dev.mysql.com/doc/refman/5.0/en/instance-manager-command-options.html
Ivan Kalik Kalik Informatika ISP Dana 19/7/2007, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> piše: >Hello FR users, > >I am running FreeRadius 1.1.3 together with MySQL 5.0.27 >I use huntgroups to allow access to specific devices only to certain users >belonging to a certain group (I use huntgroups since "I" didnt find a way >to do it via MySQL) >I have the following issue: >When for a longer period (e.g. over night) no one logs into one of the >devices (so the radius server sits idle), it happens that the first time in >the morning someone tries to login he fails because FR rejects the Request >with "invalid user" - only after 3 or 4 tries the login-attempt is >successfull >The reason seems to be, that after such a "long" dormant period, when the >first RADIUS-request(s) arrive, FR has to re-connect to the MySQL DB to >query the user's group-membership >Since this re-connect takes "too long" the query returns "Not found" and >the user is rejected as "unknown" > >Here is what you see in the radius.log file: >Tue Jul 17 08:05:16 2007 : Info: rlm_sql_mysql: Starting connect to MySQL >server for #9 >Tue Jul 17 08:05:16 2007 : Error: rlm_sql (sql): failed after re-connect >Tue Jul 17 08:05:16 2007 : Auth: No huntgroup access: [xxx] (from client >ATWRE22e7601 port 1 cli 10.0.0.31) >Tue Jul 17 08:05:16 2007 : Auth: Invalid user: [xxx] (from client >ATWRE22e7601 port 1 cli 10.0.0.31) >Tue Jul 17 08:05:25 2007 : Info: rlm_sql_mysql: Starting connect to MySQL >server for #8 >Tue Jul 17 08:05:25 2007 : Error: rlm_sql (sql): failed after re-connect >Tue Jul 17 08:05:25 2007 : Auth: No huntgroup access: [xxx] (from client >ATWRE22e7601 port 0) >Tue Jul 17 08:05:25 2007 : Auth: Invalid user: [xxx] (from client >ATWRE22e7601 port 0) >Tue Jul 17 08:05:38 2007 : Info: rlm_sql_mysql: Starting connect to MySQL >server for #7 >Tue Jul 17 08:05:38 2007 : Error: rlm_sql (sql): failed after re-connect >Tue Jul 17 08:05:38 2007 : Auth: No huntgroup access: [xxx] (from client >ATWRE22e7601 port 0) >Tue Jul 17 08:05:38 2007 : Auth: Invalid user: [xxx] (from client >ATWRE22e7601 port 0) >Tue Jul 17 08:06:00 2007 : Info: rlm_sql_mysql: Starting connect to MySQL >server for #6 >Tue Jul 17 08:06:00 2007 : Auth: Login OK: [xxx] (from client ATWRE22b7201 >port 2 cli 10.0.0.31) > >Hope the logfile is sufficient, otherwise I would have to let FR run in >debug-mode over night.... > >The funny thing is, that this problem doesn't occure when all entries in >the huntgroups file are "commented out" > >So my question is, is there a config parameter to tell FR to "wait" a bit >longer in the preprocess module (I assume) for the MYSQL query to deliver >its answer? > >thanks alot >regards >thomas pudil > > > >- >List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
