How to – Install Vicidial on Alma Linux 9 with my new auto installer

Alma Linux 9 Vicidial

How to – Install Vicidial on Alma Linux 9 with my new auto installer

That’s right, I have fixed the issues with dahdi and php7 installations on Alma Linux 9 and created the auto installer for it, complete with the dynamic portal and the CyburPhone. Its been tested and is working. So lets get to it! The code can be found here: https://github.com/carpenox/vicidial-install-scripts/tree/main

Alma 9 ISO – https://repo.almalinux.org/almalinux/9/isos/x86_64/AlmaLinux-9-latest-x86_64-dvd.iso

Step 1 – Download the dependencies

timedatectl set-timezone America/New_York

yum check-update
yum update -y
yum -y install epel-release
yum update -y
yum install git -y
yum install -y kernel*

#Disable SELINUX
sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config    

reboot

Step 2 – Download GitHub files

cd /usr/src
git clone https://github.com/carpenox/vicidial-install-scripts.git
cd vicidial-install-scripts

Step 3 – Run the installer

Now yes this an auto installer, but you have to hit enter a couple times as well as add the server’s IP so don’t walk away for too long.

chmod +x alma-rocky9-ast16.sh
./alma-rocky9-ast16.sh

Or the Asterisk 18 version:

chmod +x alma-rocky9-ast18.sh
./alma-rocky9-ast18.sh

That’s all there is to it. I hope you guys like it, it was a lot of hard work. Please donate to keep this blog thriving: https://www.paypal.me/TheDialerOne

-Chris aka carpenox

Dialer.One: The Ultimate Solution to Avoid Robocaller Blocks and Costly Legal Pitfalls

Avoid RoboCaller

Dialer.One: The Ultimate Solution to Avoid RoboCaller Blocks and Costly Legal Pitfalls

In today’s business landscape, effective communication is paramount, but it’s often challenged by an array of obstacles, from RoboCaller blocking apps to costly Do-Not-Call (DNC) violations and TCPA litigations. Enter Dialer.One – a revolutionary platform designed to help businesses overcome these challenges while saving substantial costs. Discover how Dialer.One can empower your business and safeguard your communication endeavors.

Robocaller and Scam Blocking Apps: The Communication Barrier

The rise of RoboCaller and other scam likely blocking apps has made it increasingly challenging for legitimate businesses to reach their customers. These apps indiscriminately block calls, making it difficult for businesses to connect with their target audience. This communication barrier can result in lost opportunities and hindered growth.

Dialer.One: Breaking Through the Blockade

Dialer.One emerges as the ultimate solution to overcome the obstacles posed by RoboCaller and scam blocking apps. How does it work?

  1. Smart Dialing Technology: Dialer.One employs cutting-edge predictive dialing technology that ensures your calls are not mistakenly labeled as spam. Say goodbye to missed connections and lost leads.
  2. Data-Driven Strategies: Our platform prioritizes calls based on lead quality and predictive analytics. This means your agents are engaging with the most promising leads, optimizing your conversion rates.
  3. Avoiding DNC Violations: Dialer.One provides built-in compliance mechanisms to help you steer clear of costly DNC violations. Stay on the right side of the law while reaching out to potential customers.
  4. TCPA Litigation Protection: Our platform’s advanced features protect you from TCPA litigators by ensuring that your communication practices are in full compliance with regulations.

Saving Thousands with Dialer.One’s Custom Solution

Beyond overcoming robocaller blocks and legal hurdles, Dialer.One offers a groundbreaking solution that can potentially save your business thousands of dollars each month. What sets us apart?

  1. Ownership, Not Monthly Charges: With Dialer.One, you own the custom-built dialer solution. Say goodbye to expensive per-seat monthly charges that can eat into your budget. This ownership model allows you to maximize savings and control your communication costs.
  2. Scalability and Flexibility: As your business expands, Dialer.One grows with you. There’s no need to worry about any restrictions for scaling up your operations.
  3. Exceptional Support: Our dedicated support team is available 24/7 to assist you. We’re not just a software provider; we’re your partner in communication success.

Start Saving Your Business Money Today!

Don’t let RoboCaller, DNC violations, and TCPA litigators impede your business growth and drain your resources. Dialer.One is your comprehensive solution to these challenges, offering smart technology, compliance protection, and substantial cost savings.

It’s time to break through the communication blockade and take control of your business’s future. Visit www.dialer.one today to explore the possibilities and embark on a journey towards enhanced communication, compliance, and savings. Dialer.One: Empowering your business for success.

CyburDial: Your One-Stop Solution to Revitalize Your Contact Center

Connect center solution

# CyburDial: Your One-Stop Solution to Revitalize Your Contact Center

As businesses grow, seamless communication becomes an imperative need. Whether you are a solar company, a real estate entity, a marketing agency, or a health insurance company, focusing on revenue generation while maintaining absolute control of your business can be a challenging dance. This is where CyburDial comes in.

CyburDial is a potent solution offered by Dialer One, a platform renowned for providing a complete and controlled customer service solution. Its state-of-the-art cloud-based business management operations platform ensures you have absolute control over inbound and outbound customer campaigns. Imagine owning a contact center system, without having to rely on another business’s response time for support or facing downtimes.

Agent communication platform
Agent communication platform

## Full System Automation

CyburDial breaks the shackles of traditional contact center systems with full system automation. It includes AI-driven answering machine detection which reduces wasted time by connecting your agents to real humans rather than answering machines. This potent system also seamlessly integrates with top CRMs such as High Level, Salesforce, Zoho, amid providing blended outbound and inbound campaigns.

## Elevated Agent Performance

Monitoring agent performance is pivotal for the growth and efficiency of any contact center. With CyburDial this becomes as easy as pie. It provides full visibility as to what all your agents are doing, along with comprehensive reports. A full Quality Control and Coaching Implementation helps in elevating the standards, thereby directly reflecting on the growth of the company.

Efficient agent time management
Efficient agent time management

## Time Management Efficiency

Time Management is often overlooked in a bustling contact center. CyburDial handles this powerful aspect by monitoring the actions of agents at a granular level. It also includes a full Learning Management System for easy onboarding of new agents.

## Why Choose CyburDial?

One of the standout features of CyburDial that sets it apart is that you own the system. Yes, there are no monthly per seat charges, thereby cutting your business overhead by a significant 65%. The US-based customer support is efficient, effective, and commendable. Above all, the platform is customizable and can be fully integrated with most CRM systems, which means you can add or remove features as per your requirements.

If you wish to focus on revenue-generating activities while maintaining complete control of your business operations, CyburDial is the right move for you.

Get started now and witness your business flourish like never before!

How to – Modify your options.php file to get the most out of your dialer

Real time screen

How to – Modify your options.php file to get the most out of your dialer

This article is going to go over the options.php files for both the real time screen and the agent login screen. I am actually surprised to find out how many people don’t use or even know about these simple changes that make dialer management so much easier and more professional. Ok so we’ll start with the options setup for the real time screen.

Step 1 – Edit the options-example.php file that controls the real time screen

Login to your server and navigate to your vicidial directory. In Leap, that would be /srv/www/htdocs/vicidial and for CentOS, Alma or Rocky, it’s /var/www/html/vicidial. Once you change to the property directory, edit options-example.php with your favorite editor, I personally use nano, as shown in the picture below:

Changes to options.php

You’ll notice up towards the top of the file, you can change the location, size and type of webphone to use on the real time screen. Below that starts the real changes that you should change by default on every install you do. I personally change the refresh time($RS_RR) from 40 to 4, SERVdisplay from 0 to 1 to show which servers are making calls and what server each agents phone is on, CUSTINFOdisplay from 0 to 1 which will display the customers number and state on the real time only to level 9 savings by default but you can lower that on the next setting. CARRIERstats is next, from 0 to 1 which will show your carier responses on your real time, AGENTtimeSTATS from 0 to 1, as well as logoutLINK, parkSTATS and SLAstats from 0 to 1.

The last settings I change are DIDdesc from 0 to 1, report_default_format I set to ‘HTML’, I enable AGENTlatency by changing to a 1, this way I can see what agents have poor internet connections and are lagging too much and then finally, I add ‘SALE’ to AGENTstatusTALLY so it shows how many sales each agent has on the real time. Now there’s other things that can be changed as well, just be careful and when you save the file, rename it from options-example.php to options.php like below:

This is what your finished project will look like:

Real time screen
Real time screen

Step 2 – Editing your options file in relation to the agents login and screen

There is only a few changes for this file, so go ahead and navigate to the agc directory by backing out of the current one by typing “cd ..” and then “cd agc”. Once again, edit the options-example.php and change the following settings starting with user login first which makes it where your agents only need to login with user and pass rather than phone and pass as well, but you need to save their phone login and phone pass to the user accounts.

Well , that’s all there is to it, if you have any questions feel free to stop by our group chat which now has over 200 members from the vicidial forums – https://join.skype.com/ujkQ7i5lV78O

I hope this helps!

-Chris aka carpenox

Contact Center Build-Outs

Custom built dialer

Contact Center Build-Outs

Why choose us for your Contact Center Build-Out?

We are the only vendor on the planet that has everything under one roof for a complete Contact Center Build-Out.

Providing customer service is basic, however, it is a top priority that directly affects a company’s bottom line. With Dialer One, you have control of inbound/outbound customer campaigns without contracts or excuses from a service provider. Wouldn’t it be nice to own your own contact center system? Imagine not having to rely on another businesses downtime or wait time for support. We specialize in building your business a contact center system that not only dials your customers, but also had the ability to email, chat directly with potential clients from your website or other platforms, send and receive text messages, video conferencing, as well as full integrations with your CRM of choice such as Zoho, SalesForce, vTiger, SuiteCRM or any other CRM software of your choice. So what are you waiting for, give us a call now and let’s talk about how we can help you triple your results at the very least with our Contact Center Build-Outs!

Voip phone system
Voip phone system

What Is Included in your Contact Center Build-Out?

Full System Automation

  • AI numbers which takes your DID you place the call from, changes the caller ID to a local area code presence and attestation level A shaken token and then sends the call, if the caller calls back, it’s handled by their backend to automatically map the call back to your original DID.
  • Full 2-Way seamless integrations with High Level, SalesForce, Zoho and more.
  • Artificial Intelligence driven answering machine detection giving your agents more humans and less answering machines, saving wasted time and money
  • Blended outbound & inbound campaigns
  • All Leads Go To All your Agents

Agent Performance Monitoring

  • Full Visibility as to what all your agents are doing
  • Provide full reports for all your clients
  • Full Quality ControlControlControlControloutboundControlControlControlControloutbound Implementation
  • Full Quality Control and Coaching implemented: We’ve examined countless call centers and almost everyone is missing the mark!

Agent Performance / Time Management

  • Able to monitor what agents are doing at a granular level
  • Individual agent monitoring / DID disposition
  • Monitor agents individually for conversion rates.
  • Full Learning Management System for easy onboarding of new agents

Who Should Use Dialer One’s Services?

  • Solar Companies
  • Marketing Agencies
  • Health Insurance Companies
  • Real Estate Companies
  • Travel Agencies and Vacation clubs

Any company that wants to focus on revenue-generating activities and also be in complete control of their business. We are ready to get you going TODAY!

Hey, my name is Chris aka carpenox. I am one of the most well known vicidial contributers on the planet, just ask around. The blog on our website gets over 250 hits a day from around the globe and I also contribute on the ViciDial forums. I know this dialer system inside and out and have made many custom features for clients as needed as well as a nicer user and admin interface. I now have put together a team of talented individuals to which we build custom dialer solutions with full CRM integrations and API capabilities as needed through your requests. So what are you waiting for? Let us start building your future!

Fill out the form below to get started or join our live support channel .

Special Offer for the first 10 applicants : Basic dialer build that YOU own for $250(50% off)

Why choose The Dialer One? Here’s what sets us apart:

You own this system, you don’t rent it so there’s no monthly charges. Reduce you’re business overhead by 65%, without those expensive per user monthly dialer fees. Effective and efficient USA based customer support. Unbeatable pricing – With this one time discount of 50% off, you can’t beat it for something you’ll own once built. Fully customizable platform, with full API capabilities, features to add or remove with thousands of options, plus the design itself can all be changed. Can be fully integrated with most CRM systems such as Zoho, SugarCRM, TigerCRM, GoHighLevel or whatever CRM you are using. Guaranteed one POC – You’ll be assigned your own support rep to handle your entire build process. Remote installation, your support tech will install your system with all your changes directly onto YOUR server, not ours within 24 hours of your purchase.

Experience seamless communication from your state-of-the-art VoIP phone system custom built to meet your business needs. As a special offer, we’re providing a basic dialer build to the next 10 applicants! Don’t miss out on this opportunity to discover the possibilities and reduce your monthly communication costs but as much as 75%!

Just to clarify, your dialer system can do everything the big companies like RingCentral, Dialpad, Convoso and the others can do and much much more with the ability to add both basic and API features, as and when needed. Not only that but we can also integrate your CRM with automated processes that add the information for you as soon as your sales call is done. Not only that, but we can also add other communication options such as SMS, Video chat, WhatsApp, Facebook and more. How is that possible? It’s YOUR system, you OWN it, you don’t rent it with those expensive monthly or yearly charges. So what are you waiting for, let’s get your dialer system up and running today!

If you want to get right into a more advanced build with API triggers and design changes or added features, we will give you a free quote today.

For a free quote on a more customized system click here

If you’re ready to buy our $250 special, clock the button below:

How to – Upgrade your Vicidial Database from 2.2 all the way up to 2.14 & all versions in between

SVN Update

How to – Upgrade your Vicidial Database from 2.2 all the way up to 2.14 & all versions in between

This article is going to go over how to upgrade your ViciDIal database as far back as 1.1.12-3 all the way up to the current 2.14 and every step in between. No matter what version of Astguiclient you have, this post will show you how to step yourself up, one upgrade at a time until you get to the version you want to be at. It will also show you what was added to each GUI version starting from day one.


########## UPGRADE

NOTE: Upgrading from 2.11 to 2.13 is below the first section
NOTE: Upgrading from 2.9 to 2.11 is below the first section
NOTE: Upgrading from 2.7 to 2.9 is below the first section
NOTE: Upgrading from 2.4 to 2.7 is below the first section
NOTE: Upgrading from 2.2.1 to 2.4 is below the first section
NOTE: Upgrading from 2.0.5 to 2.2.0 is below the second section
NOTE: Upgrading from 2.0.4 to 2.0.5 is below the third section
NOTE: Upgrading from 2.0.3 to 2.0.4 is below the fourth section
NOTE: Upgrading from 2.0.2 to 2.0.3 is below the fifth section
NOTE: Upgrading from 2.0.1 to 2.0.2 is in the next section
NOTE: Upgrading from 1.1.12-3 to 2.0.1 is at the bottom

#### UPGRADING FROM 2.13 TO 2.14

OPTIONAL STEPS(But highly recommended) – Backup existing system:

  1. Run this for a 1-server system or server with database on it:
    (this may take hours on large system)
    /usr/share/astguiclient/ADMIN_backup.pl –debugX
  2. Run this on dialer/Asterisk-only servers:
    (do not run this if you only have one server):
    /usr/share/astguiclient/ADMIN_backup.pl –debugX –without-db –without-web

REQUIRED STEPS!!!

  1. Check system_settings, make sure you are at DB Schema Version 1478 or higher
    If not, run the instructions for 2.11 to 2.13 before this section.
  2. upgrade the MySQL asterisk database(you have two options):
    A. Running the upgrade file directly from Linux:
    mysql -f –database=asterisk < /path/from/root/extras/upgrade_2.14.sql B. Going into mysql and executing the upgrade sql file:
    mysql
    use asterisk
    . /path/from/root/extras/upgrade_2.14.sql
    quit
  3. install new files:
    perl ./install.pl
    NOTES: If you have customized any scripts in the bin or agi folders,
    then make sure you back them up before running the install.pl script.
    This script will replace existing files in the astguiclient installation.
  4. For each of your ViciDial servers, go the Admin -> Servers -> Modify Server
    page and set each one to “Rebuild conf files = Y” and click submit.
    This will rebuild the conf files to ensure any changes are updated.
  5. On one server only, update your phone codes data:
    /usr/share/astguiclient/ADMIN_area_code_populate.pl –purge-table –debug

