Getting sick of spammers in server and IP blacklisting ? To find the spammer account in server you need to SSH to server and run below command
awk ‘$3 ~ /^cwd/{print $3}’ /var/log/exim_mainlog | sort | uniq -c | sed “s|^ *||g” | sort -nr
This will show the the path of the user account from where max email was sent in sorted order.
You can suspended the user and also check if any malicious file in the directory shown.
Getting this error on Firefox 3.x browser ? Below is the solution for this issue which does fix this issue
Clearing cache and cookies solves the problem! (Tools -> Clear Private Data; it is enough to select only cache and cookies)
Deleted or corrupted file in cpanel server for /etc/userdomains ? Use below 2 commands to by logging in as root to restore the file
# /usr/local/cpanel/bin/userdata_update
and then run
#/scripts/updateuserdomains
Having issues with cpanel Filemanager where you can write on a file with 444 permissions ? The issue is with X3 theme
. You need to modify below line in file
vi /usr/local/cpanel/base/frontend/x/files/changeperm.html
And see if you see the line:
cpanelFileman=
change it to without space
cpanelFileman=
Are you getting below error ??
Unable to remove add-on domain from cPanel – Error from Park wrapper: Sorry, you do not control the domain
Remove the entries for the domain from the following files.
====================
/var/cpanel/users/username Run Script — /scripts/updateuserdomains
/scripts/killdns domain.db
/usr/local/apache/conf/httpd.conf
/etc/localdomains
/etc/userdomains
/etc/trueuserdomains
/etc/trueuserowners
/etc/valiases/domain.com
/etc/vdomainaliases/domain.com
/etc/vfilters/domain.com
/var/cpanel/userdata/username – Remove the parked domain folders /var/cpanel/userdate/username/main
If you want to change the timezone for your webmail as per your region onn your server, please follow the below steps:
1. Log into SquirrelMail/Horde/Roundcube webmail client with the user that you would like to change the time zone for.
2. Access the following option:
In SquirrelMail:
Click on “Options” -> “Personal Information”
In Horde:
Click on “Options” -> “Global Options” -> on”Locale and Time”
In Roundcube:
Click on “Settings” -> “User Interface”
3. Select the timezone you need.
When I run the following command at mysql> I get an error which read as follows:
mysql> use dbname;
mysql> show tables;
ERROR 1018 (HY000): Can’t read dir of ‘./dbname/’ (errno: 13)
Solution to this is to set right permissions
#cd /var/lib/
chown mysql.mysql mysql -R
This fixed the issue and can run any commands on Mysql now.
Getting error in invalid number of arguments when deleting large number of files in directory ?
The error is due to bash shell has a limit of 2621440 to the number of arguments you can pass to a command. This can be verified by,
[root@hostab ~]# getconf ARG_MAX
2621440
Solution to this problem is to use the find command along with xargs,
cd to the directory where you want to delete files and run below command
find . -name ‘*’ |xargs rm
Facing issues in Virtualizor for database crash ? The mysql library is not located in normal /var/lib/mysql it located in /usr/local/emps/bin/
To repair database you need to use below command
[root@hostabc.virtualizor]# /usr/local/emps/bin/myisamchk -r *.MYI
Once completed all things should back to normal 🙂
You may have comes across situation where you have to manually edit a single file using excel or words to remove the space between words which is taking consuming and Boring 🙂
The below command can do the trick in one command to save your day
cat 116.txt | sed -e ‘s/[\t ]//g;/^$/d’ > test12
116.txt is the input file which has spaces between words
sed -e ‘s/[\t ]//g;/^$/d’ is the command to clear space in words