Powered by Jitbit .Net Forum free trial version. dismiss

HomeBugs

Bugs

Not able to capture according Messages in this topic - RSS

vijith
vijith
Posts: 2


7.02.2018
vijith
vijith
Posts: 2
Hi

I have some problems on my Mikrotik Client in account packet. I've configured a correct port on Mikrotik and Tekradius(1813), however, i'm receiving in Mikrotik error on log and error on the Tekradius log. i am using 5.3.5.5 version.

Mikrotik log show: "RADIUS accounting request not send: no response"


Tekradius log.



Size : 211 / 211
Identifier : 184
Attributes :

NAS-Port = 2155872265
Calling-Station-Id = B0:48:1A:A8:46:07
Called-Station-Id = hotspot1
NAS-Port-Id = ether3
Acct-Output-Octets = 587071337
Acct-Input-Octets = 109093650
Acct-Status-Type = Checkpoint
Acct-Session-Time = 18356
Acct-Session-Id = 80800009
NAS-Identifier = MikroTik
NAS-IP-Address = 192.168.89.1
Acct-Output-Gigawords = 0
NAS-Port-Type = Wireless
Framed-IP-Address = 10.5.50.243
User-Name = 55fe84dd-93d3-480a-96b7-3305324ff04a
Acct-Input-Gigawords = 0

07.02.2018 11:23:09.511 - Debug Message (Radius Accounting [192.168.89.1:47907, 184]); Invalid column name 'InputGigaWord'.Invalid column name 'OutputGigaWord'. [1891]

07.02.2018 11:23:10.635 - Performace counters initialized.

07.02.2018 11:23:14.472 - RadAcct req. from : 192.168.89.1:47907 [UDP]

Size : 211 / 211
Identifier : 184
Attributes :

NAS-Port = 2155872265
Calling-Station-Id = B0:48:1A:A8:46:07
Called-Station-Id = hotspot1
NAS-Port-Id = ether3
Acct-Output-Octets = 587071337
Acct-Input-Octets = 109093650
Acct-Status-Type = Checkpoint
Acct-Session-Time = 18356
Acct-Session-Id = 80800009
NAS-Identifier = MikroTik
NAS-IP-Address = 192.168.89.1
Acct-Output-Gigawords = 0
NAS-Port-Type = Wireless
Framed-IP-Address = 10.5.50.243
User-Name = 55fe84dd-93d3-480a-96b7-3305324ff04a
Acct-Input-Gigawords = 0

07.02.2018 11:23:14.488 - Debug Message (Radius Accounting [192.168.89.1:47907, 184]); Invalid column name 'InputGigaWord'.Invalid column name 'OutputGigaWord'. [1891]

07.02.2018 11:23:15.018 - RadAcct req. from : 192.168.89.1:38113 [UDP]

Regards,
Vijith.pk








0 link
Admin
Admin
Administrator
Posts: 4992


7.02.2018
Admin
Admin
Administrator
Posts: 4992
Hi,

As you can see in the log your accounting table under TekRADIUS table has not required fields InputGigaWord and OutputGigaWord. You need to add this numeric fields to the accounting table. You can drop existing table through SQL Management Studio and re-create Accounting table through TekRADIUS Manager / Settings / Database.


You can alternatively apply update at https://www.kaplansoft.com/tekradius/release/TekRADIUS-Update.zip


Best regards,


Yasin KAPLAN
0 link
vijith
vijith
Posts: 2


7.02.2018
vijith
vijith
Posts: 2
Thank you, its working super cool.

regards,
vijith.pk



Admin wrote:
Hi,

As you can see in the log your accounting table under TekRADIUS table has not required fields InputGigaWord and OutputGigaWord. You need to add this numeric fields to the accounting table. You can drop existing table through SQL Management Studio and re-create Accounting table through TekRADIUS Manager / Settings / Database.


You can alternatively apply update at https://www.kaplansoft.com/tekradius/release/TekRADIUS-Update.zip


Best regards,


Yasin KAPLAN
0 link
Admin
Admin
Administrator
Posts: 4992


7.02.2018
Admin
Admin
Administrator
Posts: 4992
You welcome
0 link






Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software