Expert Solutions

Reset MySql Root Password

2011-08-10T00:05:00.000+05:00

first stop mysql service and start mysql in safe mode using the following command

service mysqld stop
mysqld_safe --skip-grant-tables &

now connetc to mysql using the following command
mysql enter(return character)

mysql> use mysql
mysql> update user set Password=PASSWORD('passw0rd') where user='root';
mysql> flush privileges;
mysql> exit;

now password has be reset. kill mysqld_safe deamon and start mysql service using the following command

service mysqld start
now you can enter to mysql console using the new password

RAM DISK --- 2nd Porcedure

2011-05-25T11:44:00.000+05:00

you can create RAM disk or temporary file system using the following command

mount -t tmpfs -o size=32M tmpfs /var/lib/asterisk/

the above command will mount /var/lib/asterisk/ directory in the RAM and its size will be 32Mb.

you normally use RAM disk for the applications that require intensive io operation. using ram disk will increase hardisk life and also increase performance of application by reducing access time.

MySQL PHP Exampler

2011-01-30T21:15:00.000+05:00


   mysql_connect("localhost", "username", "password") or die(mysql_error());
   mysql_select_db("test") or die(mysql_error());
 
   echo " Step 1. Insert data
";
   $sql = "INSERT INTO users (name,city,web,age) VALUES ('Tom','Vegas','www.tom.com',5)";
   $result = mysql_query($sql);
 
   if ($result){
      echo "Data was inserted! ";   
   } else {
      echo "An error occured during insert! ";   
   }
 
   $result = mysql_query("SELECT * FROM users");   
 
   while($row = mysql_fetch_assoc($result)){
      echo "ID: ".$row['id'].", Name:".$row['name']
          .", City:".$row['city'].", Age:".$row['age']." ";
   }
 
   echo " Step 2. Update data
";
   $sql = "UPDATE users SET age=45 WHERE name='Tom'";
   $result = mysql_query($sql);
 
   if ($result){
      echo "Data was updated! ";   
   } else {
      echo "An error occured during update! ";   
   }
 
   $result = mysql_query("SELECT * FROM users");   
 
   while($row = mysql_fetch_assoc($result)){
      echo "ID: ".$row['id'].", Name:".$row['name']
          .", City:".$row['city'].", Age:".$row['age']." ";
   }
 
   echo " Step 3. Remove data
";
   $sql = "DELETE FROM users WHERE name='Tom'";
   $result = mysql_query($sql);
 
   if ($result){
      echo "Data was removed! ";   
   } else {
      echo "An error occured during remove! ";   
   }
 
   $result = mysql_query("SELECT * FROM users");   
 
   while($row = mysql_fetch_assoc($result)){
      echo "ID: ".$row['id'].", Name:".$row['name']
          .", City:".$row['city'].", Age:".$row['age']." ";
   }
 
?>

Asterisk Voice Prompts

2011-01-29T01:54:00.000+05:00

you can download asterisk voice prompts in different language using the following link.

http://downloads.asterisk.org/pub/telephony/sounds/

MsSQL dump to remote server

2011-01-26T16:50:00.001+05:00

was running out of disk space on a server today. The server had a large database table that was no longer used, so I wanted to archive it and then drop the table. But the server didn’t have enough disk space to dump it out to disk before copying it off to a remote server for archiving.
The first thought was to run mysqldump dump on the destination machine, and to access the database over the network. That however, doesn’t compress or encrypt the data. Plus I would have had to create a mysql user with permission to access the database remotely.
The solution I came up with worked out well: mysqldump directly to the remote host with this command:



mysqldump  [mysqldump options] | gzip -c | ssh user@remotehost "cat > /path/to/some-file.sql.gz"

That pipes the mysqldump command through gzip, then to through and SSH connection. SSH on the remote side runs the ‘cat’ command to read the stdin, then redirects that to the actual file where I want it saved.

Audio Format Converter For Asterisk

2011-01-26T15:47:00.000+05:00

you can convert audio format for asterisk ivr from the following links.

http://www.digium.com/en/products/ivr/audio-converter.php

other option is to use imagic audio editor or sox

bash script for Qmail&Vpopmail Uers Quota Refresh - Version 2

2010-10-18T10:24:00.000+05:00

#!/bin/sh

#Author: Tanveer Hussain Khan(tanveerhk@hotmail.com)

#Function:Referesh User Quota for all user and domain for qmmail and vpopmail #output=$(/usr/local/bin/mysql --password=rootpassword --exec="select pw_name,pw_domain,pw_shell from vpopmaildb.vpopmail")

/bin/date

echo "Going Referesh Quota For All Users & Domains"

output=$(/usr/bin/mysql --exec="select pw_name,pw_domain,pw_shell from vpopmaildb.vpopmail")

array=$(echo $output | tr " " "\n")

record=""

x=0

for a in $array

record[x]=$a

let "x+=1"

done

let "count=$x-1"

