Перейти до

Помогите freeradius 3 + Mikrotik

005836

Автор: 005836,
в Stargazer Ubilling

 Share Подписчики 2

Рекомендованные сообщения

Nerofar1

Nerofar1 0

Опубліковано:
Опубліковано: (відредаговано)

Перепробовал 7 прошивок везде одна и таже петрушка:

Release 6.43.12

Release 6.42.12

Release 6.42.11

Release 6.42.10

Release 6.42.9

Release 6.40.9

Release 6.40.8

Скрытый текст

(46) Received Accounting-Request Id 7 from 172.24.254.52:36088 to 172.24.254.50:1813 length 44
(46)   Acct-Status-Type = Accounting-On
(46)   NAS-Identifier = "NAS1"
(46)   Acct-Delay-Time = 0
(46)   NAS-IP-Address = 172.24.254.52
(46) # Executing section preacct from file /usr/local/etc/raddb/sites-enabled/default
(46)   preacct {
(46)     [preprocess] = ok
(46)     policy acct_unique {
(46)       update request {
(46)         &Tmp-String-9 := "ai:"
(46)       } # update request = noop
(46)       if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) &&      ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) {
(46)       EXPAND %{hex:&Class}
(46)          -->
(46)       EXPAND ^%{hex:&Tmp-String-9}
(46)          --> ^61693a
(46)       if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) &&      ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i))  -> FALSE
(46)       else {
(46)         update request {
(46)           EXPAND %{md5:%{User-Name},%{Acct-Session-ID},%{%{NAS-IPv6-Address}:-%{NAS-IP-Address}},%{NAS-Identifier},%{NAS-Port-ID},%{NAS-Port}}
(46)              --> 8e0199da000697f976cb21e0770bd579
(46)           &Acct-Unique-Session-Id := 8e0199da000697f976cb21e0770bd579
(46)         } # update request = noop
(46)       } # else = noop
(46)     } # policy acct_unique = noop
(46)   } # preacct = ok
(46) # Executing section accounting from file /usr/local/etc/raddb/sites-enabled/default
(46)   accounting {
(46) sql: EXPAND %{tolower:type.%{Acct-Status-Type}.query}
(46) sql:    --> type.accounting-on.query
(46) sql: Using query template 'query'
rlm_sql (sql): Closing connection (64): Hit idle_timeout, was idle for 110 seconds
rlm_sql_mysql: Socket destructor called, closing socket
rlm_sql (sql): Closing connection (66): Hit idle_timeout, was idle for 110 seconds
rlm_sql_mysql: Socket destructor called, closing socket
rlm_sql (sql): Closing connection (63): Hit idle_timeout, was idle for 97 seconds
rlm_sql_mysql: Socket destructor called, closing socket
rlm_sql (sql): Closing connection (67): Hit idle_timeout, was idle for 97 seconds
rlm_sql (sql): You probably need to lower "min"
rlm_sql_mysql: Socket destructor called, closing socket
rlm_sql (sql): Closing connection (65): Hit idle_timeout, was idle for 65 seconds
rlm_sql (sql): You probably need to lower "min"
rlm_sql_mysql: Socket destructor called, closing socket
rlm_sql (sql): Closing connection (68): Hit idle_timeout, was idle for 65 seconds
rlm_sql (sql): You probably need to lower "min"
rlm_sql_mysql: Socket destructor called, closing socket
rlm_sql (sql): 0 of 0 connections in use.  You  may need to increase "spare"
rlm_sql (sql): Opening additional connection (69), 1 of 32 pending slots used
rlm_sql_mysql: Starting connect to MySQL server
rlm_sql_mysql: Connected to database 'stg' on Localhost via UNIX socket, server version 5.6.42, protocol version 10
rlm_sql (sql): Reserved connection (69)
(46) sql: EXPAND %{User-Name}
(46) sql:    -->
(46) sql: SQL-User-Name set to ''
(46) sql: EXPAND UPDATE mlg_acct SET acctstoptime = FROM_UNIXTIME(%{integer:Event-Timestamp}), acctsessiontime  = '%{integer:Event-Timestamp}' - UNIX_TIMESTAMP(acctstarttime), acctterminatecause = '%{%{Acct-Terminate-Cause}:-NAS-Reboot}' WHERE acctstoptime IS NULL AND nasipaddress   = '%{NAS-IP-Address}' AND acctstarttime <= FROM_UNIXTIME(%{integer:Event-Timestamp})
(46) sql:    --> UPDATE mlg_acct SET acctstoptime = FROM_UNIXTIME(1550759188), acctsessiontime  = '1550759188' - UNIX_TIMESTAMP(acctstarttime), acctterminatecause = 'NAS-Reboot' WHERE acctstoptime IS NULL AND nasipaddress   = '172.24.254.52' AND acctstarttime <= FROM_UNIXTIME(1550759188)
(46) sql: Executing query: UPDATE mlg_acct SET acctstoptime = FROM_UNIXTIME(1550759188), acctsessiontime        = '1550759188' - UNIX_TIMESTAMP(acctstarttime), acctterminatecause = 'NAS-Reboot' WHERE acctstoptime IS NULL AND nasipaddress   = '172.24.254.52' AND acctstarttime <= FROM_UNIXTIME(1550759188)
rlm_sql_mysql: Rows matched: 0  Changed: 0  Warnings: 0
(46) sql: SQL query returned: success
(46) sql: 0 record(s) updated
(46) sql: No additional queries configured
rlm_sql (sql): Released connection (69)
Need 2 more connections to reach min connections (3)
rlm_sql (sql): Opening additional connection (70), 1 of 31 pending slots used
rlm_sql_mysql: Starting connect to MySQL server
rlm_sql_mysql: Connected to database 'stg' on Localhost via UNIX socket, server version 5.6.42, protocol version 10
(46)     


 = noop

			(46)   } # accounting = noop

			(46) Not sending reply to client.

			(46) Finished request

			(46) Cleaning up request packet ID 7 with timestamp +2881

			Ready to process requests

 

