vicidial.org

mysql service wont start i am getting an error that it cant start it is telling "MySQL connect ERROR: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)" HELP

Look in the mysql log (usually /var/log/mysqld.log) for the exact error.

hope this will help you
http://striker24x7.blogspot.in/2012/02/ ... -cant.html

Thanks so much for your replys..I was able to determine that it was just a lack of hard drive space. My next question is how can i just move the informaton to another location rather than deleting it. i have a lot of recordings in .wav files and some of the old ones can be deleted but how can i specifiy what ones to delete if there are 200 GB of .wav files half of wich i need to keep in the data base but the old one i could potentially pull out and store elsewhere if possiable...please help Linux is not my forte..Thanks

Use WinSCP from a windows desktop to view,copy,delete from your server file system using the console log in details. I usually remove the ORIG file containing the wavs from /var/spool/asterisk/ because it holds calls that have already been converted to Mp3. Read the Vicidial manuals and get some Linux basics down before you put a system into production.

You can always set up an archive server to move the recordings off to vicidial system.

Quick way to automatically remove the original after conversion is to edit:
/usr/share/astguiclient/AST_CRON_audio_2_compress.pl
Add `rm "$dir2/$ALLfile"`; where I have it below. That will cause it to delete the file after it is converted to an MP3.


if ($MP3 > 0)
{
$MP3file = $FILES[$i];
$MP3file =~ s/-all\.wav/-all.mp3/gi;

if ($DB) {print "|$recording_id|$ALLfile|$MP3file| |$SQLfile|\n";}

`$lamebin -b 16 -m m --silent "$dir2/$ALLfile" "$dir2/MP3/$MP3file"`;
`rm "$dir2/$ALLfile"`;
$stmtA = "UPDATE recording_log set location='http://$server_ip/RECORDINGS/MP3/$MP3file' where recording_id='$recording_id';";
if($DBX){print STDERR "\n|$stmtA|\n";}
$affected_rows = $dbhA->do($stmtA); # or die "Couldn't execute query:|$stmtA|\n";
}

It might be a good idea to check file size of $dir2/$ALLfile before deleting it.
Lame tends to crash, rarely but does, and the output mp3 file is 0 bytes or missing. In such cases one doesn't want the input wav file deleted.