for ((i=3;i<=$count;i+=3))

let "name=$i"

let "domain=$i+1"

let "quota=$i+2"

# echo "Setting Quota To ${record[$quota]} For User ${record[$name]}@${record[$domain]}"

# echo ${record[$name]}@${record[$domain]} ${record[$quota]}

# echo "/var/qmail/vpopmail/bin/vsetuserquota ${record[$name]}@${record[$domain]} ${record[$quota]}"

/var/qmail/vpopmail/bin/vsetuserquota ${record[$name]}@${record[$domain]} ${record[$quota]} done

/bin/date

echo "Quota Refereshed For All Users & Domains"

echo "***********************************************************"

bash script for Qmail&Vpopmail Uers Quota Refresh

2010-10-02T14:09:00.000+05:00

#!/bin/sh
#Author: Tanveer Hussain Khan
#Function:Referesh User Quota for all user and domain for qmmail and vpopmail
#output=$(/usr/local/bin/mysql --password=rootpassword --exec="select pw_name,pw_domain,pw_shell from vpopmaildb.vpopmail")
output=$(/usr/bin/mysql --exec="select pw_name,pw_domain,pw_shell from vpopmaildb.vpopmail")

array=$(echo $output | tr " " "\n")
record=""
x=0
for a in $array
do
        record[x]=$a
        let "x+=1"
done

let "count=$x-1"
echo $count
for ((i=3;i<=$count;i+=3))
do
        let "name=$i"
        let "domain=$i+1"
        let "quota=$i+2"
        echo "Setting Quota To ${record[$quota]} For User ${record[$name]}@${record[$domain]}"
#       echo ${record[$name]}@${record[$domain]} ${record[$quota]}
#       echo "/var/qmail/vpopmail/bin/vsetuserquota ${record[$name]}@${record[$domain]} ${record[$quota]}
        /var/qmail/vpopmail/bin/vsetuserquota ${record[$name]}@${record[$domain]} ${record[$quota]}
done

Install Xwindow, KDE, GNOME, VNC using Yum

2010-06-08T13:14:00.000+05:00

you can use yum groupinstall command to install these package at once. but for that you need a good internet connection. here is the complete command.

yum -y groupinstall "X Window System" "GNOME Desktop Environment" "KDE Desktop Environment"

if you have internet connection then it a magic :-) command and will install all dependencies at one and you dont need much struggle to run the Graphical Desktop Environment(KDE/GNOME).

TrixBox Web Authentication

2010-05-31T01:47:00.000+05:00

/etc/trixbox/httpdconf/trixbox.conf is the trixbox webauthentication file. its sample is given below you can modify it according to your requirement. it use htaccess method to restrict the contents.

cat /etc/trixbox/httpdconf/trixbox.conf
#Password protect /var/www/html/admin

AuthType Basic
AuthName "Restricted Area"
AuthUserFile /usr/local/apache/passwd/wwwpasswd
Require user wwwadmin maint
#Password protect /var/www/html/maint

AuthType Basic
AuthName "Restricted Area"
AuthUserFile /usr/local/apache/passwd/wwwpasswd
Require user maint

AllowOverride All

RAM Disk Creation & Mount

2010-05-26T19:04:00.000+05:00

What Is RAM Disk? RAM disk is the portion for ram which acts as the hard disk. For that we allocate some portion for ram and then mount it. below are the configurations tested on CentOS 5.2

You can configure and mount RAM Disk using the following procedure.

1. In /etc/grub.conf add the option that is highlited in the below kernel line.

title CentOS (2.6.18-164.el5PAE)
        root (hd0,0)
        kernel /vmlinuz-2.6.18-164.el5PAE ro root=LABEL=/ rhgb quiet ramdisk_size=524288
        initrd /initrd-2.6.18-164.el5PAE.img

2. now edit the /etc/rc.d/rc.local and put the below line
####### RAM DISK #######################
mkfs -t ext3 /dev/ram0 # it will formate the ramdisk
mount -t ext3 /dev/ram0 /var/spool/asterisk/monitor # it will mount ramdisk to mount point /var/spool/asterisk/monitor

Asterisk Perl AGI

2010-05-19T01:27:00.000+05:00

