[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Radiusplugin-users] Hello "duplication User connected
From: |
sekchel lee |
Subject: |
Re: [Radiusplugin-users] Hello "duplication User connected |
Date: |
Sun, 27 Jun 2010 12:50:26 +0900 |
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 | |
+----------------------+-------------+------+-----+---------------------+----------------+
- Re: [Radiusplugin-users] Hello "duplication User connected,
sekchel lee <=