OTHER CHANGES:

  1. Added AST_inbound_export.pl script for in-group call data exports
  2. Added cm_sc_areacode.agi script that allows you to use a Settings Container
    with the script in a Call Menu to define different destinations for
    customers from each state to go to: DID, CALLMENU, EXTEN
  3. Added Agent DID Report
  4. Added the ability for internal chats to have more than one agent participant
  5. Added cm_phonesearch.agi script that can search for a phone number within the
    system and redirect a call to an in-group that is defined as the Default
    Transfer Group in a campaign that the lead belongs to. This must be
    configured in a Call Menu
  6. Added In-Group option to populate new leads with a DID descriptive value in
    the province field of the new lead.
  7. Added cm_sc_send_url.agi script for Call Menus on calls tied to a lead_id to
    send a URL defined in a Settings Container.
  8. Added phone_number_log Non-Agent API export function
  9. Added api_only_user User option to prevent access to admin and agent screens
    by an API-only user account.
  10. Added logging of API request URLs
  11. Added campaign setting for Dead Call to Dispo Only, to allow the Dead Call
    Max Seconds setting to send the agent to the dispo screen
  12. Added web lead loader duplicate check options to check for leads loaded only
    within the last 90-days. Also added to Non-Agent API add_lead function.
  13. Added Agent API function switch_lead to switch the active call lead_id while
    the agent is on a live inbound phone call.
  14. Added In-group areacode_filter feature, allowing you to drop calls after a
    set number of seconds in queue that either match or do not match a list
    of areacodes defined per in-group.
  15. Added new DNC options to Manual Dial Filter campaign feature that are not
    tied to the campaign DNC settings.
  16. Changed Emergency Logout processes to hangup all agent session calls, and
    added better logging
  17. Changed Custom Fields of SCRIPT type to allow URLs and urlencoded variables
    when using –U– and –V– to declare variables
  18. Added option for custom list fields to be required for all calls or only
    inbound calls. Will prevent agent hanging up call if field is not filled
    in. Must also have campaign option enabled for it to work. Will work for
    the following custom field types:
    TEXT, AREA, DATE, SELECT, MULTI, RADIO, CHECKBOX
  19. Added admin Automated Reports section, allowing easier web configuration of
    scheduled reports being sent by Email or FTP.
  20. Added campaign option to validate transfer agent list based upon which
    AGENTDIRECT in-groups those agents had selected.
  21. Added In-Group option to look up the state based upon the areacode of the
    caller ID phone number of the person calling in.
  22. Added CHAT option to Inbound Queue No Dial campaign setting to prevent
    outbound auto-dialing if a chat is waiting for an agent
  23. Added qualify option to phones for IAX type phones
  24. Added Pause Code Time Limits to allow you to set a time limit on the number
    of seconds an agent can be in a specific pause code before the real-time
    report will show them in a different color.
  25. Added Drop Lists feature, allowing you to add new leads to a list built from
    DROPped calls from inbound groups on a scheduled basis.
  26. Added USER_CUSTOM_ options to campaign custom callerID setting to allow for
    custom caller IDs to be used per agent in MANUAL and INBOUND_MAN modes
  27. Added IP Lists feature, allowing creating of lists of IP Addresses that can
    be used as whitelists on a User Group basis for Agent, Admin and API
    web resources.
  28. Added campaign option(with user override) Ready Max Seconds Logout to log an
    agent out of the agent screen if they have been in a ready state for
    more than X seconds.
  29. Added cm_fpg.agi script to allow callers to place their phone numbers into a
    Filter Phone Group. Works from a Call Menu.
  30. Added Inbound and Advanced Forecasting Reports. Both use the Erlang formulas
    and past data to forecast agent and call metrics.
  31. Added campaign option for Callbacks Display Days which can limit the
    scheduled callbacks displayed to an agent by a number of days from now
  32. Added campaign options to stop recording when a 3-way call is started and
    start recording when the hangup xfer line button is clicked
  33. Added start call URL feature support for manual dial calls
  34. Added logging of Real-Time report monitoring, and report in Admin Utilities
  35. Added Agent Push Events, allowing for HTTP Push events to be sent on agent
    screen events. See the AGENT_EVENTS.txt doc for more details.
  36. Added Add-to-hopper options to update_lead function in the Non-Agent API
  37. Added basic one-way Cross-Cluster-Communication feature. Allowing for lead
    information to pass from one VICIdial system to another with a call.
    See the CROSS_CLUSTER_COMMUNICATION.txt document for more information.
  38. Added Real-Time agent status of “DIAL” for agent manual dial calls after
    they have been placed but before they have been answered.
  39. Changed password fields to allow up to 100 character passwords. Also changed
    password recommendations to emphasize length over complexity.
  40. Added logging and notification of 3-way call hung up in agent screen.
  41. Added URL logging of Agent Screen Webform button clicks and URLs
  42. Added AST_agent_wait_check.pl script to send out emails if there are agents
    waiting more than X seconds.
  43. Added In-Group option to ask callers if they would take a survey after
    agent has handled their call. Overrides agent HANGUP CUSTOMER button
    to send call to survey instead.
  44. Added system setting to allow Lead Management admin utilities to handle
    active lists. Also changed Advanced Lead Management tool to allow
    you to select multiple lists.
  45. Added Inbound DID Summary Report
  46. Added Agent Inbound Status Summary Report
  47. Added experimental support for Asterisk 13. See the ASTERISK_13.txt doc
    for notes on changes needed to get it to work.
  48. Added System Settings option to set lists to inactive once they pass their
    expiration date
  49. NEW REQUIREMENT!!! Perl CPAN Net::Telnet version 3.0.4(April 21, 2013)
    If you are using an older Net::Telnet version, you will need to upgrade!
    this should take just two commands: “cpan” and “install Net::Telnet”
  50. Added DID System-wide filter option to System Settings
  51. Added DNC.COM inbound number filtering with DNCcom_inbound_filter.php
  52. Added cm_cid_change.agi script to alter the CID of calls in the Call Menu
    Prompt. Also, added ability for cm_dnc.agi to recognize Vicidial-tagged
    calls and update lead records without lookups from a phone number
  53. Added Webphone Layout option in Phones and override in User Groups
  54. Added campaigns-scheduled_callbacks_email_alert option to send email alerts
    to agents when scheduled callbacks are triggered while they are logged
    in to the agent screen. Read the HELP for instructions to set up.
  55. Added new Real-Time Whiteboard multi-report
  56. Added the ability to include duplicate custom text fields in a custom fields
    form in the agent screen.
  57. Added Max Inbound Calls Outcome to allow for different behaviors when an
    agent reaches their maximum inbound calls for the day
  58. Added campaign option to allow agents to pause the Manual Dial Auto Next
    feature
  59. Added ability to display inbound email messages in Script tab scripts.
  60. Added dispo_change_status.php script to allow changing of a lead’s status
    to a different status after it has been dispositioned as a specified
    status a set number of times.
  61. Added Agent Screen Time Report campaign option, to display agent time
    statistics in the agent screen for the current day.
  62. Added List Override setting for Default Transfer Group
  63. Added lead_status_search Non-Agent API function
  64. Added “Next-Dial My Callbacks” campaign setting that will automatically dial
    USERONLY Scheduled Callbacks for agents in MANUAL or INBOUND_MAN
    no-hopper campaigns when they click DIAL NEXT NUMBER in the agent screen
  65. Added “Anyone Callback Inactive Lists” System Setting option to determine
    how ANYONE scheduled callbacks from inactive lists should be handled.
  66. Added “Inbound No-Agents No-Dial” Campaign setting, checks if any agents are
    ready and waiting for phone calls from listed In-Groups before allowing
    outbound auto-dialing.
  67. Added new PRESS_CALLBACK_QUEUE option to Hold Time and Wait Time In-Group
    settings, allowing for a customer to retain their place in line in the
    queue and be called back when their turn is reached.
  68. Added new Closed Time features to In-Groups that allow all calls in queue
    to be presented with an option when the in-group closing time for the
    day has been reached. Also, an option was added to manually force the
    end of all queueing of calls for an in-group for the day.
  69. Added dial_ingroup option to Agent API external_dial function.
  70. Added In-Group option to look up timezone of customer when a new lead is
    added during the routing of the call.
  71. Added the Outbound Lead Source Report
  72. Added basic GDPR features for lead activity download and delete. Must enable
    System setting and user permission to use.
  73. Added CID Groups, allowing for groups of caller IDs to be defined by state
    or areacode, and allowing a single CID Group to be set across multiple
    campaigns.
  74. Added NO_READY option for no_agent_no_queue in-group feature.
  75. Added campaign option “Script on top of Dispo” to allow the agent screen
    script tab to cover the dispo screen after hanging up the customer to
    allow for Agent-API-enabled IFRAMEs to control the agent dispo process.
  76. Added feature to allow for bulk change of campaign and in-group ranks and
    grades in the User Modify page.
  77. Added “Admin Lead Source ID Display” System Settings option to allow Modify
    Lead page modification of Source ID field, and display in hopper list.
  78. Added LOCALFQDN trigger for webforms and script Iframes to allow for use of
    absolute URLs on multi-home networks. See CALL_URL_FEATURES.txt doc.
  79. Added update_did Non-Agent API function
  80. Added pause code manager approval option, requires a manager to approve a
    specific flagged pause code before the agent is allowed to use it in
    their agent screen. Manager approves by entering their login credentials
    into a window on the agent’s screen.
  81. Added DISPO_FILTER Settings Container option allowing for match-and-replace
    function in Dispo Call URLs. See CALL_URL_FEATURES.txt doc for details.
  82. Added populate_lead_vendor and populate_lead_source options for In-Groups.
  83. Added In-Group option to override the Park Music-on-Hold.
  84. Added SWITCH custom field type to put buttons on the agent FORM to allow for
    the form to be switched while on an active call.
  85. Rewrote HELP display in web admin screens to function as database-driven
    javascript popup.
  86. Added per-user options for maximum number of outbound manual dial hopper
    calls per-hour and per-day.
  87. Added In-Group option for Waiting Call On/Off URL, which we added to allow
    a client to control a web-power-switch to turn lights on and off if
    there are any calls waiting in an In-Group.
  88. Added In-Group option for Enter In-Group URL, which can send a URL request
    when a caller enters an In-Group right before the system looks for an
    agent to send the call to.
  89. Added Manual Dial Routing Initiated Recording, must enable setting at the
    campaign level and have a 0 recording delay.
  90. Added campaign features for Dead Call Trigger. Allowing an audio alert to be
    sent to an agent and/or a back-end URL to be submitted when an agent has
    been in a dead call for X number of seconds.
  91. Added the ability for customers to be able to enter a new phone number to be
    called back on for the CallerID CallBack Queue feature.
  92. Added the new Callmenu Survey Report(linked as “Callmenu Agent” in Reports).
  93. Added “Agent Screen Logout Link Credentials” System Setting to change the
    agent screen logout page login link to not include user credentials.
  94. Added new campaign feature to force agents to call back their triggered
    USERONLY Scheduled Callbacks.
  95. Added new campaign feature to automatically reschedule ANYONE callbacks when
    they are dispositioned as a non-Human-Answered status flag status.
  96. Added new campaign feature to allow agents to select a specific timezone to
    use when scheduling callbacks. For this to work, the Phone Codes must be
    updated on your system using the following command:
    /usr/share/astguiclient/ADMIN_area_code_populate.pl –purge-table –debug
  97. Added new ‘force_fronter_leave_3way’ Agent API function, allowing an API
    command to be sent to the fronter of a call to leave-3way their call.
  98. Added List Daily Reset Limit option, only editable by level 9 users.
  99. Added 3-Way Volume Buttons campaign setting to allow disabling of volume
    and mute buttons in the LIVE CALLS IN YOUR SESSION panel during a 3-way
    call.
  100. Added campaign setting to filter ANYONE Scheduled Callbacks by the DNC
    settings set in the campaign
  101. Added _wait_time options to Next Agent Call settings for Campaigns and
    Inbound Groups.
  102. Added External Web Socket URL option so a WebRTC phone can be used outside
    a network if the Phone is set to Use External Server IP = Y
  103. Added SYSTEM options to the campaign detail Manual Dial Filter feature
  104. Added lead_callback_info Non-Agent API function, it outputs scheduled
    callback data for a specific lead
  105. Added Manual Dial Validation campaign and system settings, forces agent to
    manually enter in the phone number before a call is placed. Does not
    affect 3way calls or transfers.
  106. Added alphabet letters translation to phone DTMF digits feature in Agent
    Screen. For example, Putting “SMITH” in the SendDTMF field would result
    in “76484” being sent over DTMF.
  107. Added “force_fronter_audio_stop” Agent API function, allowing an API
    command to be sent to the fronter session of a closer call to stop
    playing of an audio_playback pre-recorded audio stream
  108. Added options to define the static prompts to use for the Inbound Group
    “Play Place in Line” feature
  109. Added new web pages for mobile application
  110. Added feature allowing agents to mute recordings of calls from the agent
    screen. Must be enabled in System Settings to be able to use it in
    campaigns. There is also a User Override option.
  111. Added more options to the Campaign “Hide Call Log Info” feature to be able
    to show only the last X number of calls in the Lead Info screen. Also
    added a User Override setting for this feature.
  112. Released VICIdial Manager Manual version 2.14-704a:
    http://www.vicidial.org/store.php#MANAGER
  113. Added more logging for Asterisk AMD as well as beta AMD patch for logging
    of NOAUDIODATA answered calls and more AMD stats gathering. Also added
    an AMD Log Report to the Admin Utilities page.
  114. Added Admin User Redirect URL settings, which allows you to define a web
    address that a user is to be sent to when they log in to the admin web
    screen. This is usually used for level 7 report only users to send them
    to one specific report when they log in without seeing the admin web
    screen at all. Must be enabled in System Settings.
  115. Added experimental SIP event logging. Requires patched Asteirsk 13 and
    newer version of MySQL/MariaDB. Must be enabled in System Settings and
    each dialer’s astguiclient.conf/extensions.conf/manager.conf files
    Read SIP_EVENT_LOGGING.txt doc for more details
  116. Added new Non-Agent API function ‘update_cid_group_entry’ which allows you
    to add/update/delete/info CID Group entries and AC-CID entries
  117. Added new Non-Agent API ‘custom_fields_copy’ option to the ‘add_list’
    function
  118. Added new Call Quota Lead Ranking recycling feature-set. A new and
    completely different way to do lead recycling for outbound campaigns.
    See the CALL_QUOTA_LEAD_RANKING.txt document for more info
  119. Added bench_agent_assign.php script to allow managers to move
    ‘owner-assigned’ to another agent.
  120. Added User Inbound Max Calls filtering options. Allowing selective counting
    of inbound calls excluding calls involving set in-groups, statuses and
    with a minimum time threshold. Also, new in-group routing options based
    on last non-filtered call times
  121. Added System Settings option for second agent screen script tab
  122. Added a Campaign option for VoiceMail Message Groups, allowing agents to be
    able to select a message to transfer a customer answering machine to
    from a list of pre-recorded messages that can be defined by time-of-day.
  123. Added a Campaign option to not send an agent immediately to the disposition
    screen after transferring a customer call to a VoiceMail Message.
  124. Added Campaign option for Dial Timeout Lead overrides, allowing you to set
    up a Settings Container with values for manual-dial and/or auto-dial
    lead fields and associated values that will tie to different
    Dial Timeouts.
  125. Added LTMGAD and XAMMAD Campaign Hotkey options that will transfer to the
    Leave-Voicemail option as well as dispositioning the call.
  126. Added a per-User option to define an additional Status Group of call
    statuses that agents can use to disposition all calls they handle.
  127. Added System Setting to hide the first web form button on the agent screen.
  128. Added System Setting options for alternate agent screen recording buttons.
    This includes different wording, different sizes and removing the blank
    space below the recording buttons.
  129. Added ability to play multiple audio prompts for outbound survey campaigns
    and to use DYN for lead field wildcards defined as audio prompts.
  130. Added ability to limit the number of voicemail messages played to a single
    lead per day, as a campaign setting.
  131. Added CID Group Type of NONE to allow for a group of outbound CIDs to be
    used for all outbound phone calls no matter where they are.
  132. Added Auto-Rotating CID Group numbers, allowing for timed automatic cycling
    of CID numbers, one-at-a-time, within a CID Group.
  133. Added optional OpenSIPs CallerID Name settings, for use only with systems
    that use an OpenSIPs server to route outbound calls where this feature
    has been enabled.
  134. Added system settings option to require passwords of a set minimum length.
    This setting affects User passwords, Phone and Server registration
    passwords and the System Settings default passwords.
  135. Added support for KHOMP Answering Machine Detection. This is a 3rd-party
    commercial(paid-for) solution. The code and documentation can be found
    in the “extras/KHOMP” directory of the codebase.
  136. Added AMD Agent Route Options as a campaign option allowing you to set
    the specific AMD responses for calls that should be routed to agents
  137. Added the “list_custom_fields” Non-Agent API function, to show all list
    custom data fields in a list/all-lists.
  138. Added an optional “send this user a login link email” link to the User
    Modify page to send a shortcut URL link for the agent to more easily
    log into the agent screen. Must be enabled in System Settings.
  139. Added new System Settings option to allow sending of any CallerID through
    the Agent API for external_dial outbound calls.
  140. Added system setting to allow you to restrict Admin Phones display to a
    set number of records per page.
  141. Added options at the campaign and in-group levels to allow you to play
    alert sounds when a call arrives in the agent’s session, in the agents’
    web browser that they are logged into the agent screen with. Must be
    enabled in system settings.
  142. Added “3-Way Recording Stop Exception” campaign option to override the
    “3-Way Recording Stop” setting based upon the 3way phone number dialed.
  143. Added the ability to use Automated Reports with standard SFTP and FTPSSL
    remote servers.
  144. Added the ability to configure when the Answer signal is sent to inbound
    calls at the DID, In-Group and Call Menu level. For this to work, you
    must set the conf files to be rebuilt after upgrading your systems.
  145. Added options for HTML formatting and UTF-8 charset in emails through the
    dispo_send_email.php script.
  146. Added tools for International DNC phone number scrubbing. See the
    INTERNATIONAL_DNC_SCRUB.txt doc for more information.
  147. Added option ‘2’ to the User Modify “Modify Leads” setting allowing admin
    users to modify all lead fields except for phone number and alt phone.
  148. Added campaigns_list & hopper_list functions to the Non-Agent API
  149. Added code and instructions for multi-campaign outbound agents, see the
    AGENT_MULTI-CAMPAIGN_DIALING.txt doc
  150. Added Screen Colors option to set the submit button color on the admin
    screens and reports.
  151. Added the ability to modify the status of any call or agent log in the
    Admin Modify Lead page. Must use new ‘Modify Leads’ options to enable
    for a user.
  152. Added system settings allowing you to remove digits from the beginning of
    a phone number when it is manual dialed or through the web lead loader.
  153. Added Pause Max Exceptions campaign setting, allowing for exceptions to the
    Agent Pause Max feature for specified Pause Codes.
  154. Added optional display of parked call stats and SLA 1&2 percentages to the
    Real-Time Report
  155. Added Campaign setting for Hopper Drop-Run triggering. Forcing the one-time
    hopper insertion of DROP status leads instead of standard hopper loading
  156. Added Agent API function ‘vm_message’ allowing you to set the VM message to
    be played to a customer when the agent clicks on the VM button in the
    agent screen.
  157. Added Daily Called Count Limits as a campaign setting, with options to
    count and/or restrict for manual dial calls or not.
  158. Added Transfer-Conf Button Launch campaign setting, allowing you to set a
    webform window to open when an agent clicks on the Transfer-Conf button.
  159. Added SHARED_… campaign dial method auto-dial options, for more efficient
    agent multi-campaign dialing. Read the AGENT_MULTI-CAMPAIGN_DIALING.txt
    document for more information.
  160. Added Agent Search Method override options for campaigns and in-groups.
  161. Added ‘copy_user’ function to the Non-Agent API.
  162. Added ‘add_did’ function to the Non-Agent API.
  163. Added new SOURCESELECT Custom Field Type, it is a single-selection pull-
    down menu where there are multiple sets of options available depending
    on the value of another field for the lead. Also added the ability to
    perform basic Math functions within a SCRIPT Custom Field using values
    from other fields in the equations. For more information on how both of
    these new features work, see the Field Options help in the admin web
    screen.
  164. Added Phone Defaults system setting, allowing you to set many default
    values when adding new phones through admin.php. Also added a Copy New
    Phone admin web function.
  165. Redesign of QC module, with new QC scorecards, the ability to do QC by
    Campaign/List/In-Group, new reporting and more. See the
    docs/QC_PROCCES.txt document for more information.
  166. Added the BUTTON Field Type option to Custom List Fields. Allows you to add
    a button to the form that will commit any changes made in the form and
    automatically reload the form.
  167. Added Two-Factor Authentication(2FA) as an option for the admin web screens
    This adds a required second step to the admin web screen login process
    through a method other than a password, such as: an Email, Phone Call or
    Text-Message(SMS). This 2FA auth also lasts only a set amount of time
    (defined in System Settings[number of hours, from 1-9999 hours]), or
    until the user logs out. For more information, read the
    2FA_TWO_FACTOR_AUTHENTICATION.txt document.
  168. Added a page to allow Editing existing Lead Loader Templates.
  169. Added System Settings for “Agent Hidden Browser Sound” to repeatedly play
    a selected sound at a set interval to an agent when their Agent Screen
    is hidden from view. Can be used to disable web browser javascript
    throttling if set to an audible sound at a 20 second interval. Tested
    with the ‘click_quiet’ sound file at a volume of ’25’.
  170. Added WAV audio file validation for Audio Store, and display of badly
    formatted WAV files in the audio chooser in admin.php
  171. Added “Leave 3-Way Start Recording” campaign feature that will start a new
    recording after the agent clicks on the LEAVE 3WAY button and leaves the
    call. Also includes an “Exception” option to disable/enable only for
    specific 3-way call numbers.
  172. Added “Populate Lead Comments” In-Group option, allowing configuration of
    how the ‘comments’ lead field is filled-in when a new lead is inserted
    because of an inbound phone call.
  173. Added options to add/update/delete custom fields within the ‘update_list’
    function of the Non-Agent API.
  174. Added Settings Compare Utility page to Admin Utilities to allow you to
    compare the settings from two records in your system and see what
    settings are different between the two.
  175. Added campaign options to add extra lead-field columns to the “Calls In
    Queue” panel in the agent screen.
  176. Added Calls In Queue Count Display campaign options, allowing for two
    separate Calls Waiting counters at the top of the agent screen, each
    with separate configurable labels and in-group/campaign parameters.
    Also, this can be used with the alt_display.php script.
  177. Added new “Music on Hold Suggest” Phones setting for SIP and IAX phones.
    It will define the Hold music played to a customer when the phone user
    puts them on hold through the phone.
  178. Added compatibility with TILTX STIR/SHAKEN Call Shaper pre-carrier call
    filtering service. Read the TILTX_SHAKEN_API.txt doc for more info.
  179. Added In-Group Drop Seconds Override Container, allowing for overriding of
    the Drop Seconds setting based upon the day of the week and time of day.
  180. Added Inbound Manual Dial Agent Forced Ready features allowing for forcing
    agents in INBOUND_MAN dial method campaigns to be in the READY state
    (able to take inbound calls) for a set amount of time before they are
    able to click on the DIAL NEXT NUMBER button each time. Also allows for
    an override setting based upon the day of the week and time of day.
  181. Added CORS(Cross-Origin Resource Sharing) support for the VICIdial agent
    PHP scripts and select admin PHP scripts. see the CORS_SUPPORT.txt doc
    for more information.
  182. Added Transfer No Dispo campaign setting, allowing for transferred calls
    to not immediately show the disposition panel on the agent screen.
  183. Added User override setting for campaign Manual Dial Filter option.
  184. Added display of active Call Time Holidays in the agent screen Scheduled
    Callbacks calendar panel.
  185. SECURITY NOTE: For agent screen Webform buttons, we have changed the
    default behavior to not include user credentials in non-custom URL
    strings unless you set the new agc/options.php settings to do so:
    “$user_pass_webform and “$phone_login_webform”
    See the “agc/options-example.php” file for more information.
    *This will not affect custom webform query strings that start with “VAR”
  186. Added display of the Phone Codes and Postal Codes that are loaded into the
    system. Linked from the System Settings page.
  187. Added 24-Hour Called Count Limit campaign feature, allows you to limit the
    number of calls to be placed to a phone number or lead in a 24-hour time
    period. Also allows for state-based override settings. For more
    information, read the CALL_COUNT_LIMITS.txt doc.
  188. Added CID Group Failover setting for campaigns, to allow for backup CID
    Group to use if no AREACODE or STATE match found from first CID Group.
  189. Added agc/dispo_list_quota.php script to deactivate lists once a limit of
    the number of leads matching set statuses is reached. See the comments
    in the code for more details.
  190. Changed agc/dispo_send_email.php to only allow attachments in the new
    “agc/attachments” web directory.
  191. Added Asterisk 16 “PJSIP” compatibility
  192. Added ‘batch_update_lead’ Non-Agent API function
  193. Added ‘Agent In-Call Tally Seconds Threshold’ campaign setting, to better
    handle dialing volume on campaigns with long agent talk time.
  194. Added ‘In-Queue No Agents Check’ in-group setting, to allow for checking of
    logged-in or available agents for the in-group while calls are in-queue,
    and if there are no agents available, sending the customers to the
    No-Agent-No-Queue Action. With configurable pause code exceptions.
  195. Added MIN LENGTH to the Dispo Call URL ALT admin screen, allowing for a
    minimum call time threshold before a Dispo Call URL will trigger.
  196. Added User Location to the Modify User page. Also added Queue Groups Admin
    pages, allowing you to define multiple campaigns and/or in-groups in a
    single Queue Group to be used in some reports.
  197. Added Campaign and List options for “Auto Alt-Number Dialing Threshold”
    allowing you to stop auto-dialing alternate phone numbers for a lead
    after a set number of call attempts, and thereafter only dialing the
    main phone number for the lead.
  198. Added ‘update_alt_url’ Non-Agent API function
  199. Added “Pause Max URL” Campaign feature
  200. Added “Allow Web DB Debug” System Settings feature, to allow use of the $DB
    variable on the web screens for troubleshooting issues.
    It is disabled by default.
  201. Added List CID Group Override to the List Modification admin screen.
  202. Added “Pre-Filter Recent Call” DID feature, to be able to filter out
    inbound calls based on the caller phone number and whether it had been
    called(or had called in) within the last X number of days.
  203. Added the “Inbound DID Detail Report” to the Admin Utilities page.
  204. Added Beta support for ConfBridge Asterisk Conferencing engine. See the
    “/extras/ConfBridge” directory for more information.
  205. Added Beta support for VERM(the VICIdial Enhanced Reporting Module),
    accessible from the “Reports -> Admin Utilities” page.
  206. Added User Group “Script Override” option, with per-campaign activation.
  207. Added “Webphone Settings” option to Phones, allows for more WebRTC config
    options to be set through a Settings Container.
  208. Added “Agent Call Hangup Route” campaign settings, allowing you to send
    calls that an agent is finished with to a Call Menu, In-Group or a
    pre-recorded message before hanging up the call. NOTE: After upgrading your system, be sure to set each dialer to "Rebuild conf files" = 'Y' for this feature to work properly.
  209. Added instructions and scripts for creating a Gateway Recording server
    See the GATEWAY_RECORDING_SERVER.txt doc for more info.
  210. Added the ability to have multiple “No Agent Call URL” entries for a
    single Campaign/In-Group/List, by putting “ALT” in the No Agent Call URL
    field on the Campaign, In-Group, List modify screen. Just like how it
    works with Dispo Call URL currently.
  211. Added new User Group <93>Script Tab Frame Location<94> allowing the script tab
    to extend to the far left side of the screen.
  212. Added new campaign setting <93>Max Logged-In Agents<94>, allowing you to set a
    maximum number of agents that can be logged into this campaign at any
    time.
  213. Added list option for <93>Dial Prefix Override<94>.
  214. Added a <93>color chooser<94> for the In-Group Color and Screen Colors fields.
    Also added color hex code validation to those fields.
  215. Added <93>Invalid Phone Number Replacement<94> option to the Web Lead Loader,
    allowing you to replace an invalid phone_number lead value with either
    the alt_phone or address3 value in the same lead.
  216. Added optional <93>Agent Login Kick-all<94> system setting which hangs up any
    channels that were already in the agent session before the agent is
    placed into the session.
  217. Added <93>User Codes Admin Pulldown<94> allowing only User Level 9 users to
    modify the User Code field on the User Modify page, and it will change
    the User Code field to a pulldown menu.
  218. Added “Show Confetti” campaign setting, allowing for confetti to be shown
    to agents when they disposition a call as a SALE and/or a CALLBACK
    flagged status.
  219. Added “Abandon Check Queue” feature, to catch dropped Call Menu calls that
    are tagged with a Lead ID. For more information, see the bottom of the
    INBOUND_CALLBACK_QUEUE.txt document.
  220. Added “Asterisk Restart URL” to the Modify Servers page, this can send a
    URL request any time Asterisk is auto-restarted on that server.
  221. Added Agent API “send_notification” function, allowing you to send
    notifications to agents by User, User Group or Campaign.
  222. Added “AMD Agent Route Options” flag to allow immediately hangup and dispo
    of calls with no audio data. This is a campaign feature.
  223. Added agent screen latency logging, viewable in the Real-Time Report and
    the new Agent Latency Report and Latency Gaps Report.
  224. Added Demographic Quotas, allowing for setting of quota goals for leads
    based upon lead field values for demographic parameters like: gender,
    age-group, political-party, etc… For more information on this set of
    features, read the DEMOGRAPHIC_QUOTAS.txt document.
  225. Added Inbound Calls Credits, allowing per-User setting of a number of
    inbound calls that can be handled, until reset by a manager.
  226. Added List Weekday Resets, allowing for automatic list resets scheduled by
    day-of-the-week on a per-list basis.
  227. Added Second and Third Agent Alert Trigger In-Group settings, allowing for
    a second and/or third audio alert to be played to the agent on repeat
    calls.
  228. Added VIDPROMPTSPECIAL Call Menu Handle Methods when sending calls to
    In-Groups. Allows for list-based In-Group routing based on settings in
    a Settings Container. Also allows for separate routing of not-found
    leads.
  229. Added Dead Call Stop Recording campaign feature.
  230. Manual VM Message Status Updates campaign option.
  231. Added Per Call Notes Required campaign option.

