find /home -name error_log -type f -size +5000k -exec ls -lh {} \; | awk '{ print $9 ": " $5 }'
linux find bigger than
Leave a reply
Monthly Archives: March 2016
Unknown collation: ‘utf8mb4_unicode_c
Its means you are running MySQL 5.1 or lower version and need upgrade.
webmin upgrade mysql 5.1 to 5.7
yum install http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm
Dependencies Resolved
=============================================================================================================================================================================================================================================
Package Arch Version Repository Size
=============================================================================================================================================================================================================================================
Installing:
mysql57-community-release noarch el6-7 /mysql57-community-release-el6-7.noarch 7.8 k
Transaction Summary
=============================================================================================================================================================================================================================================
Install 1 Package(s)
Total size: 7.8 k
Installed size: 7.8 k
Please backup all databases before upgrading:
yum update mysql
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement
mysql> SET PASSWORD = PASSWORD(‘new_password’);
Fatal error: mysql.user table is damaged. Please run mysql_upgrade
mysqld_safe –skip-grant-tables –user=root &
mysql_fix_privilege_tables
pkill mysqld
/etc/init.d/mysqld restart
Or maybe clean database file reinstall if first suggestion not working:
2016-03-23T12:23:41.909337Z 0 [ERROR] Fatal error: mysql.user table is damaged. Please run mysql_upgrade.
2016-03-23T12:23:41.909405Z 0 [ERROR] Aborting
mysql_upgrade
mysql_upgrade: Got error: 2002: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) while connecting to the MySQL server
Not working? Still:
mysql
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
Maybe?
mysql_install_db
[WARNING] mysql_install_db is deprecated. Please consider switching to mysqld –initialize
mv /var/lib/mysql /var/lib/mysql___
mysqld –initialize –explicit_defaults_for_timestamp –user=mysql
2016-03-23T12:29:58.232282Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-03-23T12:29:58.343355Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-03-23T12:29:58.398447Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: f4c53304-f0f2-11e5-bb28-f6d02e74bd56.
2016-03-23T12:29:58.398839Z 0 [Warning] Gtid table is not ready to be used. Table ‘mysql.gtid_executed’ cannot be opened.
2016-03-23T12:29:58.399354Z 1 [Note] A temporary password is generated for root@localhost: **********
Now restore database from: /var/lib/mysql___ or sql dump backups.
You can face this issue after MySQL server upgrade. So you need backup all database before upgrading anything.
Cpanel::Exception::DomainDoesNotExist/(XID nkjvk4) The domain “somedomain.com” does not exist.
grep somedomain.com /etc/userdomains
Warning: service(imap-login): process_limit reached, client connections are being dropped
service imap-login {
inet_listener imap {
port = 143
}
service_count = 0 # performance mode. set to 1 for secure mode
process_min_avail = 1
}
ERROR: NotifyClamd: Can’t find or parse configuration file /etc/clamd.conf
yum install clamd
InnoDB: Waiting for the background threads to start
innodb_force_recovery=3
innodb_purge_threads=0
/dev/ploop: UNEXPECTED INCONSISTENCY; RUN fsck MANUALLY
ploop check -F /vz/private/139/root.hdd/root.hdd
ploop mount /vz/private/139/root.hdd/DiskDescriptor.xml
fdisk -l /dev/ploop56824
e2fsck /dev/ploop56824p1
vzctl start 139
centos 6.7 unrar
wget http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
rpm -i rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
yum install unrar -y
unrar x
Refusing to start because log directory /usr/local/cpanel/logs is not writable
Check: df -h
W: There is no public key available for the following key IDs:
W: There is no public key available for the following key IDs:
9D6D8F6BC857C906
W: There is no public key available for the following key IDs:
7638D0442B90D010
Fix:
apt-key adv –keyserver keyserver.ubuntu.com –recv-keys 9D6D8F6BC857C906
apt-key adv –keyserver keyserver.ubuntu.com –recv-keys 7638D0442B90D010
mysql check if cache is enabled
mysql -e “show variables like ‘query_cache_size’;”
directadmin disable brute force messages
echo "hide_brute_force_notifications=1" >> /usr/local/directadmin/conf/directadmin.conf