no wait exec scripts end up as defunct zombie process

4 Feb 2010

      Hi all,

I know the issue  no wait exec scripts end up as defunct zombie process 
was covered previously and appears to have been resolved after version 
1.1(?) but the issue still appears to happening in the latest freeradius.

Has anybody else noticed this?

Linux version 2.6.26-2-amd64 (Debian 2.6.26-19lenny2) (dannf@debian.org) (gcc version 4.1.3 20080704 (prerelease) (Debian 4.1.2-25)) #1 SMP Thu Nov 5 02:23:12 UTC 2009

freeradius: FreeRADIUS Version 2.1.8, for host x86_64-pc-linux-gnu, built on Jan 19 2010 at 14:30:20

freerad   7011     1  7011  7011  0 09:22 ?        00:00:00 /usr/sbin/freeradius -x -n radiusd_bb_services
freerad   7168     1  7168  7168  0 09:22 ?        00:00:00 /usr/sbin/freeradius -x -n radiusd_bb
root      7175  2970  7175  7175  0 09:22 ?        00:00:00 sshd: swarnakulasuriya [priv]
1000      7177  7175  7175  7175  0 09:22 ?        00:00:00 sshd: swarnakulasuriya@pts/0
1000      7178  7177  7178  7178  0 09:22 pts/0    00:00:00 -bash
root      7191  7178  7191  7178  0 09:22 pts/0    00:00:00 su -
root      7192  7191  7192  7178  0 09:23 pts/0    00:00:00 -su
root      7207  2970  7207  7207  0 09:23 ?        00:00:00 sshd: swarnakulasuriya [priv]
1000      7209  7207  7207  7207  0 09:23 ?        00:00:00 sshd: swarnakulasuriya@pts/2
1000      7210  7209  7210  7210  0 09:23 pts/2    00:00:00 -bash
root      7223  7210  7223  7210  0 09:23 pts/2    00:00:00 su -
root      7224  7223  7224  7210  0 09:23 pts/2    00:00:00 -su
freerad   7749  7011  7011  7011  0 09:57 ?        00:00:00 [proxybbrealms] <defunct>
freerad   7755  7011  7011  7011  0 09:57 ?        00:00:00 [proxybbrealms] <defunct>
freerad   7759  7011  7011  7011  0 09:57 ?        00:00:00 [proxybbrealms] <defunct>
freerad   7818  7011  7011  7011  0 10:02 ?        00:00:00 [proxybbrealms] <defunct>
freerad   7822  7011  7011  7011  0 10:02 ?        00:00:00 [proxybbrealms] <defunct>
freerad   7825  7011  7011  7011  0 10:02 ?        00:00:00 [updatebbservice] <defunct>
freerad   7826  7011  7011  7011  0 10:02 ?        00:00:00 [proxybbrealms] <defunct>
freerad   7885  7011  7011  7011  0 10:07 ?        00:00:00 [updatebbservice] <defunct>
freerad   7886  7011  7011  7011  0 10:07 ?        00:00:00 [proxybbrealms] <defunct>
freerad   7889  7011  7011  7011  0 10:07 ?        00:00:00 [updatebbservice] <defunct>
freerad   7890  7011  7011  7011  0 10:07 ?        00:00:00 [proxybbrealms] <defunct>
freerad   7904  7011  7011  7011  0 10:08 ?        00:00:00 [updatebbservice] <defunct>
freerad   7905  7011  7011  7011  0 10:08 ?        00:00:00 [proxybbrealms] <defunct>
freerad   7962  7011  7011  7011  0 10:12 ?        00:00:00 [updatebbservice] <defunct>
freerad   7963  7011  7011  7011  0 10:12 ?        00:00:00 [proxybbrealms] <defunct>
freerad   7977  7011  7011  7011  0 10:13 ?        00:00:00 [updatebbservice] <defunct>
freerad   7978  7011  7011  7011  0 10:13 ?        00:00:00 [proxybbrealms] <defunct>
freerad   7981  7011  7011  7011  0 10:13 ?        00:00:00 [updatebbservice] <defunct>
freerad   7982  7011  7011  7011  0 10:13 ?        00:00:00 [proxybbrealms] <defunct>
freerad   8049  7011  7011  7011  0 10:18 ?        00:00:00 [updatebbservice] <defunct>
freerad   8050  7011  7011  7011  0 10:18 ?        00:00:00 [proxybbrealms] <defunct>
freerad   8055  7011  7011  7011  0 10:18 ?        00:00:00 [updatebbservice] <defunct>
freerad   8056  7011  7011  7011  0 10:18 ?        00:00:00 [proxybbrealms] <defunct>
freerad   8059  7011  7011  7011  0 10:18 ?        00:00:00 [updatebbservice] <defunct>
freerad   8060  7011  7011  7011  0 10:18 ?        00:00:00 [proxybbrealms] <defunct>
freerad   8122  7011  7011  7011  0 10:23 ?        00:00:00 
[updatebbservice] <defunct>
freerad   8123  7011  7011  7011  0 10:23 ?        00:00:00 [proxybbrealms] <defunct>
freerad   8126  7011  7011  7011  0 10:23 ?        00:00:00 [updatebbservice] <defunct>
freerad   8127  7011  7011  7011  0 10:23 ?        00:00:00 [proxybbrealms] <defunct>
freerad   8130  7011  7011  7011  0 10:23 ?        00:00:00 [updatebbservice] <defunct>
freerad   8131  7011  7011  7011  0 10:23 ?        00:00:00 [proxybbrealms] <defunct>
freerad   8191  7011  7011  7011  0 10:28 ?        00:00:00 [updatebbservice] <defunct>
freerad   8192  7011  7011  7011  0 10:28 ?        00:00:00 [proxybbrealms] <defunct>
freerad   8205  7168  7168  7168  0 10:29 ?        00:00:00 [proxybbrealms] <defunct>
freerad   8207  7011  7011  7011  2 10:29 ?        00:00:00 [updatebbservice] <defunct>
freerad   8208  7011  7011  7011  0 10:29 ?        00:00:00 [proxybbrealms] <defunct>

