No outbound Calling

[ALEM]

Dear All

I cant seem to be able to make outgoing calls. Incoming works fine but out going fail. Bellow if the debug trace i get when i call. 

not ips are changed

Using SIP RTP CoS mark 5

       > 0x7f87a400b420 -- Strict RTP learning after remote address set to: 192.XXX.XXX.XXX:5020

    -- Executing [0XXXXXXXXX@billing:1] AGI("SIP/1001-00000000", ""/var/www/html/mbilling/resources/asterisk/mbilling.php"") in new stack

    -- Launched AGI Script /var/www/html/mbilling/resources/asterisk/mbilling.php

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Start MBilling AGI

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT id, config_key , config_value , config_group_title  FROM pkg_configuration

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Start MBilling AGI

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Check If Is Did XXXXXXXXX

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT * FROM pkg_did WHERE did = 'XXXXXXXXX' AND activated = 1 LIMIT 1

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT * FROM pkg_sip WHERE name = '0XXXXXXXXX' OR (alias = '0XXXXXXXXX' AND accountcode = '1001') LIMIT 1

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": CALL TO PSTN

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": AuthenticateUser 1001

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT * FROM pkg_sip WHERE techprefix = '073333' AND host != 'dynamic' LIMIT 1

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Try accountcode authentication 1001

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT *, u.id id, u.id_user id_user FROM pkg_user u INNER JOIN pkg_plan p ON u.id_plan = p.id WHERE username = '1001'  LIMIT 1

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT * FROM pkg_sip WHERE name = '1001' LIMIT 1

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": AUTHENTICATION BY ACCOUNTCODE:1001

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": check user call limit

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT name FROM pkg_sip WHERE accountcode = ''

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": use_dnid:1 && len_dnid:(10 || len_exten:10 ) && (try_num:0)

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": USE_DNID DESTINATION -> 0XXXXXXXXX

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": REMOVE INTERNACIONAL PREFIX -> 0XXXXXXXXX

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Grab :0 Replacement: 254 Phone Before: 0XXXXXXXXX

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Phone After translation: 254XXXXXXXXX

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": consulta portabilidade numero 254XXXXXXXXX

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": USERNAME=1001 DESTINATION=254XXXXXXXXX PLAN=3 CREDIT=20000

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT length FROM pkg_prefix_length WHERE code = '25' LIMIT 1

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT lcrtype, pkg_plan.id AS id_plan, pkg_prefix.prefix AS dialprefix,

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                 pkg_plan.name, pkg_rate.id_prefix, pkg_rate.id AS id_rate, buyrate,  buyrateinitblock buyrateinitblock,

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                 buyrateincrement, rateinitial, initblock, billingblock, connectcharge, disconnectcharge disconnectcharge,

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                 pkg_rate.id_trunk AS id_trunk, pkg_trunk.trunkprefix AS rc_trunkprefix, pkg_trunk.directmedia AS rc_directmedia,

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                 pkg_trunk.providertech AS rc_providertech ,pkg_trunk.providerip AS rc_providerip,

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                 pkg_trunk.removeprefix AS rc_removeprefix, pkg_trunk.failover_trunk AS rt_failover_trunk,

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                 pkg_trunk.addparameter AS rt_addparameter_trunk, pkg_trunk.status, pkg_trunk.inuse, pkg_trunk.maxuse,

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                 pkg_trunk.allow_error,pkg_trunk.if_max_use, pkg_rate.additional_grace AS additional_grace, minimal_time_charge,

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                 minimal_time_buy, pkg_trunk.link_sms, pkg_trunk.user user, pkg_trunk.secret, package_offer ,

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                 pkg_trunk.id_provider, pkg_provider.credit_control, pkg_provider.credit

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                 FROM pkg_plan

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                 LEFT JOIN pkg_rate ON pkg_plan.id = pkg_rate.id_plan

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                 LEFT JOIN pkg_trunk AS pkg_trunk ON pkg_trunk.id = pkg_rate.id_trunk

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                 LEFT JOIN pkg_prefix ON pkg_rate.id_prefix = pkg_prefix.id

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                 LEFT JOIN pkg_provider ON pkg_trunk.id_provider = pkg_provider.id

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                 WHERE pkg_plan.id=3 AND pkg_rate.status = 1 AND (prefix='254' OR prefix='25' OR prefix='2' )

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                 ORDER BY LENGTH( prefix ) DESC LIMIT 1

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT * FROM pkg_user_rate WHERE id_user = 2 AND id_prefix = '1' LIMIT 1

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": NUMBER TRUNK FOUND 1

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": NUMBER TARIFF FOUND -> 1

> "/var/www/html/mbilling/resources/asterisk/mbilling.php": Credit 20000

> "/var/www/html/mbilling/resources/asterisk/mbilling.php": timeout ->> 400000

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": UPDATE pkg_call_chart SET total = total + 1 WHERE date > '2019-03-01 03:20' LIMIT 1

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": UPDATE pkg_trunk SET  call_total = call_total + 1 WHERE id=1 LIMIT 1

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": DIAL sip/+254XXXXXXXXX/254XXXXXXXXX,60,L(400000000:61000:30000)

    -- AGI Script Executing Application: (DIAL) Options: (sip/+254XXXXXXXXX/254XXXXXXXXX,60,L(400000000:61000:30000))

       > Limit Data for this call:

> timelimit = 400000000 ms (400000.000 s)

> play_warning = 61000 ms (61.000 s)

       > play_to_caller = yes

       > play_to_callee = no

> warning_freq = 30000 ms (30.000 s)

       > start_sound    =

       > warning_sound  = timeleft

       > end_sound      =

  == Everyone is busy/congested at this time (1:0/0/1)

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Call send for backup trunk -> ERROR => CHANUNAVAIL

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": USEDRATECARD - FAIL =1

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Update System

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Sessiontime0

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": CALL: used tariff K=1 - (sessiontime=0 :: dialstatus=CHANUNAVAIL)

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": 6 0+0 = 0

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php": INSERT INTO pkg_cdr_failed (uniqueid,id_user,calledstation,id_plan,id_trunk,callerid,src,

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                         starttime, terminatecauseid,sipiax,id_prefix) VALUES ('1551421246.0', '2','254XXXXXXXXX','3',

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                         '1','+254730870001', '1001',

       > "/var/www/html/mbilling/resources/asterisk/mbilling.php":                         '2019-03-01 03:20:46', '6','0','1')

    -- <SIP/1001-00000000>AGI Script /var/www/html/mbilling/resources/asterisk/mbilling.php completed, returning 0

    -- Executing [0XXXXXXXXX@billing:2] Hangup("SIP/1001-00000000", "") in new stack

  == Spawn extension (billing, 0XXXXXXXXX, 2) exited non-zero on 'SIP/1001-00000000'

    -- Executing [h@billing:1] Hangup("SIP/1001-00000000", "") in new stack

  == Spawn extension (billing, h, 1) exited non-zero on 'SIP/1001-00000000'