I am registering one customer of a2billing in softphone and dialing one number. In asterisk i am getting below result:
-- Executing [
[email protected]:1] NoOp("SIP/XXXXXXXXXXXX-00000003", "A2Billing Start") in new stack
-- Executing [
[email protected]:2] AGI("SIP/XXXXXXXXXXXX-00000003", "a2billing.php,1") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/a2billing.php
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_request: a2billing.php
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_channel: SIP/XXXXXXXXXXXX-00000003
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_language: en
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_type: SIP
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_uniqueid: 1420010215.3
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_version: 1.8.22.0
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_callerid: XXXXXXXXXXXX
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_calleridname: unknown
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_callingpres: 0
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_callingani2: 0
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_callington: 0
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_callingtns: 0
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_dnid: XXXXXXXXXXXX
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_rdnis: unknown
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_context: a2billing
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_extension: XXXXXXXXXXXX
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_priority: 2
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_enhanced: 0.0
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_accountcode: XXXXXXXXXXXX
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_threadid: XXXXXXXXXXXX
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> agi_arg_1: 1
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >>
<SIP/XXXXXXXXXXXX-00000003>AGI Rx << VERBOSE "Directory name****/usr/share/a2billing/current/stable/AGI" 1
a2billing.php,1: Directory name****/usr/share/a2billing/current/stable/AGI
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> 200 result=1
<SIP/XXXXXXXXXXXX-00000003>AGI Rx << GET VARIABLE IDCONF
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> 200 result=0
<SIP/XXXXXXXXXXXX-00000003>AGI Rx << Connection failed
<SIP/XXXXXXXXXXXX-00000003>AGI Tx >> 510 Invalid or unknown command
[Dec 31 02:16:55] ERROR[18677]: utils.c:1232 ast_carefulwrite: write() returned error: Broken pipe
[Dec 31 02:16:55] ERROR[18677]: utils.c:1232 ast_carefulwrite: write() returned error: Broken pipe
-- <SIP/XXXXXXXXXXXX-00000003>AGI Script a2billing.php completed, returning 0
-- Auto fallthrough, channel 'SIP/XXXXXXXXXXXX-00000003' status is 'UNKNOWN'
My asterisk showing the below result on executing "realtime mysql status" command:
a2billing14 connected to
[email protected], port 3306 with username a2bdbuser for 31 minutes.
I am getting correct credential in AGI when it is trying to connect and using those credential i can connect in mysql but from CLI> i am getting connection failed error.
Thanks in advance.