Re[2]: (RADIATOR) Duplicate Logins
Will check the archives for this topic. Thx a lot guys and I must say.. support here is quick :) Keep up the good work. 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 __ Saturday, May 12, 2001, 3:32:51 AM, you wrote: HI Hello Anton - HI The reason Radiator does a delete when it receives an access request is HI because an accounting stop may have gone missing. Note that the delete is HI done on the NAS and NAS=Port combination reported in the request, because by HI definition there cannot already be a session there. HI Notice that your second request is the same as the first, so the first record HI is deleted, hence the second request is accepted. If you want to test HI simultaneous use you will have to use different values in your requests. HI This topic has been discussed *many* times, so don't forget to check the HI mailing list archive at www.starport.net/~radiator and do a search. HI regards HI Hugh HI On Saturday 12 May 2001 18:24, Anton Krall wrote: 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 | 1234 | | 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. === 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.
Re: (RADIATOR) Timestamp Formatting
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hugh, Thanks for the tip. I guess I could keep it as the epoch. Really, I just want to have a time format that can be understood by my operators. I will probably just use perl or php to convert the timestamp after it has been selected from the database. Also, this is the format I insert the timestamp into the database in all the other tables. Consistency and all. Shon Stephens [EMAIL PROTECTED] - - Original Message - From: Hugh Irvine [EMAIL PROTECTED] To: Shon Stephens [EMAIL PROTECTED]; Radiator Mailing List [EMAIL PROTECTED] Sent: Friday, May 11, 2001 7:33 PM Subject: Re: (RADIATOR) Timestamp Formatting Hello Shon - The Timestamp used inside Radiator is a numeric value representing the number of seconds since the UNIX epoch (midnight January 1, 1970) and is used for calculations that expect this to be the case. You can add an additional field to the RADPOOL table if you wish and provide your own queries which will write a formatted string in addition to the standard Radiator fields. Just out of interest, why do you want to do this? regards Hugh On Saturday 12 May 2001 02:52, Shon Stephens wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am planning on using AddressAllocator SQL. In the RADPOOL table there is a TIME_STAMP field. Is this the time that the address was allocated? Can I use DateFormat to format this? If so how? If not, what can I do? Thanks, Shon Stephens [EMAIL PROTECTED] P.S. My PGP Public Key is available from either ldap://europe.keys.pgp.com or http://pgpkeys.mit.edu . You can download it and sign it if you like. -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use http://www.pgp.com iQA/AwUBOvwYwUwGLkuD4lDdEQKc0ACg8jAv9KjhxF6c4o0F3y9lh9h5XkcAoK+Z Bnx0wP9aTid4nkK35PnscdZV =3eWc -END PGP SIGNATURE- === 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. -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence. === 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. -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use http://www.pgp.com iQA/AwUBOv0lbUwGLkuD4lDdEQJxKgCeMWbvBPquL3c5GV2f9qP04/SVsdEAoI5k xuIucXQxPDh7c6pEPwXJDvJh =yg67 -END PGP SIGNATURE- === 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.
Re[3]: (RADIATOR) Duplicate Logins
Guys Ive checked all about duplicate logins in the archives and I must say Im confused. Ive seen mails saying that you have to code... others saying is not working... And some more saying that if you login as [EMAIL PROTECTED] and then [EMAIL PROTECTED] the user WILL get in when in fact its the same user. But my questions is. Will it do the trick if I just put DefaultSimultaneousUse 1 in every AuthBy? or whats the trick with it.. Ive been able to enable the time checks, and the reject:resaon check and some responses... but the Sim User.. no luck so far :( Any ideas? Thx Anton Krall AK Will check the archives for this topic. AK Thx a lot guys and I must say.. support here is quick :) AK Keep up the good work. AK Saludos AK Anton Krall AK Director de Tecnologia AK Inter.net Mexico AK (www.mx.inter.net) AK Email: [EMAIL PROTECTED] AK Directo: 5-241-7609 AK Conmutador: 5-241-7600 AK Mobile: 044-5105-5160 AK Outside Mexico: AK Office: (525)241-7609 AK PBX: (525)241-7600 AK Mobile: (525)105-5160 AK __ AK Saturday, May 12, 2001, 3:32:51 AM, you wrote: HI Hello Anton - HI The reason Radiator does a delete when it receives an access request is HI because an accounting stop may have gone missing. Note that the delete is HI done on the NAS and NAS=Port combination reported in the request, because by HI definition there cannot already be a session there. HI Notice that your second request is the same as the first, so the first record HI is deleted, hence the second request is accepted. If you want to test HI simultaneous use you will have to use different values in your requests. HI This topic has been discussed *many* times, so don't forget to check the HI mailing list archive at www.starport.net/~radiator and do a search. HI regards HI Hugh HI On Saturday 12 May 2001 18:24, Anton Krall wrote: 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 | 1234 | | 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