(RADIATOR) Duplicate Logins

[Anton Krall]

Guys.

Im trying to implement a no duplicate logins policy but so far no
luck. Here is my setup:

<Realm akrall.inter.net>
        RewriteUsername         s/^(.*)\@mcm.inter.net$/$1\@mx.inter.net/
        RewriteUsername s/^([^@]+).*/$1/
        AuthByPolicy ContinueUntilAccept
        <AuthBy SQL> 
        DefaultSimultaneousUse 1
                DBSource dbi:mysql:menu_mx:sql
                DBUsername radius
                DBAuth RaDiUs
                AuthSelect
                AuthColumnDef 0, Encrypted-Password, check

As you can see.. I have DefaultSimultaneousUse 1 set up.

now...

mysql> select * from RADONLINE where username like "akrall%";
+-------------------------+---------------+---------+---------------+------------+-----------------+-------------+-------------+
| USERNAME                | NASIDENTIFIER | NASPORT | ACCTSESSIONID | TIME_STAMP | FRAMEDIPADDRESS | NASPORTTYPE | SERVICETYPE |
+-------------------------+---------------+---------+---------------+------------+-----------------+-------------+-------------+
| akrall                  | 154.17.32.21  |    2189 | 331403079     |  989642092 | 200.53.13.161   | Async       |             |
| akrall at akrall.inter.net | 10.0.0.0      |    1234 | 00001234      |  989651829 |                 | Async       | Framed-User |
+-------------------------+---------------+---------+---------------+------------+-----------------+-------------+-------------+

As you can see.. akrall at akrall is already loggied in but when you try
to login twice:


Sat May 12 03:17:09 2001: DEBUG: Rewrote user name to akrall at akrall.inter.net
Sat May 12 03:17:09 2001: DEBUG: Rewrote user name to akrall at akrall.inter.net
Sat May 12 03:17:09 2001: DEBUG: Handling request with Handler 'Realm=akrall.inter.net'
Sat May 12 03:17:09 2001: DEBUG: Rewrote user name to akrall at akrall.inter.net
Sat May 12 03:17:09 2001: DEBUG: Rewrote user name to akrall
Sat May 12 03:17:09 2001: DEBUG: SDBSQLdialup Deleting session for akrall at akrall.inter.net, 10.0.0.0, 1234
Sat May 12 03:17:09 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='10.0.0.0' and NASPORT=01234

Sat May 12 03:17:09 2001: DEBUG: Handling with Radius::AuthSQL
Sat May 12 03:17:09 2001: DEBUG: Handling with Radius::AuthDBFILE
Sat May 12 03:17:09 2001: DEBUG: Radius::AuthDBFILE looks for match with akrall
Sat May 12 03:17:09 2001: DEBUG: Query is: select NASIDENTIFIER, NASPORT, ACCTSESSIONID, FRAMEDIPADDRESS from RADONLINE where USERNAME='akrall at akrall.inter.net'

Sat May 12 03:17:09 2001: DEBUG: Radius::AuthDBFILE ACCEPT: 
Sat May 12 03:17:09 2001: DEBUG: Access accepted for akrall
Sat May 12 03:17:09 2001: DEBUG: Packet dump:

Why does it first do a Delete Session and then a select on radonline?

The problem is that the second log is getting thru :(

Any ideas?

Thx

Saludos

Anton Krall
Director de Tecnologia
Inter.net Mexico
(www.mx.inter.net)
Email: akrall at team.inter.net
Directo: 5-241-7609
Conmutador: 5-241-7600
Mobile: 044-5105-5160

Outside Mexico:
Office: (525)241-7609
PBX: (525)241-7600
Mobile: (525)105-5160


===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.