how to access CallingStationId and CalledStationId propertes in diaup.conf (sql.conf) in a SQL query

Mehdi Ravanbakhsh babakco at gmail.com
Sat Mar 23 11:31:27 CET 2013


Dear ALL

I use this query by calling stored procedure in database :

simul_count_query = "SELECT
findout_cuncurrent_sessions_for_a_user('%{User-Name}','%{NAS-IP-Address}','%{CalledStationId}','%{CallingStationId}')"

but I can not access to the value of  CallingStationId and CalledStationId.

my radius.log file :


rlm_sql_postgresql: query: SELECT
findout_cuncurrent_sessions_for_a_user('test1','5.190.103.4','','')
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: Error invalid input syntax for type inet: ""
rlm_sql_postgresql: Postgresql Fatal Error: [22P02: INVALID TEXT
REPRESENTATION] Occurred!!
rlm_sql (sql) sql_checksimul: Database query failed
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20130323/0ba2aede/attachment.html>


More information about the Freeradius-Users mailing list