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

[Ralf Lübben]

Hi,

the SQL statements looks o.k. .

Can you check the commands which are sent to the SQL server (mysql.log) and 
maybe post them. 

Ralf


Am Montag, 28. Juni 2010, um 09:06:52 schrieb 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.