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

[Ralf Lübben]

Hi,

please use

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


A detailed description is given in this thread

http://lists.nongnu.org/archive/html/radiusplugin-users/2010-05/msg00000.html

Regards
Ralf
 


Am Donnerstag, 24. Juni 2010, um 19:15:29 schrieb sekchel lee:
> Hello
> Dear all
> 
> "duplication User connected"  strange errors
> 
> radiusd.conf
> session sql  enable
> 
> sql.conf
> simul_count_query = "SELECT COUNT(*) \
>                              FROM ${acct_table1} \
>                             WHERE UserName='%{SQL-User-Name}' \
>                             AND AcctStopTime IS NULL"
> 
> AND AcctStopTime = 0"
> ==>   Every 1 hour Disconnected
> ==>   (Reply-Message := "\r\nYou are already logged in - access
> denied\r\n\n")
> AND AcctStopTime IS NULL"
> ==>  duplication User connected
> 
> What do i do
> Please Help me