provided by Star2Billing S.L.

I find that one of my calls did not get charged.

I am using the latest copy of everything.
I have 2 rate cards defined, only using #2 for customers.

But I got a line that says
file:Class.RateEngine.php [line:1156] :[[USEDRATECARD=0]]

How could this happen, I have not opened the code to see what is up?

I also have a Default Rate in case I missed one, I am sure I have not.

This may not be the problem but it looked very odd, nand the 7 min call had no charges but shows up in the logs.

Any Advise, or more info needed?

We could take turns guessing what the problem is, or you could provide the log file so we'll all know what the problem is.

Here is the complete Log,
I changed the phone number, for safety.

This person, I setup the same as the other customers,
by hand, Her List customer page also does not show any
calls.

She is using Rateplan 2 , like everyone.

I get the calls in via DID test for callerid, and process the call.

Thanks

----------------------------------------------------------



[14/12/2007 21:04:50]:[file:a2billing.php - line:76]:[CallerID:]:[CN:]:[IDCONFIG : 1]
[14/12/2007 21:04:50]:[file:a2billing.php - line:77]:[CallerID:]:[CN:]:[MODE : standard]
[14/12/2007 21:04:50]:[file:Class.A2Billing.php - line:616]:[CallerID:4045734552]:[CN:]:[ get_agi_request_parameter = 4045734552 ; SIP/l-74523-0980eda0 ; 1197684289.63 ; ; 6782025111]
[14/12/2007 21:04:50]:[file:a2billing.php - line:139]:[CallerID:4045734552]:[CN:]:[[ANSWER CALL]]
[14/12/2007 21:04:55]:[file:Class.A2Billing.php - line:555]:[CallerID:4045734552]:[CN:]:[RES Menu Language DTMF : 1]
[14/12/2007 21:04:55]:[file:Class.A2Billing.php - line:581]:[CallerID:4045734552]:[CN:]:[[SET LANGUAGE() en]]
[14/12/2007 21:04:55]:[file:Class.A2Billing.php - line:1437]:[CallerID:4045734552]:[CN:]:[[CID_ENABLE - CID_CONTROL - CID:4045734552]]
[14/12/2007 21:04:55]:[file:Class.A2Billing.php - line:1438]:[CallerID:4045734552]:[CN:]:[[CID_ENABLE - CID_CONTROL - CID:4045734552]]
[14/12/2007 21:04:55]:[file:Class.A2Billing.php - line:1455]:[CallerID:4045734552]:[CN:]:[QUERY = SELECT cc_callerid.cid, cc_callerid.id_cc_card, cc_callerid.activated, cc_card.credit, cc_card.tariff, cc_card.activated, cc_card.inuse, cc_card.simultaccess, cc_card.typepaid, cc_card.creditlimit, cc_card.language, cc_card.username, removeinterprefix, cc_card.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_callerid LEFT JOIN cc_card ON cc_callerid.id_cc_card=cc_card.id LEFT JOIN cc_tariffgroup ON cc_card.tariff=cc_tariffgroup.id WHERE cc_callerid.cid='4045734552'
RESULT : Array
(
[0] => Array
(
[0] => 4045734552
[cid] => 4045734552
[1] => 7
[id_cc_card] => 7
[2] => t
[activated] => t
[3] => 12.00000
[credit] => 12.00000
[4] => 2
[tariff] => 2
[5] => t
[6] => 0
[inuse] => 0
[7] => 0
[simultaccess] => 0
[8] => 0
[typepaid] => 0
[9] =>
[creditlimit] =>
[10] => en
[language] => en
[11] => 2337605298
[username] => 2337605298
[12] => 1
[removeinterprefix] => 1
[13] =>
[redial] =>
[14] => 0
[enableexpire] => 0
[15] => 1512928406
[UNIX_TIMESTAMP(expirationdate)] => 1512928406
[16] => 0
[expiredays] => 0
[17] => 0
[nbused] => 0
[18] => 0
[UNIX_TIMESTAMP(firstusedate)] => 0
[19] => 1197309295
[UNIX_TIMESTAMP(cc_card.creationdate)] => 1197309295
[20] => USD
[currency] => USD
[21] => P
[lastname] => P
[22] => Claudia
[firstname] => Claudia
[23] =>
[email] =>
[24] => 1112221
[uipass] => 1112221
[25] => -1
[id_campaign] => -1
[26] => 7
[id] => 7
[27] => 4045734552
[useralias] => 4045734552
)
)
]
[14/12/2007 21:04:55]:[file:Class.A2Billing.php - line:1625]:[CallerID:4045734552]:[CN:]:[ - Account code - 2337605298]
[14/12/2007 21:04:55]:[file:Class.A2Billing.php - line:1717]:[CallerID:4045734552]:[CN:2337605298]:[[credit=12.00000 :: tariff=2 :: active=t :: isused=0 :: simultaccess=0 :: typepaid=0 :: creditlimit= :: language=en]]
[14/12/2007 21:04:55]:[file:Class.A2Billing.php - line:649]:[CallerID:4045734552]:[CN:2337605298]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse+1 WHERE username='2337605298']]
[14/12/2007 21:04:55]:[file:Class.A2Billing.php - line:1950]:[CallerID:4045734552]:[CN:2337605298]:[[A2Billing] SAY BALANCE : 12.00000
]
[14/12/2007 21:04:55]:[file:Class.A2Billing.php - line:1143]:[CallerID:4045734552]:[CN:2337605298]:[[CURRENCY : USD]]
[14/12/2007 21:04:58]:[file:a2billing.php - line:156]:[CallerID:4045734552]:[CN:2337605298]:[[TRY : callingcard_ivr_authenticate]]
[14/12/2007 21:04:58]:[file:Class.A2Billing.php - line:1399]:[CallerID:4045734552]:[CN:2337605298]:[[AUTO SetCallerID]]
[14/12/2007 21:04:58]:[file:Class.A2Billing.php - line:1405]:[CallerID:4045734552]:[CN:2337605298]:[[REQUESTED SetCallerID : 4045734552]]
[14/12/2007 21:04:58]:[file:Class.A2Billing.php - line:1416]:[CallerID:4045734552]:[CN:2337605298]:[[EXEC SetCallerID : 4045734552]]
[14/12/2007 21:04:58]:[file:a2billing.php - line:170]:[CallerID:4045734552]:[CN:2337605298]:[[CHANNEL STATUS : 6 = Line is up]]
[14/12/2007 21:04:58]:[file:a2billing.php - line:171]:[CallerID:4045734552]:[CN:2337605298]:[[CREDIT : 12.00000][CREDIT MIN_CREDIT_2CALL : 0]]
[14/12/2007 21:05:07]:[file:a2billing.php - line:241]:[CallerID:4045734552]:[CN:2337605298]:[RES REFILL CARD VOUCHER DTMF : ]
[14/12/2007 21:05:07]:[file:Class.A2Billing.php - line:671]:[CallerID:4045734552]:[CN:2337605298]:[ && && 10&& 0]
[14/12/2007 21:05:27]:[file:Class.A2Billing.php - line:678]:[CallerID:4045734552]:[CN:2337605298]:[RES DTMF : 01159342871111]
[14/12/2007 21:05:27]:[file:Class.A2Billing.php - line:696]:[CallerID:4045734552]:[CN:2337605298]:[DESTINATION ::> 01159342871111]
[14/12/2007 21:05:27]:[file:Class.A2Billing.php - line:698]:[CallerID:4045734552]:[CN:2337605298]:[RULES APPLY ON DESTINATION ::> 59342871111]
[14/12/2007 21:05:27]:[file:Class.RateEngine.php - line:73]:[CallerID:4045734552]:[CN:2337605298]:[[CC_asterisk_rate-engine: (2, 59342871111)]]
[14/12/2007 21:05:27]:[file:Class.RateEngine.php - line:122]:[CallerID:4045734552]:[CN:2337605298]:[[CC_asterisk_rate-engine: CALLERID]
4045734552
]
[14/12/2007 21:05:27]:[file:Class.RateEngine.php - line:136]:[CallerID:4045734552]:[CN:2337605298]:[[CALLERID_QUERY]
SELECT count(calleridprefix) FROM cc_tariffplan RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=2 WHERE calleridprefix=SUBSTRING('4045734552',1,length(calleridprefix))
[RESULT]Array
(
[0] => Array
(
[0] => 0
[count(calleridprefix)] => 0
)
)
]
[14/12/2007 21:05:27]:[file:Class.RateEngine.php - line:182]:[CallerID:4045734552]:[CN:2337605298]:[[RATE ENGINE QUERY]
SELECT tariffgroupname, lcrtype, idtariffgroup, cc_tariffgroup_plan.idtariffplan, tariffname, destination,
cc_ratecard.id, dialprefix, destination, buyrate, buyrateinitblock, buyrateincrement, rateinitial, initblock, billingblock,
connectcharge, disconnectcharge, stepchargea, chargea, timechargea, billingblocka, stepchargeb, chargeb,
timechargeb, billingblockb, stepchargec, chargec, timechargec, billingblockc,
cc_tariffplan.id_trunk AS tp_id_trunk, tp_trunk.trunkprefix AS tp_trunk, tp_trunk.providertech AS tp_providertech,
tp_trunk.providerip AS tp_providerip, tp_trunk.removeprefix AS tp_removeprefix,
cc_ratecard.id_trunk AS rc_id_trunk, rt_trunk.trunkprefix AS rc_trunkprefix, rt_trunk.providertech AS rc_providertech,
rt_trunk.providerip AS rc_providerip, rt_trunk.removeprefix AS rc_removeprefix,
musiconhold,
tp_trunk.failover_trunk AS tp_failover_trunk,
rt_trunk.failover_trunk AS rt_failover_trunk,
tp_trunk.addparameter AS tp_addparameter_trunk,
rt_trunk.addparameter AS rt_addparameter_trunk,
id_outbound_cidgroup,
freetimetocall_package_offer, freetimetocall, packagetype, billingtype, startday, id_cc_package_offer
FROM cc_tariffgroup
RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup.id=2
INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan )
LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id
LEFT JOIN cc_trunk AS rt_trunk ON cc_ratecard.id_trunk=rt_trunk.id_trunk
LEFT JOIN cc_trunk AS tp_trunk ON cc_tariffplan.id_trunk=tp_trunk.id_trunk
LEFT JOIN cc_package_offer ON cc_package_offer.id=cc_tariffgroup.id_cc_package_offer
WHERE (dialprefix=SUBSTRING('59342871111',1,length(dialprefix)) OR dialprefix='defaultprefix')
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 <= 7025 AND endtime >=7025)
AND idtariffgroup='2'
AND ( dnidprefix=SUBSTRING('6782025111',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = 0))
AND ( calleridprefix=SUBSTRING('4045734552',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = 0))
ORDER BY LENGTH(dialprefix) DESC
]
[14/12/2007 21:05:27]:[file:Class.RateEngine.php - line:192]:[CallerID:4045734552]:[CN:2337605298]:[[rate-engine: Count Total result 4]]
[14/12/2007 21:05:27]:[file:Class.RateEngine.php - line:281]:[CallerID:4045734552]:[CN:2337605298]:[[CC_asterisk_rate-engine: Count Total result 1]]
[14/12/2007 21:05:27]:[file:Class.RateEngine.php - line:282]:[CallerID:4045734552]:[CN:2337605298]:[[CC_asterisk_rate-engine: number_trunk 1]]
[14/12/2007 21:05:27]:[file:Class.A2Billing.php - line:736]:[CallerID:4045734552]:[CN:2337605298]:[OK - RESFINDRATE::> 1]
[14/12/2007 21:05:27]:[file:Class.RateEngine.php - line:295]:[CallerID:4045734552]:[CN:2337605298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT (12.00000)]]
[14/12/2007 21:05:27]:[file:Class.RateEngine.php - line:301]:[CallerID:4045734552]:[CN:2337605298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:3243]]
[14/12/2007 21:05:27]:[file:Class.A2Billing.php - line:758]:[CallerID:4045734552]:[CN:2337605298]:[RES_ALL_CALCULTIMEOUT ::> 1]
[14/12/2007 21:05:27]:[file:Class.A2Billing.php - line:775]:[CallerID:4045734552]:[CN:2337605298]:[TIMEOUT::> 3243 : minutes=54 - seconds=3]
[14/12/2007 21:05:33]:[file:Class.RateEngine.php - line:1025]:[CallerID:4045734552]:[CN:2337605298]:[app_callingcard: Dialing 'IAX2/VP-IAX2-A/01159342871111|60|HRgrL(3243000:61000:30000)' with timeout of '3243'.
]
[14/12/2007 21:05:33]:[file:Class.RateEngine.php - line:1050]:[CallerID:4045734552]:[CN:2337605298]:[app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.]
[14/12/2007 21:12:01]:[file:Class.RateEngine.php - line:1055]:[CallerID:4045734552]:[CN:2337605298]:[DIAL IAX2/VP-IAX2-A/01159342871111|60|HRgrL(3243000:61000:30000)]
[14/12/2007 21:12:01]:[file:Class.RateEngine.php - line:1156]:[CallerID:4045734552]:[CN:2337605298]:[[USEDRATECARD=0]]
[14/12/2007 21:12:01]:[file:Class.RateEngine.php - line:889]:[CallerID:4045734552]:[CN:2337605298]:[[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=0 - (sessiontime=0 :: dialstatus= :: buycost=0 :: cost= : signe_cc_call=-: signe=+)]]
[14/12/2007 21:12:01]:[file:Class.RateEngine.php - line:913]:[CallerID:4045734552]:[CN:2337605298]:[[CC_asterisk_stop QUERY = 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, id_card_package_offer) VALUES ('1197684289.63', 'SIP/l-2994523-0980eda0', '2337605298', '', CURRENT_TIMESTAMP - INTERVAL 0 SECOND , '0', '59342871111', '', now(), '0.222', '-0', '', '', 'ecuador', '2', '2', '28597', '3', '4045734552', '0', '0.1382', '0', '0')]]
[14/12/2007 21:12:01]:[file:Class.RateEngine.php - line:916]:[CallerID:4045734552]:[CN:2337605298]:[[CC_asterisk_stop 1.1: SQL: DONE : result=1]]
[14/12/2007 21:12:01]:[file:a2billing.php - line:310]:[CallerID:4045734552]:[CN:2337605298]:[[a2billing account stop]]
[14/12/2007 21:12:01]:[file:a2billing.php - line:170]:[CallerID:4045734552]:[CN:2337605298]:[[CHANNEL STATUS : -1 = There is no channel that matches SIP/l-24523-0980eda0]]
[14/12/2007 21:12:01]:[file:a2billing.php - line:171]:[CallerID:4045734552]:[CN:2337605298]:[[CREDIT : 12.00000][CREDIT MIN_CREDIT_2CALL : 0]]
[14/12/2007 21:12:01]:[file:Class.A2Billing.php - line:649]:[CallerID:4045734552]:[CN:2337605298]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse-1 WHERE username='2337605298']]
[14/12/2007 21:12:01]:[CallerID:4045734552]:[CN:2337605298]:[[STOP - EXIT]]