Below is the sample AGI scrip written in per perl.
In This Script You will learn the following
1. How to write AGI concept.
2. Some Perl Programming.(Variables, Arithmetic Operator, IF/ELSE/ELSIF , comparision operators, Labels etc.
3. How to use mysql queries in AGI using perl.
4. Asterisk Application Used( NoOp, SayDigits, SayNumber, Channel Variables, SayUnixTimeStamp etc)

#!/usr/bin/perl
# MODULE
use Time::Local;
use Asterisk::AGI;
use Mysql;

# CONFIG VARIABLES
$host = "localhost";
$database = "testdb";
$user = "root";
$pw = "JustForFun";

# MYSQL CONNECT
$connect = Mysql->connect($host, $database, $user, $pw);

# SELECT A DATABASE
$connect->selectdb($database);

# create agi instance
$AGI = new Asterisk::AGI;

$AGI->exec("NoOP","\----OnlineInquirySystem----\"");
$AGI->exec("Playback","custom/inquiry-thankyou");
Repeapt1:
$AGI->exec("Read","\option,custom/inquiry-tocheck,1,,,\"");
$option = $AGI->get_variable(option);

if ($option == 1 or $option == 2)
{
   EnterCheque:
   $AGI->exec("Read","cheque,custom/inquiry-pleaseenter,15,,,");
   $cheque = $AGI->get_variable(cheque);
   AfterCheque:
   $AGI->exec("NoOP","**$cheque**");
   if (length($cheque) == 10)
   {
   $AGI->exec("Playback","custom/inquiry-waitforinformation");
   $query="Select evttype_fk, issue_dtt,amount,inst_pk from lpsinst where check_no='$cheque'";
   $execute= $connect->query($query);
   @results=$execute->fetchrow();
   $AGI->exec("NoOP","=====================================");
   $AGI->exec("NoOP","**$results[0]**");
   $AGI->exec("NoOP","=====================================");
   if ($results[0] > 0)
   {
   $AGI->exec("NoOP","**CheckFound**");
   $evttype=$results[0];
   $issuedtt=$results[1];
   $amount=$results[2];
   $inst_pk=$results[3];
   $issueyear=substr $issuedtt,0,4;
   $issuemonth=substr $issuedtt,5,2;
   $issueday=substr $issuedtt,8,2;
   $issuehour=substr $issuedtt,11,2;
   $issueminute=substr $issuedtt,14,2;
   $issuesecond=substr $issuedtt,17,2;
   $AGI->exec("NoOP","$issuedtt");
   $AGI->exec("NoOP","$issueyear-$issuemonth-$issueday-$issuehour:$issueminute:$issuesecond");
   $issueutc=timelocal($issuesecond,$issueminute,$issuehour,$issueday,$issuemonth,$issueyear);
   $AGI->exec("NoOP","$issueutc");
   $bfd=length($amount) - 3;
        $afd= $bfd + 1;
        $dollars=substr $amount,0,$bfd;
        $cents=substr $amount,$afd,2;
   $AGI->exec("NoOP","D-$dollars");
   $AGI->exec("NoOP","C-$cents");

       if ($evttype == 3)
       {
       $AGI->exec("Playback","custom/inquiry-chequenumber");
       $AGI->exec("SayDigits","$cheque");
       $AGI->exec("Playback","custom/inquiry-wasissuedon");
       $AGI->exec("SayUnixTime","$issueutc,CET,BdY");
       $AGI->exec("Playback","custom/inquiry-amountof");
       $AGI->exec("SayNumber","$dollars");
       $AGI->exec("Playback","dollars");
       $AGI->exec("SayNumber","$cents");
       $AGI->exec("Playback","cents");
       $AGI->exec("PlayBack","custom/inquiry-nofurtherinfo");
       SecondOption:
                $AGI->exec("Read","\option,custom/inquiry-tocheck-2,1,,,\"");
                $option = $AGI->get_variable(option);
           if ($option == 1 or $option == 2)
               {
               goto Repeapt1;
               } elsif ($option == 3)
                   {
                   goto TalkToSupport;
                   } elsif($option == 4)
                       {
                       goto SecondOption;
                       } elsif($option == 5)
                                                   {
                           EndCall:
                           $AGI->exec("Playback","custom/inquiry-thankforcalling");
                                                   goto END;
                                                   } else
                               {
                               $AGI->exec("Playback","custom/inquiry-invalidoption");
                               goto SecondOption;
                               }


       } elsif ($evttype == 4)
       {
       $query="select evt_dtt from lpshistory where inst_fk='$inst_pk' and evttype_fk=4";
            $execute= $connect->query($query);
           @results=$execute->fetchrow();
            $evtdtt=$results[0];
       $evtyear=substr $evtdtt,0,4;
            $evtmonth=substr $evtdtt,5,2;
            $evtday=substr $evtdtt,8,2;
            $evthour=substr $evtdtt,11,2;
           $evtminute=substr $evtdtt,14,2;
            $evtsecond=substr $evtdtt,17,2;
            $AGI->exec("NoOP","$issuedtt");
            $AGI->exec("NoOP","$evtsecond-$evtminute-$evthour-$evtday-$evtmonth-$evtyear");
            $evtutc=timelocal($evtsecond,$evtminute,$evthour,$evtday,$evtmonth,$evtyear);
       $AGI->exec("Playback","custom/inquiry-chequenumber");
                $AGI->exec("SayDigits","$cheque");
                $AGI->exec("Playback","custom/inquiry-wasissuedon");
                $AGI->exec("SayUnixTime","$issueutc,CET,BdY");
                $AGI->exec("Playback","custom/inquiry-amountof");
                $AGI->exec("SayNumber","$dollars");
                $AGI->exec("Playback","dollars");
                $AGI->exec("SayNumber","$cents");
                $AGI->exec("Playback","cents");
       $AGI->exec("Playback","custom/inquiry-wasvoidedon");
       $AGI->exec("SayUnixTime","$evtutc,CET,BdY");
       goto SecondOption;
       } elsif ($evttype == 5)
                {
                $query="select evt_dtt from lpshistory where inst_fk='$inst_pk' and evttype_fk=5";
                $execute= $connect->query($query);
                @results=$execute->fetchrow();
                $evtdtt=$results[0];
                $evtyear=substr $evtdtt,0,4;
                $evtmonth=substr $evtdtt,5,2;
                $evtday=substr $evtdtt,8,2;
                $evthour=substr $evtdtt,11,2;
                $evtminute=substr $evtdtt,14,2;
                $evtsecond=substr $evtdtt,17,2;
                $AGI->exec("NoOP","$issuedtt");
                $AGI->exec("NoOP","$evtsecond-$evtminute-$evthour-$evtday-$evtmonth-$evtyear");
                $evtutc=timelocal($evtsecond,$evtminute,$evthour,$evtday,$evtmonth,$evtyear);
                $AGI->exec("Playback","custom/inquiry-chequenumber");
                $AGI->exec("SayDigits","$cheque");
                $AGI->exec("Playback","custom/inquiry-wasissuedon");
                $AGI->exec("SayUnixTime","$issueutc,CET,BdY");
                $AGI->exec("Playback","custom/inquiry-amountof");
                $AGI->exec("SayNumber","$dollars");
                $AGI->exec("Playback","dollars");
                $AGI->exec("SayNumber","$cents");
                $AGI->exec("Playback","cents");
                $AGI->exec("Playback","custom/inquiry-wasredeemedon");
                $AGI->exec("SayUnixTime","$evtutc,CET,BdY");
       goto SecondOption;
                } elsif ($evttype == 6)
       {
       $query="select evt_dtt from lpshistory where inst_fk='$inst_pk' and evttype_fk=6";
                $execute= $connect->query($query);
                @results=$execute->fetchrow();
                $evtdtt=$results[0];
                $evtyear=substr $evtdtt,0,4;
                $evtmonth=substr $evtdtt,5,2;
                $evtday=substr $evtdtt,8,2;
                $evthour=substr $evtdtt,11,2;
                $evtminute=substr $evtdtt,14,2;
                $evtsecond=substr $evtdtt,17,2;
                $AGI->exec("NoOP","$issuedtt");
                $AGI->exec("NoOP","$evtsecond-$evtminute-$evthour-$evtday-$evtmonth-$evtyear");
                $evtutc=timelocal($evtsecond,$evtminute,$evthour,$evtday,$evtmonth,$evtyear);
                $AGI->exec("Playback","custom/inquiry-chequenumber");
                $AGI->exec("SayDigits","$cheque");
                $AGI->exec("Playback","custom/inquiry-wasissuedon");
                $AGI->exec("SayUnixTime","$issueutc,CET,BdY");
                $AGI->exec("Playback","custom/inquiry-amountof");
                $AGI->exec("SayNumber","$dollars");
                $AGI->exec("Playback","dollars");
                $AGI->exec("SayNumber","$cents");
                $AGI->exec("Playback","cents");
                $AGI->exec("Playback","custom/inquiry-wasstopedon");
                $AGI->exec("SayUnixTime","$evtutc,CET,BdY");
       goto SecondOption;
                } elsif ($evttype == 7)
                {
       $query="select evt_dtt from lpshistory where inst_fk='$inst_pk' and evttype_fk=7";
                $execute= $connect->query($query);
                @results=$execute->fetchrow();
                $evtdtt=$results[0];
                $evtyear=substr $evtdtt,0,4;
                $evtmonth=substr $evtdtt,5,2;
                $evtday=substr $evtdtt,8,2;
                $evthour=substr $evtdtt,11,2;
                $evtminute=substr $evtdtt,14,2;
                $evtsecond=substr $evtdtt,17,2;
                $AGI->exec("NoOP","$issuedtt");
                $AGI->exec("NoOP","$evtsecond-$evtminute-$evthour-$evtday-$evtmonth-$evtyear");
                $evtutc=timelocal($evtsecond,$evtminute,$evthour,$evtday,$evtmonth,$evtyear);
                $AGI->exec("Playback","custom/inquiry-chequenumber");
                $AGI->exec("SayDigits","$cheque");
                $AGI->exec("Playback","custom/inquiry-wasissuedon");
                $AGI->exec("SayUnixTime","$issueutc,CET,BdY");
                $AGI->exec("Playback","custom/inquiry-amountof");
                $AGI->exec("SayNumber","$dollars");
                $AGI->exec("Playback","dollars");
                $AGI->exec("SayNumber","$cents");
                $AGI->exec("Playback","cents");
                $AGI->exec("Playback","custom/inquiry-wasstopedandvoidedon");
                $AGI->exec("SayUnixTime","$evtutc,CET,BdY");
       goto SecondOption;
                } elsif ($evttype == 11 or $evttype == 12)
                {
       $query="select evt_dtt from lpshistory where inst_fk='$inst_pk' and evttype_fk=11 or evttype_fk=12";
                $execute= $connect->query($query);
                @results=$execute->fetchrow();
                $evtdtt=$results[0];
                $evtyear=substr $evtdtt,0,4;
                $evtmonth=substr $evtdtt,5,2;
                $evtday=substr $evtdtt,8,2;
                $evthour=substr $evtdtt,11,2;
                $evtminute=substr $evtdtt,14,2;
                $evtsecond=substr $evtdtt,17,2;
                $AGI->exec("NoOP","$issuedtt");
                $AGI->exec("NoOP","$evtsecond-$evtminute-$evthour-$evtday-$evtmonth-$evtyear");
                $evtutc=timelocal($evtsecond,$evtminute,$evthour,$evtday,$evtmonth,$evtyear);
                $AGI->exec("Playback","custom/inquiry-chequenumber");
                $AGI->exec("SayDigits","$cheque");
                $AGI->exec("Playback","custom/inquiry-wasissuedon");
                $AGI->exec("SayUnixTime","$issueutc,CET,BdY");
                $AGI->exec("Playback","custom/inquiry-amountof");
                $AGI->exec("SayNumber","$dollars");
                $AGI->exec("Playback","dollars");
                $AGI->exec("SayNumber","$cents");
                $AGI->exec("Playback","cents");
                $AGI->exec("Playback","custom/inquiry-wasescheatedon");
                $AGI->exec("SayUnixTime","$evtutc,CET,BdY");
       goto SecondOption;
                } else
       {
       $AGI->exec("Playback","custom/inquiry-chequenumber");
       $AGI->exec("SayDigits","$cheque");
       $AGI->exec("NoOP","**$cheque**");
       NoValidStatus:
       $AGI->exec("Read","\option,custom/inquiry-wasnotfoundtry,1,,,\"");
       $option = $AGI->get_variable(option);
       if ($option == 1)
           {
           goto EnterCheque;
           } elsif ($option == 2)
           {
           goto TalkToSupport;
           } elsif ($option == 3)
                        {
                        goto EndCall;
                        } else
           {
           $AGI->exec("Playback","custom/inquiry-invalidoption");
           goto NoValidStatus;
           }

       }

   } else
           {
       $AGI->exec("NoOP","**====CheckNotFound====**");
       $AGI->exec("Playback","custom/inquiry-chequenumber");
            $AGI->exec("SayDigits","$cheque");
            $AGI->exec("NoOP","**$cheque**");
            RepeatNotFound:
            $AGI->exec("Read","option,custom/inquiry-wasnotfoundtry,1,,,");
            $option = $AGI->get_variable(option);
            if ($option == 1)
           {
                goto EnterCheque;
                } elsif ($option == 2)
                   {
                        goto TalkToSupport;
                        } elsif ($option == 3)
                           {
                            goto EndCall;
                            } else
                                {
                            $AGI->exec("Playback","custom/inquiry-invalidoption");
                            goto RepeatNotFound;
                                }


        }

   } else
   {
   $AGI->exec("Read","cheque,custom/inquiry-rentercheque,15,,,");
   $cheque = $AGI->get_variable(cheque);
   goto AfterCheque;
   }

} elsif ($option == 3)
   {
   TalkToSupport:
   $AGI->exec("Playback","custom/inquiry-pleasehold");
   goto END;
   } elsif ($option == 4)
       {
       goto Repeapt1;
       } else
           {
           $AGI->exec("Playback","custom/inquiry-invalidoption");
           goto Repeapt1;
           }

END:

Alcatel 1000MM E10 Operations & Maintenance

2010-02-25T13:36:00.000+05:00

We will discuss Alcatel Daily Operation & Maintenence Here.
Comming Soon.........................................................................

Emails and Their Replies

2010-02-25T13:30:00.000+05:00

shaukat ali has sent you a message.

Date: 2/24/2010

Subject: RE: Solutions/Help/HowTos On Asterisk/Billing/Telecom/IT/System Related Issues

Daer Tanveer:
This is the issue.The provider in Pakistan do not allow this.Thank you any way.
shaukat
-------------------------------------------------------------------
On 02/24/10 12:45 PM, Tanveer Hussain Khan wrote:
--------------------
Dear Shaukat Ali,

thanks for writing me.you can change cli in asterisk by changing the CALLERID variable but for this you should have the privileges from you pri provider. most provide does not allow that. if you change/off cli, they will send your PRI master number to the called party.
---------------------------------------------------------------------
On 02/24/10 12:03 AM, shaukat ali wrote:
--------------------
how to control/change/off cli on ISDN PRI card from Asterisk while it is on in central office

Alcatel 1000 MM E10

2010-02-20T13:32:00.000+05:00

Alcatel 1000 MM E10 is a Next Generation Telecom Switch. The Alcatel 1000 MM E10 with MGC has been specifically designed to address the migration strategy of established service providers (ESPs) currently running Alcatel 1000 E10-based networks. With the MGC operators can handle simultaneously TDM and next generation network (NGN) traffic.

Technical specifications:Multi-service
- One equipment able to perform all functions
- Fixed or mobile, local or transit
Modular and scalable
- Applicable to both capacity and functions
Compatibility
- Hardware and software evolving independently
Quality of service
- Same level of service for voice over circuit (PSTN) or voice over packet
Service guarantee
- Preserving the revenue generated by carrier grade services like IN
Service enhancement
- Packet capacity enabling future services
Billing
- Facilitated billing through the generation of CDRs for any type of communications - circuit or packet
Interoperability
- Guaranteeing interoperability between national and international data networks
High capacity
- Integrated high capacity terminations such as SDH STM1.

SS7 BOX Software Installation

2010-02-20T00:59:00.000+05:00

1. Install CentOS-5.4 Operating System on the system.
2. download source of asterisk,dahdi,libpri,asterisk-adons from www.asterisk.org
3. untar the sources one by one.
4. compile and install the sources one by one.

for compilation and installation go to each source directory and run the following command
1- ./configure
2- make
3- make install
4- follow on screen instructions.

in next chapter will will configure it as a IP PBX with single PRI card and then in next chapter will configure this is SS7 Box/ Signalling Gateway

SS7 BOX Hardware and Price

2010-02-18T09:53:00.000+05:00

1. Intel ATOM Dual Core .................6500
2. RAM 512 MB.................................1300
3. USB Stick(Kinston 8-GB).................850
4. Casing (Mini ATX).........................1880
-----------------------------------------------------------------------------
Total.................................................10530 PKR
------------------------------------------------------------------------------
Digiup TE100P Card........................45000
------------------------------------------------------------------------------
Grand Total......................................55530 PRK
------------------------------------------------------------------------------

Operating System.............................CentOS 5.4

What is SS7 BOX

2010-02-18T02:19:00.000+05:00

SS7 Box is a computer running Linux OS(CentOS-5.4) and Asterisk from 4GB usb, on intel ATOM process with TE100p Digium Single PRI Card. this is realy low cost ss7 box / Signalling Gateway. It will cost you about 60K PKR. i will discuss its complete hardware and software configuration and installation process in my later posts. This can also be use as IP PBX with a single pri card. guys it would be a great box with low cost and enriched featured. Comming Soon...............

A2Billing Installation

2009-11-25T13:09:00.000+05:00

Step 1)

