Hi ,
This my call log taken from tmp directory after putting debug level=3. I have set up 12 cents credit because of disconnection fee it says i have 4minutes and 30 seconds and after around 2 minutes hanged up from other end and asterisk system asks me destination and after dialling the destination the amount of talk time is very much same as before.
You can clearly observe this in following log....
[24/11/2008 15:11:41]:[CallerID:8174554318]:[CN:]:[CID_ENABLE - CID_CONTROL - CID:8174554318]
[24/11/2008 15:11:41]:[CallerID:8174554318]:[CN:]:[CID_CONTROL - STOP - NO CALLERID]
[24/11/2008 15:11:53]:[CallerID:8174554318]:[CN:4080551804]:EXEC SETLANGUAGE en
[24/11/2008 15:11:56]:[CallerID:8174554318]:[CN:4080551804]:[TRY : callingcard_ivr_authenticate]
[24/11/2008 15:11:56]:[CallerID:8174554318]:[CN:4080551804]:[callingcard_acct_start_inuse]
[24/11/2008 15:11:56]:[CallerID:8174554318]:[CN:4080551804]:[Start: UPDATE cc_card SET inuse=inuse+1 WHERE username='4080551804']
[24/11/2008 15:11:56]:[CallerID:8174554318]:[CN:4080551804]:[CHANNEL STATUS : 6 = Line is up]
[24/11/2008 15:11:56]:[CallerID:8174554318]:[CN:4080551804]:[CREDIT STATUS : 0.12]
[24/11/2008 15:12:06]:[CallerID:8174554318]:[CN:4080551804]:[DTMF DESTINATION ::> 19728893539]
[24/11/2008 15:14:27]:[CallerID:8174554318]:[CN:4080551804]:[callingcard_acct_stop]
[24/11/2008 15:14:27]:[CallerID:8174554318]:[CN:4080551804]:[CHANNEL STATUS : 6 = Line is up]
[24/11/2008 15:14:27]:[CallerID:8174554318]:[CN:4080551804]:[CREDIT STATUS : 0.12]
[24/11/2008 15:14:45]:[CallerID:8174554318]:[CN:4080551804]:[DTMF DESTINATION ::> 12142642941]
[24/11/2008 15:14:45]:[CallerID:8174554318]:[CN:4080551804]:[CC_asterisk_rate-engine: (3, 12142642941)]
[24/11/2008 15:14:45]:[CallerID:8174554318]:[CN:4080551804]:[CC_asterisk_rate-engine: SUPER 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
FROM cc_tariffgroup
RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup.id=3
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 trunk AS rt_trunk ON cc_ratecard.id_trunk=rt_trunk.id_trunk
LEFT JOIN trunk AS tp_trunk ON cc_tariffplan.id_trunk=tp_trunk.id_trunk
WHERE (dialprefix=SUBSTRING('12142642941',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 monday='1'
AND idtariffgroup='3'
AND ( cc_tariffplan.dnidprefix LIKE '8888%' OR (cc_tariffplan.dnidprefix='all' AND 0 = (SELECT count(dnidprefix) FROM cc_tariffplan RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=3 WHERE dnidprefix LIKE '8888%') ))
*******************
[24/11/2008 15:11:41]:[CallerID:8174554318]:[CN:]:[CID_ENABLE - CID_CONTROL - CID:8174554318]
[24/11/2008 15:11:41]:[CallerID:8174554318]:[CN:]:[CID_CONTROL - STOP - NO CALLERID]
[24/11/2008 15:11:53]:[CallerID:8174554318]:[CN:4080551804]:EXEC SETLANGUAGE en
[24/11/2008 15:11:56]:[CallerID:8174554318]:[CN:4080551804]:[TRY : callingcard_ivr_authenticate]
[24/11/2008 15:11:56]:[CallerID:8174554318]:[CN:4080551804]:[callingcard_acct_start_inuse]
[24/11/2008 15:11:56]:[CallerID:8174554318]:[CN:4080551804]:[Start: UPDATE cc_card SET inuse=inuse+1 WHERE username='4080551804']
[24/11/2008 15:11:56]:[CallerID:8174554318]:[CN:4080551804]:[CHANNEL STATUS : 6 = Line is up]
[24/11/2008 15:11:56]:[CallerID:8174554318]:[CN:4080551804]:[CREDIT STATUS : 0.12]
[24/11/2008 15:12:06]:[CallerID:8174554318]:[CN:4080551804]:[DTMF DESTINATION ::> 19728893539]
[24/11/2008 15:14:27]:[CallerID:8174554318]:[CN:4080551804]:[callingcard_acct_stop]
[24/11/2008 15:14:27]:[CallerID:8174554318]:[CN:4080551804]:[CHANNEL STATUS : 6 = Line is up]
[24/11/2008 15:14:27]:[CallerID:8174554318]:[CN:4080551804]:[CREDIT STATUS : 0.12]
[24/11/2008 15:14:45]:[CallerID:8174554318]:[CN:4080551804]:[DTMF DESTINATION ::> 12142642941]
[24/11/2008 15:17:07]:[CallerID:8174554318]:[CN:4080551804]:[callingcard_acct_stop]
[24/11/2008 15:17:07]:[CallerID:8174554318]:[CN:4080551804]:[CHANNEL STATUS : 6 = Line is up]
[24/11/2008 15:17:07]:[CallerID:8174554318]:[CN:4080551804]:[CREDIT STATUS : 0.12]
[24/11/2008 15:17:07]:[CallerID:8174554318]:[CN:4080551804]:[DTMF DESTINATION ::> -1]
[24/11/2008 15:17:07]:[CallerID:8174554318]:[CN:4080551804]:[Start: UPDATE cc_card SET inuse=inuse-1 WHERE username='4080551804']
[24/11/2008 15:17:07]:[CallerID:8174554318]:[CN:4080551804]:[exit]
|