[Serusers] SER loging and MySQL problems

[Klaus Darilion]

Hi John!

Please send your emails always to the list!

Have you enabled mysql logging in the Makefile of the acc module?

http://lists.iptel.org/pipermail/serusers/2004-April/007534.html
http://lists.iptel.org/pipermail/serusers/2004-April/007579.html
http://lists.iptel.org/pipermail/serdev/2003-November/000860.html
http://lists.iptel.org/pipermail/serusers/2004-February/006206.html

regards,
klaus

John Morrell wrote:

> Thanks Klaus, but I have tried various examples with the inclusion of the
> acc module. I am not getting anything logged in /var/log/messages
> 
> John.
> 
> ----- Original Message ----- 
> From: "Klaus Darilion" <klaus.mailinglists at pernau.at>
> To: "John Morrell" <john.morrell at aqcorporate.com>
> Cc: <serusers at lists.iptel.org>
> Sent: Thursday, July 01, 2004 10:53 AM
> Subject: Re: [Serusers] SER loging and MySQL problems
> 
> 
> 
>>Have you really read the manual?
>>http://iptel.org/ser/doc/seruser/seruser.html
>>There's a section called "Accounting".
>>
>>You have to use the acc module. Take also a look at the README of the
>>acc module.
>>
>>klaus
>>
>>John Morrell wrote:
>>
>>>I have ser-0.8.12 setup on Red Hat along with MySQL and SerWeb. Calls
> 
> are
> 
>>>being routed ok, but I can not seem to achieve any sort of logging or
>>>accounting of what is going on. I've followed examples and tutorials but
>>>still not progressed much further than routing the calls. I have
> 
> included my
> 
>>>ser.cfg below.
>>>
>>>
>>>#
>>># $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15 andrei Exp $
>>>#
>>># simple quick-start config script
>>>#
>>>
>>># ----------- 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=yes
>>>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/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 ---------------
>>>
>>># -- 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)
>>>modparam("usrloc", "db_url", "sql://ser:******@localhost/ser")
>>>
>>># -- auth params --
>>># Uncomment if you are using auth module
>>>#
>>>modparam("auth_db", "password_column", "password")
>>>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", "db_url", "sql://ser:******@localhost/ser")
>>>
>>># -- rr params --
>>># add value to ;lr param to make some broken UAs happy
>>>modparam("rr", "enable_full_lr", 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()) {
>>>  t_relay();
>>>  break;
>>> };
>>>
>>> # if the request is for other domain use UsrLoc
>>> # (in case, it does not work, use the following command
>>> # with proper names and addresses in it)
>>> if (uri==myself) {
>>>
>>>  if (method=="REGISTER") {
>>>
>>># Uncomment this if you want to use digest authentication
>>>#   if (!www_authorize("iptel.org", "subscriber")) {
>>>#    www_challenge("iptel.org", "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 at lists.iptel.org
>>>http://lists.iptel.org/mailman/listinfo/serusers
>>>
>>>
>>
> 
>