VICIDIAL Tips and Tricks: Webform and how to make one.
I created this tip because I kept on forgetting what’s the URL of the VICIDIAL test output for the webform variables.
Here’s how,
$filedate = date("Ymd");
$filetime = date("H:i:s");
$IP = getenv ("REMOTE_ADDR");
$BR = getenv ("HTTP_USER_AGENT");
$lead_id=$_GET["lead_id"];
$vendor_id=$_GET["vendor_id"];
$list_id=$_GET["list_id"];
$phone_code=$_GET["phone_code"];
$phone_number=$_GET["phone_number"];
$title=$_GET["title"];
$first_name=$_GET["first_name"];
$middle_initial=$_GET["middle_initial"];
$last_name=$_GET["last_name"];
$address1=$_GET["address1"];
$address2=$_GET["address2"];
$address3=$_GET["address3"];
$city=$_GET["city"];
$state=$_GET["state"];
$province=$_GET["province"];
$postal_code=$_GET["postal_code"];
$country_code=$_GET["country_code"];
$gender=$_GET["gender"];
$date_of_birth=$_GET["date_of_birth"];
$alt_phone=$_GET["alt_phone"];
$email=$_GET["email"];
$security=$_GET["security"];
$comments=$_GET["comments"];
$user=$_GET["user"];
$pass=$_GET["pass"];
$fronter=$_GET["fronter"];
$closer=$_GET["closer"];
$campaign=$_GET["campaign"];
$group=$_GET["group"];
$SQLdate=$_GET["SQLdate"];
$epoch=$_GET["epoch"];
$uniqueid=$_GET["uniqueid"];
$cust_zap_chan=$_GET["customer_zap_channel"];
$server_ip=$_GET["server_ip"];
$SIPexten=$_GET["SIPexten"];
$session_id=$_GET["session_id"];
$dialed_number=$_GET["dialed_number"];
$dialed_label=$_GET["dialed_label"];
$rank=$_GET["rank"];
$owner=$_GET["owner"];
?>
echo "lead_id: $lead_id\n";
echo "vendor_id: $vendor_id\n";
echo "list_id: $list_id\n";
echo "phone_code: $phone_code\n";
echo "phone_number: $phone_number\n";
echo "title: $title\n";
echo "first_name: $first_name\n";
echo "middle_initial: $middle_initial\n";
echo "last_name: $last_name\n";
echo "address1: $address1\n";
echo "address2: $address2\n";
echo "address3: $address3\n";
echo "city: $city\n";
echo "state: $state\n";
echo "province: $province\n";
echo "postal_code: $postal_code\n";
echo "country_code: $country_code\n";
echo "gender: $gender\n";
echo "date_of_birth: $date_of_birth\n";
echo "alt_phone: $alt_phone\n";
echo "email: $email\n";
echo "security: $security\n";
echo "comments: $comments\n";
echo "user: $user\n";
echo "pass: $pass\n";
echo "fronter: $fronter\n";
echo "closer: $closer\n";
echo "campaign: $campaign\n";
echo "group: $group\n";
echo "SQLdate: $SQLdate\n";
echo "epoch: $epoch\n";
echo "uniqueid: $uniqueid\n";
echo "cust_zap_chan: $customer_zap_channel\n";
echo "server_ip: $server_ip\n";
echo "SIPexten: $SIPexten\n";
echo "session_id: $session_id\n";
echo "dialed_number: $dialed_number\n";
echo "dialed_label: $dialed_label\n";
echo "rank: $rank\n";
echo "owner: $owner\n";?>
This is really located at http://astguiclient.sourceforge.net/test_VICIDIAL_output.phps
VICIDIAL Tips and Tricks: Some security hardening of VICIDIAL server.
Another point to consider. What to do if somebody wanted to gain access to your vicidial web admin? Well good thing about VICIDIAL Open Source Call Center Suite is that its almost documented. Matt is kinda a stickler for docs which I liked. Anyhow here’s what contain on the Base Install doc.
You may want to reduce the exposure of some of the elements of VICIDIAL. Here are some examples:
ln -s /dev/null /usr/local/apache2/htdocs/vicidial/project_auth_entries.txt
ln -s /dev/null /usr/local/apache2/htdocs/agc/vicidial_auth_entries.txt
ln -s /dev/null /usr/local/apache2/htdocs/agc/astguiclient_auth_entries.txt
ln -s /dev/null /usr/local/apache2/htdocs/vicidial/admin_changes_log.txt
- Change the WWW writable in the admin.php server settings to “0″
- Change the default admin user “6666″ or it’s password from the default
- Change the Default secret(password) for the default SIP and IAX accounts that are set up with astGUIclient
- Change the default password for the Asterisk manager connection in manager.conf then change it in the server modification screen
- Change the default password for the mysql cron user in mysql and change it to match in /etc/astguiclient.conf on each server
- Possibly use static IP addresses for the IAX/SIP conf account entries
- Change the default port for Apache in httpd.conf from 80 to something else
- Change the default port for IAX in iax.conf from 4569 to something else
- Change the default control port for SIP in sip.conf from 5060 to something else
- Use a firewall to route access using different port numbers or restricting connection by VPN or set IP addresses
for those people using vicidialNOW, the iptables entries are there. But you can also follow what was instructed above.
Easy isnt it? If you dont want to do it yourself, I am available as a consultant 
(gotta pay the bills!)
What is a Predictive dialer?
A lot of people doesn’t have any clue about predictive dialer. VICIDIAL is now a predictive dialer too. It has algorithms to do just that.
I took a liberty of lifting the wikipedia article on Predictive dialer.
Here’s The full article.
Predictive dialer
From Wikipedia, the free encyclopedia
Jump to: navigation, search
A predictive dialer is a computerized system that automatically dials batches of telephone numbers for connection to agents assigned to sales or other campaigns. Predictive dialers are widely used in call centers.
VICIDIAL Tips and Tricks: mySQL repair and optimize
You probably have a lot of logs and uploaded a lot of leads when using VICIDIAL. Then all of a sudden your you had a power outage or VICIDIAL is suddenly acting strange. Or you got your database corrupted. What to do?
It’s easy!
We repair and optimize the VICIDIAL mysql database! Here’s how.
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
Now it will ask you for a password, if you are using vicidialNOW the default root password is vicidialnow. If you are using vicibox, the password is the one you have set. For everything else, you are on your own.
VICIDIAL Tips and Tricks: Lost the manager’s password
Ok so you have lost your Web Admin manager’s password and you can’t login to the VICIDIAL web admin anymore. Don’t fret here’s how.
Login to your mysql database.
mysql -ucron -p1234 asterisk
Once in, you search for it like this
mysql> select * from vicidial_users where user='admin';
It will output this
+---------+-------+-------------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+--------------+------------------+--------------+----------------+----------------+-----------------+-------------------+---------------------+----------------+--------------+-----------------------------+-------------------------+------------+---------------+---------+-----------+-----------+-------------------+----------------------+----------------------+--------------------------+----------------------+---------------------+---------------------+
| user_id | user | pass | full_name | user_level | user_group | phone_login | phone_pass | delete_users | delete_user_groups | delete_lists | delete_campaigns | delete_ingroups | delete_remote_agents | load_leads | campaign_detail | ast_admin_access | ast_delete_phones | delete_scripts | modify_leads | hotkeys_active | change_agent_campaign | agent_choose_ingroups | closer_campaigns | scheduled_callbacks | agentonly_callbacks | agentcall_manual | vicidial_recording | vicidial_transfers | delete_filters | alter_agent_interface_options | closer_default_blended | delete_call_times | modify_call_times | modify_users | modify_campaigns | modify_lists | modify_scripts | modify_filters | modify_ingroups | modify_usergroups | modify_remoteagents | modify_servers | view_reports | vicidial_recording_override | alter_custdata_override | qc_enabled | qc_user_level | qc_pass | qc_finish | qc_commit | add_timeclock_log | modify_timeclock_log | delete_timeclock_log | alter_custphone_override | vdc_agent_api_access | modify_inbound_dids | delete_inbound_dids |
+---------+-------+-------------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+--------------+------------------+--------------+----------------+----------------+-----------------+-------------------+---------------------+----------------+--------------+-----------------------------+-------------------------+------------+---------------+---------+-----------+-----------+-------------------+----------------------+----------------------+--------------------------+----------------------+---------------------+---------------------+
| 1 | admin | vicidialnow | Admin | 9 | ADMIN | NULL | NULL | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | NULL | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | DISABLED | NOT_ACTIVE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | NOT_ACTIVE | 0 | 0 | 0 |
+---------+-------+-------------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+--------------+------------------+--------------+----------------+----------------+-----------------+-------------------+---------------------+----------------+--------------+-----------------------------+-------------------------+------------+---------------+---------+-----------+-----------+-------------------+----------------------+----------------------+--------------------------+----------------------+---------------------+---------------------+
1 row in set (0.00 sec)
There you go!
Enjoy.
VICIDIAL Tips and tricks: Easy Upgrade from 2.0.4 to 2.0.5
Ok so you are pretty stucked with a 2.0.4 version of VICIDIAL. You want something new and shiny Predictive Dialer for your center. Here’s how.
First let’s download VICIDIAL 2.0.5 rc2. This is the latest VICIDIAL version. Let’s do this.
Create a directory for your new VICIDIAL install.
Then let’s download VICIDIAL.
wget http://downloads.sourceforge.net/sourceforge/astguiclient/astguiclient_2.0.5.1rc1.zip?use_mirror=nchc
Unzip it
unzip astguiclient astguiclient_2.0.5.1rc1.zip
Before we do anything let’s back up our asterisk folder!
tar cvf asterisk.backup.tar /etc/asterisk
Due to recent changes in the database we also need to back up our mysql database in case something went really wrong. This will backup all your VICIDIAL database and non VICIDIAL databases.
mysqldump --all-databases> alldatabases.sql
For more hardcore and you are feeling hardcore, you can go get the mysql var folder and just save it to another computer.
Now we are almost ready right? But not yet. Let’s install the cpan module added also.
perl -MCPAN -e shell
Install Switch
install Switch
Ok so we now have the the Switch perl module let’s upgrade the database
mysql
use asterisk
\. /thelocation/oftheastguiclientfolder/extras/upgrade_2.0.5.sql
This will take some time if you are using VICIDIAL long enough to accumulate a lot of logs and loaded a lot of leads. After it’s done type quit.
Ok so we have upgrade VICIDIAL database now. Let’s try to upgrade VICIDIAL now.
perl install.pl‘
Press enter to the questions. Then that’s it! you now have upgraded your VICIDIAL 2.0.4 to VICIDIAL 2.0.5.
Remember to get the Manual from www.eflo.net/store.php and read it before asking a lot of questions!
If you need help, Im available for consulting too. Just click on the contact button of my blog. 
VICIDIAL featured in ABS-CBN show Kalye
I got to watch the show of abs-cbn called Kalye yesterday. They have interviewed some agents in a call center Im currently supporting for VICIDIAL Open Source Call Center suite. Although we just watched the video with out the sound. VICIDIAL WAS SHOWN IN IT BEING USED BY CALL CENTER AGENTS!!!
Yep, I did install the VICIDIAL Open Source Suite that was shown in that show. Yes there are more than 160 people using VICIDIAL at Globalspan. and Yes I AM BRAGGING ABOUT IT
I dont have the video at the moment. Let me scour the internet if anyone have a copy of the said show. Got the video now.
and yes you can contact me for VICIDIAL services too
Watch this space.
FYI: Im more of a kapuso guy I watch abs-cbn channel just to see Maja Salvador
Matt Florell VICIDIAL | VoIP Users Conference
Spend an hour and a half with Matt Florell talking about VICIDIAL , the Open Source Call Center software, and plenty of other subjects including CentOS,