asterisk2billing.org
http://forum.asterisk2billing.org/

Hangup and dial again
http://forum.asterisk2billing.org/viewtopic.php?f=15&t=4585
Page 1 of 1

Author:  mushfiq [ Mon Nov 24, 2008 5:17 pm ]
Post subject:  Hangup and dial again

Hello There,

I might have posted about it before but no solution came out so posting again. What happen is suppose for a $2 credit account to a country we can get 29 minutes now if i call to a no and talk about 10 minutes and without hangingup i dial again and finished talking 29 minutes and credit over so hanged up. What actually happen i got 39 minutes talk time in place of 29 minutes. how can i stop it?

Mushfiq

Author:  stavros [ Mon Nov 24, 2008 7:45 pm ]
Post subject: 

Which version of A2B are you running? Which version of Asterisk?
Please can you show us A2B's debug output (after setting 'debug = 3' in a2billing.conf) for a call demonstrating the behaviour you describe.

Author:  mushfiq [ Mon Nov 24, 2008 9:37 pm ]
Post subject: 

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]

Author:  stavros [ Mon Nov 24, 2008 9:49 pm ]
Post subject: 

I still don't know which version of A2B and Asterisk you're using. I don't think you set 'debug = 3' either, because there's nothing in that log I can work with.

Author:  mushfiq [ Tue Nov 25, 2008 12:02 am ]
Post subject: 

asterisk is 1.0.9 a2billing 1.3.0 i believe .
and in a2billing.conf under agiconf1 obviously i choose debug = 3 and save and reload asterisk.

Author:  stavros [ Tue Nov 25, 2008 12:05 am ]
Post subject: 

mushfiq wrote:
asterisk is 1.0.9
You're a brave character if you've got that facing the internet!
Quote:
a2billing 1.3.0 i believe
Try v1.3.4. I'm pretty sure this was fixed some time ago.

Author:  mushfiq [ Tue Nov 25, 2008 12:25 am ]
Post subject: 

ok why is brave one to use 1.0.9 in internet must be some secret.
Can you please clearly say that?
Ok if i upgrade asterisk and a2billing what could happen to my generated
5000 pin no? will these be still there or vanished? if i keep the database record and restore it will those pin come back? current database has like 18 tables and new a2billing version database will probably use 51 tables how will these ineroperable? isn't that risky?
Those were my thought it could be wrong just give me outline how will i get out of it?

Thanks

Author:  stavros [ Tue Nov 25, 2008 12:38 am ]
Post subject: 

mushfiq wrote:
ok why is brave one to use 1.0.9 in internet must be some secret.
Can you please clearly say that?
There's no secret; on today's hostile internet you should always run up-to-date, well maintained software. Asterisk 1.0 hasn't been maintained in a long time now, and Asterisk has a history of security vulnerabilities so running an up-to-date version is of paramount importance.
Quote:
Ok if i upgrade asterisk and a2billing what could happen to my generated 5000 pin no?
Follow the upgrade instructions, including applying the relevant SQL upgrade scripts and ensuring your SQL and PHP are recent enough, and everything should be fine. Of course it would be wise to take a backup beforehand.

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/