MySQL MariaDB key_buffer_size

~ admin

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    |
| Key_write_requests     | 76      |
| Key_writes             | 76      |
+————————+———+
8 rows in set (0.00 sec)

Key_read_requests should be at a ratio of 100:1 or 1000:1 to key_reads.

 

 

FreeBSD – Upgrade Perl Version

~ admin

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

~ admin

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 sessions is writable/exists.

Also check /var/lib/php/sessions (CentOS)

Once your sessions can be written to disk, you will be able to login.

XymonQV – Xymon Android App

~ admin

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 the app that was installed from the Google Play store and has not been modified in any way.

 

 

SSHD mm_request_send: write: Broken pipe

~ admin

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

~ admin

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 'secure_auth' enabled)
ERROR 1372 (HY000): Password hash should be a 16-digit hexadecimal number

Your system is definitely storing passwords in the new format.     You are going crazy because your database is offline.

UPDATE mysql.user SET Password = PASSWORD(‘cheese’) WHERE User = ‘test’ AND Host = ‘localhost’;
UPDATE mysql.user SET plugin = ‘mysql_native_password’ WHERE User = ‘test’ AND Host = ‘localhost’;
flush privileges;

Windows 2012 R2 SYSTEM_THREAD_EXCEPTION_NOT_HANDLED (xen.sys)

~ admin
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:

  1.  Snapshot the VM
  2. Boot into Safe Mode
  3. Open Device Manager (Show Hidden Devices)
  4. Go through each section and delete all Xen devices (yes, to delete driver)
  5. Reboot.   The machine should boot normally without safe mode.
  6. Control Panel -> Remove Programs
  7. Remove ALL of the Citrix programs and drivers
  8. Install VMware tools

You have just been saved hours of agony.

Are you looking to migrate your XEN VMs to VMware? Contact VMDK Hosting.

Call “HostFirewallSystem.UpdateRuleset” for object firewallSystem

~ admin

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 not like this.

How to correct the problem:

1)  SSH to the ESXi host and edit /etc/vmware/esx.conf

2) Remove the /32 from all IP entries for the firewall (see below).   Be sure to leave all larger CIDR annotations in place (/24, /27, /28, /16, etc.)

3) Reboot!

 

/firewall/services/webAccess/allowedip[0000]/ipstr = “192.168.10.10/32”  <- Bad Entry – remove the /32
/firewall/services/webAccess/allowedip[0001]/ipstr = “10.10.20.0/24”  <- Good Entry