When test with the Mikrotik, it shown not respond from the server..
the NAS setting is matched, refer to the log file from the Daloradius, it shown “Error: Ignoring request to authentication address”
could it be due to the setup error or? as refer to the guidance from the web, the setup everything is run well, using the freeradius -x, it shown..
~Listening on authentication interface eth0 *port 1812
~Listening on accounting *port 1813
~Listening on authentication address 127.0.0.1 port 18120 as server inner-tunnel
~Ready to process request.
what could be wrong and which part should i check on it?
I think DaloRADIUS is a front end for FreeRADIUS, or at least very close.
It sounds like you do not have the appropriate client entry for that ip (the router with the radius client, like hotspot, wireless, etc) in your RADIUS clients.conf file. That is the equivalent of the “Routers” tab in User Manager.
Insure you increase your radius timeout value temporarily.
/radius
print detail
set 0 timeout=2s
Do not increase the timeout value if you use User Manager. It does not have a Access-Reject delay.
Hi dude…would you mind to share more how to setup thefree radius server?
I had try few days already and install uninstall, but still can’re make it work…
And google a lot of but cannfind out the solution…
Did you add a new entry to you clients.conf file for your router? My clients.conf file is in the /etc/raddb directory. You need to add an entry like this:
client xx.xx.xx.xx {
secret = mysecret
}
Replace xx.xx.xx.xx with the ip of your router and secret with your radius secret for that router.
There is a lot of modifications you can make to the basic FreeRADIUS package, and I am certain DaloRADIUS has included their own stuff.
Considering the initial error is in the “sql.conf” file, you might insure the user/password for your MySQL radius database in that file is correct. From a shell prompt on the RADIUS/MySQL server
mysql -uuser -ppassword radius
Insure this user and password is the same in the FreeRADIUS sql.conf file.
hi dude..
may i post a bit more information, as refer to it, it able to connect to the DB but some how, there is some error.. i google + ing now …
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
rlm_sql (sql): Attempting to connect to root@127.0.0.1:/radius
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (sql): Connected new DB handle, #0
rlm_sql (sql): starting 1
rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (sql): Connected new DB handle, #1
rlm_sql (sql): starting 2
rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (sql): Connected new DB handle, #2
rlm_sql (sql): starting 3
rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (sql): Connected new DB handle, #3
rlm_sql (sql): starting 4
rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (sql): Connected new DB handle, #4
rlm_sql (sql): Processing generate_sql_clients
rlm_sql (sql) in generate_sql_clients: query is SELECT id, nasname, shortname, type, secret, server FROM nas
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_mysql: MYSQL check_error: 1054 received
rlm_sql (sql): database query error, SELECT id, nasname, shortname, type, secret, server FROM nas: Unknown column ‘server’ in ‘field list’
rlm_sql (sql): Released sql socket id: 4
Failed to load clients from SQL.
rlm_sql (sql): Closing sqlsocket 4
rlm_sql (sql): Closing sqlsocket 3
rlm_sql (sql): Closing sqlsocket 2
rlm_sql (sql): Closing sqlsocket 1
rlm_sql (sql): Closing sqlsocket 0
/etc/freeradius/sql.conf[22]: Instantiation failed for module “sql”
/etc/freeradius/sites-enabled/default[159]: Failed to load module “sql”.
/etc/freeradius/sites-enabled/default[62]: Errors parsing authorize section.
root@MykrisRadiusServer:/#
it’s headache as very hard to get the information from google + ing..
really really appreciate on your help…
rlm_sql (sql): database query error, SELECT id, nasname, shortname, type, secret, server FROM nas: Unknown column ‘server’ in ‘field list’
According to this error message, there is no field named “server” in the nas table.
From a mysql prompt
describe nas;
That should display all fields and types in table “nas”.
Now we are really getting out of the scope of this forum. This is a Mikrotik forum, and this subject has turned into a FreeRADIUS/DaloRADIUS troubleshooting question. It may be best to find a DaloRADIUS forum and ask this question there.
and accessmanager.in is not working as expected instead we are developing owr own Radius manager application on php
beta testing will be available soon
Aaah.. you’re wrong.. its does on the fly plan changing. And for the given scenario you can simply choose “different bandwidth policy for Day/Night” while creating service plan. And this to work, you need to enable “incoming” under radius on your mikrotik box and will require mikrotik to allow packets from Access manager’s IP.
And for postpaid invoicing, as of now, it is not there. But, this is already on our to do list.
will it work behind a firewall(the coa)
and also for the coa to work we have to save the access point userid and pass in your database and it is not safe
For CoA - Yes, as long as packets on port 3799 from Access Manager to your Mikrotik are allowed, it’ll work.
And you don’t need to save your AP’s user/pass into our database. You just need to your Mikrotik’s WAN (Public) IP, Shared Secret & NAS ID. WAN IP & Secret are required for Radius communication, for NAS ID, we use this for other purposes i.e. serving customized login page.
Hello,
I installed wit this tutorial on virtualbox Ubuntu servere 12.10 and when i logged at
http://ip/daloradius
with “administrator” and “radius”
i got mysql error:
Database error
Error Message: DB Error: no such table
Debug info: SELECT id, username FROM operators WHERE username = 'Administrador' AND password = 'radius' [nativecode=1146 ** Table 'radius.operators' doesn't exist]
to repair this you must:
# cd /var/www/daloradius/contrib/db/
# mysql -u(your username) -p(your password) radius(or the name of database you created) <mysql-daloradius.sql
