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 | |
| [EMAIL PROTECTED] | 10.0.0.0 | 1234 | 00001234 | 989651829 |
| | Async | Framed-User |
+-------------------------+---------------+---------+---------------+------------+-----------------+-------------+-------------+
As you can see.. akrall@akrall is already loggied in but when you try
to login twice:
Sat May 12 03:17:09 2001: DEBUG: Rewrote user name to [EMAIL PROTECTED]
Sat May 12 03:17:09 2001: DEBUG: Rewrote user name to [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
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
[EMAIL PROTECTED], 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='[EMAIL PROTECTED]'
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: [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
