Hi to all, I've installad freeradius on a Debian box with Mysql DB. After the upgrade from freeradius version 1.7 and freeradius 2.x I notice that sometimes, but everyday, the freeradius doesn't respond. I must do a /etc/init.d/freeradius restart In my log: Mon Oct 12 10:24:45 2009 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 The only modification that I have made to conf is: with Freeradius 1.7 radius:/etc/freeradius# cat ../freeradius.orig/acct_users DEFAULT Acct-Status-Type == "Start" Exec-Program = "/etc/freeradius/SCRIPT/userlogin.py %{User-Name}" DEFAULT Acct-Status-Type == "Stop" Exec-Program = "/etc/freeradius/SCRIPT/userlogout.py %{User-Name" on Freeradius 2.x I've modified the accounting conf file: # # Accounting. Log the accounting data # accounting { if (Acct-Status-Type == Start) { update reply { Tmp-String-0 = "%{exec:/etc/freeradius/SCRIPT/userlogin.py %{User-Name}}" } } if (Acct-Status-Type == Stop) { update reply { Tmp-String-0 = "%{exec:/etc/freeradius/SCRIPT/userlogout.py %{User-Name}}" } } I need to launch a script with after login and logout. Maybe this script cause some problems? It's a simple python script that update a field in db (online/offiline flag). Can I substitute this external script with a query inside freeradius? How can I create a custom (new) query and lunch it from the accounting section? # # Accounting. Log the accounting data # accounting { if (Acct-Status-Type == Start) { update reply { LAUNCH MYQUERY HERE FOR A SPECIFIC USER } } if (Acct-Status-Type == Stop) { update reply { LAUNCH MYQUERY HERE FOR A SPECIFIC USER } } OR... may the problem is some slow query... but... how can I debug this? can someone suggest me a method? Best regards. -- Gianni Olivieri SICE Telecomunicazioni ------------------------------------ Via Tazio Nuvolari, 53 55061 - Carraia (LU) - ITALY ------------------------------------------------ Tel. +39 0583 980787 Fax +39 0583 981495 www.sicetelecom.it gianni.olivieri@sicetelecom.it -----------------------------------------------