freeradius-users.
modules {
.........
perl {
module = /usr/local/etc/raddb/kes.pl
}
.........
authorize {
perl
............
Starting - reading configuration files ...
reread_config: reading radiusd.conf
Config: including file: /usr/local/etc/raddb/proxy.conf
Config: including file: /usr/local/etc/raddb/clients.conf
Config: including file: /usr/local/etc/raddb/snmp.conf
Config: including file: /usr/local/etc/raddb/eap.conf
Config: including file: /usr/local/etc/raddb/nibs.conf
main: prefix = "/usr/local"
main: localstatedir = "/var"
main: logdir = "/var/log/radius"
main: libdir = "/usr/local/lib"
main: radacctdir = "/var/log/radius/radacct"
main: hostname_lookups = no
main: max_request_time = 30
main: cleanup_delay = 5
main: max_requests = 1024
main: delete_blocked_requests = 0
main: port = 0
main: allow_core_dumps = no
main: log_stripped_names = no
main: log_file = "/var/log/radius/radius.log"
main: log_auth = no
main: log_auth_badpass = no
main: log_auth_goodpass = no
main: pidfile = "/var/run/radiusd/radiusd.pid"
main: user = "(null)"
main: group = "(null)"
main: usercollide = no
main: lower_user = "no"
main: lower_pass = "no"
main: nospace_user = "no"
main: nospace_pass = "no"
main: checkrad = "/usr/local/sbin/checkrad"
main: proxy_requests = yes
proxy: retry_delay = 5
proxy: retry_count = 3
proxy: synchronous = no
proxy: default_fallback = yes
proxy: dead_time = 120
proxy: post_proxy_authorize = yes
proxy: wake_all_if_all_dead = no
security: max_attributes = 200
security: reject_delay = 1
security: status_server = no
main: debug_level = 0
read_config_files: reading dictionary
read_config_files: reading naslist
Using deprecated naslist file. Support for this will go away soon.
read_config_files: reading clients
read_config_files: reading realms
radiusd: entering modules setup
Module: Library search path is /usr/local/lib
Module: Loaded exec
exec: wait = yes
exec: program = "(null)"
exec: input_pairs = "request"
exec: output_pairs = "(null)"
exec: packet_type = "(null)"
rlm_exec: Wait=yes but no output defined. Did you mean output=none?
Module: Instantiated exec (exec)
Module: Loaded expr
Module: Instantiated expr (expr)
Module: Loaded PAP
pap: encryption_scheme = "crypt"
Module: Instantiated pap (pap)
Module: Loaded CHAP
Module: Instantiated chap (chap)
Module: Loaded MS-CHAP
mschap: use_mppe = yes
mschap: require_encryption = no
mschap: require_strong = no
mschap: with_ntdomain_hack = no
mschap: passwd = "(null)"
mschap: ntlm_auth = "(null)"
Module: Instantiated mschap (mschap)
Module: Loaded NIBS
nibs: driver = "rlm_nibs_mysql"
nibs: server = "localhost"
nibs: port = "3306"
nibs: login = "freenibs"
nibs: password = "*****"
nibs: nibs_db = "freenibs"
nibs: auth_table = "users"
nibs: packets_table = "packets"
nibs: prices_table = "prices"
nibs: acct_table = "actions"
nibs: blacklist_table = "blacklist"
nibs: holidays_table = "holidays"
nibs: sqltrace = no
nibs: sqltracefile = "/var/log/radius/nibs_mysqltrace.sql"
nibs: num_socks = 64
nibs: connect_failure_retry = 100
nibs: connect_failure_retry_delay = 3
nibs: sql_user_name = "%{User-Name}"
nibs: group_select_query = "SELECT gid, prefix, tos, do_with_tos, direction, fixed, fixed_cost, activation_time,
total_time_limit, month_time_limit, week_time_limit, day_time_limit, total_traffic_limit, month_traffic_limit,
week_traffic_limit, day_traffic_limit, total_money_limit, month_money_limit, week_money_limit, day_money_limit,
session_timeout, idle_timeout, simultaneous_use, port_limit, login_time, other_params, huntgroup_name, allow_callback,
allowed_prefixes, framed_ip, framed_mask, no_acct, no_pass FROM packets"
nibs: holyday_select_query = "SELECT holiday_date FROM holidays"
nibs: prices_select_query = "SELECT h0, input0, output0, h1, input1, output1, h2, input2, output2, h3, input3, output3,
h4, input4, output4, h5, input5, output5, h6, input6, output6, h7, input7, output7, h8, input8, output8, h9, input9,
output9, h10, input10, output10, h11, input11, output11, h12, input12, output12, h13, input13, output13, h14, input14,
output14, h15, input15, output15, h16, input16, output16, h17, input17, output17, h18, input18, output18, h19, input19,
output19, h20, input20, output20, h21, input21, output21, h22, input22, output22, h23, input23, output23, week_day, gid
FROM prices"
nibs: blacklist_select_query = "SELECT uid, gid, phone, permit FROM blacklist order by id"
nibs: authenticate_query = "SELECT user, password, gid, crypt_method FROM users WHERE user = '%{SQL-User-Name}'"
nibs: authorize_query = "SELECT user, password, crypt_method, uid, gid, deposit, credit, unix_timestamp(add_date),
blocked, activated, unix_timestamp(expired), total_time, total_traffic, total_money, unix_timestamp(last_connection),
framed_ip, framed_mask, callback_number FROM users WHERE user = '%{SQL-User-Name}'"
nibs: authorize_query_prof = ""
nibs: month_time_query = "SELECT sum(time_on) FROM actions WHERE user = '%{SQL-User-Name}' and start_time >=
CONCAT(YEAR(NOW()),'-',MONTH(NOW()),'-01 00:00:00') AND start_time <= ADDDATE(CONCAT(YEAR(NOW()),'-',MONTH(NOW()),'-01
00:00:00'), INTERVAL 1 MONTH)"
nibs: week_time_query = "SELECT sum(time_on) FROM actions WHERE user = '%{SQL-User-Name}' and YEAR(start_time) =
YEAR(NOW()) AND WEEK(start_time,1) = WEEK(NOW(), 1)"
nibs: day_time_query = "SELECT sum(time_on) FROM actions WHERE user = '%{SQL-User-Name}' and TO_DAYS(start_time) =
TO_DAYS(NOW())"
nibs: month_traffic_query = "SELECT sum(in_bytes), sum(out_bytes) FROM actions WHERE user = '%{SQL-User-Name}' and
start_time >= CONCAT(YEAR(NOW()),'-',MONTH(NOW()),'-01 00:00:00') AND start_time <=
ADDDATE(CONCAT(YEAR(NOW()),'-',MONTH(NOW()),'-01 00:00:00'), INTERVAL 1 MONTH)"
nibs: week_traffic_query = "SELECT sum(in_bytes), sum(out_bytes) FROM actions WHERE user = '%{SQL-User-Name}' and
YEAR(start_time) = YEAR(NOW()) AND WEEK(start_time,1) = WEEK(NOW(), 1)"
nibs: day_traffic_query = "SELECT sum(in_bytes), sum(out_bytes) FROM actions WHERE user = '%{SQL-User-Name}' and
TO_DAYS(start_time) = TO_DAYS(NOW())"
nibs: month_money_query = "SELECT sum(billing_minus) FROM actions WHERE user = '%{SQL-User-Name}' and start_time >=
CONCAT(YEAR(NOW()),'-',MONTH(NOW()),'-01 00:00:00') AND start_time <= ADDDATE(CONCAT(YEAR(NOW()),'-',MONTH(NOW()),'-01
00:00:00'), INTERVAL 1 MONTH)"
nibs: week_money_query = "SELECT sum(billing_minus) FROM actions WHERE user = '%{SQL-User-Name}' and YEAR(start_time) =
YEAR(NOW()) AND WEEK(start_time,1) = WEEK(NOW(), 1)"
nibs: day_money_query = "SELECT sum(billing_minus) FROM actions WHERE user = '%{SQL-User-Name}' and TO_DAYS(start_time)
= TO_DAYS(NOW())"
nibs: activation_update_query = "UPDATE users SET add_date = %%s, expired = %%s, activated = %%d, last_connection =
from_unixtime(%l) WHERE user = '%{SQL-User-Name}'"
nibs: fixed_select_query = "SELECT to_days('%S'), to_days(last_connection) FROM users WHERE user = '%{SQL-User-Name}'"
nibs: statistic_select_query = "SELECT time_on, in_bytes, out_bytes, unix_timestamp(start_time), billing_minus,
hour_in_bytes, hour_out_bytes, hour_traffic_money, last_change FROM actions WHERE id = '%{Acct-Session-Id}' AND unique_id
= '%{Acct-Unique-Session-Id}' AND server = '%{NAS-IP-Address}' AND port = %{NAS-Port} AND user = '%{SQL-User-Name}' AND
terminate_cause='Online'"
nibs: accounting_start_query = "INSERT INTO actions (gid, id, unique_id, user, server, port, client_ip, protocol, ip,
call_to, call_from, terminate_cause, connect_info, start_time, last_change, before_billing) VALUES (%%d,
'%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{NAS-IP-Address}', %{NAS-Port},
'%{Client-IP-Address}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '%{Called-Station-Id}', '%{Calling-Station-Id}',
'Online', '%{Connect-Info}', '%S', %l, %%8.6f)"
nibs: accounting_start_query_alt = "INSERT INTO actions (gid, id, unique_id, user, server, port, client_ip, protocol,
ip, call_to, call_from, terminate_cause, connect_info, start_time, last_change, before_billing) VALUES (%%d,
'%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{NAS-IP-Address}', %{NAS-Port},
'%{Client-IP-Address}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '%{Called-Station-Id}', '%{Calling-Station-Id}',
'Online', '%{Connect-Info}', from_unixtime(%l - %%d), %l, %%8.6f)"
nibs: accounting_reopen = "UPDATE actions SET terminate_cause = 'Online', stop_time = 0, id = '%{Acct-Session-Id}',
unique_id = '%{Acct-Unique-Session-Id}' WHERE id LIKE '%%%{Acct-Session-Id}' AND unique_id LIKE
'%%%{Acct-Unique-Session-Id}' AND server = '%{NAS-IP-Address}' AND port = %{NAS-Port} AND user = '%{SQL-User-Name}' AND
terminate_cause != 'Online' AND (-10 <= (unix_timestamp(start_time) - (%l - %{Acct-Session-Time}))) AND
((unix_timestamp(start_time) - (%l - %{Acct-Session-Time})) <= 10)"
nibs: accounting_alive_auth_query = "UPDATE users SET deposit = deposit - %%8.6f, total_traffic = total_traffic + %%ld,
total_time = total_time + %%ld, total_money = total_money + %%8.6f, last_connection = from_unixtime(%l) WHERE user =
'%{SQL-User-Name}'"
nibs: accounting_stop_auth_query = "UPDATE users SET deposit = deposit - %%8.6f, total_traffic = total_traffic + %%ld,
total_time = total_time + %%ld, total_money = total_money + %%8.6f, last_connection = from_unixtime(%l) WHERE user =
'%{SQL-User-Name}'"
nibs: accounting_update_query = "UPDATE actions SET time_on = if(%{Acct-Session-Time},%{Acct-Session-Time},time_on),
in_bytes = if(%{Acct-Input-Octets},%{Acct-Input-Octets},in_bytes), out_bytes =
if(%{Acct-Output-Octets},%{Acct-Output-Octets},out_bytes), last_change = %l, billing_minus = billing_minus + %%8.6f, ip =
'%{Framed-IP-Address}', hour_in_bytes = %%lu, hour_out_bytes = %%lu, hour_traffic_money = %%8.6f WHERE
id='%{Acct-Session-Id}' AND unique_id = '%{Acct-Unique-Session-Id}' AND server = '%{NAS-IP-Address}' AND port =
%{NAS-Port} AND user = '%{SQL-User-Name}' AND terminate_cause = 'Online'"
nibs: accounting_stop_query = "UPDATE actions SET time_on = if(%{Acct-Session-Time},%{Acct-Session-Time},time_on),
stop_time = '%S', in_bytes = if(%{Acct-Input-Octets},%{Acct-Input-Octets},in_bytes), out_bytes =
if(%{Acct-Output-Octets},%{Acct-Output-Octets},out_bytes), billing_minus = billing_minus + %%8.6f,
terminate_cause='%{Acct-Terminate-Cause}', connect_info = '%{Connect-Info}', id =
concat(unix_timestamp(start_time),'-%{Acct-Session-Id}'), unique_id =
concat(unix_timestamp(start_time),'-%{Acct-Unique-Session-Id}'), ip = '%{Framed-IP-Address}' WHERE id='%{Acct-Session-Id}'
AND unique_id = '%{Acct-Unique-Session-Id}' AND server = '%{NAS-IP-Address}' AND port = %{NAS-Port} AND user =
'%{SQL-User-Name}' AND terminate_cause = 'Online'"
nibs: accounting_onoff_query = ""
nibs: simul_count_query = "SELECT id, user, server, port, ip, call_from FROM actions WHERE user = '%{SQL-User-Name}' AND
terminate_cause = 'Online'"
nibs: simul_verify_query = "SELECT id, user, server, port, ip, protocol, last_change FROM actions WHERE terminate_cause
= 'Online' ORDER BY user"
nibs: deletestalesessions_by_checkrad = yes
nibs: deletestalesessions_by_alive = yes
nibs: alive_max_interval = 30
nibs: set_session_timeout = no
nibs: use_black_list = yes
nibs: kill_by_alive = yes
nibs: kill_program = "/sbin/ifconfig ng%{NAS-Port} down"
nibs: safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
rlm_nibs (rlm_nibs_instantiate): Driver rlm_nibs_mysql (module rlm_nibs_mysql) loaded and linked
rlm_nibs (rlm_nibs_instantiate): Attempting to connect to freenibs@localhost:3306/freenibs
rlm_nibs (sql_init_socketpool): starting 0
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #0
rlm_nibs_mysql: Starting connect to MySQL server for #0
rlm_nibs (connect_single_socket): Connected new DB handle, #0
rlm_nibs (sql_init_socketpool): starting 1
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #1
rlm_nibs_mysql: Starting connect to MySQL server for #1
rlm_nibs (connect_single_socket): Connected new DB handle, #1
rlm_nibs (sql_init_socketpool): starting 2
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #2
rlm_nibs_mysql: Starting connect to MySQL server for #2
rlm_nibs (connect_single_socket): Connected new DB handle, #2
rlm_nibs (sql_init_socketpool): starting 3
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #3
rlm_nibs_mysql: Starting connect to MySQL server for #3
rlm_nibs (connect_single_socket): Connected new DB handle, #3
rlm_nibs (sql_init_socketpool): starting 4
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #4
rlm_nibs_mysql: Starting connect to MySQL server for #4
rlm_nibs (connect_single_socket): Connected new DB handle, #4
rlm_nibs (sql_init_socketpool): starting 5
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #5
rlm_nibs_mysql: Starting connect to MySQL server for #5
rlm_nibs (connect_single_socket): Connected new DB handle, #5
rlm_nibs (sql_init_socketpool): starting 6
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #6
rlm_nibs_mysql: Starting connect to MySQL server for #6
rlm_nibs (connect_single_socket): Connected new DB handle, #6
rlm_nibs (sql_init_socketpool): starting 7
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #7
rlm_nibs_mysql: Starting connect to MySQL server for #7
rlm_nibs (connect_single_socket): Connected new DB handle, #7
rlm_nibs (sql_init_socketpool): starting 8
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #8
rlm_nibs_mysql: Starting connect to MySQL server for #8
rlm_nibs (connect_single_socket): Connected new DB handle, #8
rlm_nibs (sql_init_socketpool): starting 9
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #9
rlm_nibs_mysql: Starting connect to MySQL server for #9
rlm_nibs (connect_single_socket): Connected new DB handle, #9
rlm_nibs (sql_init_socketpool): starting 10
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #10
rlm_nibs_mysql: Starting connect to MySQL server for #10
rlm_nibs (connect_single_socket): Connected new DB handle, #10
rlm_nibs (sql_init_socketpool): starting 11
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #11
rlm_nibs_mysql: Starting connect to MySQL server for #11
rlm_nibs (connect_single_socket): Connected new DB handle, #11
rlm_nibs (sql_init_socketpool): starting 12
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #12
rlm_nibs_mysql: Starting connect to MySQL server for #12
rlm_nibs (connect_single_socket): Connected new DB handle, #12
rlm_nibs (sql_init_socketpool): starting 13
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #13
rlm_nibs_mysql: Starting connect to MySQL server for #13
rlm_nibs (connect_single_socket): Connected new DB handle, #13
rlm_nibs (sql_init_socketpool): starting 14
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #14
rlm_nibs_mysql: Starting connect to MySQL server for #14
rlm_nibs (connect_single_socket): Connected new DB handle, #14
rlm_nibs (sql_init_socketpool): starting 15
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #15
rlm_nibs_mysql: Starting connect to MySQL server for #15
rlm_nibs (connect_single_socket): Connected new DB handle, #15
rlm_nibs (sql_init_socketpool): starting 16
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #16
rlm_nibs_mysql: Starting connect to MySQL server for #16
rlm_nibs (connect_single_socket): Connected new DB handle, #16
rlm_nibs (sql_init_socketpool): starting 17
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #17
rlm_nibs_mysql: Starting connect to MySQL server for #17
rlm_nibs (connect_single_socket): Connected new DB handle, #17
rlm_nibs (sql_init_socketpool): starting 18
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #18
rlm_nibs_mysql: Starting connect to MySQL server for #18
rlm_nibs (connect_single_socket): Connected new DB handle, #18
rlm_nibs (sql_init_socketpool): starting 19
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #19
rlm_nibs_mysql: Starting connect to MySQL server for #19
rlm_nibs (connect_single_socket): Connected new DB handle, #19
rlm_nibs (sql_init_socketpool): starting 20
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #20
rlm_nibs_mysql: Starting connect to MySQL server for #20
rlm_nibs (connect_single_socket): Connected new DB handle, #20
rlm_nibs (sql_init_socketpool): starting 21
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #21
rlm_nibs_mysql: Starting connect to MySQL server for #21
rlm_nibs (connect_single_socket): Connected new DB handle, #21
rlm_nibs (sql_init_socketpool): starting 22
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #22
rlm_nibs_mysql: Starting connect to MySQL server for #22
rlm_nibs (connect_single_socket): Connected new DB handle, #22
rlm_nibs (sql_init_socketpool): starting 23
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #23
rlm_nibs_mysql: Starting connect to MySQL server for #23
rlm_nibs (connect_single_socket): Connected new DB handle, #23
rlm_nibs (sql_init_socketpool): starting 24
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #24
rlm_nibs_mysql: Starting connect to MySQL server for #24
rlm_nibs (connect_single_socket): Connected new DB handle, #24
rlm_nibs (sql_init_socketpool): starting 25
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #25
rlm_nibs_mysql: Starting connect to MySQL server for #25
rlm_nibs (connect_single_socket): Connected new DB handle, #25
rlm_nibs (sql_init_socketpool): starting 26
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #26
rlm_nibs_mysql: Starting connect to MySQL server for #26
rlm_nibs (connect_single_socket): Connected new DB handle, #26
rlm_nibs (sql_init_socketpool): starting 27
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #27
rlm_nibs_mysql: Starting connect to MySQL server for #27
rlm_nibs (connect_single_socket): Connected new DB handle, #27
rlm_nibs (sql_init_socketpool): starting 28
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #28
rlm_nibs_mysql: Starting connect to MySQL server for #28
rlm_nibs (connect_single_socket): Connected new DB handle, #28
rlm_nibs (sql_init_socketpool): starting 29
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #29
rlm_nibs_mysql: Starting connect to MySQL server for #29
rlm_nibs (connect_single_socket): Connected new DB handle, #29
rlm_nibs (sql_init_socketpool): starting 30
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #30
rlm_nibs_mysql: Starting connect to MySQL server for #30
rlm_nibs (connect_single_socket): Connected new DB handle, #30
rlm_nibs (sql_init_socketpool): starting 31
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #31
rlm_nibs_mysql: Starting connect to MySQL server for #31
rlm_nibs (connect_single_socket): Connected new DB handle, #31
rlm_nibs (sql_init_socketpool): starting 32
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #32
rlm_nibs_mysql: Starting connect to MySQL server for #32
rlm_nibs (connect_single_socket): Connected new DB handle, #32
rlm_nibs (sql_init_socketpool): starting 33
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #33
rlm_nibs_mysql: Starting connect to MySQL server for #33
rlm_nibs (connect_single_socket): Connected new DB handle, #33
rlm_nibs (sql_init_socketpool): starting 34
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #34
rlm_nibs_mysql: Starting connect to MySQL server for #34
rlm_nibs (connect_single_socket): Connected new DB handle, #34
rlm_nibs (sql_init_socketpool): starting 35
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #35
rlm_nibs_mysql: Starting connect to MySQL server for #35
rlm_nibs (connect_single_socket): Connected new DB handle, #35
rlm_nibs (sql_init_socketpool): starting 36
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #36
rlm_nibs_mysql: Starting connect to MySQL server for #36
rlm_nibs (connect_single_socket): Connected new DB handle, #36
rlm_nibs (sql_init_socketpool): starting 37
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #37
rlm_nibs_mysql: Starting connect to MySQL server for #37
rlm_nibs (connect_single_socket): Connected new DB handle, #37
rlm_nibs (sql_init_socketpool): starting 38
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #38
rlm_nibs_mysql: Starting connect to MySQL server for #38
rlm_nibs (connect_single_socket): Connected new DB handle, #38
rlm_nibs (sql_init_socketpool): starting 39
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #39
rlm_nibs_mysql: Starting connect to MySQL server for #39
rlm_nibs (connect_single_socket): Connected new DB handle, #39
rlm_nibs (sql_init_socketpool): starting 40
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #40
rlm_nibs_mysql: Starting connect to MySQL server for #40
rlm_nibs (connect_single_socket): Connected new DB handle, #40
rlm_nibs (sql_init_socketpool): starting 41
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #41
rlm_nibs_mysql: Starting connect to MySQL server for #41
rlm_nibs (connect_single_socket): Connected new DB handle, #41
rlm_nibs (sql_init_socketpool): starting 42
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #42
rlm_nibs_mysql: Starting connect to MySQL server for #42
rlm_nibs (connect_single_socket): Connected new DB handle, #42
rlm_nibs (sql_init_socketpool): starting 43
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #43
rlm_nibs_mysql: Starting connect to MySQL server for #43
rlm_nibs (connect_single_socket): Connected new DB handle, #43
rlm_nibs (sql_init_socketpool): starting 44
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #44
rlm_nibs_mysql: Starting connect to MySQL server for #44
rlm_nibs (connect_single_socket): Connected new DB handle, #44
rlm_nibs (sql_init_socketpool): starting 45
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #45
rlm_nibs_mysql: Starting connect to MySQL server for #45
rlm_nibs (connect_single_socket): Connected new DB handle, #45
rlm_nibs (sql_init_socketpool): starting 46
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #46
rlm_nibs_mysql: Starting connect to MySQL server for #46
rlm_nibs (connect_single_socket): Connected new DB handle, #46
rlm_nibs (sql_init_socketpool): starting 47
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #47
rlm_nibs_mysql: Starting connect to MySQL server for #47
rlm_nibs (connect_single_socket): Connected new DB handle, #47
rlm_nibs (sql_init_socketpool): starting 48
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #48
rlm_nibs_mysql: Starting connect to MySQL server for #48
rlm_nibs (connect_single_socket): Connected new DB handle, #48
rlm_nibs (sql_init_socketpool): starting 49
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #49
rlm_nibs_mysql: Starting connect to MySQL server for #49
rlm_nibs (connect_single_socket): Connected new DB handle, #49
rlm_nibs (sql_init_socketpool): starting 50
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #50
rlm_nibs_mysql: Starting connect to MySQL server for #50
rlm_nibs (connect_single_socket): Connected new DB handle, #50
rlm_nibs (sql_init_socketpool): starting 51
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #51
rlm_nibs_mysql: Starting connect to MySQL server for #51
rlm_nibs (connect_single_socket): Connected new DB handle, #51
rlm_nibs (sql_init_socketpool): starting 52
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #52
rlm_nibs_mysql: Starting connect to MySQL server for #52
rlm_nibs (connect_single_socket): Connected new DB handle, #52
rlm_nibs (sql_init_socketpool): starting 53
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #53
rlm_nibs_mysql: Starting connect to MySQL server for #53
rlm_nibs (connect_single_socket): Connected new DB handle, #53
rlm_nibs (sql_init_socketpool): starting 54
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #54
rlm_nibs_mysql: Starting connect to MySQL server for #54
rlm_nibs (connect_single_socket): Connected new DB handle, #54
rlm_nibs (sql_init_socketpool): starting 55
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #55
rlm_nibs_mysql: Starting connect to MySQL server for #55
rlm_nibs (connect_single_socket): Connected new DB handle, #55
rlm_nibs (sql_init_socketpool): starting 56
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #56
rlm_nibs_mysql: Starting connect to MySQL server for #56
rlm_nibs (connect_single_socket): Connected new DB handle, #56
rlm_nibs (sql_init_socketpool): starting 57
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #57
rlm_nibs_mysql: Starting connect to MySQL server for #57
rlm_nibs (connect_single_socket): Connected new DB handle, #57
rlm_nibs (sql_init_socketpool): starting 58
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #58
rlm_nibs_mysql: Starting connect to MySQL server for #58
rlm_nibs (connect_single_socket): Connected new DB handle, #58
rlm_nibs (sql_init_socketpool): starting 59
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #59
rlm_nibs_mysql: Starting connect to MySQL server for #59
rlm_nibs (connect_single_socket): Connected new DB handle, #59
rlm_nibs (sql_init_socketpool): starting 60
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #60
rlm_nibs_mysql: Starting connect to MySQL server for #60
rlm_nibs (connect_single_socket): Connected new DB handle, #60
rlm_nibs (sql_init_socketpool): starting 61
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #61
rlm_nibs_mysql: Starting connect to MySQL server for #61
rlm_nibs (connect_single_socket): Connected new DB handle, #61
rlm_nibs (sql_init_socketpool): starting 62
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #62
rlm_nibs_mysql: Starting connect to MySQL server for #62
rlm_nibs (connect_single_socket): Connected new DB handle, #62
rlm_nibs (sql_init_socketpool): starting 63
rlm_nibs (connect_single_socket): Attempting to connect rlm_nibs_mysql #63
rlm_nibs_mysql: Starting connect to MySQL server for #63
rlm_nibs (connect_single_socket): Connected new DB handle, #63
rlm_nibs (nibs_init): Initializing main structures `freenibs'
rlm_nibs (nibs): Reserving sql socket id: 63
rlm_nibs (sql_release_socket): Released sql socket id: 63
rlm_nibs (nibs_init): Initializing group table `packets' done. Found 8 groups
rlm_nibs (nibs): Reserving sql socket id: 62
rlm_nibs (sql_init_holidays): No holidays configured
rlm_nibs (sql_release_socket): Released sql socket id: 62
rlm_nibs (nibs): Reserving sql socket id: 61
rlm_nibs (sql_release_socket): Released sql socket id: 61
rlm_nibs (nibs_init): Initializing prices table `prices' done. Found 64 prices
Module: Instantiated nibs (nibs)
Module: Loaded preprocess
preprocess: huntgroups = "/usr/local/etc/raddb/huntgroups"
preprocess: hints = "/usr/local/etc/raddb/hints"
preprocess: with_ascend_hack = no
preprocess: ascend_channels_per_line = 23
preprocess: with_ntdomain_hack = no
preprocess: with_specialix_jetstream_hack = no
preprocess: with_cisco_vsa_hack = no
Module: Instantiated preprocess (preprocess)
Module: Loaded Acct-Unique-Session-Id
acct_unique: key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port"
Module: Instantiated acct_unique (acct_unique)
Module: Loaded detail
detail: detailfile = "/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d"
detail: detailperm = 384
detail: dirperm = 493
detail: locking = no
Module: Instantiated detail (detail)
Module: Loaded System
unix: cache = no
unix: passwd = "(null)"
unix: shadow = "(null)"
unix: group = "(null)"
unix: radwtmp = "/var/log/radius/radwtmp"
unix: usegroup = no
unix: cache_reload = 600
Module: Instantiated unix (unix)
Module: Loaded radutmp
radutmp: filename = "/var/log/radius/radutmp"
radutmp: username = "%{User-Name}"
radutmp: case_sensitive = yes
radutmp: check_with_nas = yes
radutmp: perm = 384
radutmp: callerid = yes
Module: Instantiated radutmp (radutmp)
Module: Loaded eap
eap: default_eap_type = "md5"
eap: timer_expire = 60
eap: ignore_unknown_eap_types = no
eap: cisco_accounting_username_bug = no
rlm_eap: Loaded and initialized type md5
rlm_eap: Loaded and initialized type leap
gtc: challenge = "Password: "
gtc: auth_type = "PAP"
rlm_eap: Loaded and initialized type gtc
mschapv2: with_ntdomain_hack = no
rlm_eap: Loaded and initialized type mschapv2
Module: Instantiated eap (eap)
Module: Loaded perl
perl: module = "/usr/local/etc/raddb/kes.pl"
perl: func_authorize = "authorize"
perl: func_authenticate = "authenticate"
perl: func_accounting = "accounting"
perl: func_preacct = "preacct"
perl: func_checksimul = "checksimul"
perl: func_detach = "detach"
perl: func_xlat = "xlat"
perl: func_pre_proxy = "pre_proxy"
perl: func_post_proxy = "post_proxy"
perl: func_post_auth = "post_auth"
perl: perl_flags = "(null)"
perl: func_start_accounting = "(null)"
perl: func_stop_accounting = "(null)"
--
KES mailto:kes-kes@yandex.ru