#### UPGRADING FROM 2.11 TO 2.13

OPTIONAL STEPS(But highly recommended) – Backup existing system:

  1. Run this for a 1-server system or server with database on it:
    (this may take hours on large system)
    /usr/share/astguiclient/ADMIN_backup.pl –debugX
  2. Run this on dialer/Asterisk-only servers:
    (do not run this if you only have one server):
    /usr/share/astguiclient/ADMIN_backup.pl –debugX –without-db –without-web

REQUIRED STEPS!!!

  1. Check system_settings, make sure you are at DB Schema Version 1403 or higher
    If not, run the instructions for 2.9 to 2.11 before this section.
  2. upgrade the MySQL asterisk database(you have two options):
    A. Running the upgrade file directly from Linux:
    mysql -f –database=asterisk < /path/from/root/extras/upgrade_2.12.sql B. Going into mysql and executing the upgrade sql file:
    mysql
    use asterisk
    . /path/from/root/extras/upgrade_2.12.sql
    quit
  3. install new files:
    perl ./install.pl
    NOTES: If you have customized any scripts in the bin or agi folders,
    then make sure you back them up before running the install.pl script.
    This script will replace existing files in the astguiclient installation.
  4. For each of your ViciDial servers, go the Admin -> Servers -> Modify Server
    page and set each one to “Rebuild conf files = Y” and click submit.
    This will rebuild the conf files to ensure any changes are updated.
  5. On one server only, update your phone codes data:
    /usr/share/astguiclient/ADMIN_area_code_populate.pl –purge-table –debug

OTHER CHANGES:

  1. Added System Settings to allow custom prompts on agent login and when an
    agent leaves a 3way call in the agent screen. Must Have Asterisk 1.8+
    for it to work.
  2. Added ability to use single-quotes in vicidial_list fields. Through the
    agent screen and all lead import methods
  3. Added option to populate the entry_list_id from the DID when routing to an
    In-Group
  4. Added agent screen webform 3 feature
  5. Added user API restrictions for allowed lists and allowed API functions
  6. Added web administration for chat features
  7. Added new campaign settings for Manual Dial Search and Manual Dial Filter to
    allow for Alt phone and Address3 phone numbers to be allowed
  8. Added campaign option to disable the Manual Dial Override field
  9. Added option to change the background color for agent scripts
  10. Added option to hide the In-Group ID in the agent screen for inbound calls
  11. Added option to not populate the In-Group Name in the security_phrase field
    (the “Show” field) of the vicidial_list table on new inbound leads.
  12. Added list_description as a webform and script variable
  13. Added campaign option to allow you to set the number of seconds after a
    customer hangs up before the warning shows on the agent screen
  14. Added ability to use No Agent Call URL with the dispo_move_list.php script
    see script comments for instructions.
  15. Added DID options to check for a Maximum number of calls in queue in a set
    In-Group and route the call to an extension if over the set number.
  16. Added the ability to define multiple Dispo Call URLs as well as define
    specific statuses that they will be triggered for.
  17. Added compatibility in the Vicidial code for Asterisk 11.
  18. Added database and logfile logging of DTMF events. Works with Asterisk
    versions 1.8 and higher. If upgrading, you will need to add “dtmf” to
    the listencron user in manager.conf and reload asterisk.
  19. Added agent screen debug logging, which will log almost all mouse clicks
    and AJAX calls on the agent screen. Can be enabled for all agents or
    only one agent. Also added report to display logs by date/time. These
    agent debug logs are deleted after 7 days.
  20. Added agc/dispo_add_FPG.php script to be able to insert a phone number into
    an inbound Filter Phone Group when set to a certain specific disposition
    using the Dispo Call URL.
  21. Added campaign option to display some lead fields as read-only in the agent
    screen. Those fields are: entry_date,source_id,date_of_birth,rank,owner
  22. Added option in the web-based lead loader to convert state names to their
    two-letter abbreviations.
  23. Added option to Secondary Lead Sort by vendor lead code
  24. Added option to User Stats report to only show call logs with a specified
    call status.
  25. Added experimental Agent Whisper Monitoring from the Real-time Report.
    Must be enabled in System Settings.
  26. Added the ability in in-groups to set reset a lead’s called status when a
    call is ended by being abandoned, dropped, hung up or sent to voicemail
  27. Added Admin -> Settings Containers to admin web interface to allow more easy
    configuration of back end scripts and Dispo Email sending
  28. Added agc/dispo_send_email.php script to be used with the Dispo Call URL
    option in campaigns and in-groups. See DISPO_SEND_EMAIL.txt doc for
    more information on this feature.
  29. Added code to support proprietary encryption framework for custom fields.
  30. Added new User Group options for Allowed Reports to control the Report Page
    Servers Summary and the Admin Utilities Page
  31. Added optional GPG audio recording encryption.
  32. Added option to use RECID as a recording filename variable.
    NOTE: Cannot be used as the ONLY variable for recording filename
  33. Added functionality to adjust the input field lengths in the agent screen
    and the admin modify lead pages to follow the database schema field
    lengths for the default lead fields.
  34. Added DID custom fields as webform and script variables
    (did_custom_one, did_custom_two,…, did_custom_five)
  35. Added option to hide users from appearing on real-time report. Must be
    enabled in System Settings, then for each user to be hidden.
  36. Added did_carrier_description, sorting by columns in DID list page, integer
    sort for user list page.
  37. Added logging of DNC list insertion and deletion to vicidial_dnc_log table
  38. Added AST_DB_DNC_filter.pl script to allow filtering of existing DNC entries
  39. Changed AC-CID to be able to use areacodes from 2 to 5 digits in length
  40. Added admin web interface to allow for easy linking and display of custom
    reports that are not included in Vicidial
  41. Added Status Groups and the ability to override Campaign Statuses on a
    per-In-Group or per-List basis
  42. Added Minimum and Maximum Seconds options for all status settings. This
    allows you to prevent the use of a status by an agent if they have
    talked to a customer less than X seconds or more than Y seconds.
  43. Added the system setting USA-Canada Phone Number Dialcode Fix which will
    trigger a process that will run at the Timeclock End of Day that will
    check all phone numbers to populate the dial code, or phone code, field
    with a 1 if it is missing as well as remove a leading 1 from the phone
    number field if it is present.
  44. Added –lstn-buffer option to keepalive script to run special enhanced
    buffer version of the Listen process. Requires newer Net::Telnet perl
    module version.
  45. Added Answering Machine Message Wildcards features for campaigns. Allows for
    calls sent to a message to play a different message depending on whether
    a wildcard text string is present in a selected lead data field.
  46. Added Cached Realtime Carrier Stats option to System Settings to have the
    Carrier Log Stats generated once per minute system-wide instead of every
    time the realtime report refreshes on every screen.
  47. Added option to several reports to search the archived logs.
  48. Added AST_DNCcom_filter.pl script which allows for direct batch filtering of
    lists within vicidial with the DNC.COM dnc filtering service. For more
    info, see the DNC-dot-COM_integration.txt document.
  49. Added phone options to have call go to dialplan extension instead of
    voicemail if phone not answered.
  50. Added option in NVA agi script to search for a lead by phone number, log the
    lead_id of the phone call and send a per-phone URL at the start of the
    phone call.
  51. Added Chat Messaging to agent screen, with manager chat utlitity. For more
    information, read the CHAT_MESSAGING.txt doc.
  52. Added example code for a CRM Iframe agent screen skin(extras/crm_iframe)
    See the CRM_EXAMPLE_SKIN.txt doc for more information
  53. Added utility to gather and display Asterisk debug information. Includes
    a server setting and Admin Utilities report.
  54. Added campaign setting for manual_dial_timeout for manual dial agent screen
    calls only.
  55. Added Agent Allowed Chat Groups to User Groups to allow restriction of only
    agent to agent chatting by itself.
  56. Added options in In-Groups and Campaigns to allow for the agent recordings
    to be initiated by the routing process instead of at the agent screen.
    This only works for inbound and auto-dial outbound calls for in-groups
    and campaigns that are set to ALLCALLS or ALLFORCE recording.
  57. Added option to Inbound DID Group Filtering to filter by areacode.
  58. Added in-group option for On-Hook CID Number.
  59. Added available_agents and status_link button options as well as validation
    of active in-group to the chat_customer screen.
  60. Added campaign setting Manual Dial Hopper Check that will check for a lead
    in the hopper with the same phone number as any manual call being
    placed from the agent screen, and if one exists it will be deleted
    before the manual dial call is placed.
  61. Added recording access logging per user(must be enabled in System Settings)
  62. Added ability to transfer customer chats to another chat group or agent
  63. Added API Log Report to Admin Utilities page
  64. Added Alternate IVR(Call Menu) Logging options
  65. Added option to define a carrier across all active asterisk servers
  66. Added campaign option to move USERONLY scheduled callbacks to ANYONE
    callbacks after X minutes being LIVE without the agent calling them
    back.
  67. Made several changes to the admin web screen and real-time report designs
  68. Added options to define color scheme and logo for admin web screens
  69. Added new options to enable the recent changes to the UK OFCOM Drop Rate
    calculations. There is a new System Setting to enable on the system,
    and then each affected campaign must also have the new option enabled
    for it as well. Affects the predictive algorithm and the Real-time and
    Outbound Calling reports.
  70. Added phone outbound alt caller ID to allow for phone-dialed calls to use
    a separate CID number when dialing through a specific context
  71. Added display of admin change differences to last change on the change
    detail page
  72. Added the ability to copy audio store files with a new name
  73. Started process to redesign the Agent Screen, added Screen Colors
    definitions, removed san-serif fonts, changed loading/login/logout
    screens, logging of browser width/height.
  74. Changed HTML Reports to use dynamic charting Javascript elements
  75. Added campaign option to automatically manual dial next number in agent
    screen after X seconds. Must be enabled in System Settings.
  76. Added recording filename option to update filename post-call with select
    variable values, uses options in AST_CRON_audio_1_move_VDonly.pl script
  77. Added ALT Multi Dispo URL option to restrict URL sending by list ID.
  78. Added Admin Bulk Tools page, linked from Admin Utilities page
  79. Added customer chat options for logo/colors and a survey link after chat is
    completed.
  80. Added the User Group Hourly Report
  81. Added User List NEW Lead Limits, with User overrides. Allows you to set a
    limit on the number of NEW status leads that an agent can call on a per
    list basis per day. Also allows overall NEW limits across all lists for
    a user per day
  82. Added List Merge admin utility
  83. Added Fronter – Closer Detail Report
  84. Added option to allow agents to park 3way calls in the agent screen
  85. Added option to web lead loader to restrict leads to only those with a
    phone number of a specified length. Options for forced system-wide and
    per-list-load
  86. Added more options to the Callback moving utilites in Admin Utilities page
  87. Added Agent Audio Soundboards

#### UPGRADING FROM 2.9 TO 2.11

OPTIONAL STEPS(But highly recommended) – Backup existing system:

  1. Run this for a 1-server system or server with database on it:
    (this may take hours on large system)
    /usr/share/astguiclient/ADMIN_backup.pl –debugX
  2. Run this on dialer/Asterisk-only servers:
    (do not run this if you only have one server):
    /usr/share/astguiclient/ADMIN_backup.pl –debugX –without-db –without-web

REQUIRED STEPS!!!

  1. Check system_settings, make sure you are at DB Schema Version 1378 or higher
    If not, run the instructions for 2.7 to 2.9 before this section.
  2. upgrade the MySQL asterisk database(you have two options):
    A. Running the upgrade file directly from Linux:
    mysql -f –database=asterisk < /path/from/root/extras/upgrade_2.10.sql B. Going into mysql and executing the upgrade sql file:
    mysql
    use asterisk
    . /path/from/root/extras/upgrade_2.10.sql
    quit
  3. install new files:
    perl ./install.pl
    NOTES: If you have customized any scripts in the bin or agi folders,
    then make sure you back them up before running the install.pl script.
    This script will replace existing files in the astguiclient installation.
  4. For each of your ViciDial servers, go the Admin -> Servers -> Modify Server
    page and set each one to “Rebuild conf files = Y” and click submit.
    This will rebuild the conf files to ensure any changes are updated.
  5. On one server only, update your phone codes data:
    /usr/share/astguiclient/ADMIN_area_code_populate.pl –purge-table –debug

OTHER CHANGES:

  1. Added User setting for Wrapup Seconds Override
  2. Added new Agent API function audio_playback to play audio files from the audio
    store in an active agent session. See AGENT_API.txt doc for more info.
  3. Added option to DIDs to allow routing of calls to a redirect extension if
    there are no agents available in a specific in-group
  4. Added option to DIDs to allow pre-filtering by a specific filter phone group
    before the standard filtering process. The call can be redirected to a
    specific DID entry if there is a match.
  5. Added Wrapup Bypass option to allow or disallow agents to skip the wrapup
    screen before the timer is finished. Also added the option to use a
    system Script as the Wrap Up Message
  6. Added $RS_droppedOFtotal options.php option for the realtime report to allow
    the drops to be calculated out of Total calls instead of just Answers
  7. Added ability to use Wrap-Up messages with calls terminated through Hotkeys
  8. Integrated all QC code into standard admin code, removing includes as well
  9. Added System Setting option to use 24-hour time for callback setting in agent
    screen.
  10. Added User Group viewable report entry for Front Page System Summary
  11. Added archive log search and display in modify lead page
  12. Added campaign options to limit number of active callbacks
  13. Changed all Agent and Administrative interface text output to use a function
    instead of echo.(for dynamic other-language interfaces)
  14. Added Admin Utility to split lead lists into smaller lists
  15. Added campaign options to minimize QC audited comments without closing the
    frame, allow for the comments field to appear under all agent screen
    tabs and the dispo screen and the callback date select screen, allow
    for the audited comments to be displayed with managers in red and with
    a date/time stamp. Also, a campaign option to not display the Previous
    Callback panel in the agent screen.
  16. Added campaign option to clear the script after call disposition.
  17. Added administrative web interface for managing Languages. The language
    features are now active in the admin interface as well as in the agent
    screen. Language files are available in the “translations” directory
    in the source code, as well as on this website:
    http://vicidial.org/translations/
  18. Added No Agent URL option override for Lists
  19. Added CPD Unknown Action option to Campaigns
  20. Added new user option to allow administrative users to search for leads
    systemwide even in lists belonging to campaigns that the user’s User
    Group settings don’t allow them to view
  21. Added Local Call Time option for Lists to further restrict call times
    already set in the campaign.
  22. Added Manual Dial Lead Search Filter option to limit the search of manual
    dials to within one campaign’s lists.
  23. Added NAME as an agent screen Status Display variable
  24. The PAUSE and RESUME buttons in the agent screen have been turned into a
    single button named “You are paused” or “You are active” depending on
    your status. Issue #814
  25. Added new LOCK options to Manual Dial Search Checkbox to prevent the agent
    from checking or unchecking the search checkbox.
  26. Added case-sensitive user ID validation on agent login.
  27. Added option in phones and voicemail to display message counts on the
    Admin Summary screen.
  28. Added Callbacks Bulk Move admin utility. Also changed behavior of the
    removal links for callbacks from the callback hold displays for Users,
    User Groups, Lists and Campaigns.
  29. Added DYN filename prefix for non-TTS dynamic files to be used for answering
    machine message. For instance using DYN–A–user–B– for agent 1234
    would look for a file named 1234.wav in your audio store to play.

#### UPGRADING FROM 2.7 TO 2.8 (2.9 release branch)

OPTIONAL STEPS(But highly recommended) – Backup existing system:

  1. Run this for a 1-server system or server with database on it:
    (this may take hours on large system)
    /usr/share/astguiclient/ADMIN_backup.pl –debugX
  2. Run this on dialer/Asterisk-only servers:
    (do not run this if you only have one server):
    /usr/share/astguiclient/ADMIN_backup.pl –debugX –without-db –without-web

REQUIRED STEPS!!!

  1. Check system_settings, make sure you are at DB Schema Version 1347 or higher
    If not, run the instructions for 2.4 to 2.7 before this section.
  2. upgrade the MySQL asterisk database(you have two options):
    A. Running the upgrade file directly from Linux:
    mysql -f –database=asterisk < /path/from/root/extras/upgrade_2.8.sql B. Going into mysql and executing the upgrade sql file:
    mysql
    use asterisk
    . /path/from/root/extras/upgrade_2.8.sql
    quit
  3. install new files:
    perl ./install.pl
    NOTES: If you have customized any scripts in the bin or agi folders,
    then make sure you back them up before running the install.pl script.
    This script will replace existing files in the astguiclient installation.
  4. For each of your ViciDial servers, go the Admin -> Servers -> Modify Server
    page and set each one to “Rebuild conf files = Y” and click submit.
    This will rebuild the conf files to ensure any changes are updated.
  5. On one server only, update your phone codes data:
    /usr/share/astguiclient/ADMIN_area_code_populate.pl –purge-table –debug

OTHER CHANGES:

  1. Added outbound state call time holidays functionality. Only works if the
    “state” field is populated properly in your leads.
  2. Added several security changes to the agent interface, including freezing a
    user’s account for 15 minutes after 10 failed login attempts.
  3. Changing all of the admin scripts from using the PHP ereg functions to preg.
    This is a requirement for moving to PHP6 where ereg functions are
    depricated. This will also have the benefit of speeding up those scripts
    because preg is supposed to be more efficient and faster than ereg.
  4. Added several security changes to the admin interface, including freezing a
    user’s account for 15 minutes after 10 failed login attempts.
  5. Added 4 new reports to the admin interface: url log, lagged log, user group
    login and dial log reports
  6. Added new AST_phone_update.pl –agent-lookup flag to allow for logging of the
    IP address of the agent’s SIP or IAX phone connection. Can be enabled as
    a crontab entry to perform the lookups on each asterisk server.
  7. Added optional encrypted passwords capability within the system. If enabled,
    all user passwords must be converted to encrypted passwords. To use this
    you need to have this CPAN module installed on your web servers: cpan> install Crypt::Eksblowfish::Bcrypt To enable, first go to the Admin -> System Settings page and manually confirm that Password Encryption is DISABLED (fifth item from the top) Then, just run the following CLI script: (run in test mode first!) /usr/share/astguiclient/ADMIN_bcrypt_convert.pl --debugX --test For more information on Encrypted Passwords, read the ENCRYPTED_PASSWORDS.txt document in the docs directory
  8. If you are using the agi-phone_monitor script for agent monitoring, then
    the following dialplan lines need to be added to the same place where
    you put the original dialplan additions necessary for this feature
    to work: (it is shown in context in the 2.6 upgrade instructions below) ; quiet entry, listen-only, exit-on-dtmf conferences for VICIDIAL (listen) exten => _588600XXX,1,Dial(${TRUNKblind}/56${EXTEN:2},55) exten => _588600XXX,n,Hangup() ; barge, exit-on-dtmf conferences for VICIDIAL (barge) exten =&gt; _598600XXX,1,Dial(${TRUNKblind}/57${EXTEN:2},55) exten =&gt; _598600XXX,n,Hangup()</code></pre></li>Added Reset Lead-Called-Status for Campaigns page to Admin Utilities Added System Summary screen as default admin.php screen instead of User List Added new agent_monitor.agi script to replace the agi-phone_monitor script
    for agent monitoring. Please read the AGENT_MONITOR.txt document for
    more information on the dialplan changes necessary to use this script. Added the ability to deduplicate leads based upon statuses in the web based
    lead loader using templates and the basic web lead loader. Added dialplan variable CAMPCUST for manual dial and auto dial outbound
    calls that is set to the campaign_id of the phone call. This allows for
    the ability to put the following in your dialplan for outbound calls
    so that you can send out the campaign_id as a SIP header.
    NOTE: if you want to use this it must be placed immediately below the
    AGI call_log line of the dialplan and before the Dial line:
    exten => _91NXXNXXXXXX,n,SipAddHeader(X-campaignid: ${CAMPCUST}) Changed all PHP code to use PHP mysqli functions. This does not require
    any action or changes to enable since it is a change to the code.
    We are working on converting the administrative PHP scripts as well.
    These require MySQL 5.0 minimum to be used, but for several years that
    has been the minimum for Vicidial anyway, so that requirement shouldn't
    be a problem for existing systems running the newest code. The existing
    older mysql PHP functions are set to be marked as depricated in PHP for
    future versions. For more information on mysqli you can visit the below
    webpages:
    http://news.php.net/php.internals/53799
    http://www.php.net/manual/en/mysqli.overview.php Added AST_CRON_audio_4_ftp2_FTPSSL.pl script to allow for transmission of
    second archival of recordings to an FTP SSL server. Added settings to the agc/options.php file to allow for forced launching of
    the agent screen from a script like the new launch.php script. The agent
    is not allowed to login by going to the vicidial.php page directly, and
    the launch.php page will open the agent screen with a read-only address
    bar and several other browser options disabled. To enable this feature,
    just set the $window_validation variable to '1' in options.php Added phone number type field/list_id updating scripts. Compatible with
    DNC.COM's daily update file services. Read the
    CELLPHONE_USA_TCPA_FCC_COMPLAINCE.txt file for more detailed information
    on this feature. Added lead search of archived leads table if present. Added QueueMetrics 13.04 support with call hold records Added system setting to view country code breakdown in list modify screen. Added campaign option to allow agents to be able to place manual dial calls
    by Lead ID. Added Advanced lead tools management, access from the Admin Utilities page Admin HELP text moved to separate help.php script Added option.php option to allow user ID click to pause code report from the
    Agent Time Detail report Added campaign options to limit time on Dead Calls, Disposition Screen
    and Pause. Added Servers option to have Asterisk automatically restarted if it crashes Added called_count logging to vicidial_log table Added logging of webserver and url used for all API calls, agent logins
    and reports Added Lists Pass Report Added Agent API pause_code function Added VMAIL_NO_INST options to send calls to voicemail with no instructions
    playing after the voicemail greeting. Also phone option has been added
    to allow no instructions to be played on direct extension calls that go
    to voicemail. Added Non-Agent API function update_user to allow updating of the major
    user fields Added Non-Agent API functions for check_phone_number and server_refresh Added Agent API functions for preview_dial_action while previewing or
    manual alt dialing a lead Added Called Counts List IDs Report Added MathZDC function to prevent division math with zero as one of the
    numbers. Added DID Filter options to allow for filtering by the INTERNAL DNC list or
    a Campaign DNC list. Also added a method to allow for URL filtering to
    direct a call to a specific system DID instead of only going to the
    Filter Action. Added Performance Comparison Report Added Max Inbound Calls options to Campaigns and Users to enforce a maximum
    number of inbound calls received per day per agent. Added campaign option to default the search existing leads checkbox on the
    manual dial screen of the agent interface, as well as reset it after
    every call Added campaign option to hide call log and call count data on the agent
    screen when viewing lead information Added User permission option for editing Custom Dialplan Entries Added logging of pause type(ADMIN, AGENT, SYSTEM, API,…) Added frozen call clearing system setting, used in admin.php(Reports page)
    and optional AST_timecheck.pl script Added campaign options to auto-select the ALT DIAL checkbox, and to
    automatically dial the Alt Phone or Address3 field after a set number
    of seconds Overhauled Spanish Agent and Admin translations and Dutch agent translation
    Added Dutch button images to Dutch translation

#### UPGRADING FROM 2.4 TO 2.6 (2.7 release branch)

