Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Tue Apr 23, 2024 3:20 pm
VoIP Billing solution


All times are UTC




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: After Update A2BILLING.PHP dont update DB
PostPosted: Mon Jul 09, 2007 7:05 pm 
Offline

Joined: Mon Jul 09, 2007 6:54 pm
Posts: 1
Sorry, my english is poor.

My problem occurs after trixbox update, after that de a2billing.php dont rum command to update DB with call info. If disconect cause is BUSY, the system work :

-- Got SIP response 486 "Busy here" back from 200.219.193.230
-- SIP/voiptrade-0822e2d0 is busy
== Everyone is busy/congested at this time (1:1/0/0)
a2billing.php: line:706 - INSERT INTO cc_call (uniqueid,sessionid,username,nasipaddress,starttime,sessiontime, calledstation, terminatecause, stoptime, calledrate, sessionbill, calledcountry, calledsub, destination, id_tariffgroup, id_tariffplan, id_ratecard, id_trunk, src, sipiax, buyrate, buycost) VALUES ('1184007642.8', 'SIP/34530306-0822b6b0', '34530306', '', CURRENT_TIMESTAMP - INTERVAL 0 SECOND , '0', '11556434533878', 'BUSY', now(), '0.16', '-0', '', '', 'goias', '3', '8', '23875', '12', '34530306', '0', '0.06', '0')
a2billing.php: line:519 - UPDATE cc_card SET inuse=inuse-1 WHERE username='34530306'
-- AGI Script a2billing.php completed, returning 0

Every other cause :

-- AGI Script Executing Application: (Dial) Options: (SIP/556434554691@voiptrade|50|HL(740676000:61000:00000))
-- Limit Data for this call:
-- - timelimit = 740676000
-- - play_warning = 61000
-- - play_to_caller= yes
-- - play_to_callee= no
-- - warning_freq = 0
-- - start_sound = UNDEF
-- - warning_sound = timeleft
-- - end_sound = UNDEF
-- Called 556434554691@voiptrade
-- SIP/voiptrade-08233b10 is making progress passing it to SIP/34534100-08230ef0
-- SIP/voiptrade-08233b10 answered SIP/34534100-08230ef0
== Spawn extension (callingcard-new, 11556434554691, 3) exited non-zero on 'SIP/34534100-08230ef0'

Please, help me.

Asterisk = 1.2.20
PHP = php-4.3.11-2.8
CNTL = php-pcntl-4.3.11-2.5.1
MYSQL = mysql-server-4.1.20-2.RHEL4.1
OS = Centos 4.5 Final


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jul 17, 2007 2:44 pm 
Offline
User avatar

Joined: Mon Apr 30, 2007 6:43 am
Posts: 1060
Location: Canada
Hello,

I am almost certain that this is due to the fact that trixbox comes with PHP4 and not PHP5.

Even by upgrading from PHP4 to PHP5, on Centos, PHP5 will be installed but it will keep using some modules of PHP4. That is particularly the case for the php-pcntl module. And that is not good. I have spent a whole night trying to install PHP5 on Centos with the desired modules in vain. It was a headache.

On the other hand, I have installed a2billing13 countless times on other linux systems (I prefer Gentoo) having php5 and apache2 and mysql5 and I didn't encounter this bug.


Top
 Profile  
 
 Post subject: Update terminatecause in DB
PostPosted: Fri Jul 20, 2007 3:40 pm 
Offline

Joined: Fri Jul 20, 2007 3:36 pm
Posts: 1
If I cant update PHP to version 5 what to do?


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jul 20, 2007 7:14 pm 
Offline
User avatar

Joined: Mon Apr 30, 2007 6:43 am
Posts: 1060
Location: Canada
Check this out http://forum.asterisk2billing.org/viewt ... ight=#7950


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


All times are UTC


Who is online

Users browsing this forum: No registered users and 8 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:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group