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
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
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

tripleyourcalls – Predictive Dialer CRM


This is a promo for tripleyourcalls.com …. Explaining a little about the Predictive Dialer CRM…

March 30, 2010 No Comments
Post

AUGUTECH Predictive Dialer / autodialer


This video explains how you can increase your productivity and profits by using the AUGUTECH Dialer System. You can dial up to 10 lines for each agent, record phone calls, and even listen-in to your agents in real-time! For more info on this innovative system, please call us at 888-291-7579 or visit www.augutech.com.

March 29, 2010 1 Comment
Post

Zoiper Communicator


Training Video for the Installation and Configuration of Zoiper Communicator to use with Vicidial

March 28, 2010 No Comments
Post

nogaps Overview Part 1


This video gives a concise and rapid overview of the what the nogaps system. The various components of the system are the Business Intelligence built into the database, nogaps – centralized user control, CRM – vtiger, Telemarketing – Vicidial, Email – Dovecot and Postfix with a database back-end, VOIP PBX System – freepbx and Asterisk, Overal Virtual Server – Proxmox

March 27, 2010 No Comments
Post

Sangoma: What’s Next? Interview with Serge Forest, VP Marketing Sangoma


voipon speaks with Serge Forest, Sangoma’s new VP of Marketing. He gives a 2009 year in review, explains what’s ahead, and talks about some interesting case study implementations we can learn from.

March 26, 2010 No Comments
Post

ABS-CBN Kalye – Tambayan – Pinoy Call Center

March 25, 2010 No Comments
« Older posts

Switch to our mobile site