Dialup-Admin & mysql Problems help plz!

Nurul Faizal M.Shukeri nfaizal at usm.my
Thu Aug 4 08:40:44 CEST 2005


Set sql_debug = no in admin.conf

-----Original Message-----
From: freeradius-users-bounces at lists.freeradius.org
[mailto:freeradius-users-bounces at lists.freeradius.org] On Behalf Of Nicholas
Briere
Sent: Thursday, August 04, 2005 2:13 PM
To: freeradius-users at lists.freeradius.org
Subject: Dialup-Admin & mysql Problems help plz!

hello i just installed Freeradius and Freeradius DialupAdmin (with mysql
support)

i changed the admin.conf so its using the correct db username/password.
When i click on quite a few links Like Create New Group i get this atop of
the New Group Page

DEBUG(SQL,MYSQL DRIVER): Query: SELECT DISTINCT groupname FROM usergroup;
DEBUG(SQL,MYSQL DRIVER): Query Result:

then below under the word ' prefrences for new group '
DEBUG(SQL,MYSQL DRIVER): Query: SELECT attribute,value ,op FROM
radgroupcheck WHERE groupname = '';
DEBUG(SQL,MYSQL DRIVER): Query Result: Num rows:: 0
DEBUG(SQL,MYSQL DRIVER): Query Result:

DEBUG(SQL,MYSQL DRIVER): Query: SELECT attribute,value ,op FROM
radgroupreply WHERE groupname = '';
DEBUG(SQL,MYSQL DRIVER): Query Result: Num rows:: 0
DEBUG(SQL,MYSQL DRIVER): Query Result:

DEBUG(SQL,MYSQL DRIVER): Query: SELECT username FROM usergroup WHERE
groupname = '' ORDER BY username;
DEBUG(SQL,MYSQL DRIVER): Query Result: Num rows:: 0
DEBUG(SQL,MYSQL DRIVER): Query Result:


Under " create a new User " i get

DEBUG(SQL,MYSQL DRIVER): Query: SELECT DISTINCT groupname FROM usergroup;
DEBUG(SQL,MYSQL DRIVER): Query Result:


im using Debian (sarge) / apache 1.3 / php4 / mysql 4.0.24-10


Any help on this would be great as im Quite new the 'radius' enviroment and
these sql errors have caused alot of headaches for me :)

- 
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html





More information about the Freeradius-Users mailing list