Your browser (Internet Explorer 6) is out of date. It has known security flaws and may not display all features of this and other websites. Learn how to update your browser.
X
Articles

Official VICIDIAL Partner for Asia and Pacific.

Yes sir. 

I am an official partner of VICIDIAL group for Asia and Pacific.

September 20, 2011 No Comments Short URL
Post

And then we need the how to create a grant all user for a mysql database.

Yep there was a time in our sleep deprived environment that we need to create a user for our ultra secured mysql server. He wants a GRANT ALL permission on a new database. So you’re googling the internet because you are lazy and found my site. I don’t want hearing the “You disappoint son” verbiage so here’s how.

So we will create a database called CRM. *note we will be using a vicidialNOW uhm goautodial VICIDIAL auto install.

[root@vici ~]# mysql -uroot -pvicidialnow

Now you’ll see this
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1474214
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>

Then you need to type this command
CREATE DATABASE `crm` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

You’ll see this output

mysql> CREATE DATABASE `crm` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
Query OK, 1 row affected (0.08 sec)

Congratulations! you just created a new mysql database!

Now let’s create a user with a GRANT ALL privileges to that new mysql database.

For a user with local access capability :

mysql> GRANT all on crm.* TO USERNAME@localhost IDENTIFIED BY 'iphone1234';
Query OK, 0 rows affected (0.02 sec)

with accessing the database outside the mysql server

mysql> GRANT all on crm.* TO USERNAME@'%' IDENTIFIED BY 'iphone1234';
Query OK, 0 rows affected (0.00 sec)

Nope you’re not done yet because no matter what you’ll do you can’t still use the log-in info you created. You need the flush the toilet errr sorry! flush the privileges rather.

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

Now you’re done. Hit the comment page if you need to ask some question about the said how to.

June 22, 2011 No Comments Short URL
Post

Upgrade from Asterisk 1.2 to Asterisk 1.4 easily

So you’ve been stucked with Asterisk 1.2 and probably you’ve used vicidialnow 1.3.

Here’s a painless way to upgrade from Asterisk 1.2 to Asterisk 1.4 for your VICIDIAL.

First let’s create a directory.
cd /usr/src
mkdir asterisk1-4

Let’s get the VICIDIAL patched Asterisk.
cd asterisk1-4
wget http://download.vicidial.com/required-apps/asterisk-1.4.39.1-vici.tar.gz

How about zaptel and libpri?
wget http://downloads.digium.com/pub/zaptel/zaptel-1.4.12.1.tar.gz
wget http://downloads.digium.com/pub/libpri/libpri-1.4.9.tar.gz

Get the optional but VICIDIAL friendly sound addons
wget http://downloads.digium.com/pub/telephony/sounds/asterisk-core-sounds-en-ulaw-current.tar.gz
wget http://downloads.digium.com/pub/telephony/sounds/asterisk-core-sounds-en-wav-current.tar.gz
wget http://downloads.digium.com/pub/telephony/sounds/asterisk-core-sounds-en-gsm-current.tar.gz
wget http://downloads.digium.com/pub/telephony/sounds/asterisk-extra-sounds-en-ulaw-current.tar.gz
wget http://downloads.digium.com/pub/telephony/sounds/asterisk-extra-sounds-en-wav-current.tar.gz
wget http://downloads.digium.com/pub/telephony/sounds/asterisk-extra-sounds-en-gsm-current.tar.gz
wget http://download.vicidial.com/required-apps/asterisk-moh-freeplay-gsm.tar.gz
wget http://download.vicidial.com/required-apps/asterisk-moh-freeplay-ulaw.tar.gz
wget http://download.vicidial.com/required-apps/asterisk-moh-freeplay-wav.tar.gz

Now we start extracting the tar files
tar xvf asterisk-*.tar
tar xvf libpri-*.tar
tar xvf zaptel-*.tar

Be aware that you need to stop your Asterisk process first. Once stopped remove the module ztdummy(if you’re using one) zttranscode and zaptel. Here’s how
rmmod ztdummy zttranscode zaptel

Because most of the time zaptel crashes if you upgrade from Asterisk 1.2 to Asterisk 1.4, we delete the old zaptel directory at /lib/modules/$(uname -r) .

