SQL Counter for Expiration Attribute - Prepaid Cards

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 time login or multiple logins (30Min morning 30min

Re: SQL Counter for Expiration Attribute - Prepaid Cards

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 four days still unable to make it work. Alan Buxey advised me to implemented Expiration Attribute. Expiration works just fine. If i

Re: SQL Counter for Expiration Attribute - Prepaid Cards

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 response. I am

Re: SQL Counter for Expiration Attribute - Prepaid Cards

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

Re: account expiration attribute

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

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 in

Re: account expiration attribute

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 differ, we are not near) That's nice

Re: account expiration attribute

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

Re: account expiration attribute

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

Re: account expiration attribute

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 internet for

account expiration attribute

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

Re: account expiration attribute

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

freeRADIUS Expiration attribute and unix-time stamp

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

Expiration attribute limitation - max year?

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't. Is there any

Re: Expiration attribute limitation - max year?

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: failed to parse time string December

Re: Expiration attribute

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 freeradius-users@lists.freeradius.org Message-ID: [EMAIL PROTECTED] Content-Type: text/plain; charset=ISO-8859-2 Attribute

Question regarding the Expiration attribute

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 small wireless

Re: Question regarding the Expiration attribute

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 authenticate

Re: expiration attribute as an offset?

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 counter will start counting 30 days from his

Re: expiration attribute as an offset?

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

Re: expiration attribute as an offset?

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 on the

Re: expiration attribute as an offset?

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'ed once then the counter

expiration attribute as an offset?

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

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. mysql select * from radcheck

Expiration attribute

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' doesn't. mysql select

Re: expiration attribute

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

Hi, The expiration attribute is the account expiration date. The accountwill 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 am am t

expiration attribute

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

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 number. but if i manipulate the expiration

Re: expiration attribute

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, using MsSQL queries inside

Re: expiration attribute

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 program

expiration attribute

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? //milver