Powered by Jitbit .Net Forum free trial version. dismiss

HomeBugs

Bugs

TekRADIUS LT 5.5 Active Sessions do not appear Messages in this topic - RSS

Admin
Admin
Administrator
Posts: 4931


9.08.2019
Admin
Admin
Administrator
Posts: 4931
Yes, please.
0 link
Zeynep
Zeynep
Posts: 26


10.08.2019
Zeynep
Zeynep
Posts: 26
Step by step I:
1) uninstalled the TekRADIUS LT
2) removed all files under TekRADIUS folder including db3
3) reinstalled the TekRADIUS LT 5.5
4) Replaced the exe files with those in the update pack you sent.
5) I removed SaveAcct=0 under Server setting in the configuration file
6) I restarted the manager and the service
I just received an accounting stop request and according to the log file

09.08.2019 23:54:11.901 - Debug Message (RunQuery) SQL logic error or missing database near "and": syntax error [DELETE from Accounting where StatusType = 'Stop' and AcctSessTime < and tracid = '4D0898F08271F84C837A73AC95A64398' and strftime('%s', [TimeStamp]) >= strftime('%s', datetime('now', '-24 Hour', 'localtime'));]
There is nothing under the Active Session tab, and the devices lost their IPs due to accounting error.

7) I put back the SaveAcct=0 under Server setting in the configuration file
The devices received their IP, but again nothing under the Active Sessions tab
0 link
Admin
Admin
Administrator
Posts: 4931


10.08.2019
Admin
Admin
Administrator
Posts: 4931
Your access server does not ad Accr-Session-Time attribute to RADIUS accounting sop requests. Please replace TekRADIUSLT.exe file with the one in https://www.kaplansoft.com/tekradius/release/TekRADIUSLT.exe.zip and try again. Can you send me full session log entries for accounting packets for a session?
0 link
Zeynep
Zeynep
Posts: 26


10.08.2019
Zeynep
Zeynep
Posts: 26
I changed the exe file with the one you sent and the log file is as follows (by full, I guess you mean this):


10.08.2019 13:59:11.589 - TekRADIUS LT Service 5.5.2 (Revision 0) is being stopped.

10.08.2019 13:59:39.441 - TekRADIUS LT Service 5.5.2 (Revision 0) is being started (Microsoft Windows NT 6.2.9200.0) [en-US] running under account 'NT AUTHORITY\SYSTEM'. Internet connection available. (8A173F9C3039)

10.08.2019 13:59:39.518 - Initializing performance counters.

10.08.2019 13:59:39.527 - .NET Framework Version: 4.6.2 or later

10.08.2019 13:59:39.527 - Initializing clients table.

10.08.2019 13:59:39.527 - Clients table initialized.

10.08.2019 13:59:39.654 - DailyBreakouts view re-created.

10.08.2019 13:59:39.705 - AcctUserList view re-created.

10.08.2019 13:59:39.740 - Reading dictionary.

10.08.2019 13:59:39.848 - Accounting packets will not be recorded.

10.08.2019 13:59:39.853 - Default EAP method is PEAP.

10.08.2019 13:59:39.960 - Starting TekRADIUS LT Authentication [UDP (1812)] thread.

10.08.2019 13:59:39.962 - TekRADIUS LT Authentication (UDP) thread is started.

10.08.2019 13:59:40.238 - Starting TekRADIUS LT Authentication [TCP (1812)] thread.

10.08.2019 13:59:40.239 - TekRADIUS LT Authentication (TCP) thread is started.

10.08.2019 13:59:40.243 - Populating active stations table.

10.08.2019 13:59:40.244 - No active station found.

10.08.2019 13:59:40.366 - Starting TekRADIUS LT Accounting [UDP (1813)] thread.

10.08.2019 13:59:40.367 - TekRADIUS LT Accounting (UDP) thread is started.

10.08.2019 13:59:40.691 - Starting TekRADIUS LT Accounting [TCP (1813)] thread.

10.08.2019 13:59:40.691 - TekRADIUS LT Accounting (TCP) thread is started.

10.08.2019 13:59:40.694 - TekRADIUS LT Service is listening 172.16.230.1 (12 client(s))

10.08.2019 13:59:40.698 - Sending alert message (mail.turaconsulting.net:26)