Відредаговано Nerofar1
Ссылка на сообщение
Поделиться на других сайтах
Nerofar1

Nerofar1 0

Опубліковано:
Опубліковано:

Всё проблема решена) спасибо в чате помогли, большое спасибо Roman Shevchenko, как всегда виновата прокладка между стулом и компом))

Безымянный.jpg

Ссылка на сообщение
Поделиться на других сайтах
  • 2 years later...
Vitaliy1984

Vitaliy1984 5

Опубліковано:
Опубліковано:

добрый день нужна помощь не могу разобраться с radiusd  подскажите в чем причина

 

root@ubilling:~ # radiusd -X
FreeRADIUS Version 3.0.17
Copyright (C) 1999-2017 The FreeRADIUS server project and contributors
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE
You may redistribute copies of FreeRADIUS under the terms of the
GNU General Public License
For more information about these matters, see the file named COPYRIGHT
Starting - reading configuration files ...
including dictionary file /usr/local/share/freeradius/dictionary
including dictionary file /usr/local/share/freeradius/dictionary.dhcp
including dictionary file /usr/local/share/freeradius/dictionary.vqp
including dictionary file /usr/local/etc/raddb/dictionary
including configuration file /usr/local/etc/raddb/radiusd.conf
including files in directory /usr/local/etc/raddb/mods-enabled/
including configuration file /usr/local/etc/raddb/mods-enabled/attr_filter
including configuration file /usr/local/etc/raddb/mods-enabled/cache_eap
including configuration file /usr/local/etc/raddb/mods-enabled/chap
including configuration file /usr/local/etc/raddb/mods-enabled/date
including configuration file /usr/local/etc/raddb/mods-enabled/detail
including configuration file /usr/local/etc/raddb/mods-enabled/detail.log
including configuration file /usr/local/etc/raddb/mods-enabled/digest
including configuration file /usr/local/etc/raddb/mods-enabled/dynamic_clients
including configuration file /usr/local/etc/raddb/mods-enabled/eap
including configuration file /usr/local/etc/raddb/mods-enabled/echo
including configuration file /usr/local/etc/raddb/mods-enabled/exec
including configuration file /usr/local/etc/raddb/mods-enabled/expiration
including configuration file /usr/local/etc/raddb/mods-enabled/expr
including configuration file /usr/local/etc/raddb/mods-enabled/files
including configuration file /usr/local/etc/raddb/mods-enabled/linelog
including configuration file /usr/local/etc/raddb/mods-enabled/logintime
including configuration file /usr/local/etc/raddb/mods-enabled/mschap
including configuration file /usr/local/etc/raddb/mods-enabled/ntlm_auth
including configuration file /usr/local/etc/raddb/mods-enabled/pap
including configuration file /usr/local/etc/raddb/mods-enabled/passwd
including configuration file /usr/local/etc/raddb/mods-enabled/preprocess
including configuration file /usr/local/etc/raddb/mods-enabled/radutmp
including configuration file /usr/local/etc/raddb/mods-enabled/realm
including configuration file /usr/local/etc/raddb/mods-enabled/replicate
including configuration file /usr/local/etc/raddb/mods-enabled/soh
including configuration file /usr/local/etc/raddb/mods-enabled/sradutmp
including configuration file /usr/local/etc/raddb/mods-enabled/unix
including configuration file /usr/local/etc/raddb/mods-enabled/unpack
including configuration file /usr/local/etc/raddb/mods-enabled/utf8
including configuration file /usr/local/etc/raddb/mods-enabled/always
including configuration file /usr/local/etc/raddb/sql.conf
including configuration file /usr/local/etc/raddb/mods-config/sql/main/mysql/queries.conf
including files in directory /usr/local/etc/raddb/policy.d/
including configuration file /usr/local/etc/raddb/policy.d/accounting
including configuration file /usr/local/etc/raddb/policy.d/canonicalization
including configuration file /usr/local/etc/raddb/policy.d/control
including configuration file /usr/local/etc/raddb/policy.d/cui
including configuration file /usr/local/etc/raddb/policy.d/debug
including configuration file /usr/local/etc/raddb/policy.d/dhcp
including configuration file /usr/local/etc/raddb/policy.d/eap
including configuration file /usr/local/etc/raddb/policy.d/filter
including configuration file /usr/local/etc/raddb/policy.d/moonshot-targeted-ids
including configuration file /usr/local/etc/raddb/policy.d/operator-name
including configuration file /usr/local/etc/raddb/policy.d/abfab-tr
including files in directory /usr/local/etc/raddb/sites-enabled/
including configuration file /usr/local/etc/raddb/sites-enabled/inner-tunnel
including configuration file /usr/local/etc/raddb/sites-enabled/default
including configuration file /usr/local/etc/raddb/sites-enabled/innet-tunnel
/usr/local/etc/raddb/sites-enabled/innet-tunnel[52]: Expecting section start brace '{' after "and other"
Errors reading or parsing /usr/local/etc/raddb/radiusd.conf
root@ubilling:~ #
 

