Audio Store is Just A White Box

I encountered the "plain white box" error upon clicking any link in the administration which mentions "audio chooser". I also mysteriously found that by clicking this and having the white box issue, the disk space runs out quickly and I have to delete the logs.

By following the instructions here, I was able to fix the problem.
http://striker24x7.blogspot.com/2014/06/vicidial-goautodial-audio-store-white.html

Turns out, the directory that Vicidial was pointing to did not exist. I needed to create the folder and made sure the permissions were okay.

Now, upon clicking the Audio Chooser, this pops up!

P.S. Striker 24x7 - I <3 you!

There is a time synchronization problem with your system [Unsolved]

While calls were happening, the system stopped calling. The error message was "There is a time synchronization problem with your system, please tell your system administrator".

It could be a number of errors, but according to our provider, it was because our RAM wasn't working anymore. The server was 2 years old and was used every weekday since then.

When I replaced the RAM, it was working again for a while. But then the problem came back.

Until now, I still don't know why the error happens and I haven't been able to get back to it.

No MySQL.sock because Root Partition is 100% Full

Last week our Vicidial Server crashed and our agents couldn't make calls anymore. After restarting the server and trying to do the ol' rename-mysql.sock solution, I found that the mysql.sock file was missing. What gives??!

When I try to access the agent page in Vicidial, the error was: "MySQL connect ERROR: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)". Normally, I would follow the process of renaming or deleting the existing mysql.sock file then restart the mysql service. However, this time, there was no mysql.sock. (Impt: Please DO NOT delete the mysql! They are not the same as mysql.sock!)

After checking with the provider, turns out that the root partition is already full. Here are the steps that the provider gave to resolve the issue.

Steps and SSH commands:

1. Find out how much space you have left.
   SSH Command: df -h
   In the Admin Page, go to "Reports" and scroll down and look for "Disk". It should provide the percentage of use.
2. Delete unwanted files. In this case, you can delete the .WAV duplicates. It won't delete your .MP3 recordings.
   SSH Command:
   rm -f /var/spool/asterisk/monitorDONE/ORIG/*.wav
   rm -f /var/log/httpd/*
3. Restart the server via SSH. Do not just push the power button or pull the plug.
   SSH Command: sudo reboot

And there you go! If that still doesn't work but you have the mysql.sock file already, follow the old process of renaming or deleting the existing mysql.sock file then restart the mysql service. 

Using a Back-up Vicidial Server

As part of risk management of operations, there may be times when your main Vicidial Server conks out. Because I want to be proactive and not get caught with my pants down, I got a second Vicidial Server.

I want to share with you what I do.

First, I do a MySQL dump of the primary server then upload the MySQL back-up to the secondary server. For me, it's not mission-critical to have an exact duplicate, so I just do this weekly. For some, they may prefer to do this hourly or daily. 

Second, since my primary and secondary server do not have the same IP address, I do the IP-address-update command ("/usr/share/astguiclient/ADMIN_update_server_ip.pl") in Linux SSH. The mysql-migration will copy the primary server's IP address in the mysql database to the secondary server, so it's important to adjust it back to the correct IP address.

These 2 steps can be created as batch-jobs so you don't have to manually do this if you prefer.

There you have it! Hope this was helpful.

ERROR: sounds_list CENTRAL SOUND CONTROL IS NOT ACTIVE:

I'm setting up an inbound campaign and I wanted to use a recording we made for our voice mail. When selecting the audio-chooser, I encountered this message when I was selecting an audio-prompt for when there's nobody available to answer.

"ERROR: sounds_list CENTRAL SOUND CONTROL IS NOT ACTIVE:"

Steps to Fix:

1. Go to Admin >> System Settings
2. Change the following items:
   - "Central Sounds Control Active" and select "1" instead of "0".
   - "Allow Voicemail Greeting Chooser" and set to "1"
   - "Sounds Web Server" to whatever IP address you are currently using. Make sure it's not the default "127.0.0.1".
3. Click on the Audio Store in the Admin System Settings in the left menu. The most striking message there should be "We STRONGLY recommend uploading only 16bit Mono 8k PCM WAV audio files(.wav) "
4. Upload the audio file for the recording.
5. Go to the voice mail entry and there will be an option for "Voicemail Greeting" with "audio chooser" at the right side. Click on "audio chooser" and select the .wav file you just uploaded.

Source:

• http://www.eflo.net/VICIDIALforum/viewtopic.php?t=23888
• http://www.eflo.net/VICIDIALforum/viewtopic.php?t=9724
• http://www.eflo.net/VICIDIALforum/viewtopic.php?t=20786

MySQL Connect Error in Vicidial

Because my UPS failed, my Vicidial Server did not get to shutdown properly when the power flickered for a second. This caused the MySQL error and I can't get past anything after clicking "Agent" or "Administration".

Here's what I did in the Linux Command Line:

mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.bak
service mysqld start

After that, it was okay. Keep this piece of code close to you, if you expect power outages to happen... or if you're too lazy to use "sudo poweroff". See reason for this code at the source from stackoverflow.com

Update:

• Make sure when you use MV to rename the file, you don't use a name that already exists. For the 2nd time this happened, I renamed it to mysql1.sock.bak
• I also had another incident where the mysql.sock did not exist. Turns out, my root was already 100% capacity. View post here: http://simplevicidial.blogspot.com/2016/04/no-mysqlsock-because-root-partition-is.html

Source: http://stackoverflow.com/questions/20407292/centos-another-mysql-daemon-already-running-with-the-same-unix-socket

Changing the Static Internal Network IP Address of the Vicidial Server | Sorry, there are no available sessions

We did a revamp of the entire office network, so the old internal network IP addresses had to change. When the vendor installed our Vicidial Server, he preset it with the old one. 

Here's how I did the changes (2 important steps):

1. In Linux Shell Scripting Command Line, type the following:

sudo ifconfig eth0 <new IP address> netmask 255.255.255.0

Check afterwards if the IP address has been updated by typing:

ifconfig

Source:  http://www.howtogeek.com/118337/stupid-geek-tricks-change-your-ip-address-from-the-command-line-in-linux/


2. Next, still in Linux Shell Scripting Command Line, type the following to change the same IP address in the Vicidial Database:

/usr/share/astguiclient/ADMIN_update_server_ip.pl

After that, just follow the prompts. What I did was to keep pressing Enter and it knew what IP address was the old one and which one was the new one.

This second step is important, because it will re-point the Vicidial Database internal network IP addresses to the new one. If you forget to do this, you'll get the error "Sorry, there are no available sessions" when you log in as an agent.

Source: http://striker24x7.blogspot.com/2014/01/sorry-there-are-no-available-sessions.html