Hello There.
1. please guide me how to send sms from asterisk/vicidial to local mobile.
2. how to fetch data from database for particular row. like i am using 2.1 vicidial server and i need after survey some content will sms to current number. i tried this, but data is coming from first row of database, how can i get current row data. please help me
all is well.
example of my extensions.conf
exten => _9038X.,1,AGI(agi://127.0.0.1:4577/call_log)
exten => _9038X.,2,MYSQL(Connect connid localhost root xxxx asterisk)
exten => _9038X.,3,GotoIf($["${connid}" = ""]?nodb)
exten => _9038X.,4,MYSQL(Query resultid ${connid} SELECT\ `first_name`\ FROM\ `vicidial_list`\ WHERE\ `phone_number`=${EXTEN:4}\ LIMIT\ 1 )
exten => _9038X.,5,MYSQL(Fetch foundRow ${resultid} name1)
exten => _9038NX.,7,Hangup
currently i am using API for sending sms from my asterisk. can u tell me some solution to send sms directly from my gsm gateway using sim.
kindly solve my issues.