[MySQL/MariaDB/CentOS 7] mysqldump: Couldn’t execute XXXXX (Errcode: 24 “Too many open files”) (23)

MySQL/MariaDB will sometimes hit its open file limit when doing large mysqldump operations. On a lot of distributions you can raise the limit by adding the following line to the /etc/my.cnf file and restarting the service: open_files_limit=XXXX This doesn’t work on systemd controlled database services so you need to add the following lines to /etc/systemd/system/mariadb.service.d/limits.conf […]

[Linux/quotacheck] quotacheck: Cannot stat directory //var/spool/exim_incoming/scan/1erAzg-0007eX-E1: No such file or directory

When running quotacheck on a filesystem that isn’t read only it will error out and not finish if it’s unable to stat a certain file or directory. It does this because it assumes that there’s a problem with the filesystem. If your mail software is actively processing mail when running quotacheck it will get an […]

[OpenVZ/KVM/CentOS 7] No login prompt on boot

When converting CentOS 7 OpenVZ systems to KVM sometimes there is no login prompt after loading services. The machine is otherwise operating correctly. Here’s the fix to get the login prompt back: mv /etc/systemd/system/getty.target.wants/getty\@tty2.service /etc/systemd/system/getty.target.wants/getty\@tty1.service Afterwards the keyboard input may not work. Rebuilding the initial ramdisk will fix that: dracut -f

[RHEL 7/CentOS 7] Hanging Boot After Conversion to RAID1 (degraded RAID)

Quick fix… Rebuild the ramdisk. If you are using a rescue disk and are compiling for a different kernel version replace $(uname -r) with your kernel version: dracut –mdadmconf –fstab –add=”mdraid” –filesystems “xfs ext4 ext3 tempts devotes syses proc” –add-drivers=”raid1″ –force /boot/initramfs-$(uname -r) $(uname -r) Add the following to /etc/default/grub inside the quotes for the […]

[OS X Sierra] LSOpenURLsWithRole() failed with error -10810

Some newer version of OS X aren’t very verbose when it comes to security restrictions when trying to run a program that’s been downloaded. It may appear to crash and you can try to run it from the command line with: # open ./downloadedpackage.app That will get you the error: LSOpenURLsWithRole() failed with error -10810 for […]

[SQL Server] Database Mirroring login attempt by user ‘DOMAIN\SERVER$.’ failed with error. ‘Connection handshake failed. The login ‘DOMAIN\SERVER$’ does not have CONNECT permission on the endpoint. State 84.’.

When setting up mirroring (and witnessing) among SQL Server instances when the servers are configured using Active Directory it will automatically try to auth using the ID of the server. You need to grant CONNECT permissions on the endpoint on each server for the other server that will be connecting to it (or two if […]