MikroTik

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.

Code: Select all

/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.

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:

Code: Select all

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.

Have you done that?

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

Code: Select all

mysql -uuser -ppassword radius

Insure this user and password is the same in the FreeRADIUS sql.conf file.

rlm_sql (sql): database query error, SELECT id, nasname, shortname, type, secret, server FROM nas: Unknown column 'server' in 'field list'

describe nas;

This is the giveaway:

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

Code: Select all

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.

Good day...

Dear buddy..
i was follow the guide from the following page with the command, but when testing, the Radius server is not responding.

For the setup on the Ubuntu 11.04 server..
-sudo tasksel
-sudo apt-get update
-sudo apt-get upgrade
-sudo apt-get install mysql-server
-sudo apt-get install php5-gd php-pear php-db
-sudo apt-get install freeradius freeradius-mysql
-sudo apt-get install phpmyadmin

On the DaloRadius Setup
-wget http://sourceforge.net/projects/dalorad ... 9-8.tar.gz
-tar -zxvf daloradius-0.9-8.tar.gz
-mv daloradius-0.9-8 daloradius
-sudo cp daloradius/ /var/www -R
-sudo chown www-data:www-data /var/www/daloradius -R
-sudo chmod 644 /var/www/daloradius/library/daloradius.conf.php

Database setup:
-cd /var/www/daloradius/contrib/db/
-mysql -u root -p
Enter 'mySqlPassword'
mysql> CREATE DATABASE radius;
mysql> quit
-mysql -u root -p radius < fr2-mysql-daloradius-and-freeradius.sql
Database connection setup:
-cd /var/www/daloradius/library/
-sudo nano -w daloradius.conf.php
$configValues['FREERADIUS_VERSION'] = '2';
$configValues['CONFIG_DB_PASS'] = 'mySqlPassword';
$configValues['CONFIG_DB_TBL_RADUSERGROUP'] = 'radusergroup';
Installation completed and login page to create user:
-http://your ip address/daloradius

username: administrator
password: radius

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?

thanks and appreciate it..

Good day...

Dear buddy..
i was follow the guide from the following page with the command, but when testing, the Radius server is not responding.

For the setup on the Ubuntu 11.04 server..
-sudo tasksel
-sudo apt-get update
-sudo apt-get upgrade
-sudo apt-get install mysql-server
-sudo apt-get install php5-gd php-pear php-db
-sudo apt-get install freeradius freeradius-mysql
-sudo apt-get install phpmyadmin

On the DaloRadius Setup
-wget http://sourceforge.net/projects/dalorad ... 9-8.tar.gz
-tar -zxvf daloradius-0.9-8.tar.gz
-mv daloradius-0.9-8 daloradius
-sudo cp daloradius/ /var/www -R
-sudo chown www-data:www-data /var/www/daloradius -R
-sudo chmod 644 /var/www/daloradius/library/daloradius.conf.php

Database setup:
-cd /var/www/daloradius/contrib/db/
-mysql -u root -p
Enter 'mySqlPassword'
mysql> CREATE DATABASE radius;
mysql> quit
-mysql -u root -p radius < fr2-mysql-daloradius-and-freeradius.sql
Database connection setup:
-cd /var/www/daloradius/library/
-sudo nano -w daloradius.conf.php
$configValues['FREERADIUS_VERSION'] = '2';
$configValues['CONFIG_DB_PASS'] = 'mySqlPassword';
$configValues['CONFIG_DB_TBL_RADUSERGROUP'] = 'radusergroup';
Installation completed and login page to create user:
-http://your ip address/daloradius

username: administrator
password: radius

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?

thanks and appreciate it..

You may want to try Access Manager. Check this: accessmanager.in. Its free btw..

Please install freeradius-mysql component
for centos
yum install freeradius-mysql
for ubantu/debian
apt-get freeradius-mysql

your freeradius-mysql is not working so the you are getting sql module error

try
apt-get purge freeradius freeradius-mysql freeradius-common
then
apt-get install freeradius freeradius-mysql freeradius-common

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

first thing in accessmanager.in
it does not support CoA
as this is hosted and and firewall is not configured it will not CoA(on the fly plan changing)

like i want to give users 5am to 11pm 512kbps and 11pm to 5am 2Mbps is this possible(i guess no)

no postpaid invoicing

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