How to fix “fatal error: cannot allocate memory for the buffer pool” with mysql on AWS micro instance

I had a problem with an AWS Micro instance running WordPress on Ubuntu Linux where mysql would shut down randomly, at least once per week.

Looking in the error.log file I found the following error  “fatal error: cannot allocate memory for the buffer pool”  and “InnoDB: mmap(137363456 bytes) failed; errno 12

I did some research and found that an Ubuntu micro instance doesn’t have a swap file configure due to it’s low memory capacity.

TO create a swap file, type the following commands:

  1. sudo dd if=/dev/zero of=/swapfile bs=1M count=1024
  2. sudo mkswap /swapfile
  3. sudo swapon /swapfile
  4. Add this line: /swapfile swap swap defaults 0 0 to /etc/fstab

How to enable NetFlow on a Cisco router

I wanted to be able to work out how much internet bandwidth I was using via a Cisco router. To do this i needed to turn on NetFlow and then send that data to Solarwinds Network Traffic Analyzer.Here are the steps.

Log into your router.

Enter global configuration mode (configure terminal)

Enable NetFlow for each interface(in this case Dialer0) by typing: interface Dialer0

Then type: ip route-cache flow

type exit

then type (replacing xxx.xxx.xxx.xxx with the ip adderess the analyzer server) : ip flow-export destination xxx.xxx.xxx.xxx

 

 

How to fix Event ID 17182 “TDSSNIClient initialization failed with error 0x7e, status code 0×1″

I was getting this error on a Windows 2003 server with SQL 2005

Event ID 17182 “TDSSNIClient initialization failed with error 0x7e, status code 0×1″  and “TDSSNIClient initialization failed with error 0x7e, status code 0×60″

The fix for this is to disable the VIA protocol.

To do this, open up the SQL Server Configuration Manager, click on SQL Server 2005 Network Configuration , then click on Protocols for MSSQLSERVER  and then right click on VIA and choose Disable.

You should then be able to start the MSSQLSERVER service.

Handy Powershell commands for Exchange 2013

get-offlineaddressbook : this will show you all configured OAB’s

update-offlineaddressbook -identity “MY OAB” : this will update the OAB named MY OAB

get-queue  : shows the current mail queues

add-contentfilterphrase -phrase “BAD WORDS HERE” -influence badword     : This adds a subject line phrase to a ban list for SPAM

How to find the location of Jump Lists for your pinned items

Go to Run and then enter this:

%Appdata%\Microsoft\Windows\Recent\AutomaticDestinations

A folder will open containing lots of ”.automaticDestinations-ms”  files.

You can open these with notepad and edit them, or remove them to clear away broken links.

NOTE: removing the files will clear away all shortcuts from the Jump Lists.