Shows that the SQL query on the dialed number created 4 possible rates, and the call used the 0th (the first) of them. I get USEDRATECARD=0 on all the calls on a working system.
I think this is the cause of your problems. Sessiontime should have been more like 385 seconds, and dialstatus should definitely not be empty. I'm guessing you're running PHP without the pcntl extensions, or your Asterisk is v1.2.17-v1.2.23. If either of these is the case you'll need to search the forum for clues to solve this. Both problems have been covered many, many times.

I make sure the PHP was right now. with the pcntl extensions

and rebooted the server. Last night.
I am using asterisk 1.4.15

But here are 2 calls from same person this morning
on a call for more that 20 minutes,
and only charged her .015 cents on the second call.

Also note I have other people using the system and it appears to
be working for them, and counting the calls. and charging their account.

Sorry
==================


[18/12/2007 07:49:23]:[file:a2billing.php - line:76]:[CallerID:]:[CN:]:[IDCONFIG : 1]
[18/12/2007 07:49:23]:[file:a2billing.php - line:77]:[CallerID:]:[CN:]:[MODE : standard]
[18/12/2007 07:49:23]:[file:Class.A2Billing.php - line:616]:[CallerID:1112223333]:[CN:]:[ get_agi_request_parameter = 1112223333 ; SIP/l-274111-b7700468 ; 1197982162.13 ; ; 6782021111]
[18/12/2007 07:49:23]:[file:a2billing.php - line:139]:[CallerID:1112223333]:[CN:]:[[ANSWER CALL]]
[18/12/2007 07:49:27]:[file:Class.A2Billing.php - line:555]:[CallerID:1112223333]:[CN:]:[RES Menu Language DTMF : 1]
[18/12/2007 07:49:27]:[file:Class.A2Billing.php - line:581]:[CallerID:1112223333]:[CN:]:[[SET LANGUAGE() en]]
[18/12/2007 07:49:27]:[file:Class.A2Billing.php - line:1437]:[CallerID:1112223333]:[CN:]:[[CID_ENABLE - CID_CONTROL - CID:1112223333]]
[18/12/2007 07:49:27]:[file:Class.A2Billing.php - line:1438]:[CallerID:1112223333]:[CN:]:[[CID_ENABLE - CID_CONTROL - CID:1112223333]]
[18/12/2007 07:49:27]:[file:Class.A2Billing.php - line:1455]:[CallerID:1112223333]:[CN:]:[QUERY = SELECT cc_callerid.cid, cc_callerid.id_cc_card, cc_callerid.activated, cc_card.credit, cc_card.tariff, cc_card.activated, cc_card.inuse, cc_card.simultaccess, cc_card.typepaid, cc_card.creditlimit, cc_card.language, cc_card.username, removeinterprefix, cc_card.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_callerid LEFT JOIN cc_card ON cc_callerid.id_cc_card=cc_card.id LEFT JOIN cc_tariffgroup ON cc_card.tariff=cc_tariffgroup.id WHERE cc_callerid.cid='1112223333'
RESULT : ]
[18/12/2007 07:49:27]:[file:Class.A2Billing.php - line:1514]:[CallerID:1112223333]:[CN:]:[[CID_CONTROL - STOP - NO CALLERID]]
[18/12/2007 07:49:27]:[file:Class.A2Billing.php - line:1625]:[CallerID:1112223333]:[CN:]:[ - Account code - ]
[18/12/2007 07:49:27]:[file:Class.A2Billing.php - line:1769]:[CallerID:1112223333]:[CN:]:[Requesting DTMF, CARDNUMBER_LENGTH_MAX 15]
[18/12/2007 07:49:45]:[file:Class.A2Billing.php - line:1771]:[CallerID:1112223333]:[CN:]:[RES DTMF : 1111105298]
[18/12/2007 07:49:45]:[file:Class.A2Billing.php - line:1775]:[CallerID:1112223333]:[CN:1111105298]:[CARDNUMBER ::> 1111105298]
[18/12/2007 07:49:45]:[file:Class.A2Billing.php - line:1798]:[CallerID:1112223333]:[CN:1111105298]:[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, cc_card.id_campaign, cc_card.id, useralias FROM cc_card LEFT JOIN cc_tariffgroup ON tariff=cc_tariffgroup.id WHERE username='1111105298'
Array
(
[0] => Array
(
[0] => 12.00000
[credit] => 12.00000
[1] => 2
[tariff] => 2
[2] => t
[activated] => t
[3] => 0
[inuse] => 0
[4] => 0
[simultaccess] => 0
[5] => 0
[typepaid] => 0
[6] =>
[creditlimit] =>
[7] => en
[language] => en
[8] => 1
[removeinterprefix] => 1
[9] =>
[redial] =>
[10] => 0
[enableexpire] => 0
[11] => 1512928406
[UNIX_TIMESTAMP(expirationdate)] => 1512928406
[12] => 0
[expiredays] => 0
[13] => 0
[nbused] => 0
[14] => 0
[UNIX_TIMESTAMP(firstusedate)] => 0
[15] => 1197309295
[UNIX_TIMESTAMP(cc_card.creationdate)] => 1197309295
[16] => USD
[currency] => USD
[17] => Patino
[lastname] => Patino
[18] => Claudia
[firstname] => Claudia
[19] =>
[email] =>
[20] => 1111
[uipass] => 1111
[21] => 7
[id] => 7
[22] => -1
[id_campaign] => -1
[23] => 7
[24] => 4045799502
[useralias] => 4045799502
)
)
]
[18/12/2007 07:49:45]:[file:Class.A2Billing.php - line:1922]:[CallerID:1112223333]:[CN:1111105298]:[[NOT ADDING NEW CID IN CC_CALLERID : CID LIMIT]]
[18/12/2007 07:49:45]:[file:Class.A2Billing.php - line:649]:[CallerID:1112223333]:[CN:1111105298]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse+1 WHERE username='1111105298']]
[18/12/2007 07:49:45]:[file:Class.A2Billing.php - line:1950]:[CallerID:1112223333]:[CN:1111105298]:[[A2Billing] SAY BALANCE : 12.00000
]
[18/12/2007 07:49:45]:[file:Class.A2Billing.php - line:1143]:[CallerID:1112223333]:[CN:1111105298]:[[CURRENCY : USD]]
[18/12/2007 07:49:48]:[file:a2billing.php - line:156]:[CallerID:1112223333]:[CN:1111105298]:[[TRY : callingcard_ivr_authenticate]]
[18/12/2007 07:49:48]:[file:Class.A2Billing.php - line:1399]:[CallerID:1112223333]:[CN:1111105298]:[[AUTO SetCallerID]]
[18/12/2007 07:49:48]:[file:Class.A2Billing.php - line:1405]:[CallerID:1112223333]:[CN:1111105298]:[[REQUESTED SetCallerID : 1112223333]]
[18/12/2007 07:49:48]:[file:Class.A2Billing.php - line:1416]:[CallerID:1112223333]:[CN:1111105298]:[[EXEC SetCallerID : 1112223333]]
[18/12/2007 07:49:48]:[file:a2billing.php - line:170]:[CallerID:1112223333]:[CN:1111105298]:[[CHANNEL STATUS : 6 = Line is up]]
[18/12/2007 07:49:48]:[file:a2billing.php - line:171]:[CallerID:1112223333]:[CN:1111105298]:[[CREDIT : 12.00000][CREDIT MIN_CREDIT_2CALL : 0]]
[18/12/2007 07:49:58]:[file:a2billing.php - line:241]:[CallerID:1112223333]:[CN:1111105298]:[RES REFILL CARD VOUCHER DTMF : ]
[18/12/2007 07:49:58]:[file:Class.A2Billing.php - line:671]:[CallerID:1112223333]:[CN:1111105298]:[ && && 10&& 0]
[18/12/2007 07:50:08]:[file:Class.A2Billing.php - line:678]:[CallerID:1112223333]:[CN:1111105298]:[RES DTMF : 0115777211111]
[18/12/2007 07:50:08]:[file:Class.A2Billing.php - line:696]:[CallerID:1112223333]:[CN:1111105298]:[DESTINATION ::> 0115777211111]
[18/12/2007 07:50:08]:[file:Class.A2Billing.php - line:698]:[CallerID:1112223333]:[CN:1111105298]:[RULES APPLY ON DESTINATION ::> 5777211111]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:73]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: (2, 5777211111)]]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:122]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: CALLERID]
1112223333
]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:136]:[CallerID:1112223333]:[CN:1111105298]:[[CALLERID_QUERY]
SELECT count(calleridprefix) FROM cc_tariffplan RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=2 WHERE calleridprefix=SUBSTRING('1112223333',1,length(calleridprefix))
[RESULT]Array
(
[0] => Array
(
[0] => 0
[count(calleridprefix)] => 0
)
)
]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:182]:[CallerID:1112223333]:[CN:1111105298]:[[RATE ENGINE QUERY]
SELECT tariffgroupname, lcrtype, idtariffgroup, cc_tariffgroup_plan.idtariffplan, tariffname, destination,
cc_ratecard.id, dialprefix, destination, buyrate, buyrateinitblock, buyrateincrement, rateinitial, initblock, billingblock,
connectcharge, disconnectcharge, stepchargea, chargea, timechargea, billingblocka, stepchargeb, chargeb,
timechargeb, billingblockb, stepchargec, chargec, timechargec, billingblockc,
cc_tariffplan.id_trunk AS tp_id_trunk, tp_trunk.trunkprefix AS tp_trunk, tp_trunk.providertech AS tp_providertech,
tp_trunk.providerip AS tp_providerip, tp_trunk.removeprefix AS tp_removeprefix,
cc_ratecard.id_trunk AS rc_id_trunk, rt_trunk.trunkprefix AS rc_trunkprefix, rt_trunk.providertech AS rc_providertech,
rt_trunk.providerip AS rc_providerip, rt_trunk.removeprefix AS rc_removeprefix,
musiconhold,
tp_trunk.failover_trunk AS tp_failover_trunk,
rt_trunk.failover_trunk AS rt_failover_trunk,
tp_trunk.addparameter AS tp_addparameter_trunk,
rt_trunk.addparameter AS rt_addparameter_trunk,
id_outbound_cidgroup,
freetimetocall_package_offer, freetimetocall, packagetype, billingtype, startday, id_cc_package_offer
FROM cc_tariffgroup
RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup.id=2
INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan )
LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id
LEFT JOIN cc_trunk AS rt_trunk ON cc_ratecard.id_trunk=rt_trunk.id_trunk
LEFT JOIN cc_trunk AS tp_trunk ON cc_tariffplan.id_trunk=tp_trunk.id_trunk
LEFT JOIN cc_package_offer ON cc_package_offer.id=cc_tariffgroup.id_cc_package_offer
WHERE (dialprefix=SUBSTRING('5777211111',1,length(dialprefix)) OR dialprefix='defaultprefix')
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 <= 1910 AND endtime >=1910)
AND idtariffgroup='2'
AND ( dnidprefix=SUBSTRING('6782021111',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = 0))
AND ( calleridprefix=SUBSTRING('1112223333',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = 0))
ORDER BY LENGTH(dialprefix) DESC
]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:192]:[CallerID:1112223333]:[CN:1111105298]:[[rate-engine: Count Total result 2]]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:281]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: Count Total result 2]]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:282]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: number_trunk 2]]
[18/12/2007 07:50:08]:[file:Class.A2Billing.php - line:736]:[CallerID:1112223333]:[CN:1111105298]:[OK - RESFINDRATE::> 1]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:295]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT (12.00000)]]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:301]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:5647]]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:301]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=1 - res_calcultimeout:5106]]
[18/12/2007 07:50:08]:[file:Class.A2Billing.php - line:758]:[CallerID:1112223333]:[CN:1111105298]:[RES_ALL_CALCULTIMEOUT ::> 1]
[18/12/2007 07:50:08]:[file:Class.A2Billing.php - line:775]:[CallerID:1112223333]:[CN:1111105298]:[TIMEOUT::> 5647 : minutes=94 - seconds=7]
[18/12/2007 07:50:14]:[file:Class.RateEngine.php - line:1025]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: Dialing 'SIP/Inphonex/0115777211111|60|HRgrL(5647000:61000:30000)' with timeout of '5647'.
]
[18/12/2007 07:50:14]:[file:Class.RateEngine.php - line:1050]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.]
[18/12/2007 07:50:42]:[file:Class.RateEngine.php - line:1055]:[CallerID:1112223333]:[CN:1111105298]:[DIAL SIP/Inphonex/0115777211111|60|HRgrL(5647000:61000:30000)]
[18/12/2007 07:50:42]:[file:Class.RateEngine.php - line:1025]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: Dialing 'IAX2/VP-IAX2-A/0115777211111|60|HRgrL(5106000:61000:30000)' with timeout of '5106'.
]
[18/12/2007 07:50:42]:[file:Class.RateEngine.php - line:1050]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.]
[18/12/2007 07:51:33]:[file:Class.RateEngine.php - line:1055]:[CallerID:1112223333]:[CN:1111105298]:[DIAL IAX2/VP-IAX2-A/0115777211111|60|HRgrL(5106000:61000:30000)]
[18/12/2007 07:51:33]:[file:Class.RateEngine.php - line:1156]:[CallerID:1112223333]:[CN:1111105298]:[[USEDRATECARD=1]]
[18/12/2007 07:51:33]:[file:Class.RateEngine.php - line:889]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=1 - (sessiontime=0 :: dialstatus=CANCEL :: buycost=0 :: cost= : signe_cc_call=-: signe=+)]]
[18/12/2007 07:51:33]:[file:Class.RateEngine.php - line:913]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_stop QUERY = 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, id_card_package_offer) VALUES ('1197982162.13', 'SIP/lfowler-274523-b7700468', '1111105298', '', CURRENT_TIMESTAMP - INTERVAL 0 SECOND , '0', '5777211111', 'CANCEL', now(), '0.141', '-0', '', '', 'colombia', '2', '2', '27204', '3', '1112223333', '0', '0.0842', '0', '0')]]
[18/12/2007 07:51:33]:[file:Class.RateEngine.php - line:916]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_stop 1.1: SQL: DONE : result=1]]
[18/12/2007 07:51:33]:[file:a2billing.php - line:310]:[CallerID:1112223333]:[CN:1111105298]:[[a2billing account stop]]
[18/12/2007 07:51:33]:[file:a2billing.php - line:170]:[CallerID:1112223333]:[CN:1111105298]:[[CHANNEL STATUS : 6 = Line is up]]
[18/12/2007 07:51:33]:[file:a2billing.php - line:171]:[CallerID:1112223333]:[CN:1111105298]:[[CREDIT : 12.00000][CREDIT MIN_CREDIT_2CALL : 0]]
[18/12/2007 07:51:43]:[file:a2billing.php - line:241]:[CallerID:1112223333]:[CN:1111105298]:[RES REFILL CARD VOUCHER DTMF : ]
[18/12/2007 07:51:43]:[file:Class.A2Billing.php - line:671]:[CallerID:1112223333]:[CN:1111105298]:[0 && && 10&& 1]
[18/12/2007 07:51:57]:[file:Class.A2Billing.php - line:678]:[CallerID:1112223333]:[CN:1111105298]:[RES DTMF : 011573153711111]
[18/12/2007 07:51:57]:[file:Class.A2Billing.php - line:696]:[CallerID:1112223333]:[CN:1111105298]:[DESTINATION ::> 011573153711111]
[18/12/2007 07:51:57]:[file:Class.A2Billing.php - line:698]:[CallerID:1112223333]:[CN:1111105298]:[RULES APPLY ON DESTINATION ::> 573153711111]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:73]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: (2, 573153711111)]]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:122]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: CALLERID]
1112223333
]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:136]:[CallerID:1112223333]:[CN:1111105298]:[[CALLERID_QUERY]
SELECT count(calleridprefix) FROM cc_tariffplan RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=2 WHERE calleridprefix=SUBSTRING('1112223333',1,length(calleridprefix))
[RESULT]Array
(
[0] => Array
(
[0] => 0
[count(calleridprefix)] => 0
)
)
]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:182]:[CallerID:1112223333]:[CN:1111105298]:[[RATE ENGINE QUERY]
SELECT tariffgroupname, lcrtype, idtariffgroup, cc_tariffgroup_plan.idtariffplan, tariffname, destination,
cc_ratecard.id, dialprefix, destination, buyrate, buyrateinitblock, buyrateincrement, rateinitial, initblock, billingblock,
connectcharge, disconnectcharge, stepchargea, chargea, timechargea, billingblocka, stepchargeb, chargeb,
timechargeb, billingblockb, stepchargec, chargec, timechargec, billingblockc,
cc_tariffplan.id_trunk AS tp_id_trunk, tp_trunk.trunkprefix AS tp_trunk, tp_trunk.providertech AS tp_providertech,
tp_trunk.providerip AS tp_providerip, tp_trunk.removeprefix AS tp_removeprefix,
cc_ratecard.id_trunk AS rc_id_trunk, rt_trunk.trunkprefix AS rc_trunkprefix, rt_trunk.providertech AS rc_providertech,
rt_trunk.providerip AS rc_providerip, rt_trunk.removeprefix AS rc_removeprefix,
musiconhold,
tp_trunk.failover_trunk AS tp_failover_trunk,
rt_trunk.failover_trunk AS rt_failover_trunk,
tp_trunk.addparameter AS tp_addparameter_trunk,
rt_trunk.addparameter AS rt_addparameter_trunk,
id_outbound_cidgroup,
freetimetocall_package_offer, freetimetocall, packagetype, billingtype, startday, id_cc_package_offer
FROM cc_tariffgroup
RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup.id=2
INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan )
LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id
LEFT JOIN cc_trunk AS rt_trunk ON cc_ratecard.id_trunk=rt_trunk.id_trunk
LEFT JOIN cc_trunk AS tp_trunk ON cc_tariffplan.id_trunk=tp_trunk.id_trunk
LEFT JOIN cc_package_offer ON cc_package_offer.id=cc_tariffgroup.id_cc_package_offer
WHERE (dialprefix=SUBSTRING('573153711111',1,length(dialprefix)) OR dialprefix='defaultprefix')
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 <= 1911 AND endtime >=1911)
AND idtariffgroup='2'
AND ( dnidprefix=SUBSTRING('6782021111',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = 0))
AND ( calleridprefix=SUBSTRING('1112223333',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = 0))
ORDER BY LENGTH(dialprefix) DESC
]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:192]:[CallerID:1112223333]:[CN:1111105298]:[[rate-engine: Count Total result 6]]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:281]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: Count Total result 2]]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:282]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: number_trunk 2]]
[18/12/2007 07:51:57]:[file:Class.A2Billing.php - line:736]:[CallerID:1112223333]:[CN:1111105298]:[OK - RESFINDRATE::> 1]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:295]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT (12.00000)]]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:301]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:3582]]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:301]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=1 - res_calcultimeout:2711]]
[18/12/2007 07:51:57]:[file:Class.A2Billing.php - line:758]:[CallerID:1112223333]:[CN:1111105298]:[RES_ALL_CALCULTIMEOUT ::> 1]
[18/12/2007 07:51:57]:[file:Class.A2Billing.php - line:775]:[CallerID:1112223333]:[CN:1111105298]:[TIMEOUT::> 3582 : minutes=59 - seconds=42]
[18/12/2007 07:52:04]:[file:Class.RateEngine.php - line:1025]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: Dialing 'IAX2/VP-IAX2-A/011573153711111|60|HRgrL(3582000:61000:30000)' with timeout of '3582'.
]
[18/12/2007 07:52:04]:[file:Class.RateEngine.php - line:1050]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.]
[18/12/2007 07:59:03]:[file:Class.RateEngine.php - line:1055]:[CallerID:1112223333]:[CN:1111105298]:[DIAL IAX2/VP-IAX2-A/011573153711111|60|HRgrL(3582000:61000:30000)]
[18/12/2007 07:59:03]:[file:Class.RateEngine.php - line:1156]:[CallerID:1112223333]:[CN:1111105298]:[[USEDRATECARD=0]]
[18/12/2007 07:59:03]:[file:Class.RateEngine.php - line:889]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=0 - (sessiontime=0 :: dialstatus= :: buycost=0 :: cost= : signe_cc_call=-: signe=+)]]
[18/12/2007 07:59:03]:[file:Class.RateEngine.php - line:913]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_stop QUERY = 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, id_card_package_offer) VALUES ('2197982162.13', 'SIP/lfowler-274523-b7700468', '1111105298', '', CURRENT_TIMESTAMP - INTERVAL 0 SECOND , '0', '573153711111', '', now(), '0.201', '-0', '', '', 'colombia', '2', '2', '27586', '3', '1112223333', '0', '0.1241', '0', '0')]]
[18/12/2007 07:59:03]:[file:Class.RateEngine.php - line:916]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_stop 1.1: SQL: DONE : result=1]]
[18/12/2007 07:59:03]:[file:a2billing.php - line:310]:[CallerID:1112223333]:[CN:1111105298]:[[a2billing account stop]]
[18/12/2007 07:59:03]:[file:a2billing.php - line:170]:[CallerID:1112223333]:[CN:1111105298]:[[CHANNEL STATUS : -1 = There is no channel that matches SIP/lfowler-274523-b7700468]]
[18/12/2007 07:59:03]:[file:a2billing.php - line:171]:[CallerID:1112223333]:[CN:1111105298]:[[CREDIT : 12.00000][CREDIT MIN_CREDIT_2CALL : 0]]
[18/12/2007 07:59:03]:[file:Class.A2Billing.php - line:649]:[CallerID:1112223333]:[CN:1111105298]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse-1 WHERE username='1111105298']]
[18/12/2007 07:59:03]:[CallerID:1112223333]:[CN:1111105298]:[[STOP - EXIT]]
[18/12/2007 07:59:14]:[file:a2billing.php - line:76]:[CallerID:]:[CN:]:[IDCONFIG : 1]
[18/12/2007 07:59:14]:[file:a2billing.php - line:77]:[CallerID:]:[CN:]:[MODE : standard]
[18/12/2007 07:59:14]:[file:Class.A2Billing.php - line:616]:[CallerID:1112223333]:[CN:]:[ get_agi_request_parameter = 1112223333 ; SIP/lfowler-274523-b7700468 ; 1197982753.17 ; ; 6782021111]
[18/12/2007 07:59:14]:[file:a2billing.php - line:139]:[CallerID:1112223333]:[CN:]:[[ANSWER CALL]]
[18/12/2007 07:59:17]:[file:Class.A2Billing.php - line:555]:[CallerID:1112223333]:[CN:]:[RES Menu Language DTMF : 1]
[18/12/2007 07:59:17]:[file:Class.A2Billing.php - line:581]:[CallerID:1112223333]:[CN:]:[[SET LANGUAGE() en]]
[18/12/2007 07:59:17]:[file:Class.A2Billing.php - line:1437]:[CallerID:1112223333]:[CN:]:[[CID_ENABLE - CID_CONTROL - CID:1112223333]]
[18/12/2007 07:59:17]:[file:Class.A2Billing.php - line:1438]:[CallerID:1112223333]:[CN:]:[[CID_ENABLE - CID_CONTROL - CID:1112223333]]
[18/12/2007 07:59:17]:[file:Class.A2Billing.php - line:1455]:[CallerID:1112223333]:[CN:]:[QUERY = SELECT cc_callerid.cid, cc_callerid.id_cc_card, cc_callerid.activated, cc_card.credit, cc_card.tariff, cc_card.activated, cc_card.inuse, cc_card.simultaccess, cc_card.typepaid, cc_card.creditlimit, cc_card.language, cc_card.username, removeinterprefix, cc_card.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_callerid LEFT JOIN cc_card ON cc_callerid.id_cc_card=cc_card.id LEFT JOIN cc_tariffgroup ON cc_card.tariff=cc_tariffgroup.id WHERE cc_callerid.cid='1112223333'
RESULT : ]
[18/12/2007 07:59:17]:[file:Class.A2Billing.php - line:1514]:[CallerID:1112223333]:[CN:]:[[CID_CONTROL - STOP - NO CALLERID]]
[18/12/2007 07:59:17]:[file:Class.A2Billing.php - line:1625]:[CallerID:1112223333]:[CN:]:[ - Account code - ]
[18/12/2007 07:59:17]:[file:Class.A2Billing.php - line:1769]:[CallerID:1112223333]:[CN:]:[Requesting DTMF, CARDNUMBER_LENGTH_MAX 15]
[18/12/2007 07:59:36]:[file:Class.A2Billing.php - line:1771]:[CallerID:1112223333]:[CN:]:[RES DTMF : 1111105298]
[18/12/2007 07:59:36]:[file:Class.A2Billing.php - line:1775]:[CallerID:1112223333]:[CN:1111105298]:[CARDNUMBER ::> 1111105298]
[18/12/2007 07:59:36]:[file:Class.A2Billing.php - line:1798]:[CallerID:1112223333]:[CN:1111105298]:[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, cc_card.id_campaign, cc_card.id, useralias FROM cc_card LEFT JOIN cc_tariffgroup ON tariff=cc_tariffgroup.id WHERE username='1111105298'
Array
(
[0] => Array
(
[0] => 12.00000
[credit] => 12.00000
[1] => 2
[tariff] => 2
[2] => t
[activated] => t
[3] => 0
[inuse] => 0
[4] => 0
[simultaccess] => 0
[5] => 0
[typepaid] => 0
[6] =>
[creditlimit] =>
[7] => en
[language] => en
[8] => 1
[removeinterprefix] => 1
[9] =>
[redial] =>
[10] => 0
[enableexpire] => 0
[11] => 1512928406
[UNIX_TIMESTAMP(expirationdate)] => 1512928406
[12] => 0
[expiredays] => 0
[13] => 0
[nbused] => 0
[14] => 0
[UNIX_TIMESTAMP(firstusedate)] => 0
[15] => 1197309295
[UNIX_TIMESTAMP(cc_card.creationdate)] => 1197309295
[16] => USD
[currency] => USD
[17] => Patino
[lastname] => Patino
[18] => Claudia
[firstname] => Claudia
[19] =>
[email] =>
[20] => 1111
[uipass] => 1111
[21] => 7
[id] => 7
[22] => -1
[id_campaign] => -1
[23] => 7
[24] => 4045799502
[useralias] => 4045799502
)
)
]
[18/12/2007 07:59:36]:[file:Class.A2Billing.php - line:1922]:[CallerID:1112223333]:[CN:1111105298]:[[NOT ADDING NEW CID IN CC_CALLERID : CID LIMIT]]
[18/12/2007 07:59:36]:[file:Class.A2Billing.php - line:649]:[CallerID:1112223333]:[CN:1111105298]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse+1 WHERE username='1111105298']]
[18/12/2007 07:59:36]:[file:Class.A2Billing.php - line:1950]:[CallerID:1112223333]:[CN:1111105298]:[[A2Billing] SAY BALANCE : 12.00000
]
[18/12/2007 07:59:36]:[file:Class.A2Billing.php - line:1143]:[CallerID:1112223333]:[CN:1111105298]:[[CURRENCY : USD]]
[18/12/2007 07:59:39]:[file:a2billing.php - line:156]:[CallerID:1112223333]:[CN:1111105298]:[[TRY : callingcard_ivr_authenticate]]
[18/12/2007 07:59:39]:[file:Class.A2Billing.php - line:1399]:[CallerID:1112223333]:[CN:1111105298]:[[AUTO SetCallerID]]
[18/12/2007 07:59:39]:[file:Class.A2Billing.php - line:1405]:[CallerID:1112223333]:[CN:1111105298]:[[REQUESTED SetCallerID : 1112223333]]
[18/12/2007 07:59:39]:[file:Class.A2Billing.php - line:1416]:[CallerID:1112223333]:[CN:1111105298]:[[EXEC SetCallerID : 1112223333]]
[18/12/2007 07:59:39]:[file:a2billing.php - line:170]:[CallerID:1112223333]:[CN:1111105298]:[[CHANNEL STATUS : 6 = Line is up]]
[18/12/2007 07:59:39]:[file:a2billing.php - line:171]:[CallerID:1112223333]:[CN:1111105298]:[[CREDIT : 12.00000][CREDIT MIN_CREDIT_2CALL : 0]]
[18/12/2007 07:59:49]:[file:a2billing.php - line:241]:[CallerID:1112223333]:[CN:1111105298]:[RES REFILL CARD VOUCHER DTMF : ]
[18/12/2007 07:59:49]:[file:Class.A2Billing.php - line:671]:[CallerID:1112223333]:[CN:1111105298]:[ && && 10&& 0]
[18/12/2007 08:00:08]:[file:Class.A2Billing.php - line:678]:[CallerID:1112223333]:[CN:1111105298]:[RES DTMF : 011576840341]
[18/12/2007 08:00:08]:[file:Class.A2Billing.php - line:696]:[CallerID:1112223333]:[CN:1111105298]:[DESTINATION ::> 011576840341]
[18/12/2007 08:00:08]:[file:Class.A2Billing.php - line:698]:[CallerID:1112223333]:[CN:1111105298]:[RULES APPLY ON DESTINATION ::> 576840341]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:73]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: (2, 576840341)]]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:122]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: CALLERID]
1112223333
]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:136]:[CallerID:1112223333]:[CN:1111105298]:[[CALLERID_QUERY]
SELECT count(calleridprefix) FROM cc_tariffplan RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=2 WHERE calleridprefix=SUBSTRING('1112223333',1,length(calleridprefix))
[RESULT]Array
(
[0] => Array
(
[0] => 0
[count(calleridprefix)] => 0
)
)
]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:182]:[CallerID:1112223333]:[CN:1111105298]:[[RATE ENGINE QUERY]
SELECT tariffgroupname, lcrtype, idtariffgroup, cc_tariffgroup_plan.idtariffplan, tariffname, destination,
cc_ratecard.id, dialprefix, destination, buyrate, buyrateinitblock, buyrateincrement, rateinitial, initblock, billingblock,
connectcharge, disconnectcharge, stepchargea, chargea, timechargea, billingblocka, stepchargeb, chargeb,
timechargeb, billingblockb, stepchargec, chargec, timechargec, billingblockc,
cc_tariffplan.id_trunk AS tp_id_trunk, tp_trunk.trunkprefix AS tp_trunk, tp_trunk.providertech AS tp_providertech,
tp_trunk.providerip AS tp_providerip, tp_trunk.removeprefix AS tp_removeprefix,
cc_ratecard.id_trunk AS rc_id_trunk, rt_trunk.trunkprefix AS rc_trunkprefix, rt_trunk.providertech AS rc_providertech,
rt_trunk.providerip AS rc_providerip, rt_trunk.removeprefix AS rc_removeprefix,
musiconhold,
tp_trunk.failover_trunk AS tp_failover_trunk,
rt_trunk.failover_trunk AS rt_failover_trunk,
tp_trunk.addparameter AS tp_addparameter_trunk,
rt_trunk.addparameter AS rt_addparameter_trunk,
id_outbound_cidgroup,
freetimetocall_package_offer, freetimetocall, packagetype, billingtype, startday, id_cc_package_offer
FROM cc_tariffgroup
RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup.id=2
INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan )
LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id
LEFT JOIN cc_trunk AS rt_trunk ON cc_ratecard.id_trunk=rt_trunk.id_trunk
LEFT JOIN cc_trunk AS tp_trunk ON cc_tariffplan.id_trunk=tp_trunk.id_trunk
LEFT JOIN cc_package_offer ON cc_package_offer.id=cc_tariffgroup.id_cc_package_offer
WHERE (dialprefix=SUBSTRING('576840341',1,length(dialprefix)) OR dialprefix='defaultprefix')
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 <= 1920 AND endtime >=1920)
AND idtariffgroup='2'
AND ( dnidprefix=SUBSTRING('6782021111',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = 0))
AND ( calleridprefix=SUBSTRING('1112223333',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = 0))
ORDER BY LENGTH(dialprefix) DESC
]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:192]:[CallerID:1112223333]:[CN:1111105298]:[[rate-engine: Count Total result 2]]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:281]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: Count Total result 2]]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:282]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: number_trunk 2]]
[18/12/2007 08:00:08]:[file:Class.A2Billing.php - line:736]:[CallerID:1112223333]:[CN:1111105298]:[OK - RESFINDRATE::> 1]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:295]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT (12.00000)]]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:301]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:5647]]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:301]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=1 - res_calcultimeout:5106]]
[18/12/2007 08:00:08]:[file:Class.A2Billing.php - line:758]:[CallerID:1112223333]:[CN:1111105298]:[RES_ALL_CALCULTIMEOUT ::> 1]
[18/12/2007 08:00:08]:[file:Class.A2Billing.php - line:775]:[CallerID:1112223333]:[CN:1111105298]:[TIMEOUT::> 5647 : minutes=94 - seconds=7]
[18/12/2007 08:00:14]:[file:Class.RateEngine.php - line:1025]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: Dialing 'SIP/Inphonex/011576840341|60|HRgrL(5647000:61000:30000)' with timeout of '5647'.
]
[18/12/2007 08:00:14]:[file:Class.RateEngine.php - line:1050]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:1055]:[CallerID:1112223333]:[CN:1111105298]:[DIAL SIP/Inphonex/011576840341|60|HRgrL(5647000:61000:30000)]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:1152]:[CallerID:1112223333]:[CN:1111105298]:[-> dialstatus : ANSWER, answered time is 5
]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:1156]:[CallerID:1112223333]:[CN:1111105298]:[[USEDRATECARD=0]]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:834]:[CallerID:1112223333]:[CN:1111105298]:[ft2c_package_offer : 0 ; ; 0]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:660]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_CALCULCOST: K=0 - CALLDURATION:5 - freetimetocall_used=0]]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:699]:[CallerID:1112223333]:[CN:1111105298]:[[TEMP - CC_RATE_ENGINE_CALCULCOST: 1. COST: -0.010625]:[ (5/60) * 0.1275 ]]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:776]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_CALCULCOST: K=0 - BUYCOST: -0.00625 - SELLING COST: -0.0106]]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:889]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=0 - (sessiontime=5 :: dialstatus=ANSWER :: buycost=0.00625 :: cost=-0.0106 : signe_cc_call=+: signe=-)]]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:913]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_stop QUERY = 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, id_card_package_offer) VALUES ('1197982753.17', 'SIP/lfowler-274523-b7700468', '1111105298', '', CURRENT_TIMESTAMP - INTERVAL 5 SECOND , '5', '576840341', 'ANSWER', now(), '0.1275', '+0.0106', '', '', 'colombia - roc', '2', '2', '40115', '4', '1112223333', '0', '0.075', '0.00625', '0')]]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:916]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_stop 1.1: SQL: DONE : result=1]]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:934]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_stop 1.2: SQL: UPDATE cc_card SET credit= credit-0.0106 , redial='576840341' , lastuse=now(), firstusedate=now(), nbused=nbused+1 WHERE username='1111105298']]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:939]:[CallerID:1112223333]:[CN:1111105298]:[UPDATE cc_trunk SET secondusedreal = secondusedreal + 5 WHERE id_trunk='4']
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:943]:[CallerID:1112223333]:[CN:1111105298]:[UPDATE cc_tariffplan SET secondusedreal = secondusedreal + 5 WHERE id='2']
[18/12/2007 08:00:19]:[file:a2billing.php - line:310]:[CallerID:1112223333]:[CN:1111105298]:[[a2billing account stop]]
[18/12/2007 08:00:19]:[file:a2billing.php - line:170]:[CallerID:1112223333]:[CN:1111105298]:[[CHANNEL STATUS : 6 = Line is up]]
[18/12/2007 08:00:19]:[file:a2billing.php - line:171]:[CallerID:1112223333]:[CN:1111105298]:[[CREDIT : 11.9894][CREDIT MIN_CREDIT_2CALL : 0]]
[18/12/2007 08:00:29]:[file:a2billing.php - line:241]:[CallerID:1112223333]:[CN:1111105298]:[RES REFILL CARD VOUCHER DTMF : ]
[18/12/2007 08:00:29]:[file:Class.A2Billing.php - line:671]:[CallerID:1112223333]:[CN:1111105298]:[0 && && 10&& 1]
[18/12/2007 08:00:41]:[file:Class.A2Billing.php - line:678]:[CallerID:1112223333]:[CN:1111105298]:[RES DTMF : 0115716840341]
[18/12/2007 08:00:41]:[file:Class.A2Billing.php - line:696]:[CallerID:1112223333]:[CN:1111105298]:[DESTINATION ::> 0115716840341]
[18/12/2007 08:00:41]:[file:Class.A2Billing.php - line:698]:[CallerID:1112223333]:[CN:1111105298]:[RULES APPLY ON DESTINATION ::> 5716840341]
[18/12/2007 08:00:41]:[file:Class.RateEngine.php - line:73]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: (2, 5716840341)]]
[18/12/2007 08:00:41]:[file:Class.RateEngine.php - line:122]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: CALLERID]
1112223333
]
[18/12/2007 08:00:41]:[file:Class.RateEngine.php - line:136]:[CallerID:1112223333]:[CN:1111105298]:[[CALLERID_QUERY]
SELECT count(calleridprefix) FROM cc_tariffplan RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=2 WHERE calleridprefix=SUBSTRING('1112223333',1,length(calleridprefix))
[RESULT]Array
(
[0] => Array
(
[0] => 0
[count(calleridprefix)] => 0
)
)
]
[18/12/2007 08:00:41]:[file:Class.RateEngine.php - line:182]:[CallerID:1112223333]:[CN:1111105298]:[[RATE ENGINE QUERY]
SELECT tariffgroupname, lcrtype, idtariffgroup, cc_tariffgroup_plan.idtariffplan, tariffname, destination,
cc_ratecard.id, dialprefix, destination, buyrate, buyrateinitblock, buyrateincrement, rateinitial, initblock, billingblock,
connectcharge, disconnectcharge, stepchargea, chargea, timechargea, billingblocka, stepchargeb, chargeb,
timechargeb, billingblockb, stepchargec, chargec, timechargec, billingblockc,
cc_tariffplan.id_trunk AS tp_id_trunk, tp_trunk.trunkprefix AS tp_trunk, tp_trunk.providertech AS tp_providertech,
tp_trunk.providerip AS tp_providerip, tp_trunk.removeprefix AS tp_removeprefix,
cc_ratecard.id_trunk AS rc_id_trunk, rt_trunk.trunkprefix AS rc_trunkprefix, rt_trunk.providertech AS rc_providertech,
rt_trunk.providerip AS rc_providerip, rt_trunk.removeprefix AS rc_removeprefix,
musiconhold,
tp_trunk.failover_trunk AS tp_failover_trunk,
rt_trunk.failover_trunk AS rt_failover_trunk,
tp_trunk.addparameter AS tp_addparameter_trunk,
rt_trunk.addparameter AS rt_addparameter_trunk,
id_outbound_cidgroup,
freetimetocall_package_offer, freetimetocall, packagetype, billingtype, startday, id_cc_package_offer
FROM cc_tariffgroup
RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup.id=2
INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan )
LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id
LEFT JOIN cc_trunk AS rt_trunk ON cc_ratecard.id_trunk=rt_trunk.id_trunk
LEFT JOIN cc_trunk AS tp_trunk ON cc_tariffplan.id_trunk=tp_trunk.id_trunk
LEFT JOIN cc_package_offer ON cc_package_offer.id=cc_tariffgroup.id_cc_package_offer
WHERE (dialprefix=SUBSTRING('5716840341',1,length(dialprefix)) OR dialprefix='defaultprefix')
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 <= 1920 AND endtime >=1920)
AND idtariffgroup='2'
AND ( dnidprefix=SUBSTRING('6782021111',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = 0))
AND ( calleridprefix=SUBSTRING('1112223333',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = 0))
ORDER BY LENGTH(dialprefix) DESC
]
[18/12/2007 08:00:41]:[file:Class.RateEngine.php - line:192]:[CallerID:1112223333]:[CN:1111105298]:[[rate-engine: Count Total result 5]]
[18/12/2007 08:00:41]:[file:Class.RateEngine.php - line:281]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: Count Total result 1]]
[18/12/2007 08:00:41]:[file:Class.RateEngine.php - line:282]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: number_trunk 1]]
[18/12/2007 08:00:41]:[file:Class.A2Billing.php - line:736]:[CallerID:1112223333]:[CN:1111105298]:[OK - RESFINDRATE::> 1]
[18/12/2007 08:00:41]:[file:Class.RateEngine.php - line:295]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT (11.9894)]]
[18/12/2007 08:00:41]:[file:Class.RateEngine.php - line:301]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:9465]]
[18/12/2007 08:00:41]:[file:Class.A2Billing.php - line:758]:[CallerID:1112223333]:[CN:1111105298]:[RES_ALL_CALCULTIMEOUT ::> 1]
[18/12/2007 08:00:41]:[file:Class.A2Billing.php - line:775]:[CallerID:1112223333]:[CN:1111105298]:[TIMEOUT::> 9465 : minutes=157 - seconds=45]
[18/12/2007 08:00:49]:[file:Class.RateEngine.php - line:1025]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: Dialing 'IAX2/VP-IAX2-A/0115716840341|60|HRgrL(9465000:61000:30000)' with timeout of '9465'.
]
[18/12/2007 08:00:49]:[file:Class.RateEngine.php - line:1050]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.]
[18/12/2007 08:23:28]:[file:Class.RateEngine.php - line:1055]:[CallerID:1112223333]:[CN:1111105298]:[DIAL IAX2/VP-IAX2-A/0115716840341|60|HRgrL(9465000:61000:30000)]
[18/12/2007 08:23:28]:[file:Class.RateEngine.php - line:1156]:[CallerID:1112223333]:[CN:1111105298]:[[USEDRATECARD=0]]
[18/12/2007 08:23:28]:[file:Class.RateEngine.php - line:889]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=0 - (sessiontime=0 :: dialstatus= :: buycost=0 :: cost= : signe_cc_call=-: signe=+)]]
[18/12/2007 08:23:28]:[file:Class.RateEngine.php - line:913]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_stop QUERY = 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, id_card_package_offer) VALUES ('2197982753.17', 'SIP/lfowler-274523-b7700468', '1111105298', '', CURRENT_TIMESTAMP - INTERVAL 0 SECOND , '0', '5716840341', '', now(), '0.076', '-0', '', '', 'colombia', '2', '2', '27243', '3', '1112223333', '0', '0.0409', '0', '0')]]
[18/12/2007 08:23:28]:[file:Class.RateEngine.php - line:916]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_stop 1.1: SQL: DONE : result=1]]
[18/12/2007 08:23:28]:[file:a2billing.php - line:310]:[CallerID:1112223333]:[CN:1111105298]:[[a2billing account stop]]
[18/12/2007 08:23:28]:[file:a2billing.php - line:170]:[CallerID:1112223333]:[CN:1111105298]:[[CHANNEL STATUS : -1 = There is no channel that matches SIP/lfowler-274523-b7700468]]
[18/12/2007 08:23:28]:[file:a2billing.php - line:171]:[CallerID:1112223333]:[CN:1111105298]:[[CREDIT : 11.9894][CREDIT MIN_CREDIT_2CALL : 0]]
[18/12/2007 08:23:28]:[file:Class.A2Billing.php - line:649]:[CallerID:1112223333]:[CN:1111105298]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse-1 WHERE username='1111105298']]
[18/12/2007 08:23:28]:[CallerID:1112223333]:[CN:1111105298]:[[STOP - EXIT]]

