no wait exec scripts end up as defunct zombie process
Sajeewa Warnakulasuriya
sajeewaw at ispone.com.au
Fri Feb 5 00:45:46 CET 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at ispone.com.au
Web: http://www.ispone.com.au/
More information about the Freeradius-Users
mailing list