Scenario: We upgraded from MySQL 5.1 to 5.5 (It was 4.1 in the past and possibly even 3.x before my time!). There seems to be some sort of corruption in a particular DB. The normal myisamchk and REPAIR TABLE functions didnt cut the mustard. Below are my steps to fix the issue. It appears that the Read More…
Installing and Enabling NRPE on Remote FreeBSD Server
Here are some instructions I had (from a couple of years ago may I add) to assist in setting up NRPE for remote monitoring from (eg) Nagios 1) Add nagios user. nologin 2) install nagios-plugins from ports (nagios-plugins-1.4.11,1 ) -> cd / /usr/ports/net-mgmt/nagios-plugins/ -> make -> make install 3) Set permissions -> chown Read More…
VM Reset Stuck at 95% – Esx 5.0
Scenario: We have an Ubunutu (12.0.10) VM called btn-dnsng-v1 which was not responding on an ESX 5.0 host. It was only a test VM so not entirely important. Restart Guest wasn’t available (as VMware Tools wasnt installed) so we had to do a Reset. Upon the reset the VM stuck at 95 percent and no other operations Read More…
Shrinking Transaction Logs in MSSQL 2005
Scenario: We host a lot of small databases on an Microsoft SQL 2005 server. Occasionally the transaction (.ldf) files will become extremely large so we will need to shrink them. As we only take nightly backups we are happy to make the recovery model “simple”. If you require a more mission critical backup solution then Read More…
Monitoring Storage Adapter Performance using ESXTOP
As you will see from the diagram below, this particular VMware installation is using a Software ISCSI initiator (vmhba38) Key: CMDS/s – Number of IOPS per second (READ/s + WRITE/s) and other SCSI commands such as SCSI locks, reservations, etc. These are normally nominal though compared to IOPS. MBREAD/s & MBWRTN = Self explanatory (in Read More…
Ahsay: Uploaded file size incorrect.
Scenario: One of your users suddenly starts getting an error with the message “uploaded file size incorrect” Looking at the attached logfiles we can see the file size incorrect message when trying to upload a MySQL directory (there is an argument to suggest excluding this directory and using the MySQL feature in Ahsay but the Read More…
Login Incorrect when connecting from FreeBSD to SQL Server 2008 via FreeTDS
Scenario: I wanted to connect to an SQL server 2008 from a FreeBSD 8.2 machine using PHP5.3 and FreeTDS. We have a similar set up on another server running FreeBSD 7.2 with PHP 5.2 . This is still running in production and connecting to the same DB server successfully. The logical thing to do was Read More…
Adding a static route on a QNAP
Scenario I have two QNAPS on two different sites. Both have similar setups. On each site there is a management network and storage network. I wanted to test QNAP replication by backing up over an MPLS (storage network). The only problem is that the default gateway is needed for the management network. QNAP does not allow Read More…
Rebuilding RAID after degraded disk using 3dm2 management CLI
Scenario I was using Openfiler on a reconditioned server with 6x2TB disks (4xRAID5, 2x RAID1). This was my Veeam Backup repository (via ISCSI to a pRDM). The device started playing up and was completely unresponsive. I couldnt log into the console of the openfiler server. After a hard reset it rebooted but could not find the RAID Read More…
Setup Rsync in 5 Minutes – Centos 6
Scenario: I wanted to transfer a /data folder from one server to another on Centos 6. Source is 10.0.43.2. Destination is 10.0.43.1 First of all we need to check rsync and xinetd are installed and working on the DESTINATION (receiving) server. To find out if the packages are installed type this: yum list installed Note: Read More…
You must be logged in to post a comment.