Em Andamento

Asterisk-MySQL Project


I'm using Asterisk 1.2.16.

I would like to link it to a MySQL server <b>that is installed on a separate server</b> and to use the external database for 2 purposes:

1. Set all the extensions that are currently listed in [url removed, login to view], the hosts/servers that are listed in [url removed, login to view] and the mailboxes that are listed in [url removed, login to view] in tables in the database. Any change in the database would need to be applied immediately on the running Asterisk, and voicemail password changes would need to be updated in the database, in case a user changes them through the IVR.

2. I would like to build the following script:

a. Caller dials *111, *222 or *333.

b. Run a select command in a specific table in the database to exteact usr and pwd fields, where dialed is the dialed extension.

c. Update the table by marking an additional field (used) as Y for the usr/pwd read.

d. Play to the caller the usr and pwd, by using the /digits and /letters folder in /var/lib/asterisk/sounds.

e. If the caller needs to hear the usr/pwd again, allow him to press 1 to listen.

f. Disconnect the call.

Knowledgeable Asterisk users/developers are invited to send quotes. Further details can be provided.



Habilidades: Serviços de audio, Linux

Veja mais: asterisk mysql, asterisk external database, asterisk mysql sip, asterisk mysql separated server, use case extension, services letters, mysql developers, marking services, linux developers, asterisk mysql database sipconf, asterisk mysql sip table, asterisk mysql script, asterisk mysql play audio, sip asterisk getafreelancercom, link asterisk mysql database, linux asterisk mysql, sip asterisk mysql, mysql asterisk sip, asterisk update table sip, asterisk mysql update, asterisk mysql link, asterisk mysql voicemail, sipconf mysql linux, asterisk voicemail mysql, mysql asterisk

Acerca do Empregador:
( 15 comentários ) Larnaca, Israel

ID do Projeto: #152042