Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 1:51 pm
Auto Dialer Software


All times are UTC




Post new topic Reply to topic  [ 23 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: Doesn't duduct minutes after call was hung up
PostPosted: Sat Mar 18, 2006 4:38 pm 
Hi, I am using the a2billing bundled with *@home 2.2, got it mostly working, except a couple of things:
1) It treats the entire number dialed as the prefix
2) It does not detect the end of call after I hang up, and the "in use" flag stays on, no minutes are deducted.

Does anyone else have these problems? What am I doing wrong?


Top
  
 
 Post subject:
PostPosted: Sat Mar 18, 2006 4:45 pm 
Offline

Joined: Sun Mar 12, 2006 2:49 pm
Posts: 954
Location: Barcelona
for 2)
Please install php-pcntl
you can do php -m to check the module install.

Rgds, Areski


Top
 Profile  
 
 Post subject: deducting minutes
PostPosted: Sat Mar 18, 2006 5:12 pm 
Areski,

Thank you for the very quick response, this is better than any customer service I have received! The first problem was fixed by filling in a country name. I ran the command you suggested, it shows that pcntl is already installed:

[root@asterisk1 asterisk]# php -m
[PHP Modules]
bcmath
bz2
calendar
ctype
curl
dba
dbx
dio
exif
ftp
gd
gettext
gmp
iconv
mime_magic
mysql
openssl
overload
pcntl
pcre
posix
pspell
session
shmop
sockets
standard
sysvsem
sysvshm
tokenizer
wddx
xml
yp
zlib

Thank you so much for your help!


Top
  
 
 Post subject:
PostPosted: Sat Mar 18, 2006 5:27 pm 
Offline

Joined: Sun Mar 12, 2006 2:49 pm
Posts: 954
Location: Barcelona
hmmm I will be sorry to say this but it's hard to provide support on the a2b of a@h
I dont know which version they use and how they integrated.
please download & reinstall the application again, then we could easily help
you if you have an issue.

Btw which asterisk version do u run ?


Top
 Profile  
 
 Post subject:
