Где моя ошибка с FreeRadius, MySQL и Dialup-Admin для Mikrotik? Если я создаю пользователя = admin, который принадлежит группе = Test, у пользователей будут статические IP-адреса из сети 10.10.10.0/24.
Группа = Test
Протокол = ppp
IP-адрес =
Netmask = 255.0.0.0
Framed-MTU = 1500
Compression Used = Van-Jacobson-TCP-IP
Service Type = Framed-IP-Address
Session Timeout =
Idle Timeout =
Port Limit =
Lock Message =
User = Admin
Протокол = ppp
IP-адрес = 10.10.10.1
Netmask = 255.0.0.0
Framed-MTU = 1500
Compression Used = Van-Jacobson-TCP-IP
Service Type = Framed-IP-Address
Session Timeout =
Idle Timeout =
Port Limit =
Lock Message =
Эти ошибки у меня возникают:
Mikrotik: PPPoE соединение установлено от 00:00:00:00:00:00: жду вызов…: аутентифицирован Admin, вышел, 0 98 80 8 8: прекращено…
- Не удалось определить локальный IP-адрес: отключено.
============================================
FreeRadius:
rad_recv: Пакет Accounting-Request от хоста 10.10.10.254:1024, id=189, length=186
Service-Type = Framed-User
Framed-Protocol = PPP
NAS-Port = 86
NAS-Port-Type = Ethernet
User-Name = “Admin”
Calling-Station-Id = “00:00:00:00:00:00”
Called-Station-Id = “PPPoE”
NAS-Port-Id = “LAN”
Acct-Session-Id = “81c00000”
Framed-IP-Address = 10.10.10.1
Framed-IP-Netmask = 255.0.0.0
Acct-Authentic = RADIUS
Acct-Session-Time = 0
Acct-Input-Octets = 98
Acct-Input-Gigawords = 0
Acct-Input-Packets = 8
Acct-Output-Octets = 80
Acct-Output-Gigawords = 0
Acct-Output-Packets = 8
Acct-Status-Type = Stop <=========
Acct-Terminate-Cause = NAS-Error <=========
NAS-Identifier = “MikroTik”
NAS-IP-Address = 10.10.10.254
Acct-Delay-Time = 0
rad_rmspace_pair: User-Name now ‘Admin’
Processing the preacct section of radiusd.conf
modcall: entering group preacct for request 29
rlm_acct_unique: WARNING: Attribute Client-IP-Address was not found in request, unique ID MAY be inconsistent
rlm_acct_unique: Hashing ‘NAS-Port = 86,NAS-IP-Address = 10.10.10.254,Acct-Session-Id = “81c00000”,User-Name = “Admin”’
rlm_acct_unique: Acct-Unique-Session-ID = “51ce50f50198750c”.
modcall[preacct]: module “acct_unique” returns ok for request 29
modcall: leaving group preacct (returns ok) for request 29
Processing the accounting section of radiusd.conf
modcall: entering group accounting for request 29
radius_xlat: ‘Admin’
rlm_sql (sql): sql_set_user escaped user → ‘Admin’
radius_xlat: ‘UPDATE radacct SET AcctStopTime = ‘2007-01-08 14:07:39’, AcctSessionTime = ‘0’, AcctInputOctets = ‘98’, AcctOutputOctets = ‘80’, AcctTerminateCause = ‘NAS-Error’, AcctStopDelay = ‘0’, ConnectInfo_stop = ‘’ WHERE AcctSessionId = ‘81c00000’ AND UserName = ‘Admin’ AND NASIPAddress = ‘10.10.10.254’’
rlm_sql (sql): Reserving sql socket id: 3
rlm_sql (sql): Released sql socket id: 3
modcall[accounting]: module “sql” returns ok for request 29
modcall: leaving group accounting (returns ok) for request 29
Sending Accounting-Response of id 189 to 10.10.10.254 port 1024
Finished request 29
Going to the next request
Waking up in 6 seconds…
— Walking the entire request list —
Cleaning up request 27 ID 187 with timestamp 45a2886b
Cleaning up request 28 ID 188 with timestamp 45a2886b
Cleaning up request 29 ID 189 with timestamp 45a2886b
Nothing to do.
Sleeping until we see a request.
Группа = Test
Протокол = ppp
IP-адрес =
Netmask = 255.0.0.0
Framed-MTU = 1500
Compression Used = Van-Jacobson-TCP-IP
Service Type = Framed-IP-Address
Session Timeout =
Idle Timeout =
Port Limit =
Lock Message =
User = Admin
Протокол = ppp
IP-адрес = 10.10.10.1
Netmask = 255.0.0.0
Framed-MTU = 1500
Compression Used = Van-Jacobson-TCP-IP
Service Type = Framed-IP-Address
Session Timeout =
Idle Timeout =
Port Limit =
Lock Message =
Эти ошибки у меня возникают:
Mikrotik: PPPoE соединение установлено от 00:00:00:00:00:00: жду вызов…: аутентифицирован Admin, вышел, 0 98 80 8 8: прекращено…
- Не удалось определить локальный IP-адрес: отключено.
============================================
FreeRadius:
rad_recv: Пакет Accounting-Request от хоста 10.10.10.254:1024, id=189, length=186
Service-Type = Framed-User
Framed-Protocol = PPP
NAS-Port = 86
NAS-Port-Type = Ethernet
User-Name = “Admin”
Calling-Station-Id = “00:00:00:00:00:00”
Called-Station-Id = “PPPoE”
NAS-Port-Id = “LAN”
Acct-Session-Id = “81c00000”
Framed-IP-Address = 10.10.10.1
Framed-IP-Netmask = 255.0.0.0
Acct-Authentic = RADIUS
Acct-Session-Time = 0
Acct-Input-Octets = 98
Acct-Input-Gigawords = 0
Acct-Input-Packets = 8
Acct-Output-Octets = 80
Acct-Output-Gigawords = 0
Acct-Output-Packets = 8
Acct-Status-Type = Stop <=========
Acct-Terminate-Cause = NAS-Error <=========
NAS-Identifier = “MikroTik”
NAS-IP-Address = 10.10.10.254
Acct-Delay-Time = 0
rad_rmspace_pair: User-Name now ‘Admin’
Processing the preacct section of radiusd.conf
modcall: entering group preacct for request 29
rlm_acct_unique: WARNING: Attribute Client-IP-Address was not found in request, unique ID MAY be inconsistent
rlm_acct_unique: Hashing ‘NAS-Port = 86,NAS-IP-Address = 10.10.10.254,Acct-Session-Id = “81c00000”,User-Name = “Admin”’
rlm_acct_unique: Acct-Unique-Session-ID = “51ce50f50198750c”.
modcall[preacct]: module “acct_unique” returns ok for request 29
modcall: leaving group preacct (returns ok) for request 29
Processing the accounting section of radiusd.conf
modcall: entering group accounting for request 29
radius_xlat: ‘Admin’
rlm_sql (sql): sql_set_user escaped user → ‘Admin’
radius_xlat: ‘UPDATE radacct SET AcctStopTime = ‘2007-01-08 14:07:39’, AcctSessionTime = ‘0’, AcctInputOctets = ‘98’, AcctOutputOctets = ‘80’, AcctTerminateCause = ‘NAS-Error’, AcctStopDelay = ‘0’, ConnectInfo_stop = ‘’ WHERE AcctSessionId = ‘81c00000’ AND UserName = ‘Admin’ AND NASIPAddress = ‘10.10.10.254’’
rlm_sql (sql): Reserving sql socket id: 3
rlm_sql (sql): Released sql socket id: 3
modcall[accounting]: module “sql” returns ok for request 29
modcall: leaving group accounting (returns ok) for request 29
Sending Accounting-Response of id 189 to 10.10.10.254 port 1024
Finished request 29
Going to the next request
Waking up in 6 seconds…
— Walking the entire request list —
Cleaning up request 27 ID 187 with timestamp 45a2886b
Cleaning up request 28 ID 188 with timestamp 45a2886b
Cleaning up request 29 ID 189 with timestamp 45a2886b
Nothing to do.
Sleeping until we see a request.
