MySQL CDR Backend – Asterisk

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

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

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

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

install phpmyadmin on centos 6

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

Install MySQL on CentOS 6.4 – Asterisk mysql database configuration

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  

Adding Listen, Whisper, and Barge to FreePBX or Asterisk

Adding Listen, Whisper, and Barge to FreePBX or Asterisk Listen: Monitor an agents call. The manager can hear both the spied-on and bridged channels, but they cannot hear the manager. Whisper:  Whisper to the agent. The manager can hear both the spied-on and bridged channels, and the spied-on channel (agent) can also hear the manager, … Read more