Re: (RADIATOR) question
Hi Chris, My advice for different time zone u should be using a stored procedure to process the accounting event. The person might be said surfing 11pm and end @2am. u will be charging 11-12am and the rest free. We have implementing the rating using the stored procedure and it allows flexibility as well. Hope it help. Mike McCauley [EMAIL PROTECTED] 18/07/2003 03:57 PM Sent by: [EMAIL PROTECTED] To: Chris [EMAIL PROTECTED], [EMAIL PROTECTED] cc: (bcc: QUEK Steven/Prod Dev Dir/STSunPage/ST Group) Subject: Re: (RADIATOR) question Hello Chris, On Fri, 18 Jul 2003 12:05 pm, Chris wrote: Hello list, I'm using radmin + radiator, Right now I want to do these to my system, please point me out to some examples or possible solutions: 1. How do I make first time users to base their starting usage from the moment they first logged into the system? You could use an AcctSQLStatement that sets thir expiry date if it is currently NULL. The the first successful session start will set their expiry date to, say the current date + 30 days (or whatever your policy is). 2. I want to implement an off peak time wherein when users login from 12am to 7am that their usage won't be deducted during those specified time. You could set up multiple Handlers, each with a different Time check items: # off peak Handler Time=Al-0700 AuthBy RADMIN # no AccountingTable or AcctColumnDef entries here # means no accounting data inserted /AuthBy /Handler # all the rest Handler AuthBy RADMIN /AuthBy /Handler The AuthBy RADMIN clauses would be thanks, chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.501 / Virus Database: 299 - Release Date: 7/14/2003 -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, TTLS, PEAP etc on Unix, Windows, MacOS etc. === 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. [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] === 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) Stored procedures
Hi,
I suggest that u should not use the paremeters instead they are expecting a
recordset.
Hope it help.
Tim Ballingall [EMAIL PROTECTED] 04/04/2003 08:41 AM
Sent by: [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
cc: (bcc: QUEK Steven/Prod Dev Dir/STSunPage/ST Group)
Subject: (RADIATOR) Stored procedures
Hello all,
Can I start by saying how happy I was to come across such a flexible
powerful product. Easily the most configurable Radius server I've ever
seen..:)
And on that note I'm actually evaluating Radiator at the moment. If I
can get it to do as I want I'll be a certain buyer. What I need to do is to
get Radiator running on an 2K Server machine, connecting to a remote Tru64
Unix server running Oracle 8.0.5.1, and using a stored oracle procedure to
authenticate. Sqlnet is installed operating correctly on the 2K server.
My stored procedure looks like :
procedure check_password
(db_user in varchar2,
db_password in varchar2,
db_valid_password out number)
After passing three parameters, it will return a value in
db_valid_password. If that value is 1 then the username password match, any
other value indicates a wrong combination.
Now I'm trying to get this to work using the sample plsql.cfg
authplsql.pm but it's giving me a little grief... My config file looks like
:
snip
NoDefault
DBSource dbi:Oracle:MYMACHINE
DBUsername MYUSERNAME
DBAuth MYPASSWORD
# Authentication
AuthBlock BEGIN \
security_pkg.check_password
('%n','%P',\
:reply_item); \
END;
AuthParamDef:reply_item,GENERIC,reply
My trace debug looks like :
Fri Apr 4 10:06:31 2003: DEBUG: Query is: BEGIN
security_pkg.check_password('SOMEUSER','SOMEPASSWORD',:reply_item); END;
Fri Apr 4 10:06:31 2003: ERR: Bad attribute=value pair: 1
Fri Apr 4 10:06:31 2003: DEBUG: Radius::AuthPLSQL looks for match with
SOMEUSER
Fri Apr 4 10:06:31 2003: DEBUG: Radius::AuthPLSQL ACCEPT:
Fri Apr 4 10:06:31 2003: DEBUG: Access accepted for SOMEUSER
The trouble here is that SOMEPASSWORD is actually incorrect, but the user
is being authenticated anyway. I think I'm implementing AuthPLSQL
incorrectly but not entirely sure. Do I need to define the behavior of
check_password to Radiator...? If so, I'd appreciate some help on where I
would do this.
Any advice on this would be most welcome...
Thanks kindly in advance
Tim
**
Mazda Australia takes many precautions to ensure emails are virus free.
For extra protection you should virus scan this message yourself.
**
[This e-mail is confidential and may also be privileged. If you are not the
intended recipient, please delete it and notify us immediately; you should
not copy or use it for any purpose, nor disclose its contents to any other
person. Thank you.]
===
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) WiFi - Business
Hi All, We are looking to provide Hotspot business but based on the current hotspot model arounds we find no business case. I will appriecate someone could share he/her opinions. Best Regards [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] === 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) 100% processor load outside the time service window
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] To: [EMAIL PROTECTED] cc: (bcc: QUEK Steven/Mgr - IDD Network/STSunPage/ST Group) Subject: (RADIATOR) 100% processor load outside the time service window 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 clue/help appreciated ? Wed Jan 15 16:42:20 2003: DEBUG: Query is: select CLID,ctime,dtimeout,portlimit from whitelist where DNIS=12345 and CLID=1234 Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL looks for match with DEFAULT410 Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an all owable Time range Wed Jan 15 16:42:20 2003: DEBUG: Query is: select CLID,ctime,dtimeout,portlimit from whitelist where DNIS=12345 and CLID=1234 Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL looks for match with DEFAULT411 Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an all owable Time range Wed Jan 15 16:42:20 2003: DEBUG: Query is: select CLID,ctime,dtimeout,portlimit from whitelist where DNIS=12345 and CLID=1234 Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL looks for match with DEFAULT412 Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an all Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with DEFAULT247 3 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an all owable Time range Wed Jan 15 16:38:50 2003: DEBUG: Query is: select CLID,ctime,dtimeout,portlimit from whitelist where DNIS=12345 and CLID=1234 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with DEFAULT247 4 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an all owable Time range Wed Jan 15 16:38:50 2003: DEBUG: Query is: select CLID,ctime,dtimeout,portlimit from whitelist where DNIS=12345 and CLID=1234 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with DEFAULT247 5 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an all owable Time range Wed Jan 15 16:38:50 2003: DEBUG: Query is: select CLID,ctime,dtimeout,portlimit from whitelist where DNIS=12345 and CLID=1234 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with DEFAULT247 6 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an all owable Time range Wed Jan 15 16:38:50 2003: DEBUG: Query is: select CLID,ctime,dtimeout,portlimit from whitelist where DNIS=12345 and CLID=1234 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with DEFAULT247 7 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an all owable Time range Wed Jan 15 16:38:50 2003: DEBUG: Query is: select CLID,ctime,dtimeout,portlimit from whitelist where DNIS=12345 and CLID=1234 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with DEFAULT247 8 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an all owable Time range Wed Jan 15 16:38:50 2003: DEBUG: Query is: select CLID,ctime,dtimeout,portlimit from whitelist where DNIS=12345 and CLID=1234 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with DEFAULT247 9 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an all owable Time range Wed Jan 15 16:38:50 2003: DEBUG: Query is: select CLID,ctime,dtimeout,portlimit from whitelist where DNIS=12345 and CLID=1234 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with DEFAULT248 0 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an all owable Time range Wed Jan 15 16:38:50 2003: DEBUG: Query is: select CLID,ctime,dtimeout,portlimit from whitelist where DNIS=12345 and CLID=1234 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with DEFAULT248 1 Kind Regards Marius Stefan
(RADIATOR) WildCard Handler Definition
Hi, I have a list of NAS having the Name as 123_Loc1 123_LocUS 123_LocCHINA 123_LocTHAILAND to use the below handler, How to I define the Handler Definition below Handler NAS-Identifier=123_*, Acct-Status-Type = /Start/, Realm=/icc/ix RewriteUsername s/^([^@]+).*/$1/ AuthBy AP_ICC_AccountingStarts /Handler [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] === 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) A radius enabled HTTP port/redirector
Hi, Is the prototype available. I currently got a supplier that like to do some SMS gaming and connecting to our backend system for billing purpose. He is proposing using HTTP which currently widely use by many ISP . Can i trial on these ? Best Regards [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] === 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) Realm - Cases
How to accept different cases for the Realm: Eg: 1234@ICC, 1234@IcC and also sometime the user include space behind Best Regards [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] === 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) NAS - Reboot
How can i run certain SQL command whenever the NAS reboot. I have an wireless AP send message when its reboot and i need to logout all the user and created all the necessary CDR ? [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] === 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) Re: NAS - Reboot
Thanks. BTW how can i run multi-copy of Radiator in the same machine. Hugh Irvine [EMAIL PROTECTED] 20/11/2002 09:58 AM Sent by: [EMAIL PROTECTED] To: QUEK Steven/Mgr - IDD Network/STSunPage/ST Group@ST Domain cc: [EMAIL PROTECTED] Subject: (RADIATOR) Re: NAS - Reboot Hello Steven - You should use Handers and an AuthBy SQL clause: Handler Acct-Status-Type = Accounting-On AuthBy SQL . AcctSQLStatement .. /AuthBy /Handler . regards Hugh On Wednesday, Nov 20, 2002, at 12:11 Australia/Melbourne, [EMAIL PROTECTED] wrote: How can i run certain SQL command whenever the NAS reboot. I have an wireless AP send message when its reboot and i need to logout all the user and created all the necessary CDR ? [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] -- 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. [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] === 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) Auth using MD5
I got an 3Com client that use the abovementioned. I only see the User ID but the password is BLANK. Am right to use the %P ? [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] === 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) Radiator - Shiva Landrover
Hi, 1.In the shiva, its successfully auth but its keep saying the user does not have the dialin right ? - What should i configure the attribute 2.In the AuthSelect, what happen if the stored procedure return two result set, how to specify what is the result to readin ? [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] === 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.
