HereWeFix

Easy and Simple Solution

Thursday, May 27, 2021

Remove the application pools that have no domain from plesk database

Use the below command to remove the entries for application pools that have no domain-related from the Plesk database.
Solution:
1.If you have an issue on a remote server, connect your server through RDP.
2.Open the command prompt and run the below command.
DELETE i, ia FROM IisAppPools i LEFT JOIN IisAppPoolDomains ia ON i.id = ia.poolId LEFT JOIN domains d ON d.id = ia.domainId WHERE d.name IS NULL AND i.id != 1;


Unable to find row with id 1381 in domains table

The issue occurred while deleting the domain from the Plesk panel. It happens due to database inconsistency. Follow the below steps to resolve the issue.

Solution:
1.If you have an issue on a remote server, connect your server through RDP.
2.Open the command prompt and generate a backup for the Plesk database
  plesk db dump psa > C:\psa_dump.sql
3.Connect Plesk database
  plesk db
4.Check whether there is no domain associated with such ID in the Plesk database. Replace 1381 with your affected ID.
  select * from domains where id=1381;
NOTE: if you got the below output then the given ID is not available in the database.
              Empty set (0.00 sec)
5.Fix the inconsistency in the Plesk database.
  delete from IisAppPools where ownerId=1381;
6.If you disabled ModSecurity activate and check.

Find password expiry date for all users

Check all user's password expiry date except system users on Linux based system.
for user in $(cat /etc/passwd |cut -d: -f1); do echo $user; chage -l $user | grep "Password expires"; done | paste -d " "  - - | sed 's/Password expires//g' | grep -v "never"

Wednesday, May 26, 2021

find and set read only file in linux

Below command will help to find everything in /var/www/html and set to read-only.

find /var/www/html -iname "*" -print0 | xargs -I {} -0 chattr +i {}

Delete a file named NUL on windows

Error:
Unable to remove /httpdocs/nul.38vHB38iv.cer: Path is invalid

Solution:
Open a command prompt and run the below command to rename and delete the file.
Rename the suspected file: 
rename \\.\C:\inetpub\vhosts\demo.com\httpdocs\nul.38vHB38iv.cer deletefile.txt
Delete the renamed file:
del C:\inetpub\vhosts\demo.com\httpdocs\deletefile.txt

Friday, May 7, 2021

fatal sftphostkey unable to use '/etc/ssh/ssh_host_rsa_key' as host key

Due to inappropriate permission for ssh error occured. 

ERROR:
 [server@demo setupftp]# proftpd 
2014-8-14 21:08:39,896 host.serverdemo proftpd[6934]: fatal: SFTPHostKey: unable to use '/etc/ssh/ssh_host_rsa_key' as host key, as it is group- or world-accessible on line 21 of '/usr/etc/proftpd.conf'

Solution:
chmod 600 /etc/ssh/ssh_host_rsa_key
ssh-keygen -f /etc/ssh/ssh_host_dsa_key -N '' -t dsa

Error communicating with server cloudlinux

ERROR:
[server@demo]# /usr/sbin/clnreg_ks --force
An error has occurred:
Error communicating with server. The message was:
Unable to connect to the host and port specified
See /var/log/up2date for more information

Solution:
skip checking the hardware
 /usr/sbin/clnreg_ks --nohardware

Saturday, July 13, 2019

term environment variable not set ssh top

ERROR:
root@host [/etc]# top -c
TERM environment variable not set.

Solution:
export TERM=xterm

Warning: Cannot modify header information - headers already sent by

ERROR:
Warning: Cannot modify header information - headers already sent by (output started at /home/demo/public_html/contact.php:1) in /home/demo/public_html/contact.php on line 21

Solution:
Remove the whitespace that included on first line in your file.

welcome to emergency mode after logging in type journalctl

While boot your linux based system or laptop or server you will encounter this error. This issue will occur because of unused disk entry in fstab file.

ERROR:
Welcome to emergency mode! After logging in, type "journalctl -xb" to view
system logs, "systemctl reboot" to reboot, "systemctl default" or ^D to
try again to boot into default mode.
Give root password for maintenance
(or type Control-D to continue):

Solution:
1.Open fstab and check for the invalid or unused entry.
2.Remove the entry you found.
File location : /etc/fstab
3.Now try to boot your

Wednesday, January 17, 2018

No Valid CloudLinux License Found

You will get an error while open LVE Manager option on whm panel.
Error:
No Valid CloudLinux License Found
We couldn't validate your CloudLinux License since Aug 22, 17. Please, make sure your license correct.
If your server is licensed by IP, please check if your IP license valid here.
check again If you need help with your license - please, contact our support department at https://cloudlinux.zendesk.com/hc/requests/new
If you need to purchase a license, you can buy it from http://www.cloudlinux.com or contact sales@cloudlinux.com
Solution:
1.Login your server using SSH and run the following command.
/usr/sbin/clnreg_ks --force
2.Once you completed your LVE (cloudlinux) re-licensed successfully.
Real Time Analytics -->