Database Matter The first step is to open up phpMyAdmin or a database software and incorporate the below query into the SQL section. 1 2 3 4 5 6 CREATE TABLE `searchengine` ( `id` INT NOT NULL AUTO_INCREMENT , `pageurl` VARCHAR( 255 ) NOT NULL , `pagecontent` TEXT NOT NULL , PRIMARY KEY ( `id` … Read more
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