Hi,
I have installed A2Billing on My production server and configured it as per the recommended configuration
use_dnid=yes, use_clid=no, number_try=1 & no IVR.
Version Information Asterisk 1.8.15.0 A2Billing Version 1.9.4
Issues I am facing
1) When creating a new rate card and call plan , the simulator gives me message no matching rates found. 2) Call does not goes to the provider
below is the logs , please advice on the same.
[18/07/2013 06:04:23]:[file:Class.A2Billing.php - line:604 - uniqueid:]:[CallerID:]:[CN:]:[A2Billing AGI internal configuration:] [18/07/2013 06:04:23]:[file:Class.A2Billing.php - line:605 - uniqueid:]:[CallerID:]:[CN:]:[Array ( [dialcommand_param_call_2did] => |60|HiL(%timeout%:61000:30000) [description] => agi-config [asterisk_version] => 1_4 [answer_call] => 0 [play_audio] => 0 [say_goodbye] => 0 [play_menulanguage] => 0 [force_language] => [intro_prompt] => [min_credit_2call] => 0 [min_duration_2bill] => 0 [notenoughcredit_cardnumber] => 0 [notenoughcredit_assign_newcardnumber_cid] => 0 [use_dnid] => 1 [no_auth_dnid] => Array ( [0] => 2400 [1] => 2300 )
[number_try] => 1 [force_callplan_id] => [say_balance_after_auth] => 0 [say_balance_after_call] => 0 [say_rateinitial] => 0 [say_timetocall] => 1 [auto_setcallerid] => 1 [force_callerid] => [cid_sanitize] => 0 [cid_enable] => 0 [cid_askpincode_ifnot_callerid] => 0 [failover_lc_prefix] => 0 [cid_auto_assign_card_to_cid] => 0 [callerid_authentication_over_cardnumber] => 0 [sip_iax_friends] => 0 [sip_iax_pstn_direct_call_prefix] => [sip_iax_pstn_direct_call] => 0 [ivr_voucher] => 0 [ivr_voucher_prefix] => 8 [jump_voucher_if_min_credit] => 0 [dialcommand_param] => |60|HRrL(%timeout%:61000:30000) [dialcommand_param_sipiax_friend] => |60|HiL(3600000:61000:30000) [switchdialcommand] => 0 [failover_recursive_limit] => 2 [maxtime_tocall_negatif_free_route] => 5400 [send_reminder] => 0 [record_call] => 0 [monitor_formatfile] => gsm [agi_force_currency] => [currency_association] => Array ( [0] => usd:dollars [1] => mxn:pesos [2] => eur:euros [3] => all:credit )
[local_dialing_addcountryprefix] => 0 [max_call_call_2_did] => 3600 [file_conf_enter_destination] => prepaid-enter-dest [conf_order_menulang] => en:fr:es [callback_bill_1stleg_ifcall_notconnected] => 1 [international_prefixes] => Array ( [0] => )
[extracharge_did] => Array ( [0] => 1800 [1] => 1900 )
[extracharge_fee] => Array ( [0] => 0 [1] => 0 )
[extracharge_buyfee] => Array ( [0] => 0 [1] => 0 )
[maxtime_tounlimited_calls] => 5400 [maxtime_tofree_calls] => 5400 [callplan_deck_minute_threshold] => [disable_announcement_seconds] => 0 [verbosity_level] => 4 [logging_level] => 4 [dial_balance_reservation] => 0.25 [callerid_update] => 0 [cid_auto_create_card] => 0 [cid_auto_create_card_len] => 10 [cid_auto_create_card_typepaid] => PREPAID [cid_auto_create_card_credit] => 0 [cid_auto_create_card_credit_limit] => 0 [cid_auto_create_card_tariffgroup] => 1 [busy_timeout] => 1 [callback_reduce_balance] => 1 [ivr_enable_locking_option] => 0 [ivr_enable_account_information] => 0 [ivr_enable_ivr_speeddial] => 0 [play_rate_cents_if_lower_one] => 0 [callback_beep_to_enter_destination] => 0 [cid_prompt_callback_confirm_phonenumber] => 0 [logger_enable] => 1 [log_file] => /var/log/a2billing/a2billing.log [dialcommand_param_call_2did ] => |30|HL(3600000:61000:30000) [currency_association_internal] => Array ( [usd] => dollars [mxn] => pesos [eur] => euros [all] => credit )
[file_conf_enter_menulang] => prepaid-menulang [ivr_voucher_prefixe] => 8 [cheat_on_announcement_time] => 0 ) ] [18/07/2013 06:04:23]:[file:a2billing.php - line:106 - uniqueid:]:[CallerID:]:[CN:]:[IDCONFIG : 1] [18/07/2013 06:04:23]:[file:a2billing.php - line:107 - uniqueid:]:[CallerID:]:[CN:]:[MODE : standard] [18/07/2013 06:04:23]:[file:a2billing.php - line:124 - uniqueid:]:[CallerID:]:[CN:]:[AGI Request: Array ( [agi_request] => a2billing.php [agi_channel] => SIP/5993917633-0000003b [agi_language] => en [agi_type] => SIP [agi_uniqueid] => 1374141861.59 [agi_version] => 1.8.15.0 [agi_callerid] => 5993917633 [agi_calleridname] => 5993917633 [agi_callingpres] => 0 [agi_callingani2] => 0 [agi_callington] => 0 [agi_callingtns] => 0 [agi_dnid] => 13057534330 [agi_rdnis] => unknown [agi_context] => a2billing [agi_extension] => 13057534330 [agi_priority] => 3 [agi_enhanced] => 0.0 [agi_accountcode] => 5993917633 [agi_threadid] => -1251402896 [agi_arg_1] => 1 ) ] [18/07/2013 06:04:23]:[file:a2billing.php - line:126 - uniqueid:]:[CallerID:]:[CN:]:[[INFO : A2Billing - Version 1.9.4 (Cuprum)]] [18/07/2013 06:04:23]:[file:Class.A2Billing.php - line:718 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:]:[ get_agi_request_parameter = 5993917633 ; SIP/5993917633-0000003b ; 1374141861.59 ; 5993917633 ; 13057534330] [18/07/2013 06:04:23]:[file:Class.Table.php - line:182 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:]:[Running time=0.0032191276550293 - QUERY= SELECT id, currency, name, value FROM cc_currencies ORDER BY id ] [18/07/2013 06:04:23]:[file:a2billing.php - line:166 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:]:[[NO ANSWER CALL]] [18/07/2013 06:04:23]:[file:Class.A2Billing.php - line:2721 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:]:[ - Account code ::> 5993917633] [18/07/2013 06:04:23]:[file:Class.Table.php - line:182 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[Running time=0.00098299980163574 - QUERY= SELECT credit, tariff, activated, inuse, simultaccess, typepaid, creditlimit, language, removeinterprefix, redial, enableexpire, UNIX_TIMESTAMP(expirationdate), expiredays, nbused, UNIX_TIMESTAMP(firstusedate), UNIX_TIMESTAMP(cc_card.creationdate), cc_card.currency, cc_card.lastname, cc_card.firstname, cc_card.email, cc_card.uipass, cc_card.id_campaign, cc_card.id, useralias, status, voicemail_permitted, voicemail_activated, cc_card.restriction, cc_country.countryprefix FROM cc_card LEFT JOIN cc_tariffgroup ON tariff=cc_tariffgroup.id LEFT JOIN cc_country ON cc_card.country=cc_country.countrycode WHERE username='5993917633' ] [18/07/2013 06:04:23]:[file:Class.A2Billing.php - line:2738 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[ - Retrieve account info SQL ::> SELECT credit, tariff, activated, inuse, simultaccess, typepaid, creditlimit, language, removeinterprefix, redial, enableexpire, UNIX_TIMESTAMP(expirationdate), expiredays, nbused, UNIX_TIMESTAMP(firstusedate), UNIX_TIMESTAMP(cc_card.creationdate), cc_card.currency, cc_card.lastname, cc_card.firstname, cc_card.email, cc_card.uipass, cc_card.id_campaign, cc_card.id, useralias, status, voicemail_permitted, voicemail_activated, cc_card.restriction, cc_country.countryprefix FROM cc_card LEFT JOIN cc_tariffgroup ON tariff=cc_tariffgroup.id LEFT JOIN cc_country ON cc_card.country=cc_country.countrycode WHERE username='5993917633'] [18/07/2013 06:04:23]:[file:Class.A2Billing.php - line:2807 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[[SET CHANNEL(language) en]] [18/07/2013 06:04:23]:[file:Class.A2Billing.php - line:2811 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[[credit=5.00000 :: tariff=1 :: status=1 :: isused=0 :: simultaccess=1 :: typepaid=0 :: creditlimit= :: language=en]] [18/07/2013 06:04:23]:[file:Class.A2Billing.php - line:750 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[[CARD STATUS UPDATE]] [18/07/2013 06:04:23]:[file:Class.Table.php - line:182 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[Running time=0.00039100646972656 - QUERY= UPDATE cc_card SET inuse=inuse+1, credit=credit-0.25 WHERE username='5993917633' ] [18/07/2013 06:04:23]:[file:Class.A2Billing.php - line:759 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[[QUERY USING CARD UPDATE::> UPDATE cc_card SET inuse=inuse+1, credit=credit-0.25 WHERE username='5993917633']] [18/07/2013 06:04:23]:[file:a2billing.php - line:178 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[[TRY : callingcard_ivr_authenticate]] [18/07/2013 06:04:23]:[file:Class.A2Billing.php - line:2392 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[[AUTO SetCallerID]] [18/07/2013 06:04:23]:[file:Class.A2Billing.php - line:2398 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[[REQUESTED SetCallerID : 5993917633]] [18/07/2013 06:04:23]:[file:Class.A2Billing.php - line:2410 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[[EXEC SetCallerID : 5993917633]] [18/07/2013 06:04:23]:[file:a2billing.php - line:193 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[[CHANNEL STATUS : 6 = Line is up] [CREDIT : 5.00000][CREDIT MIN_CREDIT_2CALL : 0]] [18/07/2013 06:04:23]:[file:a2billing.php - line:396 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[TARIFF ID -> 1] [18/07/2013 06:04:23]:[file:a2billing.php - line:566 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[CALL SIP_IAX_BUDDY] [18/07/2013 06:04:23]:[file:Class.Table.php - line:182 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[Running time=0.00034189224243164 - QUERY= UPDATE cc_card SET redial = '13057534330' WHERE username='5993917633' ] [18/07/2013 06:04:23]:[file:Class.A2Billing.php - line:3551 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[[SAVING DESTINATION FOR REDIAL: SQL: UPDATE cc_card SET redial = '13057534330' WHERE username='5993917633']:[result: 1]] [18/07/2013 06:04:23]:[file:Class.A2Billing.php - line:1086 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[SIP o IAX DESTINATION : 13057534330] [18/07/2013 06:04:23]:[file:Class.Table.php - line:182 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[Running time=0.00027203559875488 - QUERY= SELECT name, cc_card.username FROM cc_iax_buddies, cc_card WHERE cc_iax_buddies.id_cc_card=cc_card.id AND useralias='13057534330' ] [18/07/2013 06:04:23]:[file:Class.A2Billing.php - line:1092 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[] [18/07/2013 06:04:23]:[file:Class.Table.php - line:182 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[Running time=0.0002598762512207 - QUERY= SELECT name, cc_card.username FROM cc_sip_buddies, cc_card WHERE cc_sip_buddies.id_cc_card=cc_card.id AND useralias='13057534330' ] [18/07/2013 06:04:23]:[file:Class.A2Billing.php - line:1103 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[RESULT : ] [18/07/2013 06:04:23]:[file:Class.A2Billing.php - line:750 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[[CARD STATUS UPDATE]] [18/07/2013 06:04:23]:[file:Class.Table.php - line:182 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[Running time=0.00028181076049805 - QUERY= UPDATE cc_card SET inuse=inuse-1, credit=credit+0.25 WHERE username='5993917633' ] [18/07/2013 06:04:23]:[file:Class.A2Billing.php - line:759 - uniqueid:1374141861.59]:[CallerID:5993917633]:[CN:5993917633]:[[QUERY USING CARD UPDATE::> UPDATE cc_card SET inuse=inuse-1, credit=credit+0.25 WHERE username='5993917633']] [18/07/2013 06:04:23]:[CallerID:5993917633]:[CN:5993917633]:[[exit]] [18/07/2013 06:06:16]:[file:Class.A2Billing.php - line:604 - uniqueid:]:[CallerID:]:[CN:]:[A2Billing AGI internal configuration:] [18/07/2013 06:06:16]:[file:Class.A2Billing.php - line:605 - uniqueid:]:[CallerID:]:[CN:]:[Array ( [dialcommand_param_call_2did] => |60|HiL(%timeout%:61000:30000) [description] => agi-config [asterisk_version] => 1_4 [answer_call] => 0 [play_audio] => 0 [say_goodbye] => 0 [play_menulanguage] => 0 [force_language] => [intro_prompt] => [min_credit_2call] => 0 [min_duration_2bill] => 0 [notenoughcredit_cardnumber] => 0 [notenoughcredit_assign_newcardnumber_cid] => 0 [use_dnid] => 1 [no_auth_dnid] => Array ( [0] => 2400 [1] => 2300 )
[number_try] => 1 [force_callplan_id] => [say_balance_after_auth] => 0 [say_balance_after_call] => 0 [say_rateinitial] => 0 [say_timetocall] => 1 [auto_setcallerid] => 1 [force_callerid] => [cid_sanitize] => 0 [cid_enable] => 0 [cid_askpincode_ifnot_callerid] => 0 [failover_lc_prefix] => 0 [cid_auto_assign_card_to_cid] => 0 [callerid_authentication_over_cardnumber] => 0 [sip_iax_friends] => 0 [sip_iax_pstn_direct_call_prefix] => [sip_iax_pstn_direct_call] => 0 [ivr_voucher] => 0 [ivr_voucher_prefix] => 8 [jump_voucher_if_min_credit] => 0 [dialcommand_param] => |60|HRrL(%timeout%:61000:30000) [dialcommand_param_sipiax_friend] => |60|HiL(3600000:61000:30000) [switchdialcommand] => 0 [failover_recursive_limit] => 2 [maxtime_tocall_negatif_free_route] => 5400 [send_reminder] => 0 [record_call] => 0 [monitor_formatfile] => gsm [agi_force_currency] => [currency_association] => Array ( [0] => usd:dollars [1] => mxn:pesos [2] => eur:euros [3] => all:credit )
[local_dialing_addcountryprefix] => 0 [max_call_call_2_did] => 3600 [file_conf_enter_destination] => prepaid-enter-dest [conf_order_menulang] => en:fr:es [callback_bill_1stleg_ifcall_notconnected] => 1 [international_prefixes] => Array ( [0] => )
[extracharge_did] => Array ( [0] => 1800 [1] => 1900 )
[extracharge_fee] => Array ( [0] => 0 [1] => 0 )
[extracharge_buyfee] => Array ( [0] => 0 [1] => 0 )
[maxtime_tounlimited_calls] => 5400 [maxtime_tofree_calls] => 5400 [callplan_deck_minute_threshold] => [disable_announcement_seconds] => 0 [verbosity_level] => 4 [logging_level] => 4 [dial_balance_reservation] => 0.25 [callerid_update] => 0 [cid_auto_create_card] => 0 [cid_auto_create_card_len] => 10 [cid_auto_create_card_typepaid] => PREPAID [cid_auto_create_card_credit] => 0 [cid_auto_create_card_credit_limit] => 0 [cid_auto_create_card_tariffgroup] => 1 [busy_timeout] => 1 [callback_reduce_balance] => 1 [ivr_enable_locking_option] => 0 [ivr_enable_account_information] => 0 [ivr_enable_ivr_speeddial] => 0 [play_rate_cents_if_lower_one] => 0 [callback_beep_to_enter_destination] => 0 [cid_prompt_callback_confirm_phonenumber] => 0 [logger_enable] => 1 [log_file] => /var/log/a2billing/a2billing.log [dialcommand_param_call_2did ] => |30|HL(3600000:61000:30000) [currency_association_internal] => Array ( [usd] => dollars [mxn] => pesos [eur] => euros [all] => credit )
[file_conf_enter_menulang] => prepaid-menulang [ivr_voucher_prefixe] => 8 [cheat_on_announcement_time] => 0 ) ] [18/07/2013 06:06:16]:[file:a2billing.php - line:106 - uniqueid:]:[CallerID:]:[CN:]:[IDCONFIG : 1] [18/07/2013 06:06:16]:[file:a2billing.php - line:107 - uniqueid:]:[CallerID:]:[CN:]:[MODE : standard] [18/07/2013 06:06:17]:[file:a2billing.php - line:124 - uniqueid:]:[CallerID:]:[CN:]:[AGI Request: Array ( [agi_request] => a2billing.php [agi_channel] => SIP/5993917633-0000003c [agi_language] => en [agi_type] => SIP [agi_uniqueid] => 1374141975.60 [agi_version] => 1.8.15.0 [agi_callerid] => 5993917633 [agi_calleridname] => 5993917633 [agi_callingpres] => 0 [agi_callingani2] => 0 [agi_callington] => 0 [agi_callingtns] => 0 [agi_dnid] => 13057534330 [agi_rdnis] => unknown [agi_context] => a2billing [agi_extension] => 13057534330 [agi_priority] => 3 [agi_enhanced] => 0.0 [agi_accountcode] => 5993917633 [agi_threadid] => -1251402896 [agi_arg_1] => 1 ) ] [18/07/2013 06:06:17]:[file:a2billing.php - line:126 - uniqueid:]:[CallerID:]:[CN:]:[[INFO : A2Billing - Version 1.9.4 (Cuprum)]] [18/07/2013 06:06:17]:[file:Class.A2Billing.php - line:718 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:]:[ get_agi_request_parameter = 5993917633 ; SIP/5993917633-0000003c ; 1374141975.60 ; 5993917633 ; 13057534330] [18/07/2013 06:06:17]:[file:Class.Table.php - line:182 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:]:[Running time=0.00093388557434082 - QUERY= SELECT id, currency, name, value FROM cc_currencies ORDER BY id ] [18/07/2013 06:06:17]:[file:a2billing.php - line:166 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:]:[[NO ANSWER CALL]] [18/07/2013 06:06:17]:[file:Class.A2Billing.php - line:2721 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:]:[ - Account code ::> 5993917633] [18/07/2013 06:06:17]:[file:Class.Table.php - line:182 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[Running time=0.0010631084442139 - QUERY= SELECT credit, tariff, activated, inuse, simultaccess, typepaid, creditlimit, language, removeinterprefix, redial, enableexpire, UNIX_TIMESTAMP(expirationdate), expiredays, nbused, UNIX_TIMESTAMP(firstusedate), UNIX_TIMESTAMP(cc_card.creationdate), cc_card.currency, cc_card.lastname, cc_card.firstname, cc_card.email, cc_card.uipass, cc_card.id_campaign, cc_card.id, useralias, status, voicemail_permitted, voicemail_activated, cc_card.restriction, cc_country.countryprefix FROM cc_card LEFT JOIN cc_tariffgroup ON tariff=cc_tariffgroup.id LEFT JOIN cc_country ON cc_card.country=cc_country.countrycode WHERE username='5993917633' ] [18/07/2013 06:06:17]:[file:Class.A2Billing.php - line:2738 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[ - Retrieve account info SQL ::> SELECT credit, tariff, activated, inuse, simultaccess, typepaid, creditlimit, language, removeinterprefix, redial, enableexpire, UNIX_TIMESTAMP(expirationdate), expiredays, nbused, UNIX_TIMESTAMP(firstusedate), UNIX_TIMESTAMP(cc_card.creationdate), cc_card.currency, cc_card.lastname, cc_card.firstname, cc_card.email, cc_card.uipass, cc_card.id_campaign, cc_card.id, useralias, status, voicemail_permitted, voicemail_activated, cc_card.restriction, cc_country.countryprefix FROM cc_card LEFT JOIN cc_tariffgroup ON tariff=cc_tariffgroup.id LEFT JOIN cc_country ON cc_card.country=cc_country.countrycode WHERE username='5993917633'] [18/07/2013 06:06:17]:[file:Class.A2Billing.php - line:2807 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[[SET CHANNEL(language) en]] [18/07/2013 06:06:17]:[file:Class.A2Billing.php - line:2811 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[[credit=5.00000 :: tariff=1 :: status=1 :: isused=0 :: simultaccess=1 :: typepaid=0 :: creditlimit= :: language=en]] [18/07/2013 06:06:17]:[file:Class.A2Billing.php - line:750 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[[CARD STATUS UPDATE]] [18/07/2013 06:06:17]:[file:Class.Table.php - line:182 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[Running time=0.00046396255493164 - QUERY= UPDATE cc_card SET inuse=inuse+1, credit=credit-0.25 WHERE username='5993917633' ] [18/07/2013 06:06:17]:[file:Class.A2Billing.php - line:759 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[[QUERY USING CARD UPDATE::> UPDATE cc_card SET inuse=inuse+1, credit=credit-0.25 WHERE username='5993917633']] [18/07/2013 06:06:17]:[file:a2billing.php - line:178 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[[TRY : callingcard_ivr_authenticate]] [18/07/2013 06:06:17]:[file:Class.A2Billing.php - line:2392 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[[AUTO SetCallerID]] [18/07/2013 06:06:17]:[file:Class.A2Billing.php - line:2398 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[[REQUESTED SetCallerID : 5993917633]] [18/07/2013 06:06:17]:[file:Class.A2Billing.php - line:2410 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[[EXEC SetCallerID : 5993917633]] [18/07/2013 06:06:17]:[file:a2billing.php - line:193 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[[CHANNEL STATUS : 6 = Line is up] [CREDIT : 5.00000][CREDIT MIN_CREDIT_2CALL : 0]] [18/07/2013 06:06:17]:[file:a2billing.php - line:396 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[TARIFF ID -> 1] [18/07/2013 06:06:17]:[file:a2billing.php - line:566 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[CALL SIP_IAX_BUDDY] [18/07/2013 06:06:17]:[file:Class.Table.php - line:182 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[Running time=0.00026988983154297 - QUERY= UPDATE cc_card SET redial = '13057534330' WHERE username='5993917633' ] [18/07/2013 06:06:17]:[file:Class.A2Billing.php - line:3551 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[[SAVING DESTINATION FOR REDIAL: SQL: UPDATE cc_card SET redial = '13057534330' WHERE username='5993917633']:[result: 1]] [18/07/2013 06:06:17]:[file:Class.A2Billing.php - line:1086 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[SIP o IAX DESTINATION : 13057534330] [18/07/2013 06:06:17]:[file:Class.Table.php - line:182 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[Running time=0.00026798248291016 - QUERY= SELECT name, cc_card.username FROM cc_iax_buddies, cc_card WHERE cc_iax_buddies.id_cc_card=cc_card.id AND useralias='13057534330' ] [18/07/2013 06:06:17]:[file:Class.A2Billing.php - line:1092 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[] [18/07/2013 06:06:17]:[file:Class.Table.php - line:182 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[Running time=0.00032305717468262 - QUERY= SELECT name, cc_card.username FROM cc_sip_buddies, cc_card WHERE cc_sip_buddies.id_cc_card=cc_card.id AND useralias='13057534330' ] [18/07/2013 06:06:17]:[file:Class.A2Billing.php - line:1103 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[RESULT : ] [18/07/2013 06:06:17]:[file:Class.A2Billing.php - line:750 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[[CARD STATUS UPDATE]] [18/07/2013 06:06:17]:[file:Class.Table.php - line:182 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[Running time=0.00034594535827637 - QUERY= UPDATE cc_card SET inuse=inuse-1, credit=credit+0.25 WHERE username='5993917633' ] [18/07/2013 06:06:17]:[file:Class.A2Billing.php - line:759 - uniqueid:1374141975.60]:[CallerID:5993917633]:[CN:5993917633]:[[QUERY USING CARD UPDATE::> UPDATE cc_card SET inuse=inuse-1, credit=credit+0.25 WHERE username='5993917633']] [18/07/2013 06:06:17]:[CallerID:5993917633]:[CN:5993917633]:[[exit]]
Thanks in advance
Best Regards Chetan Jha +91 9930573730
|