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`...
Tuesday, May 7, 2013
Friday, May 3, 2013
A2BILLING INSTALLATION GUIDE
To RUN this install PHP 5.2 or later as it wont work on
earlier version because of filter_var() issue as in 5.2 it is already installed
as a bundle
-----------
This document
focuses on the installation of A2Billing system for the Asterisk open source
PBX. The document covers the installation and basic
configuration of
A2Billing.
A2billing is an open source implementation of a telecommunication billing and
added value services platform.
A2billing is a
LAMP (Linux Apache Mysql(Postgresql)...
Sunday, January 6, 2013
How to uninstall (remove) Conduit toolbar from Mozilla
First of all, uninstall it using the common way: Go Start. In the opened menu find Control Panel and click on it. Select Add/Remove Programs Then find Conduit Toolbar and remove it. The program's name may be changed to "Bittorent toolbar" if you downloaded it together with uTorrent. These two steps may solve your problem. If not, proceed to the following steps. Remove Conduit Toolbar from Internet Explorer: Open Internet Explorer Then click Tools, in the drop-down menu select Internet...
Saturday, September 22, 2012
Keeping putty idle sessions active.
Another frustrating problem is induced by the time-to-live of inactive or idle TCP sessions on firewall or switch configurations. At some companies this is put aggressively low so that TCP sessions that have no activity for 1 minute or even 30 seconds are being dropped. If you are using an SSH connection over such a network device, you have to take care to send keep-alive packets over your idle session. To do this go to Category: Connection and set Seconds between keepalives (0 to turn off) to 25.You Are DONE!!...
Friday, September 21, 2012
Guide to install Web-MeetMe. by Sunny Khetarpal
1. Download and extract Web-MeetMe gui in the root direcotry of your
Web Server (usually /var/www/). The actual version of the package is
1.3.3. Run :
wget http://www.fitawi.com/Asterisk/Web-MeetMe_v1.3.3.tgz
As root run:
cd /var/www/
mv Web-MeetMe_v1.3.3.tgz /var/www/
tar -xzf Web-MeetMe_v1.3.3.tgz
mv Web-MeetMe web-meetme (it's not necessary, if you do this you'll
have to edit the index.html file in the same folder in order to match
the address)
2. Edit the file Web-MeetMe/lib/defines.php in order to match the
configuration of your system (...
Wednesday, September 12, 2012
How to delete all the files from the directory in PHP
<?PHP
emptyDir("/home/DIR_NAME/public_html");
FUNCTION emptyDir($path) {
// init the debug string
$debugStr = '';
$debugStr .= "DeletingContents Of: $path<br /><br />";
// parse the folder
IF ($handle = OPENDIR($path)) {
WHILE (FALSE !== ($file = READDIR($handle))) {
IF ($file != "." && $file != "..") {
// If it's a file, delete it
IF(IS_FILE($path."/".$file)) {
IF(UNLINK($path."/".$file)) {
$debugStr...
Monday, August 13, 2012
Generate XML from MySQL database via PHP
<?phpmysql_connect('localhost', 'root', 'admin');mysql_select_db('xml');$sql = "SELECT udid, country,code FROM country ORDER BY udid";$res = mysql_query($sql); $xml = new XMLWriter();$xml->openURI("php://output");$xml->startDocument();$xml->setIndent(true);$xml->startElement('countries');while ($row = mysql_fetch_assoc($res)) { $xml->startElement("udid"); $xml->writeRaw($row['udid']); $xml->endElement(); $xml->startElement("country"); $xml->writeAttribute('udid',...
Thursday, June 21, 2012
Sending Email From the dialplan
exten => s,1,NoOp()
exten => s,n,System(echo "To: simplesunny@gmail.com" > /opt/etc/init.d/calls)
exten => s,n,System(echo "Subject: [PBX]: Service Down" >> /opt/etc/init.d/calls)
exten => s,n,System(echo "" >> /opt/etc/init.d/calls)
exten => s,n,System(echo "service down at ${STRFTIME(%C%m%d%y%H%M)}" >> /opt/etc/init.d/calls)
exten => s,n,System(sendmail -t -f noc@gmail.com < /opt/etc/init.d/calls)
exten => s,n,Hangup
sub mailSend {
my ($subj, $body) = @_;
my(@da, @day, @mon, $datetime, $expTO, $mail,...
Friday, June 1, 2012
Backup Your MySQL Database Using PHP
One of the most important tasks any developer needs to do often is back up their MySQL database. In many cases, the database is what drives most of the site. While most web hosts do a daily backup of a customer's database, relying on them to make backups and provide them at no cost is risky to say the least. That's why I've created a database backup function that I can call whenever I want -- including nightly CRONs.
The PHP & MySQL Codebackup_tables('localhost','username','password','databasename'); /* backup the db OR just...
Subscribe to:
Posts (Atom)
