ISDN hangup cause codes

ISDN hangup cause codes provide information as to why a call has been terminated.  The list of hangup cause codes below provides detailed information as to the underlying cause behind a call hangup: Code No. 0 This is usually given by the router when none of the other codes apply. This cause usually occurs in … Read more

Asterisk DialStatus Channel Varriable

Asterisk channel variable DIALSTATUS Contains a text string signifying result of the last dial attempt: ANSWER: Call is answered. A successful dial. The caller reached the callee. BUSY: Busy signal. The dial command reached its number but the number is busy. NOANSWER: No answer. The dial command reached its number, the number rang for too … Read more

Asterisk cmd MYSQL

This is an ADD-ON of asterisk, is not installed by default and must be downloaded and installed with the asterisk-addons package.  However, in Asterisk 1.8 the addons have been integrated back into Asterisk. MYSQL(): Basic MYSQL Database Functionality (note that the help information returned from ‘show application MYSQL’ is a little misleading – what’s shown … Read more

Asterisk queue callback

SQL Table Structure If using the dialplan below, put the following table into a database called ‘acd‘. CREATE TABLE `bit_callers` ( `uniqueid` varchar(15) NOT NULL default ”, `callback` int(3) NOT NULL default ‘0’, `callbacknum` varchar(15) NOT NULL default ”, PRIMARY KEY (`uniqueid`), KEY `callback` (`callback`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; Dialplan Additions [support-queue] exten => s,1,Answer … Read more

php sql server connection : connect to MS SQL Server database

<?php $myServer = “localhost”; $myUser = “your_name”; $myPass = “your_password”; $myDB = “examples”; //connection to the database $dbhandle = mssql_connect($myServer, $myUser, $myPass) or die(“Couldn’t connect to SQL Server on $myServer”); //select a database to work with $selected = mssql_select_db($myDB, $dbhandle) or die(“Couldn’t open database $myDB”); //declare the SQL statement that will query the database $query … Read more

Execute root commands via PHP

I have a CentOS 5.7 linux server and use php5.3.x. On a pfSense system, you can restart services-that required root permissions using a php web page. I’m trying to do something similar, I have written some php code to execute shell commands. For example, to restart the sshd service: <?php exec(‘/sbin/service sshd restart’); ?> and … Read more