OPTIONAL STEPS(But highly recommended) – Backup existing system:

  1. Run this for a 1-server system or server with database on it:
    (this may take hours on large system)
    /usr/share/astguiclient/ADMIN_backup.pl –debugX
  2. Run this on dialer/Asterisk-only servers:
    (do not run this if you only have one server):
    /usr/share/astguiclient/ADMIN_backup.pl –debugX –without-db –without-web

REQUIRED STEPS!!!

  1. Check system_settings, make sure you are at DB Schema Version 1316 or higher
    If not, run the instructions for 2.2.0 to 2.4 before this section.
  2. upgrade the MySQL asterisk database(you have two options):
    A. Running the upgrade file directly from Linux:
    mysql -f –database=asterisk < /path/from/root/extras/upgrade_2.6.sql B. Going into mysql and executing the upgrade sql file:
    mysql
    use asterisk
    . /path/from/root/extras/upgrade_2.6.sql
    quit
  3. install new files:
    perl ./install.pl
    NOTES: If you have customized any scripts in the bin or agi folders,
    then make sure you back them up before running the install.pl script.
    This script will replace existing files in the astguiclient installation.
  4. For each of your ViciDial servers, go the Admin -> Servers -> Modify Server
    page and set each one to “Rebuild conf files = Y” and click submit.
    This will rebuild the conf files to ensure any changes are updated.
  5. On one server only, update your phone codes data:
    /usr/share/astguiclient/ADMIN_area_code_populate.pl –purge-table –debug

OTHER CHANGES:

  1. Added the ability for an agent to place manual dial calls out as if they were
    in-group inbound calls. Also allows for no-dial calls that are not
    actually placed out the telco, but are logged as calls. For more
    information see the “In-Group Manual Dial” options in Campaign Detail
  2. Added Dial In-Group CallerID override to In-Groups Modify screen, allowing
    for the callerid to automatically be set per in-group on agent manual
    dial in-group calls
  3. Added transfer call to answering machine message with hotkey option,
    currently hard-coded to these two statuses: (LTMG or XFTAMM)
  4. Added User Group Login Report
  5. Added Safe Harbor Audio Field to campaign options which allows for a lead
    field to be used as an override safe harbor audio on a per-lead basis
  6. Added Japanese agent web interface translation
  7. Added ability to qualify callers before they go through a Call Menu by using
    a SQL fragment(like in Filters) that you define in a Call Menu. Must be
    enabled in System Settings. Calls must be passed from an outbound
    campaign or an in-group.
  8. Added ability to download the Max System Stats and display by date range.
  9. Added ‘recording’ and ‘webserver’ functions to the agent API
  10. Added add_group_alias non-agent API function
  11. Added System Settings option to disable list counts in admin web screens
  12. Added callback user transfer page, linked from Admin Utilities in Reports
  13. Added non-loading webphone options and API agent call and webphone url
    functions
  14. Added outbound call logging in vicidial_dial_log table
  15. Added user_group_status and in_group_status functions to the non-agent API.
  16. Added update_log_entry function to the non-agent API, which allows the
    updating of the status of an inbound or outbound call log entry.
  17. Added ability to set an audio store file for the voicemail greeting message
  18. Added ability to delete audio files from the audio store
  19. Added logging of svn version info in the database at server install/update
  20. Added more validation of agent sessions to prevent double-logins
  21. Added campaign option to show a “Pause After Next Call” link to the agent
    screen below the Pause/Resume buttons
  22. Added campaign option to set owner field to user if the owner field is empty
  23. Added Lead Tools web page from Admin Utilities. Allows for some basic lead
    management through the web interface.
  24. Added recording filename variable INGROUP for the In-Group ID of a call
  25. Added QC functionality contributed by PoundTeam and Affinity On-Call.
    To enable, go to Admin -> System Settings and set “QC Features Active”
    to “1”, then submit.
  26. Added QM Socket-Send functionality for custom queue_log record sending.
  27. Added inbound call time holiday functions.
  28. Added list expiration date feature
  29. Added Other Campaign DNC List campaign option
  30. Added Enhanced Disconnect logging for outside the USA, disabled by default
  31. Added a campaign feature to allow an agent to search for a lead while on an
    inbound call and have their active lead change to a search result lead
    that they select.
  32. Added inbound email to queue to agent features. To enable, you must add an
    “E” keepalive to ONLY ONE of your servers. You will also need to enable
    email in System Settings. You also need the following perl cpan modules
    installed:
    install LWP::UserAgent
    install HTML::Entities
    install HTML::Strip
    install HTML::FormatText
    install HTML::TreeBuilder
    install Switch
    install Time::Local
    install MIME::Decoder
    install Mail::POP3Client
    install Mail::IMAPClient
    install Mail::Message
    install IO::Socket::SSL
    install MIME::Base64
    install MIME::QuotedPrint
    Also, the inbound email parser must be added to the crontab of ONLY ONE
    server:
    ### inbound email parser
    * * * * * /usr/share/astguiclient/AST_inbound_email_parser.pl
  33. Added Asterisk 1.8 support. This is in the BETA testing phase currently,
    and is not recommended for use in production at this time. If you are
    upgrading an existing system, please make note of the many conf file
    changes(extensions.conf and manager.conf) that will need to be made for
    Vicidial to function properly while interfacing with Asterisk 1.8. Also,
    make sure that the Admin -> Servers -> modify server “Asterisk Version”
    setting is set properly for the version you have installed on that
    server.
  34. Added campaign options to send answering machine detected calls to a
    Call Menu or In-Group.
  35. Added System Settings option to disable Add/Copy admin functions for level
    8 users.
  36. Added ability to use .agi scripts in Call Menu prompt. Also added
    cm_date.agi script to say date with options
  37. Converted ereg to preg in the agc agent interface PHP scripts
  38. Added agi-phone_monitor.agi script to allow monitoring of agents using only
    their user IDs or phone extensions and no web browser needed.
    You can add as an AGI to a Call Menu, or just an extension transfer:
    call menu AGI with options:
  39. [up_monitor]
    agi-phone_monitor.agi,USER—N—LISTEN
    or as extension transfer to “up_monitor_exit” context and “s” extension settings for this script: 1. USER or PHONE, lookup by user id or phone extension (default is USER) 2. Y or N, log in api log (default is N) 3. BARGE or LISTEN, (default is LISTEN) For this to work you need to add these lines to your extensions.conf: (which can be added to the "System Settings -> Custom Dialplan" instead) ; quiet entry, listen-only, exit-on-dtmf conferences for VICIDIAL (listen) exten =&gt; _568600XXX,1,Set(MEETME_EXIT_CONTEXT=up_monitor_exit) exten =&gt; _568600XXX,n,Meetme(${EXTEN:2},mqX) exten =&gt; _568600XXX,n,Hangup() ; barge, exit-on-dtmf conferences for VICIDIAL (barge) exten =&gt; _578600XXX,1,Set(MEETME_EXIT_CONTEXT=up_monitor_exit) exten =&gt; _578600XXX,n,Meetme(${EXTEN:2},X) exten =&gt; _578600XXX,n,Hangup() ; quiet entry, listen-only, exit-on-dtmf conferences for VICIDIAL (listen) exten =&gt; _588600XXX,1,Dial(${TRUNKblind}/56${EXTEN:2},55) exten =&gt; _588600XXX,n,Hangup() ; barge, exit-on-dtmf conferences for VICIDIAL (barge) exten =&gt; _598600XXX,1,Dial(${TRUNKblind}/57${EXTEN:2},55) exten =&gt; _598600XXX,n,Hangup()
  40. {up_monitor_exit}