10.08.2019 13:59:41.209 - Performance counters initialized.

10.08.2019 13:59:43.490 - (Send_Mail) Mailbox unavailable. The server response was: Access denied - Invalid HELO name (See RFC2821 4.1.1.1)

10.08.2019 13:59:43.490 - Startup completed.

10.08.2019 14:00:19.940 - RadAuth req. from : 10.128.128.241:50117 [UDP]

Size : 115 / 115
Identifier : 3
Attributes :

NAS-Port-Type = 5
Called-Station-Id = signalix
Calling-Station-Id = 55XXX
Service-Type = 2
Framed-Protocol = 7
NAS-IP-Address = 10.128.128.241
NAS-Port = 0
NAS-Identifier = VGGTZLE01
User-Name = 55XXX

10.08.2019 14:00:19.972 - Authentication successful for user '55XXX'

10.08.2019 14:00:19.980 - RadAuth reply to : 10.128.128.241:50117 (Success)

Size : 38
Identifier : 3
Attributes :

User-Name = 55XXX
Framed-IP-Address = 10.128.128.14

10.08.2019 14:00:20.325 - RadAcct req. from : 10.128.128.241:50117 [UDP]

Size : 139 / 139
Identifier : 8
Attributes :

Framed-IP-Address = 10.128.128.14
Acct-Status-Type = Start
NAS-Port-Type = Virtual
Called-Station-Id = signalix
Calling-Station-Id = 55XXX
NAS-IP-Address = 10.128.128.241
Acct-Session-Id = D91FF8C207B47141
NAS-Identifier = VGGTZLE01
User-Name = 55XXX

10.08.2019 14:00:20.329 - Simultaneous session counter for user '55XXX' set to 1.
0 link
Admin
Admin
Administrator
Posts: 4931


10.08.2019
Admin
Admin
Administrator
Posts: 4931
Here is another update; https://www.kaplansoft.com/tekradius/release/TekRADIUSLT.exe.zip Please apply this and try again after removing SaveAcct=0
0 link
Zeynep
Zeynep
Posts: 26


11.08.2019
Zeynep
Zeynep
Posts: 26
I did. As I remove the SaveAcct=0, same thing. Devices can not get IP, active sessions do not appear.
The log is as follows:
11.08.2019 10:18:10.958 - TekRADIUS LT Service 5.5.2 (Revision 0) is being started (Microsoft Windows NT 6.2.9200.0) [en-US] running under account 'NT AUTHORITY\SYSTEM'. Internet connection available. (8A173F9C3039)

11.08.2019 10:18:11.044 - Initializing performance counters.

11.08.2019 10:18:11.048 - .NET Framework Version: 4.6.2 or later

11.08.2019 10:18:11.048 - Initializing clients table.

11.08.2019 10:18:11.049 - Clients table initialized.

11.08.2019 10:18:11.155 - DailyBreakouts view re-created.

11.08.2019 10:18:11.168 - AcctUserList view re-created.

11.08.2019 10:18:11.208 - Reading dictionary.

11.08.2019 10:18:11.404 - Default EAP method is PEAP.

11.08.2019 10:18:11.576 - Starting TekRADIUS LT Authentication [UDP (1812)] thread.

11.08.2019 10:18:11.578 - TekRADIUS LT Authentication (UDP) thread is started.

11.08.2019 10:18:11.963 - Starting TekRADIUS LT Authentication [TCP (1812)] thread.

11.08.2019 10:18:11.964 - TekRADIUS LT Authentication (TCP) thread is started.

11.08.2019 10:18:11.968 - Populating active stations table.

11.08.2019 10:18:11.968 - No active station found.
11.08.2019 10:18:11.992 - Starting TekRADIUS LT Accounting [UDP (1813)] thread.

11.08.2019 10:18:11.992 - TekRADIUS LT Accounting (UDP) thread is started.

11.08.2019 10:18:12.177 - Starting TekRADIUS LT Accounting [TCP (1813)] thread.

11.08.2019 10:18:12.177 - TekRADIUS LT Accounting (TCP) thread is started.

11.08.2019 10:18:12.179 - TekRADIUS LT Service is listening 172.16.230.1 (12 client(s))

11.08.2019 10:18:12.183 - Sending alert message (mail.turaconsulting.net:26)

