[Serusers] ACC into mysql
Edgardo O. Gonzales II
edgardo.g at pacific.net.ph
Wed Apr 27 23:09:35 CEST 2005
any other help to make accounting work ..
At 03:52 AM 4/28/2005, Leon Sun wrote:
>For me, 0.8.12 was same.
>
>
>----------
>From: Edgardo O. Gonzales II [mailto:edgardo.g at pacific.net.ph]
>Sent: April 27, 2005 12:12 PM
>To: Leon Sun; 'Barry Murphy'; 'Kofi Obiri-Yeboah'
>Cc: serusers at lists.iptel.org
>Subject: RE: [Serusers] ACC into mysql
>
>
>Im also using 0.8.14 version of ser .. any other good suggestion .. have
>you tried using other ver of ser ..
>
>
>
>At 03:10 AM 4/28/2005, Leon Sun wrote:
>
>Edgardo,
>
>Whats your SER version?
>
>Me either.
>
>I even couldnt put modparam("acc", "db_url",
>"mysql://ser:heslo@localhost/ser") into ser.cfg. It showed error in file.
>
>It seemed 0.8.14 doesnt like it.
>
>
>
>
>----------
>From: serusers-bounces at iptel.org [ mailto:serusers-bounces at lists.iptel.org] On
>Behalf Of Edgardo O. Gonzales II
>Sent: April 27, 2005 11:17 AM
>To: Barry Murphy; Kofi Obiri-Yeboah
>Cc: serusers at lists.iptel.org
>Subject: Re: [Serusers] ACC into mysql
>
>
>Hi!
>
>my accounting is still not working though im not receiving any error
>message during my startup.
>Its nto logging my transaction on my db.
>
>Can you please check my ser.cfg file below .. Please put your comments ..
>
>thanks,
>ed
>
>======================
>
>debug=7
>#fork=no
>#log_stderror=yes
>
>check_via=no
>dns=no
>rev_dns=no
>port=5060
>#children=4
>fifo="/tmp/ser_fifo"
>
># ------------------ module loading ----------------------------------
>
>loadmodule "/usr/local/ser/lib/ser/modules/mysql.so"
>loadmodule "/usr/local/ser/lib/ser/modules/sl.so"
>loadmodule "/usr/local/ser/lib/ser/modules/tm.so"
>loadmodule "/usr/local/ser/lib/ser/modules/rr.so"
>loadmodule "/usr/local/ser/lib/ser/modules/maxfwd.so"
>loadmodule "/usr/local/ser/lib/ser/modules/usrloc.so"
>loadmodule "/usr/local/ser/lib/ser/modules/registrar.so"
>loadmodule "/usr/local/ser/lib/ser/modules/auth.so"
>loadmodule "/usr/local/ser/lib/ser/modules/auth_db.so"
>loadmodule "/usr/local/ser/lib/ser/modules/acc.so"
>
># ----------------- setting module-specific parameters ---------------
>
># -- usrloc params --
>
>modparam("usrloc", "db_mode", 1)
>modparam("usrloc", "db_url","mysql://ser:heslo@localhost/ser")
>
># -- auth params --
>
>modparam("auth_db", "calculate_ha1", yes)
>modparam("auth_db", "password_column", "password")
>
># -- rr params --
>
>modparam("rr", "enable_full_lr", 1)
>
># -- acc params --
>
>modparam("acc", "log_level", 1)
>modparam("acc", "log_flag", 1)
>modparam("acc", "log_missed_flag", 3)
>modparam("acc", "db_url", "mysql://ser:heslo@localhost/ser")
>modparam("acc", "db_flag", 2)
>modparam("acc", "failed_transactions", 1)
>
>
># ------------------------- request routing logic -------------------
>
>alias=test.com
>
># main routing logic
>
>route{
> if (!mf_process_maxfwd_header("10")) {
> sl_send_reply("483","Too Many Hops");
> break;
> };
> if ( msg:len > max_len ) {
> sl_send_reply("513", "Message too big");
> break;
> };
>
> record_route();
> if (loose_route()) {
> t_relay();
> break;
> };
>
> if (uri=~"test.com") {
> if (method=="REGISTER") {
> setflag(1);
> setflag(2);
>
> if (!www_authorize("test.com", "subscriber")) {
> www_challenge("test.com", "0");
> break;
> };
>
> save("location");
> break;
> };
>
> lookup("aliases");
>
> if (!lookup("location")) {
> sl_send_reply("404", "Not Found");
> break;
> };
> };
> if (!t_relay()) {
> sl_reply_error();
> };
>
>}
>
>
>
>======================================
>
>At 02:47 PM 4/26/2005, Barry Murphy wrote:
>
>Mine works, just I dont get the BYE into mysql, even though I see it in ngrep.
>
>Secondly if i call my PBX (Asterisk) via ser and the asterisk hangs up
>after giving the time, the call doesnt end on SER it remains connected.
>
>Stupid stupid thing :(
>
>Barry
>
>----- Original Message -----
>From: <mailto:edgardo.g at pacific.net.ph>Edgardo O. Gonzales II
>To: <mailto:kofi at radiocomplex.com>Kofi Obiri-Yeboah
>Cc: <mailto:serusers at lists.iptel.org>serusers at lists.iptel.org
>Sent: Tuesday, April 26, 2005 6:29 PM
>Subject: RE: [Serusers] ACC into mysql
>
>Thanks again for your help .. Here's my running ser.cfg
>Hope you can help me make my accounting work..
>thanks,
>ed
>================================================================
># ----------- global configuration parameters ------------------------
>#debug=3
>#fork=yes
>#log_stderror=no
>#debug=7
>#fork=no
>#log_stderror=yes
>check_via=no
>dns=no
>rev_dns=no
>#port=5060
>#children=4
>fifo="/tmp/ser_fifo"
># ------------------ module loading ----------------------------------
>loadmodule "/usr/local/ser/lib/ser/modules/mysql.so"
>loadmodule "/usr/local/ser/lib/ser/modules/sl.so"
>loadmodule "/usr/local/ser/lib/ser/modules/tm.so"
>loadmodule "/usr/local/ser/lib/ser/modules/rr.so"
>loadmodule "/usr/local/ser/lib/ser/modules/maxfwd.so"
>loadmodule "/usr/local/ser/lib/ser/modules/usrloc.so"
>loadmodule "/usr/local/ser/lib/ser/modules/registrar.so"
>loadmodule "/usr/local/ser/lib/ser/modules/auth.so"
>loadmodule "/usr/local/ser/lib/ser/modules/auth_db.so"
>loadmodule "/usr/local/ser/lib/ser/modules/acc.so"
># ----------------- setting module-specific parameters ---------------
># -- usrloc params --
>modparam("usrloc", "db_mode", 1)
>modparam("usrloc", "db_url","mysql://ser:heslo@localhost/ser")
># -- auth params --
>modparam("auth_db", "calculate_ha1", yes)
>modparam("auth_db", "password_column", "password")
># -- rr params --
>modparam("rr", "enable_full_lr", 1)
># -- acc params --
>modparam("acc", "log_level", 1)
>modparam("acc", "log_flag", 1)
>modparam("acc", "log_missed_flag", 3)
># ------------------------- request routing logic -------------------
>alias=abc.com.ph
># main routing logic
>route{
> if (!mf_process_maxfwd_header("10")) {
> sl_send_reply("483","Too Many Hops");
> break;
> };
> if ( msg:len > max_len ) {
> sl_send_reply("513", "Message too big");
> break;
> };
> record_route();
> if (loose_route()) {
> t_relay();
> break;
> };
> if (uri=~"abc.com.ph") {
> if (method=="REGISTER") {
> if (!www_authorize("abc.com.ph", "subscriber")) {
> www_challenge("abc.com.ph", "0");
> break;
> };
> save("location");
> break;
> };
> lookup("aliases");
> if (!lookup("location")) {
> sl_send_reply("404", "Not Found");
> break;
> };
> };
> if (!t_relay()) {
> sl_reply_error();
> };
>}
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20050428/dda5febd/attachment.htm>
More information about the sr-users
mailing list