exten =&gt; h,1,AGI(agi://127.0.0.1:4577/call_log–HVcauses–PRI—–NODEBUG—–${HANGUPCAUSE}—–${DIALSTATUS}—–${DIALEDTIME}—–${ANSWEREDTIME}) exten =&gt; _X.,1,Set(MEETME_EXIT_CONTEXT=up_monitor_exit) exten =&gt; _X.,n,AGI(agi-phone_monitor.agi,USER—N—LISTEN—${EXTEN}) exten =&gt; _X.,n,Hangup() exten =&gt; s,1,Set(MEETME_EXIT_CONTEXT=up_monitor_exit) exten =&gt; s,n,AGI(agi-phone_monitor.agi,USER—N—LISTEN) exten =&gt; s,n,Hangup() exten =&gt; i,1,Goto(up_monitor_exit,s,1) exten =&gt; i,n,Hangup() exten =&gt; #,1,Goto(up_monitor_exit,s,1) exten =&gt; #,n,Hangup() exten =&gt; t,1,Goto(up_monitor_exit,s,1) exten =&gt; t,n,Hangup()

exten =&gt; h,1,AGI(agi://127.0.0.1:4577/call_log–HVcauses–PRI—–NODEBUG—–${HANGUPCAUSE}—–${DIALSTATUS}—–${DIALEDTIME}—–${ANSWEREDTIME}) exten =&gt; _X,1,Goto(up_monitor,s,1) exten =&gt; _X,n,Hangup() exten =&gt; i,1,Goto(up_monitor,s,1) exten =&gt; i,n,Hangup() exten =&gt; #,1,Goto(up_monitor,s,1) exten =&gt; #,n,Hangup() exten =&gt; t,1,Goto(up_monitor,s,1) exten =&gt; t,n,Hangup()</code></pre></li>

Added user_group as a script, form, webform, start_call_url and
dispo_call_url variable.

Added agent_status function to the non-agent API

Added method for logging SIP error codes, also display of those codes in the
agent screen. The logging goes to the vicidial_carrier_log and
vicidial_dial_log tables and includes both the SIP code and the reason
(i.e. 503 “Service Unavailable”). To get this to work, you need to patch
Asterisk with the extras/sipcausecodelog_1.4.39.1.patch file for
Asterisk 1.4, and for Asterisk 1.8 the patch is pending.

cd /usr/src/asterisk/asterisk-1.4.39.1-vici
patch -p1 < ./sipcausecodelog_1.4.39.1.patch
   (file to patch: channels/chan_sip.c)
make clean
./configure
make
make install
   (then stop and restart asterisk)

Added admin report logging to all reports on the system, and added the
“Admin Report Log Viewer” linked from the “Admin Utilities” page which
allows you to see the reports that have been run on the system.

Added option to the AST_DB_dead_cb_purge.pl script to remove duplicate
callback entries for a single lead, keeping the newest one only.

Added NANPA areacode and prefix phone number validation and timezone setting
options to the admin web lead loader, the Non-Agent API and the CLI lead
loader. The NANPA prefix list will give you more accurate time zone
encoding of your USA and Canadian lead files within ViciDial. The NANPA
list is available for purchase at the vicidial.org web store:
http://www.vicidial.org/store.php#NANPA

Added a NOINT flag option to the Call Menu Prompt so the playback cannot be
interrupted with a key press by the caller, the NOINT should be put
directly in front of the prompt filename, but should not be a part of
the filename, it is a special flag for the system.

Added Survey No Response DROP option to send no-response calls to the
campaign drop method and added Survey Wait Seconds to allow you to set
the amount of time the person called will have to respond after the
survey message is played.

Added AST_timecheck.pl script to check for Asterisk update sync issues. Also
added red indicator on Reports page servers table if server falls out of
sync.

Updated and cleaned up other language builds for agent and admin.

#### UPGRADING FROM 2.2.0 TO 2.4

OPTIONAL STEPS(But highly recommended) – Backup existing system:

  1. Run this for a 1-server system or server with database on it:
    (this may take hours on large system)
    /usr/share/astguiclient/ADMIN_backup.pl –debugX
  2. Run this on dialer/Asterisk-only servers:
    (do not run this if you only have one server):
    /usr/share/astguiclient/ADMIN_backup.pl –debugX –without-db –without-web

REQUIRED STEPS!!!

  1. upgrade the MySQL asterisk database(you have two options):
    A. Running the upgrade file directly from Linux:
    mysql -f –database=asterisk < /path/from/root/extras/upgrade_2.4.sql B. Going into mysql and executing the upgrade sql file:
    mysql
    use asterisk
    . /path/from/root/extras/upgrade_2.4.sql
    quit
  2. install new files:
    perl ./install.pl
    NOTES: If you have customized any scripts in the bin or agi folders,
    then make sure you back them up before running the install.pl script.
    This script will replace existing files in the astguiclient installation.
  3. For each of your ViciDial servers, go the Admin -> Servers -> Modify Server
    page and set each one to “Rebuild conf files = Y” and click submit.
    This will rebuild the conf files to ensure any changes are updated.
  4. On one server only, update your phone codes data:
    /usr/share/astguiclient/ADMIN_area_code_populate.pl –purge-table –debug

OTHER CHANGES:

  1. Changed “After hours”, “No agent no queue” and “drop timeout reached” DROPs
    to use AFTHRS/NANQUE/TIMEOT statuses respectively
  2. Added an option to record calls that enter through a DID until they end or
    enter an in-group queue. MUST ENABLE –MIX CRONTAB ENTRY!!!
  3. Added ability to have AGENTDIRECT calls that drop go to user’s defined
    voicemail box
  4. Added ability to use a webphone added in an IFRAME in the agent screen.
    Tested with Zoiper webphone and sample code included
  5. Added vdc_script_notes.php for call notes and appointment taking, read
    comments for more information.
  6. Added Call Log View options to the Agent screen, can be enabled in the
    User Group screen or the User screen in Administration
  7. Added custom dialplan entries fields for System Settings and Servers
  8. Added ability to use security_phrase field in the vicidial_list table as a
    Custom CallerID, must enable in Campaign settings
  9. Changed voicemail auto-config to use voicemail.conf directly because include
    files are not fully supported in voicemail.conf. If you have any custom
    voicemail boxes that are NOT defined in ViciDial then you need to put
    them in a custom context above the [default] context in voicemail.conf
    in order to keep them. This change will update the ViciDial database if
    the user changes their voicemail password through their phone. If that
    user also uses that phone entry to login to vicidial.php that password
    will be changed as well
  10. Changed AGENTDIRECT selection to be triggered by clicking on AGENTS link
    instead of number-to-dial field
  11. Reformatted lead search page and added first and last name search options
  12. Added 3-WAY status to the Real-time report to show when agents are in
    consultative transfer sessions
  13. Added AGENTONLY Scheduled Callbacks display options to allow the Callbacks
    link line in the agent interface to show as red and/or blink. Also,
    added option to have callbacks count display only triggered callbacks
  14. Added carrier log display option to Real-time report to show the hangup
    causes for the last 24/6/1 hours and 15/5/1 minutes of outbound calls
  15. Added agc/deactivate_lead.php script that can change the status of a lead in
    another campaign with the same vendor_lead_code, source_id or other
    field match. See the file comments for more information
  16. Added options.php for vicidial.php to give you the ability to change the
    interface options in a separate file so that they can be preserved
    through an upgrade. See options-example.php for more information
  17. Added CallCard featureset to allow for pin-number entry before entering an
    In-Group by a customer with minute balances and a basic admin interface.
    See the CALLCARD.txt doc for more information.
  18. Added display options for agent screen Transfer-conf buttons in the User
    Group modification screen.
  19. Added ra_call_control function to agent API to allow for hangup and transfer
    of calls sent to a Remote Agent also allows for setting of a disposition
    for more information read the AGENT_API.txt doc.
  20. Added Extension Groups feature to Remote Agents section allowing calls to be
    sent to different numbers in a round-robin method when enabled on
    multi-line remote agent accounts. To enable, you must create Extension
    Group entries and enable Extension Group in the Remote Agent entry.
  21. Added agi-AGENT_route.agi script to more easily allow for agentdirect calls
    from call menus without having to create a DID entry for every agent.
    Simply put this line in the custom dialplan section of the call menu
    that you want to allow agentdirect dialing for:
    “exten => _XXXX,1,AGI(agi-AGENT_route.agi,default—AGENTDIRECT)”
    That example will only work for agents that have 4-digit IDs.
    This works well even after hours and when the agent is not available
    because you can set the call to go to a voicemail box in the selected
    in-group by using AGENTVMAIL in the voicemail field of the in-group.
  22. Add the following lines to the extensions.conf to fix bug with manual dial
    leave answering machine message(put in the default context):
    exten => _8320.,1,AGI(VD_amd.agi,${EXTEN}—–YES) exten => _8320.,2,Hangup
  23. Added ability to search logs from admin search lead page
  24. Added more login information to the User Stats page including session,
    server, phone and computer IP
  25. Added Manual Dial override option to campaigns to allow overriding of
    user options for manual dial permissions
  26. Added campaign option for alerting the agent when they are being blind
    monitored. Options include an alert, a notice and an audio alert
  27. Added inbound custom call ID display and logging feature, also added
    vicidial_log_extended which stores more useful call log info
  28. Added optional phone codecs definitions as well as system-wide defaults
    for codec definition. Default for both is blank which will keep
    whatever is set at the top of the iax.conf or sip.conf files
  29. Added option to allow user information to be blocked form the real-time
    report by user login(the user viewing the report)
  30. Added Hold Time Option Minimum option to in-groups which will prevent the
    hold time option from running until a minimum number of hold seconds.
  31. Added headers to the list export and calls export reports
  32. Added several PRESS-1 options to the Hold Time Option settings for In-Groups
  33. Added Call Time after-hours filename override option used by inbound groups
  34. Added Campaign setting for inbound queue no dial that will prohibit outbound
    auto-dialing if there are any allowed in-group calls in queue if enabled
  35. Added In-group options for setting the length of the on hold message and the
    hold time option press message as well as offering the option to have
    those two prompts be non-blocking and allow existing newer calls through
    to agents while the prompts are playing
  36. Added utility in CallCard section to generate new card IDs and view by Run.
  37. Added Agent API functions for Send DTMF, Park Customer and the Transfer
    Conference functions as well
  38. Added prompt options for in-group VIDPROMPT methods when initiated from Call
    Menus
  39. Added web-configurable TTS voice option. Please make sure the Cepstral voice
    is installed before entering one.
  40. Added function for start_call_url to work with remote agents
  41. Added custom default field names for fields in the agent interface. Defined
    in the Admin System Settings
  42. Added new code to help deal with agents on poor network connections. New
    vicidial.php option is $conf_check_attempts
  43. Added Custom List Fields functions to the Admin and Agent web interfaces.
    To activate you need to enable custom fields in system settings, then
    you can go to the Lists section to add custom fields to a list. The
    fields are tied to a list, not a campaign, and they can be displayed
    in a new tab in the agent interface, and there is a new option to have
    the Get Call Launch open this custom fields tab upon a call being sent
    to the agent. Also, the Calls Export Report and the List Download
    feature include the custom fields values for the leads exported. You
    can import custom field data through the web-based lead loader in TXT
    and CSV format(you must set a list ID override and you must select
    Custom Format). You can also use the non-agent API add_lead function,
    (see the NON-AGENT_API.txt doc for more info). You can also use the
    third gen lead loader to import leads with custom files in several
    other formats.
  44. Added more options to agi-AGENT_route.agi to allow it to prompt for user IDs
    as well as set the number of digits to collect and check whether a user
    is logged into ViciDial. The script can also now be run as an AGI route
    option in CallMenus as well as in the custom dialplan.
    Look at the comments in the code for more info.
  45. Added third generation web-based lead loader capable of loading more data
    file types and optionally loading all of them with custom list fields.
    You must install the following perl modules on your web server for this
    new lead loader to work:
    cpan> install Spreadsheet::XLSX
    cpan> install Spreadsheet::Read
    To get to the new lead loader, click to:
    Lists -> Load New Leads
    Here is a list of the file formats(by file extension) that are now
    supported by the third generation web lead loader:
    TXT – tab or pipe delimited
    CSV – comma separated values
    XLS – MS Excel 2000/XP
    XLSX – MS Excel 2007+
    SXC – OpenOffice.org First Generation Spreadsheet
    ODS – OpenOffice.org OpenDocument Spreadsheet
  46. Added the ability to run selected reports from a MySQL slave server. This is
    definable in the System Settings in the admin.php interface. You must
    already have MySQL Master/Slave replication set up for this to work.
  47. Added options to include recording ID, Filename and/or Location with Call
    Export Report results
  48. Added Non-Agent API function for updating leads: update_lead
    Allows for searching by lead_id, vendor_lead_code and phone_number
    as well as the ability to insert a new lead if no results found.
    Works with custom fields as well.
    For more information, look in the docs/NON-AGENT_API.txt doc
  49. Added Wait Time options to in-groups. This is different from the Estimated
    Hold Time options because this is based only on the customer wait time.
    Also, second and third options were added for both allow the offering of
    a press 1, 2 and 3 option in the wait/hold time option features.
  50. Added timer action methods HANGUP, EXTENSION, CALLMENU and IN_GROUP. These
    allow you to hangup or transfer the call at a set number of seconds
    from start time or triggered from an outside process.
  51. Added Allowable Reports option in User Groups for user_level 7 and higher
    users to restrict viewable reports. Also enforced the Allowed
    Campaigns option in User Group across admin.php and reports
  52. Changed the “Admin” link in admin.php to go to a links page instead of a
    listing of Phones, also forced level 7 users to the reports links page
    if they try going anywhere in admin.php
  53. Renamed “In-Groups” header in admin.php to “Inbound” to reflect that it is
    not just for In-groups, but includes DIDs and Call Menus as well
  54. Added Filter Phone Groups to allow calls coming into DIDs to be filtered
    and sent to a different route if the caller ID number matches one in
    the selected Filter Phone Group, or the search can be done by a web GET
    to a URL that you define.
  55. Added method to clean caller ID number when calls come into DIDs, either by
    stripping specific digits from the front of a number if they are there
    or taking only the right X numbers, i.e. R10 will take only the 10
    digits on the right of a number, and L1 will remove only a 1 from the
    left side of the number.
  56. Added ability to download DNC numbers from the internal and campaign-
    specific DNC lists, as well as the Filter Phone Groups
  57. Added validation for Remote Agents to ensure that the User Start is a valid
    User in the system, also added validation that Remote Agents do not
    overlap their number of lines into another Remote Agent
  58. Added ability to override the System Settings webphone URL per User Group
  59. Added Calculate Estimated Hold Seconds setting which can delay the
    Calculation and optionally the announcement of Estimated Hold Time
    for X seconds.
  60. Added new beta script for faster checking of leave-3way conferences,
    AST_conf_update_3way.pl, read the comments before using.
  61. Added Transfer Presets to Campaigns allowing for unlimited dial presets for
    agents to use in the transfer-conf frame of the agent interface. Also,
    real-time and outbound report reporting have been added to show call
    counts for these presets. Presets can optionally have their numbers
    hidden from agents allowing agents only to select a preset name to
    transfer or conference a call to. You must Enable Transfer Presets in a
    campaign before you can define them in the Presets sub-menu.
  62. Added ability to hide the “Number to dial” field in the Transfer-conf frame
    of the agent interface. This is a Campaign-level setting.
  63. Added Manual Dial Prefix to allow for a different dial path for manual dial
    calls placed through the agent interface.
  64. Added did_id, did_extension, did_pattern, did_description, closecallid,
    xfercallid and agent_log_id as webform and script variables in the agent
    screen.
  65. Added webphone options for System Key and Dialpad, may not be compatible
    with all webphones.
  66. Allow the changing of the queue priority of an inbound call while the call
    is in queue.
  67. Changed the example iax.conf and sip.conf to default to context=trunkinbound
    to prevent unauthenticated calls on insecure phone accounts
  68. Added password strength grading for users, phones and servers. Added ability
    to force a user password change on the next admin login. Added password
    default settings to System Settings and added a first login setup screen
  69. Changed application limit for lead_id from 9 digits to 10 digits. This does
    not affect the database limit of lead_id: 4294967295
  70. Added customer 3way hangup logging options to campaigns which will log if
    and how far into the 3-way call a customer has hung-up, as well as if
    the agent initiated the call after the customer hung up. There is also
    an option to end the 3-way call and send the agent to the disposition
    screen if the customer hangs up during the 3-way call.
  71. Added ability to view Inbound Report by selected DIDs instead of by
    in-groups. Link added to Reports page.
  72. Added dispo_move_list.php script which can be used in the Dispo Call URL
    option for a campaign or in-group. This script can be used to move a
    lead into a different list_id after the agent disposition depending on
    the disposition that is selected. Optionally, the lead can also be reset
    so that it can be dialed back immediately. See the code comments for
    more information.
  73. Added the Lists Campaign Statuses Report which is a list inventory report,
    not a calling report. This report will show statistics for all of the
    lists in the selected campaigns.
  74. Added ability to use Custom List Fields in Web Forms, Scripts and Dispo
    Call URL entries used by the agent interface.
  75. Added “Add Lead URL” feature to in-groups. Works like Dispo Call URL except
    it will send a web get out as soon as a lead is created by the inbound
    process. There is a more limited set of variables available for use with
    this option, see the admin.php help for more details
  76. Changed the PARK CUSTOMER option in campaigns to use a Music-on-Hold context
    instead of a difficult-to-configure filename and extension as before
  77. Added new IVR PARK CUSTOMER feature to campaigns allowing an agent to park
    a customer to an AGI script as an IVR and have the customer enter in
    digits unassisted and then be redirected back to the agent who parked
    them when they are finished. Optional in-group redirect if customer
    does not enter valid input. See example park_call_IVR_example.agi script
  78. Added In-Group options for Estimated Hold Time Minimum, which can replace
    the “15 seconds” minimum accouncement with an announcement of your
    choosing
  79. Added a campaign option for Manual Preview Dial, to enable or disable that
    manual dial option, as well as allowing or disallowing for the SKIP
    lead option.
  80. Added two new recording filename variable options: VENDORLEADCODE, LEADID
  81. Added the ViciDial Web Dial Firefox web browser plugin, that allows right-
    click selection dialing of phone numbers on web pages to a logged-in
    ViciDial Agent session. See “extras/firefox_plugin” for more info.
  82. Added ability to change users’ in-group settings from the in-group
    modification screen in bulk.
  83. Added Agent Average time stats option to the real-time screen. Must enable
    realtime_agent_time_stats option in campaign screen.
  84. Added customer park time counter to the agent screen when customer is on
    park. Also, added logging of parked calls to park_log table
  85. Added ADDMEMBER queue_log logging option to System Settings, and added
    CALLERONHOLD entries to queue_log when customer is on park.
  86. Added admin no-cache and auto-refresh of modify screens to admin interface.
    These are configurable in the System Settings
  87. Added option for cross-server phone dialplan extensions in System Settings.
  88. Added campaign feature to automatically adjust the hopper level to the
    dialing rate and the number of active agents, also added a trim feature
    to make sure the hopper is not filled too much
  89. Added the ability to filter manual dial calls to adhere to the call time
    scheme selected for the campaign. Does not work with State Call Times.
    Must be enabled in the Campaign Detail settings.
  90. Added the ability to queue multiple manual dial calls for a specific logged-
    in agent using the Agent API. Feature must be enabled in the Campaign
    Detail settings.
  91. Added ability to modify scheduled callback dates and comments in the Admin
    Modify Lead screen.
  92. Added List override options for webform fields
  93. Added script to purge all vicidial_callbacks records that are inactive or
    are tied to deleted leads, AST_DB_dead_cb_purge.pl
    add to the crontab like this:
    # cleanup of the scheduled callback records
    25 0 * * * /usr/share/astguiclient/AST_DB_dead_cb_purge.pl –purge-non-cb -q
  94. Added did_log_export and recording_lookup functions to the non-agent API
  95. Added option to display statuses within the active lists of a campaign in
    the campaign modification screen. Also includes called and not called
    counts.
  96. Added rewritten AJAX/Javascript driven real-time report, able to support
    webphones.
  97. Added the ability to hide fields in the agent interface by entering
    —HIDE— into the System Settings label option for the field
  98. Added preprocess leads in script to filter leads and generate standard
    format lead files before being imported
  99. Added the ability to have call times go beyond midnight for inbound calls.
  100. Added capability for agent interface to have webphone as a thin top bar
  101. Added hopper loader randomization option in Campaign Detail screen, which
    allows for the results to be randomized inside of the sorted results as
    sorted by the List Order option
  102. Added add_user and add_phone non-agent API functions
  103. Changed vicidial.php HTML formatting to be XHTML compliant
  104. Added vdc_script_dispo_example.php script which can be customized to
    require specific fields be filled in before submitting, as well as
    limiting this restriction to only specific dispositions. You can also
    specify dispositions to be selectable that are set to non-selectable.
    You use this script in an IFRAME for the campaign. It must be
    customized for your specific business rules.
  105. Added the ability to use custom statuses for scheduled callbacks. These
    are configurable with the Scheduled Callbacks flag in the System
    Statuses and Campaign Statuses administrative screens.
  106. Added Secondary List Order which allows for further sorting of leads to be
    dialed by a secondary sorting method
  107. Added Default Campaign setting for the My Callback agent interface option
    so that the checkbox can be pre-selected or not on every call
  108. Added the campaign option for per-call call notes in the agent interface.
    If the User Group also has Call Log enabled, the agent can also see
    the call notes from previous calls.
  109. Added the add-a-new-lead link to the admin interface
  110. Added ability for an agent to search for a lead in the agent interface
    while paused. This feature can be enabled per campaign and per user.
    Searches can optionally be restricted to campaign lists or only one
    list. All search queries are logged.
  111. Added options to restrict agent lead search to the owner field equal to
    the user, user group or selected territories for the agent.
  112. Added option for phone load balanced logins server twin checking on
    systems that have servers installed in pairs
  113. Changed scheduled callbacks display in the agent interface to show all
    callback and lead information, including call history and call notes,
    without having to dial the lead.
  114. Added on-hook agent phone feature. This feature allows inbound calls from
    customers to ring on an on-hook agent phone, but not be transferred to
    that agent until the agent’s phone is answered. If the call times out
    then the call will go on to the next agent. This is defined in the
    Phones record and allows the agent using the vicidial.php agent screen
    to not have to stay on the phone at all times when they are logged in.
    You will need to add the following lines to the default context in your
    extensions.conf file:
    ; these are used for the ring_all function in VICIDIAL
    exten => _8331.,1,Playback(sip-silence) exten => _8331.,n,AGI(agi-VDAD_RINGALL.agi,${EXTEN})
    exten => _8331.,n,AGI(agi-VDAD_RINGALL.agi,${EXTEN}) exten => _8331.,n,AGI(agi-VDAD_RINGALL.agi,${EXTEN})
    exten => _8331*.,n,Hangup
  115. Added ring_all Next Agent Call option for in-groups. This works with on-
    hook agent phones to allow all available agents to have their phones
    ring at the same time, with the first agent to pick up their phone
    receiving the call. It is not recommended to use this on high-volume
    systems or systems with many agents available.
  116. Added DEFER options to the Scheduled Callbacks Alert campaign feature.
    These allow you to stop the blinking of the alert in the agent screen
    after you have viewed the callbacks, but if the number of callbacks
    changes the red and/or blink will start again.
  117. Added add_list and update_list functions to the Non-Agent API, allowing
    you to add, modify and delete lists, as well as reset leads in a list,
    change a list to active or inactive, change the campaign of a list and
    delete the leads inside of a list.
  118. Added Campaign option to auto-pause agents when they go into several
    pre-call functions like Manual Dial, Lead Search, Callbacks Check, etc.
    Also added an option to auto-resume the agent when leaving those
    funtions.
  119. Changed almost all of the browser alerts to HTML alerts. These are the
    messages that tell you for example that you cannot do this when paused.
    The reason for the change is that browser alerts are blocking and will
    halt executiong of javascript on the agent workstation. This change
    should require no alterations to any configurations.
  120. Added recording of Remote Agents calls per recording settings in campaigns.
    If recording is set to ALLCALLS or ALLFORCE then a recording will be
    initiated for the call upon routing to the Remote Agent and will be tied
    to the R/ user and the lead_id. Also works with on-hook enabled. User-
    level recording settings for the start user of the remote agent will
    also be followed.
  121. Added MULTI_LEAD option for Auto-Alt-Dialing. Using MULTI_LEAD allows you
    to use a separate lead for each number on a customer account that all
    share a common vendor_lead_code, and the type of phone number for each
    is defined with a label in the Owner field. This option will disable
    some options on the Modify Campaign screen and show a link to the
    Multi-Alt Settings page which allows you to set which phone number types
    , defined by the label of each lead, will be dialed and in what order.
    This will create a special lead filter and will alter the Rank field of
    all of the leads inside the lists set to this campaign in order to call
    them in the order you have specified.
  122. Added option to use the owner field to define a time zone abbreviation code
    Works across web/api/cli lead loading methods. There is also an option
    in the time zone updating script to use this method.
  123. Added ability to use external_dial Agent API function with a defined
    lead_id and optional alt_dial setting
  124. Added feature to give an alert on manual dial campaigns if the phone number
    area code and the postal code are in different time zones, or if either
    of them are outside of the local call time for the campaign. Viewable in
    preview mode as well as lead info viewing from the callbacks list, the
    call log and search results in the agent interface.
  125. Added utility to synchronize users, remote agents, dids, call menus,
    in-groups and campaigns with entries in QM: ADMIN_qm_sync.pl
  126. Added Custom 3-Way Button Transfer feature which allows for 3-way calls to
    be placed using one of several lead fields or campaign presets, as well
    as the customer optionally being put on park, and the transfer – conf
    frame being brought up, all at the click of one button on the main agent
    screen.
  127. Added the agc/phone_only.php script, a web-based web-phone-only client
    application that allows full phone usage without needing to login as an
    agent
  128. Added option to Lists to allow you to choose in the List Modification
    screen the method of time zone adjustment that happens nightly on a per
    list basis. COUNTRY_AND_AREA_CODE is the default, and will use the
    country code and area code of the phone number to determine the time
    zone of the lead. POSTAL_CODE will use the postal code if available to
    determine the time zone of the lead. NANPA_PREFIX works only in the USA
    and will use the area code and prefix of the phone number to determine
    the time zone of the lead, but this is not enabled by default in the
    system, so please be sure you have the NANPA prefix data loaded onto
    your system before selecting this option. OWNER_TIME_ZONE_CODE will use
    a standard time zone abbreviation loaded into the owner field of the
    lead to determine the time zone, in the USA examples are AST, EST, CST,
    MST, PST, AKST, HST. This feature does NOT affect the time zone used at
    the moment leads are loaded, that needs to be selected when you are
    loading leads. This feature must be enabled in the crontab for the GMT
    adjust script:
    /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl –list-settings
  129. Added Available Only Tally Threshold campaign option which allows you to
    set the number of agents below which Available Only Tally will be
    temporarily enabled
  130. Added Auto Dial Level Threshold campaign option which allows you to set a
    minimum number agents that the predictive algorithm will work at. If the
    number of agents falls below the number that you have set, then the
    dial level will go to 1.0 until more agents log in or go into the
    selected state
  131. Change Dial Level Difference Target to work properly with all RATIO and
    ADAPT dial method outbound campaigns. Added a Method option to restrict
    this feature to only calculation of dial level or to affect the calls
    dialed on each dialing engine.
  132. Added ability to have outbound auto-dial campaigns drop to an audio prompt
    or a call menu. Outbound IVR Report added. Added optional logging of
    call menu caller key presses. Lead ID can now be preserved on calls
    coming from auto-dial or in-groups that go through call menus and back
    into an in-group. Call Menu transfer also works from an Outbound Survey.
  133. Added new agent interface alert where manual dial calls will not be allowed
    if the disposition process has not completed. Usually a rare problem on
    systems with networking issues.
  134. Added Callback Days Limit campaign option to allow scheduled callbacks to
    be scheduled only a set number of days from today.
  135. Added ability to disable the Disposition screen on the agent interface.
  136. Added install.pl options to define conf file and copy web language
    translation files.
  137. Added Export Leads Report similar to Export Calls Report, but a lead is
    only exported once and with the current status.
  138. Added Agent Screen Labels sub-section of the Admin functions. Allows for
    each campaign to use a different set of labels for the fields on the
    default agent screen.
  139. Added ability to define the agent screen status fields shown to the agent:
    Call ID, Lead ID and List ID
  140. Added HIDDEN and READONLY field types for custom list fields.
  141. Added Outbound Campaign Test Call feature to allow you to place a call from
    the Campaign Detail screen that will go out as if it were an auto-dial
    call. Must be enabled in System Settings.
  142. Added ability to check for USA and Canada valid prefix and areacodes when
    loading leads into the web/cli/api lead loaders
  143. Added ability to use AGENTEXT in AGENTDIRECT in-groups as a way to send
    dropped, no-agent-no-queue and other transferred calls to a specific
    dialplan number per-user defined in the User Custom Five field.
  144. Added last_inbound_call_time and last_inbound_call_finish Next Agent Call
    routing options to in-groups.
  145. Added CSV download option to almost all reports.
  146. Added manual dial agent skip lead logging to the user stats page
  147. Added HIDEBLOB field type for custom list fields
  148. Added options to set the voicemail zone and extra voicemail options for
    each voicemail box in phones and extra voicemail boxes. Also added
    default voicemail zone and timezone settings in the system settings.
    ** **** NOTE **** You might want to add the new zones in the new
    ** voicemail.conf.sample file to your voicemail.conf file
    You must delete the BUILD voicemail file for this feature to work:
    rm -f /etc/asterisk/BUILDvoicemail-vicidial.conf
  149. Added ability to chose the type of callerid sent for inbound ring-agent
    calls in the in-group: GENERIC, INGROUP, CUSTOMER PHONE and a couple
    of combinations of those.
  150. Added NA Call URL feature to campaigns and in-groups. This works like
    dispo call url, but it works only for non-agent handled calls, like
    dropped calls, No Answers, Busy, etc…
  151. Changed MULTI_LEAD Auto-Alt-Dial to use the Auto-Alt-Dial Statuses as set
    in the campaign automatically. If you are using MULTI_LEAD you may need
    to add statuses like DROP, PDROP and others to your campaign’s auto-alt
    dial statuses so that the other leads tied by vendor_lead_code in the
    campaign’s lists are not deactivated.
  152. Added noanswer logging feature to System Settings, will log only auto-dial
    calls that are not answered to a separate table
  153. Added new Team Performance Detail report to the Reports page. This is a
    fairly detailed and database-intensive report that summarizes several
    user-grouped statistics
  154. Added ability to use static audio from dynamic fields in Survey and
    Answering machine messages when using Cepstral TTS
  155. Added the Campaign Status List Report which shows calls broken down by
    status within each list_id for a campaign.
  156. Added update_phone, add_phone_alias, update_phone_alias functions

How to – Optimize your database using the MySQL tuning tool

MySQL tuning

How to – Optimize your database using the MySQL tuning tool

This article will go over how to optimize your database using the mysql-tuning tool included in your extras directory. The great thing about this tool is you can keep using it. You can use it after your initial install all the way through your finished using ViciDial.

MySQL tuning

Step 1 – Change your location to the extras directory

First we need to change our location to the extras directory for astguiclient with the commands below:

cd /usr/src/astguiclient/trunk/extras

Step 2 – Give mysql-tuning.sh executable permissions

The file we need to use is mysql-tuning.sh and by default it’s not executable, so we need to give it that permission. You can do this simply by typing:

chmod +x mysql-tuning.sh

Step 3 – Run the tuner

Now you can run the tuning program by typing:

./mysql-tuning.sh

MySQL tuning

If it tells you that you have an unsupported version of MySQL, copy and paste the code below into a file called MyTuner.sh:

#!/bin/sh

# vim: ts=8
#########################################################################
#                                                                       #
#       MySQL performance tuning primer script                          #
#       Writen by: Matthew Montgomery                                   #
#       Report bugs to: https://bugs.launchpad.net/mysql-tuning-primer  #
#       Inspired by: MySQLARd (http://gert.sos.be/demo/mysqlar/)        #
#       Version: 1.6-r1         Released: 2011-08-06                    #
#       Licenced under GPLv2                                            #
#                                                                       #
#########################################################################

#########################################################################
#                                                                       #
#       Usage: ./tuning-primer.sh [ mode ]                              #
#                                                                       #
#       Available Modes:                                                #
#               all :           perform all checks (default)            #
#               prompt :        prompt for login credintials and socket #
#                               and execution mode                      #
#               mem, memory :   run checks for tunable options which    #
#                               effect memory usage                     #
#               disk, file :    run checks for options which effect     #
#                               i/o performance or file handle limits   #
#               innodb :        run InnoDB checks /* to be improved */  #
#               misc :          run checks for that don't categorise    #
#                               well Slow Queries, Binary logs,         #
#                               Used Connections and Worker Threads     #
#########################################################################
#                                                                       #
# Set this socket variable ONLY if you have multiple instances running  #
# or we are unable to find your socket, and you don't want to to be     #
# prompted for input each time you run this script.                     #
#                                                                       #
#########################################################################
socket=

export black='\033[0m'
export boldblack='\033[1;0m'
export red='\033[31m'
export boldred='\033[1;31m'
export green='\033[32m'
export boldgreen='\033[1;32m'
export yellow='\033[33m'
export boldyellow='\033[1;33m'
export blue='\033[34m'
export boldblue='\033[1;34m'
export magenta='\033[35m'
export boldmagenta='\033[1;35m'
export cyan='\033[36m'
export boldcyan='\033[1;36m'
export white='\033[37m'
export boldwhite='\033[1;37m'


cecho ()

## -- Function to easliy print colored text -- ##

        # Color-echo.
        # Argument $1 = message
        # Argument $2 = color
{
local default_msg="No message passed."

message=${1:-$default_msg}      # Defaults to default message.

#change it for fun
#We use pure names
color=${2:-black}               # Defaults to black, if not specified.

case $color in
        black)
                 printf "$black" ;;
        boldblack)
                 printf "$boldblack" ;;
        red)
                 printf "$red" ;;
        boldred)
                 printf "$boldred" ;;
        green)
                 printf "$green" ;;
        boldgreen)
                 printf "$boldgreen" ;;
        yellow)
                 printf "$yellow" ;;
        boldyellow)
                 printf "$boldyellow" ;;
        blue)
                 printf "$blue" ;;
        boldblue)
                 printf "$boldblue" ;;
        magenta)
                 printf "$magenta" ;;
        boldmagenta)
                 printf "$boldmagenta" ;;
        cyan)
                 printf "$cyan" ;;
        boldcyan)
                 printf "$boldcyan" ;;
        white)
                 printf "$white" ;;
        boldwhite)
                 printf "$boldwhite" ;;
esac
  printf "%s\n"  "$message"
  tput sgr0                     # Reset to normal.
  printf "$black"

return
}


cechon ()

## -- Function to easliy print colored text -- ##

        # Color-echo.
        # Argument $1 = message
        # Argument $2 = color
{
local default_msg="No message passed."
                                # Doesn't really need to be a local variable.

message=${1:-$default_msg}      # Defaults to default message.

#change it for fun
#We use pure names
color=${2:-black}               # Defaults to black, if not specified.

case $color in
        black)
                printf "$black" ;;
        boldblack)
                printf "$boldblack" ;;
        red)
                printf "$red" ;;
        boldred)
                printf "$boldred" ;;
        green)
                printf "$green" ;;
        boldgreen)
                printf "$boldgreen" ;;
        yellow)
                printf "$yellow" ;;
        boldyellow)
                printf "$boldyellow" ;;
        blue)
                printf "$blue" ;;
        boldblue)
                printf "$boldblue" ;;
        magenta)
                printf "$magenta" ;;
        boldmagenta)
                printf "$boldmagenta" ;;
        cyan)
                printf "$cyan" ;;
        boldcyan)
                printf "$boldcyan" ;;
        white)
                printf "$white" ;;
        boldwhite)
                printf "$boldwhite" ;;
esac
  printf "%s"  "$message"
  tput sgr0                     # Reset to normal.
  printf "$black"

return
}


print_banner () {

## -- Banner -- ##

cecho " -- MYSQL PERFORMANCE TUNING PRIMER --" boldblue
cecho "      - By: Matthew Montgomery -" black

}

## -- Find the location of the mysql.sock file -- ##

check_for_socket () {
        if [ -z "$socket" ] ; then
                # Use ~/my.cnf version
                if [ -f ~/.my.cnf ] ; then
                        cnf_socket=$(grep ^socket ~/.my.cnf | awk -F \= '{ print $2 }' | head -1)
                fi
                if [ -S "$cnf_socket" ] ; then
                        socket=$cnf_socket
                elif [ -S /var/lib/mysql/mysql.sock ] ; then
                        socket=/var/lib/mysql/mysql.sock
                elif [ -S /var/run/mysqld/mysqld.sock ] ; then
                        socket=/var/run/mysqld/mysqld.sock
                elif [ -S /tmp/mysql.sock ] ; then
                        socket=/tmp/mysql.sock
                else
                        if [ -S "$ps_socket" ] ; then
                        socket=$ps_socket
                        fi
                fi
        fi
        if [ -S "$socket" ] ; then
                echo UP > /dev/null
        else
                cecho "No valid socket file \"$socket\" found!" boldred
                cecho "The mysqld process is not running or it is installed in a custom location." red
                cecho "If you are sure mysqld is running, execute script in \"prompt\" mode or set " red
                cecho "the socket= variable at the top of this script" red
                exit 1
        fi
}


check_for_plesk_passwords () {

## -- Check for the existance of plesk and login using it's credentials -- ##

        if [ -f /etc/psa/.psa.shadow ] ; then
                mysql="mysql -S $socket -u admin -p$(cat /etc/psa/.psa.shadow)"
                mysqladmin="mysqladmin -S $socket -u admin -p$(cat /etc/psa/.psa.shadow)"
        else
                mysql="mysql"
                mysqladmin="mysqladmin"
                # mysql="mysql -S $socket"
                # mysqladmin="mysqladmin -S $socket"
        fi
}

check_mysql_login () {

## -- Test for running mysql -- ##

        is_up=$($mysqladmin ping 2>&1)
        if [ "$is_up" = "mysqld is alive" ] ; then
                echo UP > /dev/null
                # echo $is_up
        elif [ "$is_up" != "mysqld is alive" ] ; then
                printf "\n"
                cecho "Using login values from ~/.my.cnf"
                cecho "- INITIAL LOGIN ATTEMPT FAILED -" boldred
                if [ -z $prompted ] ; then
                find_webmin_passwords
                else
                        return 1
                fi

        else
                cecho "Unknow exit status" red
                exit -1
        fi
}

final_login_attempt () {
        is_up=$($mysqladmin ping 2>&1)
        if [ "$is_up" = "mysqld is alive" ] ; then
                echo UP > /dev/null
        elif [ "$is_up" != "mysqld is alive" ] ; then
                cecho "- FINAL LOGIN ATTEMPT FAILED -" boldred
                cecho "Unable to log into socket: $socket" boldred
                exit 1
        fi
}