mkdir /usr/local/src/a2billing

step 2)

cd /usr/local/src/a2billing

step 3)

yum -y install perl-DBD-Pg subversion

step 4)

svn co --username guest --password guest http://svn.a2billing.net/svn/asterisk2billing/trunk/ /usr/local/src/a2billing

step 5)

cp a2billing.conf /etc/a2billing.conf
ln /etc/a2billing.conf /etc/asterisk/a2billing.conf

step 6)

mysql -u root -p < DataBase/mysql-5.x/a2billing-createdb-user.sql
pass=passw0rd (ziro)
*Database name is: mya2billing
*Database user is: a2billinguser
*User password is: a2billing

step 7)

mysql -u root -p mya2billing < DataBase/mysql-5.x/a2billing-schema-v1.4.0.sql

step

mysql -u root -p mya2billing < DataBase/mysql-5.x/UPDATE-a2billing-v1.4.0-to-v1.4.1.sql
mysql -u root -p mya2billing < DataBase/mysql-5.x/UPDATE-a2billing-v1.4.1-to-v1.4.2.sql
mysql -u root -p mya2billing < DataBase/mysql-5.x/UPDATE-a2billing-v1.4.2-to-v1.4.3.sql

step 9)

vi /etc/a2billing.conf

[database]
hostname = localhost
; port for postgres is 5432 by default
port = 3306
user = a2billinguser
password = a2billing
dbname = mya2billing
; dbtype setting can either be mysql or postgres
dbtype = mysql

