Tags: Load balancing via DNS is achieved by assigning more than one IP address to the same name. For example, to balance the load on http requests for the site example.com, we would add more than one IP address, say 3, to the site. So the site can be accessed with any of the IP address. […]
Author Archive
December 12th, 2011
WhoIS Domain Name Status Codes
What does the Status of my Domain name mean ? There are 23 domain name status codes that you may come across when using WHOIS. Most of these domain name status codes are variations of a few basic states. The following is a complete list of domain name status codes along with explanations/definitions for each […]
December 9th, 2011
MySQL Socket Error in phpMyAdmin
While accessing phpMyAdmin, you may get the following error. #2002 – The server is not responding (or the local MySQL server’s socket is not correctly configured) This is due to the missing socket file in the location /tmp. The socket path which is specified in the phpMyAdmin configuration file is /tmp/mysql.sock. $ vi /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php cfg[‘Server’][‘socket’] […]
December 9th, 2011
phpMyAdmin Error: Cannot start session without errors
If we get an error given below while accessing phpMyAdmin. Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly. Inference By looking into the error, we expect that there can be error in writing session files. Either the owner do not have […]
December 9th, 2011
PhpMyAdmin error – “The local MySQL server’s socket is not correctly configured”
First of all check whether MySQL is running or not using the following command: ps uax | grep mysql If MySQL is running then, find the location of the socket file created by MySQL. Most probably it will be at “/var/lib/mysql/mysql.sock“. But when PHP communicates with MySQL server in the same host, it uses a […]
December 9th, 2011
Warning message in PhpMyAdmin after upgrading MySQL version to 5 In cPanel server.
In cPanel server after upgrading MySQL version to 5, PhpMyAdmin shows a warning message as given below Your PHP MySQL library version 4.1.22 differs from your MySQL server version 5.0.45 CPanel’s internal PHP is not compiled with MySQL 5. That is why you are facing this issue. In order to fix this, perform the following […]
December 9th, 2011
Using encrypted passwords in mysql
It is a good idea to store passwords in encrypted forms in mysql databases. Function MD5() is a good option to encrypt the passwords. You can use this function in the mysql codes to encrypt the passwords. There may be some situations that we may need to reset the password stored in encrypted form, then […]
December 9th, 2011
InnoDB: Operating system error number 13 in a file operation.
You might come across with following error while starting mysql. ———————————– 071027 7:43:13 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: ‘open’. InnoDB: Cannot continue operation. 071027 07:43:13 mysqld ended […]
December 9th, 2011
Disk full error in MySQL logs
Disk full error in MySQL logs. ——————- 81218 14:53:40 [ERROR] /usr/libexec/mysqld: Disk is full writing ‘/tmp/#sql_5047_21.MYI’ (Errcode: 28). Waiting for someone to free space… Retry in 60 secs ——————- This occurs when /tmp runs out of space. Check the size of /tmp partition. It should be atleast 3 times as the size of largest table. […]
December 9th, 2011
Unable to start Mysql after its Downgrade
This issue usually happens after the mysql downgrade from version 5 to 4. The error will be like: ERROR 2002: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) If you check further, you can see charset issue related with mysql (charset #83) in the /var/lib/mysql/HOSTNAME.err file. You can fix this issue by appending the below line in […]
