Re: Interim-Updates

2007-07-17 Thread Peter Nixon
On Tue 17 Jul 2007, David Roze wrote: Hi Peter and Stephan, I will update the page when I get a chance. It isn't the best way to proceed, you're right... One thing though, there's confusing between 2 pages with 2 different problems: Support for Gigawords in Mysql: I'm not using stored

RE: Interim-Updates

2007-07-17 Thread David Roze
and bug fixes Thanks, David -Original Message- From: Peter Nixon [mailto:[EMAIL PROTECTED] Sent: 17 July 2007 23:11 To: FreeRadius users mailing list; David Roze Subject: Re: Interim-Updates On Tue 17 Jul 2007, David Roze wrote: Hi Peter and Stephan, I will update the page when I get

Re: Interim-Updates

2007-07-13 Thread Stefan Winter
Exactly. Although of course your DB columns need to be able to hold the large numbers as well so they should be of type BIGINT like: AcctInputOctets bigint(20) default NULL, AcctOutputOctets bigint(20) default NULL, I updated the MySQL schema a couple of days ago to reflect this, but

Re: Interim-Updates

2007-07-13 Thread Stefan Winter
Stephan, we appreciate you efforts, and we always need more people writing documentation, but if you could update that page we would appreciate it. Well, the page isn't a wiki and I am in no way affiliated with the site ops. I cc'ed their contact address in my previous mail and the registrant

Re: Interim-Updates

2007-07-13 Thread Peter Nixon
On Fri 13 Jul 2007, Stefan Winter wrote: Exactly. Although of course your DB columns need to be able to hold the large numbers as well so they should be of type BIGINT like: AcctInputOctets bigint(20) default NULL, AcctOutputOctets bigint(20) default NULL, I updated the MySQL

Re: Interim-Updates

2007-07-13 Thread Peter Nixon
On Fri 13 Jul 2007, Stefan Winter wrote: Exactly. Although of course your DB columns need to be able to hold the large numbers as well so they should be of type BIGINT like: AcctInputOctets bigint(20) default NULL, AcctOutputOctets bigint(20) default NULL, I updated the MySQL

Re: Interim-Updates

2007-07-13 Thread Stefan Winter
I have also changed the FAQ around a little. That section now lives at: http://wiki.freeradius.org/FAQ#Why_do_Acct-Input-Octets_and_Acct-Output-Oct ets_wrap_at_4_GB.3F I think it better describes the symptom (which is what people reading FAQs are searching for) rather then the problem. I

Re: Interim-Updates

2007-07-13 Thread Peter Nixon
On Fri 13 Jul 2007, Stefan Winter wrote: Stephan, we appreciate you efforts, and we always need more people writing documentation, but if you could update that page we would appreciate it. Well, the page isn't a wiki and I am in no way affiliated with the site ops. I cc'ed their contact

Re: Interim-Updates

2007-07-13 Thread Stefan Winter
Hi, Yep. I was actually referring to Stephan Kirsten who posted the initial link, not to Stefan Winter :-) Ah :-) I'm so used to people misspelling my name (the French spelling with ph is a lot more popular here in Luxembourg), I'm doing an auto s/ph/f/ in my mind. Sorry about that. Stefan

RE: Interim-Updates

2007-07-13 Thread Hugh Messenger
Peter Nixon said: On Fri 13 Jul 2007, Hugh Messenger wrote: If someone has time to test this before I do, please shoot me a mail with tested working queries for MySQL... I'm testing today, I'll get back to you. BTW, one thing that always confused me about the stored procure hack was that it

Re: Interim-Updates

2007-07-13 Thread Peter Nixon
On Fri 13 Jul 2007, Hugh Messenger wrote: Peter Nixon said: On Fri 13 Jul 2007, Hugh Messenger wrote: If someone has time to test this before I do, please shoot me a mail with tested working queries for MySQL... I'm testing today, I'll get back to you. Well, check the code I committed

Re: Interim-Updates

2007-07-12 Thread Irina
: Irina [EMAIL PROTECTED] To: FreeRadius users mailing list freeradius-users@lists.freeradius.org Sent: Wednesday, July 11, 2007 4:29 PM Subject: Re: Interim-Updates Thank you very much for quick replies. Our NAS does send Gigawords, great. I am reading the link Stephan pointed out. I need

RE: Interim-Updates

2007-07-12 Thread Hugh Messenger
Irina said I need to apply it according to this document http://www.netexpertise.eu/en/FreeRadius/DailyAcct.html Could someone reply with simple yes/no answers? I am going to do it on a life server. Please. Firstly, I strongly recommend you set up a test copy of FR with its own test

Re: Interim-Updates

2007-07-12 Thread Irina
, 2007 4:44 PM Subject: RE: Interim-Updates Irina said I need to apply it according to this document http://www.netexpertise.eu/en/FreeRadius/DailyAcct.html Could someone reply with simple yes/no answers? I am going to do it on a life server. Please. Firstly, I strongly recommend

Re: Interim-Updates

2007-07-12 Thread Peter Nixon
On Thu 12 Jul 2007, Irina wrote: I need to apply it according to this document http://www.netexpertise.eu/en/FreeRadius/DailyAcct.html Hi Irina Please note that that document describes several things that you can do, including ONE way to fix your problem. There is and easier and more

RE: Interim-Updates

2007-07-12 Thread Hugh Messenger
There is and easier and more correct way to fix your problem simply by fixing the mysql query to work the same way the existing postgresql query does. The next version of FreeRADIUS will have this _bug_ fixed. So I presume all we need to do to the 1.1.x MySQL is the shift gigawords left and

Re: Interim-Updates

2007-07-12 Thread Peter Nixon
On Fri 13 Jul 2007, Hugh Messenger wrote: There is and easier and more correct way to fix your problem simply by fixing the mysql query to work the same way the existing postgresql query does. The next version of FreeRADIUS will have this _bug_ fixed. So I presume all we need to do to

RE: Interim-Updates

2007-07-11 Thread Hugh Messenger
Irina said: There are users that use a lot of bandwidth. Seems, NAS wraps Acct-Input-Octets and Acct-Output-Octets at 4 GB. We have few users that may have their bandwidth reset to 0 within hour. When next Interim- Updates is sent, we don't have a proper number. Do I miss something in

Re: Interim-Updates

2007-07-11 Thread Peter Nixon
On Wed 11 Jul 2007, Irina wrote: Hello all, We enabled Cisco NAS to send Interim-Updates to the radius server, once an hour. Everything is great except for the following. There are users that use a lot of bandwidth. Seems, NAS wraps Acct-Input-Octets and Acct-Output-Octets at 4 GB. We

Re: Interim-Updates

2007-07-11 Thread Irina
[EMAIL PROTECTED] To: FreeRadius users mailing list freeradius-users@lists.freeradius.org Sent: Wednesday, July 11, 2007 2:55 PM Subject: Re: Interim-Updates - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http