script to check MySQL password length of users. mysql -e "SELECT user, Length(Password) FROM mysql.user;" | grep -E "16" | head
Month: August 2018
MySQL upgrade issue : /etc/init.d/mysql was gone
Tried to upgrade mysql 5.0 to 5.5 and then to 5.6 after 5.5 upgrade tried 5.6 all were gone /etc/init.d/mysql was gone Fix moved the file /var/lib/mysql/RPM_UPGRADE_MARKER and then /scripts/check_cpanel_rpms --fix
Steps for assigning PHP 5.3 with FCGI handler on easyapache 4 server.
If any website scripts stringently need FCGI handler for working, you can install it from EA4 experimental Repository. Follow below steps for assigning PHP 5.3 with FCGI handler on easyapache 4 server. 1. Install ea4-experimental Repository and mod_fcgid module. === yum install ea4-experimental yum install ea-apache24-mod_fcgid.x86_64 === 2. Create a file "/etc/apache2/conf.d/php-fcgi-53.conf" with below pasted … Continue reading Steps for assigning PHP 5.3 with FCGI handler on easyapache 4 server.
libxml2.so.2: cannot open shared object file: No such file or directory
We are getting "libxml2" error message while performing upcp on the server. Fix The issue can been corrected by creating the following symlink: ln -s /opt/xml2/lib64/libxml2.so.2 /usr/lib64/libxml2.so.2
Unable to start cxs Watch daemon: /proc/sys/fs/inotify/max_user_watches is set too low [currently:8192]. You need to have your VPS provider increase this value.
If you are facing issue with the CXS in VPS server with the mentioned error you can correct this by increasing the value. Fix vzctl exec CTID echo fs.inotify.max_user_watches=xxxxx | tee -a /etc/sysctl.conf && sudo sysctl -p where CTID represent ID of the VE. xxxxx represent a higher value than the error.
To create 10 MB image file in linux
To create a 10 MB file in Linux you can use following command. dd if=/dev/zero of=test.img bs=1024 count=0 seek=$[1024*10]
To change permission of files and folders under public_html
To change permission of folders and files under the public_html of a domain at once we can use the following script. find ./ -type d -exec chmod 755 {} \; find ./ -type f -exec chmod 644 {} \;
CDP agent hcp driver not loaded into kernal
Fix Run the following command in the server and restart cdp-agent. r1soft-setup --get-module /etc/init.d/cdp-agent restart
To delete the mails older than 30 days
/usr/bin/archivemail --quiet --delete --days 30 /home/{USER}/mail/inbox
Enable and install iptables in centos 7
If you need to disable firewalld and use iptables in server use the following steps. First, stop and mask the firewalld service: systemctl stop firewalld systemctl mask firewalld Next, install the iptables-services package and enable the service to start at boot: yum install iptables-services systemctl enable iptables Then, saving the firewall rules can be done … Continue reading Enable and install iptables in centos 7