Re: How to control users traffic ?

2009-07-11 Thread Mark Elkins
On Sat, 2009-07-11 at 12:29 +0430, Eric wrote: The NAS server is poptop vpn server. It seems that pppd can support Session-Octets-Limit. How can freeradius send Session-Octets-Limit instead of Session-Timeout in auth-reply? On Tue, Jul 7, 2009 at 12:23 PM, Eric bbah...@gmail.com wrote:

Re: Not real account stop records ,

2008-09-29 Thread Mark Elkins
On Mon, 2008-09-29 at 05:49 +0200, AHMED KHIDR wrote: Hi All Any one have an Idea about this problem , I changed the account priodic update in my NASes to be 25 Min , and all works good except when a session starts , I found in Acc Start time : 2008-09-28 03:58:56 and Acc

Re: Class attribute in accounting record.

2007-10-29 Thread Mark Elkins
On Mon, 2007-10-29 at 16:45 +0200, Mark J Elkins wrote: My access provider is setting and sending me the Class attribute in an accounting record... I use MySQL to store such info in... and I'm using freeradius 1.1.6 Wisdom prevails.. (touching the dictionaries is probably a bad* thing to

Duplicate AccSessionId + AcctUniqueId from NAS (which I don't want)

2006-02-09 Thread Mark Elkins
I've got a problem where sometimes I'm getting duplicate accounting records entered into my Accounts file. The customer is on an ADSL line and the NAS is owned by the local monopoly operator. We need accurate traffic counts for each user - as thats what they are billed on. The Telco has sent

Re: SUSPENSION OF ACCOUNT

2005-10-26 Thread Mark Elkins
On Tue, 2005-10-25 at 09:47 +0100, maruna wrote: I use FreeRadius v 1.0.5 with postgresql 7.3.4 on redhat Linux ES3 and its been working well. However, I want to create accounts where these accounts will be suspended after let say a month and this suspension continue until the account is

Need to conditionally update user data in authentication process (mysql) - Clues?

2005-09-09 Thread Mark Elkins
Hi I need to conditionally update some user data whilst in the authentication process - I'm looking for clues as how to do this. Background: I'm providing vouchers with a username and password on them. The first time the voucher details are used - I need to update that users details (change

Re: How to solve alive user who actually has loged off

2005-06-20 Thread Mark Elkins
On Mon, 2005-06-20 at 18:54 +0800, ??? wrote: Hello everybody, I am using freeradius-1.0.4. In my situation, user testuser from domain domain logged from NAS 192.168.1.68, After a while,user testuser logged out,but the NAS did not send Accout-Stop packet(for some reason) and

Multiple logins Freeradius/Mysql

2005-06-13 Thread Mark Elkins
We've set up Simultaneous-Use := 1 - and this seems fine. However, I have my first user - who is really off the net and 'radzap' seems to do nothing (radwho still gives the user as being there). What is the code... in sql.conf... simul_count_query = SELECT COUNT(*) FROM ${acct_table1} WHERE

sql _alt query - when?

2005-03-10 Thread Mark Elkins
I'm happily running FreeRadius with SQL for storing users - etc... In the accounting sections - there are entries for :- accounting_update_query -and- accounting_update_query_alt Under what conditions does Radius run the '_alt' version of the SQL query?? (Where is it

Post-Auth-Typeq REJECT and sql

2005-03-10 Thread Mark Elkins
I'm sure Kostas Kalevras pointed me to a file - which included the section -- In the following example, 2 different sql modules are used to store accepted requests and rejected requests. post-auth { my_sql_accept Post-Auth-Type REJECT {

Re: Secondary SQL accounting instance needed

2005-03-04 Thread Mark Elkins
On Wed, 2005-03-02 at 13:19 +0200, Mark Elkins wrote: I want to collect the current allocate IP address and username into a separate MySql table - if it (the user (=key)) exists - update the IP, if the user does not exist, add user and IP. I (think that I) understand that I need to have

Re: Secondary SQL accounting instance needed

2005-03-04 Thread Mark Elkins
On Fri, 2005-03-04 at 16:56 +0200, Mark Elkins wrote: On Wed, 2005-03-02 at 13:19 +0200, Mark Elkins wrote: I want to collect the current allocate IP address and username into a separate MySql table - if it (the user (=key)) exists - update the IP, if the user does not exist, add user

Secondary SQL accounting instance needed

2005-03-02 Thread Mark Elkins
Before I go forth and break my radius and have a few thousand people looking for me I want to collect the current allocate IP address and username into a separate MySql table - if it (the user (=key)) exists - update the IP, if the user does not exist, add user and IP. I (think that I)

Want to add details to MySQL

2005-03-02 Thread Mark Elkins
I want to put the contents of radius.log into a MySQL Database - in **real time**. ie - lines that read something like... Fri Feb 25 18:50:37 2005 : Auth: Login OK: [EMAIL PROTECTED] (from client adsl1 port 123456789) How do I do this? This is so various support type people can see when

RE: NAS from db - add without restart

2005-01-26 Thread Mark Elkins
On Fri, 2005-01-21 at 08:00 +, Neil Craig wrote: Could use cron to HUP server every so often [EMAIL PROTECTED] 21/01/2005 00:05:09 Just floating an idea... Is it worth considering adding a periodic section to radiusd.conf and the radius server? Rather than retrofitting reload this,

Re: NAS from db - add without restart

2005-01-20 Thread Mark Elkins
On Wed, 2005-01-19 at 23:05 +0200, Kostas Kalevras wrote: On Wed, 19 Jan 2005, Alan DeKok wrote: Neil Craig [EMAIL PROTECTED] wrote: Is it possible to add a NAS to SQL and have Freeradius recognise and use it without restarting radius? The only way I can get this to work is by adding in

Re: icradius to freeradius with mysql - do I need all the tables...

2005-01-14 Thread Mark Elkins
On Tue, 2005-01-11 at 17:47 +0200, Mark Elkins wrote: I'm in need of some advice - ... move to freeradius... In my current MySql structure - I have a master user table (useracct) - containing fields like... | userid | usertype | username | fullname | password | contact | uid | gid | phone

icradius to freeradius with mysql - do I need all the tables...

2005-01-11 Thread Mark Elkins
I'm in need of some advice - I'm playing with a quite old icradius setup and also looking to move to freeradius... In my current MySql structure - I have a master user table (useracct) - containing fields like... | userid | usertype | username | fullname | password | contact | uid | gid | phone |