MySQL MariaDB key_buffer_size

To optimize the key_buffer_size, you need to review the key_read statistics: MariaDB [(none)]> SHOW STATUS LIKE “key%”; +————————+———+ | Variable_name          | Value   | +————————+———+ | Key_blocks_not_flushed | 0       | | Key_blocks_unused      | 1428301 | | Key_blocks_used        | 4187    | | Key_blocks_warm        | 0       | | Key_read_requests      | 82847   | | Key_reads              | 4187    | | ...

FreeBSD – Upgrade Perl Version

To upgrade the version of Perl installed on a FreeBSD server: vi /etc/make.conf Add this line (adjust for Perl version): DEFAULT_VERSIONS+=perl5=5.22 Execute on command line (adjust for Perl version): pkg set -o lang/perl5.16:lang/perl5.22 Execute on command line (adjust for Perl version): portupgrade -o lang/perl5.22 -f perl-5.16.\* Execute on command line: portupgrade -rf perl*

Interspire Email Marketer Can’t Login

You all of the sudden cannot login to Interspire Email Marketer. You are entering the correct password and the login screen refreshes when you enter the correct login details but will not allow access to the admin panel. Your problem is the session cannot be saved. Check your php.ini file to ensure the location for ...

XymonQV – Xymon Android App

XymonQV - Xymon Android App
Upon purchasing a new phone, I discovered that XymonQV was no longer in the Google Play store and the link on GitHub was 404. I was able to export the installed app from an old phone. If you need the XymonQV Android App, you download it here:   XymonQV Android App This is a copy of ...

Stolen Motorola Moto G Second Generation

Dual SIM Motorola Moto G Second Generation IMEI:  353326061401933 IMEI:  353326061401941 The phone was stolen in France. Police report on file.

SSHD mm_request_send: write: Broken pipe

You are attempting to login to a Linux machine (probably CentOS) and your SSH sessions are instantly disconnected. /var/log/secure shows various Signal 15 crashes and this error: mm_request_send:  write:  Broken pipe Your box has been hacked.    Format and Reinstall. Be sure to run “yum update” at frequent intervals to keep your servers/VMs up-to-date!!     ...

Connect Error (2000) mysqld cannot connect to MySQL 4.1+ using old authentication ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused

You are receiving these errors: Connect Error (2000) mysqld cannot connect to MySQL 4.1+ using old authentication ERROR 1275 (HY000): Server is running in –secure-auth mode, but ‘dbname’@’localhost’ has a password in the old format; please change the password to the new format ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option ...

Windows 2012 R2 SYSTEM_THREAD_EXCEPTION_NOT_HANDLED (xen.sys)

Windows 2012 R2 SYSTEM_THREAD_EXCEPTION_NOT_HANDLED (xen.sys)
      You are trying to start a Windows 2012 R2 server on a VMware infrastructure. What you do (or don’t) realize is that this VM is heavily tainted by a Citrix Xen basket of fun.   Procedure to fix this tediosity:  Snapshot the VM Boot into Safe Mode Open Device Manager (Show Hidden ...

Convert squid log timestamps to human readable

Convert squid log timestamps to a human readable format: cat access.log | perl -p -e 's/^([0-9]*)/"[".localtime($1)."]"/e'

Call “HostFirewallSystem.UpdateRuleset” for object firewallSystem

This error occurs when there is a problem with an IP in one of the services located in ESXi firewall. The IPs entered into the GUI will all look correct and you have exhausted all possibility. The root cause is usually that you have entered individual IPs in CIDR format with a /32.   ESXi does ...