step 10)

chmod 775 /etc/asterisk

step 11)

touch /etc/asterisk/additional_a2billing_iax.conf

step 12)

touch /etc/asterisk/additional_a2billing_sip.conf

step 13)

echo \#include additional_a2billing_sip.conf >> /etc/asterisk/sip_custom.conf

step 14)

echo \#include additional_a2billing_iax.conf >> /etc/asterisk/iax_custom.conf

step 15)

chown -Rf asterisk:asterisk /etc/asterisk/additional_a2billing_iax.conf

step 16)

chown -Rf asterisk:asterisk /etc/asterisk/additional_a2billing_sip.conf

step 17)

ln -s /usr/local/src/a2billing/AGI/a2billing.php /var/lib/asterisk/agi-bin/a2billing.php

step 18)

chown asterisk:asterisk /var/lib/asterisk/agi-bin/a2billing.php

step 19)

chmod +x /var/lib/asterisk/agi-bin/a2billing.php

step 20)

cd /usr/local/src/a2billing/addons/sounds

step 21)

./install_a2b_sounds.sh

step 22)

chown -R asterisk:asterisk /var/lib/asterisk/

step 23)

vi /etc/asterisk/manager_custom.conf
[myasterisk]
secret = mycode
deny=0.0.0.0/0.0.0.0
permit=127.0.0.1/255.255.255.0
read = system,call,log,verbose,command,agent,user
write = system,call,log,verbose,command,agent,user

