Re: [Radiusplugin-users] Hello "duplication User connected

[Ralf Lübben]

Hi,

the related RADIUS attribute is Acct-Session-Id, maybe 

simul_count_query = "SELECT COUNT(*) \
                             FROM ${acct_table1} \
                             WHERE username = '%{SQL-User-Name}' \
                             AND acctstoptime IS NULL \
                             AND acctsessionid != '%{SQL-Session-Id}'"


From your  radacct table the related attribute is AcctSessionId.

Regards
Ralf
 


Am Sonntag, 27. Juni 2010, um 05:50:26 schrieb sekchel lee:
> Thank you Answer
> 
> error message ------------------------------
> 
> simul_count_query = "SELECT COUNT(*) \
>                             FROM ${acct_table1} \
>                             WHERE username = '%{SQL-User-Name}' \
>                             AND acctstoptime IS NULL \
>                             AND sessionid != '%{SQL-Session-Id}'"
> 
> 
>  AND sessionid != '%{SQL-Session-Id}'"   <=== Right  ??
>  AND sessionid != '%{SQL-Session-Id}'   <===  Wrong  ??
> 
> 
> WARNING: Attempt to use unknown xlat function, or non-existent attribute in
> string %{SQL-Session-Id}
> radius_xlat:  'SELECT COUNT(*)                              FROM
> radacct                             WHERE
> UserName='test4'                             AND AcctStopTime IS
> NULL                             AND sessionid != '''
> rlm_sql (sql): Reserving sql socket id: 0
> rlm_sql_mysql: MYSQL check_error: 1054 received
> 
> 
> 
>  desc radacct;
> +----------------------+-------------+------+-----+---------------------+--
> --------------+
> 
> | Field                | Type        | Null | Key | Default             |
> 
> Extra          |
> +----------------------+-------------+------+-----+---------------------+--
> --------------+
> 
> | RadAcctId            | bigint(21)  | NO   | PRI | NULL                |
> 
> auto_increment |
> 
> | AcctSessionId        | varchar(32) | NO   | MUL |
> | 
> | AcctUniqueId         | varchar(32) | NO   | MUL |
> | 
> | UserName             | varchar(64) | NO   | MUL |
> | 
> | Realm                | varchar(64) | YES  |     |
> | 
> | NASIPAddress         | varchar(15) | NO   | MUL |
> | 
> | NASPortId            | varchar(15) | YES  |     | NULL
> | 
> | NASPortType          | varchar(32) | YES  |     | NULL
> | 
> | AcctStartTime        | datetime    | NO   | MUL | 0000-00-00 00:00:00
> | 
> | AcctStopTime         | datetime    | NO   | MUL | 0000-00-00 00:00:00
> | 
> | AcctSessionTime      | int(12)     | YES  |     | NULL
> | 
> | AcctAuthentic        | varchar(32) | YES  |     | NULL
> | 
> | ConnectInfo_start    | varchar(50) | YES  |     | NULL
> | 
> | ConnectInfo_stop     | varchar(50) | YES  |     | NULL
> | 
> | AcctInputOctets      | bigint(20)  | YES  |     | NULL
> | 
> | AcctOutputOctets     | bigint(20)  | YES  |     | NULL
> | 
> | CalledStationId      | varchar(50) | NO   |     |
> | 
> | CallingStationId     | varchar(50) | NO   |     |
> | 
> | AcctTerminateCause   | varchar(32) | NO   |     |
> | 
> | ServiceType          | varchar(32) | YES  |     | NULL
> | 
> | FramedProtocol       | varchar(32) | YES  |     | NULL
> | 
> | FramedIPAddress      | varchar(15) | NO   | MUL |
> | 
> | AcctStartDelay       | int(12)     | YES  |     | NULL
> | 
> | AcctStopDelay        | int(12)     | YES  |     | NULL
> | 
> | XAscendSessionSvrKey | varchar(10) | YES  |     | NULL
> 
> +----------------------+-------------+------+-----+---------------------+--
> --------------+