PostPosted: Sat Mar 18, 2006 5:31 pm 
Below is the log from /tmp/a2billing.log, not very helpful :-( I have set up the calling card application at an extension and testing it by calling another extension, 301, through SIP/301@(PBX IP Address).

[18/03/2006 12:13:14]:[CallerID:]:[CN:8537034741]:[CC_asterisk_rate-engine: (1, 301)]
[18/03/2006 12:13:14]:[CallerID:]:[CN:8537034741]:[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,
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=1

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('301',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 saturday='1'
AND idtariffgroup='1'

AND ( cc_tariffplan.dnidprefix LIKE '701%' OR (cc_tariffplan.dnidprefix='all' AND 0 = 0))


ORDER BY LENGTH(dialprefix) DESC


The CDR are there, but the duration and cost are both 0:


1. 2006-03-18 12:13:19 4080000000 301 paid-content 00:00 8537034741 ANSWER No 0.01 0.00 USD


Top
  
 
 Post subject: Deducting minutes
PostPosted: Sat Mar 18, 2006 5:41 pm 
OK, I'll try that. The Asterisk version is 1.2.0, the INSTALL_AGI.txt in
A2Billing_AGI/ has the follwoing:

********************************************************************
A2BILLING : CALLING CARD PLATFORM
********************************************************************
Name: A2Billing / Asterisk callingcard agi
Author: Belaid Arezqui <areski at gmail dot com>
Date: 18 Oct 2005


Top
  
 
 Post subject:
PostPosted: Sat Mar 18, 2006 9:17 pm 
Offline

Joined: Sun Mar 12, 2006 2:49 pm
Posts: 954
Location: Barcelona
Thx we will update.


Top
 Profile  
 
 Post subject:
PostPosted: Sat Mar 25, 2006 2:36 am 
Hi,

I tried to reinstall it on Asterisk@home 2.2 but it was giving me an error, so I tried it on Asterisk@home 2.5 and it seems to work, once. When I made another call it showed the session time as 0 and does not deduct any money, even though the call time is longer than 1 minute. Below is the log for the call where money was deducted, followed by the one in which money was not deducted. The inuse flag does get reset to 0 after I hang up.

The release date in the a2billing.php file is:

* a2billing.php
*
* Sat Oct 29 21:11:39 2005
* Copyright 2005 - Belaid Arezqui

[19/03/2006 08:15:00]:[CallerID:4086549046]:[CN:2635396427]:[K=0]:[ANSWEREDTIME=1-DIALSTATUS=ANSWER]
[19/03/2006 08:15:00]:[CallerID:4086549046]:[CN:2635396427]:[USEDRATECARD=0]
[19/03/2006 08:15:00]:[CallerID:4086549046]:[CN:2635396427]:[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=0 - (sessiontime=1 :: dialstatus=ANSWER :: cost=0.07)]
[19/03/2006 08:15:00]:[CallerID:4086549046]:[CN:2635396427]:[CC_asterisk_stop 1.1: SQL: INSERT INTO call (uniqueid,sessionid,username,nasipaddress,starttime,sessiontime, calledstation, terminatecause, stoptime, calledrate, sessionbill, calledcountry, calledsub, destination, id_tariffgroup, id_tariffplan, id_ratecard, id_trunk, src) VALUES ('1142784866.982', 'IAX2/66.234.228.170:4569-5', '2635396427', '', CURRENT_TIMESTAMP - INTERVAL 1 SECOND , '1', '3770', 'ANSWER', now(), '0.02', '0.07', '', '', 'paid', '1', '1', '1', '2', '4086549046' )]
[19/03/2006 08:15:00]:[CallerID:4086549046]:[CN:2635396427]:[CC_asterisk_stop 1.1: SQL: DONE]
[19/03/2006 08:15:00]:[CallerID:4086549046]:[CN:2635396427]:[CC_asterisk_stop 1.2: SQL: UPDATE cc_card SET credit= credit-0.07, redial='3770', lastuse=now(), firstusedate=now(),
nbused=nbused+1 WHERE username='2635396427']


The call below didn't work:

[23/03/2006 22:21:30]:[CallerID:201]:[CN:2635396427]:[K=0]:[ANSWEREDTIME=-DIALSTATUS=ANSWER]
[23/03/2006 22:21:30]:[CallerID:201]:[CN:2635396427]:[USEDRATECARD=0]
[23/03/2006 22:21:30]:[CallerID:201]:[CN:2635396427]:[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=0 - (sessiontime=0 :: dialstatus=ANSWER :: cost=0)]
[23/03/2006 22:21:30]:[CallerID:201]:[CN:2635396427]:[CC_asterisk_stop 1.1: SQL: INSERT INTO call (uniqueid,sessionid,username,nasipaddress,starttime,sessiontime, calledstation,
terminatecause, stoptime, calledrate, sessionbill, calledcountry, calledsub, destination, id_tariffgroup, id_tariffplan, id_ratecard, id_trunk, src) VALUES ('1143181255.897', 'SIP/64.55.123.192-08d61028', '2635396427', '', CURRENT_TIMESTAMP - INTERVAL 0 SECOND , '0', '3770', 'ANSWER', now(), '0.02', '0', '', '', 'paid', '1', '1', '1', '2', '201' )]
[23/03/2006 22:21:30]:[CallerID:201]:[CN:2635396427]:[CC_asterisk_stop 1.1: SQL: DONE]
[23/03/2006 22:21:30]:[CallerID:201]:[CN:2635396427]:[callingcard_acct_stop]
[23/03/2006 22:21:30]:[CallerID:201]:[CN:2635396427]:[CHANNEL STATUS : 6 = Line is up]
[23/03/2006 22:21:30]:[CallerID:201]:[CN:2635396427]:[CREDIT STATUS : 1.13]
[23/03/2006 22:21:30]:[CallerID:201]:[CN:2635396427]:[DTMF DESTINATION ::> -1]
[23/03/2006 22:21:30]:[CallerID:201]:[CN:2635396427]:[CHANNEL STATUS : -1 = There is no channel that matches SIP/64.55.123.192-08d61028]
[23/03/2006 22:21:30]:[CallerID:201]:[CN:2635396427]:[CREDIT STATUS : 1.13]
[23/03/2006 22:21:30]:[CallerID:201]:[CN:2635396427]:[Start: UPDATE cc_card SET inuse=inuse-1 WHERE username='2635396427']


Top
  
 
 Post subject:
PostPosted: Sat Mar 25, 2006 6:05 am 
OK, finally got it figured out. Ticket closed :-)


Top
  
 
 Post subject:
PostPosted: Fri Sep 01, 2006 7:49 am 
Offline

Joined: Fri Aug 11, 2006 9:07 am
Posts: 8
wcjiang wrote:
OK, finally got it figured out. Ticket closed :-)


Hi wcjiang. I am having the same issue where the credit is not being deducted. Can you elaborate how the problem got fixed.

thx


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 01, 2006 8:11 am 
Offline

Joined: Sun Mar 12, 2006 2:49 pm
Posts: 954
Location: Barcelona
Please install php-pcntl
you can do php -m to check the module install.

Rgds, Areski


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 01, 2006 4:41 pm 
Offline

Joined: Fri Aug 11, 2006 9:07 am
Posts: 8
areski wrote:
Please install php-pcntl
you can do php -m to check the module install.

Rgds, Areski



Areski:
Appreciate your quick response. However i already have php-pcntl installed.
Any other ideas on why this might not be working?
thx


Top
 Profile  
 
 Post subject: did you fix it?
PostPosted: Fri Jul 06, 2007 5:51 pm 
Offline

Joined: Thu Apr 19, 2007 12:35 am
Posts: 2
culd you help with the solution. I haven´t have had succes.

Thanks in advance


Top
 Profile  
 
 Post subject: help minutes not deducting
PostPosted: Sat Jul 07, 2007 1:31 pm 
Offline

Joined: Fri Jul 06, 2007 2:41 pm
Posts: 3
I am having the same problem. I am not getting any minutes deducted.I guess this error in the logs has something to do with it

[[CHANNEL STATUS : -1 = There is no channel that matches SIP/6015-084a7e98]]

Does anyone know how to fix this?


Top
 Profile  
 
 Post subject:
PostPosted: Sat Jul 07, 2007 10:39 pm 
Offline

Joined: Sat Jul 07, 2007 10:00 pm
Posts: 57
bump bump . I am new to this and having exactly same problem . Was anyone able to do it successfully in a2biling 1.3 stable ?


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 23 posts ]  Go to page 1, 2  Next
Predictive Dialer


All times are UTC


Who is online

Users browsing this forum: No registered users and 9 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