Personal Ola, my name is wellington, I am of Brazil, and am having problems in the hour that I make linking… sees log…
a2billing.log
Code:
AND startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL OR LENGTH(expirationdate)<5)
AND startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR stopdate IS NULL OR LENGTH(stopdate)<5)
AND (starttime <= 2151 AND endtime >=2151)
AND idtariffgroup='30'
AND ( cc_tariffplan.dnidprefix LIKE '1158230485%' OR (cc_tariffplan.dnidprefix='all' AND 0 = 0))
ORDER BY LENGTH(dialprefix) DESC
[22/05/2007 11:51:47]:[CallerID:23216]:[CN:2024790729]:[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:37500]
[22/05/2007 11:51:53]:[CallerID:23216]:[CN:2024790729]:DIAL SIP/proveedorsip/011551158230485|70|rL(37500000)
[22/05/2007 11:51:53]:[CallerID:23216]:[CN:2024790729]:[K=0]:[ANSWEREDTIME=-DIALSTATUS=]
[22/05/2007 11:51:53]:[CallerID:23216]:[CN:2024790729]:[USEDRATECARD=0]
[22/05/2007 11:51:53]:[CallerID:23216]:[CN:2024790729]:[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=0 - (sessiontime=0 :: dialstatus= :: buycost=0 :: cost= : signe_cc_call=-: signe=+)]
[22/05/2007 11:51:53]:[CallerID:23216]:[CN:2024790729]:[CC_asterisk_stop 1.1: SQL: INSERT INTO cc_call (uniqueid,sessionid,username,nasipaddress,starttime,sessiontime, calledstation, terminatecause, stoptime, calledrate, sessionbill, calledcountry, calledsub, destination, id_tariffgroup, id_tariffplan, id_ratecard, id_trunk, src, sipiax, buyrate, buycost) VALUES ('1179849104.12', 'SIP/2024790729-092c7098', '2024790729', '', CURRENT_TIMESTAMP - INTERVAL 0 SECOND , '0', '1158230485', '', now(), '0.4', '-0', '', '', 'BRASIL SAMPA', '30', '45', '351694', '27', '23216', '0', '0.09', '0')]
[22/05/2007 11:51:53]:[CallerID:23216]:[CN:2024790729]:[CC_asterisk_stop 1.1: SQL: DONE : result=1]
[22/05/2007 11:51:53]:[CallerID:23216]:[CN:2024790729]:[callingcard_acct_stop]
[22/05/2007 11:51:53]:[CallerID:23216]:[CN:2024790729]:[Start: UPDATE cc_card SET inuse=inuse-1 WHERE username='2024790729']
[22/05/2007 11:51:53]:[CallerID:23216]:[CN:2024790729]:[exit]
asterisk -vvvvr
Code:
a2billing.php|1: line:58 - IDCONFIG : 1
a2billing.php|1:
a2billing.php|1: line:67 - MODE : standard
a2billing.php|1:
a2billing.php|1: A2Billing AGI internal configuration:
a2billing.php|1: Array
a2billing.php|1: (
a2billing.php|1: [debug] => 1
a2billing.php|1: [logger_enable] => 1
a2billing.php|1: [log_file] => /tmp/a2billing.log
a2billing.php|1: [say_goodbye] =>
a2billing.php|1: [play_menulanguage] =>
a2billing.php|1: [force_language] =>
a2billing.php|1: [intro_prompt] =>
a2billing.php|1: [len_cardnumber] => 6
a2billing.php|1: [len_aliasnumber] => 6
a2billing.php|1: [len_voucher] => 10
a2billing.php|1: [min_credit_2call] => 0
a2billing.php|1: [min_duration_2bill] => 0
a2billing.php|1: [notenoughcredit_cardnumber] => 1
a2billing.php|1: [notenoughcredit_assign_newcardnumber_cid] => 1
a2billing.php|1: [use_dnid] => 1
a2billing.php|1: [no_auth_dnid] => Array
a2billing.php|1: (
a2billing.php|1: [0] => 2400
a2billing.php|1: [1] => 2300
a2billing.php|1: )
a2billing.php|1:
a2billing.php|1: [number_try] => 1
a2billing.php|1: [say_balance_after_auth] =>
a2billing.php|1: [say_balance_after_call] =>
a2billing.php|1: [say_rateinitial] =>
a2billing.php|1: [say_timetocall] =>
a2billing.php|1: [auto_setcallerid] =>
a2billing.php|1: [force_callerid] =>
a2billing.php|1: [cid_sanitize] =>
a2billing.php|1: [cid_enable] =>
a2billing.php|1: [cid_askpincode_ifnot_callerid] => 1
a2billing.php|1: [cid_auto_create_card] =>
a2billing.php|1: [cid_auto_assign_card_to_cid] => 1
a2billing.php|1: [cid_auto_create_card_typepaid] => PREPAY
a2billing.php|1: [cid_auto_create_card_credit] => 0
a2billing.php|1: [cid_auto_create_card_credit_limit] => 1000
a2billing.php|1: [cid_auto_create_card_tariffgroup] => 6
a2billing.php|1: [callerid_authentication_over_cardnumber] =>
a2billing.php|1: [sip_iax_friends] =>
a2billing.php|1: [sip_iax_pstn_direct_call_prefix] => 9
a2billing.php|1: [sip_iax_pstn_direct_call] =>
a2billing.php|1: [extracharge_did] => Array
a2billing.php|1: (
a2billing.php|1: [0] =>
a2billing.php|1: )
a2billing.php|1:
a2billing.php|1: [extracharge_fee] => Array
a2billing.php|1: (
a2billing.php|1: [0] =>
a2billing.php|1: )
a2billing.php|1:
a2billing.php|1: [dialcommand_param] => |70|rL(%timeout%)
a2billing.php|1: [dialcommand_param_sipiax_friend] => |30|HL(3600000:61000:40000)
a2billing.php|1: [switchdialcommand] =>
a2billing.php|1: [maxtime_tocall_negatif_free_route] => 5400
a2billing.php|1: [send_reminder] =>
a2billing.php|1: [record_call] =>
a2billing.php|1: [monitor_formatfile] => gsm
a2billing.php|1: [base_currency] => R$
a2billing.php|1: [agi_force_currency] =>
a2billing.php|1: [currency_association] => Array
a2billing.php|1: (
a2billing.php|1: [0] => usd:prepaid-dollar
a2billing.php|1: [1] => mxn:pesos
a2billing.php|1: [2] => eur:euro
a2billing.php|1: [3] => all:credit
a2billing.php|1: )
a2billing.php|1:
a2billing.php|1: [file_conf_enter_destination] => prepaid-enter-dest
a2billing.php|1: [file_conf_enter_menulang] => prepaid-menulang2
a2billing.php|1: [answer_call] => 1
a2billing.php|1: [currency_association_internal] => Array
a2billing.php|1: (
a2billing.php|1: [usd] => prepaid-dollar
a2billing.php|1: [mxn] => pesos
a2billing.php|1: [eur] => euro
a2billing.php|1: [all] => credit
a2billing.php|1: )
a2billing.php|1:
a2billing.php|1: )
a2billing.php|1:
a2billing.php|1: AGI Request:
a2billing.php|1: Array
a2billing.php|1: (
a2billing.php|1: [agi_request] => a2billing.php
a2billing.php|1: [agi_channel] => SIP/2024790729-092c17c8
a2billing.php|1: [agi_language] => en
a2billing.php|1: [agi_type] => SIP
a2billing.php|1: [agi_uniqueid] => 1179849801.14
a2billing.php|1: [agi_callerid] => 23216
a2billing.php|1: [agi_calleridname] => 2024790729
a2billing.php|1: [agi_callingpres] => 0
a2billing.php|1: [agi_callingani2] => 0
a2billing.php|1: [agi_callington] => 0
a2billing.php|1: [agi_callingtns] => 0
a2billing.php|1: [agi_dnid] => 1158230485
a2billing.php|1: [agi_rdnis] => unknown
a2billing.php|1: [agi_context] => a2billing
a2billing.php|1: [agi_extension] => 1158230485
a2billing.php|1: [agi_priority] => 3
a2billing.php|1: [agi_enhanced] => 0.0
a2billing.php|1: [agi_accountcode] => 2024790729
a2billing.php|1: )
a2billing.php|1:
a2billing.php|1: line:490 get_agi_request_parameter = 23216 ; SIP/2024790729-092c17c8 ; 1179849801.14 ; 2024790729 ; 1158230485
a2billing.php|1: line:138 - [ANSWER CALL]
a2billing.php|1: line:1470 - 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 FROM cc_card LEFT JOIN cc_tariffgroup ON tariff=cc_tariffgroup.id WHERE username='2024790729'
a2billing.php|1: line:1473 - Array
a2billing.php|1: line:519 - UPDATE cc_card SET inuse=inuse+1 WHERE username='2024790729'
a2billing.php|1: line:166 - [CHANNEL STATUS : 6 = Line is up]
a2billing.php|1: line:170 - [CREDIT STATUS : 250.00000]
a2billing.php|1: line:171 - [CREDIT MIN_CREDIT_2CALL : 0]
a2billing.php|1: line:544 - 1 && && 10&& 0
a2billing.php|1: line:571 - DESTINATION ::> 1158230485
a2billing.php|1: line:573 - APPLY_RULES DESTINATION ::> 1158230485
a2billing.php|1: line:612 - OK - RESFINDRATE::> 1
a2billing.php|1: line:634 - RES_ALL_CALCULTIMEOUT ::> 1
a2billing.php|1: line:651 - TIMEOUT::> 37500 : minutes=625 - seconds=0
a2billing.php|1: line:819 - app_callingcard: Dialing 'SIP/proveedorsip/011551158230485|70|rL(37500000)' with timeout of '37500'.
a2billing.php|1:
-- AGI Script Executing Application: (Dial) Options: (SIP/proveedorsip/011551158230485|70|rL(37500000))
-- Called proveedorsip/011551158230485
-- SIP/proveedorsip-092c43e8 is making progress passing it to SIP/2024790729-092c17c8 // until here, the telephone for where I am binding, is calling….\\\
e is after the phone call here that I am making I am taken care of by the 1158230485….
Code:
-- SIP/proveedorsip-092c43e8 answered SIP/2024790729-092c17c8
a2billing.php|1: line:706 - INSERT INTO cc_call (uniqueid,sessionid,username,nasipaddress,starttime,sessiontime, calledstation, terminatecause, stoptime, calledrate, sessionbill, calledcountry, calledsub, destination, id_tariffgroup, id_tariffplan, id_ratecard, id_trunk, src, sipiax, buyrate, buycost) VALUES ('1179849801.14', 'SIP/2024790729-092c17c8', '2024790729', '', CURRENT_TIMESTAMP - INTERVAL 0 SECOND , '0', '1158230485', '', now(), '0.4', '-0', '', '', 'BRASIL SAMPA', '30', '45', '351694', '27', '23216', '0', '0.09', '0')
a2billing.php|1: line:519 - UPDATE cc_card SET inuse=inuse-1 WHERE username='2024790729'
-- AGI Script a2billing.php completed, returning 0
as soon as the 1158230485 take care of the telephone, the linking falls, and of the signal of busy
please, it helps me,