Where is my error with FreeRadius with Mysql and Dialup-Admin for Mikrotik?
If I create a User = admin that belongs to Group = Test, users are going to have Static IPs from network 10.10.10.0/24
Group = Test
==========
Protocol = ppp
IP Address =
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
==========
Protocol = ppp
IP Address = 10.10.10.1
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 =
These are the errors that I’m having:
Mikrotik:
PPPoE Connection establishe from 00:00:00:00:00:00
<pppoe-0>: waiting for call...
<pppoe-Admin>: authenticated
Admin logget out, 0 98 80 8 8
<pppoe-Admin>: terminating... -could not determinate local IP address
<pppoe-Admin>: disconnected
=============================================
FreeRadius:
rad_recv: Accounting-Request packet from host 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.