step 24)

mkdir /var/www/html/a2billing

step 25)

ln -s /usr/local/src/a2billing/common /var/www/html/a2billing/common

step 26)

ln -s /usr/local/src/a2billing/admin /var/www/html/a2billing/admin

step 27)

ln -s /usr/local/src/a2billing/agent /var/www/html/a2billing/agent

step 28)

ln -s /usr/local/src/a2billing/customer /var/www/html/a2billing/customer

step 29)

chown -R asterisk:asterisk /var/www/html/a2billing/

step 30)

chown -R asterisk:asterisk /usr/local/src/a2billing/common

step 31)

chown -R asterisk:asterisk /usr/local/src/a2billing/admin

step 32)

chown -R asterisk:asterisk /usr/local/src/a2billing/customer

step 33)

chown -R asterisk:asterisk /usr/local/src/a2billing/agent

step 34)

vi /etc/crontab
echo "
# Automatically added for A2Billing
0 * * * * php /usr/local/src/a2billing/Cronjobs/a2billing_alarm.php
0 12 * * * php /usr/local/src/a2billing/Cronjobs/a2billing_archive_data_cront.php
0 10 21 * * php /usr/local/src/a2billing/Cronjobs/a2billing_autorefill.php
#Batch process at 00:20 each day
20 0 * * * php /usr/local/src/a2billing/Cronjobs/a2billing_batch_process.php
#Bill DID usage at 00:00 each day
0 0 * * * php /usr/local/src/a2billing/Cronjobs/a2billing_bill_diduse.php
#Remind users of low balance every day at 06:00
0 6 * * * php /usr/local/src/a2billing/Cronjobs/a2billing_check_account.php
#Generate Invoices at 7am everyday
0 7 * * * php /usr/local/src/a2billing/Cronjobs/a2billing_invoice2_cront.php
0 7 * * * php /usr/local/src/a2billing/Cronjobs/a2billing_invoice_cront.php
#Check if balance below preset value, and email user if so.
1 * * * * php /usr/local/src/a2billing/Cronjobs/a2billing_notify_account.php
#Charge subscriptions at 06:05 on the 1st of each month
0 6 1 * * php /usr/local/src/a2billing/Cronjobs/a2billing_subscription_fee.php
#Update currencies at 01:00 each day
0 1 * * * php /usr/local/src/a2billing/Cronjobs/currencies_update_yahoo.php
" >> /var/spool/cron/asterisk

