[Serusers] missed_calls username and domain

[Rafael R. GV]

Hi
you have to include "username Part of inbound Request-URI" in the
accounting packet using log_fmt parameter:

modparam("acc", "log_fmt", "miocfsp")  #  p = username Part of inbound
Request-URI

rafael

On 8/19/05, Ah khng <akhng999 at gmail.com> wrote:
>  Hi all,
>  
>  I want to display missed calls in SERWEB, so i use acc_db_request to store
> the entry into table missed_calls. However, username and domain weren't
> recorded into database. While i noticed that serweb is comparing username
> and domain in sql WHERE cluase (method.get_missed_calls.php) which cause no
> records being display.
>  
>  Thus, how do i make domain and username recorded into database? 
>  
>  # -- accounting parameters --
>  modparam("acc", "log_level", 1)
>  modparam("acc", "db_missed_flag", 3)
>  modparam("acc", "db_flag", 1)
>  modparam("acc", "failed_transactions", 1)
>  modparam("acc", "report_cancels", 1)
>  
>  failure_route[1] {
>          # we account missed incoming calls; previous statteful processing
>          # guarantees that retransmissions are not accounted
>          acc_db_request("missed calls","missed_calls");
>          revert_uri();
>          if (t_check_status("486") || t_check_status("603")) {
>                  log(1,"User busy\n");
>          } else if (t_check_status("480") || t_check_status("408")) {
>                  log(1,"User is unavailable\n");
>          } else {
>                  log(1,"User is unavailable for unknown reason\n");
>          }
>          
>          rewritehostport("202.73.10.7:5060");
>          append_branch();
>          t_relay_to_udp("202.73.10.7", "5060");
>                                                            
>                                        
>  }
>  
>  
>  mysql> select
> sip_from,sip_status,sip_method,username,domain from
> missed_calls;
> +----------------------------------------------+--------------+------------+----------+--------+
>  | sip_from                                     |
> sip_status   | sip_method | username | domain |
> +----------------------------------------------+--------------+------------+----------+--------+
>  | <sip:10001 at 202.73.10.8>;tag=ff2015eeb8c23171 | missed calls | INVITE    
> | n/a      | n/a    |
>  | <sip:10001 at 202.73.10.8>;tag=ff2015eeb8c23171 | missed calls | CANCEL    
> | n/a      | n/a    |
>  | <sip:10001 at 202.73.10.8>;tag=688a799e25d70d76 | missed calls | INVITE    
> | n/a      | n/a    |
>  | <sip:10001 at 202.73.10.8>;tag=9da5279e291e12cc | missed calls | INVITE    
> | n/a      | n/a    |
>  | <sip:10001 at 202.73.10.8>;tag=1fbde47420f30ff2 | missed calls | INVITE    
> | n/a      | n/a    |
>  | <sip:10001 at 202.73.10.8>;tag=bde153a0cf74ce23 | missed calls | INVITE    
> | n/a      | n/a    |
>  | <sip:10001 at 202.73.10.8>;tag=bc3362f1cb8b0f64 | missed calls | INVITE    
> | n/a      | n/a    |
> +----------------------------------------------+--------------+------------+----------+--------+
>  9 rows in set (0.00 sec)
>  
>  Regards
>  Seong
>  
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
> 
> 
> 


-- 

rrgv