Hello,

after implementing very basic pstn-routing ive tried to get accounting to a mysql database working. Unluckily with no success yet.

Ive read the acc/README, several example configs and all i could find on the mailing list archive but i still cant get it to work.

According to the docs i configure the acc module after loading like this:

--- # # Accounting Setup # modparam("acc", "db_url", "mysql://yyy:yyyy@localhost:3306/ser") modparam("acc", "log_level", 1) modparam("acc", "log_flag", 1) modparam("acc", "failed_transactions", 1) modparam("acc", "log_fmt", "miocfst") ---

Then i added "setflag(1);" at various location within my simple ser-script. First i added it just b4 the "t_relay()" then i tried various other locations until i finaly added:

--- setflag(1); setflag(2); ---

at the very start of the script.

All which happens is that the ser-router writes some errors into the syslog:

--- Jan 10 12:56:18 gk /usr/local/sbin/ser[13285]: BUG:tm:register_tmcb: no transact ion found Jan 10 12:56:18 gk /usr/local/sbin/ser[13285]: ERROR:acc:acc_onreq: cannot regis ter additional callbacks ---

and

--- Jan 10 11:51:12 gk /usr/local/sbin/ser[12694]: ERROR:acc:acc_onreq: cannot regis ter additional callbacks Jan 10 11:51:12 gk /usr/local/sbin/ser[12693]: ERROR: extract_body: message body has lenght zero Jan 10 11:51:12 gk /usr/local/sbin/ser[12693]: ERROR: force_rtp_proxy: can't ext ract body from the message Jan 10 11:51:12 gk /usr/local/sbin/ser[12693]: ERROR: on_reply processing failed ---

