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

[sekchel lee]

Dear Ralf Lübben Thank very much

 

mysql.log

 

100628  0:47:46 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100628  0:47:46 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100628  0:47:46  InnoDB: Started; log sequence number 0 43655
100628  0:47:47 [Note] /usr/libexec/mysqld: ready for connections.

Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

 

openv-vpn-server.conf

 

reneg-sec 60   ==> (Used  limit time for user)

 

----

---- duplication user limit

----

session  ==> sql

 

sql.conf  

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

 

test user connect

 

rlm_sql (sql): sql_set_user escaped user --> 'test'
WARNING: Attempt to use unknown xlat function, or non-existent attribute in string %{SQL-Session-Id}
radius_xlat:  'SELECT COUNT(*)                              FROM radacct                              WHERE UserName='test'                              AND AcctStopTime IS NULL                              AND acctsessionid != '''

 

 

1 minute......................

 

renegotiation .......

 

openvpn.log

 

Tue Jun 29 22:57:59 2010 test/2xx.xx.1xx.252:1444 TLS: soft reset sec=0 bytes=15510/0 pkts=130/0
Tue Jun 29 22:57:59 2010 RADIUS-PLUGIN: FOREGROUND THREAD: isAuthenticated()1Tue Jun 29 22:57:59 2010 RADIUS-PLUGIN: FOREGROUND THREAD: isAcct()1Tue Jun 29 22:58:00 2010 RADIUS-PLUGIN: Got no response from radius server.
Tue Jun 29 22:58:00 2010 RADIUS-PLUGIN: FOREGROUND THREAD: Error ar rekeying!
Tue Jun 29 22:58:00 2010 Error: RADIUS-PLUGIN: BACKGROUND  AUTH: Auth failed!.

Tue Jun 29 22:58:00 2010 RADIUS-PLUGIN: FOREGROUND THREAD: Error receiving auth confirmation from background process.
Tue Jun 29 22:58:00 2010 test/2xx.xx.1xx.252:1444 PLUGIN_CALL: POST /etc/openvpn/radiusplugin.so/PLUGIN_AUTH_USER_PASS_VERIFY status=1
Tue Jun 29 22:58:00 2010 test/2xx.xx.1xx.252:1444 PLUGIN_CALL: plugin function PLUGIN_AUTH_USER_PASS_VERIFY failed with status 1: /etc/openvpn/radiusplugin.so
Tue Jun 29 22:58:00 2010 test/2xx.xx.1xx.252:1444 TLS Auth Error: Auth Username/Password verification failed for peer
Tue Jun 29 22:58:00 2010 test/2xx.xx.1xx.252:1444 Control Channel: TLSv1, cipher TLSv1/SSLv3 DHE-RSA-AES256-SHA

 

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"