Thanxs; How can this be done ? should I configure the queries in raddb/sql.conf ?
regards, John
From: Guy Fraser <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: working with another sql table in freeRadius Date: Fri, 26 Mar 2004 08:55:53 -0700
Yes it can.
Since all the queries are configurable, you can modify them how ever you want.
John Que wrote:
Hello,
I work with freeRadius and mysql. Now , I know and succeed to read attributes from the radreply sql table in the authorize request. (see below an example)
My problem is this :
I want to create a table which has 2 columns :
user country code (integer), and price for that country code (also integer).
Theses 2 attributes can be added as VSA attributes.
Now in the authorize request, I want to pass , besides userName
and password,the country code as a VSA attribute ,and get back from
the radius server (which will read the proper sql table)
the country price for that country code.
As I understand this is not the usual way of working with mysql in radius, since in the usual way we read attributes from a radreply table which correspond to a specific USER NAME and not to something else.
can this be done ?
Any help will be appreciated.
(I do receive bak from authorize
the values of attributes I set for a specific user in the radreply sql table;
thus , if my radreply table is :
mysql> select * from radreply;
+----+----------+-------------------+------+------------------------+ | id | UserName | Attribute | op | Value | +----+----------+-------------------+------+------------------------+ | 1 | 1111 | Framed-IP-Address | := | 164.131.0.1 | +----+----------+-------------------+------+-------------------------+
I do get the value of 164.131.0.1 for Framed-IP-Address attribute.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html