Skip to content

Eduguru

  • Tutorial and Training
    • SQL Server
    • Linux Tutorial
    • PHP Tutorial
    • Asterisk Tutorial
    • MySQL Tutorial
    • JavaScript Tutorial
    • C Tutorial
    • Who Breaks into Computer Systems
    • Planning and Performing Hacking Attacks
    • Maintaining Anonymity
    • Selecting Security Assessment Tools
    • Scanning Systems
  • Contact Us
    • Feedback
  • Business
    • Solutions
      • Job : Dialer Support
    • ViciDial – GoautoDial Support
    • Domain Registration
    • Web Hosting
    • Consultancy
    • Dialer Support
  • About Us
  • News
  • Donate Online
  • Offers
  • Newsletter
  • Jobs
  • Sale
    • Amazon
    • Get Computer Books
    • Amazon Sale Offer
  • Search
  • Python Tutorial
  • Search
  • WPMS HTML Sitemap
  • Log In
  • Log Out
  • Register
  • Lost Password
  • Reset Password
  • Download
  • Result
  • Newsletter
  • search
  • MySQL – Video Tutorial
  • Products Page
    • Checkout
    • Transaction Results
    • Your Account
  • Privacy

PASSWORD

ACD configuration in Asterisk

February 24, 2016January 19, 2014 by eduguru

ACD = Automatic Call Distribution It is extremely important for supervisors and the company to distribute the incoming calls among the team members. How it Works?  Incoming call will be segregated among the teams Example : Sales and Support Objective : Customer calls up a Toll Free number (1800 XXXXXX) and hears the IVR – … Read more

Categories Asterisk Tags 1, 1234, ACD = Automatic Call Distribution It is extremely important for supervisors and the company to distribute the incoming calls among the team members. How it Works? Incoming call will be segregated amon, ACD configuration in Asterisk, add the following Create the Agents Login Code which will be used for agent to login exten => 4000, AgentLogin(200) exten => 7000, e.g. using code "4000" as in the example above, hears hold music and waits for call. Inbound call gets transfered to extension 7000 and agents hears beep and inbound call gets connected to agent., Name of the Agent agent => 200, PASSWORD, Prakash Create agents in the agents.conf file and make them as members in the queue 3) Dial Plan Configuration In extensions.conf, Queue(sales) Testing This is how it works - Agent logs on, Satya agent => 100 Leave a comment

Asterisk Full RealTime Database example

March 31, 2016September 10, 2013 by eduguru
Asterisk dial command

Configure asterisk MySql connection: create the res_mysql.conf file in /etc/asterisk vi /etc/asterisk/res_mysql.conf enter the following: [general] dbhost = 127.0.0.1 dbname = asteriskrealtime dbuser = root dbpass = password dbport = 3306 save the following configuration files, we will use a very short files instead in order to simplefy the setup: cp /etc/asterisk/extensions.conf /etc/asterisk/extensions.conf_orig cp /etc/asterisk/extconfig.conf … Read more

