[freeside-users] Usage Billing

M. Stephen stemap at netsoltz.com
Sun Sep 23 13:52:38 PDT 2007


I went through the freeside-sqlradius-radacctd and I saw 
radacctd is complaining about Unknown Column 
'FreesideStatus' in 'where clause' at 
/usr/local/share/perl/5.8.8/FS/part_expor
t/sqlradius.pm line 646.

I think this should be the problem with my per usage 
billing.

Any help to solve this problem will highly be appreciated

________
Stephen



[Sun Sep 23 23:45:39 2007] [13970] DBD::Pg::db disconnect 
failed: server closed
the connection unexpectedly
         This probably means the server terminated 
abnormally
         before or while processing the request.
[Sun Sep 23 23:45:39 2007] [12524] child 13970 spawned for 
RadiusServer at /usr/
local/bin/freeside-sqlradius-radacctd line 64.
[Sun Sep 23 23:45:39 2007] [13970] DBD::mysql::st execute 
failed: Unknown column
  'FreesideStatus' in 'where clause' at 
/usr/local/share/perl/5.8.8/FS/part_expor
t/sqlradius.pm line 646.
[Sun Sep 23 23:45:39 2007] [13970] Unknown column 
'FreesideStatus' in 'where cla
use' at 
/usr/local/share/perl/5.8.8/FS/part_export/sqlradius.pm 
line 646.
[Sun Sep 23 23:45:39 2007] [13972] DBD::Pg::db disconnect 
failed: server closed
the connection unexpectedly
         This probably means the server terminated 
abnormally
         before or while processing the request.
[Sun Sep 23 23:45:39 2007] [20667] child 13972 spawned for 
RadiusServer at /usr/
local/bin/freeside-sqlradius-radacctd line 64.
[Sun Sep 23 23:45:39 2007] [13972] DBD::mysql::st execute 
failed: Unknown column
  'FreesideStatus' in 'where clause' at 
/usr/local/share/perl/5.8.8/FS/part_expor
t/sqlradius.pm line 646.
[Sun Sep 23 23:45:39 2007] [13972] Unknown column 
'FreesideStatus' in 'where cla
use' at 
/usr/local/share/perl/5.8.8/FS/part_export/sqlradius.pm 
line 646.
[Sun Sep 23 23:45:44 2007] [13975] DBD::Pg::db disconnect 
failed: server closed
the connection unexpectedly
         This probably means the server terminated 
abnormally
         before or while processing the request.
[Sun Sep 23 23:45:44 2007] [19872] child 13975 spawned for 
RadiusServer at /usr/
local/bin/freeside-sqlradius-radacctd line 64.
[Sun Sep 23 23:45:44 2007] [13975] DBD::mysql::st execute 
failed: Unknown column
  'FreesideStatus' in 'where clause' at 
/usr/local/share/perl/5.8.8/FS/part_expor
t/sqlradius.pm line 646.
[Sun Sep 23 23:45:44 2007] [13975] Unknown column 
'FreesideStatus' in 'where cla
use' at 
/usr/local/share/perl/5.8.8/FS/part_export/sqlradius.pm 
line 646.
[Sun Sep 23 23:45:49 2007] [13979] DBD::Pg::db disconnect 
failed: server closed
the connection unexpectedly
         This probably means the server terminated 
abnormally
         before or while processing the request.
[Sun Sep 23 23:45:49 2007] [12524] child 13979 spawned for 
RadiusServer at /usr/
local/bin/freeside-sqlradius-radacctd line 64.
[Sun Sep 23 23:45:49 2007] [13979] DBD::mysql::st execute 
failed: Unknown column
  'FreesideStatus' in 'where clause' at 
/usr/local/share/perl/5.8.8/FS/part_expor
t/sqlradius.pm line 646.
[Sun Sep 23 23:45:49 2007] [13979] Unknown column 
'FreesideStatus' in 'where cla
use' at 
/usr/local/share/perl/5.8.8/FS/part_export/sqlradius.pm 
line 646.
[Sun Sep 23 23:45:49 2007] [13981] DBD::Pg::db disconnect 
failed: server closed
the connection unexpectedly




On Sat, 22 Sep 2007 12:43:17 -0700
  Ivan Kohler <ivan at sisd.com> wrote:
