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