한국어

IPPBX/GW

온누리070 플레이스토어 다운로드
    acrobits softphone
     온누리 070 카카오 프러스 친구추가온누리 070 카카오 프러스 친구추가친추
     카카오톡 채팅 상담 카카오톡 채팅 상담카톡
    
     라인상담
     라인으로 공유

    
페북공유

   ◎위챗 : speedseoul


  
     PAYPAL
     
     PRICE
     

pixel.gif

    before pay call 0088 from app


Insert into dialplan Asterisk

2017.08.26 14:42

admin 조회 수:23944



https://community.asterisk.org/t/solved-insert-into-via-dialplan/69469



Goodmorning i had configured this dialplan on extension.conf into asterisk

[test]
exten => s,1,Answer();
exten => s,n,Playback(welcome);
exten => s,n,SayDigits(1);
;exten => s,n,SayAlpha(Accettare);
exten => s,n,SayDigits(2);
;exten => s,n,SayAlpha(Declinare);
;exten => s,n,Read(pippo,enter-ext-of-person);
;exten => s,n,SayNumber(${pippo});
exten => s,n,WaitExten();

exten => 1,1,Playback(you-entered);
exten => 1,n,SayDigits(${EXTEN});
exteb => 1,n,MYSQL(Connect connid localhost marco marco finaziamenti)
exten => 1,n,MYSQL(Query resultid ${connid} 'INSERT INTO 'a'('a') Values (1);
exten => 1,n,MYSQL(Clear ${resultid});
exten => 1,n,MYSQL(Disconnect ${connid});
exten => 1,n,Wait(2);
exten => 1,n,Playback(hello-world);

exten => 2,1,Playback(you-entered);
exten => 2,n,SayDigits(${EXTEN});
exten => 2,n,Read(number)
exten => 2,n,SayDigits(${number});
exten => 2,n,Wait(2);
exten => 2,n,Playback(goodbye);

when the user types 1 should insert into the table the record set but nothing happen
the db user have all privileges and grant option on db 

table a with column a INT

i hope somebody could help me

thanks

번호 제목 글쓴이 날짜 조회 수
98 php memory and filesize increase upload wav admin 2019.06.25 7488
97 changing SIP drivers to CHAN_PJSIP Please err 에러 admin 2019.06.21 8494
96 /dev/mapper/ubuntu--vg-root filling up admin 2019.04.08 14960
95 Configuring Your PBX admin 2017.08.17 23035
94 how-to-freepbx-13-firewall-setup admin 2017.08.14 23079
93 Asterisk dialolan detail explan good easy clean admin 2017.08.26 23086
92 RPi Text to Speech (Speech Synthesis) admin 2017.08.24 23228
91 asterisk XactView V3-CRM Widget admin 2017.08.24 23301
90 IVR actions asterisk admin 2017.08.31 23324
89 /sbin/service httpd start stop web start stop admin 2017.08.16 23390
88 Asterisk 13 Debian 8 admin 2015.11.13 23391
87 Google letter agi admin 2017.08.26 23395
86 User Control Panel (UCP) 14+ admin 2017.08.23 23448
85 NAT 와 VoIP 시그널과 RTP 전송 영향 NAT와 방화벽/STUN/TURN/ICE/SBC admin 2017.08.19 23469
84 FreePBX 12 – Getting Started Guide admin 2017.08.29 23474
83 download Installing+AsteriskNOW admin 2017.08.25 23479
82 asterisk freepbx TTS Engine Custom - Amazon Polly - 24 languages admin 2017.08.24 23515
81 Asterisk/IVR/PBX/VoIP/Contact center/Voicebroadcast engineer admin 2017.08.25 23526
80 AsterSwitchboard CTI Operator Panel for Asterisk admin 2017.08.08 23536
79 github A2Billing is commercially supported by Star2Billing admin 2017.08.26 23580
78 thirdlane PBX price admin 2017.08.23 23615
77 Asterisk based auto dialer test and verified by 300+ concurrent. admin 2017.08.31 23622
76 Text to Speech User Guide admin 2017.08.24 23643
75 Capturing SIP and RTP traffic using tcpdump admin 2017.08.17 23658
74 SUGAR CRM admin 2017.08.23 23667
73 asterisk Chapter 6. Dialplan Basics admin 2017.08.25 23674
72 Configuring an Asterisk server admin 2015.05.05 23695
71 FOIP: T.38 Fax Relay vs. G.711 Fax Pass-Through (Fax Over IP) admin 2015.09.24 23713
70 asterisk IVR 쉽게 설정하기 admin 2017.08.16 23719
69 OPUS and VP9 Bitrates admin 2017.08.17 23723
68 Asterisk Downloads AsteriskNOW Software PBX admin 2015.05.05 23811
67 Top 10 greater worker admin 2017.08.26 23818
66 TwistedWave Online A browser-based audio editor admin 2017.08.25 23858
65 Considerations for Using T.38 versus G.711 for Fax over IP file admin 2015.09.24 23937
» Insert into dialplan Asterisk admin 2017.08.26 23944
63 asterisk FreePBX 14, Distro 14 & More! admin 2017.08.16 23963
62 FreePBX – Custom FAX to email admin 2015.05.05 23972
61 HOW TO INSTALL FREEPBX ON CENTOS 7 admin 2017.08.24 23988
60 Asterisk 설치 준비 admin 2015.11.15 24003
59 FaxServer using Asterisk admin 2015.05.05 24027
58 User Control Panel (UCP) asterisk freepbx admin 2017.08.17 24030
57 A simple IVR and Queue example where customer listens to marketing materials .. admin 2015.05.05 24034
56 Generic Asterisk SIP Configuration Guide admin 2015.05.05 24034
55 Asterisk Freepbx Install Guide (CentOS v7, Asterisk v13, Freepbx v13) admin 2017.08.23 24039
54 Fax Configuration FREE PBX and asterisk FAX admin 2015.05.05 24040
53 Brand New Sealed Sangoma FreePBX 60 - 75 Users or 30 Calls admin 2017.08.05 24071
52 Asterisk A simple IVR admin 2015.05.05 24079
51 fax licenses Asterisk admin 2015.05.05 24080
50 WombatDialer is highly scalable, multi-server, works with your existing Asterisk PBX. admin 2017.08.31 24086
49 How to Install Asterisk 13 on Ubuntu 16.04 from Source admin 2017.08.23 24105
48 음성통화 서버 Asterisk + FreePBX / 통화 시연해보기 admin 2017.08.18 24114
47 우분투 Mumble VoIP 음성채팅서버 구축 admin 2017.08.18 24135
46 Installing FreePBX 14 on Debian 8.8 These instructions work fine admin 2017.08.29 24146
45 초보) Asterisk , AsteriskNow 무엇인가? 무슨차이인가? 시작 배우기 쉽게 이해 공부 사용 admin 2017.08.29 24148
44 FAX over IP sofware admin 2015.05.05 24174
43 Price ,,Install Commercial Modules on CentOS and RHEL based admin 2017.08.16 24240
42 T.38 Fax Gateway Asterisk admin 2015.05.05 24280
41 Setup Asterisk 13 with FreePBX 13 in CentOS 7 admin 2017.08.24 24305
40 Incoming Fax Handling admin 2015.05.05 24327
39 iptables for asterisk simple example configuration admin 2017.08.31 24351
38 Asterisk Answering Machine Detection (AMD) Configuration admin 2017.08.17 24371
37 Installing SNG7 Official Distro admin 2017.08.17 24372
36 AGI asterisk gateway interface synopsis admin 2017.08.26 24433
35 Fax For Asterisk download add on 1 port free IVR prompt G.729 admin 2015.05.05 24454
34 How to install and setup Asterisk 14 (PBX) on CentOS 7 admin 2017.08.23 24454
33 Using Asterisk to Detect and Redirect Fax Calls for Communications Server admin 2015.05.05 24465
32 MP3 to WAV, WMA to WAV, OGG Convert audio to WAV online admin 2015.05.09 24492
31 Setup FAX on Asterisk with DIDForSale SIP DIDs admin 2015.05.05 24559
30 Playing text to speech inside read function in asterisk admin 2017.08.28 24571
29 Smart Predictive Auto calling Software System: Automatic Phone Calling admin 2017.08.31 24590
28 Introducing Asterisk Call Distribution ACD asterisk admin 2017.08.31 24616
27 Dialplan handler routines allow customization admin 2017.08.26 24688
26 Asterisk Answering Machine Detection (AMD) Configuration admin 2017.09.01 24698
25 asterisk CRM SUGARCRM SuiteCRM admin 2017.08.24 24743
24 Automatic Call Distribution (ACD) Asterisk as Call Center admin 2017.08.31 24775
23 Setup install Asterisk PBX telephony system | VOIP Tutorial admin 2015.05.05 24792
22 asterisk dialplan 설명 admin 2017.08.16 24860
21 How to build an outbound Call Center with Newfies-Dialer and Asterisk/FreePBX admin 2017.08.31 24879
20 Asterisk tips ivr menu Interactive voice response menus admin 2015.05.05 25170
19 Text to speech for asterisk using Google Translate admin 2017.08.24 25237
18 Hosting Cheap VPS Hosting that doesn’t feel cheap admin 2017.08.24 25253
17 Installing AsteriskNOW Official Distro admin 2015.05.05 25484
16 Speech Recognition on Asterisk: Getting Started admin 2017.08.28 25705
15 Asterisk 가장쉬운 설치 및 설정 사용 방법 이해 할수있게 배우는 순서 안내 설명 admin 2017.08.16 25936
14 VICIdial Scratch Installation CentOS 7 & MariaDB & Asterisk 11 & Latest VICIdial SVN admin 2017.09.02 25972
13 Freepbx on Debian (Debian v7, Asterisk v11, Freepbx v2.11) admin 2015.05.05 26065
12 Asterisk fax Asterisk and fax calls Fax over IP admin 2015.05.05 26643
11 List of 5 Open Source Call Center Software Programs admin 2017.08.31 26652
10 Asterisk Quick Start Guide admin 2015.05.05 26838
9 A2Billing v2.2 Install Guide CentOS v7 Asterisk v11 v13 seems to work FreePBX v13 admin 2017.08.23 27219
8 Securing Your Asterisk VoIP Server with IPTables admin 2015.05.05 27684
7 A2Billing v2 Install Guide admin 2015.05.05 27823
6 Asterisk Freepbx Install Guide (CentOS v6, Asterisk v13, Freepbx v12) admin 2015.05.05 28630
5 Fusionpbx v4 Freeswitch v1.6 CentOS v7 Install Guide admin 2017.08.23 29020
4 How to Install Asterisk on CentOS 7 easy clean explain 깔금한 쉬운 설명 admin 2017.08.23 30268
3 라즈베리파이, 아스타리스크(asterisk) PBX(사설교환기) admin 2017.08.23 31469
2 Asterisk AGI/AMI to ARI Asterisk&FreePbx - IVR setting admin 2015.05.05 33364
1 Make Your Own IVR with Asterisk admin 2017.08.26 37980