[Users] CDR error

Klaus Darilion klaus.mailinglists at pernau.at
Mon Oct 3 09:57:43 CEST 2005


jayesh nambiar wrote:
> hi everybody,
> I've just put my openser 0.9.5 in the production environment and it 
> works well. For now, I jus use a query to extract the CDR 
> as "call_date", "orig_number", "termination_number", "duration" and 
> "src_ip".
> but when the volume is very large I get the following problem. The 
> scenario is as follows.
>  
> call_date                  | orig_number             | 
> term_number                     | duration   | src_ip
> 2005-09-25 20:45:30 | 203 at my_sip_server | 
> 56924536 at my_sip_server | 
> 14:00:30   X.X.X.X 
>  
> 2005-09-25 20:45:30 |56924356 at my_sip_server | 43234123 at my_sip_server 
> | 4:00:30   X.X.X.X 
>  
> I get the same number as the origination number which was the 

they are different:
56924536 at my_sip_server
56924356 at my_sip_server
      ^^

are they real different or is this a type?

I always used the SQL query from serweb (the accouting tab) to match CDRs.

regards
klaus

> destination number some moments before, when in reality it is not 
> possible to call from that particular number.
> But this only happens when the calling volume is really large. Does 
> anyone have any idea regarding this.
> If you want to see the query I can do that.
> pls share if there is some better query to generate the CDR..
>  
> I have also downloaded the latest version 0.10.x from CVS head. Can 
> somebody tell me how stable is it for the production environment.
>  
> thanx
> jayesh
> 
> ------------------------------------------------------------------------
> Yahoo! for Good
> Click here to donate <http://store.yahoo.com/redcross-donate3/> to the 
> Hurricane Katrina relief effort.
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users





More information about the Users mailing list