Need to execute my personnal app but i don't know how to do it

General Help
1

Sorry if i have a bad english.

First i have created this small app and put it in extensions_custom.conf

[mycustomapp]
exten => s,1,Set(TIMEOUT(digit)=7)
exten => s,2,Set(TIMEOUT(response)=10)
exten => s,3,Playback(custom/Message)
exten => s,4,Read(UNIT|beep|10||2|5)
exten => s,5,SayDigits(${UNIT})

I entered on FreePBX and try to add a Custom Destination but only i see is this:

I am very confused, but it is all my fault, i dont have a good english…
What i will type on Custom Destination? Where i put the destination to the app?
And where i will put the ramal number to my app?

2

Custom Destination = mycustomapp,s,1

You do not need to enter a Description or Notes

3

Correction, you do need to enter the description.

4

Thank you friend for your help, this problem is solved, but now i have another problem!

The app is more complex, it needs to open a connection to a database and say a number, the code is this:
[MyCustomApp]
exten => s,1,Set(TIMEOUT(digit)=7)
exten => s,2,Set(TIMEOUT(response)=10)
exten => s,3,Playback(custom/digite-o-numero-do-cartao)
exten => s,4,Playback(en/beep)
exten => s,5,Read(NUMBER,19,3)
exten => s,6,MYSQL(Connect connid 192.168.3.33 root qwe123 teste)
exten => s,7,MYSQL(Query resultid ${connid} SELECT\ matricula\ FROM\ cartao\ WHERE\ numero=’${NUMBER}’)
exten => s,8,MYSQL(Fetch fetchid ${resultid} x1)
exten => s,9,MYSQL(Clear ${resultid})
exten => s,10,MYSQL(Disconnect ${connid})
exten => s,11,SayDigits(${x1})
exten => s,12,SayDigits(123)
exten => s,13,WaitExten()

It works the voice messages and read variable, but it seems the command mysql is being ignored and never connected to database, how to debug?

Need to install something to use Mysql function, how?
The developer used only varchar on database, so all the fields are varchar, i also tryied to use cast to convert the fields to unsigned, but stil does not work, saydigits(${x1}), never sayed nothing.

Sorry for my horrible, terrible english.

5

You are following an old tutorial on how to do mysql in asterisk. You don’t say what version of asterisk you are using, but recent versions do not permit escape characters \ in mysql queries any more, remove them and retest.

6

Thank you guys, this saved my job.
=]

7

Friends i solve all the problems, =[ But now i have another problem, the developer use a table that changes the name (its strange i know, but i just the server admin, and need to do this…)…

[MyCustomApp]
exten => s,1,Set(TIMEOUT(digit)=7)
exten => s,2,Set(TIMEOUT(response)=10)
exten => s,3,Playback(custom/digite-o-numero-do-cartao)
exten => s,4,Playback(en/beep)
exten => s,5,Read(NUMBER,19,3)
exten => s,6,MYSQL(Connect connid 192.168.3.33 root qwe123 teste)
exten => s,7,MYSQL(Query resultid ${connid} SELECT matricula FROM cartao WHERE $
exten => s,8,MYSQL(Fetch fetchid ${resultid} matricula)
exten => s,9,MYSQL(Clear ${resultid})
exten => s,10,MYSQL(Query resultid ${connid} SELECT servidor FROM parametros WH$
exten => s,11,MYSQL(Fetch fetchid ${resultid} tabserv)
exten => s,12,MYSQL(Clear ${resultid})
exten => s,13,MYSQL(Query resultid ${connid} SELECT limite_avista FROM '${tabse$
exten => s,14,MYSQL(Fetch fetchid ${resultid} x1)
exten => s,15,MYSQL(Clear ${resultid})
exten => s,16,MYSQL(Disconnect ${connid})
exten => s,17,SayDigits(${x1})

On s,10, i need to store the table name, but sounds like it is not working.
How can i debug the code?