Missing Session Time Left on Mikrotik
Posted: 27 May 2019, 13:37
Hello,
Recently we have had complaints by our resellers that users aren't being disconnected when their product expires, and can continue to login to the portal without being prompted to recharge.
Having done some investigation, it seems that the "Session Time Left" field isn't populated for the users with this issue: If you look at the list of sales for this particular users, they do have an expiration date set: I've looked at the "radcheck" table from a database backup, and it looks like the user with the issue doesn't have the 'Expiration' attribute set even though an expiration date is set on the product sale. I've included a working user for comparison. While looking at other users having this problem, I've spotted that some users who also haven't expired have the attribute 'Credit-Time' set instead of 'Expiration' but I don't know how that relates.
Kind regards,
Dean
Recently we have had complaints by our resellers that users aren't being disconnected when their product expires, and can continue to login to the portal without being prompted to recharge.
Having done some investigation, it seems that the "Session Time Left" field isn't populated for the users with this issue: If you look at the list of sales for this particular users, they do have an expiration date set: I've looked at the "radcheck" table from a database backup, and it looks like the user with the issue doesn't have the 'Expiration' attribute set even though an expiration date is set on the product sale. I've included a working user for comparison. While looking at other users having this problem, I've spotted that some users who also haven't expired have the attribute 'Credit-Time' set instead of 'Expiration' but I don't know how that relates.
Kind regards,
Dean