[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