<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-2">
<META content="MSHTML 6.00.2800.1491" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>
<STRONG>Regards!</STRONG></FONT></DIV>
<DIV><STRONG><FONT face=Arial size=2></FONT></STRONG> </DIV>
<DIV><STRONG><FONT face=Arial size=2>During the use of areski a2billing software
I'm getting same problem all the time.</FONT></STRONG></DIV>
<DIV><STRONG><FONT face=Arial size=2>Actually, after 15 minutes of speaking
to someone over calling card, connection brakes. </FONT></STRONG></DIV>
<DIV><STRONG><FONT face=Arial size=2>Installation was as smooth as it could be
so I don't think I made same kind of a mess in that domain. This is the only
problem in the aplication.</FONT></STRONG></DIV>
<DIV><STRONG><FONT face=Arial size=2>In the logs everything seems to be
fine.</FONT></STRONG></DIV>
<DIV><STRONG><FONT face=Arial size=2>I'am sending You log as an apendix bellow
the text.</FONT></STRONG></DIV>
<DIV><STRONG><FONT face=Arial size=2>Is it a asterisk problem
or...</FONT></STRONG></DIV>
<DIV><STRONG><FONT face=Arial size=2></FONT></STRONG> </DIV>
<DIV><STRONG><FONT face=Arial size=2>a2billing.log</FONT></STRONG></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV><FONT face=Arial size=2>
<DIV><BR><FONT size=1><STRONG>[05/03/2006
19:39:45]:[CallerID:051359687]:[CN:0474]:[CC_asterisk_rate-engine: Count Total
result 1]<BR>[05/03/2006
19:39:45]:[CallerID:051359687]:[CN:0474]:[CC_asterisk_rate-engine: Count Total
result 1]<BR>[05/03/2006
19:39:45]:[CallerID:051359687]:[CN:0474]:[CC_asterisk_rate-engine: number_trunk
1]<BR>[05/03/2006
19:39:46]:[CallerID:051359687]:[CN:0474]:[CC_RATE_ENGINE_ALL_CALCULTIMEOUT
(81.1667)]<BR>[05/03/2006
19:39:46]:[CallerID:051359687]:[CN:0474]:[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0
- res_calcultimeout:4869]<BR>[05/03/2006
19:52:37]:[CallerID:051359687]:[CN:0474]:DIAL
SIP/odlazni/00436642780018|90|HL(4869000:61000:30000)<BR>[05/03/2006
19:52:37]:[CallerID:051359687]:[CN:0474]:[K=0]:[ANSWEREDTIME=751-DIALSTATUS=ANSWER]<BR>[05/03/2006
19:52:37]:[CallerID:051359687]:[CN:0474]:[USEDRATECARD=0]<BR>[05/03/2006
19:52:37]:[CallerID:051359687]:[CN:0474]:[CC_RATE_ENGINE_CALCULCOST: K=0 -
CALLDURATION:751]<BR>[05/03/2006 19:52:37]:[CallerID:051359687]:[CN:0474]:[TEMP
- CC_RATE_ENGINE_CALCULCOST: 1. COST: -12.516666666667]:[ (751/60) * 1
]<BR>[05/03/2006
19:52:37]:[CallerID:051359687]:[CN:0474]:[CC_RATE_ENGINE_CALCULCOST: K=0 - FINAL
COST: -12.516666666667]<BR>[05/03/2006
19:52:37]:[CallerID:051359687]:[CN:0474]:[CC_RATE_ENGINE_UPDATESYSTEM:
usedratecard K=0 - (sessiontime=751 :: dialstatus=ANSWER ::
cost=12.516666666667)]<BR>[05/03/2006
19:52:37]:[CallerID:051359687]:[CN:0474]:[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 ('1141583953.47',
'SIP/callingcard-50e8', '0474', '', CURRENT_TIMESTAMP - INTERVAL 751
SECOND , '751', '00436642780018', 'ANSWER', now(), '1', '12.516666666667',
'', '', 'svet', '1', '1', '1', '1', '051359687' )]<BR>[05/03/2006
19:52:37]:[CallerID:051359687]:[CN:0474]:[CC_asterisk_stop 1.1: SQL:
DONE]<BR>[05/03/2006 19:52:37]:[CallerID:051359687]:[CN:0474]:[CC_asterisk_stop
1.2: SQL: UPDATE cc_card SET credit= credit-12.516666666667,
redial='00436642780018', lastuse=now(), nbused=nbused+1 WHERE
username='0474']<BR>[05/03/2006
19:52:37]:[CallerID:051359687]:[CN:0474]:[callingcard_acct_stop]<BR>[05/03/2006
19:52:37]:[CallerID:051359687]:[CN:0474]:[CHANNEL STATUS : 6 = Line is
up]<BR>[05/03/2006 19:52:37]:[CallerID:051359687]:[CN:0474]:[CREDIT STATUS :
68.650033333333]<BR>[05/03/2006 19:52:37]:[CallerID:051359687]:[CN:0474]:[DTMF
DESTINATION ::> -1]<BR>[05/03/2006
19:52:37]:[CallerID:051359687]:[CN:0474]:[CHANNEL STATUS : -1 = There is no
channel that matches SIP/callingcard-50e8]<BR>[05/03/2006
19:52:37]:[CallerID:051359687]:[CN:0474]:[CREDIT STATUS :
68.650033333333]<BR>[05/03/2006 19:52:37]:[CallerID:051359687]:[CN:0474]:[Start:
UPDATE cc_card SET inuse=inuse-1 WHERE username='0474']<BR>[05/03/2006
19:52:37]:[CallerID:051359687]:[CN:0474]:[STOP - EXIT]<BR>[05/03/2006
19:38:06]:[CallerID:051212072]:[CN:4513]:[CC_asterisk_rate-engine: Count Total
result 1]<BR>[05/03/2006
19:38:06]:[CallerID:051212072]:[CN:4513]:[CC_asterisk_rate-engine: Count Total
result 1]<BR>[05/03/2006
19:38:06]:[CallerID:051212072]:[CN:4513]:[CC_asterisk_rate-engine: number_trunk
1]<BR>[05/03/2006
19:38:06]:[CallerID:051212072]:[CN:4513]:[CC_RATE_ENGINE_ALL_CALCULTIMEOUT
(46.750033333333)]<BR>[05/03/2006
19:38:06]:[CallerID:051212072]:[CN:4513]:[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0
- res_calcultimeout:2804]<BR>[05/03/2006
19:53:58]:[CallerID:051212072]:[CN:4513]:DIAL
SIP/odlazni/00497720954992|90|HL(2804000:61000:30000)<BR>[05/03/2006
19:53:58]:[CallerID:051212072]:[CN:4513]:[K=0]:[<FONT
color=#ff0000>ANSWEREDTIME=937-DIALSTATUS=ANSWER] ( my max call duration
937 sec)<BR></FONT>[05/03/2006
19:53:58]:[CallerID:051212072]:[CN:4513]:[USEDRATECARD=0]<BR>[05/03/2006
19:53:58]:[CallerID:051212072]:[CN:4513]:[CC_RATE_ENGINE_CALCULCOST: K=0 -
CALLDURATION:937]<BR>[05/03/2006 19:53:58]:[CallerID:051212072]:[CN:4513]:[TEMP
- CC_RATE_ENGINE_CALCULCOST: 1. COST: -15.616666666667]:[ (937/60) * 1
]<BR>[05/03/2006
19:53:58]:[CallerID:051212072]:[CN:4513]:[CC_RATE_ENGINE_CALCULCOST: K=0 - FINAL
COST: -15.616666666667]<BR>[05/03/2006
19:53:58]:[CallerID:051212072]:[CN:4513]:[CC_RATE_ENGINE_UPDATESYSTEM:
usedratecard K=0 - (sessiontime=937 :: dialstatus=ANSWER ::
cost=15.616666666667)]<BR>[05/03/2006
19:53:58]:[CallerID:051212072]:[CN:4513]:[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 ('2141583490.41',
'SIP/callingcard-31f3', '4513', '', CURRENT_TIMESTAMP - INTERVAL 937
SECOND , '937', '00497720954992', 'ANSWER', now(), '1', '15.616666666667',
'', '', 'svet', '1', '1', '1', '1', '051212072' )]<BR>[05/03/2006
19:53:58]:[CallerID:051212072]:[CN:4513]:[CC_asterisk_stop 1.1: SQL:
DONE][05/03/2006 19:53:58]:[CallerID:051212072]:[CN:4513]:[CC_asterisk_stop 1.2:
SQL: UPDATE cc_card SET credit= credit-15.616666666667, redial='00497720954992',
lastuse=now(), nbused=nbused+1 WHERE username='4513']<BR>[05/03/2006
19:53:58]:[CallerID:051212072]:[CN:4513]:[callingcard_acct_stop]<BR>[05/03/2006
19:53:58]:[CallerID:051212072]:[CN:4513]:[CHANNEL STATUS : 6 = Line is
up][05/03/2006 19:53:58]:[CallerID:051212072]:[CN:4513]:[CREDIT STATUS :
31.133366666667]<BR>[05/03/2006 19:53:58]:[CallerID:051212072]:[CN:4513]:[DTMF
DESTINATION ::> -1][05/03/2006
19:53:58]:[CallerID:051212072]:[CN:4513]:[Start: UPDATE cc_card SET
inuse=inuse-1 WHERE username='4513'][05/03/2006
19:53:58]:[CallerID:051212072]:[CN:4513]:[exit][05/03/2006
19:54:21]:[CallerID:051212072]:[CN:]:EXEC SETLANGUAGE en<BR>[05/03/2006
19:54:21]:[CallerID:051212072]:[CN:]:[CID_ENABLE - CID_CONTROL -
CID:051212072]<BR>[05/03/2006 19:54:21]:[CallerID:051212072]:[CN:]:[CID_CONTROL
- STOP - NO CALLERID][05/03/2006 19:54:34]:[CallerID:051212072]:[CN:4513]:[TRY :
callingcard_ivr_authenticate]<BR>[05/03/2006
19:54:34]:[CallerID:051212072]:[CN:4513]:[callingcard_acct_start_inuse]<BR>[05/03/2006
19:54:34]:[CallerID:051212072]:[CN:4513]:[Start: UPDATE cc_card SET
inuse=inuse+1 WHERE username='4513']<BR>[05/03/2006
19:54:34]:[CallerID:051212072]:[CN:4513]:[CHANNEL STATUS : 6 = Line is
up]<BR>[05/03/2006 19:54:34]:[CallerID:051212072]:[CN:4513]:[CREDIT STATUS :
31.1333]<BR>[05/03/2006 19:54:50]:[CallerID:051212072]:[CN:4513]:[DTMF
DESTINATION ::> 00497720954992]<BR>[05/03/2006
19:54:50]:[CallerID:051212072]:[CN:4513]:[CC_asterisk_rate-engine: (1,
00497720954992)]<BR>[05/03/2006
19:54:50]:[CallerID:051212072]:[CN:4513]:[CC_asterisk_rate-engine: SUPER
QUERY]<BR>SELECT tariffgroupname, lcrtype, idtariffgroup,
cc_tariffgroup_plan.idtariffplan, tariffname, destination,</STRONG></FONT></DIV>
<DIV><FONT size=1><STRONG></STRONG></FONT> </DIV>
<DIV><FONT size=1><STRONG>
cc_ratecard.id,<BR> dialprefix,
destination, buyrate, buyrateinitblock, buyrateincrement, rateinitial,
initblock, billingblock,<BR>
connectcharge, disconnectcharge, stepchargea, chargea, timechargea,
billingblocka, stepchargeb,
chargeb,<BR> timechargeb,
billingblockb, stepchargec, chargec, timechargec, billingblockc,
</STRONG></FONT></DIV>
<DIV><FONT size=1><STRONG></STRONG></FONT> </DIV>
<DIV><BR><FONT size=1><STRONG>
cc_tariffplan.id_trunk AS tp_id_trunk, tp_trunk.trunkprefix AS tp_trunk,
tp_trunk.providertech AS
tp_providertech,<BR>
tp_trunk.providerip AS tp_providerip, tp_trunk.removeprefix AS
tp_removeprefix,<BR>
cc_ratecard.id_trunk AS rc_id_trunk, rt_trunk.trunkprefix AS rc_trunkprefix,
rt_trunk.providertech AS
rc_providertech,<BR>
rt_trunk.providerip AS rc_providerip, rt_trunk.removeprefix AS
rc_removeprefix,<BR>
musiconhold, tp_trunk.failover_trunk
AS tp_failover_trunk,<BR>
rt_trunk.failover_trunk AS
rt_failover_trunk,<BR>
tp_trunk.addparameter AS
tp_addparameter_trunk,
rt_trunk.addparameter AS rt_addparameter_trunk</STRONG></FONT></DIV>
<DIV><FONT size=1><STRONG></STRONG></FONT> </DIV>
<DIV><FONT size=1><STRONG> FROM
cc_tariffgroup<BR> RIGHT JOIN
cc_tariffgroup_plan ON cc_tariffgroup.id=1</STRONG></FONT></DIV>
<DIV><FONT size=1><STRONG></STRONG></FONT> </DIV>
<DIV><FONT size=1><STRONG> INNER JOIN
cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan
)</STRONG></FONT></DIV>
<DIV><FONT size=1><STRONG></STRONG></FONT> </DIV>
<DIV><FONT size=1><STRONG> LEFT JOIN
cc_ratecard ON
cc_ratecard.idtariffplan=cc_tariffplan.id<BR>
LEFT JOIN trunk AS rt_trunk ON
cc_ratecard.id_trunk=rt_trunk.id_trunk<BR>
LEFT JOIN trunk AS tp_trunk ON
cc_tariffplan.id_trunk=tp_trunk.id_trunk</STRONG></FONT></DIV>
<DIV><FONT size=1><STRONG></STRONG></FONT> </DIV>
<DIV><FONT size=1><STRONG> WHERE
(dialprefix=SUBSTRING('00497720954992',1,length(dialprefix)) OR
dialprefix='defaultprefix')<BR> AND
startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP
OR expirationdate IS NULL OR
LENGTH(expirationdate)<5)<BR> AND
startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR
stopdate IS NULL OR
LENGTH(stopdate)<5)<BR> AND
sunday='1'<BR> AND
idtariffgroup='1'</STRONG></FONT></DIV>
<DIV><FONT size=1><STRONG></STRONG></FONT> </DIV>
<DIV><FONT size=1><STRONG> AND (
cc_tariffplan.dnidprefix LIKE '192.168.0.36%' OR (cc_tariffplan.dnidprefix='all'
AND 0 = 0))</STRONG></FONT></DIV>
<DIV><FONT size=1><STRONG></STRONG></FONT> </DIV>
<DIV><BR><FONT size=1><STRONG> ORDER
BY LENGTH(dialprefix) DESC</STRONG></FONT></DIV>
<DIV><FONT size=1><STRONG></STRONG></FONT> </DIV>
<DIV><FONT size=1><STRONG>[05/03/2006 19:55:25]:[CallerID:051379680]:[CN:]:EXEC
SETLANGUAGE en<BR>[05/03/2006 19:55:25]:[CallerID:051379680]:[CN:]:[CID_ENABLE -
CID_CONTROL - CID:051379680]<BR>[05/03/2006
19:55:25]:[CallerID:051379680]:[CN:]:[CID_CONTROL - STOP - NO
CALLERID]<BR>[05/03/2006 19:55:43]:[CallerID:051379680]:[CN:4963]:[TRY :
callingcard_ivr_authenticate]<BR>[05/03/2006
19:55:43]:[CallerID:051379680]:[CN:4963]:[AUTHENTICATION FAILED
(cia_res:-1)]<BR>[05/03/2006
19:55:44]:[CallerID:051379680]:[CN:4963]:[exit]<BR>[05/03/2006
19:55:57]:[CallerID:051379680]:[CN:]:EXEC SETLANGUAGE en<BR>[05/03/2006
19:55:57]:[CallerID:051379680]:[CN:]:[CID_ENABLE - CID_CONTROL -
CID:051379680]<BR>[05/03/2006 19:55:57]:[CallerID:051379680]:[CN:]:[CID_CONTROL
- STOP - NO CALLERID]<BR>[05/03/2006 19:56:12]:[CallerID:051379680]:[CN:-1]:[TRY
: callingcard_ivr_authenticate]<BR>[05/03/2006
19:56:12]:[CallerID:051379680]:[CN:-1]:[AUTHENTICATION FAILED
(cia_res:-1)]<BR>[05/03/2006
19:56:12]:[CallerID:051379680]:[CN:-1]:[exit]<BR>[05/03/2006
19:54:50]:[CallerID:051212072]:[CN:4513]:[CC_asterisk_rate-engine: Count Total
result 1]<BR>[05/03/2006
19:54:50]:[CallerID:051212072]:[CN:4513]:[CC_asterisk_rate-engine: Count Total
result 1]<BR>[05/03/2006
19:54:50]:[CallerID:051212072]:[CN:4513]:[CC_asterisk_rate-engine: number_trunk
1]<BR>[05/03/2006
19:54:50]:[CallerID:051212072]:[CN:4513]:[CC_RATE_ENGINE_ALL_CALCULTIMEOUT
(31.1333)]<BR>[05/03/2006
19:54:50]:[CallerID:051212072]:[CN:4513]:[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0
- res_calcultimeout:1866]<BR>[05/03/2006
20:10:07]:[CallerID:051212072]:[CN:4513]:DIAL
SIP/odlazni/00497720954992|90|HL(1866000:61000:30000)<BR>[05/03/2006
20:10:07]:[CallerID:051212072]:[CN:4513]:[K=0]:[ANSWEREDTIME=903-DIALSTATUS=ANSWER]<BR>[05/03/2006
20:10:07]:[CallerID:051212072]:[CN:4513]:[USEDRATECARD=0]<BR>[05/03/2006
20:10:07]:[CallerID:051212072]:[CN:4513]:[CC_RATE_ENGINE_CALCULCOST: K=0 -
CALLDURATION:903]<BR>[05/03/2006 20:10:07]:[CallerID:051212072]:[CN:4513]:[TEMP
- CC_RATE_ENGINE_CALCULCOST: 1. COST: -15.05]:[ (903/60) * 1 ]<BR>[05/03/2006
20:10:07]:[CallerID:051212072]:[CN:4513]:[CC_RATE_ENGINE_CALCULCOST: K=0 - FINAL
COST: -15.05][05/03/2006
20:10:07]:[CallerID:051212072]:[CN:4513]:[CC_RATE_ENGINE_UPDATESYSTEM:
usedratecard K=0 - (sessiontime=903 :: dialstatus=ANSWER ::
cost=15.05)][05/03/2006
20:10:07]:[CallerID:051212072]:[CN:4513]:[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 ('1141584857.49',
'SIP/callingcard-716f', '4513', '', CURRENT_TIMESTAMP - INTERVAL 903
SECOND , '903', '00497720954992', 'ANSWER', now(), '1', '15.05', '', '',
'svet', '1', '1', '1', '1', '051212072' )]<BR>[05/03/2006
20:10:07]:[CallerID:051212072]:[CN:4513]:[CC_asterisk_stop 1.1: SQL:
DONE][05/03/2006 20:10:07]:[CallerID:051212072]:[CN:4513]:[CC_asterisk_stop 1.2:
SQL: UPDATE cc_card SET credit= credit-15.05, redial='00497720954992',
lastuse=now(), nbused=nbused+1 WHERE username='4513']<BR>[05/03/2006
20:10:07]:[CallerID:051212072]:[CN:4513]:[callingcard_acct_stop]<BR>[05/03/2006
20:10:07]:[CallerID:051212072]:[CN:4513]:[CHANNEL STATUS : 6 = Line is
up]<BR>[05/03/2006 20:10:07]:[CallerID:051212072]:[CN:4513]:[CREDIT STATUS :
16.0833]<BR>[05/03/2006 20:10:07]:[CallerID:051212072]:[CN:4513]:[DTMF
DESTINATION ::> -1]<BR>[05/03/2006
20:10:07]:[CallerID:051212072]:[CN:4513]:[CHANNEL STATUS : -1 = There is no
channel that matches SIP/callingcard-716f]<BR>[05/03/2006
20:10:07]:[CallerID:051212072]:[CN:4513]:[CREDIT STATUS :
16.0833]<BR>[05/03/2006 20:10:07]:[CallerID:051212072]:[CN:4513]:[Start: UPDATE
cc_card SET inuse=inuse-1 WHERE username='4513']<BR>[05/03/2006
20:10:07]:[CallerID:051212072]:[CN:4513]:[STOP -
EXIT]</STRONG></FONT></FONT></DIV></BODY></HTML>