FreeRADIUS Version 2.1.8, for host x86_64-pc-linux-gnu, built on Jan 19 
2010 at 14:30:20
Copyright (C) 1999-2009 The FreeRADIUS server project and contributors.
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE.
You may redistribute copies of FreeRADIUS under the terms of the
GNU General Public License v2.
Starting - reading configuration files ...
including configuration file /etc/freeradius/radiusd_bb_services.conf
including configuration file /etc/freeradius/clients_bb.conf
including configuration file /etc/freeradius/sql_bb_services.conf
including configuration file /etc/freeradius/check_bb_service.conf
including configuration file /etc/freeradius/check_bb_service_prepaid.conf
including configuration file /etc/freeradius/proxy_bb_realms.conf
including configuration file /etc/freeradius/bb_quota_update.conf
including configuration file /etc/freeradius/policy_bb_services.conf
including configuration file /etc/freeradius/default_bb_services
main {
         user = "freerad"
         group = "freerad"
         allow_core_dumps = no
}
including dictionary file /etc/freeradius/dictionary
main {
         prefix = "/usr"
         localstatedir = "/var"
         logdir = "/var/log/freeradius"
         libdir = "/usr/lib/freeradius"
         radacctdir = "/var/log/freeradius/radacct"
         hostname_lookups = no
         max_request_time = 5
         cleanup_delay = 2
         max_requests = 2048
         pidfile = "/var/run/freeradius/server_bb_services.pid"
         checkrad = "/usr/sbin/checkrad"
         debug_level = 0
         proxy_requests = no
  log {
         stripped_names = no
         auth = no
         auth_badpass = yes
         auth_goodpass = no
  }
  security {
         max_attributes = 200
         reject_delay = 0
         status_server = yes
  }
}
radiusd_bb_services: #### Loading Realms and Home Servers ####
radiusd_bb_services: #### Loading Clients ####
  client 112.213.128.3 {
         ipaddr = 112.213.128.3
         require_message_authenticator = no
         secret = "XXXXX"
         shortname = "MEL-LNS01"
         nastype = "cisco_7300"
  }
  client 112.213.128.4 {
         ipaddr = 112.213.128.4
         require_message_authenticator = no
         secret = "XXXXXXX"
         shortname = "MEL-LNS02"
         nastype = "cisco_7300"
  }
radiusd_bb_services: #### Instantiating modules ####
  instantiate {
  }
