True. Just look at FreeRADIUS configs and use a similar
INSERT statement to have an offline billing.
----- Original Message -----
From: "Shashi Dahal" <shashi0@xxxxxxxxx>
Sent: Monday, November 07, 2005 7:52 PM
In sqlbill, i know that the tariff is processed via triggers/procedures.
Does this mean that it is possible to use it for cdr based processing too?
like crafting a insert into field into a file, taking values from the csv
file and running it on postgresql.
with every insert into voipcall, will it automatically take the values and
do the correct billing.
sqlbill is working like a charm (though i am trying to make it work with
oracle too, since we already faced downtimes with mysql not being able to
handle a huge chunk of calls, and this system never been tested or any
mention of handling loads of traffic), but what I got are cdr records in a
csv file. What can I do to get the billing out of the csv file using sqlbill
? Would just an insert into postgresql do the job?
insert into voipcall values (.... IP, number, duration... ) and it will
automatically take the framedIP from the voipuser table and get its tariff
and start doing the processing and deducting of the amount from the account
?
Please let me know if my question is not clear.
Thanks,
Shashi
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________________
Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users
Homepage: http://www.gnugk.org/
