Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 10:47 am
VoIP Billing solution


All times are UTC




Post new topic Reply to topic  [ 8 posts ] 
Author Message
 Post subject: Hangup and dial again
PostPosted: Mon Nov 24, 2008 5:17 pm 
Offline

Joined: Wed Jul 11, 2007 9:27 pm
Posts: 55
Location: USA
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


Top
 Profile  
 
 Post subject:
PostPosted: Mon Nov 24, 2008 7:45 pm 
Offline
Moderator
User avatar

Joined: Thu Jun 22, 2006 2:19 pm
Posts: 2890
Location: Devon, UK
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.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Nov 24, 2008 9:37 pm 
Offline

Joined: Wed Jul 11, 2007 9:27 pm
Posts: 55
Location: USA
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]


Top
 Profile  
 
 Post subject:
PostPosted: Mon Nov 24, 2008 9:49 pm 
Offline
Moderator
User avatar

Joined: Thu Jun 22, 2006 2:19 pm
Posts: 2890
Location: Devon, UK
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.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Nov 25, 2008 12:02 am 
Offline

Joined: Wed Jul 11, 2007 9:27 pm
Posts: 55
Location: USA
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.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Nov 25, 2008 12:05 am 
Offline
Moderator
User avatar

Joined: Thu Jun 22, 2006 2:19 pm
Posts: 2890
Location: Devon, UK
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.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Nov 25, 2008 12:25 am 
Offline

Joined: Wed Jul 11, 2007 9:27 pm
Posts: 55
Location: USA
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


Top
 Profile  
 
 Post subject:
PostPosted: Tue Nov 25, 2008 12:38 am 
Offline
Moderator
User avatar

Joined: Thu Jun 22, 2006 2:19 pm
Posts: 2890
Location: Devon, UK
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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 
VoIP Billing solution


All times are UTC


Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group