Не  получается запустить данную  связку  для  учёта  и  контроля трафика.
1. Собираю  модуль  для  поддержки  mppe mppc.
2.  Устонавливаю  ppp  и  pptpd  c  флагами
net-dialup/ppp-2.4.2-r15 [2.4.3-r10] +activefilter -atm -dhcp +ipv6 +mppe-mppc +pam +radius
net-dialup/pptpd-1.2.3-r1  +tcpd

3. настраиваю pptpd
Файл /etc/pptpd.conf :

option /etc/ppp/options.pptpd
localip 10.10.10.1-255
remoteip 192.168.80.1-254

(Компы в локалке имеют  адреса 192.168.80.0/24)

Файл /etc/ppp/options.pptpd :

name pptpd

refuse-pap
refuse-chap
refuse-mschap
require-mschap-v2

debug
dump
lock
nobsdcomp

# turn off logging to stderr, since this may be redirected to pptpd
#nologfd

auth
#refuse-pap
#refuse-chap
#refuse-mschap
#refuse-eap
#require-mschap-v2
mppe required,stateless,no40,no56
lcp-echo-failure 3
lcp-echo-interval 5
nodeflate
defaultroute
ipcp-accept-local
ipcp-accept-remote
#plugin radius.so
#plugin radattr.so
noipx
asyncmap 0
nomppc

Создаю тестового пользователя
Файл /etc/ppp/chap-secrets
test *  qwerty  10.10.10.2

Делаю  коннект  из  под  винды:  всё  работает.

Перехожу   к  настройке  freeradius+freenibs

Делаю  всё  как  написано  вот  здесь https://www.opennet.ru/base/net/freenibs_mpd_bill.txt.html

только     устанавливаю в   /opt/freeradius/

Запускаю  freeradius и  получаю  вот  такой  вот  лог

freeradius # ./sbin/radiusd -X
Starting - reading configuration files ...
reread_config:  reading radiusd.conf
Config:   including file: /opt/freeradius/etc/raddb/proxy.conf
Config:   including file: /opt/freeradius/etc/raddb/clients.conf
Config:   including file: /opt/freeradius/etc/raddb/snmp.conf
Config:   including file: /opt/freeradius/etc/raddb/eap.conf
Config:   including file: /opt/freeradius/etc/raddb/nibs.conf
main: prefix = "/opt/freeradius"
main: localstatedir = "/opt/freeradius/var"
main: logdir = "/opt/freeradius/var/log/radius"
main: libdir = "/opt/freeradius/lib"
main: radacctdir = "/opt/freeradius/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 = "/opt/freeradius/var/log/radius/radius.log"
main: log_auth = no
main: log_auth_badpass = no
main: log_auth_goodpass = no
main: pidfile = "/opt/freeradius/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 = "/opt/freeradius/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
Using deprecated clients file.  Support for this will go away soon.
read_config_files:  reading realms
radiusd:  entering modules setup
Module: Library search path is /opt/freeradius/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 MS-CHAP
mschap: use_mppe = yes
mschap: require_encryption = no
mschap: require_strong = yes
mschap: with_ntdomain_hack = no
mschap: passwd = "(null)"
mschap: authtype = "MS-CHAP"
mschap: ntlm_auth = "(null)"
Module: Instantiated mschap (mschap)
Module: Loaded NIBS
nibs: driver = "rlm_nibs_mysql"
nibs: server = "localhost"
nibs: port = "3306"
nibs: login = "root"
nibs: password = "martin29"
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 = "/opt/freeradius/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 = "SELECT 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, login_time, huntgroup_name, simultaneous_use, port_limit, session_timeout, idle_timeout, allowed_prefixes, no_pass, no_acct, allow_callback, other_params FROM users WHERE user = '%{SQL-User-Name}'"
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 = "/opt/freeradius/sbin/userkill %{User-Name} %{NAS-IP-Address} %{Client-IP-Address} %{NAS-Port} %{Framed-IP-Address}"
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 root@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 3 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 8 prices
Module: Instantiated nibs (nibs)
Module: Loaded preprocess
preprocess: huntgroups = "/opt/freeradius/etc/raddb/huntgroups"
preprocess: hints = "/opt/freeradius/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 realm
realm: format = "suffix"
realm: delimiter = "@"
realm: ignore_default = no
realm: ignore_null = no
Module: Instantiated realm (suffix)
Module: Loaded Acct-Unique-Session-Id
acct_unique: key = "User-Name, Acct-Session-Id, NAS-IP-Address, NAS-Port"
Module: Instantiated acct_unique (acct_unique)
Module: Loaded files
files: usersfile = "/opt/freeradius/etc/raddb/users"
files: acctusersfile = "/opt/freeradius/etc/raddb/acct_users"
files: preproxy_usersfile = "/opt/freeradius/etc/raddb/preproxy_users"
files: compat = "no"
Module: Instantiated files (files)
Module: Loaded detail
detail: detailfile = "/opt/freeradius/var/log/radius/radacct/%{Client-IP-Address}/detail"
detail: detailperm = 384
detail: dirperm = 493
detail: locking = no
Module: Instantiated detail (detail)
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)
Listening on authentication *:1812
Listening on accounting *:1813
Listening on proxy *:1814
Ready to process requests.

