Re: SQL Counter for Expiration Attribute - Prepaid Cards

2013-01-01 Thread A . L . M . Buxey
Hi, > Dear List Members, people read this list. you do yourself no favours by repeating the same question all the time. you have been given advice but appear to want someone to do all the work for you. there are companies/consultants that can deliver the product that you need. alan - List info/s

Re: SQL Counter for Expiration Attribute - Prepaid Cards

2013-01-01 Thread Prabhpal S. Mavi
> > > Hi there, > You can use the frontend tool called daloradius, it will sort you out in > what you are trying to achieve, it uses freeradius as the back end. > > -- > On Tue, Jan 1, 2013 12:01 PM MSK Prabhpal S. Mavi wrote: > Dear Mulindwa, Thanks for your respons

Re: SQL Counter for Expiration Attribute - Prepaid Cards

2013-01-01 Thread Mulindwa
rrow so on) >username & password must never work for more than 1 hour to access our >network. i am bit confuse attribute to use, i would grateful if someone >can advice the correct attribute to use for the purpose. > >Thanks > > >Hi Members, > > >after working for

SQL Counter for Expiration Attribute - Prepaid Cards

2013-01-01 Thread Prabhpal S. Mavi
t work. Alan Buxey advised me to implemented "Expiration" Attribute. Expiration works just fine. If i specify any date (01 Sep 2013). But i am working to expire username after certain amount of time, such as one hour (not one hour after first log in) sum of one hour internet used either by one ti

Re: account expiration attribute

2009-09-26 Thread Alan DeKok
Rakotomandimby Mihamina wrote: > 09/25/2009 03:46 PM, Ivan Kalik: >> Why, oh why, do people trawl the internet for outdated and inaccurate > > Ivan, this is just the result of: > http://www.google.com/search?q=radius+expiration+attribute > (the results ranking may di

Re: account expiration attribute

2009-09-26 Thread Ivan Kalik
> I usually tend to make the web search before searching the docs, > at least to see wether: > - the doc exists > - I am alone to have my problem So you buy a washing machine. You don't know which wash is which oprogram. Do you: a) read the user manual that came with it? b) search the Internet i

Re: account expiration attribute

2009-09-26 Thread Rakotomandimby Mihamina
09/25/2009 03:46 PM, Ivan Kalik: Why, oh why, do people trawl the internet for outdated and inaccurate Ivan, this is just the result of: http://www.google.com/search?q=radius+expiration+attribute (the results ranking may differ, we are not near) I usually tend to make the web search before

Re: account expiration attribute

2009-09-25 Thread Ivan Kalik
> 09/24/2009 12:03 PM, Ivan Kalik:: >>> What RADIUS attribute would suit to account expiration? >> >> Expiration. > > I cannot find its documentation (its syntax) doc/rlm_expiration. > A hint: > http://www.open.com.au/pipermail/radiator/2008-July/014935.html Why, oh why, do people trawl the inte

Re: account expiration attribute

2009-09-25 Thread Rakotomandimby Mihamina
09/25/2009 02:59 PM, Rakotomandimby Mihamina:: 09/24/2009 12:03 PM, Ivan Kalik:: What RADIUS attribute would suit to account expiration? Expiration. I cannot find its documentation (its syntax) http://www.portmasters.com/tech/docs/pdf/radius-release20.pdf In RADIUS 1.16, if a user record co

Re: account expiration attribute

2009-09-25 Thread Rakotomandimby Mihamina
09/24/2009 12:03 PM, Ivan Kalik:: What RADIUS attribute would suit to account expiration? Expiration. I cannot find its documentation (its syntax) A hint: http://www.open.com.au/pipermail/radiator/2008-July/014935.html But not more... A help? -- Architecte Informatique chez Blueline/G

Re: account expiration attribute

2009-09-24 Thread Ivan Kalik
> What RADIUS attribute would suit to account expiration? Expiration. Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

account expiration attribute

2009-09-24 Thread Rakotomandimby Mihamina
Hi all, What RADIUS attribute would suit to account expiration? the context: - prepaid users must regularily add credit to his account - big credit -> big validity extension - small credit -> small validity extension - no account removal, just auth reject if validity date passed Credit adding

freeRADIUS Expiration attribute and unix-time stamp

2008-07-27 Thread Jeep Or Die
Hello Everyone. I am new to *nix in general, and so when I ran across unix-time for the first time, I took the time to read up on it. I have created a wifi captured portal system using freeRADIUS, Mysql and Open BlueDragon, but I am having a problem with the Expiration attribute in freeRADIUS

Re: Expiration attribute limitation - max year?

2007-12-18 Thread Alan DeKok
Marinko Tarlac wrote: > Hello I'm working on something and I can figure what is the max year for > expiration attribute? It's a 32-bit Unix timestamp, in seconds since 1970. 2039 *is* the maximum. > Here is the problem > > rlm_sql: Failed to create the pair: fa

Expiration attribute limitation - max year?

2007-12-18 Thread Marinko Tarlac
Hello I'm working on something and I can figure what is the max year for expiration attribute? Here is the problem rlm_sql: Failed to create the pair: failed to parse time string "December 31 2039 00:00:00" When I enter December 31 2035 00:00:00 as a year it works but 2039 doesn&

Re: Expiration attribute

