I have a 3.22 Mikrotik with UserManager configurated to login on Freeradius + MySQL database.
For me, all appear work fine.. when the Mikrotik login the user, consult the radcheck table and validate correctly, without problem.
But when i did a query on the tabble radacct, the table is empty.. (without information about the loged users). On the contrary, when i consult the Mikrotik on the hotspot section, only in this areas Active and Host appear the info from the user that i connect.
So.. this are my questions:
1.- Why don’t writte the user information stats on the radacct table like appear on this site (http://infodotnet.blogspot.com/2007/11/part-4-mikrotik-hotspot-freeradius.html). What i do wrong or what i miss on the configuration if the Mikrotik validate correctly the user on the MySQL Database with the radius.
2.- What lines are needed to include on my radgroupreply (diferents thath explained on the: http://wiki.mikrotik.com/wiki/How_to_setup_up_RADIUS_for_use_with_MikroTik_-_By_Ramona), to make the same validation on the use of time connection, cookie expiraton, etc. Used on the UserManager but with my configuration (Mikrotik + Freeradius + MySQL).
Note:
The use of Freeradius + MySql, with Mikrotik is that i need conserve all user history and stadistics.
Which is not possible with my Mikrotik database (Limited Size), and beacose why we wich a more easy, redundant and automatic operation process.
I did update to 3.30 version and still have the same problem, with new one.
After a user login, on the status page, when the value of the status refresh is 0, the user explorer recive again the login page to revalidate the user credentials.
And on the tables of my MySQL still without appear information about the user connection.
The quides at infodotnet seem to be from 2007 and use version 2.9.43 of RouterOS. I suspect this as an issue, since there have been improvements to RouterOS since then.
Thank's for the reply.. and sorry for the late answer. but, i was on vacations.
Yes, i have allowed through the firewall and opened the port 1813.
Using a NTRadPing to do a test in the port 1813, i have this answare:
Sending accounting update request to server ##.##.##.##:1813
Transmiting packet, code=4 id=23 length=37
recived response from the server in 0 milliseconds
reply packet code=5 id=23 length=20
response: Accounting-Response
If that can help, when i start Freeradius with -X (Debuggin mode), i have this lines at the end.
Indicaring that the listening on the port 1813, 1812 and 1814 is ok.
Listening on authentication address * port 1812
Listening on accounting address * port 1813
Listening on proxy address * port 1814
Ready to process request.
BTW, Somebody know, where can find a previus or a early version of freeradius. That is with the indea of making a test with the same environment (like appear on infodotnet) and check if i do something wrong on the new version.
Or.. if some one, know a Page for dummy's where explain how do this configuration with the new versions of Mikrotik, Freeradius and MySQL. You never know.. maybe i was doing this wrong (I don't think so.. but maybe).