Now let’s start compiling!

Let’s do the libpri first!
cd /usr/src/asterisk1-4
cd libpri-1.4.10.1
make clean
make
make install

Went well? Let’s do zaptel.
cd ../zaptel-1.4.12.1
./configure
make clean
make
make install

If you haven’t encounter any errors yet. Let’s compile Asterisk 1.4.
cd ../asterisk-1.4.39.1-vici
./configure
make clean
make
make install
If you did not encounter any errors, it means your Asterisk 1.2 is now Asterisk 1.4!

Got more questions? Hit the comments. :)

May 28, 2011 1 Comment Short URL
Post

VICIDIAL for 500 seats Call Center.

Here’s some tips also on getting VICIDIAL stable for 500 seats center. (*Note I am currently the IT Manager of a 600+ seats call center here in the Philippines.)

VICIDIAL cluster per campaign.

Some outbound campaigns only have 10 agents some 30 agents some 50 agents and the biggest i have right now is 280 agents.

What I usually do is asks the expansion plan. If it will do 40 agents per shift from the start, I usually create a new cluster for it. If it is only 20 agents I do single server.

You will also need at least a team of dialer people who will upload leads /modify campaigns/check system status and a whole lot more for VICIDIAL.

When it comes to hardware, it all boils down to a quad core for the asterisks/vicidial and the biggest and the baddest server you can get your hand’s on for the database. I use an IBM m2 series with 320gb hard drive on raid10, 32gb ram and centos 64bit.

Although it’s a lot of servers to manage and purchase, the cost of VICIDIAL being fully functional and head-ache free can seriously help bring the CAPEX and OPEX lower than what you should be spending if you are using a closed source system.

And yes I usually get drunk on friday nights, can sleep far more than 8 hours a day and have a hobby other than computers.

I am also available as a VICIDIAL Consultant. Hit the contact link to contact me :D

April 16, 2011 1 Comment Short URL
Post

sunday night drinking.

drinking!!!!!

April 10, 2011 No Comments
Post

Load g729 without restarting asterisk.

Here’s how to load g729 codec without restarting your asterisk open source pbx.

Go to asterisk cli by typing:

asterisk -rv

Then type

module load codec_g729a.so

That’s it! check if the g729 is loaded by typing show translation or show g729

April 8, 2011 No Comments Short URL
Images

270 Seats VICIDIAL Predictive Dialer

Here’s how it looks. 

Interested in hiring me? Use the contact link :)  
April 8, 2011 2 Comments Short URL
Post

The ugly way to WAN failover.

I’m just posting this for posterity sake.

So you have 2 NIC cards connected to different ISP. You wanted to have one to do a fail over once the other is dead.

Use this bash script.

#!/bin/bash
GW1=”192.168.10.254″
GW2=”192.168.55.254″
TESTIP=”192.71.220.10″ # Any reliable Internet ip that responds to ping.
CURGW=`/sbin/route -n |awk ‘/^0.0.0.0/ {print $2 }’`

if ping -w2 -c3 $TESTIP >/dev/null 2>&1; then
echo “Active ISP is Ok.”
else
if [ "$CURGW" = "$GW1" ]; then
NEWGW=”$GW2″
else
NEWGW=”$GW1″
fi
/sbin/route del default
/sbin/route add default gw $NEWGW
fi

Save and add it to your crontab.

January 3, 2011 No Comments
Post

Goodbye my past and hello my future.

Goodbye my past and hello my future,
may you be more kind of me, take care of me.

Goodbye my past and hello my future,
may you forget about my transgression, take another look at me.

Goodbye my past and hello my future,
may you make me more humble, start believing in me.

Goodbye my past and hello my future,
may you save my soul, give me a chance to be whole.

Goodbye my past and hello my future,
may you give me more strength, please open my eyes.

Goodbye my past and hello my future,
may you not trouble me with what I did in the past and prepare me for my bright future.

Amen.

- Edwin Adquilen Valbuena Jr.
January 2, 2010

January 2, 2011 No Comments
Post

What is the best voip router? What do others have and like?

VoIP
angiepangie8 asked:

What is the best voip router? What do others have and like?

May 19, 2010 3 Comments
« Older posts

Switch to our mobile site