prepaid-dest-unreachable - problem trunk ZAP

Discussion in 'General' started by arthur_bits, Apr 30, 2009.

  1. arthur_bits

    Joined:
    Mar 31, 2009
    Messages:
    9
    Likes Received:
    0
    greetings!

    I have a problem with a zap trunk without A2Billing
    if I can make calls, but when I try to use it
    I said that is not available to dial the number, asks me the pin number, I said that I have the balance and minutes available and the number you want to dial, but it remains the same mistake, :(

    Trunk: ZAP/g0
    elastix: 1.5

    someone knows that this happens?



    LOG CLI:

    a2billing.php: file:a2billing.php - line:138 - [ANSWER CALL]
    a2billing.php: file:Class.A2Billing.php - line:1797 - Requesting DTMF, CARDNUMBER_LENGTH_MAX 15
    -- <SIP/200-08f88fb0> Playing 'prepaid-enter-pin-number' (language 'en')
    a2billing.php: file:Class.A2Billing.php - line:1799 - RES DTMF : 0107330240
    a2billing.php: file:Class.A2Billing.php - line:1803 - CARDNUMBER ::> 0107330240
    a2billing.php: file:Class.A2Billing.php - line:1826 - QUERY = SELECT credit, tariff, activated, inuse, simultaccess, typepaid, creditlimit, language, removeinterprefix, redial, enableexpire, UNIX_TIMESTAMP(expirationdate), expiredays, nbused, UNIX_TIMESTAMP(firstusedate), UNIX_TIMESTAMP(cc_card.creationdate), cc_card.currency, cc_card.lastname, cc_card.firstname, cc_card.email, cc_card.uipass, cc_card.id, cc_card.id_campaign, cc_card.id, useralias FROM cc_card LEFT JOIN cc_tariffgroup ON tariff=cc_tariffgroup.id WHERE username='0107330240'
    a2billing.php: Array
    a2billing.php: (
    a2billing.php: [0] => Array
    a2billing.php: (
    a2billing.php: [0] => 22.50000
    a2billing.php: [credit] => 22.50000
    a2billing.php: [1] => 1
    a2billing.php: [tariff] => 1
    a2billing.php: [2] => t
    a2billing.php: [activated] => t
    a2billing.php: [3] => 0
    a2billing.php: [inuse] => 0
    a2billing.php: [4] => 0
    a2billing.php: [simultaccess] => 0
    a2billing.php: [5] => 0
    a2billing.php: [typepaid] => 0
    a2billing.php: [6] =>
    a2billing.php: [creditlimit] =>
    a2billing.php: [7] => es
    a2billing.php: [language] => es
    a2billing.php: [8] => 0
    a2billing.php: [removeinterprefix] => 0
    a2billing.php: [9] =>
    a2billing.php: [redial] =>
    a2billing.php: [10] => 0
    a2billing.php: [enableexpire] => 0
    a2billing.php: [11] => 1556570971
    a2billing.php: [UNIX_TIMESTAMP(expirationdate)] => 1556570971
    a2billing.php: [12] => 0
    a2billing.php: [expiredays] => 0
    a2billing.php: [13] => 0
    a2billing.php: [nbused] => 0
    a2billing.php: [14] => 0
    a2billing.php: [UNIX_TIMESTAMP(firstusedate)] => 0
    a2billing.php: [15] => 1241038223
    a2billing.php: [UNIX_TIMESTAMP(cc_card.creationdate)] => 1241038223
    a2billing.php: [16] => MXN
    a2billing.php: [currency] => MXN
    a2billing.php: [17] => gardea
    a2billing.php: [lastname] => gardea
    a2billing.php: [18] => Arturo
    a2billing.php: [firstname] => Arturo
    a2billing.php: [19] =>
    a2billing.php: =>
    a2billing.php: [20] => 123456
    a2billing.php: [uipass] => 123456
    a2billing.php: [21] => 1
    a2billing.php: [id] => 1
    a2billing.php: [22] => -1
    a2billing.php: [id_campaign] => -1
    a2billing.php: [23] => 1
    a2billing.php: [24] => 200
    a2billing.php: [useralias] => 200
    a2billing.php: )
    a2billing.php:
    a2billing.php: )
    a2billing.php:
    a2billing.php: file:Class.A2Billing.php - line:1898 - [SET LANGUAGE() es]
    a2billing.php: file:Class.A2Billing.php - line:634 - [CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse+1 WHERE username='0107330240']
    a2billing.php: file:Class.A2Billing.php - line:1969 - [A2Billing] SAY BALANCE : 22.50000
    a2billing.php:
    a2billing.php: file:Class.A2Billing.php - line:1122 - [CURRENCY : MXN]
    -- Playing 'prepaid-you-have' (escape_digits=#) (sample_offset 0)
    -- <SIP/200-08f88fb0> Playing 'digits/200' (language 'es')
    -- <SIP/200-08f88fb0> Playing 'digits/40' (language 'es')
    -- <SIP/200-08f88fb0> Playing 'digits/1' (language 'es')
    -- Playing 'pesos' (escape_digits=#) (sample_offset 0)
    -- Playing 'vm-and' (escape_digits=#) (sample_offset 0)
    -- <SIP/200-08f88fb0> Playing 'digits/40' (language 'es')
    -- <SIP/200-08f88fb0> Playing 'digits/1' (language 'es')
    -- Playing 'prepaid-cents' (escape_digits=#) (sample_offset 0)
    a2billing.php: file:Class.A2Billing.php - line:1427 - [AUTO SetCallerID]
    a2billing.php: file:Class.A2Billing.php - line:1433 - [REQUESTED SetCallerID : 200]
    a2billing.php: file:Class.A2Billing.php - line:1444 - [EXEC SetCallerID : 200]
    a2billing.php: file:a2billing.php - line:169 - [CHANNEL STATUS : 6 = Line is up]
    a2billing.php: file:a2billing.php - line:170 - [CREDIT : 22.50000][CREDIT MIN_CREDIT_2CALL : 0]
    a2billing.php: file:Class.A2Billing.php - line:656 - && && 7&& 0
    -- <SIP/200-08f88fb0> Playing 'prepaid-enter-dest' (language 'es')
    a2billing.php: file:Class.A2Billing.php - line:663 - RES DTMF : 4390100
    a2billing.php: file:Class.A2Billing.php - line:681 - DESTINATION ::> 4390100
    a2billing.php: file:Class.A2Billing.php - line:683 - RULES APPLY ON DESTINATION ::> 4390100
    a2billing.php: file:Class.A2Billing.php - line:721 - OK - RESFINDRATE::> 1
    a2billing.php: file:Class.A2Billing.php - line:743 - RES_ALL_CALCULTIMEOUT ::> 1
    a2billing.php: file:Class.A2Billing.php - line:760 - TIMEOUT::> 2700 : minutes=45 - seconds=0
    -- Playing 'prepaid-you-have' (escape_digits=#) (sample_offset 0)
    -- <SIP/200-08f88fb0> Playing 'digits/40' (language 'es')
    -- <SIP/200-08f88fb0> Playing 'digits/5' (language 'es')
    -- Playing 'prepaid-minutes' (escape_digits=#) (sample_offset 0)
    a2billing.php: file:Class.RateEngine.php - line:960 - app_callingcard: Dialing 'ZAP/g0/4390100|60|HRrL(2700000:61000:30000)' with timeout of '2700'.
    a2billing.php:
    a2billing.php: file:Class.RateEngine.php - line:985 - app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.
    -- AGI Script Executing Application: (Dial) Options: (ZAP/g0/4390100|60|HRrL(2700000:61000:30000))
    -- Limit Data for this call:
    > timelimit = 2700000
    > play_warning = 61000
    > play_to_caller = yes
    > play_to_callee = no
    > warning_freq = 30000
    > start_sound = (null)
    > warning_sound = timeleft
    > end_sound = (null)
    == Everyone is busy/congested at this time (1:0/0/1)
    a2billing.php: file:Class.RateEngine.php - line:1095 - [USEDRATECARD - FAIL =0]
    -- Playing 'prepaid-dest-unreachable' (escape_digits=#) (sample_offset 0)
    a2billing.php: file:Class.RateEngine.php - line:848 - [CC_asterisk_stop QUERY = 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, id_card_package_offer) VALUES ('1241042150.4', 'SIP/200-08f88fb0', '0107330240', '', CURRENT_TIMESTAMP - INTERVAL 0 SECOND , '0', '4390100', 'CHANUNAVAIL', now(), '0.5', '-0', '', '', 'Internacional', '1', '1', '1', '2', '200', '0', '0.23', '0', '0')]
    a2billing.php: file:Class.RateEngine.php - line:851 - [CC_asterisk_stop 1.1: SQL: DONE : result=1]
    a2billing.php: file:a2billing.php - line:309 - [a2billing account stop]
    a2billing.php: file:a2billing.php - line:169 - [CHANNEL STATUS : 6 = Line is up]
    a2billing.php: file:a2billing.php - line:170 - [CREDIT : 22.50000][CREDIT MIN_CREDIT_2CALL : 0]
    a2billing.php: file:Class.A2Billing.php - line:656 - 0 && && 7&& 1
    -- <SIP/200-08f88fb0> Playing 'prepaid-enter-dest' (language 'es')
    a2billing.php: file:Class.A2Billing.php - line:663 - RES DTMF : -1
    a2billing.php: file:Class.A2Billing.php - line:681 - DESTINATION ::> -1
    a2billing.php: file:Class.A2Billing.php - line:683 - RULES APPLY ON DESTINATION ::> -1
    -- Playing 'prepaid-invalid-digits' (escape_digits=#) (sample_offset 0)
    -- Executing [h@from-internal:1] Macro("SIP/200-08f88fb0", "hangupcall") in new stack
    -- Executing [s@macro-hangupcall:1] ResetCDR("SIP/200-08f88fb0", "vw") in new stack
    -- Executing [s@macro-hangupcall:2] NoCDR("SIP/200-08f88fb0", "") in new stack
    -- Executing [s@macro-hangupcall:3] GotoIf("SIP/200-08f88fb0", "1?skiprg") in new stack
    -- Goto (macro-hangupcall,s,6)
    -- Executing [s@macro-hangupcall:6] GotoIf("SIP/200-08f88fb0", "1?skipblkvm") in new stack
    -- Goto (macro-hangupcall,s,9)
    -- Executing [s@macro-hangupcall:9] GotoIf("SIP/200-08f88fb0", "1?theend") in new stack
    -- Goto (macro-hangupcall,s,11)
    -- Executing [s@macro-hangupcall:11] Hangup("SIP/200-08f88fb0", "") in new stack
    == Spawn extension (macro-hangupcall, s, 11) exited non-zero on 'SIP/200-08f88fb0' in macro 'hangupcall'
    == Spawn extension (from-internal, s, 1) exited non-zero on 'SIP/200-08f88fb0'[/i]



    THANKS!!!
     
  2. ro30dri

    Joined:
    Jul 8, 2008
    Messages:
    16
    Likes Received:
    0
    I have he same problem with my a2billing box.
    I configurate the zap trunk and the outbound route using the elastix web interface.
    made satisfactory test from an extension but when use a2 billing ca not completed the call (CHANUNAVAILABLE)

    Any help
    Sorry for my english.
     
  3. arthur_bits

    Joined:
    Mar 31, 2009
    Messages:
    9
    Likes Received:
    0
    yo sigo con el mismo problema, realicé la instalación de a2billing en un trixbox, y me funcionó, te adjunto la info, la única diferencia que encuentro es la base de datos, uno es de postgres el del trixbox, y el del elastix es de mysql, e instalado varias veces el trixbox, y ahi el a2billing el 1.3.4 o 1.3.2 y cargo el respaldo y todo funciona, pero en elastix no eh podido hacerlo funcionar,

    te adjunto el respaldo por si te sirve de algo, espero encontrar una pronta solución, veo los manuales y es muy claro lo que hay que configurar no se en donde esté el error, a y si no uso el a2billing, mis canales ZAP funcionan correctamente, el problema está cuando quiero utilizar el a2billing


    Saludos espero puedas encontrar el por que,

    nota: escribo en español por tu comentario sobre el ingles, yo soy de México



    ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

    I continue with the same problem, did the installation of a a2billing
    TrixBox, and I ran, I attached the info, the only difference
    encounter is the database, is one of the postgres TrixBox, and
    of elastix is mysql, and installed several times TrixBox, and that the
    a2billing the 1.3.4 or 1.3.2 and the back office and everything works, but
    eh elastix not able to operate,

    you attach the backup if you use something, I hope to find a
    early settlement, see the manuals and it is very clear what needs to be
    set is not where the error,

    greetings I hope you find that
    http://forum.elastix.org/old_files/db_a2billing_20090722220300.gz
     
  4. ro30dri

    Joined:
    Jul 8, 2008
    Messages:
    16
    Likes Received:
    0
    Pues ya solucione mi problema, yo estaba usando la version Elastix 1.5.2-2, en la cual se deja de usar los canales ZAP y cambia todo por DAHDI, ya no usa zapata.conf y cambia por chan-dahdi.conf, etc etc....pues en la configuracion de la troncal a2billing el campo PROVIDER TECH q normalmente era ZAP se cambia por DAHDI, y el campo PROVIDER IP se coloca el group correspondiente a tu puerto FXO que configuraste en el dahdi-channels.conf en mi caso g2.
    Claro q previamente necesitas configurar la troncal y el outbound route con su correspondiente dialplan del elastix.

    Espero te sirva.
    Saludos desde Bolivia
     
  5. arthur_bits

    Joined:
    Mar 31, 2009
    Messages:
    9
    Likes Received:
    0
    hasta hoy e podido probar tu solución en un servidor de prueba, y efectivamente eso es todo lo que estaba fallando, e cambiado a DAHDI en lugar de ZAP, y todo funciona correctamente, te agradezco mucho ro30dri por tu respuesta y solución,

    saludos hasta Bolivia!:cheer:
     
  6. nano

    Joined:
    Mar 2, 2008
    Messages:
    59
    Likes Received:
    0
    Hola chicos, como y donde arreglaron ese detalle

    Tengo que usar A2billing en un asterisk con una tarjeta para E1.

    saludos
     
  7. patrickerz

    Joined:
    Sep 28, 2010
    Messages:
    2
    Likes Received:
    0
    Hola Rodrigo, tb soy de bolivia, cbba.
    como me puedo comunicar contigo?

    saludos,
     
  8. patrickerz

    Joined:
    Sep 28, 2010
    Messages:
    2
    Likes Received:
    0
    Hola Rodrigo, tb soy de bolivia, cbba.
    como me puedo comunicar contigo?

    saludos,

    patrickerz@gmail.com
     

Share This Page