Aarvi

Cachet install on Ubuntu 18.04

Had an opportunity an Operation Notification open source application callled Cachet Below are the steps I used to successfully complete it and get it working SSH to Ubuntu server Set up right time on server using root@status:~# sudo dpkg-reconfigure tzdata Current default time zone: ‘America/Chicago’ Local time is now:      Mon Feb 22 10:48:44 […]
Read more

Permission denied (publickey,gssapi-keyex,gssapi-with-mic).

While trying to add new user and ssh using the user login details after adding user ssh keys was getting below error Permission denied (publickey,gssapi-keyex,gssapi-with-mic) The issue was due to permissions Changing to below permissions resolved the issue chmod 0700 /home/surmeet/.ssh/ chmod 0600 /home/surmeet/.ssh/authorized_keys
Read more

Install Brotli on Apache 2.4 on cPanel

root@server /]# yum install brotli Loaded plugins: fastestmirror, getpagespeed, universal-hooks Loading mirror speeds from cached hostfile epel/x86_64/metalink | 8.6 kB 00:00:00 EA4: 208.74.123.61 cpanel-addons-production-feed: 208.74.123.61 cpanel-plugins: 208.74.123.61 base: mirrors.radwebhosting.com epel: pubmirror2.math.uh.edu extras: centos.mirror.lstn.net updates: repos.dfw.quadranet.com Resolving Dependencies –> Running transaction check —> Package brotli.x86_64 0:1.0.7-5.el7 will be installed –> Finished Dependency Resolution Dependencies Resolved Package […]
Read more

The MySQL Connection could not be established. Joomla

While instaling Joomla using softaculous was getting error The MySQL Connection could not be established Mysql was working fine   issue was with Mysql not supporting more then 16 characters in database name. in advanded setting I changed database name which resolved this issue  
Read more

Additionally, a 503 Service Unavailable error

Service Unavailable The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later. Additionally, a 503 Service Unavailable error was encountered while trying to use an ErrorDocument to handle the request. While accessing one of the website saw the error mentioned above Normally this 503 error […]
Read more

PHP Fatal error: Uncaught Error: Call to undefined function wp()

This issue is due to some core files in wordpress being corrupt. The solution to this issue is to download new version of wordpress and upload new files and folders mentioned below wp-includes , wp-admin and below files wp-activate.php wp-blog-header.php wp-comments-post.php wp-config.php wp-config-sample.php wp-cron.php wp-links-opml.php wp-load.php wp-login.php wp-mail.php wp-settings.php wp-signup.php wp-trackback.php xmlrpc.php This resolved the […]
Read more

Inoddb recovery from crash

We had a Inoddb database crash in server , Where Mysqld was not starting. So first we checked on what databases tables are crashed or corrupted using command mysqlcheck -A –all-databases and repaired it using mysqlcheck –auto-repair –all-databases You can check in below URL for additional functions using mysqlcheck https://mariadb.com/kb/en/mysqlcheck/ First thing we did was […]
Read more

How to fix innodb_table_stats and innodb_index_stats has length mismatch

While Checking Mysql error logs could see below error 2021-03-31 0:04:00 1222 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-03-31 0:04:00 1222 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-03-31 0:04:00 1222 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch […]
Read more

MySQL: Stale lock file prevents the service from starting

Attempting to start the MySQL service results in the following error: [ERROR] Unix socket lock file is empty /var/lib/mysql/mysql.sock.lock. [ERROR] Unable to setup unix socket lock file. Below were the errors in mysql error log 2021-01-06T01:29:39.630848Z 0 [Note] – ‘127.0.0.1’ resolves to ‘127.0.0.1’; 2021-01-06T01:29:39.630871Z 0 [Note] Server socket created on IP: ‘127.0.0.1’. 2021-01-06T01:29:39.630932Z 0 [ERROR] […]
Read more

admin bin cPanel/cpmysql/DBCACHE: exit 11

Currently aware of an issue when updating to MariaDB 10.3.26 or MariaDB 10.2.35. Which causes MySQL Databases interface within cPanel to display invalid errors such as, but not limited to: “The MySQL server is currently offline”. While the error in cPanel may indicate that the MySQL service is offline, it is an issue with grants […]
Read more