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

[sekchel lee]

Dear Ralf Lübben

Thank very much

 

Same error

My situation 

radiusd.conf 

Session database, used for checking Simultaneous-Use.

session

{

#radutmp #disable

sql   #enable

}

 

 usergroup;
+----------+-----------+----------+
| UserName | GroupName | priority |
+----------+-----------+----------+
| test     | group_one |        1 |

 

radgroupcheck;
+----+-----------+------------------+----+-----------+
| id | GroupName | Attribute        | op | Value     |
+----+-----------+------------------+----+-----------+
| 29 | group_one | Simultaneous-Use | := | 1         |
| 30 | group_one | Pool-Name        | := | group_one |

radgroupreply;
+----+-----------+-----------------------+----+-------+
| id | GroupName | Attribute             | op | Value |
+----+-----------+-----------------------+----+-------+
|  7 | group_one | Acct-Interim-Interval | =  | 60    |
+----+-----------+-----------------------+----+-------+

openv-vpn-server.conf

reneg-sec 60

 

sql.conf

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

 

simul_verify_query  = "SELECT RadAcctId, AcctSessionId, UserName, \
                               NASIPAddress, NASPortId, FramedIPAddress, \
                               CallingStationId, FramedProtocol \
                               FROM ${acct_table1} \
                               WHERE UserName='%{SQL-User-Name}' \
                               AND AcctStopTime = 0"

radiusd -X  .........

 

rlm_sql (sql): Reserving sql socket id: 0
radius_xlat:  'test'
rlm_sql (sql): sql_set_user escaped user --> 'test'
radius_xlat:  'BEGIN'
radius_xlat:  'test'
rlm_sql (sql): sql_set_user escaped user --> 'test'
radius_xlat:  'UPDATE radippool   SET NASIPAddress = '', pool_key = 0, CallingStationId = '',   expiry_time = NOW() - INTERVAL 1 SECOND   WHERE NASIPAddress = '127.0.0.1'   AND pool_key = '1'   AND UserName = 'test'   AND CallingStationId = '2xx.8x.1xx.252'   AND FramedIPAddress = '1xx.1xx.1xx.93''
radius_xlat:  'test'
rlm_sql (sql): sql_set_user escaped user --> 'test'
radius_xlat:  'COMMIT'
rlm_sql (sql): Released sql socket id: 0
  modcall[accounting]: module "sqlippool" returns ok for request 5
radius_xlat:  'test'
rlm_sql (sql): sql_set_user escaped user --> 'test'
radius_xlat:  '           UPDATE radacct SET              AcctStopTime       = '2010-06-28 15:31:42',              AcctSessionTime    = '61',              AcctInputOctets    = '0' << 32 |                                   '8056',              AcctOutputOctets   = '0' << 32 |                                   '4782',              AcctTerminateCause = '',              AcctStopDelay      = '0',              ConnectInfo_stop   = ''           WHERE AcctSessionId   = '59014A407775C975B63498451AD111B4'           AND UserName          = 'test'           AND NASIPAddress      = '127.0.0.1''
rlm_sql (sql): Reserving sql socket id: 3
rlm_sql (sql): Released sql socket id: 3
  modcall[accounting]: module "sql" returns ok for request 5
modcall: leaving group accounting (returns ok) for request 5
Sending Accounting-Response of id 171 to 127.0.0.1 port 43491
Finished request 5
Going to the next request
Sending Access-Reject of id 24 to 127.0.0.1 port 52948
        Reply-Message := "\r\nYou are already logged in - access denied\r\n\n"
Cleaning up request 5 ID 171 with timestamp 4c2841ce
Waking up in 1 seconds...
--- Walking the entire request list ---
Waking up in 1 seconds...
--- Walking the entire request list ---
Sending Access-Reject of id 24 to 127.0.0.1 port 34414
        Reply-Message := "\r\nYou are already logged in - access denied\r\n\n"
Waking up in 3 seconds...
--- Walking the entire request list ---
Cleaning up request 2 ID 24 with timestamp 4c2841cd
Waking up in 1 seconds...
--- Walking the entire request list ---
Cleaning up request 4 ID 24 with timestamp 4c2841ce
Nothing to do.  Sleeping until we see a request.