Categories Asterisk Tags `accountcode` varchar(20) default NULL, `adminpin`, `adminpin` varchar(20) default NULL, `allow` varchar(100) default 'g729;ilbc;gsm;ulaw;alaw', `amaflags` varchar(7) default NULL, `announce` varchar(128) default NULL, `announce_frequency` int(11) default NULL, `announce_holdtime` varchar(128) default NULL, `announce_round_seconds` int(11) default NULL, `app`, `app` varchar(20) NOT NULL default '', `appdata` varchar(128) NOT NULL default '', `appdata`) values ('from-sip', `attach` varchar(4) NOT NULL default 'yes', `callback` varchar(10) NOT NULL, `callerid` varchar(80) default NULL, `callgroup` varchar(10) default NULL, `cancallforward` char(3) default 'yes', `canreinvite` char(3) default 'yes', `context` varchar(128) default NULL, `context` varchar(20) NOT NULL default '', `context` varchar(50) NOT NULL, `context` varchar(80) default NULL, `context`) ) ENGINE=MyISAM AUTO_INCREMENT=2001 DEFAULT CHARSET=latin1; CREATE TABLE `queue_table` ( `name` varchar(128) NOT NULL, `context`) VALUES ('my_queue', `customer_id` varchar(11) NOT NULL default '0', `defaultip` varchar(15) default NULL, `defaultuser` varchar(80) NOT NULL, `delete` varchar(4) NOT NULL default 'no', `deny` varchar(95) default NULL, `dialout` varchar(10) NOT NULL, `disallow` varchar(100) default 'all', `domain`, `domain` varchar(128) NOT NULL default '', `dtmfmode` varchar(7) default NULL, `email` varchar(50) NOT NULL, `envelope` varchar(4) NOT NULL default 'no', `eventmemberstatus` tinyint(1) default NULL, `eventwhencalled` tinyint(1) default NULL, `exten` varchar(20) NOT NULL default '', `forcegreetings` varchar(4) NOT NULL default 'no', `forcename` varchar(4) NOT NULL default 'no', `fromdomain` varchar(80) default NULL, `fromuser` varchar(80) default NULL, `fullcontact` varchar(80) default NULL, `fullname` varchar(150) NOT NULL, `hidefromdir` varchar(4) NOT NULL default 'yes', `host` varchar(31) NOT NULL, `insecure` varchar(4) default NULL, `interface`, `interface` varchar(128) default NULL, `interface`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; CREATE TABLE `meetme` ( `confno` varchar(80) NOT NULL default '0', `ipaddr` varchar(15) NOT NULL, `joinempty` varchar(128) default NULL, `language` char(2) default NULL, `lastms` int(11) NOT NULL, `leavewhenempty` varchar(128) default NULL, `mailbox` varchar(11) NOT NULL default '0', `mailbox` varchar(50) default NULL, `mask` varchar(95) default NULL, `maxlen` int(11) default NULL, `md5secret` varchar(80) default NULL, `memberdelay` int(11) default NULL, `membername`, `membername` varchar(40) default NULL, `members` int(11) NOT NULL default '0', `members`) VALUES ('my_conf', `monitor_format` varchar(128) default NULL, `monitor_join` tinyint(1) default NULL, `musiconhold` varchar(100) default NULL, `musiconhold` varchar(128) default NULL, `name` varchar(80) NOT NULL, `nat` varchar(5) NOT NULL default 'no', `nextaftercmd` varchar(4) NOT NULL default 'yes', `operator` varchar(4) NOT NULL default 'no', `pager` varchar(50) NOT NULL, `password` varchar(5) NOT NULL default '0', `paused` int(11) default NULL, `paused`) VALUES (1, `paused`) VALUES (2, `penalty`, `penalty` int(11) default NULL, `periodic_announce` varchar(50) default NULL, `periodic_announce_frequency` int(11) default NULL, `permit` varchar(95) default NULL, `pickupgroup` varchar(10) default NULL, `pin`, `pin` varchar(20) default NULL, `port` varchar(5) NOT NULL, `priority` tinyint(4) NOT NULL default '0', `priority`), `qualify` char(3) default NULL, `queue_callswaiting` varchar(128) default NULL, `queue_holdtime` varchar(128) default NULL, `queue_lessthan` varchar(128) default NULL, `queue_minutes` varchar(128) default NULL, `queue_name`, `queue_name` varchar(128) default NULL, `queue_reporthold` varchar(128) default NULL, `queue_seconds` varchar(128) default NULL, `queue_thankyou` varchar(128) default NULL, `queue_thereare` varchar(128) default NULL, `queue_youarenext` varchar(128) default NULL, `regexten` varchar(80) NOT NULL, `regseconds` int(11) NOT NULL default '0', `regserver` varchar(100) default NULL, `reportholdtime` tinyint(1) default NULL, `restrictcid` char(1) default NULL, `retry` int(11) default NULL, `review` varchar(4) NOT NULL default 'no', `ringinuse` tinyint(1) default NULL, `rtpholdtimeout` char(3) default NULL, `rtptimeout` char(3) default NULL, `saycid` varchar(4) NOT NULL default 'yes', `sayduration` varchar(4) NOT NULL default 'no', `saydurationm` tinyint(4) NOT NULL default '1', `secret` varchar(80) default NULL, `sendvoicemail` varchar(4) NOT NULL default 'no', `servicelevel` int(11) default NULL, `setinterfacevar` tinyint(1) default NULL, `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `strategy` varchar(128) default NULL, `timeout` int(11) default NULL, `timeoutrestart` tinyint(1) default NULL, `type` varchar(6) NOT NULL default 'friend', `tz` varchar(10) NOT NULL default 'central', `useragent` char(255) default NULL, `username`, `username` varchar(64) NOT NULL default '', `weight` int(11) default NULL, `wrapuptime` int(11) default NULL, '_*0', '_9X.', '_X.', '', ''), '${CALLERID(num)}@from-sip'), '${EXTEN}@from-sip'), '1000', '11111111', '12121111111', '12122222222', '12127777777', '12129999999', '2000', '4444', '5555', 'Dial', 'dynamic', 'friend'); ; INSERT INTO asteriskrealtime.sip_buddies ( NAME, 'friend'); inster the dial-plan in the extensions table insert into `extensions`(`context`, 'from-sip', 'from-sip'); Insert the two extensions 1000 and 2000 as members: INSERT INTO `queue_member_table` (`uniqueid`, 'MeetMe', 'my_conf'); add voicemail to ext 1000 & 2000: INSERT INTO asteriskrealtime.voicemail_users (customer_id, 'my_queue'), 'no', 'Queue', 'SIP/${EXTEN:1}@deltathree'), 'SIP/${EXTEN}|30'), 'SIP/1000', 'SIP/1000@from-sip', 'SIP/1000|60'), 'SIP/2000', 'SIP/2000@from-sip', 'SIP/2000|60'), 'sipauth.deltathree.com', 'User-A', 'User-B', 'UserA@myemail.com'); ; INSERT INTO asteriskrealtime.voicemail_users (customer_id, 'UserB@myemail.com'); Insert the new queue "my_queue": INSERT INTO `queue_table` (`name`, 'VoiceMail', 'VoiceMailMain', ${EXTEN}, 0); ; INSERT INTO `queue_member_table` (`uniqueid`, 0); insert the conference bridge: INSERT INTO `meetme` (`confno`, 0); Restart asterisk and go into the CLI: asterisk -rx "restart now" asterisk -r Check the asterisk realtime status localhost*CLI> realtime mysql status general connected to asteriskrealtime@127.0., 1, 1234, 2, 3, 4, 5 are "off" turn to "on" chkconfig --level 345 mysqld on set your mysql root password (in needed): mysqladmin -u root password password go into the mysql CLI: mysql -u root -p insert the "password" Cr, and start it if needed: /etc/init.d/mysqld status /etc/init.d/mysqld start in order to start mysql after reboot check the status chkconfig | grep mysql If 3, Asterisk Full RealTime Database example, change the extconfig.conf file as follow [settings] sippeers => mysql, Configure asterisk MySql connection: create the res_mysql.conf file in /etc/asterisk vi /etc/asterisk/res_mysql.conf enter the following: [general] dbhost = 127.0.0.1 dbname = asteriskrealtime dbuser , context, defaultuser, email ) VALUES ('1000', email ) VALUES ('2000', extensions voicemail => mysql, fullname, general, Hangup, HOST, KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=257 DEFAULT CHARSET=latin1; CREATE TABLE `voicemail_users` ( `uniqueid` int(11) NOT NULL auto_increment, KEY `mailbox_context` (`mailbox`, KEY `name_2` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=893 DEFAULT CHARSET=latin1; CREATE TABLE `extensions` ( `id` int(11) NOT NULL auto_increment, mailbox, meetme Configure sip.conf and exensioncs.conf sip.conf should Register your account and DID with the SIP provider Change the default context to "from-sip" for the inbound calls from the SIP provider. , nat, NULL, PASSWORD, port 3306 with username root for 12 seconds., PRIMARY KEY (`confno`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; verify that all tables created: mysql> show tables; +----------------------------+ | Tables_in_asteriskrealtime | +-------------------, PRIMARY KEY (`context`, PRIMARY KEY (`id`), PRIMARY KEY (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE `queue_member_table` ( `uniqueid` int(10) unsigned NOT NULL auto_increment, PRIMARY KEY (`uniqueid`), qualify, queue_member_table meetme => mysql, queue_table queue_members => mysql, secret, sip_buddies extensions => mysql, TYPE) VALUES ( '1000', TYPE) VALUES ( '2000', TYPE) VALUES ( 'deltathree', UNIQUE KEY `name` (`name`), UNIQUE KEY `queue_interface` (`queue_name`, voicemail_users queues => mysql, we we call it "asteriskrealtime" create database if not exists `asteriskrealtime`; change to the asteriskrealtime database: use asteriskrealtime; now we will create the following tables: sip_buddies e, we will use a very short files instead in order to simplefy the setup: cp /etc/asterisk/extensions.conf /etc/asterisk/extensions.conf_orig cp /etc/asterisk/extconfig.conf /etc/asterisk/extconfig.conf_, yes 2 Comments
Newer posts
← Previous Page1 Page2

Recent Posts

  • How to resolve -bash: netstat: command not found centos stream 9
  • python script to STT output in a text file
  • New Install Asterisk 18 from source on CentOS Stream 8
  • How to save audio stream from Asterisk to a file via WebSocket
  • create web socket and save data in a text file
  • How to capture and analyze traffic with tcpdump
  • Installing Asterisk 20 From source On Rocky 9
  • html drop down with search from table php mysql
  • How to Install and Use FFmpeg on CentOS 8
  • How to get duration of MP3 or wav any audio File in PHP
  • How to Change location Of MariaDB Data Directory
  • How to check partition details of MySQL table
  • internal server error when download large file php
  • iostat : How to monitor disk activity and CPU load average
  • Webrtc with Asterisk 16 : complete configuration with SIP
  • What is inode and where this is stored
  • How to create Bootstrap Dropdown button/link
  • How to check supported RAM type in Linux System
  • MySQL update table based on value of another table Join
  • How to check the Public IP: Mera Wala IP
  • How to fix WordPress 404 Errors, requested URL was not found on this server: Home Page works
  • How to create Round Buttons and Square Buttons
  • Basic and Simple Examples of Skills with CSS
  • How to SUM Columns value in MYSQL
  • How to create a data table in bootstrap PHP and MySQL ?
  • How to DELETE Data Into MySQL Database Using PHP ?
  • How to Create MySQL user and Grant permission ?
  • What is XML & HTML ? What is Difference Between XML & HTML?
  • What is MySQL Binary logs ,their usages and how to purge binary logs ?
  • How to Select Data Into MySQL Database Using PHP ?
  • How to Remove spaces from string in MySQL ?
  • What is Different Between CHAR & VARCHAR ?
  • How to Insert Data Into MySQL Database Using PHP
  • What is MySQL SELECT Statement And Example of MySQL SELECT Query
  • What is INSERT Statement And Example of INSERT Query ?
  • What is MySQL Cluster vs Replication ?
  • How to Protect your computer from viruses and malware ?
  • What is the Use of Motherboard in a Computer ?
  • Happy Teacher’s Day 2022 – Quotes and Greetings on Teachers’ Day
  • NDA exam date question paper 2022 download and solution
  • What is Need of Information Security?
  • What is Information Security ?
  • How to Secure Web server ?
  • What is JSP ?
  • What is DDoS Attack ? & How Google Stopped the Largest -ever DDoS Attack ?
  • what is Malware ? And How to Stay Protected from Malware Attacks?
  • Best Practices to secure from DDoS Attack
  • How to protect Your Site Against DDoS Attack
  • How to secure from DDoS Attack
  • What is DDoS Attack. Basic introduction of DDoS

Recent Post

  • How to resolve -bash: netstat: command not found centos stream 9
  • python script to STT output in a text file
  • New Install Asterisk 18 from source on CentOS Stream 8
  • How to save audio stream from Asterisk to a file via WebSocket
  • create web socket and save data in a text file
© 2026 Eduguru • Built with GeneratePress