additional SQL-query, after authorize_check_query fail

cky thomas.martens at desy.de
Thu May 3 11:55:13 CEST 2007


Hi,

I use a SQL-database for authorization request from a cisco-ssg (a service
gateway).
This works fine But now I'm trying to perform an additional sql-query, when
the calling-station-id isn't found in the sql-table.

Also, my table looks like this:

mysql> select * from ssg_check;
+----+----------+-----------+--------+----+--------------------+
| id | UserName | Attribute | Value  | op | Calling-Station-Id |
+----+----------+-----------+--------+----+--------------------+
|  1 | Guest    | Auth-Type | ACCEPT | := | 0009.2419.d428     |
+----+----------+-----------+--------+----+--------------------+

If the SSG request the authorization for: Calling-Station-Id 0009.2419.a618,
this record isn't found and the radius send a reject...this is ok.
But, then the record isn't found, it would be great if the radius could do
this insert-statement:

INSERT INTO `ssg_check`
(`UserName`,`Attribute`,`Value`,`op`,`Calling-Station-Id`) VALUES
('GUEST','Auth-Type','REJECT','op','%{Calling-Station-Id}').

Any ideas, how this can be realized?

Thanks in advance!

Best regards,
Thomas

PS: sorry for my bad english....
-- 
View this message in context: http://www.nabble.com/additional-SQL-query%2C-after-authorize_check_query-fail-tf3685565.html#a10301880
Sent from the FreeRadius - User mailing list archive at Nabble.com.




More information about the Freeradius-Users mailing list