URGENT Mysql service won't start

[Cj4life24]

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

[Vince-0]

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

[striker]

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

[Cj4life24]

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

[Vince-0]

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.

[Arative]

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

[Acidshock]

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";
}

[okli]

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.