radiusd_bb_services: #### Loading Virtual Servers ####
server {
  modules {
  Module: Checking authenticate {...} for more modules to load
  Module: Linked to module rlm_pap
  Module: Instantiating pap
   pap {
         encryption_scheme = "auto"
         auto_header = no
   }
  Module: Linked to module rlm_chap
  Module: Instantiating chap
  Module: Checking authorize {...} for more modules to load
  Module: Linked to module rlm_preprocess
  Module: Instantiating preprocess
   preprocess {
         huntgroups = "/etc/freeradius/huntgroups_bb"
         hints = "/etc/freeradius/hints_bb"
         with_ascend_hack = no
         ascend_channels_per_line = 23
         with_ntdomain_hack = no
         with_specialix_jetstream_hack = no
         with_cisco_vsa_hack = no
         with_alvarion_vsa_hack = no
   }
  Module: Loading virtual module accept_check_bb_service
  Module: Linked to module rlm_always
  Module: Instantiating reject
   always reject {
         rcode = "reject"
         simulcount = 0
         mpp = no
   }
  Module: Loading virtual module accept_check_bb_service
  Module: Linked to module rlm_sql
  Module: Instantiating bb_auth
   sql bb_auth {
         driver = "rlm_sql_mysql"
         server = "localhost"
         port = ""
         login = "bb_auth"
         password = "XXXXX"
         radius_db = "Radius"
         read_groups = no
         sqltrace = no
         sqltracefile = "/var/log/freeradius/sqltrace_bb.sql"
         readclients = no
         deletestalesessions = yes
         num_sql_socks = 50
         lifetime = 0
         max_queries = 0
         sql_user_name = ""
         default_user_profile = ""
         nas_query = "SELECT id,nasname,shortname,type,secret FROM nas"
         authorize_check_query = "SELECT id, username, attribute, value, op 
FROM servicecheck WHERE username = '%{User-Name}' ORDER BY id"
         authorize_reply_query = "SELECT id, username, attribute, value, op 
FROM servicereply WHERE username = '%{User-Name}' ORDER BY id"
         authorize_group_check_query = ""
         authorize_group_reply_query = ""
         accounting_onoff_query = ""
         accounting_update_query = ""
         accounting_update_query_alt = ""
         accounting_start_query = ""
         accounting_start_query_alt = ""
         accounting_stop_query = ""
         accounting_stop_query_alt = ""
         group_membership_query = ""
         connect_failure_retry_delay = 3
         simul_count_query = ""
         simul_verify_query = ""
         postauth_query = ""
         safe-characters = 
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: 
/[]()="
   }
rlm_sql (bb_auth): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and 
linked
rlm_sql (bb_auth): Attempting to connect to bb_auth@localhost:/Radius
rlm_sql (bb_auth): starting 0
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (bb_auth): Connected new DB handle, #0
rlm_sql (bb_auth): starting 1
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (bb_auth): Connected new DB handle, #1
rlm_sql (bb_auth): starting 2
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (bb_auth): Connected new DB handle, #2
rlm_sql (bb_auth): starting 3
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (bb_auth): Connected new DB handle, #3
rlm_sql (bb_auth): starting 4
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (bb_auth): Connected new DB handle, #4
rlm_sql (bb_auth): starting 5
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #5
rlm_sql_mysql: Starting connect to MySQL server for #5
rlm_sql (bb_auth): Connected new DB handle, #5
rlm_sql (bb_auth): starting 6
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #6
rlm_sql_mysql: Starting connect to MySQL server for #6
rlm_sql (bb_auth): Connected new DB handle, #6
rlm_sql (bb_auth): starting 7
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #7
rlm_sql_mysql: Starting connect to MySQL server for #7
rlm_sql (bb_auth): Connected new DB handle, #7
rlm_sql (bb_auth): starting 8
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #8
rlm_sql_mysql: Starting connect to MySQL server for #8
rlm_sql (bb_auth): Connected new DB handle, #8
rlm_sql (bb_auth): starting 9
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #9
rlm_sql_mysql: Starting connect to MySQL server for #9
rlm_sql (bb_auth): Connected new DB handle, #9
rlm_sql (bb_auth): starting 10
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #10
rlm_sql_mysql: Starting connect to MySQL server for #10
rlm_sql (bb_auth): Connected new DB handle, #10
rlm_sql (bb_auth): starting 11
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #11
rlm_sql_mysql: Starting connect to MySQL server for #11
rlm_sql (bb_auth): Connected new DB handle, #11
rlm_sql (bb_auth): starting 12
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #12
rlm_sql_mysql: Starting connect to MySQL server for #12
rlm_sql (bb_auth): Connected new DB handle, #12
rlm_sql (bb_auth): starting 13
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #13
rlm_sql_mysql: Starting connect to MySQL server for #13
rlm_sql (bb_auth): Connected new DB handle, #13
rlm_sql (bb_auth): starting 14
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #14
rlm_sql_mysql: Starting connect to MySQL server for #14
rlm_sql (bb_auth): Connected new DB handle, #14
rlm_sql (bb_auth): starting 15
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #15
rlm_sql_mysql: Starting connect to MySQL server for #15
rlm_sql (bb_auth): Connected new DB handle, #15
rlm_sql (bb_auth): starting 16
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #16
rlm_sql_mysql: Starting connect to MySQL server for #16
rlm_sql (bb_auth): Connected new DB handle, #16
rlm_sql (bb_auth): starting 17
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #17
rlm_sql_mysql: Starting connect to MySQL server for #17
rlm_sql (bb_auth): Connected new DB handle, #17
rlm_sql (bb_auth): starting 18
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #18
rlm_sql_mysql: Starting connect to MySQL server for #18
rlm_sql (bb_auth): Connected new DB handle, #18
rlm_sql (bb_auth): starting 19
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #19
rlm_sql_mysql: Starting connect to MySQL server for #19
rlm_sql (bb_auth): Connected new DB handle, #19
rlm_sql (bb_auth): starting 20
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #20
rlm_sql_mysql: Starting connect to MySQL server for #20
rlm_sql (bb_auth): Connected new DB handle, #20
rlm_sql (bb_auth): starting 21
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #21
rlm_sql_mysql: Starting connect to MySQL server for #21
rlm_sql (bb_auth): Connected new DB handle, #21
rlm_sql (bb_auth): starting 22
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #22
rlm_sql_mysql: Starting connect to MySQL server for #22
rlm_sql (bb_auth): Connected new DB handle, #22
rlm_sql (bb_auth): starting 23
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #23
rlm_sql_mysql: Starting connect to MySQL server for #23
rlm_sql (bb_auth): Connected new DB handle, #23
rlm_sql (bb_auth): starting 24
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #24
rlm_sql_mysql: Starting connect to MySQL server for #24
rlm_sql (bb_auth): Connected new DB handle, #24
rlm_sql (bb_auth): starting 25
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #25
rlm_sql_mysql: Starting connect to MySQL server for #25
rlm_sql (bb_auth): Connected new DB handle, #25
rlm_sql (bb_auth): starting 26
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #26
rlm_sql_mysql: Starting connect to MySQL server for #26
rlm_sql (bb_auth): Connected new DB handle, #26
rlm_sql (bb_auth): starting 27
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #27
rlm_sql_mysql: Starting connect to MySQL server for #27
rlm_sql (bb_auth): Connected new DB handle, #27
rlm_sql (bb_auth): starting 28
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #28
rlm_sql_mysql: Starting connect to MySQL server for #28
rlm_sql (bb_auth): Connected new DB handle, #28
rlm_sql (bb_auth): starting 29
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #29
rlm_sql_mysql: Starting connect to MySQL server for #29
rlm_sql (bb_auth): Connected new DB handle, #29
rlm_sql (bb_auth): starting 30
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #30
rlm_sql_mysql: Starting connect to MySQL server for #30
rlm_sql (bb_auth): Connected new DB handle, #30
rlm_sql (bb_auth): starting 31
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #31
rlm_sql_mysql: Starting connect to MySQL server for #31
rlm_sql (bb_auth): Connected new DB handle, #31
rlm_sql (bb_auth): starting 32
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #32
rlm_sql_mysql: Starting connect to MySQL server for #32
rlm_sql (bb_auth): Connected new DB handle, #32
rlm_sql (bb_auth): starting 33
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #33
rlm_sql_mysql: Starting connect to MySQL server for #33
rlm_sql (bb_auth): Connected new DB handle, #33
rlm_sql (bb_auth): starting 34
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #34
rlm_sql_mysql: Starting connect to MySQL server for #34
rlm_sql (bb_auth): Connected new DB handle, #34
rlm_sql (bb_auth): starting 35
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #35
rlm_sql_mysql: Starting connect to MySQL server for #35
rlm_sql (bb_auth): Connected new DB handle, #35
rlm_sql (bb_auth): starting 36
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #36
rlm_sql_mysql: Starting connect to MySQL server for #36
rlm_sql (bb_auth): Connected new DB handle, #36
rlm_sql (bb_auth): starting 37
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #37
rlm_sql_mysql: Starting connect to MySQL server for #37
rlm_sql (bb_auth): Connected new DB handle, #37
rlm_sql (bb_auth): starting 38
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #38
rlm_sql_mysql: Starting connect to MySQL server for #38
rlm_sql (bb_auth): Connected new DB handle, #38
rlm_sql (bb_auth): starting 39
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #39
rlm_sql_mysql: Starting connect to MySQL server for #39
rlm_sql (bb_auth): Connected new DB handle, #39
rlm_sql (bb_auth): starting 40
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #40
rlm_sql_mysql: Starting connect to MySQL server for #40
rlm_sql (bb_auth): Connected new DB handle, #40
rlm_sql (bb_auth): starting 41
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #41
rlm_sql_mysql: Starting connect to MySQL server for #41
rlm_sql (bb_auth): Connected new DB handle, #41
rlm_sql (bb_auth): starting 42
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #42
rlm_sql_mysql: Starting connect to MySQL server for #42
rlm_sql (bb_auth): Connected new DB handle, #42
rlm_sql (bb_auth): starting 43
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #43
rlm_sql_mysql: Starting connect to MySQL server for #43
rlm_sql (bb_auth): Connected new DB handle, #43
rlm_sql (bb_auth): starting 44
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #44
rlm_sql_mysql: Starting connect to MySQL server for #44
rlm_sql (bb_auth): Connected new DB handle, #44
rlm_sql (bb_auth): starting 45
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #45
rlm_sql_mysql: Starting connect to MySQL server for #45
rlm_sql (bb_auth): Connected new DB handle, #45
rlm_sql (bb_auth): starting 46
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #46
rlm_sql_mysql: Starting connect to MySQL server for #46
rlm_sql (bb_auth): Connected new DB handle, #46
rlm_sql (bb_auth): starting 47
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #47
rlm_sql_mysql: Starting connect to MySQL server for #47
rlm_sql (bb_auth): Connected new DB handle, #47
rlm_sql (bb_auth): starting 48
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #48
rlm_sql_mysql: Starting connect to MySQL server for #48
rlm_sql (bb_auth): Connected new DB handle, #48
rlm_sql (bb_auth): starting 49
rlm_sql (bb_auth): Attempting to connect rlm_sql_mysql #49
rlm_sql_mysql: Starting connect to MySQL server for #49
rlm_sql (bb_auth): Connected new DB handle, #49
  Module: Linked to module rlm_exec
  Module: Instantiating check_bb_service
   exec check_bb_service {
         wait = yes
         program = "/etc/freeradius/scripts/checkbbservice %{User-Name} 
%{NAS-IP-Address} %{Acct-Session-Id}"
         input_pairs = "request"
         output_pairs = "reply"
         shell_escape = yes
   }
  Module: Checking preacct {...} for more modules to load
  Module: Linked to module rlm_realm
  Module: Instantiating suffix
   realm suffix {
         format = "suffix"
         delimiter = "@"
         ignore_default = no
         ignore_null = no
   }
  Module: Checking accounting {...} for more modules to load
  Module: Instantiating bb_acct_usage
   sql bb_acct_usage {
         driver = "rlm_sql_mysql"
         server = "localhost"
         port = ""
         login = "bb_accounting"
         password = "XXXXXXXX"
         radius_db = "Radius"
         read_groups = yes
         sqltrace = no
         sqltracefile = "/var/log/freeradius/sqltrace_bb.sql"
         readclients = no
         deletestalesessions = yes
         num_sql_socks = 50
         lifetime = 0
         max_queries = 0
         sql_user_name = ""
         default_user_profile = ""
         nas_query = "SELECT id,nasname,shortname,type,secret FROM nas"
         authorize_check_query = ""
         authorize_group_check_query = ""
         authorize_group_reply_query = ""
         accounting_onoff_query = ""
         accounting_update_query = "UPDATE SRVUSAGE_%Y%m SET TIME_STAMP = 
UNIX_TIMESTAMP('%S'), ACCTSTATUSTYPE = '3', ACCTSESSIONTIME = 
'%{Acct-Session-Time}', ACCTINPUTOCTETS = '%{%{Acct-Input-Gigawords}:-0}' 
<< 32 | '%{%{Acct-Input-Octets}:-0}', ACCTOUTPUTOCTETS = 
'%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', 
ACCTTERMINATECAUSE = '%{Acct-Terminate-Cause}' WHERE ACCTSESSIONID = 
'%{Acct-Session-Id}' AND USERNAME = '%{User-Name}' AND NASIDENTIFIER = 
'%{NAS-IP-Address}' AND TIME_STAMP >= UNIX_TIMESTAMP('%Y-%m-%d 00:00:00') 
AND TIME_STAMP <= UNIX_TIMESTAMP('%Y-%m-%d 23:59:59') AND ACCTSTATUSTYPE = 
'3'"
         accounting_update_query_alt = "INSERT DELAYED INTO SRVUSAGE_%Y%m 
(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME, ACCTINPUTOCTETS, 
ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME, ACCTTERMINATECAUSE, 
FRAMEDIPADDRESS, NASIDENTIFIER, NASPORT, CALLEDSTATIONID, 
CALLINGSTATIONID, SERVICENAME, PARENT_ACCTSESSIONID) VALUES 
('%{User-Name}',UNIX_TIMESTAMP('%S'),'3','%{Acct-Delay-Time}','%{%{Acct-Input-Gigawords}:-0}' 
<< 32 | '%{%{Acct-Input-Octets}:-0}','%{%{Acct-Output-Gigawords}:-0}' << 
32 | 
'%{%{Acct-Output-Octets}:-0}','%{Acct-Session-Id}','%{Acct-Session-Time}','%{Ascend-Disconnect-Cause}','%{Framed-IP-Address}','%{NAS-IP-Address}','%{NAS-Port}','%{Called-Station-Id}','%{Calling-Station-Id}','%{Cisco-Service-Info}',SUBSTRING('%{Cisco-AVPair}',(LOCATE('=','%{Cisco-AVPair}')+ 
1)))"
         accounting_start_query = "INSERT DELAYED INTO SRVUSAGE_%Y%m 
(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME, ACCTINPUTOCTETS, 
ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME, ACCTTERMINATECAUSE, 
FRAMEDIPADDRESS, NASIDENTIFIER, NASPORT, CALLEDSTATIONID, 
CALLINGSTATIONID, SERVICENAME, PARENT_ACCTSESSIONID) VALUES 
('%{User-Name}',UNIX_TIMESTAMP('%S'),'1','%{Acct-Delay-Time}','%{Acct-Input-Octets}','%{Acct-Output-Octets}','%{Acct-Session-Id}','%{Acct-Session-Time}','%{Ascend-Disconnect-Cause}','%{Framed-IP-Address}','%{NAS-IP-Address}','%{NAS-Port}','%{Called-Station-Id}','%{Calling-Station-Id}','%{Cisco-Service-Info}',SUBSTRING('%{Cisco-AVPair}',(LOCATE('=','%{Cisco-AVPair}')+ 
1)))"
         accounting_start_query_alt = ""
         accounting_stop_query = "INSERT DELAYED INTO SRVUSAGE_%Y%m 
(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME, ACCTINPUTOCTETS, 
ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME, ACCTTERMINATECAUSE, 
FRAMEDIPADDRESS, NASIDENTIFIER, NASPORT, CALLEDSTATIONID, 
CALLINGSTATIONID, SERVICENAME, PARENT_ACCTSESSIONID) VALUES 
('%{User-Name}',UNIX_TIMESTAMP('%S'),'2','%{Acct-Delay-Time}','%{%{Acct-Input-Gigawords}:-0}' 
<< 32 | '%{%{Acct-Input-Octets}:-0}','%{%{Acct-Output-Gigawords}:-0}' << 
32 | 
'%{%{Acct-Output-Octets}:-0}','%{Acct-Session-Id}','%{Acct-Session-Time}','%{Ascend-Disconnect-Cause}','%{Framed-IP-Address}','%{NAS-IP-Address}','%{NAS-Port}','%{Called-Station-Id}','%{Calling-Station-Id}','%{Cisco-Service-Info}',SUBSTRING('%{Cisco-AVPair}',(LOCATE('=','%{Cisco-AVPair}')+ 
1)))"
         accounting_stop_query_alt = ""
         connect_failure_retry_delay = 1
         simul_count_query = ""
         simul_verify_query = ""
         postauth_query = ""
         safe-characters = 
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: 
/[]()="
   }
rlm_sql (bb_acct_usage): Driver rlm_sql_mysql (module rlm_sql_mysql) 
loaded and linked
rlm_sql (bb_acct_usage): Attempting to connect to 
bb_accounting@localhost:/Radius
rlm_sql (bb_acct_usage): starting 0
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (bb_acct_usage): Connected new DB handle, #0
rlm_sql (bb_acct_usage): starting 1
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (bb_acct_usage): Connected new DB handle, #1
rlm_sql (bb_acct_usage): starting 2
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (bb_acct_usage): Connected new DB handle, #2
rlm_sql (bb_acct_usage): starting 3
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (bb_acct_usage): Connected new DB handle, #3
rlm_sql (bb_acct_usage): starting 4
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (bb_acct_usage): Connected new DB handle, #4
rlm_sql (bb_acct_usage): starting 5
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #5
rlm_sql_mysql: Starting connect to MySQL server for #5
rlm_sql (bb_acct_usage): Connected new DB handle, #5
rlm_sql (bb_acct_usage): starting 6
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #6
rlm_sql_mysql: Starting connect to MySQL server for #6
rlm_sql (bb_acct_usage): Connected new DB handle, #6
rlm_sql (bb_acct_usage): starting 7
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #7
rlm_sql_mysql: Starting connect to MySQL server for #7
rlm_sql (bb_acct_usage): Connected new DB handle, #7
rlm_sql (bb_acct_usage): starting 8
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #8
rlm_sql_mysql: Starting connect to MySQL server for #8
rlm_sql (bb_acct_usage): Connected new DB handle, #8
rlm_sql (bb_acct_usage): starting 9
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #9
rlm_sql_mysql: Starting connect to MySQL server for #9
rlm_sql (bb_acct_usage): Connected new DB handle, #9
rlm_sql (bb_acct_usage): starting 10
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #10
rlm_sql_mysql: Starting connect to MySQL server for #10
rlm_sql (bb_acct_usage): Connected new DB handle, #10
rlm_sql (bb_acct_usage): starting 11
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #11
rlm_sql_mysql: Starting connect to MySQL server for #11
rlm_sql (bb_acct_usage): Connected new DB handle, #11
rlm_sql (bb_acct_usage): starting 12
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #12
rlm_sql_mysql: Starting connect to MySQL server for #12
rlm_sql (bb_acct_usage): Connected new DB handle, #12
rlm_sql (bb_acct_usage): starting 13
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #13
rlm_sql_mysql: Starting connect to MySQL server for #13
rlm_sql (bb_acct_usage): Connected new DB handle, #13
rlm_sql (bb_acct_usage): starting 14
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #14
rlm_sql_mysql: Starting connect to MySQL server for #14
rlm_sql (bb_acct_usage): Connected new DB handle, #14
rlm_sql (bb_acct_usage): starting 15
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #15
rlm_sql_mysql: Starting connect to MySQL server for #15
rlm_sql (bb_acct_usage): Connected new DB handle, #15
rlm_sql (bb_acct_usage): starting 16
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #16
rlm_sql_mysql: Starting connect to MySQL server for #16
rlm_sql (bb_acct_usage): Connected new DB handle, #16
rlm_sql (bb_acct_usage): starting 17
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #17
rlm_sql_mysql: Starting connect to MySQL server for #17
rlm_sql (bb_acct_usage): Connected new DB handle, #17
rlm_sql (bb_acct_usage): starting 18
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #18
rlm_sql_mysql: Starting connect to MySQL server for #18
rlm_sql (bb_acct_usage): Connected new DB handle, #18
rlm_sql (bb_acct_usage): starting 19
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #19
rlm_sql_mysql: Starting connect to MySQL server for #19
rlm_sql (bb_acct_usage): Connected new DB handle, #19
rlm_sql (bb_acct_usage): starting 20
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #20
rlm_sql_mysql: Starting connect to MySQL server for #20
rlm_sql (bb_acct_usage): Connected new DB handle, #20
rlm_sql (bb_acct_usage): starting 21
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #21
rlm_sql_mysql: Starting connect to MySQL server for #21
rlm_sql (bb_acct_usage): Connected new DB handle, #21
rlm_sql (bb_acct_usage): starting 22
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #22
rlm_sql_mysql: Starting connect to MySQL server for #22
rlm_sql (bb_acct_usage): Connected new DB handle, #22
rlm_sql (bb_acct_usage): starting 23
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #23
rlm_sql_mysql: Starting connect to MySQL server for #23
rlm_sql (bb_acct_usage): Connected new DB handle, #23
rlm_sql (bb_acct_usage): starting 24
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #24
rlm_sql_mysql: Starting connect to MySQL server for #24
rlm_sql (bb_acct_usage): Connected new DB handle, #24
rlm_sql (bb_acct_usage): starting 25
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #25
rlm_sql_mysql: Starting connect to MySQL server for #25
rlm_sql (bb_acct_usage): Connected new DB handle, #25
rlm_sql (bb_acct_usage): starting 26
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #26
rlm_sql_mysql: Starting connect to MySQL server for #26
rlm_sql (bb_acct_usage): Connected new DB handle, #26
rlm_sql (bb_acct_usage): starting 27
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #27
rlm_sql_mysql: Starting connect to MySQL server for #27
rlm_sql (bb_acct_usage): Connected new DB handle, #27
rlm_sql (bb_acct_usage): starting 28
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #28
rlm_sql_mysql: Starting connect to MySQL server for #28
rlm_sql (bb_acct_usage): Connected new DB handle, #28
rlm_sql (bb_acct_usage): starting 29
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #29
rlm_sql_mysql: Starting connect to MySQL server for #29
rlm_sql (bb_acct_usage): Connected new DB handle, #29
rlm_sql (bb_acct_usage): starting 30
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #30
rlm_sql_mysql: Starting connect to MySQL server for #30
rlm_sql (bb_acct_usage): Connected new DB handle, #30
rlm_sql (bb_acct_usage): starting 31
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #31
rlm_sql_mysql: Starting connect to MySQL server for #31
rlm_sql (bb_acct_usage): Connected new DB handle, #31
rlm_sql (bb_acct_usage): starting 32
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #32
rlm_sql_mysql: Starting connect to MySQL server for #32
rlm_sql (bb_acct_usage): Connected new DB handle, #32
rlm_sql (bb_acct_usage): starting 33
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #33
rlm_sql_mysql: Starting connect to MySQL server for #33
rlm_sql (bb_acct_usage): Connected new DB handle, #33
rlm_sql (bb_acct_usage): starting 34
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #34
rlm_sql_mysql: Starting connect to MySQL server for #34
rlm_sql (bb_acct_usage): Connected new DB handle, #34
rlm_sql (bb_acct_usage): starting 35
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #35
rlm_sql_mysql: Starting connect to MySQL server for #35
rlm_sql (bb_acct_usage): Connected new DB handle, #35
rlm_sql (bb_acct_usage): starting 36
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #36
rlm_sql_mysql: Starting connect to MySQL server for #36
rlm_sql (bb_acct_usage): Connected new DB handle, #36
rlm_sql (bb_acct_usage): starting 37
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #37
rlm_sql_mysql: Starting connect to MySQL server for #37
rlm_sql (bb_acct_usage): Connected new DB handle, #37
rlm_sql (bb_acct_usage): starting 38
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #38
rlm_sql_mysql: Starting connect to MySQL server for #38
rlm_sql (bb_acct_usage): Connected new DB handle, #38
rlm_sql (bb_acct_usage): starting 39
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #39
rlm_sql_mysql: Starting connect to MySQL server for #39
rlm_sql (bb_acct_usage): Connected new DB handle, #39
rlm_sql (bb_acct_usage): starting 40
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #40
rlm_sql_mysql: Starting connect to MySQL server for #40
rlm_sql (bb_acct_usage): Connected new DB handle, #40
rlm_sql (bb_acct_usage): starting 41
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #41
rlm_sql_mysql: Starting connect to MySQL server for #41
rlm_sql (bb_acct_usage): Connected new DB handle, #41
rlm_sql (bb_acct_usage): starting 42
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #42
rlm_sql_mysql: Starting connect to MySQL server for #42
rlm_sql (bb_acct_usage): Connected new DB handle, #42
rlm_sql (bb_acct_usage): starting 43
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #43
rlm_sql_mysql: Starting connect to MySQL server for #43
rlm_sql (bb_acct_usage): Connected new DB handle, #43
rlm_sql (bb_acct_usage): starting 44
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #44
rlm_sql_mysql: Starting connect to MySQL server for #44
rlm_sql (bb_acct_usage): Connected new DB handle, #44
rlm_sql (bb_acct_usage): starting 45
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #45
rlm_sql_mysql: Starting connect to MySQL server for #45
rlm_sql (bb_acct_usage): Connected new DB handle, #45
rlm_sql (bb_acct_usage): starting 46
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #46
rlm_sql_mysql: Starting connect to MySQL server for #46
rlm_sql (bb_acct_usage): Connected new DB handle, #46
rlm_sql (bb_acct_usage): starting 47
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #47
rlm_sql_mysql: Starting connect to MySQL server for #47
rlm_sql (bb_acct_usage): Connected new DB handle, #47
rlm_sql (bb_acct_usage): starting 48
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #48
rlm_sql_mysql: Starting connect to MySQL server for #48
rlm_sql (bb_acct_usage): Connected new DB handle, #48
rlm_sql (bb_acct_usage): starting 49
rlm_sql (bb_acct_usage): Attempting to connect rlm_sql_mysql #49
rlm_sql_mysql: Starting connect to MySQL server for #49
rlm_sql (bb_acct_usage): Connected new DB handle, #49
  Module: Instantiating bb_acct_online
   sql bb_acct_online {
         driver = "rlm_sql_mysql"
         server = "localhost"
         port = ""
         login = "bb_accounting"
         password = "xxxxxx"
         radius_db = "Radius"
         read_groups = yes
         sqltrace = no
         sqltracefile = "/var/log/freeradius/sqltrace_bb.sql"
         readclients = no
         deletestalesessions = yes
         num_sql_socks = 50
         lifetime = 0
         max_queries = 0
         sql_user_name = ""
         default_user_profile = ""
         nas_query = "SELECT id,nasname,shortname,type,secret FROM nas"
         authorize_check_query = ""
         authorize_group_check_query = ""
         authorize_group_reply_query = ""
         accounting_onoff_query = ""
         accounting_update_query = ""
         accounting_update_query_alt = ""
         accounting_start_query = "INSERT INTO SRVRADONLINE (USERNAME, 
NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, 
NASPORTTYPE, SERVICETYPE, CALLINGSTATIONID, CALLEDSTATIONID, SERVICENAME) 
VALUES ('%{User-Name}', '%{NAS-IP-Address}', '%{NAS-Port}', 
'%{Acct-Session-Id}', UNIX_TIMESTAMP('%S'), '%{Framed-IP-Address}', 
'0%{NAS-Port-Type}', '%{Service-Type}', '%{Calling-Station-Id}', 
'%{Called-Station-Id}','%{Cisco-Service-Info}')"
         accounting_start_query_alt = ""
         accounting_stop_query = "DELETE FROM SRVRADONLINE WHERE USERNAME = 
'%{User-Name}' AND NASIDENTIFIER = '%{NAS-IP-Address}' AND ACCTSESSIONID = 
'%{Acct-Session-Id}' AND SERVICENAME = '%{Cisco-Service-Info}'"
         accounting_stop_query_alt = ""
         connect_failure_retry_delay = 3
         simul_count_query = ""
         simul_verify_query = ""
         postauth_query = ""
         safe-characters = 
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: 
/[]()="
   }
rlm_sql (bb_acct_online): Driver rlm_sql_mysql (module rlm_sql_mysql) 
loaded and linked
rlm_sql (bb_acct_online): Attempting to connect to 
bb_accounting@localhost:/Radius
rlm_sql (bb_acct_online): starting 0
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (bb_acct_online): Connected new DB handle, #0
rlm_sql (bb_acct_online): starting 1
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (bb_acct_online): Connected new DB handle, #1
rlm_sql (bb_acct_online): starting 2
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (bb_acct_online): Connected new DB handle, #2
rlm_sql (bb_acct_online): starting 3
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (bb_acct_online): Connected new DB handle, #3
rlm_sql (bb_acct_online): starting 4
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (bb_acct_online): Connected new DB handle, #4
rlm_sql (bb_acct_online): starting 5
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #5
rlm_sql_mysql: Starting connect to MySQL server for #5
rlm_sql (bb_acct_online): Connected new DB handle, #5
rlm_sql (bb_acct_online): starting 6
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #6
rlm_sql_mysql: Starting connect to MySQL server for #6
rlm_sql (bb_acct_online): Connected new DB handle, #6
rlm_sql (bb_acct_online): starting 7
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #7
rlm_sql_mysql: Starting connect to MySQL server for #7
rlm_sql (bb_acct_online): Connected new DB handle, #7
rlm_sql (bb_acct_online): starting 8
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #8
rlm_sql_mysql: Starting connect to MySQL server for #8
rlm_sql (bb_acct_online): Connected new DB handle, #8
rlm_sql (bb_acct_online): starting 9
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #9
rlm_sql_mysql: Starting connect to MySQL server for #9
rlm_sql (bb_acct_online): Connected new DB handle, #9
rlm_sql (bb_acct_online): starting 10
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #10
rlm_sql_mysql: Starting connect to MySQL server for #10
rlm_sql (bb_acct_online): Connected new DB handle, #10
rlm_sql (bb_acct_online): starting 11
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #11
rlm_sql_mysql: Starting connect to MySQL server for #11
rlm_sql (bb_acct_online): Connected new DB handle, #11
rlm_sql (bb_acct_online): starting 12
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #12
rlm_sql_mysql: Starting connect to MySQL server for #12
rlm_sql (bb_acct_online): Connected new DB handle, #12
rlm_sql (bb_acct_online): starting 13
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #13
rlm_sql_mysql: Starting connect to MySQL server for #13
rlm_sql (bb_acct_online): Connected new DB handle, #13
rlm_sql (bb_acct_online): starting 14
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #14
rlm_sql_mysql: Starting connect to MySQL server for #14
rlm_sql (bb_acct_online): Connected new DB handle, #14
rlm_sql (bb_acct_online): starting 15
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #15
rlm_sql_mysql: Starting connect to MySQL server for #15
rlm_sql (bb_acct_online): Connected new DB handle, #15
rlm_sql (bb_acct_online): starting 16
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #16
rlm_sql_mysql: Starting connect to MySQL server for #16
rlm_sql (bb_acct_online): Connected new DB handle, #16
rlm_sql (bb_acct_online): starting 17
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #17
rlm_sql_mysql: Starting connect to MySQL server for #17
rlm_sql (bb_acct_online): Connected new DB handle, #17
rlm_sql (bb_acct_online): starting 18
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #18
rlm_sql_mysql: Starting connect to MySQL server for #18
rlm_sql (bb_acct_online): Connected new DB handle, #18
rlm_sql (bb_acct_online): starting 19
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #19
rlm_sql_mysql: Starting connect to MySQL server for #19
rlm_sql (bb_acct_online): Connected new DB handle, #19
rlm_sql (bb_acct_online): starting 20
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #20
rlm_sql_mysql: Starting connect to MySQL server for #20
rlm_sql (bb_acct_online): Connected new DB handle, #20
rlm_sql (bb_acct_online): starting 21
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #21
rlm_sql_mysql: Starting connect to MySQL server for #21
rlm_sql (bb_acct_online): Connected new DB handle, #21
rlm_sql (bb_acct_online): starting 22
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #22
rlm_sql_mysql: Starting connect to MySQL server for #22
rlm_sql (bb_acct_online): Connected new DB handle, #22
rlm_sql (bb_acct_online): starting 23
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #23
rlm_sql_mysql: Starting connect to MySQL server for #23
rlm_sql (bb_acct_online): Connected new DB handle, #23
rlm_sql (bb_acct_online): starting 24
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #24
rlm_sql_mysql: Starting connect to MySQL server for #24
rlm_sql (bb_acct_online): Connected new DB handle, #24
rlm_sql (bb_acct_online): starting 25
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #25
rlm_sql_mysql: Starting connect to MySQL server for #25
rlm_sql (bb_acct_online): Connected new DB handle, #25
rlm_sql (bb_acct_online): starting 26
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #26
rlm_sql_mysql: Starting connect to MySQL server for #26
rlm_sql (bb_acct_online): Connected new DB handle, #26
rlm_sql (bb_acct_online): starting 27
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #27
rlm_sql_mysql: Starting connect to MySQL server for #27
rlm_sql (bb_acct_online): Connected new DB handle, #27
rlm_sql (bb_acct_online): starting 28
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #28
rlm_sql_mysql: Starting connect to MySQL server for #28
rlm_sql (bb_acct_online): Connected new DB handle, #28
rlm_sql (bb_acct_online): starting 29
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #29
rlm_sql_mysql: Starting connect to MySQL server for #29
rlm_sql (bb_acct_online): Connected new DB handle, #29
rlm_sql (bb_acct_online): starting 30
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #30
rlm_sql_mysql: Starting connect to MySQL server for #30
rlm_sql (bb_acct_online): Connected new DB handle, #30
rlm_sql (bb_acct_online): starting 31
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #31
rlm_sql_mysql: Starting connect to MySQL server for #31
rlm_sql (bb_acct_online): Connected new DB handle, #31
rlm_sql (bb_acct_online): starting 32
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #32
rlm_sql_mysql: Starting connect to MySQL server for #32
rlm_sql (bb_acct_online): Connected new DB handle, #32
rlm_sql (bb_acct_online): starting 33
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #33
rlm_sql_mysql: Starting connect to MySQL server for #33
rlm_sql (bb_acct_online): Connected new DB handle, #33
rlm_sql (bb_acct_online): starting 34
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #34
rlm_sql_mysql: Starting connect to MySQL server for #34
rlm_sql (bb_acct_online): Connected new DB handle, #34
rlm_sql (bb_acct_online): starting 35
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #35
rlm_sql_mysql: Starting connect to MySQL server for #35
rlm_sql (bb_acct_online): Connected new DB handle, #35
rlm_sql (bb_acct_online): starting 36
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #36
rlm_sql_mysql: Starting connect to MySQL server for #36
rlm_sql (bb_acct_online): Connected new DB handle, #36
rlm_sql (bb_acct_online): starting 37
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #37
rlm_sql_mysql: Starting connect to MySQL server for #37
rlm_sql (bb_acct_online): Connected new DB handle, #37
rlm_sql (bb_acct_online): starting 38
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #38
rlm_sql_mysql: Starting connect to MySQL server for #38
rlm_sql (bb_acct_online): Connected new DB handle, #38
rlm_sql (bb_acct_online): starting 39
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #39
rlm_sql_mysql: Starting connect to MySQL server for #39
rlm_sql (bb_acct_online): Connected new DB handle, #39
rlm_sql (bb_acct_online): starting 40
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #40
rlm_sql_mysql: Starting connect to MySQL server for #40
rlm_sql (bb_acct_online): Connected new DB handle, #40
rlm_sql (bb_acct_online): starting 41
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #41
rlm_sql_mysql: Starting connect to MySQL server for #41
rlm_sql (bb_acct_online): Connected new DB handle, #41
rlm_sql (bb_acct_online): starting 42
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #42
rlm_sql_mysql: Starting connect to MySQL server for #42
rlm_sql (bb_acct_online): Connected new DB handle, #42
rlm_sql (bb_acct_online): starting 43
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #43
rlm_sql_mysql: Starting connect to MySQL server for #43
rlm_sql (bb_acct_online): Connected new DB handle, #43
rlm_sql (bb_acct_online): starting 44
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #44
rlm_sql_mysql: Starting connect to MySQL server for #44
rlm_sql (bb_acct_online): Connected new DB handle, #44
rlm_sql (bb_acct_online): starting 45
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #45
rlm_sql_mysql: Starting connect to MySQL server for #45
rlm_sql (bb_acct_online): Connected new DB handle, #45
rlm_sql (bb_acct_online): starting 46
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #46
rlm_sql_mysql: Starting connect to MySQL server for #46
rlm_sql (bb_acct_online): Connected new DB handle, #46
rlm_sql (bb_acct_online): starting 47
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #47
rlm_sql_mysql: Starting connect to MySQL server for #47
rlm_sql (bb_acct_online): Connected new DB handle, #47
rlm_sql (bb_acct_online): starting 48
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #48
rlm_sql_mysql: Starting connect to MySQL server for #48
rlm_sql (bb_acct_online): Connected new DB handle, #48
rlm_sql (bb_acct_online): starting 49
rlm_sql (bb_acct_online): Attempting to connect rlm_sql_mysql #49
rlm_sql_mysql: Starting connect to MySQL server for #49
rlm_sql (bb_acct_online): Connected new DB handle, #49
  Module: Instantiating bb_quota_update
   exec bb_quota_update {
         wait = no
         program = "/etc/freeradius/scripts/updatebbservicequota 
%{User-Name} %{Cisco-Service-Info} %{Acct-Output-Octets} 
%{Acct-Input-Octets} %{Framed-IP-Address} %{NAS-IP-Address} 
%{Acct-Status-Type} %{Acct-Output-Gigawords} %{Acct-Input-Gigawords}"
         input_pairs = "request"
         shell_escape = yes
   }
  Module: Instantiating proxy_bb_realms
   exec proxy_bb_realms {
         wait = no
         program = "/etc/freeradius/scripts/proxybbrealms %u %Z"
         input_pairs = "request"
         shell_escape = yes
   }
  Module: Checking post-auth {...} for more modules to load
  Module: Instantiating auth_reject
   sql auth_reject {
         driver = "rlm_sql_mysql"
         server = "localhost"
         port = ""
         login = "bb_auth"
         password = "xxxxx"
         radius_db = "Radius"
         read_groups = yes
         sqltrace = no
         sqltracefile = "/var/log/freeradius/sqltrace_bb.sql"
         readclients = no
         deletestalesessions = yes
         num_sql_socks = 10
         lifetime = 0
         max_queries = 0
         sql_user_name = ""
         default_user_profile = ""
         nas_query = "SELECT id,nasname,shortname,type,secret FROM nas"
         authorize_check_query = ""
         authorize_group_check_query = ""
         authorize_group_reply_query = ""
         accounting_onoff_query = ""
         accounting_update_query = ""
         accounting_update_query_alt = ""
         accounting_start_query = ""
         accounting_start_query_alt = ""
         accounting_stop_query = ""
         accounting_stop_query_alt = ""
         connect_failure_retry_delay = 3
         simul_count_query = ""
         simul_verify_query = ""
         postauth_query = "INSERT DELAYED INTO SRVRADAUTHLOG (REASON, 
TIME_STAMP, TYPE, ACCTSESSIONID, SERVICENAME, CALLEDSTATIONID, 
CALLINGSTATIONID, PASS_WORD) values 
('%{%{reply:Reply-Message}:-%{reply:Packet-Type}}',UNIX_TIMESTAMP('%S'),'0','%{Acct-Session-Id}','%{User-Name}','%{Called-Station-Id}','%{Calling-Station-Id}','%{%{User-Password}:-%{Chap-Password}}')"
         safe-characters = 
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: 
/[]()="
   }
