On Mon, 26 Aug 2002 17:51:28 +0400
Dinar wrote:
> Hi, I'm using FR0.7 with postgresql database
> and I'm selecting reply attributes from database, but in reply I get
> only one attribute.
> My list looks like:
> id | Username | Attribute | value | op
> ---+-------------+------------------+-------------------+----
> 1 | dinar | Service-Type | Login-Service| | =
> 2 | dinar | Framed-Protocol | PPP | =
> 3 | dinar | Session-timeout | 43200 | =
>
> what's wrong???
> my query is
>
> select id,username,attribute,value,op from radreply where
> username=%{SQL-User-Name} order by id;
>
> Best regards, dinar
>
Try setting op field to ':='
Try replacing 'Login-Service' to 'Framed-User'
We use something like this:
radius=# SELECT * FROM radreply ;
id | username | attribute | value | op
----+-----------+-------------------+-----------------+----
1 | <snip> | Framed-IP-Address | <snip> | :=
2 | <snip> | Framed-IP-Netmask | 255.255.255.254 | :=
radius=# SELECT * FROM radgroupreply ;
id | groupname | attribute | value | op
----+-----------+--------------------+---------------------+----
1 | dynamic | Framed-Protocol | PPP | :=
2 | dynamic | Service-Type | Framed-User | :=
3 | dynamic | Framed-IP-Netmask | 255.255.255.240 | :=
etc.
������� ������ ����������
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