second_login_failed () {

## -- create a ~/.my.cnf and exit when all else fails -- ##

        cecho "Could not auto detect login info!"
        cecho "Found potential sockets: $found_socks"
        cecho "Using: $socket" red
        read -p "Would you like to provide a different socket?: [y/N] " REPLY
                case $REPLY in
                        yes | y | Y | YES)
                        read -p "Socket: " socket
                        ;;
                esac
        read -p "Do you have your login handy ? [y/N] : " REPLY
        case $REPLY in
                yes | y | Y | YES)
                answer1='yes'
                read -p "User: " user
                read -rp "Password: " pass
                if [ -z $pass ] ; then
                export mysql="$mysql -S$socket -u$user"
                export mysqladmin="$mysqladmin -S$socket -u$user"
                else
                export mysql="$mysql -S$socket -u$user -p$pass"
                export mysqladmin="$mysqladmin -S$socket -u$user -p$pass"
                fi
                ;;
                *)
                cecho "Please create a valid login to MySQL"
                cecho "Or, set correct values for  'user=' and 'password=' in ~/.my.cnf"
                ;;
        esac
        cecho " "
        read -p "Would you like me to create a ~/.my.cnf file for you? [y/N] : " REPLY
        case $REPLY in
                yes | y | Y | YES)
                answer2='yes'
                if [ ! -f ~/.my.cnf ] ; then
                        umask 077
                        printf "[client]\nuser=$user\npassword=$pass\nsocket=$socket" > ~/.my.cnf
                        if [ "$answer1" != 'yes' ] ; then
                                exit 1
                        else
                                final_login_attempt
                                return 0
                        fi
                else
                        printf "\n"
                        cecho "~/.my.cnf already exists!" boldred
                        printf "\n"
                        read -p "Replace ? [y/N] : " REPLY
                        if [ "$REPLY" = 'y' ] || [ "$REPLY" = 'Y' ] ; then
                        printf "[client]\nuser=$user\npassword=$pass\socket=$socket" > ~/.my.cnf
                                if [ "$answer1" != 'yes' ] ; then
                                        exit 1
                                else
                                        final_login_attempt
                                        return 0
                                fi
                        else
                                cecho "Please set the 'user=' and 'password=' and 'socket=' values in ~/.my.cnf"
                                exit 1
                        fi
                fi
                ;;
                *)
                if [ "$answer1" != 'yes' ] ; then
                        exit 1
                else
                        final_login_attempt
                        return 0
                fi
                ;;
        esac
}

find_webmin_passwords () {

## -- populate the .my.cnf file using values harvested from Webmin -- ##

        cecho "Testing for stored webmin passwords:"
        if [ -f /etc/webmin/mysql/config ] ; then
                user=$(grep ^login= /etc/webmin/mysql/config | cut -d "=" -f 2)
                pass=$(grep ^pass= /etc/webmin/mysql/config | cut -d "=" -f 2)
                if [  $user ] && [ $pass ] && [ ! -f ~/.my.cnf  ] ; then
                        cecho "Setting login info as User: $user Password: $pass"
                        touch ~/.my.cnf
                        chmod 600 ~/.my.cnf
                        printf "[client]\nuser=$user\npassword=$pass" > ~/.my.cnf
                        cecho "Retrying login"
                        is_up=$($mysqladmin ping 2>&1)
                        if [ "$is_up" = "mysqld is alive"  ] ; then
                                echo UP > /dev/null
                        else
                                second_login_failed
                        fi
                echo
                else
                        second_login_failed
                echo
                fi
        else
        cecho " None Found" boldred
                second_login_failed
        fi
}

#########################################################################
#                                                                       #
#  Function to pull MySQL status variable                               #
#                                                                       #
#  Call using :                                                         #
#       mysql_status \'Mysql_status_variable\' bash_dest_variable       #
#                                                                       #
#########################################################################

mysql_status () {
        local status=$($mysql -Bse "show /*!50000 global */ status like $1" | awk '{ print $2 }')
        export "$2"=$status
}

#########################################################################
#                                                                       #
#  Function to pull MySQL server runtime variable                       #
#                                                                       #
#  Call using :                                                         #
#       mysql_variable \'Mysql_server_variable\' bash_dest_variable     #
#       - OR -                                                          #
#       mysql_variableTSV \'Mysql_server_variable\' bash_dest_variable  #
#                                                                       #
#########################################################################

mysql_variable () {
        local variable=$($mysql -Bse "show /*!50000 global */ variables like $1" | awk '{ print $2 }')
        export "$2"=$variable
}
mysql_variableTSV () {
        local variable=$($mysql -Bse "show /*!50000 global */ variables like $1" | awk -F \t '{ print $2 }')
        export "$2"=$variable
}

float2int () {
        local variable=$(echo "$1 / 1" | bc -l)
        export "$2"=$variable
}

divide () {

# -- Divide two intigers -- #

        usage="$0 dividend divisor '$variable' scale"
        if [ $1 -ge 1 ] ; then
                dividend=$1
        else
                cecho "Invalid Dividend" red
                echo $usage
                exit 1
        fi
        if [ $2 -ge 1 ] ; then
                divisor=$2
        else
                cecho "Invalid Divisor" red
                echo $usage
                exit 1
        fi
        if [ ! -n $3 ] ; then
                cecho "Invalid variable name" red
                echo $usage
                exit 1
        fi
        if [ -z $4 ] ; then
                scale=2
        elif [ $4 -ge 0 ] ; then
                scale=$4
        else
                cecho "Invalid scale" red
                echo $usage
                exit 1
        fi
        export $3=$(echo "scale=$scale; $dividend / $divisor" | bc -l)
}

human_readable () {

#########################################################################
#                                                                       #
#  Convert a value in to human readable size and populate a variable    #
#  with the result.                                                     #
#                                                                       #
#  Call using:                                                          #
#       human_readable $value 'variable name' [ places of precision]    #
#                                                                       #
#########################################################################

        ## value=$1
        ## variable=$2
        scale=$3

        if [ $1 -ge 1073741824 ] ; then
                if [ -z $3 ] ; then
                        scale=2
                fi
                divide $1 1073741824 "$2" $scale
                unit="G"
        elif [ $1 -ge 1048576 ] ; then
                if [ -z $3 ] ; then
                        scale=0
                fi
                divide $1 1048576 "$2" $scale
                unit="M"
        elif [ $1 -ge 1024 ] ; then
                if [ -z $3 ] ; then
                        scale=0
                fi
                divide $1 1024 "$2" $scale
                unit="K"
        else
                export "$2"=$1
                unit="bytes"
        fi
        # let "$2"=$HR
}

human_readable_time () {

########################################################################
#                                                                      #
#       Function to produce human readable time                        #
#                                                                      #
########################################################################

        usage="$0 seconds 'variable'"
        if [ -z $1 ] || [ -z $2 ] ; then
                cecho $usage red
                exit 1
        fi
        days=$(echo "scale=0 ; $1 / 86400" | bc -l)
        remainder=$(echo "scale=0 ; $1 % 86400" | bc -l)
        hours=$(echo "scale=0 ; $remainder / 3600" | bc -l)
        remainder=$(echo "scale=0 ; $remainder % 3600" | bc -l)
        minutes=$(echo "scale=0 ; $remainder / 60" | bc -l)
        seconds=$(echo "scale=0 ; $remainder % 60" | bc -l)
        export $2="$days days $hours hrs $minutes min $seconds sec"
}

check_mysql_version () {

## -- Print Version Info -- ##

        mysql_variable \'version\' mysql_version
        mysql_variable \'version_compile_machine\' mysql_version_compile_machine

if [ "$mysql_version_num" -lt 050000 ]; then
        cecho "MySQL Version $mysql_version $mysql_version_compile_machine is EOL please upgrade to MySQL 4.1 or later" boldred
else
        cecho "MySQL Version $mysql_version $mysql_version_compile_machine"
fi


}

post_uptime_warning () {

#########################################################################
#                                                                       #
#  Present a reminder that mysql must run for a couple of days to       #
#  build up good numbers in server status variables before these tuning #
#  suggestions should be used.                                          #
#                                                                       #
#########################################################################

        mysql_status \'Uptime\' uptime
        mysql_status \'Threads_connected\' threads
        queries_per_sec=$(($questions/$uptime))
        human_readable_time $uptime uptimeHR

        cecho "Uptime = $uptimeHR"
        cecho "Avg. qps = $queries_per_sec"
        cecho "Total Questions = $questions"
        cecho "Threads Connected = $threads"
        echo

        if [ $uptime -gt 172800 ] ; then
                cecho "Server has been running for over 48hrs."
                cecho "It should be safe to follow these recommendations"
        else
                cechon "Warning: " boldred
                cecho "Server has not been running for at least 48hrs." boldred
                cecho "It may not be safe to use these recommendations" boldred

        fi
        echo ""
        cecho "To find out more information on how each of these" red
        cecho "runtime variables effects performance visit:" red
        if [ "$major_version" = '3.23' ] || [ "$major_version" = '4.0' ] || [ "$major_version" = '4.1' ] ; then
        cecho "http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html" boldblue
        elif [ "$major_version" = '5.0' ] || [ "$mysql_version_num" -gt '050100' ]; then
        cecho "http://dev.mysql.com/doc/refman/$major_version/en/server-system-variables.html" boldblue
        else
        cecho "UNSUPPORTED MYSQL VERSION" boldred
        exit 1
        fi
        cecho "Visit http://www.mysql.com/products/enterprise/advisors.html" boldblue
        cecho "for info about MySQL's Enterprise Monitoring and Advisory Service" boldblue
}

check_slow_queries () {

## -- Slow Queries -- ##

        cecho "SLOW QUERIES" boldblue

        mysql_status \'Slow_queries\' slow_queries
        mysql_variable \'long_query_time\' long_query_time
        mysql_variable \'log%queries\' log_slow_queries

        prefered_query_time=5
        if [ -e /etc/my.cnf ] ; then
                if [ -z $log_slow_queries ] ; then
                        log_slow_queries=$(grep log-slow-queries /etc/my.cnf)
                fi
        fi

        if [ "$log_slow_queries" = 'ON' ] ; then
                cecho "The slow query log is enabled."
        elif [ "$log_slow_queries" = 'OFF' ] ; then
                cechon "The slow query log is "
                cechon "NOT" boldred
                cecho " enabled."
        elif [ -z $log_slow_queries ] ; then
                cechon "The slow query log is "
                cechon "NOT" boldred
                cecho " enabled."
        else
                cecho "Error: $log_slow_queries" boldred
        fi
        cecho "Current long_query_time = $long_query_time sec."
        cechon "You have "
        cechon "$slow_queries" boldred
        cechon " out of "
        cechon "$questions" boldred
        cecho " that take longer than $long_query_time sec. to complete"

        float2int long_query_time long_query_timeInt

        if [ $long_query_timeInt -gt $prefered_query_time ] ; then
                cecho "Your long_query_time may be too high, I typically set this under $prefered_query_time sec." red
        else
                cecho "Your long_query_time seems to be fine" green
        fi

}

check_binary_log () {

## -- Binary Log -- ##

        cecho "BINARY UPDATE LOG" boldblue

        mysql_variable \'log_bin\' log_bin
        mysql_variable \'max_binlog_size\' max_binlog_size
        mysql_variable \'expire_logs_days\' expire_logs_days
        mysql_variable \'sync_binlog\' sync_binlog
        #  mysql_variable \'max_binlog_cache_size\' max_binlog_cache_size

        if [ "$log_bin" = 'ON' ] ; then
                cecho "The binary update log is enabled"
                if [ -z "$max_binlog_size" ] ; then
                        cecho "The max_binlog_size is not set. The binary log will rotate when it reaches 1GB." red
                fi
                if [ "$expire_logs_days" -eq 0 ] ; then
                        cecho "The expire_logs_days is not set." boldred
                        cechon "The mysqld will retain the entire binary log until " red
                        cecho "RESET MASTER or PURGE MASTER LOGS commands are run manually" red
                        cecho "Setting expire_logs_days will allow you to remove old binary logs automatically"  yellow
                        cecho "See http://dev.mysql.com/doc/refman/$major_version/en/purge-master-logs.html" yellow
                fi
                if [ "$sync_binlog" = 0 ] ; then
                        cecho "Binlog sync is not enabled, you could loose binlog records during a server crash" red
                fi
        else
                cechon "The binary update log is "
                cechon "NOT " boldred
                cecho "enabled."
                cecho "You will not be able to do point in time recovery" red
                cecho "See http://dev.mysql.com/doc/refman/$major_version/en/point-in-time-recovery.html" yellow
        fi
}

check_used_connections () {

## -- Used Connections -- ##

        mysql_variable \'max_connections\' max_connections
        mysql_status \'Max_used_connections\' max_used_connections
        mysql_status \'Threads_connected\' threads_connected

        connections_ratio=$(($max_used_connections*100/$max_connections))

        cecho "MAX CONNECTIONS" boldblue
        cecho "Current max_connections = $max_connections"
        cecho "Current threads_connected = $threads_connected"
        cecho "Historic max_used_connections = $max_used_connections"
        cechon "The number of used connections is "
        if [ $connections_ratio -ge 85 ] ; then
                txt_color=red
                error=1
        elif [ $connections_ratio -le 10 ] ; then
                txt_color=red
                error=2
        else
                txt_color=green
                error=0
        fi
        # cechon "$max_used_connections " $txt_color
        # cechon "which is "
        cechon "$connections_ratio% " $txt_color
        cecho "of the configured maximum."

        if [ $error -eq 1 ] ; then
                cecho "You should raise max_connections" $txt_color
        elif [ $error -eq 2 ] ; then
                cecho "You are using less than 10% of your configured max_connections." $txt_color
                cecho "Lowering max_connections could help to avoid an over-allocation of memory" $txt_color
                cecho "See \"MEMORY USAGE\" section to make sure you are not over-allocating" $txt_color
        else
                cecho "Your max_connections variable seems to be fine." $txt_color
        fi
        unset txt_color
}

check_threads() {

## -- Worker Threads -- ##

        cecho "WORKER THREADS" boldblue

        mysql_status \'Threads_created\' threads_created1
        sleep 1
        mysql_status \'Threads_created\' threads_created2

        mysql_status \'Threads_cached\' threads_cached
        mysql_status \'Uptime\' uptime
        mysql_variable \'thread_cache_size\' thread_cache_size

        historic_threads_per_sec=$(($threads_created1/$uptime))
        current_threads_per_sec=$(($threads_created2-$threads_created1))

        cecho "Current thread_cache_size = $thread_cache_size"
        cecho "Current threads_cached = $threads_cached"
        cecho "Current threads_per_sec = $current_threads_per_sec"
        cecho "Historic threads_per_sec = $historic_threads_per_sec"

        if [ $historic_threads_per_sec -ge 2 ] && [ $threads_cached -le 1 ] ; then
                cecho "Threads created per/sec are overrunning threads cached" red
                cecho "You should raise thread_cache_size" red
        elif [ $current_threads_per_sec -ge 2 ] ; then
                cecho "Threads created per/sec are overrunning threads cached" red
                cecho "You should raise thread_cache_size" red
        else
                cecho "Your thread_cache_size is fine" green
        fi
}

check_key_buffer_size () {

## -- Key buffer Size -- ##

        cecho "KEY BUFFER" boldblue

        mysql_status \'Key_read_requests\' key_read_requests
        mysql_status \'Key_reads\' key_reads
        mysql_status \'Key_blocks_used\' key_blocks_used
        mysql_status \'Key_blocks_unused\' key_blocks_unused
        mysql_variable \'key_cache_block_size\' key_cache_block_size
        mysql_variable \'key_buffer_size\' key_buffer_size
        mysql_variable \'datadir\' datadir
        mysql_variable \'version_compile_machine\' mysql_version_compile_machine
        myisam_indexes=$($mysql -Bse "/*!50000 SELECT IFNULL(SUM(INDEX_LENGTH),0) from information_schema.TABLES where ENGINE='MyISAM' */")

        if [ -z $myisam_indexes ] ; then
                myisam_indexes=$(find $datadir -name '*.MYI' -exec du $duflags '{}' \; 2>&1 | awk '{ s += $1 } END { printf("%.0f\n", s )}')
        fi

        if [ $key_reads -eq 0 ] ; then
                cecho "No key reads?!" boldred
                cecho "Seriously look into using some indexes" red
                key_cache_miss_rate=0
                key_buffer_free=$(echo "$key_blocks_unused * $key_cache_block_size / $key_buffer_size * 100" | bc -l )
                key_buffer_freeRND=$(echo "scale=0; $key_buffer_free / 1" | bc -l)
        else
                key_cache_miss_rate=$(($key_read_requests/$key_reads))
                if [ ! -z $key_blocks_unused ] ; then
                        key_buffer_free=$(echo "$key_blocks_unused * $key_cache_block_size / $key_buffer_size * 100" | bc -l )
                        key_buffer_freeRND=$(echo "scale=0; $key_buffer_free / 1" | bc -l)
                else
                        key_buffer_free='Unknown'
                        key_buffer_freeRND=75
                fi
        fi

        human_readable $myisam_indexes myisam_indexesHR
        cecho "Current MyISAM index space = $myisam_indexesHR $unit"

        human_readable  $key_buffer_size key_buffer_sizeHR
        cecho "Current key_buffer_size = $key_buffer_sizeHR $unit"
        cecho "Key cache miss rate is 1 : $key_cache_miss_rate"
        cecho "Key buffer free ratio = $key_buffer_freeRND %"

        if [ "$major_version" = '5.1' ] && [ $mysql_version_num -lt 050123 ] ; then
                if [ $key_buffer_size -ge 4294967296 ] && ( echo "x86_64 ppc64 ia64 sparc64 i686" | grep -q $mysql_version_compile_machine ) ; then
                        cecho "Using key_buffer_size > 4GB will cause instability in versions prior to 5.1.23 " boldred
                        cecho "See Bug#5731, Bug#29419, Bug#29446" boldred
                fi
        fi
        if [ "$major_version" = '5.0' ] && [ $mysql_version_num -lt 050052 ] ; then
                if [ $key_buffer_size -ge 4294967296 ] && ( echo "x86_64 ppc64 ia64 sparc64 i686" | grep -q $mysql_version_compile_machine ) ; then
                        cecho "Using key_buffer_size > 4GB will cause instability in versions prior to 5.0.52 " boldred
                        cecho "See Bug#5731, Bug#29419, Bug#29446" boldred
                fi
        fi
        if [ "$major_version" = '4.1' -o "$major_version" = '4.0' ] && [ $key_buffer_size -ge 4294967296 ] && ( echo "x86_64 ppc64 ia64 sparc64 i686" | grep -q $mysql_version_compile_machine ) ; then
                cecho "Using key_buffer_size > 4GB will cause instability in versions prior to 5.0.52 " boldred
                cecho "Reduce key_buffer_size to a safe value" boldred
                cecho "See Bug#5731, Bug#29419, Bug#29446" boldred
        fi

        if [ $key_cache_miss_rate -le 100 ] && [ $key_cache_miss_rate -gt 0 ] && [ $key_buffer_freeRND -le 20 ]; then
                cecho "You could increase key_buffer_size" boldred
                cecho "It is safe to raise this up to 1/4 of total system memory;"
                cecho "assuming this is a dedicated database server."
        elif [ $key_buffer_freeRND -le 20 ] && [ $key_buffer_size -le $myisam_indexes ] ; then
                cecho "You could increase key_buffer_size" boldred
                cecho "It is safe to raise this up to 1/4 of total system memory;"
                cecho "assuming this is a dedicated database server."
        elif [ $key_cache_miss_rate -ge 10000 ] || [ $key_buffer_freeRND -le 50  ] ; then
                cecho "Your key_buffer_size seems to be too high." red
                cecho "Perhaps you can use these resources elsewhere" red
        else
                cecho "Your key_buffer_size seems to be fine" green
        fi
}

check_query_cache () {

## -- Query Cache -- ##

        cecho "QUERY CACHE" boldblue

        mysql_variable \'version\' mysql_version
        mysql_variable \'query_cache_size\' query_cache_size
        mysql_variable \'query_cache_limit\' query_cache_limit
        mysql_variable \'query_cache_min_res_unit\' query_cache_min_res_unit
        mysql_status \'Qcache_free_memory\' qcache_free_memory
        mysql_status \'Qcache_total_blocks\' qcache_total_blocks
        mysql_status \'Qcache_free_blocks\' qcache_free_blocks
        mysql_status \'Qcache_lowmem_prunes\' qcache_lowmem_prunes

        if [ -z $query_cache_size ] ; then
                cecho "You are using MySQL $mysql_version, no query cache is supported." red
                cecho "I recommend an upgrade to MySQL 4.1 or better" red
        elif [ $query_cache_size -eq 0 ] ; then
                cecho "Query cache is supported but not enabled" red
                cecho "Perhaps you should set the query_cache_size" red
        else
                qcache_used_memory=$(($query_cache_size-$qcache_free_memory))
                qcache_mem_fill_ratio=$(echo "scale=2; $qcache_used_memory * 100 / $query_cache_size" | bc -l)
                qcache_mem_fill_ratioHR=$(echo "scale=0; $qcache_mem_fill_ratio / 1" | bc -l)

                cecho "Query cache is enabled" green
                human_readable $query_cache_size query_cache_sizeHR
                cecho "Current query_cache_size = $query_cache_sizeHR $unit"
                human_readable $qcache_used_memory qcache_used_memoryHR
                cecho "Current query_cache_used = $qcache_used_memoryHR $unit"
                human_readable $query_cache_limit query_cache_limitHR
                cecho "Current query_cache_limit = $query_cache_limitHR $unit"
                cecho "Current Query cache Memory fill ratio = $qcache_mem_fill_ratio %"
                if [ -z $query_cache_min_res_unit ] ; then
                        cecho "No query_cache_min_res_unit is defined.  Using MySQL < 4.1 cache fragmentation can be inpredictable" %yellow
                else
                        human_readable $query_cache_min_res_unit query_cache_min_res_unitHR
                        cecho "Current query_cache_min_res_unit = $query_cache_min_res_unitHR $unit"
                fi
                if [ $qcache_free_blocks -gt 2 ] && [ $qcache_total_blocks -gt 0 ] ; then
                        qcache_percent_fragmented=$(echo "scale=2; $qcache_free_blocks * 100 / $qcache_total_blocks" | bc -l)
                        qcache_percent_fragmentedHR=$(echo "scale=0; $qcache_percent_fragmented / 1" | bc -l)
                        if [ $qcache_percent_fragmentedHR -gt 20 ] ; then
                                cecho "Query Cache is $qcache_percent_fragmentedHR % fragmented" red
                                cecho "Run \"FLUSH QUERY CACHE\" periodically to defragment the query cache memory" red
                                cecho "If you have many small queries lower 'query_cache_min_res_unit' to reduce fragmentation." red
                        fi
                fi

                if [ $qcache_mem_fill_ratioHR -le 25 ] ; then
                        cecho "Your query_cache_size seems to be too high." red
                        cecho "Perhaps you can use these resources elsewhere" red
                fi
                if [ $qcache_lowmem_prunes -ge 50 ] && [ $qcache_mem_fill_ratioHR -ge 80 ]; then
                        cechon "However, "
                        cechon "$qcache_lowmem_prunes " boldred
                        cecho "queries have been removed from the query cache due to lack of memory"
                        cecho "Perhaps you should raise query_cache_size" boldred
                fi
                cecho "MySQL won't cache query results that are larger than query_cache_limit in size" yellow
        fi

}

