TECH.kulish.com Migration

Posted by packetmad as Databases, Drupal, MySQL, Scripting, Website, Wordpress, php

As you may have noticed, the site has migrated from Drupal to WordPress.

Please bear with us while we finish implementing all the features of the old site.

Thank You.

6/08 Outage

Posted by packetmad as Databases, Drupal, Linux, MySQL, OS, Website, Wordpress

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.

Drupal Issue

Posted by packetmad as Daemons, Databases, Drupal, Linux, MySQL, OS, Scripting, Website, http, php

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

D4rk Theme Issues

Posted by packetmad as Databases, Drupal, Linux, MySQL, OS, Scripting, Website, php

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.

Building a MySQL Capable Postfix RPM

Posted by packetmad as Daemons, Databases, Linux, MySQL, OS, smtp

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

Simple MySQL Backup Script

Posted by packetmad as Databases, FreeBSD, Linux, MySQL, OS, Perl, Scripting, Unix

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.

Debian: Email Server Build

Posted by packetmad as Daemons, Databases, Linux, MySQL, OS, smtp

Another semi-how-to for my old email server build.

1. Partition harddrive:
/boot 150MB Primary hda1 bootable
/ 3000MB Logical hda5
/var 15000MB Logical hda6
/home 6000MB Logical hda7
swap 1024MB Primary hda3 end of drive
/usr Balance Logical hda8

Database Server Build

Posted by packetmad as Databases, Linux, MySQL, OS

More for my records than anyone elses. Still someone may find some use for this information.

I started off by doing a standard network install of Debian Woody. After that I installed ssh and got to work.

Before doing anything else, I create a “poor man’s” disk mirror. This probably isn’t the best solution but it works for my needs. The first thing we need to do here is take a look at the current partition info:

venus:/# df | grep ^/dev
/dev/hde2 1999804 100580 1899224 6% /
/dev/hde1 999868 42036 957832 5% /boot
/dev/hde5 4000088 163476 3836612 5% /usr
/dev/hde6 999868 32840 967028 4% /tmp
/dev/hde7 4000088 37680 3962408 1% /home
/dev/hde8 16028688 198940 15829748 2% /var

SASL Screws Mail Admins (AGAIN)

Posted by packetmad as Daemons, Databases, Linux, MySQL, OS, smtp

It seems that the SASL developers are still hard at work *censored*ing things up. Well, actually, I don’t think they have to work very hard at it. It seems to come natural to them.

After upgrading the SASL libraries on my email server, SMTP authentication is refusing to work.

I found a few tidbits of information, but no fixes.

I found this email that says I have to grab a cvs snapshot. They have GOT TO BE KIDDING! Sadly, they are not. Time to replace some project managers and developers here. They obviously haven’t a clue what they are doing.