The Guru Of Tech - Gobind

Asterisk Insall, Codec Install, Vicidial Install.

Wednesday, November 30, 2011

Install And Maintain Kamailio (OpenSER) v3.0.x From GIT on CentOS 5.x

Install And Maintain Kamailio (OpenSER) v3.0.x From GIT on CentOS 5.x Main author:    Elena-Ramona Modroiu <ramona (at) asipto.com> This is a step by step tutorial about how to install and maintain Kamailio (OpenSER) using the sources from GIT on CentOS 5.x. Using the GIT, you get access to the latest code very quickly. This document focuses on Kamailio (OpenSER) v3.0.x with MySQL support, using CentOS 5.5 system - should works more or less in the same way with CentOS 5.3 or 5.4. Kamailio 3.0.0 was released on January...

SIREMIS: Open Source Web Management Interface for SIP Routing Engines:

  SIREMIS: Open Source Web Management Interface for SIP Routing Engines: Kamailio (OpenSER) SIP-Router.org Download Latest version of SIREMIS 2.x is available at: http://siremis.asipto.com/pub/downloads/siremis/ it includes everything, so you do not need to download something extra Untar the archive on the local file system (e.g., in your web server root folder): cd /var/www tar xvfz siremis-x.y.z.tgz Web Server Setup If you want to setup an alias for Apache 2.x, you can run 'make apache-conf' and you get...

Tuesday, November 29, 2011

Set New Password for MYSQL

SET PASSWORD FOR root@localhost=PASSWORD('YOUR-PASSWORD'); QUIT; ...

Thursday, November 17, 2011

Make Custom Ring in Asterisk

Locate chan_dahdi.conf Searh for : You can define your own custom ring cadences here. You can define up to 8 ; pairs. If the silence is negative, it indicates where the caller ID spill is ; to be placed. Also, if you define any custom cadences, the default cadences ; will be turned off. ; ; This setting is global, rather than per-channel. It will not update on ; a reload. ; ; Syntax is: cadence=ring,silence[,ring,silence[...]] ; These are the default cadences: ;cadence=silence cadence=125,125,2000,-4000 cadence=250,250,500,1000,250,250,500,-4000...

Taking MySQL Backup [with mysqldump utility]

mysqldump -u cron -p -h IP astguiclient > FullBackup.sql [-h :- for host. This is optional if you are creating backup of localhost] To Restore from the created dump(*.sql) file:- mysql -u cron -p astguiclient < FullBackup.sql ...

Tuesday, November 15, 2011

Showing running queries in MySQL

The syntax is simply:show processlist; The "info" column shows the query being executedm or NULL if there's nothing currently happening. When running "show processlist" it will only show the first 100 characters of the query. To show the full query run "show full processlist" instead. Running the above command from the MySQL command line interface with a ; delimiter can make it difficult to read the output, especially if the queries are long and span multiple lines. Using the \G delimiter instead will show the data in what is often a more readable...

Monday, November 14, 2011

Google's latest Easter egg

STEPS:   First-> Go to Google Second-> Type “Do a Barrel Roll” Third-> Wait & Watch ..   Google's "Do a Barrel Roll" OR “Z or R twice” search trick went viral on Thursday after bored users tweeted about the cool trick to their friends. The barrel roll trick isn't the only Easter egg Google's hidden in its site.   Here are seven other Google tricks.   Be warned that they only work if your turn off the "instant search" feature.   Gravity. Type in "Google gravity" in the search bar, hit the "I'm...

Sunday, November 13, 2011

How to find the RSS feed for any Twitter user

Last month, without warning, Facebook and Twitter killed-off access to RSS feeds. With the launch of the new Twitter interface, you could only access RSS feeds on Twitter if you were logged out of your account. Now, it seems you can't access them at all. Whether intentional or not, this is not a surprising move on Twitter's part. It has been hard at work ensuring that any interaction with its services adheres to a particular vision. Twitter has been cracking down on third-party apps, or simply buying them out, all in an effort to streamline the...

Sunday, November 6, 2011

How to Hide, Disable or Remove Blogger Blogspot NavBar?

Please note that according to the term and condition of blogger.com, you're not allowed to remove or disable the navbar from your blogspot template unless you host your blog under your own server. This tutorial is meant for those that host their blog outside of blogger.com, but the code does work for blogs hosted with blogger.com. Backup your blogspot post.Step 01This tutorial is on how to hide,disable or remove the blogger navbar (also known as the navigation bar) from your blog. First go to 'Layout' –> 'Edit...

Saturday, November 5, 2011

Asterisk AGI php example source code

Example for Asterisk IVR     ;*****************************START context1***********************************   [context1] ;exten => 1234,1,Answer() exten => 1234,1,Playback(/var/lib/asterisk/sounds/custom/folder-name/filename) exten => 1234,n,Set(i=1) exten => 1234,n,Set(x=1) exten => 1234,n,Set(y=1) exten => 1234,n,Set(z=1) exten => 1234,n,GoTo(context2,1234,1)     ;*****************************END context1***********************************     ;****************START...

Friday, November 4, 2011

Active calls on an Asterisk

Command: watch -n 1 "sudo asterisk -vvvvvrx 'core show channels' | grep call" Watch active calls on an Asterisk PBX Show active calls as the happen on an Asterisk server. Note that the Asterisk command (in single quotes) is formatted for Asterisk 1.6. Use the -n flag on the watch command to modify the refresh period (in seconds - default is 2 seconds). ...

Grant Permission to the particular USER on particular TABLES

Mysql> use mysql; create user 'username'@'%' identified by 'any_password'; grant select on reports to 'username'@'%' identified by 'any_password'; grant all on school to 'username'@'%' identified by 'any_password'; flush privileges; ...

Resetting MySQL root Password [In case You forgot password]

[root ~]# mysqld_safe --skip-grant-tables Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 110416 12:11:00 mysqld ended [root ~]# mysql mysql>update user set Password=PASSWORD('new-password') where user='root'; mysql>flush privileges; mysql>exit; ...

Error too many connection in mysql

Default connection for mysql for client is maximum 100. When connection exceed from 100, it will not accept another connection. In this case mysql throw error of too many connections. And to increase the limit of connections. You need to do setting for attribute max_connections  increase the connection limit. Linux: /etc/my.cnf max_connections=250 or whatever you want the limit   ...

ViciDial Basic Queries

1)      Calls Recording location and how agents can extract recordings.   Calls recordins are stored at /var/spool/asterisk/monitorDONE/,     2)      Procedure of uploading leads and format.   You can uploaded leads from admin panel -> Lists -> Load New Leads You have to select list id which you want to use for leads and also set country code in Phone Code Override, So it will load that country code for all leads,   3)      Agent...

How To install ViciDial/astGUIclient 2.2.1 With Asterisk 1.4.21.2 On CentOS

You must login as root to install the following software. Make sure you update the system first, then reboot if you installed an updated kernel. #yum -y update #reboot * Install the following software * #yum install gcc gcc-c++ php php-devel php-gd gd-devel php-mbstring php-mcrypt php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc curl curl-devel perl-libwww-perl ImageMagick libxml2 libxml2-devel httpd libpcap libpcap-devel ncurses ncurses-devel screen sox mysql-server mysql-devel ntp kernel-devel mutt * Setup MySQL * ...