----- Original Message -----
Sent: Wednesday, April 27, 2005 1:13
AM
Subject: RE: [Serusers] ACC into
mysql
This
particular config (I don't think?) won't log to a DB, additionally you need to
setflag(1); somewhere in your config. We tried to set on "outbound" only
originally and didn't have much luck so I set it near the top. To log to
(my)sql you will additionally need to set another flag and setup similar mod
params:
modparam("acc", "db_url",
"mysql://ser:serro@blah.mysql.haha/dbname")
# Note flag 2, you will need to
setflag(1); AND setflag(2);
modparam("acc", "db_flag", 2)
#Note this one logs all failed calls from the invite response, I find
it useful
modparam("acc", "failed_transactions", 1)
# In
your route config use something like the following
#
This is pretty much near the top, while ACC won't log reg's or INFO anyway, I
just thought it'd be a little cleaner to have
...
if
(!method == "REGISTER" || !method == "INFO" )
{
setflag(1);
setflag(2);
}
...
#
Doing the above ensure everything gets tagged including BYE's. A good reason
why your BYE's may not get
#
tagged is possibly because record-route could be relaying the call before the
flag gets set, just a thought..
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();
};
}
================================================================
At
10:55 AM 4/26/2005, Kofi Obiri-Yeboah wrote:
I am assuming your question is if the record_route() function is a
parameter for accounting? If that was your question then the answer is no.
Generally you invoke record_route() to ensure acl acceptance on a gateway
(i.e. all calls through that gateway)
- -----Original Message-----
- From: Edgardo O. Gonzales II [
mailto:edgardo.g@pacific.net.ph]
- Sent: Monday, April 25, 2005 6:22 PM
- To: Kofi Obiri-Yeboah
- Cc: serusers@lists.iptel.org
- Subject: RE: [Serusers] ACC into mysql
- Hi Kofi!
- got it.. thanks for immediate feedback .. however my accounting is
not working.
- any parameters to be added to make it work..
- I have the following info already on my ser.cfg
- modparam("acc", "log_level", 1)
- modparam("acc", "log_flag", 1)
- modparam("acc", "log_missed_flag", 3)
- record_route(); -> its this a parameter for accounting
- thanks,
- ed
- At 08:32 AM 4/26/2005, Kofi Obiri-Yeboah wrote:
- I think the correct modparam
statement should read as follows:
- modparam("acc", "db_url",
"mysql://ser:heslo@localhost/ser")
- please note that "my" is required in front
of sql
- and not:
- modparam("acc", "db_url",
"sql://ser:heslo@localhost/ser")
- -----Original Message-----
- From: serusers-bounces@lists.iptel.org [ mailto:serusers-bounces@lists.iptel.org]On Behalf Of
Edgardo O. Gonzales II
- Sent: Monday, April 25, 2005 5:20 PM
- To: serusers@lists.iptel.org
- Subject: Re: [Serusers] ACC into mysql
- Hi all!
- Im also receiving this error message.
- Can somebody help us on how to make accounting work using
mysql.
- thanks,
- ed
- At 06:01 AM 4/26/2005, Leon Sun wrote:
- Hi,
- I am using 0.8.12 in Fedora 3. I tried to log account info
into Mysql followed instruction from manual. I found, first,
modparam("acc", "db_url", "sql://ser:heslo@localhost/ser") coudnlt
work at all in ser.cfg. If I enabled in cfg file, it showed
Starting ser: ERROR: bad config file (1 errors)
-
- If I disabled it, SER worked fine but I couldnt see any record
in acc table.
-
- Would anyone suggest how to put call records into Mysql?
-
- Thank you.
-
- # ----------- global configuration parameters
------------------------
-
- #debug=3 #
debug level (cmd line: -dddddddddd)
- #fork=yes
- #log_stderror=no #
(cmd line: -E)
-
- /* Uncomment these lines to enter debugging mode
- debug=7
- fork=no
- log_stderror=yes
- */
-
- check_via=no # (cmd. line: -v)
- dns=no
# (cmd. line: -r)
- rev_dns=no # (cmd. line: -R)
- #port=5060
- #children=4
- fifo="/tmp/ser_fifo"
-
- # ------------------ module loading
----------------------------------
-
- # Uncomment this if you want to use SQL database
- loadmodule "/usr/lib/ser/modules/mysql.so"
-
- loadmodule "/usr/lib/ser/modules/acc.so"
- loadmodule "/usr/lib/ser/modules/sl.so"
- loadmodule "/usr/lib/ser/modules/tm.so"
- loadmodule "/usr/lib/ser/modules/rr.so"
- loadmodule "/usr/lib/ser/modules/maxfwd.so"
- loadmodule "/usr/lib/ser/modules/usrloc.so"
- loadmodule "/usr/lib/ser/modules/registrar.so"
-
- # Uncomment this if you want digest authentication
- # mysql.so must be loaded !
- loadmodule "/usr/lib/ser/modules/auth.so"
- loadmodule "/usr/lib/ser/modules/auth_db.so"
-
- # ----------------- setting module-specific parameters
---------------
-
- #modparam("acc", "db_url",
"sql://ser:heslo@localhost/ser")
-
- # -- usrloc params --
-
- #modparam("usrloc", "db_mode", 0)
-
- # Uncomment this if you want to use SQL database
- # for persistent storage and comment the previous line
- modparam("usrloc", "db_mode", 2)
-
- # -- auth params --
- # Uncomment if you are using auth module
- #
- modparam("auth_db", "calculate_ha1", yes)
- #
- # If you set "calculate_ha1" parameter to yes (which true in
this config),
- # uncomment also the following parameter)
- #
- modparam("auth_db", "password_column", "password")
-
- # -- rr params --
- # add value to ;lr param to make some broken UAs happy
- modparam("rr", "enable_full_lr", 1)
-
- modparam("acc","log_level",1)
- modparam("acc","log_flag",1)
- # ------------------------- request routing logic
-------------------
-
- # main routing logic
-
- route{
-
- # initial sanity
checks -- messages with
- # max_forwards==0,
or excessively long requests
- 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;
- };
-
- # we record-route
all messages -- to make sure that
- # subsequent
messages will go through our proxy; that's
- # particularly good
if upstream and downstream entities
- # use different
transport protocol
- record_route();
- # loose-route
processing
- if (loose_route())
{
-
if (method=="BYE") {
-
setflag(1);
-
setflag(2);
-
}
-
-
t_relay();
-
-
break;
- };
-
- #labeled all
transaction for accounting
- setflag(1);
- setflag(2);
-
- if
(method=="CANCEL"){
-
t_relay();
-
};
-
- # (in case, it does
not work, use the following command
- # with proper names
and addresses in it)
-
- if (uri==myself)
{
-
-
# This for PSTN destination
-
-
if (uri=~"^sip:1")
-
-
{ rewritehost("10.10.10.10");
-
forward(10.10.10.10,5060);
-
break;
-
}
-
if (method=="REGISTER") {
-
-
# Uncomment this if you want to use digest authentication
-
if (!www_authorize("sip.mycommunications.com", "subscriber")) {
-
www_challenge("sip.mycommunications.com", "0");
-
break;
-
};
-
-
save("location");
-
break;
-
};
-
-
# native SIP destinations are handled using our USRLOC DB
-
if (!lookup("location")) {
-
sl_send_reply("404", "Not Found");
-
break;
-
};
- };
- # forward to
current uri now; use stateful forwarding; that
- # works reliably
even if we forward from TCP to UDP
- if (!t_relay()) {
-
sl_reply_error();
- };
-
- }
- _______________________________________________
- Serusers mailing list
- serusers@lists.iptel.org
- http://lists.iptel.org/mailman/listinfo/serusers
_______________________________________________
Serusers mailing
list
serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers