(RADIATOR) Request for Feature

2003-01-15 Thread Vangelis Kyriakakis
Hello, Sometimes it is very helpful to disable NAS queries while checking for Simultaneus-Use on some Handlers. Now we can only prevent NAS queries on a client basis using NasType. Is a Handler or AuthBy based flag, that would enable-disable the queries, possible? Regards

(RADIATOR) Session database with mysql

2003-01-15 Thread tdn
Hello, Am trying to implement a session database using a mysql database. My problem is that i notice that there are so many cases when people have actually logged out, but not deleted from the database. (see my database structure and part of my cfg file) create table radonline (

(RADIATOR) 100% processor load outside the time service window

2003-01-15 Thread MStefan
I was trying to implement the Time and Simultaneous-use check/reply items but the radiator is getting nervous Inside the service window We08:00-16:00 everything goes perfect but outside the server gets stuck(100% load and blocked) I am running a test on my computer with NT and Access ODBC Any

(RADIATOR) logging IPASS accounting records to Database

2003-01-15 Thread Ayotunde Itayemi
Hi Hugh, Hi All, I would like to log only IPASS accounting start and stop request to a database tableso as to get some sort of record locally - how can I implement this? I want something a little bit "simpler" than the long detail file generated by the AcctLogFileName clause (see below

(RADIATOR) More than one DNS server via Address Allocator SQL

2003-01-15 Thread Cortney Thompson
Is there a way to assign two DNS servers using Address Allocator SQL? Something like DNSSERVER-PRI = X.X.X.X. DNSSERVER-SEC= Y.Y.Y.Y. Instead of DNSSERVER = Z.Z.Z.Z Thanks Cortney Cortney Thompson [EMAIL PROTECTED] Opinions are mine and do not necessarily reflect those

(RADIATOR) CallerID logging in AuthLog SQL

2003-01-15 Thread gordons
Hi all, I have a problem - I want to include Calling-Station-ID in my AuthLog table. Unfortunately, I can't find the correct attribute to include in the SQL statement to do so. I have the standard: FailureQuery insert into RADAUTHLOG (TIME_STAMP, USERNAME, REASON) values (%t, '%n', 0, %1)

Re: (RADIATOR) CallerID logging in AuthLog SQL

2003-01-15 Thread Hugh Irvine
Hello Gordon - You will need to modify your RADAUTHLOG table first to include the column, then do something like this: FailureQuery insert into RADAUTHLOG (TIME_STAMP, USERNAME, REASON, CALLINGSTATIONID) values (%t, '%n', 0, %1, %{Calling-Station-Id}) You will find the list of attributes in

(RADIATOR) Dual Accounting Streams Possible?

2003-01-15 Thread Cliff Daniel
I'm looking for a way to configure radiator to send a duplicate stream to another radius host, just for logging purposes only. Is there any easy way to accomplish this? I've search the archives for this list and only saw one thing similar but that was for Auth and I didn't quite understand

Re: (RADIATOR) More than one DNS server via Address Allocator SQL

2003-01-15 Thread Hugh Irvine
Hello Cortney - This is currently not supported directly, but you could write a hook to do it fairly easily. Note that the radius protocol does not have a standard way to do this in any case. There are some example hooks in the file goodies/hooks.txt in the distribution. regards Hugh On

Re: (RADIATOR) 100% processor load outside the time service window

2003-01-15 Thread queksteven
Hi, U should included the NODEFAULTs clauses. Radiator will attempt to incremental the user ID when the query failed till u Reboot the PC. [EMAIL PROTECTED] 15/01/2003 11:48 PM Sent by: [EMAIL PROTECTED]

Re: (RADIATOR) logging IPASS accounting records to Database

2003-01-15 Thread Hugh Irvine
Hello Tunde - You just need to add an AuthBy SQL clause to your configuration file, something like this: Client localhost     # ipass client for VNAS (incoming metrong roamers)     Secret     Identifier ipassclient     IdenticalClients 63.10.10.212     RewriteUsername

Re: (RADIATOR) Dual Accounting Streams Possible?

2003-01-15 Thread Hugh Irvine
Hello Cliff - Yes this is quite simple to do (I assume you want a copy of the accounting only?). Something like this: # define AuthBy clauses AuthBy RADIUS ForwardAccountingOnly Host ... Secret IgnoreAuthentication . /AuthBy AuthBy RADIUS ForwardToProxy Host ... Secret

Re: (RADIATOR) 100% processor load outside the time service window

2003-01-15 Thread Hugh Irvine
Hello Marius - You should add a NoDefault parameter to your AuthBy SQL clause: AuthBy SQL . NoDefault . /AuthBy regards Hugh On Thursday, Jan 16, 2003, at 02:48 Australia/Melbourne, [EMAIL PROTECTED] wrote: I was trying to implement the Time and Simultaneous-use

Re: (RADIATOR) Session database with mysql

2003-01-15 Thread Hugh Irvine
Hello - The usual reason for stale records being left in the session database is missing stop records. In other words, if you do not receive a stop record when a user session completes, then you will not delete that users record from the session database. It is also possible that the delete

Re: (RADIATOR) Request for Feature

2003-01-15 Thread Hugh Irvine
Hello Vangelis - I can't think of an easy way to do this, but I have copied Mike on this mail for his comments. regards Hugh On Wednesday, Jan 15, 2003, at 21:01 Australia/Melbourne, Vangelis Kyriakakis wrote: Hello, Sometimes it is very helpful to disable NAS queries while checking

(RADIATOR) Time check item

2003-01-15 Thread Anton Krall
Guys.. I trying to make 2 AuthBy SQL.. one is a standard one and the other is for a dialup plan called Nightly The 2nd one has to have a check item: Time = Wk-0800 Thing is... where do I put the check item? I forgot : Thx for the help.

Re: (RADIATOR) Time check item

2003-01-15 Thread Hugh Irvine
Hello Anton - A check item usually goes in a user record. Ie: someuser Password = xxx, Time = Wk-0800 .. There are other possibilities depending on what else you are doing in your configuration file. regards Hugh On Thursday, Jan 16, 2003, at 16:19 Australia/Melbourne,

RE: (RADIATOR) 100% processor load outside the time service window

2003-01-15 Thread MStefan
Thanks guys.It has solved the problem for Time+Session-Timeout but also for Simultaneous-Use(port Limit) Perfect -Original Message- From: Hugh Irvine [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 2:48 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: (RADIATOR)

RE: (RADIATOR) Time check item

2003-01-15 Thread Anton Krall
If I needed to hard code the check into the authby so that the user record (SQL) would only have username and pw? __ Anton Krall CEO %-Original Message- %From: [EMAIL PROTECTED] %[mailto:[EMAIL PROTECTED]] On Behalf Of

Re: (RADIATOR) Time check item

2003-01-15 Thread Hugh Irvine
Hello Anton - As mentioned previously, the answer depends on what else you are doing in your configuration file and how you are going to recognise and process the radius requests. You can use Handlers or cascaded AuthBy clauses, it depends on what else is required. Please outline your

RE: (RADIATOR) Dual Accounting Streams Possible?

2003-01-15 Thread david.kramar
Hi Cliff FYI, maybe your RAS support AAA Broadcast Accounting like Cisco. http://www.cisco.com/en/US/products/sw/iosswrel/ps1834/products_feature_guide09186a008007fe4a.html David -Pvodn zprva- Od: Cliff Daniel [mailto:[EMAIL PROTECTED]] Odeslno: 16. ledna 2003 1:59 Komu: [EMAIL