prepaid-dest-unreachable - problem trunk ZAP

[arthur_bits]

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!!!

 

[ro30dri]

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.

 

[arthur_bits]

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

 

[ro30dri]

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

 

[arthur_bits]

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:

 

[nano]

Hola chicos, como y donde arreglaron ese detalle

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

saludos

 

[patrickerz]

Hola Rodrigo, tb soy de bolivia, cbba.
como me puedo comunicar contigo?

saludos,

 

[patrickerz]

Hola Rodrigo, tb soy de bolivia, cbba.
como me puedo comunicar contigo?

saludos,

patrickerz@gmail.com