MySQL CDR Backend – Asterisk

by

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

Adding User Accounts mysql – asterisk database

by

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;  

“bearercapability notauth” Zoiper error

by

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.

copy a folder under linux server to windows server

by

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

Asterisk CDR in MySQL

by

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

install phpmyadmin on centos 6

by

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