rlm_sql (auth_reject): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded 
and linked
rlm_sql (auth_reject): Attempting to connect to bb_auth@localhost:/Radius
rlm_sql (auth_reject): starting 0
rlm_sql (auth_reject): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (auth_reject): Connected new DB handle, #0
rlm_sql (auth_reject): starting 1
rlm_sql (auth_reject): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (auth_reject): Connected new DB handle, #1
rlm_sql (auth_reject): starting 2
rlm_sql (auth_reject): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (auth_reject): Connected new DB handle, #2
rlm_sql (auth_reject): starting 3
rlm_sql (auth_reject): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (auth_reject): Connected new DB handle, #3
rlm_sql (auth_reject): starting 4
rlm_sql (auth_reject): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (auth_reject): Connected new DB handle, #4
rlm_sql (auth_reject): starting 5
rlm_sql (auth_reject): Attempting to connect rlm_sql_mysql #5
rlm_sql_mysql: Starting connect to MySQL server for #5
rlm_sql (auth_reject): Connected new DB handle, #5
rlm_sql (auth_reject): starting 6
rlm_sql (auth_reject): Attempting to connect rlm_sql_mysql #6
rlm_sql_mysql: Starting connect to MySQL server for #6
rlm_sql (auth_reject): Connected new DB handle, #6
rlm_sql (auth_reject): starting 7
rlm_sql (auth_reject): Attempting to connect rlm_sql_mysql #7
rlm_sql_mysql: Starting connect to MySQL server for #7
rlm_sql (auth_reject): Connected new DB handle, #7
rlm_sql (auth_reject): starting 8
rlm_sql (auth_reject): Attempting to connect rlm_sql_mysql #8
rlm_sql_mysql: Starting connect to MySQL server for #8
rlm_sql (auth_reject): Connected new DB handle, #8
rlm_sql (auth_reject): starting 9
rlm_sql (auth_reject): Attempting to connect rlm_sql_mysql #9
rlm_sql_mysql: Starting connect to MySQL server for #9
rlm_sql (auth_reject): Connected new DB handle, #9
  Module: Linked to module rlm_attr_filter
  Module: Instantiating attr_filter.access_reject
   attr_filter attr_filter.access_reject {
         attrsfile = "/etc/freeradius/attrs.access_reject"
         key = "%{User-Name}"
   }
  } # modules
} # server
radiusd_bb_services: #### Opening IP addresses and Ports ####
listen {
         type = "auth"
         ipaddr = 124.254.72.146
         port = 1815
}
listen {
         type = "acct"
         ipaddr = 124.254.72.146
         port = 1816
}
Listening on authentication address 124.254.72.146 port 1815
Listening on accounting address 124.254.72.146 port 1816
Ready to process requests.

Regards,

Sajeewa Warnakulasuriya

Systems Development Manager

ispONE is a wholesale ISP built to help internet access resellers and
independent ISPs to compete in the Australian marketplace through
ONE Brand, ONE Provider, ONE Solution.

Level 14
520 Collins Street
Melbourne 3000 VIC

Phone:  1300 663 400

Fax:      1300 665 400

E-Mail: sajeewaw@ispone.com.au

Web:    http://www.ispone.com.au/