[Spce-user] Bug-Report [Rate-o-Mat and v2.2-rc1]: Dialing #21# will break rate-o-mat

[Carsten Bock]

Hi,

i just found the following bug:

When i dial "#21#" (aka. %2321%21), it will create the according CDR
in accounting.cdr:

*************************** 4. row ***************************
                      id: 79
             update_time: 2011-05-16 16:45:34
          source_user_id: fb90275f-f390-4eb6-a4c8-ea2b28bf6234
      source_provider_id: 1
             source_user: laptop
           source_domain: sip.ng-voice.com
              source_cli: 494034927219
             source_clir: 0
     destination_user_id: 0
 destination_provider_id: 0
        destination_user: %2321%23
      destination_domain: app.local
 destination_user_dialed: %2321%23
     destination_user_in: %2321%23
   destination_domain_in: sip.ng-voice.com
               call_type: call
             call_status: ok
               call_code: 200
              start_time: 2011-05-16 16:45:32
                duration: 0
                 call_id: 09D57708966463C6 at 95.118.115.160
            carrier_cost: 0.00
           reseller_cost: 0.00
           customer_cost: 0.00
  carrier_billing_fee_id: NULL
 reseller_billing_fee_id: NULL
 customer_billing_fee_id: NULL
 carrier_billing_zone_id: NULL
reseller_billing_zone_id: NULL
customer_billing_zone_id: NULL
     frag_carrier_onpeak: NULL
    frag_reseller_onpeak: NULL
    frag_customer_onpeak: NULL
           is_fragmented: NULL
                rated_at: NULL
           rating_status: unrated

With this record in the database, rate-o-mat will simply stop and no
longer start with the following error:

Use of uninitialized value $DBI::err in concatenation (.) or string at
/usr/sbin/rate-o-mat line 1271.
Use of uninitialized value $DBI::err in numeric eq (==) at
/usr/sbin/rate-o-mat line 1272.
rollback ineffective with AutoCommit enabled at /usr/sbin/rate-o-mat line 85.
rollback ineffective with AutoCommit enabled at /usr/sbin/rate-o-mat line 86.
Error rating CDR batch:

It happens in my case, when i set or delete a call-forwarding on my
CPE (AVM FritzBox 7270 (o2)). The CPE will issue the VSC/SCI-Code as a
call towards the voip-network, in order to enable/disable the
call-forwarding.
I hope, this is the right channel for bug-reports.

Kind regards,
Carsten
-- 
Carsten Bock
http://www.ng-voice.com
mailto:carsten at ng-voice.com

Schomburgstr. 80
22767 Hamburg
Germany

Mobile +49 179 2021244
Office +49 40 34927219
Fax +49 40 34927220