step 35)

touch /var/log/asterisk/a2billing-daemon-callback.log

step 36)

touch /var/log/a2billing/a2billing-daemon-callback.log

step 37)

touch /var/log/a2billing/cront_a2b_alarm.log

step 38)

touch /var/log/a2billing/cront_a2b_autorefill.log

step 39)

touch /var/log/a2billing/cront_a2b_batch_process.log

step 40)

touch /var/log/a2billing/cront_a2b_bill_diduse.log

step 41)

touch /var/log/a2billing/cront_a2b_subscription_fee.log

step 42)

touch /var/log/a2billing/cront_a2b_currency_update.log

step 43)

touch /var/log/a2billing/cront_a2b_invoice.log

step 44)

touch /var/log/a2billing/cront_a2b_check_account.log

step 45)

touch /var/log/a2billing/a2billing_paypal.log

step 46)

touch /var/log/a2billing/a2billing_epayment.log

step 47)

touch /var/log/a2billing/api_ecommerce_request.log

step 48)

touch /var/log/a2billing/api_callback_request.log

step 49)

touch /var/log/a2billing/a2billing_agi.log

step 50)

cp /usr/local/src/a2billing/addons/Doc/extensions_a2billing.conf /etc/asterisk/extensions_a2billing.conf

step 51)

echo \#include extensions_a2billing.conf >> /etc/asterisk/extensions_custom.conf

step 52) remove PHP info

vi /var/www/html/a2billing/common/lib/admin.defines.php

define ("PHP_QUICK_PROFILER", false);

vi /var/www/html/a2billing/common/lib/agent.defines.php

define ("PHP_QUICK_PROFILER", false);

vi /var/www/html/a2billing/common/lib/customer.defines.php

