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 [EMAIL PROTECTED]: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:[EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html