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-fa... Sent from the FreeRadius - User mailing list archive at Nabble.com.