ERROR while trying to upgrade MySQL password format for Billing user.

Upgrade failed with below error:

ERROR 1133 (42000) at line 1: Can't find any matching row in the user table
ERROR 1133 (42000) at line 1: Can't find any matching row in the user table

ERROR while trying to upgrade MySQL password format for Billing user
Check the error reason(see log file: /tmp/plesk_11.0.9_installation.log), fix and try again

Such error occurs if the password for "billing" user is missing in the psa database. To fix it,

------

#insert into `user` (Host,User,Password) values ('localhost', 'billing', 'password');

#echo 'SET PASSWORD FOR "billing"@"localhost" = PASSWORD("password")'|mysql -uadmin -p`cat /etc/psa/.psa.shadow`

#echo 'GRANT ALL PRIVILEGES ON `billing`.* TO "billing"@"localhost";' | mysql -uadmin -p`cat /etc/psa/.psa.shadow`

------

Starting psa... Unable to create 'dirty' flag.

Starting of psa Failing with below error:

# /etc/init.d/psa start

Starting psa... Unable to create 'dirty' flag (/usr/local/psa/tmp/components_dirty_flag): Permission denied
System error 13: Permission denied

Solution:

# chmod 777 /usr/local/psa/tmp

Hostname change in VPS.

You can change the hostname of a VPS by changing the hostname entries in Following 3 files:

~~~~~~
/etc/hosts
/etc/sysconfig/network
/proc/sys/kernel/hostname
~~~~~~ 

Configuring Pidgin for Facebook.

1. Open Pidgin.

2. Click on Accounts –> Manage Accounts –> Add window of Pidgin.

3. Fill the following details under Basics tab:
      -Protocol: XMPP
      -Username: enter your Facebook username without the facebook.com part.
      -Domain: chat.facebook.com
      -Password: Enter your Facebook account password.
      -Tick the remember password option if you want to auto login each time you start Pidgin.
     
4. Click on the Advanced tab, and uncheck the “Require SSL/TLS” box.  Be sure that:
      -Connect port: 5222..

5. Click Add to finish the configuration process.

Now start chatting happily without opening Facebook in browser.

Important CSF commands!!!

To add IP address in to deny list csf -d xxx.xxx.xxx.xxx

To add IP address in to allow list csf -a xxx.xxx.xxx.xxx

How to restart csf firewall csf -r

How to stop csf firewall csf -x

Path of CSF configuration file on cPanel server /etc/csf/csf.conf

Path of denied IP addresses file in CSF /etc/csf/csf.deny

Path of allowed IP address file in CSF /etc/csf/csf.allow

How to add IP address in to ignorelist /etc/csf/csf.ignore

How to find IP address blocked in temporary ban grep xxx.xxx.xxx.xxx /etc/csf/csf.tempban

Configuring Pidgin for Gtalk.

1. Open Pidgin.

2. Click on Accounts –> Manage Accounts –> Add window of Pidgin.

3. Fill the following details under Basics tab:
      -Protocol: Google Talk
      -Username: enter your Google ID
       (user name without the "@gmail.com")
      -Password: Enter your gmail account password
      -Tick the remember password option.

4. Now start chatting :)