check_sort_operations () {

## -- Sort Operations -- ##

        cecho "SORT OPERATIONS" boldblue

        mysql_status \'Sort_merge_passes\' sort_merge_passes
        mysql_status \'Sort_scan\' sort_scan
        mysql_status \'Sort_range\' sort_range
        mysql_variable \'sort_buffer%\' sort_buffer_size
        mysql_variable \'read_rnd_buffer_size\' read_rnd_buffer_size

        total_sorts=$(($sort_scan+$sort_range))
        if [ -z $read_rnd_buffer_size ] ; then
                mysql_variable \'record_buffer\' read_rnd_buffer_size
        fi

        ## Correct for rounding error in mysqld where 512K != 524288 ##
        sort_buffer_size=$(($sort_buffer_size+8))
        read_rnd_buffer_size=$(($read_rnd_buffer_size+8))

        human_readable $sort_buffer_size sort_buffer_sizeHR
        cecho "Current sort_buffer_size = $sort_buffer_sizeHR $unit"

        human_readable $read_rnd_buffer_size read_rnd_buffer_sizeHR
        cechon "Current "
        if [ "$major_version" = '3.23' ] ; then
                cechon "record_rnd_buffer "
        else
                cechon "read_rnd_buffer_size "
        fi
        cecho "= $read_rnd_buffer_sizeHR $unit"

        if [ $total_sorts -eq 0 ] ; then
                cecho "No sort operations have been performed"
                passes_per_sort=0
        fi
        if [ $sort_merge_passes -ne 0 ] ; then
                passes_per_sort=$(($sort_merge_passes/$total_sorts))
        else
                passes_per_sort=0
        fi

        if [ $passes_per_sort -ge 2 ] ; then
                cechon "On average "
                cechon "$passes_per_sort " boldred
                cecho "sort merge passes are made per sort operation"
                cecho "You should raise your sort_buffer_size"
                cechon "You should also raise your "
                if [ "$major_version" = '3.23' ] ; then
                        cecho "record_rnd_buffer_size"
                else
                        cecho "read_rnd_buffer_size"
                fi
        else
                cecho "Sort buffer seems to be fine" green
        fi
}

check_join_operations () {

## -- Joins -- ##

        cecho "JOINS" boldblue

        mysql_status \'Select_full_join\' select_full_join
        mysql_status \'Select_range_check\' select_range_check
        mysql_variable \'join_buffer%\' join_buffer_size

        ## Some 4K is dropped from join_buffer_size adding it back to make sane ##
        ## handling of human-readable conversion ##

        join_buffer_size=$(($join_buffer_size+4096))

        human_readable $join_buffer_size join_buffer_sizeHR 2

        cecho "Current join_buffer_size = $join_buffer_sizeHR $unit"
        cecho "You have had $select_full_join queries where a join could not use an index properly"

        if [ $select_range_check -eq 0 ] && [ $select_full_join -eq 0 ] ; then
                cecho "Your joins seem to be using indexes properly" green
        fi
        if [ $select_full_join -gt 0 ] ; then
                print_error='true'
                raise_buffer='true'
        fi
        if [ $select_range_check -gt 0 ] ; then
                cecho "You have had $select_range_check joins without keys that check for key usage after each row" red
                print_error='true'
                raise_buffer='true'
        fi

        ## For Debuging ##
        # print_error='true'
        if [ $join_buffer_size -ge 4194304 ] ; then
                cecho "join_buffer_size >= 4 M" boldred
                cecho "This is not advised" boldred
                raise_buffer=
        fi

        if [ $print_error ] ; then
                if [ "$major_version" = '3.23' ] || [ "$major_version" = '4.0' ] ; then
                        cecho "You should enable \"log-long-format\" "
                elif [ "$mysql_version_num" -gt 040100 ]; then
                        cecho "You should enable \"log-queries-not-using-indexes\""
                fi
                cecho "Then look for non indexed joins in the slow query log."
                if [ $raise_buffer ] ; then
                cecho "If you are unable to optimize your queries you may want to increase your"
                cecho "join_buffer_size to accommodate larger joins in one pass."
                printf "\n"
                cecho "Note! This script will still suggest raising the join_buffer_size when" boldred
                cecho "ANY joins not using indexes are found." boldred
                fi
        fi

        # XXX Add better tests for join_buffer_size pending mysql bug #15088  XXX #
}

check_tmp_tables () {

## -- Temp Tables -- ##

        cecho "TEMP TABLES" boldblue

        mysql_status \'Created_tmp_tables\' created_tmp_tables
        mysql_status \'Created_tmp_disk_tables\' created_tmp_disk_tables
        mysql_variable \'tmp_table_size\' tmp_table_size
        mysql_variable \'max_heap_table_size\' max_heap_table_size


        if [ $created_tmp_tables -eq 0 ] ; then
                tmp_disk_tables=0
        else
                tmp_disk_tables=$((created_tmp_disk_tables*100/(created_tmp_tables+created_tmp_disk_tables)))
        fi
        human_readable $max_heap_table_size max_heap_table_sizeHR
        cecho "Current max_heap_table_size = $max_heap_table_sizeHR $unit"

        human_readable $tmp_table_size tmp_table_sizeHR
        cecho "Current tmp_table_size = $tmp_table_sizeHR $unit"

        cecho "Of $created_tmp_tables temp tables, $tmp_disk_tables% were created on disk"
        if [ $tmp_table_size -gt $max_heap_table_size ] ; then
                cecho "Effective in-memory tmp_table_size is limited to max_heap_table_size." yellow
        fi
        if [ $tmp_disk_tables -ge 25 ] ; then
                cecho "Perhaps you should increase your tmp_table_size and/or max_heap_table_size" boldred
                cecho "to reduce the number of disk-based temporary tables" boldred
                cecho "Note! BLOB and TEXT columns are not allow in memory tables." yellow
                cecho "If you are using these columns raising these values might not impact your " yellow
                cecho  "ratio of on disk temp tables." yellow
        else
                cecho "Created disk tmp tables ratio seems fine" green
        fi
}

check_open_files () {

## -- Open Files Limit -- ##
        cecho "OPEN FILES LIMIT" boldblue

        mysql_variable \'open_files_limit\' open_files_limit
        mysql_status   \'Open_files\' open_files

        if [ -z $open_files_limit ] || [ $open_files_limit -eq 0 ] ; then
                open_files_limit=$(ulimit -n)
                cant_override=1
        else
                cant_override=0
        fi
        cecho "Current open_files_limit = $open_files_limit files"

        open_files_ratio=$(($open_files*100/$open_files_limit))

        cecho "The open_files_limit should typically be set to at least 2x-3x" yellow
        cecho "that of table_cache if you have heavy MyISAM usage." yellow
        if [ $open_files_ratio -ge 75 ] ; then
                cecho "You currently have open more than 75% of your open_files_limit" boldred
                if [ $cant_override -eq 1 ] ; then
                        cecho "You should set a higer value for ulimit -u in the mysql startup script then restart mysqld" boldred
                        cecho "MySQL 3.23 users : This is just a guess based upon the current shell's ulimit -u value" yellow
                elif [ $cant_override -eq 0 ] ; then
                        cecho "You should set a higher value for open_files_limit in my.cnf" boldred
                else
                        cecho "ERROR can't determine if mysqld override of ulimit is allowed" boldred
                        exit 1
                fi
        else
                cecho "Your open_files_limit value seems to be fine" green
        fi



}

check_table_cache () {

## -- Table Cache -- ##

        cecho "TABLE CACHE" boldblue

        mysql_variable \'datadir\' datadir
        mysql_variable \'table_cache\' table_cache

        ## /* MySQL +5.1 version of table_cache */ ##
        mysql_variable \'table_open_cache\' table_open_cache
        mysql_variable \'table_definition_cache\' table_definition_cache

        mysql_status \'Open_tables\' open_tables
        mysql_status \'Opened_tables\' opened_tables
        mysql_status \'Open_table_definitions\' open_table_definitions

        table_count=$($mysql -Bse "/*!50000 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' */")

        if [ -z "$table_count" ] ; then
                if [ "$UID" != "$socket_owner" ] && [ "$UID" != "0" ] ; then
                        cecho "You are not '$socket_owner' or 'root'" red
                        cecho "I am unable to determine the table_count!" red
                else
                        table_count=$(find $datadir 2>&1 | grep -c .frm$)
                fi
        fi
        if [ $table_open_cache ] ; then
                table_cache=$table_open_cache
        fi

        if [ $opened_tables -ne 0 ] && [ $table_cache -ne 0 ] ; then
                table_cache_hit_rate=$(($open_tables*100/$opened_tables))
                table_cache_fill=$(($open_tables*100/$table_cache))
        elif [ $opened_tables -eq 0 ] && [ $table_cache -ne 0 ] ; then
                table_cache_hit_rate=100
                table_cache_fill=$(($open_tables*100/$table_cache))
        else
                cecho "ERROR no table_cache ?!" boldred
                exit 1
        fi
        if [ $table_cache ] && [ ! $table_open_cache ] ; then
                cecho "Current table_cache value = $table_cache tables"
        fi
        if [ $table_open_cache ] ; then
                cecho "Current table_open_cache = $table_open_cache tables"
                cecho "Current table_definition_cache = $table_definition_cache tables"
        fi
        if [ $table_count ] ; then
        cecho "You have a total of $table_count tables"
        fi

        if  [ $table_cache_fill -lt 95 ] ; then
                cechon "You have "
                cechon "$open_tables " green
                cecho "open tables."
                cecho "The table_cache value seems to be fine" green
        elif [ $table_cache_hit_rate -le 85 -o  $table_cache_fill -ge 95 ]; then
                cechon "You have "
                cechon "$open_tables " boldred
                cecho "open tables."
                cechon "Current table_cache hit rate is "
                cecho "$table_cache_hit_rate%" boldred
                cechon ", while "
                cechon "$table_cache_fill% " boldred
                cecho "of your table cache is in use"
                cecho "You should probably increase your table_cache" red
        else
                cechon "Current table_cache hit rate is "
                cechon "$table_cache_hit_rate%" green
                cechon ", while "
                cechon "$table_cache_fill% " green
                cecho "of your table cache is in use"
                cecho "The table cache value seems to be fine" green
        fi
        if [ $table_definition_cache ] && [ $table_definition_cache -le $table_count ] && [ $table_count -ge 100 ] ; then
                cecho "You should probably increase your table_definition_cache value." red
        fi
}

check_table_locking () {

## -- Table Locking -- ##

        cecho "TABLE LOCKING" boldblue

        mysql_status \'Table_locks_waited\' table_locks_waited
        mysql_status \'Table_locks_immediate\' table_locks_immediate
        mysql_variable \'concurrent_insert\' concurrent_insert
        mysql_variable \'low_priority_updates\' low_priority_updates
        if [ "$concurrent_insert" = 'ON' ]; then
                concurrent_insert=1
        elif [ "$concurrent_insert" = 'OFF' ]; then
                concurrent_insert=0
        fi

        cechon "Current Lock Wait ratio = "
        if [ $table_locks_waited -gt 0 ]; then
                immediate_locks_miss_rate=$(($table_locks_immediate/$table_locks_waited))
                cecho "1 : $immediate_locks_miss_rate" red
        else
                immediate_locks_miss_rate=99999 # perfect
                cecho "0 : $questions"
        fi
        if [ $immediate_locks_miss_rate -lt 5000 ] ; then
                cecho "You may benefit from selective use of InnoDB."
                if [ "$low_priority_updates" = 'OFF' ] ; then
                cecho "If you have long running SELECT's against MyISAM tables and perform"
                cecho "frequent updates consider setting 'low_priority_updates=1'"
                fi
                if [ "$mysql_version_num" -gt 050000 ] && [ "$mysql_version_num" -lt 050500 ]; then
                        if [ $concurrent_insert -le 1 ] ; then
                        cecho "If you have a high concurrency of inserts on Dynamic row-length tables"
                        cecho "consider setting 'concurrent_insert=2'."
                        fi
                elif [ "$mysql_version_num" -gt 050500 ] ; then
                        if [ "$concurrent_insert" = 'AUTO' ] || [ "$concurrent_insert" = 'NEVER' ] ; then
                        cecho "If you have a high concurrency of inserts on Dynamic row-length tables"
                        cecho "consider setting 'concurrent_insert=ALWAYS'."
                        fi
                fi
        else
                cecho "Your table locking seems to be fine" green
        fi
}

check_table_scans () {

## -- Table Scans -- ##

        cecho "TABLE SCANS" boldblue

        mysql_status \'Com_select\' com_select
        mysql_status \'Handler_read_rnd_next\' read_rnd_next
        mysql_variable \'read_buffer_size\' read_buffer_size

        if [ -z $read_buffer_size ] ; then
                mysql_variable \'record_buffer\' read_buffer_size
        fi

        human_readable $read_buffer_size read_buffer_sizeHR
        cecho "Current read_buffer_size = $read_buffer_sizeHR $unit"

        if [ $com_select -gt 0 ] ; then
                full_table_scans=$(($read_rnd_next/$com_select))
                cecho "Current table scan ratio = $full_table_scans : 1"
                if [ $full_table_scans -ge 4000 ] && [ $read_buffer_size -le 2097152 ] ; then
                        cecho "You have a high ratio of sequential access requests to SELECTs" red
                        cechon "You may benefit from raising " red
                        if [ "$major_version" = '3.23' ] ; then
                                cechon "record_buffer " red
                        else
                                cechon "read_buffer_size " red
                        fi
                        cecho "and/or improving your use of indexes." red
                elif [ $read_buffer_size -gt 8388608 ] ; then
                        cechon "read_buffer_size is over 8 MB " red
                        cecho "there is probably no need for such a large read_buffer" red

                else
                        cecho "read_buffer_size seems to be fine" green
                fi
        else
                cecho "read_buffer_size seems to be fine" green
        fi
}


check_innodb_status () {

## -- InnoDB -- ##

        ## See http://bugs.mysql.com/59393

        if [ "$mysql_version_num" -lt 050603 ] ; then
        mysql_variable \'have_innodb\' have_innodb
        fi
        if [ "$mysql_version_num" -lt 050500 ] && [ "$have_innodb" = "YES" ] ; then
        innodb_enabled=1
        fi
        if [ "$mysql_version_num" -ge 050500 ] && [ "$mysql_version_num" -lt 050512 ] ; then
        mysql_variable \'ignore_builtin_innodb\' ignore_builtin_innodb
                if [ "$ignore_builtin_innodb" = "ON" ] || [ $have_innodb = "NO" ] ; then
                innodb_enabled=0
                else
                innodb_enabled=1
                fi
        elif [ "$major_version"  = '5.5' ] && [ "$mysql_version_num" -ge 050512 ] ; then
        mysql_variable \'ignore_builtin_innodb\' ignore_builtin_innodb
                if [ "$ignore_builtin_innodb" = "ON" ] ; then
                innodb_enabled=0
                else
                innodb_enabled=1
                fi
        elif [ "$mysql_version_num" -ge 050600 ] && [ "$mysql_version_num" -lt 050603 ] ; then
        mysql_variable \'ignore_builtin_innodb\' ignore_builtin_innodb
                if [ "$ignore_builtin_innodb" = "ON" ] || [ $have_innodb = "NO" ] ; then
                innodb_enabled=0
                else
                innodb_enabled=1
                fi
        elif [ "$major_version" = '5.6' ] && [ "$mysql_version_num" -ge 050603 ] ; then
        mysql_variable \'ignore_builtin_innodb\' ignore_builtin_innodb
                if [ "$ignore_builtin_innodb" = "ON" ] ; then
                innodb_enabled=0
                else
                innodb_enabled=1
                fi
        fi
        if [ "$innodb_enabled" = 1 ] ; then
                mysql_variable \'innodb_buffer_pool_size\' innodb_buffer_pool_size
                mysql_variable \'innodb_additional_mem_pool_size\' innodb_additional_mem_pool_size
                mysql_variable \'innodb_fast_shutdown\' innodb_fast_shutdown
                mysql_variable \'innodb_flush_log_at_trx_commit\' innodb_flush_log_at_trx_commit
                mysql_variable \'innodb_locks_unsafe_for_binlog\' innodb_locks_unsafe_for_binlog
                mysql_variable \'innodb_log_buffer_size\' innodb_log_buffer_size
                mysql_variable \'innodb_log_file_size\' innodb_log_file_size
                mysql_variable \'innodb_log_files_in_group\' innodb_log_files_in_group
                mysql_variable \'innodb_safe_binlog\' innodb_safe_binlog
                mysql_variable \'innodb_thread_concurrency\' innodb_thread_concurrency

                cecho "INNODB STATUS" boldblue
                innodb_indexes=$($mysql -Bse "/*!50000 SELECT IFNULL(SUM(INDEX_LENGTH),0) from information_schema.TABLES where ENGINE='InnoDB' */")
                innodb_data=$($mysql -Bse "/*!50000 SELECT IFNULL(SUM(DATA_LENGTH),0) from information_schema.TABLES where ENGINE='InnoDB' */")

                if [ ! -z "$innodb_indexes" ] ; then

                mysql_status \'Innodb_buffer_pool_pages_data\' innodb_buffer_pool_pages_data
                mysql_status \'Innodb_buffer_pool_pages_misc\' innodb_buffer_pool_pages_misc
                mysql_status \'Innodb_buffer_pool_pages_free\' innodb_buffer_pool_pages_free
                mysql_status \'Innodb_buffer_pool_pages_total\' innodb_buffer_pool_pages_total

                mysql_status \'Innodb_buffer_pool_read_ahead_seq\' innodb_buffer_pool_read_ahead_seq
                mysql_status \'Innodb_buffer_pool_read_requests\' innodb_buffer_pool_read_requests

                mysql_status \'Innodb_os_log_pending_fsyncs\' innodb_os_log_pending_fsyncs
                mysql_status \'Innodb_os_log_pending_writes\'   innodb_os_log_pending_writes
                mysql_status \'Innodb_log_waits\' innodb_log_waits

                mysql_status \'Innodb_row_lock_time\' innodb_row_lock_time
                mysql_status \'Innodb_row_lock_waits\' innodb_row_lock_waits

                human_readable $innodb_indexes innodb_indexesHR
                cecho "Current InnoDB index space = $innodb_indexesHR $unit"
                human_readable $innodb_data innodb_dataHR
                cecho "Current InnoDB data space = $innodb_dataHR $unit"
                percent_innodb_buffer_pool_free=$(($innodb_buffer_pool_pages_free*100/$innodb_buffer_pool_pages_total))
                cecho "Current InnoDB buffer pool free = "$percent_innodb_buffer_pool_free" %"

                else
                cecho "Cannot parse InnoDB stats prior to 5.0.x" red
                $mysql -s -e "SHOW /*!50000 ENGINE */ INNODB STATUS\G"
                fi

                human_readable $innodb_buffer_pool_size innodb_buffer_pool_sizeHR
                cecho "Current innodb_buffer_pool_size = $innodb_buffer_pool_sizeHR $unit"
                cecho "Depending on how much space your innodb indexes take up it may be safe"
                cecho "to increase this value to up to 2 / 3 of total system memory"
        else
                cecho "No InnoDB Support Enabled!" boldred
        fi
}

total_memory_used () {

## -- Total Memory Usage -- ##
        cecho "MEMORY USAGE" boldblue

        mysql_variable \'read_buffer_size\' read_buffer_size
        mysql_variable \'read_rnd_buffer_size\' read_rnd_buffer_size
        mysql_variable \'sort_buffer_size\' sort_buffer_size
        mysql_variable \'thread_stack\' thread_stack
        mysql_variable \'max_connections\' max_connections
        mysql_variable \'join_buffer_size\' join_buffer_size
        mysql_variable \'tmp_table_size\' tmp_table_size
        mysql_variable \'max_heap_table_size\' max_heap_table_size
        mysql_variable \'log_bin\' log_bin
        mysql_status \'Max_used_connections\' max_used_connections

        if [ "$major_version" = "3.23" ] ; then
                mysql_variable \'record_buffer\' read_buffer_size
                mysql_variable \'record_rnd_buffer\' read_rnd_buffer_size
                mysql_variable \'sort_buffer\' sort_buffer_size
        fi

        if [ "$log_bin" = "ON" ] ; then
                mysql_variable \'binlog_cache_size\' binlog_cache_size
        else
                binlog_cache_size=0
        fi

        if [ $max_heap_table_size -le $tmp_table_size ] ; then
                effective_tmp_table_size=$max_heap_table_size
        else
                effective_tmp_table_size=$tmp_table_size
        fi


        per_thread_buffers=$(echo "($read_buffer_size+$read_rnd_buffer_size+$sort_buffer_size+$thread_stack+$join_buffer_size+$binlog_cache_size)*$max_connections" | bc -l)
        per_thread_max_buffers=$(echo "($read_buffer_size+$read_rnd_buffer_size+$sort_buffer_size+$thread_stack+$join_buffer_size+$binlog_cache_size)*$max_used_connections" | bc -l)

        mysql_variable \'innodb_buffer_pool_size\' innodb_buffer_pool_size
        if [ -z $innodb_buffer_pool_size ] ; then
        innodb_buffer_pool_size=0
        fi

        mysql_variable \'innodb_additional_mem_pool_size\' innodb_additional_mem_pool_size
        if [ -z $innodb_additional_mem_pool_size ] ; then
        innodb_additional_mem_pool_size=0
        fi

        mysql_variable \'innodb_log_buffer_size\' innodb_log_buffer_size
        if [ -z $innodb_log_buffer_size ] ; then
        innodb_log_buffer_size=0
        fi

        mysql_variable \'key_buffer_size\' key_buffer_size

        mysql_variable \'query_cache_size\' query_cache_size
        if [ -z $query_cache_size ] ; then
        query_cache_size=0
        fi

        global_buffers=$(echo "$innodb_buffer_pool_size+$innodb_additional_mem_pool_size+$innodb_log_buffer_size+$key_buffer_size+$query_cache_size" | bc -l)


        max_memory=$(echo "$global_buffers+$per_thread_max_buffers" | bc -l)
        total_memory=$(echo "$global_buffers+$per_thread_buffers" | bc -l)

        pct_of_sys_mem=$(echo "scale=0; $total_memory*100/$physical_memory" | bc -l)

        if [ $pct_of_sys_mem -gt 90 ] ; then
                txt_color=boldred
                error=1
        else
                txt_color=
                error=0
        fi

        human_readable $max_memory max_memoryHR
        cecho "Max Memory Ever Allocated : $max_memoryHR $unit" $txt_color
        human_readable $per_thread_buffers per_thread_buffersHR
        cecho "Configured Max Per-thread Buffers : $per_thread_buffersHR $unit" $txt_color
        human_readable $global_buffers global_buffersHR
        cecho "Configured Max Global Buffers : $global_buffersHR $unit" $txt_color
        human_readable $total_memory total_memoryHR
        cecho "Configured Max Memory Limit : $total_memoryHR $unit" $txt_color
#       human_readable $effective_tmp_table_size effective_tmp_table_sizeHR
#       cecho "Plus $effective_tmp_table_sizeHR $unit per temporary table created"
        human_readable $physical_memory physical_memoryHR
        cecho "Physical Memory : $physical_memoryHR $unit" $txt_color
        if [ $error -eq 1 ] ; then
                printf "\n"
                cecho "Max memory limit exceeds 90% of physical memory" $txt_color
        else
                cecho "Max memory limit seem to be within acceptable norms" green
        fi
        unset txt_color
}

