(RADIATOR) First Login handling

[Hugh Irvine]

Hello Hisham -

If your database supports stored procedures and/or triggers you could  
do this processing directly in the database.

Otherwise you can add an AcctSQLStatement to set the expiry date and  
change the flag if it is 0.

See section 5.29.16 in the Radiator 3.15 reference manual.

hope that helps

regards

Hugh


On 1 Nov 2006, at 20:34, Hisham Al-Shiha wrote:

>
> Dear all,
>
> 	I would like to express my regards to every one in this fantastic
> group.
> 	
> 	We are planning to launch a prepaid ADSL card accounts. All accounts
> are by default inactive (flag 0 in the db). So when the user tries to
> connect the first time I want to run a Perl script in a hook that  
> changes
> the flag to active and calculates the expiration date (i.e. automatic
> activation)
>
> 	I searched the mailing list archive for a similar case but I didn't
> find such one. I know that the hook is "PostAuthHook". But my  
> problem is my
> weakness in Perl programming. I'm not sure how to make a such  
> script. If you
> think there is another way and simpler one please guide me to it.
>
> 	Radiator version: 3.11
> 	DB: MySQL
>
> Regards,
> 	
> Hisham A. Al-Shiha
> Tel +(9661) 4623623 Ext. 342
> Fax +(9661) 4625348
> P.O.Box 14466 Riyadh 11424 Saudi Arabia
> MeduNet
>
>
> --
> 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.



NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/ 
radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.


--
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.