Alan Buxey A.L.M.Buxey at lboro.ac.uk
Sun Nov 6 17:46:19 CET 2016


On 6 November 2016 13:56:49 GMT+00:00, Ejaz <mejaz at cyberia.net.sa> wrote:
>>> SELECT GroupName FROM usergroup WHERE UserName='%{SQL-User-Name}'
>Do you mean we don’t have any data in usergroup table??  

Look at the query.  Look how it got populated. SQL-User-Name was blank. So check in your freeradius sql config to see what it is supposed to represent. 

> alternative
>option is in "sql" file, the table name should be as is  in oracle
>database where that table contents users info ??

Obviously the table name needs to be what you've actually chosen to call it. Either you use the table names that freeradius uses out of the box OR you reconfigure freeradius to use the table names that you have chosen to use. 


More information about the Freeradius-Users mailing list