How to Disable RADIUS user logins if 'Session-Timeout' falls below 0

Hi All, I am using FreeRadius with PostgreSQL and everything is running like a charm besides a small issue.   I am using ‘session-timeout’ attribute in radreply table to control user session time. I have added a trigger on RADACCT table which subtracts amount of time used by user from

RE: restricting multiple logins by same user

Hi , To restrict one login per user please use "Simultaneous-Use" attribute in radcheck and set it to value 1. Thanks, Sagar Message: 4 Date: Wed, 19 Jan 2005 11:40:04 -0800 (PST) From: Sonali Karmarkar <[EMAIL PROTECTED]> Subject: restricting multiple logins by same user To: freeradius-users@l

Is it possible to authenticate RADIUS users just on Username with no password?

Hi All, I am using radius for my personal wireless ISP venture. I got some pre-paid cards used for long distance voice calls and I want to use them for occasional wi-fi users. Though radius needs a username/pwd pair for authentication they have only PIN printed on them. Can I use these PINs as RAD

Can I use just Password for RADIUS authentication?

Hi All, I want to use a PRE-PAID vouchers for Wireless User logins. In theory for each connection one need to enter a username and password pair to authenticate against RADIUS server. The Challenge I have , my Pre-Paid Cards don't have username printed on them. They just have a 12 digit Random NUM

using scratch-Card SERIAL number instead of RADIUS username/pwd

Hi All, I am using FreeRADIUS for Hotspot Wireless Internet System. I would like to have a PIN number(16 Digits) on my Scratch card rather than username password pair. User will buy scratch card ,use PIN printed on card to login at hotspot locations. My question is, How can I make RADIUS Server a

Forum for freeRADIUS

Alan/Others, Is it possible for us to setup a Discussion Forum for freeRADIUS? There are number of questions answered on previous mailing list but they lack good search engine & web interface. Lots of newbie like me keep on asking same questions again and again which are already answered. See an

How to add multiple MySQL queries/stmts for each Acconting START/STOP packets?

Hi All, Is there a way to add number of SQL statements into SQL.conf to execute for each Accounting START/STOP packet? I need to update multiple tables with stats once radiusd receives accounting START or STOP packet. Please see my current SQL.CONF entries below. Can I write ? Accounting_start_

Using MYSQL 5.0 Stored Procedure for RADIUS Accounting queries

Hi All, I need to fire number of SQL statements (mainly Update/INSERT) after Radius Server receives ACCOUNTING_STOP, ACCOUNTING_START packets. I looked into sql.conf and can't make out a way to add N no. of queries at receipt of packets. Is it possible to use MYSQL 5.0 stored procedure feature fo

Re: How to specify more than one SQL query in SQL.CONF

Hi All, Keith, Thanks for U'r reply. I looked into rlm_sqlcounter and it can help to restrict daily ,weekly else monthly limits. In my case people are charged at per minute usage of internet .In worst case if we have 100 users and all of them subscribed for odd minutes then I would need 100 count

How to specify more than one SQL query in SQL.CONF

Hi All, I can see accounting_update_query in SQl.conf which updates RADACCT table for each ACCOUNTINGT_UPDATE PACKET form NAS. My question is can I specify more than one query here. I want to decrement SESSION_TIMEOUT in RERPLY by min each time I receive Accounting update packets. So is it possib

Custom MYSQL Query at SQL.conf file

Hi All, I can see number of SQL queries in sql.conf. They are defined by keywords simul_verify_query, group_membership_query, postauth_query etc. I want to know if there is a easy way to add a custom Query in this file? I need to fire a mysql backend procedure (new in 5.0.0) once it has finished e

Re: SQLCOUNTER Problems

Hi Juban, I did tried both settings SQL and SQLCC in sqlcounter.conf Accounting packets are updated into mySQL radacct table without any problems. Can I request you to send me MYSQL table entries for a sample user with daily time limits for my reference. I think I am entering some wrong values i

RE: Freeradius-Users digest, Vol 1 #3023 - 3 msgs

Hi Alan, Thanks mate for U'r reply. I have following parameters in radiusd.conf... $INCLUDE ${confdir}/sqlcounter.conf authorize { preprocess # auth_log # attr_filter chap mschap # digest # IPASS suffix eap files

SQLCOUNTER Problems

Hi All,   I want to use RLM_SQLCOUNTER with Freeradius. After compiling RLM_SQLCOUNTER with FreeRadius .. I still can’t see radius trying to update usage statistics in MYSQL tables. I read doc/rlm_sqlcounter and thought whenever user uses any minutes out of allocated values RLM_COUNTER

Freeradius-Dialup-Admin Help

Hi All,   I am trying to use dialup_admin/bin/clean_radacct to clear dangling User sessions. When I fire following Command it returns an error   [[EMAIL PROTECTED] bin]# ./clean_radacct Could not find mysql binary. Please make sure that the $mysql variable points to the right locatio

Freeradius Accounting Updates after user Validation

Hi All,   I have a real problem here and looking for a solution.   User A has Paid for 1 hour time. User logged in and used 50 mins of it’s time Then he logged in and start using 51 mins onwards. In theory he should be allowed to use 10 mins of remaining time but once logged in he ca

Using IPPOOLS with FreeRadius +MYSQL

Hi All,   I have a FreeRadius + Mysql up and running fine under Mandrake Linux 9.1.   Questions here     How can I assign pool  of IP addresses to one Wireless AP in MYSQL   ?     I read following reply in past but can’t make out what U need to add in MYSQL tables

Column Descriptions for RADACCT table

Hi All, If someone has got knowledge could U please reply me about columns in RADACCT table?I need information for columns marked as ??? TABLE `radacct`   `RadAcctId`     `AcctSessionId`     `AcctUniqueId`      `UserName`      `Realm`  ???  `NASIPAd

How to Freeradius + EAP/TTLS

Hi All,   I am following notes at following link to implement EAP/TTLS with FREERADIUS. http://rbirri.9online.fr/howto/Freeradius_+_TTLS.html   Alan U’r suggestion to pick up latest snapshot did worked and I could compile TTLS under src/modules/rlm_eap/types/rlm_eap_ttls/   I also

Freeradius Upgrade Error

Hi,   I had freeradius 0.9.3 with Mysql working fine. Now I am trying to upgrade it to freeradius-snapshot-20040218 to achieve support for EAP/TTLS. I am Following notes at http://rbirri.9online.fr/howto/Freeradius_+_TTLS.html   When I try to use # make  for freeradius-snapshot-200402

How to limit Upload/Download Rate

Hi All,   I am working on a Wireless ISP project. I have installed Freeradius 0.9.3 with mysql under Mandrake LINUX 9.1 and everything is working fine. Freeradius can authenticate users against Mysql DB and I could use DIALUP_ADMIN for Radius user management.   Couple of questions her