[Serusers] Broken Calls not written to Database
Daryl Sanders
daryl.sanders at gmail.com
Wed Jul 13 18:03:08 CEST 2005
In the billing system it would be great to see the following:
* multiple sip addresses under one account. (for users w/multiple DIDs)
* Import of rate tables from xls, csv
* Export of CDR data to file
* Multiple privilege levels
- Daryl
On 7/12/05, Ozan Blotter <cosmocid at ispro.net.tr> wrote:
>
> Dear List,
>
> I'm making a call to PSTN, it's okay i can talk with the other party via
> ATA, but suddenly i unplug power from it, and in accounting module it does
> not write line with BYE message so i cannot understand whether the call is
> finished or not. only INVITE and ACK are written, no BYE :(
>
> This may be a security hole for customers, because they talk for a long time
> and they may unplug their units or cut power so it does not tell SER it's
> over. How i can prevent this, also what i need to add as a line for telling
> ACC module not to write calls from 833 to 833 into database, which are free
> SIP2SIP calls ?
>
> Btw, a Postpaid Billing System is on the way for OpenSER built in PHP, later
> i will need OpenSER group's help to place it onto hosting site. Shortly it
> will have features:
>
> * Nothing extra from package, default MySql Database which comes with
> OpenSER Release is being used,
> * All routing is done via OpenSER's ser.cfg ,
> * Initial Rate, Initial Time, Increment Rate, Increment Time will be user
> variable ,
> * Account Creation/Deletion done in PHP ,
> * Invoice Generation and CDR will include many variables ,
> * Rating will be in PHP,
> * And everything is totaly free :)
>
> If you have ideas and/or suggestion please write back to me so i can work
> for it too.
> Reqs: OpenSER & PHP & MySql & Apache
>
> Thanks,
> Ozan
>
>
> debug=3
> fork=yes
> log_stderror=no
>
> listen=212.XXX.104.XXX
> port=5060
> children=4
>
> alias=212.XXX.104.XXX
>
> dns=no
> rev_dns=no
>
> fifo="/tmp/openser_fifo"
> fifo_db_url="mysql://openser:openserrw@localhost/openser"
>
> loadmodule "/usr/local/lib/openser/modules/mysql.so"
> loadmodule "/usr/local/lib/openser/modules/sl.so"
> loadmodule "/usr/local/lib/openser/modules/tm.so"
> loadmodule "/usr/local/lib/openser/modules/rr.so"
> loadmodule "/usr/local/lib/openser/modules/maxfwd.so"
> loadmodule "/usr/local/lib/openser/modules/usrloc.so"
> loadmodule "/usr/local/lib/openser/modules/registrar.so"
> loadmodule "/usr/local/lib/openser/modules/auth.so"
> loadmodule "/usr/local/lib/openser/modules/auth_db.so"
> loadmodule "/usr/local/lib/openser/modules/uri.so"
> loadmodule "/usr/local/lib/openser/modules/uri_db.so"
> loadmodule "/usr/local/lib/openser/modules/mediaproxy.so"
> loadmodule "/usr/local/lib/openser/modules/nathelper.so"
> loadmodule "/usr/local/lib/openser/modules/textops.so"
> loadmodule "/usr/local/lib/openser/modules/domain.so"
> loadmodule "/usr/local/lib/openser/modules/acc.so"
>
> #modparam("auth_db|uri_db|usrloc", "db_url",
> "mysql://ser:heslo@localhost/ser")
> modparam("auth_db", "calculate_ha1", 1)
> modparam("auth_db", "password_column", "password")
> modparam("auth_db", "use_domain", 1)
>
> modparam("domain", "db_mode", 1)
>
> modparam("nathelper", "rtpproxy_disable", 1)
> modparam("nathelper", "natping_interval", 0)
>
> modparam("mediaproxy","natping_interval", 30)
> modparam("mediaproxy","mediaproxy_socket",
> "/var/run/mediaproxy.sock")
> modparam("mediaproxy","sip_asymmetrics","/usr/local/etc/openser/sip-asymmetric-clients")
> modparam("mediaproxy","rtp_asymmetrics","/usr/local/etc/openser/rtp-asymmetric-clients")
>
> modparam("usrloc", "db_mode", 2)
> modparam("usrloc", "use_domain", 1)
>
> modparam("registrar", "default_expires", 60)
> modparam("registrar", "min_expires", 30)
> modparam("registrar", "nat_flag", 6)
> modparam("registrar", "use_domain", 1)
>
> modparam("rr", "enable_full_lr", 1)
>
> modparam("acc", "db_url",
> "mysql://openser:openserrw@localhost/openser")
> modparam("acc", "log_level", 1)
> modparam("acc", "log_flag", 1)
> modparam("acc", "db_flag", 1)
>
> route {
>
> #
> -----------------------------------------------------------------
> # Sanity Check Section
> #
> -----------------------------------------------------------------
> if (!mf_process_maxfwd_header("10")) {
> sl_send_reply("483", "Too Many Hops");
> break;
> };
>
> if (msg:len > max_len) {
> sl_send_reply("513", "Message Overflow");
> break;
> };
>
> #
> -----------------------------------------------------------------
> # Record Route Section and Acc section
> #
> -----------------------------------------------------------------
> if (method=="INVITE" && client_nat_test("3")) {
> # INSERT YOUR IP ADDRESS HERE
> record_route_preset("212.XXX.104.XXX:5060;nat=yes");
> } else if (method!="REGISTER") {
> record_route();
> setflag(1);
> };
>
> #
> -----------------------------------------------------------------
> # Call Tear Down Section
> #
> -----------------------------------------------------------------
> if (method=="BYE" || method=="CANCEL") {
> end_media_session();
> };
>
> #
> -----------------------------------------------------------------
> # Loose Route Section
> #
> -----------------------------------------------------------------
> if (loose_route()) {
>
> if (has_totag() && (method=="INVITE" || method=="ACK")) {
>
> if (client_nat_test("3") ||
> search("^Route:.*;nat=yes")) {
> setflag(6);
> use_media_proxy();
> };
> };
>
> route(1);
> break;
> };
>
> #
> -----------------------------------------------------------------
> # Call Type Processing Section
> #
> -----------------------------------------------------------------
>
> if (uri!=myself) {
> route(1);
> break;
> };
>
> if (uri==myself) {
>
> if (method=="CANCEL") {
> route(3);
> break;
> } else if (method=="INVITE") {
> route(3);
> break;
> } else if (method=="REGISTER") {
> route(2);
> break;
> };
>
> lookup("aliases");
> if (uri!=myself) {
> route(1);
> break;
> };
>
> if (!lookup("location")) {
> sl_send_reply("404", "User Not Found");
> break;
> };
> };
>
> route(1);
> }
>
> route[1] {
>
> #
> -----------------------------------------------------------------
> # Default Message Handler
> #
> -----------------------------------------------------------------
>
> t_on_reply("1");
>
> if (!t_relay()) {
>
> if (method=="INVITE" || method=="ACK") {
> end_media_session();
> };
>
> sl_reply_error();
> };
> }
>
> route[2] {
>
> #
> -----------------------------------------------------------------
> # REGISTER Message Handler
> #
> ----------------------------------------------------------------
>
> if (!search("^Contact:\ +\*") && client_nat_test("7")) {
> setflag(6);
> fix_nated_register();
> force_rport();
> };
>
> sl_send_reply("100", "Trying");
>
> if (!www_authorize("","subscriber")) {
> www_challenge("","0");
> break;
> };
>
> if (!check_to()) {
> sl_send_reply("401", "Unauthorized");
> break;
> };
>
> consume_credentials();
>
> if (!save("location")) {
> sl_reply_error();
> };
> }
>
> route[3] {
>
> #
> -----------------------------------------------------------------
> # CANCEL and INVITE Message Handler
> #
> -----------------------------------------------------------------
>
> if (client_nat_test("3")) {
> setflag(7);
> force_rport();
> fix_nated_contact();
> };
>
> lookup("aliases");
> if (uri!=myself) {
> route(1);
> break;
> };
>
> if (uri=~"^sip:0[0-9]*@*") {
> rewritehost("212.XXX.59.XXX");
> route(1);
> break;
> };
>
> if (!lookup("location")) {
> sl_send_reply("404", "User Not Found");
> break;
> };
>
> if (method=="CANCEL") {
> route(1);
> break;
> };
>
> if (!proxy_authorize("","subscriber")) {
> proxy_challenge("","0");
> break;
> } else if (!check_from()) {
> sl_send_reply("403", "Use From=ID");
> break;
> };
>
> consume_credentials();
>
> if (isflagset(6) || isflagset(7)) {
> use_media_proxy();
> };
>
> route(1);
> }
>
> onreply_route[1] {
>
> if ((isflagset(6) || isflagset(7)) &&
> (status=~"(180)|(183)|2[0-9][0-9]")) {
>
> if (!search("^Content-Length:\ +0")) {
> use_media_proxy();
> };
> };
>
> if (client_nat_test("1")) {
> fix_nated_contact();
> };
> }
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>
>
>
More information about the sr-users
mailing list