[OpenSIPS-Users] acc extra_fields param

[Pasan Meemaduma]

Hi Bogdan,
your fix worked :). Thanks for that. it converts the int properly now.
 

    On Wednesday, 14 February 2018, 14:12, Bogdan-Andrei Iancu <bogdan at opensips.org> wrote:
 

  Hi Pasan,
 
 This is for OpenSIPS 2.3:
    https://github.com/OpenSIPS/opensips/commit/42cba2c0de9cb07e31c055bc82514c14735bd2e8
 
 Regards,
  Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
  http://www.opensips-solutions.com
OpenSIPS Summit 2018
  http://www.opensips.org/events/Summit-2018Amsterdam
 On 02/14/2018 04:06 AM, Pasan Meemaduma wrote:
  
  Hi Bogdan, 
  Thanks for the response. I'll get my opensips rebuild , can you let me know the commit id so I know I got it correctly ?
   
 
      On Tuesday, 13 February 2018, 17:38, Bogdan-Andrei Iancu <bogdan at opensips.org> wrote:
  
 
    Hi Pasan,
 
 The "extra" support in ACC is always producing output as strings (when performing the DB query). Nevertheless this should not prevent you pushing integer or string values into the $acc_extra() variable. 
 
 But, it seems you discovered a BUG here :D...if the pushed value is a static int (from the script), it is not properly converted :(. I just pushed a fix on GIT repo (master and 2.3) - so please update you checkout or if using packages,  use the nightly build (of course, wait for the night :) first )
 
 Best regards,
  Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
  http://www.opensips-solutions.com
OpenSIPS Summit 2018
  http://www.opensips.org/events/Summit-2018Amsterdam
  On 02/13/2018 03:39 AM, Pasan Meemaduma via Users wrote:
  
        Hi List, 
  I'm working on getting my opensips 1.10 -> 2.3.3 :) 
  As db_extra param is not there anymore I tried to use extra_fields param in acc module and it appears it can hold string values only. Is it the  case ? 
  I tried to use it to hold an integer value and it comes up as  empty string ''. 
  
  Is it a bug or purpose set only to accept string data only ? cause  my db column has integer type for it. 
  
  following is my config 
  modparam("acc", "extra_fields", "db: fu->from_uri; ru->to_uri; islocal->islocal; callid->\"exe-callid\"; direction->direction")
  
  
  
  $acc_extra(islocal) = 1; 
  
  When call hangups it failed to insert the cdr record to acc table as  islocal comes up as ''. 
  Ex:- ERROR:db_postgres:db_postgres_submit_query: 0x7fd07fb45d18 PQsendQuery Error: ERROR:  invalid input syntax for integer: ""#012LINE 1:...sip:xx at xx;transport=UDP','','376ab2...#012                                                             ^#012 Query: insert into acc(method,from_tag,to_tag,callid,sip_code,sip_reason,time,from_uri,to_uri,islocal,"exe-callid",direction,setuptime,created,duration,ms_duration ) values('INVITE','101c267c','464b920d','6m1aTeUcif5ctoXI7ZSq9A..','200','OK','2018-02-09  17:55:41','sip:xx at xx;transport=UDP','sip:xx at xxx;transport=UDP','','376ab2da-0d66-11e8-9410-bb1806756cbd','in',11,'2018-02-09 17:55:30',4,4298)
           
  
 _______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
 
  
   
 
      
 
 

   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20180215/0b8bdc97/attachment-0001.html>