2007-11-23 Thread Marinko Tarlac
Thanks Ivan Best regards Message: 3 Date: Thu, 22 Nov 2007 07:51:41 +0100 From: <[EMAIL PROTECTED]> Subject: Re: Expire attribute To: "FreeRadius users mailing list" Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=ISO-8859-2 Attribute name is Expiration. It is a check

Re: Question regarding the Expiration attribute

2007-10-10 Thread Thibault Le Meur
Terry Pelley a écrit : FreeRADIUS Version 1.1.7 on Novell SLES10 The question is simple but I can't seem to find the answer to it so I will apologize in advance. Can some one tell me the format for entering the date in the Expiration attribute? I'm using the users file to au

Question regarding the Expiration attribute

2007-10-10 Thread Terry Pelley
FreeRADIUS Version 1.1.7 on Novell SLES10 The question is simple but I can't seem to find the answer to it so I will apologize in advance. Can some one tell me the format for entering the date in the Expiration attribute? I'm using the users file to authenticate users on a smal

Re: expiration attribute as an offset?

2007-01-28 Thread liran tal
Very nice, thank you Alan. On 1/28/07, Alan DeKok <[EMAIL PROTECTED]> wrote: liran tal wrote: > > Interesting. > I actually wouldn't want to go into involving scripts Well, then you won't implement a solution, I guess. > but this gets me > curious - what would be the way to > run a script

Re: expiration attribute as an offset?

2007-01-28 Thread Alan DeKok
liran tal wrote: > > Interesting. > I actually wouldn't want to go into involving scripts Well, then you won't implement a solution, I guess. > but this gets me > curious - what would be the way to > run a script on the first login? This is something freeradius related, > isn't it? Uh... ye

Re: expiration attribute as an offset?

2007-01-28 Thread liran tal
> Is it possible to set the expiration attribute to be of an offset type? No. Because something has to remember when the offset started. > Say I set an offset of +30 days, and the user logins for the first time > only 6 months from now. So once he > login'ed once then the co

Re: expiration attribute as an offset?

2007-01-23 Thread Alan DeKok
liran tal wrote: > Is it possible to set the expiration attribute to be of an offset type? No. Because something has to remember when the offset started. > Say I set an offset of +30 days, and the user logins for the first time > only 6 months from now. So once he > login'

expiration attribute as an offset?

2007-01-22 Thread liran tal
Hey guys, Is it possible to set the expiration attribute to be of an offset type? Instead of entering an absolute date is it possible to enter the duration of which the user will be allowed from the first time that he logins? Say I set an offset of +30 days, and the user logins for the first

Expiration attribute

2005-01-28 Thread rashad
What date/time formats allowed for Expiration attribute? Is it possible to use UNIX timestamp format (number of seconds since UNIX epoch) or any date/time format supported by MySQL? For exampe 'January 28 2005 12:00:00' in radcheck table works fine but '2005-01-28 12:00:00' doe

Expiration attribute

2005-01-28 Thread rashad
What date/time formats allowed for Expiration attribute? Is it possible to use UNIX timestamp format (number of seconds since UNIX epoch)? For exampe 'January 28 2005 12:00:00' in radcheck table works fine but '2005-01-28 12:00:00' doesn't. mysq

Re: expiration attribute

2004-04-21 Thread Santiago Balaguer García
It is easy for with my method. I suposse that you have RADIUS counts with a specific login, if you want that a count expires in 30 days after its activation, you only have to get the activation date (you know with NOW() in mysql) and add to this date 30 in MySQL sentences. This calculated date

Re: expiration attribute

2004-04-20 Thread Alan DeKok
"Milver S. Nisay" <[EMAIL PROTECTED]> wrote: > The next challenge for a prepaid dialup would be , is there a possibility > that an > account's expiration would be modified, using MsSQL queries inside > sqlcounter.conf, on the first successful authentication I would suggest running an external pr

Re: expiration attribute

2004-04-20 Thread Milver S. Nisay
Thanks Alan. My expiration attribute is now working To add more details, the OP field must be set to "==" and not ":=" and it worked smoothly. The next challenge for a prepaid dialup would be , is there a possibility that an account's expiration would be modified, u

Re: expiration attribute

2004-04-20 Thread Alan DeKok
"Milver S. Nisay" <[EMAIL PROTECTED]> wrote: > i have inserted expiration attribute with radcheck table, with a PAP account > as shown below > | 243 | milver | Expiration | := | 20040419153024 | That isn't a date. It's simply a long

expiration attribute

2004-04-20 Thread Milver S. Nisay
i am trying to make expiration attribute works. my freeradius 0.9.1 + MySQL 3.23. did some search with the mailing list, and could not lead to a solution. i have inserted expiration attribute with radcheck table, with a PAP account as shown below

Re: expiration attribute

2004-04-20 Thread Julius Igugu
Hi,   The expiration attribute is the account expiration date.  The account will be disabled on that date."Milver S. Nisay" <[EMAIL PROTECTED]> wrote: can anyone elaborate more of the "Expiration" attribute?is it an attribute of password age or expiration for password?i a

expiration attribute

2004-04-19 Thread Milver S. Nisay
can anyone elaborate more of the "Expiration" attribute? is it an attribute of password age or expiration for password? i am am trying to play around for an expiration attribute -- expiration for an account from MySQL table and not from system accounts, using freeradius under FC1. anyone