You still have problems with A2B receiving the dialstatus and sessiontime back from Asterisk after the call completes. I've not used Asterisk v1.4 yet, but I think this may be possibly related to calling A2B using AGI() rather than DeadAGI() in extensions.conf. Alternatively, it's possible the Asterisk devs have introduced the same regression into v1.4.15 that we endured in v1.2.17-v1.2.23.I think the outcome depends on who clears down the call. If the called party clears down first then you'll not bill the call. Test it and find out. It might also be informative to test using '*' to hang up the outbound leg.
There were 4 attempts in that debug log:
1) dialstatus said CANCEL: cleared down before remote answer2) A 7 minute call to Colombia which was billed at 0.00 due to the 0 sessiontime:
3) A 5 second call to Colombia, correctly billed at (5/60)*12.75 == 1.06 cents4) A 22:30 minute call to Colombia, which was billed at 0.00 due to the 0 sessiontime.

Added after 45 minutes:

PS That 3rd call that billed 5 seconds doesn't look right. The times in the log show 5 seconds was billed 5 seconds after the dial command. This means the PDD (Post Dial Delay: the delay your carrier introduces in routing the call before it starts to ring) was 0. Unless you're directly connected to the PSTN via PRI this is a suspiciously low figure. It also means the call was answered the instant it started to ring. This suggests the call failed but was billed 5 seconds nonetheless.
When the call is to a cellular destination via a cheap carrier I've frequently found the calls are answered by the cellular network operator with some audible failure message (for example "calls from this SIM are barred" or "please call $OPERATOR customer services").