To use it, configure the module in cdr_mysql.conf. Create a table called cdr under the database name you will be using the following schema. Change the following entries in cdr_mysql.conf file located in /etc/asterisk/ folder. [global] hostname=10.0.30.47 dbname=asterisk table=cdr password=ASTERISK user=root port=3306 sock=/var/lib/mysql/mysql.sock userfield=1 loguniqueid=yes And then create a table to store the CDR data … Read more
Create mysql user id after logging through root user. mysql -u root -p yourpasswordforroot CREATE USER ‘monty’@’localhost’ IDENTIFIED BY ‘some_pass’; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON bankaccount*. TO ‘monty’@’localhost’; FLUSH PRIVILEGES;
The error ‘bearercapability notauth’ suggest that the credentials are not correct. If the credentials are definitely correct, this could indicate that the user might need to be purged on the VOIP/Asterisk server.
Asterisk SIP Trunk calling thorugh other server – Communicating two asterisk server Configuration:- Configure the following sip account in both the asterisk server like below. ServerA ServerB [serverB] type=peer context=phones host=10.0.30.47 defaultuser=serverA allow=all [serverA] type=peer context=phones host=10.0.10.16 defaultuser=serverB allow=all Now change the dialplan on both the server like the :- configure extensions.conf :- exten => … Read more
MS-Windows shared folder: You can share data between windows and linux system for such use : For example you would like to access MS-Windows share called //windowsserver/sharename by mounting to /mnt/win directory under Linux system. So execute these commands: mkdir -p /mnt/win mount -t smbfs -o username=winntuser,password=mypassword //windowsserver/sharename /mnt/win Next create the password file /etc/sambapasswords: … Read more
Create Database mysql -u root -p CREATE DATABASE asterisk; GRANT INSERT ON asterisk.* TO asterisk@localhost IDENTIFIED BY ’yourpassword’; USE asterisk; CREATE TABLE `cdr` ( `calldate` datetime NOT NULL default ’0000-00-00 00:00:00′, `clid` varchar(80) NOT NULL default ”, `src` varchar(80) NOT NULL default ”, `dst` varchar(80) NOT NULL default ”, `dcontext` varchar(80) NOT NULL default ”, `channel` varchar(80) NOT NULL default ”, `dstchannel` varchar(80) NOT NULL default ”, `lastapp` varchar(80) NOT NULL default ”, `lastdata` varchar(80) NOT NULL default ”, `duration` int(11) NOT NULL default ’0′, `billsec` int(11) NOT NULL default ’0′, `disposition` varchar(45) NOT NULL default ”, `amaflags` int(11) NOT NULL default ’0′, `accountcode` varchar(20) NOT NULL default ”, `userfield` varchar(255) NOT NULL default ” ); ALTER TABLE `cdr` ADD `uniqueid` VARCHAR(32) NOT NULL default ”; ALTER TABLE `cdr` ADD INDEX ( `calldate` ); ALTER TABLE `cdr` ADD INDEX ( `dst` ); ALTER TABLE `cdr` ADD INDEX ( `accountcode` ); Configure Asterisk CDR Mysql vim /etc/asterisk/cdr.conf [general] enabled=yes vim /etc/asterisk/cdr_mysql.conf [global] hostname=localhost dbname=asterisk table=cdr password=”yourpassword” user=asterisk port=3306 ;sock=/tmp/mysql.sock ;userfield=1 vim /etc/asterisk/modules.conf load … 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
Step 1: Add EPEL Repository in System First step is to install EPEL repository in your system, Install package using one of below urls. CentOS/RHEL 6, 32 Bit (i386): # rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm CentOS/RHEL 6, 64 Bit x86_64): # rpm -Uvh http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm CentOS/RHEL 5, 32 Bit (i386): # rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm CentOS/RHEL 5, 64 Bit … Read more
How to Install MySQL on CentOS 6.4 su to root install mysql and mysql-server download and install all dependencies done start mysql start mysql at startup
Recharge Solution | DTH recharge | Datacard Recharge | Mobile Recharge Recharge solution a zero costing. Mail us: info@eduguru.in | info@snettechnology.com [contact-form][contact-field label=’Name’ type=’name’ required=’1’/][contact-field label=’Phone Number’ type=’text’ required=’1’/][contact-field label=’Email’ type=’email’ required=’1’/][contact-field label=’Website’ type=’url’/][contact-field label=’Comment’ type=’textarea’ required=’1’/][/contact-form] mail ur requirement to replytosatya@gmail.com