define ("PHP_QUICK_PROFILER", false);

step 52)

http:///a2billing/

user: root
pass: changepassword

What is A2Billing

2009-11-25T13:03:00.000+05:00

A2Billing combined with Asterisk now gives any Telecom company a very good reason to consider the A2Billing Soft-Switch over the traditional offerings for TDM and VoIP Soft-Switches as well as wholesale and IP PBX billing, particularly when you consider the cost of A2Billing – FREE! If you want to launch any of the following services, then A2Billing may be the system for you:

Traditional Calling Card services – A2Billing can be configured to provide standard calling card services via traditional “dial through”, with PIN or CID authentication.

Callback services, A2Billing supports a number of call-back methods including ANI, DID and web based call-backs.

VoIP residential services – Customers can be issued with a softphone or hard phone and be billed for calls made via Voice over IP.

VoIP wholesale termination - A2Billing and Asterisk can be used as a softswitch to terminate and bill large numbers of VoIP minutes from a number of sources such as resellers and distributors of your services.

VoIP termination for Asterisk and FreePBX systems. – With the growth of IP based PBX systems, as well as the asterisk based systems, A2Billing can be used to provide services and billing to IP PBX resellers and Asterisk system integrators.

DID termination and redirection. DID can be redirected to any SIP, IAX or PSTN destination with monthly charges and duration based charges.

Its is fair to say that A2Billing when combined with Asterisk is is now a full featured telecom platform and softswitch providing converged services, with self contained billing (pre or post-paid), reporting and statistics for IP and TDM based voice networks and can be configured to supply a wide range of services, rate calls, prepare and send out invoices, as well as accept payments via a number of payment service providers.
The A2Billing solution comprises of the following components: -

Server: The computer to run the system.
Line Interface Cards: The Digium hardware (optional)to connect to the TDM network (PRI, BRI, Analogue)
Linux: The base operating system
Asterisk: The telephony engine
Apache: The web server
MySQL/Postgresql: The back end database
A2Billing: The Billing engine handling Authentication, Authorisation and Accounting.

The platform can be fitted with a TDM cards to interconnect with the PSTN, and can support in excess of 120 concurrent calls given the right hardware. If more capacity is required, then more Asterisk servers can be added as necessary.
The A2Billing Platform has been deployed in a number of commercial environments by both traditional TDM based telecoms companies wishing to move into the VoIP market, and calling card and call-shop businesses. Additionally, there has been a lot of interest from IT and networking companies who are beginning to deploy VoIP PBXs in addition to their traditional business, and wish to enjoy an ongoing income by terminating their customer’s calls using A2Billing as their Wholesale Billing Platform.
A2Billing is licenced under the AGPL – this means that you have the freedom to modify the system to suit your own needs, within the rules of the AGPL.

official website for a2billing is www.a2billing.org.

Asterisk Installation

2009-11-25T12:56:00.000+05:00

download asterisk source from http://www.asterisk.org/downloads on you local system. as it is *.tar.gz file you have to decompress it using the following command
tar -zxf asterisk-1.XXX.tar.gz. >>> out put would be the directory with the name asterisk-1.XXX
go the that directory using the "cd asterisk-1.XXX" command and run the following commands.

make clean
make
make all
make install

and thats it.

for more details follow instruction given on below link.

http://www.voip-info.org/wiki/view/Asterisk+installation+for+CentOS+4.x

What is Asterisk?

2009-11-09T17:37:00.000+05:00

Asterisk is the world's most popular open source telephony project. Under development since 1999, Asterisk is free, open source software that turns an ordinary computer into a feature-rich voice communications server. Asterisk makes it simple to create and deploy a wide range of telephony applications and services. Code for Asterisk, originally written by Mark Spencer of Digium, Inc., has been contributed from open source software engineers around the world. Currently boasting over two million users, Asterisk supports a wide range of telephony protocols. It includes rich support for the handling and transmission of voice over traditional telephony interfaces including analog lines, ISDN-BRI lines and digital T1/E1 trunks. Asterisk also features support for a wide range of VoIP protocols including SIP, IAX and H.323 among others. It supports U.S. and European standard signaling types used in business phone systems, allowing it to bridge between next-generation voice-data integrated networks and existing infrastructure.
Asterisk is released as open source under the GNU General Public License (GPL), and it is available for download free of charge. Asterisk® is the leading open source telephony project and the Asterisk community has been ranked as a key factor in the growth of VoIP.

Free Books Sites

2009-11-08T03:24:00.000+05:00

here are some websites, where you can find free book of all categories i.e computer, information technology, OS ( Unix, Linux, Windows, Solaris, HP-UX, FreeBSD), Networks, Telecomunications etc.
http://www.getfreeebooks.com
http://www.freetechbooks.com/
http://freecomputerbooks.com/
http://www.freebookcentre.net/
http://www.techbooksforfree.com

i hope you will find the above links very usefull.