I am using version: --- version: ser 0.8.13-dev-23-merged (i386/linux) flags: STATS:Off, USE_IPV6, USE_TCP, DISABLE_NAGLE, DNS_IP_HACK, SHM_MEM, SHM_MMAP, PKG_MALLOC, FAST_LOCK-ADAPTIVE_WAIT ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535 @(#) $Id: main.c,v 1.174 2003/11/26 23:43:59 andrei Exp $ main.c compiled on 21:37:37 Dec 27 2003 with gcc 2.95 ---

Below you find the complete ser.cfg. Its basicly a slightly hacked version of the standard nathelper example script.

best regards,

Arnd --------------- 8< ----------- 8< ------------------ 8< ------------

debug=1 # i had this at "3" initially" fork=yes log_stderror=no # (cmd line: -E)

/* Uncomment these lines to enter debugging mode 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"

# # Aliases # alias="xxxx.net"

# ------------------ module loading ----------------------------------

# Uncomment this if you want to use SQL database loadmodule "/usr/local/lib/ser/modules/mysql.so"

loadmodule "/usr/local/lib/ser/modules/sl.so" loadmodule "/usr/local/lib/ser/modules/tm.so" loadmodule "/usr/local/lib/ser/modules/rr.so" loadmodule "/usr/local/lib/ser/modules/maxfwd.so" loadmodule "/usr/local/lib/ser/modules/usrloc.so" loadmodule "/usr/local/lib/ser/modules/registrar.so" loadmodule "/usr/local/lib/ser/modules/textops.so"

# Uncomment this if you want digest authentication # mysql.so must be loaded ! loadmodule "/usr/local/lib/ser/modules/auth.so" loadmodule "/usr/local/lib/ser/modules/auth_db.so"

# We want to earn money, therefore we need accounting loadmodule "/usr/local/lib/ser/modules/acc.so"

# !! Nathelper loadmodule "/usr/local/lib/ser/modules/nathelper.so"

# ----------------- setting module-specific parameters ---------------

# -- usrloc params -- modparam("usrloc", "db_mode", 2) modparam("usrloc", "db_url", "mysql://x:y@localhost:3306/ser")

# # Accounting Setup # modparam("acc", "db_url", "mysql://x:y@localhost:3306/ser") modparam("acc", "log_level", 1) modparam("acc", "log_flag", 1)

# Account failed transactions modparam("acc", "failed_transactions", 1)

# Which data should be accounted? # # c = Call-Id # d = To tag (Dst) # f = From # i = Inbound Request-URI # m = Method # o = Outbound Request-URI # r = fRom # s = Status # t = To # u = digest Username # p = username Part of inbound Request-URI # # default is "miocfs" # modparam("acc", "log_fmt", "miocfst")

# -- 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", "db_url", "mysql://x:y@localhost:3306/ser") 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)

# !! Nathelper modparam("registrar", "nat_flag", 6) modparam("nathelper", "natping_interval", 30) # Ping interval 30 s modparam("nathelper", "ping_nated_only", 1) # Ping only clients behind NAT

# ------------------------- request routing logic -------------------

# main routing logic

route{

# Accounting TEST # How does this work anyway? And why 1+2? setflag(1); setflag(2);

# 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; };

# !! Nathelper # Special handling for NATed clients; first, NAT test is # executed: it looks for via!=received and RFC1918 addresses # in Contact (may fail if line-folding is used); also, # the received test should, if completed, should check all # vias for rpesence of received if (nat_uac_test("3")) { # Allow RR-ed requests, as these may indicate that # a NAT-enabled proxy takes care of it; unless it is # a REGISTER

if (method == "REGISTER" || ! search("^Record-Route:")) { log("LOG: Someone trying to register from private IP, rewriting\n");

# This will work only for user agents that support symmetric # communication. We tested quite many of them and majority is # smart enough to be symmetric. In some phones it takes a configuration # option. With Cisco 7960, it is called NAT_Enable=Yes, with kphone it is # called "symmetric media" and "symmetric signalling".

fix_nated_contact(); # Rewrite contact with source IP of signalling if (method == "INVITE") { fix_nated_sdp("1"); # Add direction=active to SDP }; force_rport(); # Add rport parameter to topmost Via setflag(6); # Mark as NATed }; };

# 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 if (!method=="REGISTER") { record_route(); }

# subsequent messages withing a dialog should take the # path determined by record-routing if (loose_route()) { # mark routing logic in request append_hf("P-hint: rr-enforced\r\n"); route(1); break; };

if (!uri==myself) { # mark routing logic in request append_hf("P-hint: outbound\r\n"); route(1); 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") {

# SQL Digest Auth if (!www_authorize("", "subscriber")) { www_challenge("", "0"); break; };

save("location"); break; };

lookup("aliases"); if (!uri==myself) { append_hf("P-hint: outbound alias\r\n"); route(1); break; };

# Destination PSTN or H323? if( uri=~"^sip:9[0-9]*@mynet.net" || uri=~"^sip:8[0-9]*@mynet.net" ) { route(1); break; };

# native SIP destinations are handled using our USRLOC DB if (!lookup("location") ) { sl_send_reply("404", "Not Found"); break; }; }; append_hf("P-hint: usrloc applied\r\n"); route(1); }

route[1] { # !! Nathelper if (uri=~"[@:](192.168.|10.|172.(1[6-9]|2[0-9]|3[0-1]).)" && !search("^Route:")){ sl_send_reply("479", "We don't forward to private IP addresses"); break; };

# if client or server know to be behind a NAT, enable relay if (isflagset(6)) { force_rtp_proxy(); };

# NAT processing of replies; apply to all transactions (for example, # re-INVITEs from public to private UA are hard to identify as # NATed at the moment of request processing); look at replies t_on_reply("1");

# Route to PSTN Gateways(s) if (uri=~"^sip:9[0-9]*@mynet.net") { ## This assumes that the caller is log("Forwarding to PSTN\n"); ## registered in our realm t_relay_to_udp( "PSTN-GW", "5060" ); break; };

# Route to SIP<>H323 Proxy if (uri=~"^sip:8[0-9]*@mynet.net") { ## This assumes that the caller is log("Forwarding to SIP<>H323 Proxy\n"); ## registered in our realm t_relay_to_udp( "SIPH323-GW", "22400" ); break; };

# Local Domain User # send it out now; use stateful forwarding as it works reliably # even for UDP2TCP if (!t_relay()) { sl_reply_error(); }; }

# !! Nathelper onreply_route[1] { # NATed transaction ? if (isflagset(6) && status =~ "(183)|2[0-9][0-9]") { fix_nated_contact(); force_rtp_proxy(); # otherwise, is it a transaction behind a NAT and we did not # know at time of request processing ? (RFC1918 contacts) } else if (nat_uac_test("1")) { fix_nated_contact(); }; }