Re: Insert billiplan code in radacct table during authenticaiton

2008-10-25 Thread Anders Holm
Would a customers billing plan be determined if they sucessfully authenticate? Wouldn't they all then be in the same plan? Sorry, I just don't see your point. Sent from my iPhone On 25 Oct 2008, at 03:26, Bishal [EMAIL PROTECTED] wrote: Hi all, I am using freeradius for AAA of

Re: Insert billiplan code in radacct table during authenticaiton

2008-10-25 Thread tnt
I am using freeradius for AAA of my cable users. Now what I want to do is, insert billiplan code 001 into radacct table during authentication so that I can view online users according to billingplan code. There will be Billingplan field in radcheck table and when users tries to login the

voip accounting

2008-10-25 Thread Noel Rwamatsika
Hi there, I have setup a SuSE 11 server with freeradius and mysql. The freeradius and mysql are rpm packages from the SuSE 11 dvd. How can I setup voip accounting on this server? Which files should I configure in mysql and freeradius and how should i do it? regards, Noel - List

Re: sqlcounter returning wrong value?

2008-10-25 Thread tnt
OK. This where the problem comes from: /* * If we are near a reset then add the next * limit, so that the user will not need to * login again */ if (data-reset_time

Re: voip accounting

2008-10-25 Thread tnt
VoIP accounting is developed for postgresql (raddb/sql/postgresql). You can use that database or adapt schema and queries for MySQL. Ivan Kalik Kalik Informatika ISP Dana 25/10/2008, Noel Rwamatsika [EMAIL PROTECTED] piše: Hi there, I have setup a SuSE 11 server with freeradius and mysql. The

Re: sqlcounter returning wrong value?

2008-10-25 Thread liran tal
I've actually tested the sqlcounter for a data counter for both weekly and monthly resets and that doesn't work well either... This is odd because people have reported this working so... it is either something in the configuration that I'm missing or I really don't know what's going on but the

Re: sqlcounter returning wrong value?

2008-10-25 Thread tnt
And they won't. It's nothing to do with the settings - it's this peace of the code. Let's take your example. Limit was 26MB and about 2MB was left. 2,000,000 seconds is about 23 days. So this part of the code will kick in (there are 6 days left in this month) and returned value will be 26MB +

Re: sqlcounter returning wrong value?

2008-10-25 Thread Venkatesh K
I have had hard time using sqlcounter for data. It has (at least had) limitations for counting data like 2GB limit. I ended up writing my own code for counting data. Here is a small patch which will skip adding additional quota if counter-type=time in sqlcounter.conf file.

mysql driver for debian

2008-10-25 Thread Ahmet DÜLGAR
hi i want to install freeradius 2.1.1 into debian system. i think there is no package for 2.1.1 for debian when i try to install wiht apt-get install freeradius, it install an old package, so i download freeradius-server-2.1.1.tar.gz and write this commands ./configure make make install it

Re: mysql driver for debian

2008-10-25 Thread tnt
http://wiki.freeradius.org/FAQ#It_says_.22Could_not_link_..._file_not_found.22.2C_what_do_I_do.3F Ivan Kalik Kalik Informatika ISP Dana 25/10/2008, Ahmet DÜLGAR [EMAIL PROTECTED] piše: hi i want to install freeradius 2.1.1 into debian system. i think there is no package for 2.1.1 for debian

Re: mysql driver for debian

2008-10-25 Thread A . L . M . Buxey
Hi, ./configure make make install it is working fine, but i want to use mysql db i installed mysql and create radius db wiht schema and configure sql.conf files but radius -X says rlm_sql_mysql driver not found how too add mysql driver for debian system i tried to intall wiht apt-get

Re: Insert billiplan code in radacct table during authenticaiton

2008-10-25 Thread Bishal
Following is my radcheck table format: --+--+-+--+ | id | UserName | Attribute| op | Value| CrDate | creator | Usemac | activated | activeDate | status | rate | Type | BillingPlan | TimeToFinish |