11.08.2019 10:18:12.533 - Performance counters initialized.

11.08.2019 10:18:14.652 - (Send_Mail) Mailbox unavailable. The server response was: Access denied - Invalid HELO name (See RFC2821 4.1.1.1)

11.08.2019 10:18:14.652 - Startup completed.

11.08.2019 10:22:19.815 - RadAuth req. from : 10.128.128.241:49365 [UDP]


Size : 115 / 115
Identifier : 249
Attributes :
NAS-Port-Type = 5

Called-Station-Id = signalix
Calling-Station-Id = 9055XXX
Service-Type = 2
Framed-Protocol = 7
NAS-IP-Address = 10.128.128.241
NAS-Port = 0
NAS-Identifier = VGGTZLE01
User-Name = 55XXX

11.08.2019 10:22:19.827 - Authentication successful for user '55XXX'
11.08.2019 10:22:19.832 - RadAuth reply to : 10.128.128.241:49365 (Success)

Size : 38

Identifier : 249
Attributes :
User-Name = 55XXX

Framed-IP-Address = 10.128.128.14
11.08.2019 10:22:20.157 - RadAcct req. from : 10.128.128.241:49365 [UDP]

Size : 139 / 139

Identifier : 252
Attributes :

Framed-IP-Address = 10.128.128.14
Acct-Status-Type = Start
NAS-Port-Type = Virtual
Called-Station-Id = signalix
Calling-Station-Id = 9055XXX
NAS-IP-Address = 10.128.128.241
Acct-Session-Id = D91FF8C2081AAF51
NAS-Identifier = VGGTZLE01
User-Name = 55XXX

11.08.2019 10:22:20.161 - Simultaneous session counter for user '55XXX' set to 1.
11.08.2019 10:22:20.161 - Simultaneous session counter for group 'Default' set to 1.

11.08.2019 10:22:20.171 - Debug Message (Radius Accounting [10.128.128.241:49365, 252]); SQL logic error or missing database 18 values for 17 columns [16]

11.08.2019 10:22:23.162 - RadAcct req. from : 10.128.128.241:49239 [UDP]


Size : 139 / 139
Identifier : 38
Attributes :

Framed-IP-Address = 10.128.128.14
Acct-Status-Type = Start
NAS-Port-Type = Virtual
Called-Station-Id = signalix
Calling-Station-Id = 9055XXX
NAS-IP-Address = 10.128.128.241
Acct-Session-Id = D91FF8C2081AAF51
NAS-Identifier = VGGTZLE01
User-Name = 55XXX

11.08.2019 10:22:23.163 - Simultaneous session counter for user '55XXX' set to 2.
11.08.2019 10:22:23.163 - Simultaneous session counter for group 'Default' set to 2.

11.08.2019 10:22:23.166 - Debug Message (Radius Accounting [10.128.128.241:49239, 38]); SQL logic error or missing database 18 values for 17 columns [16]

11.08.2019 10:22:26.212 - RadAcct req. from : 10.128.128.241:49239 [UDP]


Size : 139 / 139
Identifier : 70
Attributes :

Framed-IP-Address = 10.128.128.14
Acct-Status-Type = Start
NAS-Port-Type = Virtual
Called-Station-Id = signalix
Calling-Station-Id = 9055XXX
NAS-IP-Address = 10.128.128.241
Acct-Session-Id = D91FF8C2081AAF51
NAS-Identifier = VGGTZLE01
User-Name = 55XXX

11.08.2019 10:22:26.212 - Simultaneous session counter for user '55XXX' set to 3.

11.08.2019 10:22:26.214 - Simultaneous session counter for group 'Default' set to 3.

11.08.2019 10:22:26.215 - Debug Message (Radius Accounting [10.128.128.241:49239, 70]); SQL logic error or missing database 18 values for 17 columns [16]

11.08.2019 10:29:10.322 - RadAuth req. from : 10.128.128.241:50117 [UDP]

Size : 115 / 115
Identifier : 164
Attributes :

NAS-Port-Type = 5
Called-Station-Id = signalix
Calling-Station-Id = 9055XXX
Service-Type = 2
Framed-Protocol = 7
NAS-IP-Address = 10.128.128.241
NAS-Port = 0
NAS-Identifier = VGGTZLE01
User-Name = 55XXX