> We have done this sort of usage billing - sponsored by 
>two separate 
> customers recently.  I don't personally have the 
>resources to walk you 
> through setting it up and troubleshoot your problems, 
>but I do know that 
> it works for us.  Hope that helps.
> 
> -- 
> _ivan
> 
> 
> On Sat, Sep 22, 2007 at 10:45:53PM +0300, M. Stephen 
>wrote:
>> I real in need of perdownload usage. I decided to do 
>>fresh 
>> installation of FREESIDE_1_7_BRANCH.
>> 
>> The freeside-sqlradius-radacctd is running. I also 
>>enabled 
>> svc_acct-usage_suspend and svc_acct-usage_unsuspend.
>> 
>> I can see usage sessions and i can set total bytes in 
>>user 
>> account.
>> 
>> But still the used bytes is 0 and remaining bytes is the 
>> same as before, although usage sessions shows some bytes 
>> are used.
>> 
>> I want to charge users per usage. Say user is given 
>>90MB. 
>> The user should buy the usage capacity using prepaid 
>>card. 
>> And when the 90MB is finished, the user should be 
>> disconnected automatically.
>> 
>> User should also see from the selfservice interface the 
>> amount of data used and remaining amount.
>> 
>> If there is anybody who has done per usage billing 
>>please 
>> advice
>> 
>> ___________
>> Stephen
>> 
>> 
>> 
>> On Fri, 21 Sep 2007 16:50:27 -0700
>>   Ivan Kohler <ivan at sisd.com> wrote:
>> > It sounds like you didn't install the new verison 
>> >completely, 
>> > including programs.  Make sure you do that, and run 
>> > freeside-upgrade.  Good luck.
>> > 
>> > -- 
>> > _ivan
>> > 
>> > 
>> > On Fri, Sep 21, 2007 at 10:07:22AM +0300, M. Stephen 
>> >wrote:
>> >> I upgraded my freeside installation to 
>> >> FREESIDE_1_7_BRANCH. Now when adding user, I get the 
>> >> following error
>> >> 
>> >> Error: can't parse cust_main.custnum default value 
>>for 
>> >> sequence name
>> >> 
>> >> I can not add users anymore.
>> >> 
>> >> ___________
>> >> Stephen
>> >> 
>> >> 
>> >> On Mon, 17 Sep 2007 18:13:12 -0700
>> >>   Ivan Kohler <ivan at sisd.com> wrote:
>> >> > Upgrade to 1.7.3 (FREESIDE_1_7_BRANCH in CVS 
>> >>currently, 
>> >> >a release Real 
>> >> > Soon Now), and make sure you're running 
>> >> >freeside-sqlradius-radacctd (it 
>> >> > is commented out in the shipped init file).
>> >> > 
>> >> > -- 
>> >> > _ivan
>> >> > 
>> >> > 
>> >> > On Thu, Sep 13, 2007 at 11:43:20PM +0300, M. 
>>Stephen 
>> >> >wrote:
>> >> >> 
>> >> >> I have installed freeside v1.7.2. It works fine. I 
>> >>can 
>> >> >> generate prepaid cards and I can provision to 
>>mysql 
>> >> >>using 
>> >> >> radius export module.
>> >> >> 
>> >> >> My problem is, I want to charge users per usage 
>>and 
>> >> >> prepaid cards should be used tp recharge accounts. 
>> >>That 
>> >> >>is 
>> >> >> I need to create say, a package of 30MB total 
>>limit. 
>> >> >>When 
>> >> >> user has finished the 30MB HE SHOULD BE 
>>DISCONNECTED 
>> >> >>FROM 
>> >> >> THE SERVICE. And also, if the user quota (30MB) is 
>> >>not 
>> >> >> used within a month, the user should also be 
>> >> >>disconnected.
>> >> >> 
>> >> >> I have tried almost all price plan with no 
>>success. 
>> >>What 
>> >> >>I 
>> >> >> see is that using prepaid flat rate, Expiration 
>>date 
>> >>and 
>> >> >> time for the user is populated to radius mysql 
>> >>server.
>> >> >> 
>> >> >> I was expecting freeside to provision the account 
>>to 
>> >> >> radius server and when usage has reached the 
>>limit, 
>> >> >> automatically freeside should remove the account 
>>from 
>> >> >>  radius server and mark the user as suspended.
>> >> >> 
>> >> >> If anyone there has done per usage billing please 
>> >>advice
>> >> >> 
>> >> >> 
>> >> >> ____________
>> >> >> Stephen
>> >> >> _______________________________________________
>> >> >> freeside-users mailing list
>> >> >> freeside-users at sisd.com
>> >> >> 
>>http://420.am/cgi-bin/mailman/listinfo/freeside-users
>> >> > 
>> >> > _______________________________________________
>> >> > freeside-users mailing list
>> >> > freeside-users at sisd.com
>> >> > 
>>http://420.am/cgi-bin/mailman/listinfo/freeside-users
>> >> 
>> >> _______________________________________________
>> >> freeside-users mailing list
>> >> freeside-users at sisd.com
>> >> http://420.am/cgi-bin/mailman/listinfo/freeside-users
>> > 
>> > _______________________________________________
>> > freeside-users mailing list
>> > freeside-users at sisd.com
>> > http://420.am/cgi-bin/mailman/listinfo/freeside-users
>> 
>> _______________________________________________
>> freeside-users mailing list
>> freeside-users at sisd.com
>> http://420.am/cgi-bin/mailman/listinfo/freeside-users
> 
> -- 
> _ivan
> _______________________________________________
> freeside-users mailing list
> freeside-users at sisd.com
> http://420.am/cgi-bin/mailman/listinfo/freeside-users



More information about the freeside-users mailing list