Category Archives: Databases

6/08 Outage

Posted on June 8, 2010 by Null

Apparently we had a power failure today that my UPS wasn’t quick enough to take over for.

Everything is back up and running.

One database was corrupted but we were able restore it from this morning’s backup.
Backups will be more frequent during storm season.


Permalink (46 words)

Drupal Issue

Posted on December 25, 2009 by Null

We are currently experiencing an issue with editing account information.
The problem is being researched and status will be provided when information is available.

The following sites are affected:

http://tech.kulish.com

http://family.kulish.com

http://www.iowajeep.net

http://www.racebus.org


Permalink (34 words)

D4rk Theme Issues

Posted on November 2, 2009 by Null

New Drupal theme issues:

(FIXED)1. Text – Links Too dark. The gray is a couple shades too dark for it’s background color.

(FIXED)2. Text – Black text, in text entry areas, is too dark. (search box)

(FIXED)3. Spacing – Spacing on articles and blocks.
There needs to be a CR between the controls of an article teaser and the title of the next.
In blocks, there needs to be a CR at the end.

(MOSTLY)4. Preview – white text on white background. Mostly fixed. You can now see the body but some fields, like author, still have some white text on white background. Comment preview works fine however.


Read more ... (139 words)

Building a MySQL Capable Postfix RPM

Posted on October 18, 2009 by Null

Build Environment:
CentOS 5 x86_64
Postfix 2.3.3 Sources
gcc version 4.1.2 20080704 (Red Hat 4.1.2-44)

2.6.18-164.el5 #1 SMP Thu Sep 3 03:28:30 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux

# Get the src
1) wget http://mirror.centos.org/centos/5.3/centosplus/SRPMS/postfix-2.3.3-2.1.centos.mysql_pgsql.src.rpm

# Install the src RPM
2) rpm -i postfix-2.3.3-2.1.centos.mysql_pgsql.src.rpm

# Install some dependencies I didn’t have
3.1) yum install pcre-devel
3.2) yum install rpm-build
3.3) yum install mysql-devel.x86_64 openldap-devel.x86_64 db4-devel.x86_64
3.4) yum install gcc.x86_64

# Edit SPECS; remove postgres support
4.1) cd /usr/src/redhat/SPECS
4.2) vi postfix.spec and change “%%define PGSQL 1″ to “%define PGSQL 0″
# I didn’t want Postgres support
4.3) “%define MYSQL 1″ was already defined for me


Read more ... (135 words)

Simple MySQL Backup Script

Posted on December 15, 2005 by Null

Below is a simple database backup script to use with MySQL.

#!/usr/bin/perl -w

use strict;

# Backup – Script used to backup MySQL databases to an NFS share.
# VERSION: 1.2
# DATE: 12152005
# AUTHOR: packetmad

# This is a Freebsd 4.x-centric script. It may run on other
# versions of Freebsd, or any other BSD for that matter, but I
# wrote it on a Freebsd 4.7 system. It’s not even guaranteed
# to run on that.


Read more ... (399 words)