The Shell Guru - Page 2 of 20 - TheShellGuru provides the best in-depth tutorials for Linux, Mac OSX and Windows. Learn to utilize your server, or fix that pesky problem yourself!

check mysql / mariadb table for primary key

Uncategorized
January 25, 2021

mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists

We got this error on a server we were tasked with for recovery MySQL server’s root password: mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists The fix for this turns out to be pretty straight forward, the directory it complains about doesn’t exist. Create the directory and all is…

MySQL
January 7, 2021

Row size too large (> 8126). Changing some columns to TEXT or BLOB… | Mysql / MariaDB

We recently migrated a client website to a new server and encountered the following error when trying to import their database: ERROR 1118 (42000) at line 2663: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row…

CentOS
January 7, 2021

Unable to register authentication agent. Cannot determine user of subject Error registering authentication agent.

We’re running Atomicorp’s Workload Security, previous known as Atomic Secure Linux, and have started getting the following error whenever we restart any service. ** (pkttyagent:112415): WARNING **: 12:49:43.934: Unable to register authentication agent: GDBus.Error:org.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject Error registering authentication agent: GDBus.Error:org.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject (polkit-error-quark,…

Uncategorized
December 15, 2020

upstream timed out (110: Connection timed out) while reading response header from upstream, client: X.X.X.X | 504 Gateway Timeout

This error indicates that there is a problem with communication between the Nginx server and the backend server it is proxying to. upstream timed out (110: Connection timed out) while reading response header from upstream, client: X.X.X.X | 504 Gateway Timeout From the error we can gather that the backend…

General Linux
November 12, 2020

GoAccess – Missing development files for the GeoIP library

GoAccess is a web log viewer and analyzer, it also parses logs in realtime. This comes specially handy when you need to understand the traffic your server is getting. While installing GoAccess on a new server we got the following error: configure: error: *** Missing development files for the GeoIP…

General Linux
November 5, 2020

How to convert CER to PFX | SSL Certificates

We recently had to deploy a wildcard SSL certificate to an Microsoft Azure web app. The company we buy our certs from, issues them in .crt format by default, we have to convert them to .pfx ourselves. This isn’t a big deal and we’re going to see how to do…

MySQL
October 14, 2020

MySQL / MariaDB: Disable strict mode | Upgrading to MariaDB 10.2

We recently needed to upgrade a server from MySQL 5.7 to MariaDB 10.3 and one of the key steps in doing so is to disable strict mode after the upgrade. By default, MariaDB enables strict mode from version 10.2 and onwards. Having this enabled can cause various issues, a few…

Uncategorized
October 7, 2020

Requires: kernel(posix_acl_valid) = 0x7add44b5

We got this error when trying to install ZFS on a server recently: Error: Package: kmod-zfs-0.7.13-1.el7_6.x86_64 (zfs-kmod) Requires: kernel(posix_acl_valid) = 0x7add44b5 Installed: kernel-3.10.0-1127.19.1.el7.x86_64 (@updates) kernel(posix_acl_valid) = 0xc89bfa92 Available: kernel-3.10.0-1127.el7.x86_64 (base) kernel(posix_acl_valid) = 0xc89bfa92 Available: kernel-3.10.0-1127.8.2.el7.x86_64 (updates) kernel(posix_acl_valid) = 0xc89bfa92 Available: kernel-3.10.0-1127.10.1.el7.x86_64 (updates) kernel(posix_acl_valid) = 0xc89bfa92 Available: kernel-3.10.0-1127.13.1.el7.x86_64 (updates) kernel(posix_acl_valid) =…

CentOS
September 24, 2020

configure: error: could not find required sqlite3 library

We were faced with this error while trying to install vnstat from source on one of our servers. checking for sqlite3_prepare_v2 in -lsqlite3... no configure: error: could not find required sqlite3 library As to what this error is about, well SQLite is a small, fast, self-contained, high-reliability, full-featured, SQL database engine. It is used…

MySQL
September 17, 2020

View ‘sys.host_summary’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

We’re running cPanel with MariaDB 10.2 on one of our servers and during a complete database dump we ran into this error: mysqldump: Got error: 1356: "View 'sys.host_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them" when using LOCK TABLES We used…