Posts Tagged ‘ mysql ’

Mysql regularily crashing – Cannot allocate memory for buffer pool

Sep 15th, 2016 | By

So every day now on one of my Debian servers, Mysql is crashing with the following message: Fatal error: cannot allocate memory for the buffer pool 160915 6:38:10 [ERROR] Plugin ‘InnoDB’ init function returned error. 160915 6:38:10 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed. 160915 6:38:10 [ERROR] Unknown/unsupported storage engine: InnoDB 160915 6:38:10
[continue reading…]



Migrating away from postfix/dovecot to Zimbra 8 on a Debian 6 server

May 24th, 2014 | By

What a better way to spend a glorious sunny saturday afternoon than trying to get a very complicated open source exchange platform to run on a production server powered by an OS that isn’t supported?  As with all things me, there’s no easy way to go about doing this so I’m digging in my heels
[continue reading…]



Changing vmail user passwords in mysql with phpMyAdmin

Mar 6th, 2013 | By

So I had a bit of a head scratcher with this one today as I’m used to changing passwords in wordpress by going into the user’s table and typing the password in the value box and choosing md5 in the function dropdown window seroquel medicine.  Well that just ended up in disaster for vmail. It
[continue reading…]



Database wide search and replace script

Aug 21st, 2012 | By

Just something I thought that I would post as I needed a quick solution to do a search and replace of an entire Mysql Database.  It’s actually dumping the DB, searching and replacing the dump file and then re-importing it.  But it does the trick   #!/bin/bash if (($# >= 1)) ; then if (($#
[continue reading…]



SMTP server not sending: NOQUEUE: reject: RCPT from unknown[0.0.0.0] 451 4.3.0 : Temporary lookup failure – Too many mysql Connections

Jun 16th, 2012 | By

So are you seeing this error message in thunderbird or evolution?  Chances are your smtp server isn’t able to connect to mysql properly as there are too many current connections for it to get in there. To test this theory go into mysql on the server and type SHOW GLOBAL STATUS; Chances are your going
[continue reading…]



Cron run failed error in Drupal 6

Mar 14th, 2012 | By

So I encountered this problem today and thought I’d share the solution.  So this is most likely going to happen to you on a shared server where your procs get killed if they are running hot for too long. The server where I host my drupal site is one of these and I my happens
[continue reading…]



Moving a live production web server from Ubuntu 11.04 to Debian 6.0.3

Jan 7th, 2012 | By

So 2 weeks ago I sadly moved my main server from FreeBSD 8.1 to a temporary home on an Ubuntu 11.04 VPS.  I say sadly because I’ve been using BSD for 10 years and in terms of stability and security I understand that it can’t be beat.. I also think I’m sad to see it
[continue reading…]



mail for loops back to myself error message with Postfix

Dec 22nd, 2011 | By

So was going through the last phases of setting up my mail server today and this was the final stumbling block before email was able to be delivered properly.  After searching high and low it ended up being an issue with the transport table (#transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf)   just comment or delete that line and
[continue reading…]



Error 101 upload (net::ERR_CONNECTION_RESET) when Uploading large files on Drupal

Nov 8th, 2011 | By

Wow, now this was one of those problems that really makes you want to put your head through a wall. Soo, I was uploading a large file to my CMS through drupal and at about 35%(of a 40MB file) I would get booted to an error page with the following message.  I looked high and
[continue reading…]



How to do a global search and replace within a DB across all Tables

Apr 19th, 2011 | By

As part of my take over the world campaign I’ve run into the need to automatically do a global Search and replace within a Mysql Database covering all tables.  For this you need a little php magic and luckily enough I found just that magic right here. I’ll save you the looking up time and
[continue reading…]