11.08.2019 10:29:10.323 - Authentication successful for user '55XXX'

11.08.2019 10:29:10.324 - RadAuth reply to : 10.128.128.241:50117 (Success)

Size : 38
Identifier : 164
Attributes :

User-Name = 55XXX
Framed-IP-Address = 10.128.128.14

11.08.2019 10:29:10.581 - RadAcct req. from : 10.128.128.241:50117 [UDP]

Size : 139 / 139
Identifier : 168
Attributes :

Framed-IP-Address = 10.128.128.14
Acct-Status-Type = Start
NAS-Port-Type = Virtual
Called-Station-Id = signalix
Calling-Station-Id = 9055XXX
NAS-IP-Address = 10.128.128.241
Acct-Session-Id = D91FF8C2081B29A1
NAS-Identifier = VGGTZLE01
User-Name = 55XXX

11.08.2019 10:29:10.581 - Simultaneous session counter for user '55XXX' set to 4.

11.08.2019 10:29:10.582 - Simultaneous session counter for group 'Default' set to 4.

11.08.2019 10:29:10.584 - Debug Message (Radius Accounting [10.128.128.241:50117, 168]); SQL logic error or missing database 18 values for 17 columns [16]

11.08.2019 10:29:10.584 - Sending alert message (mail.turaconsulting.net:26)

11.08.2019 10:29:13.000 - (Send_Mail) Mailbox unavailable. The server response was: Access denied - Invalid HELO name (See RFC2821 4.1.1.1)

11.08.2019 10:29:13.606 - RadAcct req. from : 10.128.128.241:50117 [UDP]

Size : 139 / 139
Identifier : 206
Attributes :

Framed-IP-Address = 10.128.128.14
Acct-Status-Type = Start
NAS-Port-Type = Virtual
Called-Station-Id = signalix
Calling-Station-Id = 9055XXX
NAS-IP-Address = 10.128.128.241
Acct-Session-Id = D91FF8C2081B29A1
NAS-Identifier = VGGTZLE01
User-Name = 55XXX

11.08.2019 10:29:13.606 - Simultaneous session counter for user '55XXX' set to 5.

11.08.2019 10:29:13.607 - Simultaneous session counter for group 'Default' set to 5.

11.08.2019 10:29:13.610 - Debug Message (Radius Accounting [10.128.128.241:50117, 206]); SQL logic error or missing database 18 values for 17 columns [16]

11.08.2019 10:29:16.656 - RadAcct req. from : 10.128.128.241:50117 [UDP]

Size : 139 / 139
Identifier : 238
Attributes :

Framed-IP-Address = 10.128.128.14
Acct-Status-Type = Start
NAS-Port-Type = Virtual
Called-Station-Id = signalix
Calling-Station-Id = 9055XXX
NAS-IP-Address = 10.128.128.241
Acct-Session-Id = D91FF8C2081B29A1
NAS-Identifier = VGGTZLE01
User-Name = 55XXX

11.08.2019 10:29:16.656 - Simultaneous session counter for user '55XXX' set to 6.
11.08.2019 10:29:16.657 - Simultaneous session counter for group 'Default' set to 6.

11.08.2019 10:29:16.658 - Debug Message (Radius Accounting [10.128.128.241:50117, 238]); SQL logic error or missing database 18 values for 17 columns [16]



If I keep it as, set to zero, devices get authentication. Is there any way I can work around by playing with the db3 file?
0 link
Admin
Admin
Administrator
Posts: 4931


11.08.2019
Admin
Admin
Administrator
Posts: 4931
Here is another update; https://www.kaplansoft.com/tekradius/release/TekRADIUSLT.A.exe.zip Please apply this and try again after removing SaveAcct=0. This one should solve the problem.
+1 link
Zeynep
Zeynep
Posts: 26


11.08.2019
Zeynep
Zeynep
Posts: 26
It actually did. Thank you very much indeed. Great support especially on the first day of bayram. Happy Eid-el Adha.
0 link
Admin
Admin
Administrator
Posts: 4931


11.08.2019
Admin
Admin
Administrator
Posts: 4931
You welcome ve bayramınız kutlu olsun.
0 link
12






Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software