Could not connect to server... MySQL server through socket /srv/mysql/mysql.sock

[mgarvin6026]

I cannot seem to find an answer to the issue I am having with the rPath Version of the SugarCRM appliance version 4.5.0b I have installed

I had everything up and running and was just getting started by entering 5 users and uploaded some contacts and started to learn my way around the system.

Today I logged onto the Web interface as an admin account and performed a backup of the system, I added three new users and I clicked on the update wizard. The wizard did not display anything so I gave up on that. The short story is that when I logged off as admin and tried to logon with my own account, after I attempted to log on with my account name the logon failed and my account name was replaced with admin and the system will not log me on. I get an error: Could not connect to server localhost as sugarcrm.Can't connect to local MySQL server through socket '/srv/mysql/mysql.sock' (2) --- and from this I have discovered that MySQL is not running and will not startup. I followed the instructions in the user guide to manually startup MySQl using the command: service mysqld start and I receive a FAILED error: Timeout error occurred trying to start MySQL Daemon.

When I use the command: su –l mysql -- I receive the error: Warning: cannot change directory to /var/lib/mysql: no such file or directory – bash-3.00$

I am unable to get MySQL to startup and I know that I did not move or delete any files I only made a backup.

I believe the reason my copy of MySQL will not start is because the hard disk space is used up. I had created a backup of the CRM system and since that time the MySQL server will not startup. I did a df –h and it shows 1.2G allocated and 1.2G used and 0 available. So when the SugarCRM appliance was created it was created with only 1.2G hard disk space available. I removed the backup file that was created and that did not return any space back to the system. Is this the correct reason why the MySQL server will not startup. When I do a PS -al it shows MYSQLD_safe and my processor is pegged at 100%.

Is there a way to mount an additional drive (VM) and move the MySQL DB to that new location or Is there a way to allocate more space to the VM? We are using VMware ESX and I believe it is version 3.

Thanks for any help.

[stuzenz]

I had the same issue - also on the vm. I fooled around for a bit - then thought about the allocated space for the hdd. Considering it happened when making a backup and all ....

on throwing a df -kh against the vm I found I had zero space left on the hdd. I deleted the backup, Tried to login again and all was fine.

time to quadruple the size of the vm hdd.

Hope it is as easy as this for you others with problems

regds,
Stuart

[nathanbthomas]

Yes, this is fairly common. There is a description of expanding the VM here at the bottom:

http://www.sugarcrm.com/wiki/index.p...and_User_Guide

The latest version (4.5.1d) of the vmware image that will be out tomorrow gives a much bigger free space allocation to avoid this.