Jump to content
Local
005836

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

Recommended Posts

Перепробовал 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
		
	


 

Edited by Nerofar1

Share this post


Link to post
Share on other sites

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

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By Olh@
      Продам микротик RB2011UiAS-RM
      В работе практически не был, состояние 9/10 пострадал при переездах. 
      Цена 1500
    • By ip-si.com
      Продам вот такое железо:
      1. Mikrotik Cloud Core Router CCR1016-12S-1S+ 
      2. sfp to rj45
      Все новое, в коробке и с гарантией.
      Все это добро за 600дол.
      Можно наложкой, можно на карту, можно на ФОП, а можно и самовывозом!
      Пишите в личку или звоните.
      0965397975 Андрей
       
    • By ddd_kr
      Продам маршрутизатор:
      Продам Juniper J2320 (БУ) - 3500 грн
      Mikrotik CCR1016-12G (БУ) - 11000грн
       
    • By MiaV
      КУПЛЮ

      MikroTik LHG 5 (RBLHG-5nD)
    • By dimonian
      Не получается настроить SMSPILOT, все сделал по инструкции: включил собаку-посылаку, включил SMSZILLA, установил длину номера и код (раскоментировал строки и установил значение), вставил API-ключ, создал список номеров и у клиентов указал номера телефонов. При попытке отправить сообщение клиентам, номера не извлекаются (фильтр настроен, как "отправить всем"). При попытке отправить на номера из списка возникает ошибка Warning: strpos(): Empty needle in /usr/local/www/apache24/data/billing/api/libs/api.workaround.php on line 2813.
      Пробовал на чистом Биллинге, сообщения ставятся в очередь, но не отсылаются. На сервис смс не приходит запрос от Биллинга. Номера извлекаются из списка номеров но Notice: Undefined index: mobile in /usr/local/www/apache24/data/billing/api/libs/api.smszilla.php on line 3093
×