Ссылка на сообщение
Поделиться на других сайтах
nightfly

nightfly 1 221

Опубліковано:
Опубліковано:
38 минут назад, Vitaliy1984 сказав:

добрый день нужна помощь не могу разобраться с radiusd  подскажите в чем причина

судя по этому

 

38 минут назад, Vitaliy1984 сказав:

Expecting section start brace '{' after "and other"
Errors reading or parsing /usr/local/etc/raddb/radiusd.conf

причина в вас.

Ссылка на сообщение
Поделиться на других сайтах

Создайте аккаунт или войдите в него для комментирования

Вы должны быть пользователем, чтобы оставить комментарий

Создать аккаунт

Зарегистрируйтесь для получения аккаунта. Это просто!

Зарегистрировать аккаунт

Вхід

Уже зарегистрированы? Войдите здесь.

Войти сейчас
 Share
Подписчики 2
Перейти до переліку тем

  • Зараз на сторінці   0 користувачів

    Немає користувачів, що переглядають цю сторінку.

  • Схожий контент

    • ppv
      Є використані IP але абонентів з такими IP немає.
      Від ppv
      Потрібно було витерти одну мережу, всі абоненти з неї були перенесені в іншу. Але світить що 6 IP зайняті, хоча вона повністю вільна.
       
      ID    Мережа/CID           RВсього IP        Використано IP ▾           Вільно IPСервіс
      6      172.16.70.0/23        506                    6                                       500
       
      Підкажіть як правильно це підчистити щоб видалити мережу.
    • Игорь_Кривой Рог
      Продам Mikrotik RB850Gx2, RB260GS
      Від Игорь_Кривой Рог
      Продам за ненадобностью остатки после модернизации, лежать без дела.
       
      Mikrotik RB850Gx2 - 4шт.
       
      Mikrotik RB260GS - 1шт.
       
      Все в рабочем состоянии, сброшены на заводские настройки, битые порты отсутствуют.
       








    • Dimon123
      Продам RB260GSP
      Від Dimon123
      новий, без коробки, відправлю 1600 грн


    • Dimon123
      Продам RB260GS
      Від Dimon123
      Новий, в коробці, відправлю. 1200 грн
       


    • cyi
      Ремонт Mikrotik 2011
      Від cyi
      Вітаю. Така проблема, в Mikrotik 2011UAS-2HnD перестав працювати порт 7 та 10. Може хто підкаже в чому проблема або ж має Repair Instruction.
      Дякую.
×
×
  • Створити нове...