Error in Kloxo: Could not open database connection

You may get the below error while trying to access Kloxo Control Panel

"Could not open database connection" 

You can fix this by two ways, 

Fix 1:

Open your phpMyAdmin http://ip:7778/thirdparty/phpMyAdmin and enter the Root Login details.

Select the "Privileges"

Locate Kloxo  and select "Edit Privileges"

Click "Check All " options

Next, Go to the Bottom of the Page and select "password" and enter the password. 

Then Click "Go"

Thats it!!. Now Kloxo should work fine.

Fix 2:

mysql -u root -p

mysql> grant all on kloxo.* to kloxo@localhost identified by '{new password}';

mysql> flush privileges;

mysql> quit

cat "{new password}" > usr/local/lxlabs/kloxo/etc/conf/kloxo.pass

sh /script/restart

ERROR! MySQL is running but PID file could not be found

You may get the below Error:

[root@server ~]# /etc/init.d/mysql status
ERROR! MySQL is running but PID file could not be found

Fix:

1.Check for mysql directory:
[root@server ~]# ll /var/run/mysql
ls: /var/run/mysql: No such file or directory

2.Create a mysql directory:
[root@server ~]# mkdir /var/run/mysql

3.Enter into the created directory:
[root@server ~]# cd /var/run/mysql/

4.Create the mysqld process id:
[root@server mysql]# touch mysqld.pid

5.Changing the ownership of mysqld.pid
[root@server mysql]# chown mysql:mysql mysqld.pid

6.Restart the MySQL:
[root@server mysql]# /etc/init.d/mysql restart
 ERROR! MySQL manager or server PID file could not be found!
Starting MySQL..................................................................                                                                     .................................. SUCCESS!


7.Check the Status of MySQL:
[root@server mysql]# /etc/init.d/mysql status
 SUCCESS! MySQL running (1583)
Thats it!!!