Debug info: SELECT distinct(radcheck.username),radcheck.value,
radcheck.id,radgroupcheck.groupname as groupname, radcheck.attribute,
userinfo.firstname, userinfo.lastname FROM radcheck LEFT JOIN userinfo ON
radcheck.username=userinfo.username LEFT JOIN radgroupcheck ON
radcheck.username=radgroupcheck.username WHERE (Attribute LIKE '%-Password')
OR (Attribute='Auth-Type') GROUP BY UserName
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Debug info: SELECT distinct(radgroupreply.GroupName),
count(distinct(radgroupcheck.username)) AS Users FROM radgroupreply LEFT JOIN
radgroupcheck ON radgroupreply.GroupName=radgroupcheck.GroupName GROUP BY
radgroupreply.GroupName UNION SELECT distinct(radgroupcheck.GroupName),
count(distinct(radgroupcheck.username)) FROM radgroupcheck LEFT JOIN
radgroupcheck ON radgroupcheck.GroupName=radgroupcheck.GroupName GROUP BY
radgroupcheck.GroupName;
User-Group Mapping in Database +
Database error
Error Message: DB Error: no such field
Debug info: SELECT distinct(radgroupcheck.UserName), radgroupcheck.GroupName,
radgroupcheck.priority, userinfo.firstname, userinfo.lastname FROM
radgroupcheck LEFT JOIN userinfo ON radgroupcheck.username=userinfo.username
GROUP BY UserName;
Profiles Configuration +
Database error
Error Message: DB Error: unknown error
Debug info: SELECT distinct(radgroupreply.GroupName),
count(distinct(radgroupcheck.username)) AS Users FROM radgroupreply LEFT JOIN
radgroupcheck ON radgroupreply.GroupName=radgroupcheck.GroupName GROUP BY
radgroupreply.GroupName UNION SELECT distinct(radgroupcheck.GroupName),
count(distinct(radgroupcheck.username)) FROM radgroupcheck LEFT JOIN
radgroupcheck ON radgroupcheck.GroupName=radgroupcheck.GroupName GROUP BY
radgroupcheck.GroupName;
daloRADIUS Logfile :: 50 Lines Count with filter set to . +
error reading log file: /tmp/daloradius.log
looked for log file in /tmp/daloradius.log but couldn't find it.
if you know where your daloradius log file is located, set it's location in
your library/daloradius.conf file
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
freeradius: FreeRADIUS Version 2.1.8, for host x86_64-pc-linux-gnu, built on
Jan 5 2010 at 02:56:18
Copyright (C) 1999-2009 The FreeRADIUS server project and contributors.
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE.
You may redistribute copies of FreeRADIUS under the terms of the
GNU General Public License.
For more information about these matters, see the file named COPYRIGHT.
DALORADIUS:
All Rights Reserved.
*
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License
* as published by the Free Software Foundation; either version 2
* of the License, or (at your option) any later version.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
*
*********************************************************************************************************
* Description:
* daloRADIUS Configuration File
*
* Modification Date:
* Tue Sep 30 16:29:00 EDT 2008
*********************************************************************************************************
*/
$configValues = 'mysql';
$configValues = '127.0.0.1';
$configValues = 'root';
$configValues = 'xxxxxx';
$configValues = 'radius';
$configValues = 'radcheck';
$configValues = 'radreply';
$configValues = 'radgroupreply';
$configValues = 'radgroupcheck';
$configValues = 'usergroup';
$configValues = 'nas';
$configValues = 'radpostauth';
$configValues = 'radacct';
$configValues = 'radippool';
$configValues = 'operators';
$configValues = 'rates';
$configValues = 'hotspots';
$configValues = 'userinfo';
$configValues = 'dictionary';
$configValues = 'realms';
$configValues = 'proxys';
$configValues = '/etc/freeradius/proxy.conf';
$configValues = '';
$configValues = '/var/www/daloradius/var';
$configValues = 'cleartext';
$configValues = 'en';
$configValues = 'no';
$configValues = 'no';
$configValues = 'no';
$configValues = 'no';
$configValues = 'no';
$configValues = '/tmp/daloradius.log';
$configValues = 'no';
$configValues = '25';
$configValues = 'yes';
$configValues = 'no';
$configValues = '127.0.0.1';
$configValues = '1812';
$configValues = '0';
$configValues = 'testing123';
?>
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Do you know a small "HOW TO" uset the dolaradious to configur with five
mikrotik hotspots? that have 3 hot spot on each? and they use Mikrotik captive
portal, login page and register new user. And use pay pal? Do you know any
good tutorials on that?
thx \
TOm
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Users Listing +
Database error
Error Message: DB Error: unknown error
Debug info: SELECT distinct(radcheck.username),radcheck.value,
radcheck.id,radgroupcheck.groupname as groupname, radcheck.attribute,
userinfo.firstname, userinfo.lastname FROM radcheck LEFT JOIN userinfo ON
radcheck.username=userinfo.username LEFT JOIN radgroupcheck ON
radcheck.username=radgroupcheck.username WHERE (Attribute LIKE '%-Password')
OR (Attribute='Auth-Type') GROUP BY UserName
Also, forgot, those too,:
Profiles Configuration +
Database error
Error Message: DB Error: unknown error
Debug info: SELECT distinct(radgroupreply.GroupName),
count(distinct(radgroupcheck.username)) AS Users FROM radgroupreply LEFT JOIN
radgroupcheck ON radgroupreply.GroupName=radgroupcheck.GroupName GROUP BY
radgroupreply.GroupName UNION SELECT distinct(radgroupcheck.GroupName),
count(distinct(radgroupcheck.username)) FROM radgroupcheck LEFT JOIN
radgroupcheck ON radgroupcheck.GroupName=radgroupcheck.GroupName GROUP BY
radgroupcheck.GroupName;
User-Group Mapping in Database +
Database error
Error Message: DB Error: no such field
Debug info: SELECT distinct(radgroupcheck.UserName), radgroupcheck.GroupName,
radgroupcheck.priority, userinfo.firstname, userinfo.lastname FROM
radgroupcheck LEFT JOIN userinfo ON radgroupcheck.username=userinfo.username
GROUP BY UserName;
Profiles Configuration +
Database error
Error Message: DB Error: unknown error
Debug info: SELECT distinct(radgroupreply.GroupName),
count(distinct(radgroupcheck.username)) AS Users FROM radgroupreply LEFT JOIN
radgroupcheck ON radgroupreply.GroupName=radgroupcheck.GroupName GROUP BY
radgroupreply.GroupName UNION SELECT distinct(radgroupcheck.GroupName),
count(distinct(radgroupcheck.username)) FROM radgroupcheck LEFT JOIN
radgroupcheck ON radgroupcheck.GroupName=radgroupcheck.GroupName GROUP BY
radgroupcheck.GroupName;
daloRADIUS Logfile :: 50 Lines Count with filter set to . +
error reading log file: /tmp/daloradius.log
looked for log file in /tmp/daloradius.log but couldn't find it.
if you know where your daloradius log file is located, set it's location in
your library/daloradius.conf file
All of your errors are about the radgroupcheck table, which you don't have
exist in your database.
Check your database schema and set your table names accordingly.
Regards,
Liran.
What do you mean that i dont have radgroupcheck table?
I do have.
mysql> show tables;
+------------------+
| Tables_in_radius |
+------------------+
| billing_history |
| billing_paypal |
| billing_plans |
| billing_rates |
| dictionary |
| hotspots |
| nas |
| operators |
| proxys |
| radacct |
| radcheck |
| radgroupcheck |
| radgroupreply |
| radippool |
| radpostauth |
| radreply |
| radusergroup |
| realms |
| userbillinfo |
| userinfo |
| wimax |
+------------------+
21 rows in set (0.00 sec)
mysql>
Right.
Look at your errors, there are many issues with database, queries, etc.
Which version of dalo and of freeradius are you using?
FREERADIUS:
freeradius: FreeRADIUS Version 2.1.8, for host x86_64-pc-linux-gnu, built on
Jan 5 2010 at 02:56:18
Copyright (C) 1999-2009 The FreeRADIUS server project and contributors.
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE.
You may redistribute copies of FreeRADIUS under the terms of the
GNU General Public License.
For more information about these matters, see the file named COPYRIGHT.
DALORADIUS:
All Rights Reserved. * * This program is free software; you can redistribute it and/or * modify it under the terms of the GNU General Public License * as published by the Free Software Foundation; either version 2 * of the License, or (at your option) any later version. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. * ********************************************************************************************************* * Description: * daloRADIUS Configuration File * * Modification Date: * Tue Sep 30 16:29:00 EDT 2008 ********************************************************************************************************* */ $configValues = 'mysql'; $configValues = '127.0.0.1'; $configValues = 'root'; $configValues = 'xxxxxx'; $configValues = 'radius'; $configValues = 'radcheck'; $configValues = 'radreply'; $configValues = 'radgroupreply'; $configValues = 'radgroupcheck'; $configValues = 'usergroup'; $configValues = 'nas'; $configValues = 'radpostauth'; $configValues = 'radacct'; $configValues = 'radippool'; $configValues = 'operators'; $configValues = 'rates'; $configValues = 'hotspots'; $configValues = 'userinfo'; $configValues = 'dictionary'; $configValues = 'realms'; $configValues = 'proxys'; $configValues = '/etc/freeradius/proxy.conf'; $configValues = ''; $configValues = '/var/www/daloradius/var'; $configValues = 'cleartext'; $configValues = 'en'; $configValues = 'no'; $configValues = 'no'; $configValues = 'no'; $configValues = 'no'; $configValues = 'no'; $configValues = '/tmp/daloradius.log'; $configValues = 'no'; $configValues = '25'; $configValues = 'yes'; $configValues = 'no'; $configValues = '127.0.0.1'; $configValues = '1812'; $configValues = '0'; $configValues = 'testing123'; ?>DALORADIUS: 0.9.8
I followed these instraction:
tar -zxvf daloradius-0.9-8.tar.gz
https://help.ubuntu.com/community/CategoryNetworking/daloRADIUS
Go ahead and use 0.9-9, I'm not sure what that document describes...
THanks that 9.9 realy worked.
Do you know a small "HOW TO" uset the dolaradious to configur with five
mikrotik hotspots? that have 3 hot spot on each? and they use Mikrotik captive
portal, login page and register new user. And use pay pal? Do you know any
good tutorials on that?
thx \
TOm