Tuesday 11 March 2014

How to check the number of current MYSQL connections ?

Following are the different ways to check the MYSQL Connections to the database:
The below command will show the full stat about the mysql connections :
mysql> SHOW FULL PROCESSLIST\G

To get the number of connection attempts (successful or not) to the MySQL server :
mysql> show processlist;

Following command will show the number of open connections :
mysql> SHOW STATUS WHERE variable_name = 'Threads_connected';

To find current conection status you can use the following command :
#mysqladmin extended-status | grep -wi 'threads_connected\|threads_running' | awk '{ print $2,$4}' 
 
This will show you:
Threads_connected 12
Threads_running 1

Wednesday 5 March 2014

Strict Standards: Only variables should be assigned

Strict Standards: Only variables should be assigned ... error on the website

Update the php version to php 5.3


Replace old domain name or URL with new URL in WordPress

To replace the old domain name or the URL with the new URL in the wordpress blog site, refer the following steps :

Login to the cPanel >> go to phpMyAdmin >> Select the database you want to modify >> click on the SQL

Then type the following query to execute :
To update WordPress options with the new blog location, use the following SQL command:
UPDATE wp_options SET option_value = replace(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';

After that to fix URLs of the WordPress posts and pages stored in database wp_posts table as guid field use the following SQL command:
UPDATE wp_posts SET guid = replace(guid, 'http://www.old-domain.com','http://www.new-domain.com');

Finally Use the following SQL commands to fix all internal links:

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.old-domain.com', 'http://www.new-domain.com');

Tuesday 4 March 2014

Manually remove the cPanel account from the server

Inorder to manually remove the cPanel account from the server , please follow the below steps : 
(Note: For example consider the domain name as abc.com and username of the cPanel as abc)

  • rm /var/cpanel/users/abc
  • Remove the Virtual host entry for the domain abc.com from httpd.conf
    vi /etc/httpd/conf/httpd.conf remove the site VirtualHost entry
  • rm /var/named/[domain_name].db (If you used DNS Only cPanel, you may remove zone through WHM).
  • vi /etc/userdomains (remove only the abc.com: abc entry)
  • vi /etc/trueuserdomains (remove only the abc.com: abc entry)
  • vi /etc/trueuserowners ( remove only the abc: root entry)
  • vi /etc/named.conf ( remove the following entry:
                           zone "abc.c" {
                           type master;
                           file "/var/named/abc.com.db";
                             }; )
  • vi /etc/localdomains (remove only the abc.com: abc entry)
  • /etc/valiases (remove only the abc.com: abc entry)
Please login into the mysql and follow the steps
  • #mysql
  • mysql > use mysql;
  • mysql > drop user dbuser@localhost;
                     OR
          mysql> delete from mysql.user where user=dbuser;
  • vi /var/cpanel/databases/users.db ( remove only the entry of the domain )
  • rm /var/cpanel/databases/abc.cache
  • rm /var/cpanel/databases/abc.yaml
  • vi /etc/dbowners ( remove only the abc.com: abc entry)
This will manually remove the cPanel account from the server. 

ERR_CONTENT_DECODING_FAILED

If you are getting the error as ERR_CONTENT_DECODING_FAILED while accessing the domain then add the below extension in php.ini  ++++++++...