Re: reset sql counter every 30 minute

| +-+---+-++-+---+ Regards Bishal On Thu, Jan 27, 2011 at 1:34 PM, piston pisto...@yahoo.com wrote: Hi Is that possible to reset the sql counter every 30 minute? Basically, i need to get user free access of 20 minutes, after 20 minutes NAS

Re: Deleting stale session automatically with unlang

in the latest version. Perhaps its the space between 'sql:' and 'UPDATE' that is preventing the parser from recognising it as a non-select query. Try removing it? On Sat, Jan 15, 2011 at 4:02 AM, Bishal Pun bishal...@gmail.com wrote: Hello Edi, Enclosing sql statement inside empty if gives same

Re: Deleting stale session automatically with unlang

Alan, While running that command in mysql it clear the session of user. But with radius unlang it is giving error in radius log. Thanks On Fri, Jan 14, 2011 at 3:41 PM, Alan DeKok al...@deployingradius.comwrote: Bishal Pun wrote: if(User-Name){ %{sql: UPDATE radacct set AcctStopTime

Re: Deleting stale session automatically with unlang

:50 PM, Bishal Pun wrote: Alan, While running that command in mysql it clear the session of user. But with radius unlang it is giving error in radius log. I might be wrong, but as far as I know rlm_mysql expects something to come back from the query. Can't think

Deleting stale session automatically with unlang

+Hi , I am using freeradius 2.1.6 + mysql + LDAP for AAA in freebsd server. What I want to do is, when my AP reboots or due to power failure clients login is still seen there as online but the client is not able to do login. SO is it possible to clear the stale session with unlang if the

Acct-Interim-Interval not working

Hello all, I am using freeradius 2.1.6 on FreeBSD 7.2 and using rp-pppoe server 3.10 on gentoo linux. During live session it is not updating acct-input/ouput-octets. Earlier with mpd pppoe server on freebsd it was working fine accounting input and output octets were updating every 5mins as

Max-All-Session counter module problem

with Maximum never usage time reached? radcheck table output of user sneha: 2901 | sneha| Max-All-Session| := | 18 | Thank you Bishal I am using Freeradius 2.1.6 with LDAP for authentication and mysql for accounting in FreeBSD 7.2. radcheck table for user is like below. However

Max-All-Session counter module problem[SOLVED]

Hello all, Problem is solved. Actually it was due to radgroupcheck table. There I have inserted Max-All-Session as 9. I deleted it and now the user can log in. Thank you Bishal Hi, I am posting the debug of another user who has same problem: rad_recv: Access-Request packet from

Re: Insert billiplan code in radacct table during authenticaiton

Hi Liran, I have developed my own php based online viewing gui interface. Bishal On 10/27/2008, liran tal [EMAIL PROTECTED] wrote: On Sun, Oct 26, 2008 at 4:12 AM, Bishal [EMAIL PROTECTED] wrote: Following is my radcheck table format: --+--+-+--+ | id

Re: Insert billiplan code in radacct table during authenticaiton

Thanks Ivan, by extending my query in mysql it worked. Thanks Bishal On 10/26/2008, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Following is my radcheck table format: --+--+-+--+ | id | UserName | Attribute| op | Value| CrDate | creator

Re: Insert billiplan code in radacct table during authenticaiton

| +--+--+--++--+-+-++---+-++--+--+-+--+ | 1272 | bishal | User-Password| == | testpass| 2006-07-28 18:42:58 | bishal | 0 | 0 | 2007-07-22 20:49:17

Insert billiplan code in radacct table during authenticaiton

to login the script will check the radcheck table and update that billingplan code into radacct table. Is it possible with rlm_perl module? Thank you Bishal - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: help need with mysql statement in freeradius

Hi all, After many trial and errors my perl modules is working great. Thanks IVan, Alan and all of who helped me a lot. Well I am not programmer but search in google and you guys helped me a lot. One thing is I am not able to log my custom message of perl modules in radius.log. Is it

Re: help need with mysql statement in freeradius

On 5/15/2008, Ivan Kalik [EMAIL PROTECTED] wrote: PS. You should run your script in authorize. Ivan Kalik Kalik Informatika ISP Dana 15/5/2008, Bishal [EMAIL PROTECTED] pi¹e: Hello Ivan, I came up with this scripts but looks like it;s not working. In radiusd.conf perl{ modules = /usr

Re: help need with mysql statement in freeradius

your script in authorize. Ivan Kalik Kalik Informatika ISP Dana 15/5/2008, Bishal [EMAIL PROTECTED] pi¹e: Hello Ivan, I came up with this scripts but looks like it;s not working. In radiusd.conf perl{ modules = /usr/local/etc/raddb/mac_check.pl } Instantiate { exec expr dailycounter

Re: help need with mysql statement in freeradius

Hi Ivan, I am using sql for AAA. Can u give me some exaples how can I do that withl Rlm_perl modules.? Thanks On 5/14/2008, Ivan Kalik [EMAIL PROTECTED] wrote: http://wiki.freeradius.org/Rlm_perl Ivan Kalik kalik Informatika ISP Dana 14/5/2008, Bishal [EMAIL PROTECTED] pi¹e: Hi all

Re: help need with mysql statement in freeradius

Any sample scripts IVAN? On 5/14/2008, Ivan Kalik [EMAIL PROTECTED] wrote: I am using sql for AAA. I have news for you - you are not. You are using it to store attributes. Can u give me some exaples how can I do that withl Rlm_perl modules.? Do Google: mysql perl tutorial. If it's not

Re: help need with mysql statement in freeradius

{ exit; } $sql-finish; $dbh-disconnect() or warn Disconnection failed: $DBI::errstr\n; On 5/14/2008, Bishal [EMAIL PROTECTED] wrote: Any sample scripts IVAN? On 5/14/2008, Ivan Kalik [EMAIL PROTECTED] wrote: I am using sql for AAA. I have news for you - you are not. You are using

help need with mysql statement in freeradius

Hi all, I am trying to do MAC insertion during post authentication section with the help of freeradius. Like during authentication section it will check in mysql database for MAC use option. If MAC use= 1 then if the user is login for the first time then grab the mac address from the login

Re: freeradius authentication LAN users

Use PPPoE for AAA. Regards Bisal On 8/10/2007, ram [EMAIL PROTECTED] wrote: On 8/8/07, satish patel [EMAIL PROTECTED] wrote: Dear all I am on ISP and i want to configure billing gateway means user authentuicate that gateway and surffing net so is these type of any

LDAP errror in dialup admin page

I am trying to use freeradius 1.1.7 in Freebsd 6.2 with openldap 2.3.37 for authentication and mysql for accounting. While creating new user I get following error in dialup admin page: Warning: file(/usr/local/etc/raddb/ldap.attrmap) [function.file]: failed to open stream: Permission denied in

Re: LDAP errror in dialup admin page

Apache is running as www and it can open and read file. But still I am getting the same error. On 7/29/2007, Kostas Kalevras [EMAIL PROTECTED] wrote: O/H Bishal έγραψε: I am trying to use freeradius 1.1.7 in Freebsd 6.2 with openldap 2.3.37 for authentication and mysql for accounting

Rejected Calling Station id and radius reply message

Hello I am using freeradius 1.1.3 in freebsd 6 with mysql database. My problem is if I enable the calling-station-id in freeradius radcheck table the rejected message is shown as below in radius log Fri Mar 16 16:56:58 2007 : Info: rlm_sql (sql): No matching entry in the database for request

Question about rlm_sqlcounter

Hi list, Is it possible to reset the monthly counter from the date of account active/created to the end of the month (30days). Like: user abc renewed his account 25hrs on 15 Dec 2006 and it will expire on 14th Jan 2007. Is it possible to make counter reset on 15th Jan 2007? - List

Reset sql counter

Is it possible to reset the sql counter manually or by any scripts in freeradius? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Two sql queries in counter module

Hello all Is it possible to make two queries in sql counter module? like sqlcounter noresetcounter { driver = rlm_sqlcounter counter-name = Max-All-Session-Time check-name = Max-All-Session

Sql counter

Has anyone made a sql counter module for rechargeable account? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

sqlcounter

Hello all How can I make sqlcounter module for rechargeable account in my freeradius server with mysql backened. Bsal - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

sqlcounter for rechargeable account

Hi all, Can anybody guide me how to make sql counter for rechargeable account. like user test01 subscribe for total of 25hours and after finishing 25hours if he wants to recharge his account again to 25hrs. Bisal - List info/subscribe/unsubscribe? See

freeradius stop automatically

After upgrading freeradius 1.0.5 to version 1.1.2 on Freebsd 6 my radius server stop automatically with the following error essage. Wed Jul 26 01:30:08 2006 : Error: Discarding duplicate request from client pppoe-bhw:61882 - ID: 137 due to unfinished request 61 Wed Jul 26 01:30:08 2006 :

Error while running log_badlogins scripts

Hello, I have installed Freeradius 1.1.2 in FreeBSD 6.0. Everything is running well except log_badlogins script. When I run log_badlogins scripts it gives me the error ERROR: Date::Manip unable to determine TimeZone. at /usr/local/lib/perl5/site_perl/5.8.7/Date/Manip.pm line 3635

radzap not working

Hello all, I have installed freeradius 1.0.5 in freebsd 6. I am authenticating pppoe users to my remote freeradius server. I tried to delete the stale session from radutmp file with radzap coammand but it doesnot work; radwho shows the following login information: #radwho Login Name

Re: Re: how to disconnect user after quota given to him finishes ?

You can use daily limit with Session Timeout. On 2/16/2006, Rupesh Amatya [EMAIL PROTECTED] wrote: Dear all, The user gets logged out exactly after the time set in Session Time Out. But I am trying to create package like 4hours per day, 2 hours perday. If I put 4hours in Session time and

Password chaning and usage viewing interface for client

Hello all Is their any web interface for clients, so that they can change their password and view their account usage status.? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Mikrotik router Tx/Rx attribute and freeradius

Is it possible to limit the data transfer rate with freeradius and mikrotik. If possbile then where should I specify what attribute. For example I want to authenticate the users with freeradius + mysql and mikrotik router and limit the Tx/Rx rate to 64Kbps/32Kbps. How can I do that? - List

Re: dialup-admin problem

Mine too is FreeBSD 6.0 with Apache2.2.0 and php5.1 Dialup admin works fine only one dialup menu option i.e Statistics when I click on it, gives the error as follows; Warning: mktime() expects parameter 1 to be long, string given in

Freeradius 1.1.0 crash on FreeBSD 6

Dear all, I have installed Freeradius 1.1.0 in FreeBSD with Mysql 5.0.17. Authenticaiton an authorization works fine. But when I enable the Max-Daily-Session module it crashes with segmentation fault. and radiusd.core file is created. Below is the dumped file of radiusd.core file:

Re: Freeradius 1.1.0 crash on FreeBSD 6

Ok I followed the step in bug #98 and compiled with ./configure --disable-shared Now when I tried to run the radiusd -X it shows /libexec/ld-elf.so.1: Shared object libperl.so not found, required by radiusd while searching the libperl.so it was located in

Error with dialup admin

Hello all I have installed freeradius 1.1.0 in freebsd 6.0. While clicking on statistic menu of dialup page I got this error. Warning: mktime() expects parameter 1 to be long, string given in /usr/home/httpd/baayu.com.np/baayucom/dialbaayu/lib/functions.php3 on line 83 Warning: mktime()