## Required Functions  ##

login_validation () {
        check_for_socket                # determine the socket location -- 1st login
        check_for_plesk_passwords       # determine the login method -- 2nd login
        check_mysql_login               # determine if mysql is accepting login -- 3rd login
        export major_version=$($mysql -Bse "SELECT SUBSTRING_INDEX(VERSION(), '.', +2)")
#       export mysql_version_num=$($mysql -Bse "SELECT LEFT(REPLACE(SUBSTRING_INDEX(VERSION(), '-', +1), '.', ''),4)" )
        export mysql_version_num=$($mysql -Bse "SELECT VERSION()" |
                awk -F \. '{ printf "%02d", $1; printf "%02d", $2; printf "%02d", $3 }')

}

shared_info () {
        export major_version=$($mysql -Bse "SELECT SUBSTRING_INDEX(VERSION(), '.', +2)")
        # export mysql_version_num=$($mysql -Bse "SELECT LEFT(REPLACE(SUBSTRING_INDEX(VERSION(), '-', +1), '.', ''),4)" )
        export mysql_version_num=$($mysql -Bse "SELECT VERSION()" |
                awk -F \. '{ printf "%02d", $1; printf "%02d", $2; printf "%02d", $3 }')
        mysql_status \'Questions\' questions
#       socket_owner=$(find -L $socket -printf '%u\n')
        socket_owner=$(ls -nH $socket | awk '{ print $3 }')
}


get_system_info () {

    export OS=$(uname)

    # Get information for various UNIXes
    if [ "$OS" = 'Darwin' ]; then
        ps_socket=$(netstat -ln | awk '/mysql(.*)?\.sock/ { print $9 }' | head -1)
        found_socks=$(netstat -ln | awk '/mysql(.*)?\.sock/ { print $9 }')
        export physical_memory=$(sysctl -n hw.memsize)
        export duflags=''
    elif [ "$OS" = 'FreeBSD' ] || [ "$OS" = 'OpenBSD' ]; then
        ## On FreeBSD must be root to locate sockets.
        ps_socket=$(netstat -ln | awk '/mysql(.*)?\.sock/ { print $9 }' | head -1)
        found_socks=$(netstat -ln | awk '/mysql(.*)?\.sock/ { print $9 }')
        export physical_memory=$(sysctl -n hw.realmem)
        export duflags=''
    elif [ "$OS" = 'Linux' ] ; then
        ## Includes SWAP
        ## export physical_memory=$(free -b | grep -v buffers |  awk '{ s += $2 } END { printf("%.0f\n", s ) }')
        ps_socket=$(netstat -ln | awk '/mysql(.*)?\.sock/ { print $9 }' | head -1)
        found_socks=$(netstat -ln | awk '/mysql(.*)?\.sock/ { print $9 }')
        export physical_memory=$(awk '/^MemTotal/ { printf("%.0f", $2*1024 ) }' < /proc/meminfo)
        export duflags='-b'
    elif [ "$OS" = 'SunOS' ] ; then
        ps_socket=$(netstat -an | awk '/mysql(.*)?.sock/ { print $5 }' | head -1)
        found_socks=$(netstat -an | awk '/mysql(.*)?.sock/ { print $5 }')
        export physical_memory=$(prtconf | awk '/^Memory\ size:/ { print $3*1048576 }')
    fi
    if [ -z $(which bc) ] ; then
        echo "Error: Command line calculator 'bc' not found!"
        exit
    fi
}


## Optional Components Groups ##

banner_info () {
        shared_info
        print_banner            ; echo
        check_mysql_version     ; echo
        post_uptime_warning     ; echo
}

misc () {
        shared_info
        check_slow_queries      ; echo
        check_binary_log        ; echo
        check_threads           ; echo
        check_used_connections  ; echo
        check_innodb_status     ; echo
}

memory () {
        shared_info
        total_memory_used       ; echo
        check_key_buffer_size   ; echo
        check_query_cache       ; echo
        check_sort_operations   ; echo
        check_join_operations   ; echo
}

file () {
        shared_info
        check_open_files        ; echo
        check_table_cache       ; echo
        check_tmp_tables        ; echo
        check_table_scans       ; echo
        check_table_locking     ; echo
}

all () {
        banner_info
        misc
        memory
        file
}

prompt () {
        prompted='true'
        read -p "Username [anonymous] : " user
        read -rp "Password [<none>] : " pass
        cecho " "
        read -p "Socket [ /var/lib/mysql/mysql.sock ] : " socket
        if [ -z $socket ] ; then
                export socket='/var/lib/mysql/mysql.sock'
        fi

        if [ -z $pass ] ; then
        export mysql="mysql -S $socket -u$user"
        export mysqladmin="mysqladmin -S $socket -u$user"
        else
        export mysql="mysql -S $socket -u$user -p$pass"
        export mysqladmin="mysqladmin -S $socket -u$user -p$pass"
        fi

        check_for_socket
        check_mysql_login

        if [ $? = 1 ] ; then
                exit 1
        fi
        read -p "Mode to test - banner, file, misc, mem, innodb, [all] : " REPLY
        if [ -z $REPLY ] ; then
                REPLY='all'
        fi
        case $REPLY in
                banner | BANNER | header | HEADER | head | HEAD)
                banner_info
                ;;
                misc | MISC | miscelaneous )
                misc
                ;;
                mem | memory |  MEM | MEMORY )
                memory
                ;;
                file | FILE | disk | DISK )
                file
                ;;
                innodb | INNODB )
                innodb
                ;;
                all | ALL )
                cecho " "
                all
                ;;
                * )
                cecho "Invalid Mode!  Valid options are 'banner', 'misc', 'memory', 'file', 'innodb' or 'all'" boldred
                exit 1
                ;;
        esac
}

## Address environmental differences ##
get_system_info
# echo $ps_socket

if [ -z "$1" ] ; then
        login_validation
        mode='ALL'
elif [ "$1" = "prompt" ] || [ "$1" = "PROMPT" ] ; then
        mode=$1
elif [ "$1" != "prompt" ] || [ "$1" != "PROMPT" ] ; then
        login_validation
        mode=$1
fi

case $mode in
        all | ALL )
        cecho " "
        all
        ;;
        mem | memory |  MEM | MEMORY )
        cecho " "
        memory
        ;;
        file | FILE | disk | DISK )
        cecho " "
        file
        ;;
        banner | BANNER | header | HEADER | head | HEAD )
        banner_info
        ;;
        misc | MISC | miscelaneous )
        cecho " "
        misc
        ;;
        innodb | INNODB )
        banner_info
        check_innodb_status ; echo
        ;;
        prompt | PROMPT )
        prompt
        ;;
        *)
        cecho "usage: $0 [ all | banner | file | innodb | memory | misc | prompt ]" boldred
        exit 1
        ;;
esac

Now make it executable by typing: chmod +x MyTuner.sh and run it by typing: ./MyTuner.sh

Step 4 – Update your settings accordingly

Now change your my.cnf file with the changes shown in the tuner.

That’s it, I hope this helped

Chris aka carpenox

How to – Scratch install ViciBox 11 on OpenSuSE Leap 15.5 with Asterisk 16.17.0-vici

Asterisk 18

How to – Scratch install ViciBox 11 on OpenSuSE Leap 15.5 with Asterisk 16.17.0-vici

Install Asterisk 16 on Vicidial

I have been asked to write up an article for a scratch install for ViciBox 11 on OpenSuSE Leap 15.5 with Asterisk 16.17-0-vici, so here it is.


zypper ar https://mirrorcache-us.opensuse.org/update/leap/15.5/oss/openSUSE:Leap:15.5:Update.repo
zypper ar https://mirrorcache-us.opensuse.org/repositories/devel:/languages:/perl/15.5/devel:languages:perl.repo
zypper ar https://mirrorcache-us.opensuse.org/repositories/devel:/languages:/php/openSUSE_Leap_15.5/devel:languages:php.repo
zypper ar https://mirrorcache-us.opensuse.org/repositories/devel:/languages:/python/15.5/devel:languages:python.repo
zypper ar https://mirrorcache-us.opensuse.org/repositories/home:/vicidial/openSUSE_Leap_15.5/home:vicidial.repo
zypper ar https://mirrorcache-us.opensuse.org/repositories/home:/vicidial:/vicibox/openSUSE_Leap_15.5/home:vicidial:vicibox.repo
zypper ar https://mirrorcache-us.opensuse.org/repositories/home:/zippy:/jx:/packages-ready/15.4/home:zippy:jx:packages-ready.repo



zypper ref
zypper up
zypper in dahdi*
zypper in libpri*
zypper in libedit*
zypper in net-snmp*
zypper in libjansson4*

zypper install sqlite3-devel mariadb-server mariadb make patch gcc gcc-c++ subversion 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 libnet ncurses ncurses-devel screen mysql-devel ntp mutt wget nano unzip sipsak sox libuuid-devel httpd php-common php-pdo mod_ssl perl-DBI perl-DBD-MySQL perl-Digest-HMAC perl-YAML perl-ExtUtils-ParseXS perl-NetAddr-IP perl-Crypt-SSLeay perl-Curses perl-DBD-Pg perl-Module-ScanDeps perl-Text-CSV perl-HTML-Template perl-IO-Compress perl-Text-Glob perl-Jcode perl-Test-Script perl-Archive-Tar perl-Test-Base perl-OLE-Storage_Lite perl-Archive-Zip perl-Net-Server perl-Convert-ASN1 perl perl-Compress-Raw-Zlib perl-Digest-SHA1 perl-Data-Dumper perl-Error perl-ExtUtils-CBuilder perl-Test-Tester perl-Parse-RecDescent perl-Spiffy perl-IO-Zlib perl-Module-Build perl-HTML-Parser perl-Net-SSLeay perl-Proc-ProcessTable perl-TermReadKey perl-Term-ReadLine-Gnu perl-Digest-SHA perl-Tk perl-Net-SNMP perl-Test-NoWarnings perl-XML-Writer perl-Proc-PID-File perl-Compress-Raw-Bzip2 perl-libwww-perl perl-XML-Parser perl-File-Remove perl-Parse-CPAN-Meta perl-Set-Scalar perl-Probe-Perl perl-File-Which perl-Package-Constants perl-Module-Install perl-File-HomeDir perl-Spreadsheet-ParseExcel perl-Mail-Sendmail perl-Spreadsheet-XLSX asterisk-perl perl-version perl-Crypt-DES perl-URI perl-Net-Daemon perl-IO-stringy perl-YAML-Tiny perl-HTML-Tagset perl-Socket6 perl-BSD-Resource perl-IPC-Run3 perl-Text-CSV_XS perl-Unicode-Map perl-Net-Telnet perl-PAR-Dist perl-Date-Manip perl-JSON perl-rrdtool lame screen iftop htop perl-GD gcc gcc-c++- bzip2 make libjansson-devel dahdi-linux-devel libxml2-tools libxml2-2 libxml2-devel libuuid-devel sqlite3-devel



perl -MCPAN -e 'my $c = "CPAN::HandleConfig"; $c->load(doit => 1, autoconfig => 1); $c->edit(prerequisites_policy => "follow"); $c->edit(build_requires_install_policy => "yes"); $c->commit'

cpan -i String::CRC Tk::TableMatrix Net::Address::IP::Local Term::ReadLine::Gnu Spreadsheet::Read Net::Address::IPv4::Local RPM::Specfile Spreadsheet::XLSX Spreadsheet::ReadSXC MD5 Digest::MD5 Digest::SHA1 Bundle::CPAN Pod::Usage Getopt::Long DBI DBD::mysql Net::Telnet Time::HiRes Net::Server Mail::Sendmail Unicode::Map Jcode Spreadsheet::WriteExcel OLE::Storage_Lite Proc::ProcessTable IO::Scalar Scalar::Util Spreadsheet::ParseExcel Archive::Zip Compress::Raw::Zlib Spreadsheet::XLSX Test::Tester Spreadsheet::ReadSXC Text::CSV Test::NoWarnings Text::CSV_PP File::Temp Text::CSV_XS Spreadsheet::Read LWP::UserAgent HTML::Entities HTML::Strip HTML::FormatText HTML::TreeBuilder Switch Time::Local MIME::POP3Client Mail::IMAPClient Mail::Message IO::Socket::SSL readline 

cd /usr/bin/
curl -LOk http://xrl.us/cpanm
chmod +x cpanm
cpanm -f File::Which
cpanm -f File::HomeDir
cpanm CPAN::Meta::Requirements
cpanm -f CPAN
cpanm -f DBD::mysql
cpanm User::Identity --force
cpanm YAML MD5 Digest::MD5 Digest::SHA1 Curses Getopt::Long Net::Domain Term::ReadKey Term::ANSIColor HTML::FormatText MIME::Decoder Mail::POP3Client Mail::Message Crypt::Eksblowfish::Bcrypt

### Create DB & Cron user
mysql
CREATE DATABASE `asterisk` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE USER 'cron'@'localhost' IDENTIFIED BY '1234';
GRANT SELECT,INSERT,UPDATE,DELETE,LOCK TABLES on asterisk.* TO cron@'%' IDENTIFIED BY '1234';
GRANT SELECT,INSERT,UPDATE,DELETE,LOCK TABLES on asterisk.* TO cron@localhost IDENTIFIED BY '1234';
GRANT RELOAD ON *.* TO cron@'%';
GRANT RELOAD ON *.* TO cron@localhost;
flush privileges;
exit

### Install Asterisk 16 ###
mkdir /usr/src/asterisk
wget http://download.vicidial.com/beta-apps/asterisk-16.17.0-vici.tar.gz
tar -xzvf asterisk-16.17.0-vici.tar.gz
./configure --libdir=/usr/lib64 --with-pjproject-bundled -with-jansson-bundled
make && make install && make samples && make config && make basic-pbx
/usr/share/astguiclient/start_asterisk_boot.pl

Want to upgrade to Asterisk 18? Click here

mkdir /usr/src/astguiclient
cd /usr/src/astguiclient
svn checkout svn://svn.eflo.net:3690/agc_2-X/trunk

mysql
SET GLOBAL connect_timeout=60;
use asterisk;
\. /usr/src/astguiclient/trunk/extras/MySQL_AST_CREATE_tables.sql
\. /usr/src/astguiclient/trunk/extras/first_server_install.sql
ALTER TABLE phones ALTER template_id SET DEFAULT '';
quit

/usr/src/astguiclient/trunk/install.pl
/usr/share/astguiclient/ADMIN_area_code_populate.pl
/usr/src/astguiclient/trunk/bin/ADMIN_update_server_ip.pl

nano /etc/rc.local

### paste this below: 

#!/bin/sh
#
# This script will be executed *after* all the other init scripts.
# You can put your own initialization stuff in here if you don't
# want to do the full Sys V style init stuff.

touch /var/lock/subsys/local

# OPTIONAL enable ip_relay(for same-machine trunking and blind monitoring)
/usr/share/astguiclient/ip_relay/relay_control start 2>/dev/null 1>&2

# Disable console blanking and powersaving
/usr/bin/setterm -blank
/usr/bin/setterm -powersave off
/usr/bin/setterm -powerdown

### start up the MySQL server
systemctl start mariadb.service
systemctl enable mariadb.service

### start up the apache web server
systemctl start apache2
systemctl enable apache2

### roll the Asterisk logs upon reboot
/usr/share/astguiclient/ADMIN_restart_roll_logs.pl

### clear the server-related records from the database
/usr/share/astguiclient/AST_reset_mysql_vars.pl

### load dahdi drivers
modprobe dahdi
/usr/sbin/dahdi_cfg -vvvvvvvvvvvvv

### sleep for 20 seconds before launching Asterisk
sleep 20

### start up asterisk
/usr/share/astguiclient/start_asterisk_boot.pl


############## END PASTE HERE ##################


crontab -e

### paste below:

### recording mixing/compressing/ftping scripts
#0,3,6,9,12,15,18,21,24,27,30,33,36,39,42,45,48,51,54,57 * * * * /usr/share/astguiclient/AST_CRON_audio_1_move_mix.pl
0,3,6,9,12,15,18,21,24,27,30,33,36,39,42,45,48,51,54,57 * * * * /usr/share/astguiclient/AST_CRON_audio_1_move_mix.pl --MIX
0,3,6,9,12,15,18,21,24,27,30,33,36,39,42,45,48,51,54,57 * * * * /usr/share/astguiclient/AST_CRON_audio_1_move_VDonly.pl
1,4,7,10,13,16,19,22,25,28,31,34,37,40,43,46,49,52,55,58 * * * * /usr/share/astguiclient/AST_CRON_audio_2_compress.pl --GSM
#2,5,8,11,14,17,20,23,26,29,32,35,38,41,44,47,50,53,56,59 * * * * /usr/share/astguiclient/AST_CRON_audio_3_ftp.pl --GSM

### keepalive script for astguiclient processes
* * * * * /usr/share/astguiclient/ADMIN_keepalive_ALL.pl --cu3way

### kill Hangup script for Asterisk updaters
* * * * * /usr/share/astguiclient/AST_manager_kill_hung_congested.pl

### updater for voicemail
* * * * * /usr/share/astguiclient/AST_vm_update.pl

### updater for conference validator
* * * * * /usr/share/astguiclient/AST_conf_update.pl

### flush queue DB table every hour for entries older than 1 hour
11 * * * * /usr/share/astguiclient/AST_flush_DBqueue.pl -q

### fix the vicidial_agent_log once every hour and the full day run at night
33 * * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl
50 0 * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl --last-24hours
## uncomment below if using QueueMetrics
#*/5 * * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl --only-qm-live-call-check

## uncomment below if using Vtiger
#1 1 * * * /usr/share/astguiclient/Vtiger_optimize_all_tables.pl --quiet

### updater for VICIDIAL hopper
* * * * * /usr/share/astguiclient/AST_VDhopper.pl -q

### adjust the GMT offset for the leads in the vicidial_list table
1 1,7 * * * /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl --debug

### reset several temporary-info tables in the database
2 1 * * * /usr/share/astguiclient/AST_reset_mysql_vars.pl

### optimize the database tables within the asterisk database
3 1 * * * /usr/share/astguiclient/AST_DB_optimize.pl

## adjust time on the server with ntp
30 * * * * /usr/sbin/ntpdate -u pool.ntp.org 2>/dev/null 1>&2

### VICIDIAL agent time log weekly and daily summary report generation
2 0 * * 0 /usr/share/astguiclient/AST_agent_week.pl
22 0 * * * /usr/share/astguiclient/AST_agent_day.pl

### VICIDIAL campaign export scripts (OPTIONAL)
#32 0 * * * /usr/share/astguiclient/AST_VDsales_export.pl
#42 0 * * * /usr/share/astguiclient/AST_sourceID_summary_export.pl

### remove old recordings more than 7 days old
#24 0 * * * /usr/bin/find /var/spool/asterisk/monitorDONE -maxdepth 2 -type f -mtime +7 -print | xargs rm -f

### roll logs monthly on high-volume dialing systems
#30 1 1 * * /usr/share/astguiclient/ADMIN_archive_log_tables.pl

### remove old vicidial logs and asterisk logs more than 2 days old
28 0 * * * /usr/bin/find /var/log/astguiclient -maxdepth 1 -type f -mtime +2 -print | xargs rm -f
29 0 * * * /usr/bin/find /var/log/asterisk -maxdepth 3 -type f -mtime +2 -print | xargs rm -f
30 0 * * * /usr/bin/find / -maxdepth 1 -name "screenlog.0*" -mtime +4 -print | xargs rm -f

### cleanup of the scheduled callback records
25 0 * * * /usr/share/astguiclient/AST_DB_dead_cb_purge.pl --purge-non-cb -q

### GMT adjust script - uncomment to enable
#45 0 * * * /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl --list-settings

### Dialer Inventory Report
1 7 * * * /usr/share/astguiclient/AST_dialer_inventory_snapshot.pl -q --override-24hours

### inbound email parser
* * * * * /usr/share/astguiclient/AST_inbound_email_parser.pl

################ END PASTE HERE ####################



reboot

go to http://127.0.0.1/vicidial/admin.php

I honestly have not tested this so whoever tried it please comment below any problems you had, errors or anything that was wrong. Also post if it worked without issue. Thank you

-Chris aka carpenox

P.S. – You may have to run this fix for dahdi on the latest kernel on Leap 15.5 – How to – Fix ViciBox 11 after kernel update

How to – Upgrade Asterisk 13/16 to Asterisk 18

Asterisk 18

How to – Upgrade Asterisk 13/16 to Asterisk 18

This post will go over the steps to upgrade your asterisk from 13 or 16 to Asterisk 18. It was pretty easy except for one little bug I ran into but there’s any easy fix for it. Ok so let’s get started.

Step 1 – Download Asterisk 18 to your server.

We need to get the file from the Asterisk website for version 18 which can be found at https://downloads.asterisk.org/pub/telephony/asterisk

Go to your source directory by typing “cd /usr/src/asterisk/” – If the directory doesn’t exist, create it by using mkdir.

Now locate the file you need on the asterisk website (shown below).

Time to download the file by typing “wget https://downloads.asterisk.org/pub/telephony/asterisk/asterisk-18.19.0.tar.gz”

Unzip the file and then we will begin compiling.

Step 2 – Compile Asterisk

We will need Asterisk to be patched with ViciDial changes for it to work correctly. Follow this article. To compile Asterisk, first we need to go to it’s folder by typing “cd /etc/asterisk”. Once here type the following 4 commands:

./configure

make menuselect

make && make install

Step 3 – Remove old modules

Remove the 4 files listed above from the directory it tells you. For me it was:

/usr/lib/asterisk/modules

Step 4 – Restart Asterisk

Login to asterisk and restart it by doing “core restart now”. That’s it, you’re now using Asterisk 18.

If for some reason Asterisk doesn’t start up after you restart it, type “screen asterisk vvc” and of it keeps you in the screen press control+A then control+D

How to – Setup Two Factor Authentication (2FA) on your ViciDial system

2FA

How to – Setup Two Factor Authentication (2FA) on your ViciDial system

This article will go over how to setup two factor authentication on your Vicidial system using the phone method. Later on I will add the SMS and Email methods.

Step 1 – Create the 2FA settings container

First we need to create the 2FA settings container that we will need to choose in system settings when we enable two factor authentication. Below is an example of how to setup a container for a phone call auth:

2FA settings container

Step 2 – Set an email and mobile phone on the admin user

You must make sure to add an email and mobile phone to the admin user you are saying 2FA for or you will lock yourself out of the system.

2FA requirements

Step 3 – Enable two factor authentication on system settings

The next thing we need to do is turn this feature on and set a couple variables needed for it to work. To do this go to Admin then system settings as shown below:

Two Factor authentication

Now when you hit submit, it’s going to turn on 2FA and if you didn’t set it up correctly you will be locked out of the system for good or until you fix it via MySQL with the following code:

mysql -p
> use asterisk
> UPDATE system_settings SET two_factor_auth_hours='0';

If you did everything correctly you should see this when you try to login:

Hopefully this has helped you guys set this up with less headache than I went through.

Chris aka carpenox