Создаю   через   web-interface  пользователя   включаю плагин radius.so
Захожу  в  базу - да  пользователь  есть  и пароль не  шифруется.

Исправляю  файл /etc/radiusclient/radiusclient.conf

# General settings

# specify which authentication comes first respectively which
# authentication is used. possible values are: "radius" and "local".
# if you specify "radius,local" then the RADIUS server is asked
# first then the local one. if only one keyword is specified only
# this server is asked.
auth_order      radius,local

# maximum login tries a user has
login_tries     4

# timeout for all login tries
# if this time is exceeded the user is kicked out
login_timeout   60

# name of the nologin file which when it exists disables logins.
# it may be extended by the ttyname which will result in
# a terminal specific lock (e.g. /etc/nologin.ttyS2 will disable
# logins on /dev/ttyS2)
nologin /etc/nologin

# name of the issue file. it's only display when no username is passed
# on the radlogin command line
issue   /etc/radiusclient/issue

# RADIUS settings

# RADIUS server to use for authentication requests. this config
# item can appear more then one time. if multiple servers are
# defined they are tried in a round robin fashion if one
# server is not answering.
# optionally you can specify a the port number on which is remote
# RADIUS listens separated by a colon from the hostname. if
# no port is specified /etc/services is consulted of the radius
# service. if this fails also a compiled in default is used.
#authserver     localhost

# RADIUS server to use for accouting requests. All that I
# said for authserver applies, too.
#
#acctserver     localhost
#добавил  здесь   свой  freeradius  сервак

authserver localhost:1812  
acctserver localhost:1813

# file holding shared secrets used for the communication
# between the RADIUS client and server
servers         /etc/radiusclient/servers

# dictionary of allowed attributes and values
# just like in the normal RADIUS distributions
dictionary      /etc/radiusclient/dictionary

# program to call for a RADIUS authenticated login
login_radius    /usr/sbin/login.radius

# file which holds sequence number for communication with the
# RADIUS server
seqfile         /var/run/radius.seq

# file which specifies mapping between ttyname and NAS-Port attribute
mapfile         /etc/radiusclient/port-id-map

# default authentication realm to append to all usernames if no
# realm was explicitly specified by the user
# the radiusd directly form Livingston doesnt use any realms, so leave
# it blank then
default_realm

# time to wait for a reply from the RADIUS server
radius_timeout  10

# resend request this many times before trying the next server
radius_retries  3

# LOCAL settings

# program to execute for local login
# it must support the -f flag for preauthenticated login
login_local     /bin/login

Правлю /etc/radiusclient/servers

#Server Name or Client/Server pair              Key
#----------------                               ---------------
#portmaster.elemental.net                       hardlyasecret
#portmaster2.elemental.net                      donttellanyone
localhost:1812  testing123
localhost:1813  testing123

Подключаю   плагин  radius.so
  в options.pptpd

и всё,  пользователь  не  может   подключится
Долго     проверяет  пользователя  и   потом  пишет  неправильный  пароль.

в  лог  ни  pptpd  ни  freeradius ничего не  пишут. Такое  ощущение,  что  модуль  не туда  коннектится  за   проверкой  пользователя.  
Объясните  где  грабли.

• gentoo, freenibs + freeradius + pptpd, cybersun, 20:38 , 21-Дек-05, (1)