Recent Posts

Topics

Archives

What? 40:0eh <> 40:13h

By Jesse | August 22, 2011

I got this error when trying to boot up a new GigaByte Motherboard.

Turns out the BIOS was corrupted.. A re-flash with the latest BIOS for the board corrected the error.

_______________________________________
PLEASE HELP BY BOOKMARKING OUR SITE...
[del.icio.us] [Digg] [StumbleUpon]

Topics: Uncategorized | 1 Comment »

Outlook wont connect to Exchange: Disconnected

By Jesse | July 22, 2011

I ran into a strange bug in exchange 2010. If you are on a local/closed network with no gateway (say for testing purposes), Outlook will never connect to exchange and stays disconnected. After running a packet sniffer to watch the traffic I saw exchange for some odd reason INSISTS on having a gateway set.. It can be a completely bogus gateway (say the machine’s IP again) but something must fill in the gateway options.

Once you’ve added some setting for gateway Exchange will function normally.

_______________________________________
PLEASE HELP BY BOOKMARKING OUR SITE...
[del.icio.us] [Digg] [StumbleUpon]

Topics: Uncategorized | No Comments »

automysqlbackup.sh updated version 2.6

By Jesse | July 19, 2011

I have updated automysqlbackup.sh to 2.6.   this new version adds encryption to the backup regimen allowing you to encrypt your mysql database backup before emailing them.

For a great backup solution encrypt them, then send them to a Gmail account!  Free backup to the cloud!

The other major fix to automysqlbackup.sh is that sending via email was not working.  This too is now fixed.  Please note that to email your files somewhere you must have mutt installed.   (yum install mutt for you redhat / fedora / centos users)

to use:

Download from the link below and save it to a file in /etc/cron.daily (remove the .txt extension).  Then chmod 755 the filename and edit it to suit your needs!

automysql.sh

——————————————————————————————————————————————–

#!/bin/bash
#
# MySQL Backup Script
# VER. 2.6 – http://sourceforge.net/projects/automysqlbackup/
# Copyright (c) 2002-2003 wipe_out@lycos.co.uk
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
#
#=====================================================================
#=====================================================================
# Set the following variables to your system needs
# (Detailed instructions above variables)
#=====================================================================

# Username to access the MySQL server e.g. dbuser (must have read access to all dbs)
USERNAME=backupuser

# Username to access the MySQL server e.g. password
PASSWORD=backupuserpassword

# Host name (or IP address) of MySQL server e.g localhost
DBHOST=localhost

# List of DBNAMES for Daily/Weekly Backup e.g. “DB1 DB2 DB3″
DBNAMES=”all”

# Backup directory location e.g /backups
BACKUPDIR=”/backups”

# Encrypt backups? (y to encrypt)
ENCRYPTBACKUPS=”y”

# Password to encrypt backups with
ENCPASSWD=”passwordforencryption”

# to decrypt run (replace bz2 with gz if using gzip)
# openssl enc -aes-256-cbc -d -in encrypted_file_name(ex: *.enc.bz2) -out outputfilename.bz2 -pass pass:PASSWORDUSEDTOENCRYPT

# Mail setup
# What would you like to be mailed to you?
# – log   : send only log file
# – files : send log file and sql files as attachments (see docs)
# – stdout : will simply output the log to the screen if run manually.
# – quiet : Only send logs if an error occurs to the MAILADDR.
MAILCONTENT=”log”

# Set the maximum allowed email size in k. (4000 = approx 5MB email [see docs])
MAXATTSIZE=”4000″

# Email Address to send mail to? (user@domain.com,  separate with spaces for multiple)
MAILADDR=”user1@domain.com user2@domain.com user3@domain.com”

# ============================================================
# === ADVANCED OPTIONS ( Read the doc’s below for details )===
#=============================================================

# List of DBBNAMES for Monthly Backups.
MDBNAMES=”mysql $DBNAMES”

# List of DBNAMES to EXLUCDE if DBNAMES are set to all (must be in ” quotes)
DBEXCLUDE=””

# Include CREATE DATABASE in backup?
CREATE_DATABASE=yes

# Separate backup directory and file for each DB? (yes or no)
SEPDIR=yes

# Which day do you want weekly backups? (1 to 7 where 1 is Monday)
DOWEEKLY=6

# Choose Compression type. (gzip or bzip2)
COMP=bzip2

# Compress communications between backup server and MySQL server?
COMMCOMP=no

# Additionally keep a copy of the most recent backup in a seperate directory.
LATEST=no

#  The maximum size of the buffer for client/server communication. e.g. 16MB (maximum is 1GB)
MAX_ALLOWED_PACKET=

#  For connections to localhost. Sometimes the Unix socket file must be specified.
SOCKET=

# Command to run before backups (uncomment to use)
#PREBACKUP=”/etc/mysql-backup-pre”

# Command run after backups (uncomment to use)
#POSTBACKUP=”/etc/mysql-backup-post”

#=====================================================================
# Options documantation
#=====================================================================
# Set USERNAME and PASSWORD of a user that has at least SELECT permission
# to ALL databases.
#
# Set the DBHOST option to the server you wish to backup, leave the
# default to backup “this server”.(to backup multiple servers make
# copies of this file and set the options for that server)
#
# Put in the list of DBNAMES(Databases)to be backed up. If you would like
# to backup ALL DBs on the server set DBNAMES=”all”.(if set to “all” then
# any new DBs will automatically be backed up without needing to modify
# this backup script when a new DB is created).
#
# If the DB you want to backup has a space in the name replace the space
# with a % e.g. “data base” will become “data%base”
# NOTE: Spaces in DB names may not work correctly when SEPDIR=no.
#
# You can change the backup storage location from /backups to anything
# you like by using the BACKUPDIR setting..
#
# The MAILCONTENT and MAILADDR options and pretty self explanitory, use
# these to have the backup log mailed to you at any email address or multiple
# email addresses in a space seperated list.
# (If you set mail content to “log” you will require access to the “mail” program
# on your server. If you set this to “files” you will have to have mutt installed
# on your server. If you set it to “stdout” it will log to the screen if run from
# the console or to the cron job owner if run through cron. If you set it to “quiet”
# logs will only be mailed if there are errors reported. )
#
# MAXATTSIZE sets the largest allowed email attachments total (all backup files) you
# want the script to send. This is the size before it is encoded to be sent as an email
# so if your mail server will allow a maximum mail size of 5MB I would suggest setting
# MAXATTSIZE to be 25% smaller than that so a setting of 4000 would probably be fine.
#
# Finally copy automysqlbackup.sh to anywhere on your server and make sure
# to set executable permission. You can also copy the script to
# /etc/cron.daily to have it execute automatically every night or simply
# place a symlink in /etc/cron.daily to the file if you wish to keep it
# somwhere else.
# NOTE:On Debian copy the file with no extention for it to be run
# by cron e.g just name the file “automysqlbackup”
#
# Thats it..
#
#
# === Advanced options doc’s ===
#
# The list of MDBNAMES is the DB’s to be backed up only monthly. You should
# always include “mysql” in this list to backup your user/password
# information along with any other DBs that you only feel need to
# be backed up monthly. (if using a hosted server then you should
# probably remove “mysql” as your provider will be backing this up)
# NOTE: If DBNAMES=”all” then MDBNAMES has no effect as all DBs will be backed
# up anyway.
#
# If you set DBNAMES=”all” you can configure the option DBEXCLUDE. Other
# wise this option will not be used.
# This option can be used if you want to backup all dbs, but you want
# exclude some of them. (eg. a db is to big).
#
# Set CREATE_DATABASE to “yes” (the default) if you want your SQL-Dump to create
# a database with the same name as the original database when restoring.
# Saying “no” here will allow your to specify the database name you want to
# restore your dump into, making a copy of the database by using the dump
# created with automysqlbackup.
# NOTE: Not used if SEPDIR=no
#
# The SEPDIR option allows you to choose to have all DBs backed up to
# a single file (fast restore of entire server in case of crash) or to
# seperate directories for each DB (each DB can be restored seperately
# in case of single DB corruption or loss).
#
# To set the day of the week that you would like the weekly backup to happen
# set the DOWEEKLY setting, this can be a value from 1 to 7 where 1 is Monday,
# The default is 6 which means that weekly backups are done on a Saturday.
#
# COMP is used to choose the copmression used, options are gzip or bzip2.
# bzip2 will produce slightly smaller files but is more processor intensive so
# may take longer to complete.
#
# COMMCOMP is used to enable or diable mysql client to server compression, so
# it is useful to save bandwidth when backing up a remote MySQL server over
# the network.
#
# LATEST is to store an additional copy of the latest backup to a standard
# location so it can be downloaded bt thrid party scripts.
#
# If the DB’s being backed up make use of large BLOB fields then you may need
# to increase the MAX_ALLOWED_PACKET setting, for example 16MB..
#
# When connecting to localhost as the DB server (DBHOST=localhost) sometimes
# the system can have issues locating the socket file.. This can now be set
# using the SOCKET parameter.. An example may be SOCKET=/private/tmp/mysql.sock
#
# Use PREBACKUP and POSTBACKUP to specify Per and Post backup commands
# or scripts to perform tasks either before or after the backup process.
#
#
#=====================================================================
# Backup Rotation..
#=====================================================================
#
# Daily Backups are rotated weekly..
# Weekly Backups are run by default on Saturday Morning when
# cron.daily scripts are run…Can be changed with DOWEEKLY setting..
# Weekly Backups are rotated on a 5 week cycle..
# Monthly Backups are run on the 1st of the month..
# Monthly Backups are NOT rotated automatically…
# It may be a good idea to copy Monthly backups offline or to another
# server..
#
#=====================================================================
# Please Note!!
#=====================================================================
#
# I take no resposibility for any data loss or corruption when using
# this script..
# This script will not help in the event of a hard drive crash. If a
# copy of the backup has not be stored offline or on another PC..
# You should copy your backups offline regularly for best protection.
#
# Happy backing up…
#
#=====================================================================
# Restoring
#=====================================================================
# Firstly you will need to uncompress the backup file.
# eg.
# gunzip file.gz (or bunzip2 file.bz2)
#
# Next you will need to use the mysql client to restore the DB from the
# sql file.
# eg.
# mysql –user=username –pass=password –host=dbserver database < /path/file.sql
# or
# mysql –user=username –pass=password –host=dbserver -e “source /path/file.sql” database
#
# NOTE: Make sure you use “<” and not “>” in the above command because
# you are piping the file.sql to mysql and not the other way around.
#
# Lets hope you never have to use this.. :)
#
#=====================================================================
# Change Log
#=====================================================================
# VER 2.6 – (2011-07-19)
#               Fixed bug where files would not email correctly (Fix by Jesse Vaughan)
Added section to encrypt .gz and .bz2 files using openssl (added by Jesse Vaughan)
# VER 2.5 – (2006-01-15)
#               Added support for setting MAXIMUM_PACKET_SIZE and SOCKET parameters (suggested by Yvo van Doorn)
# VER 2.4 – (2006-01-23)
#    Fixed bug where weekly backups were not being rotated. (Fix by wolf02)
#    Added hour an min to backup filename for the case where backups are taken multiple
#    times in a day. NOTE This is not complete support for mutiple executions of the script
#    in a single day.
#    Added MAILCONTENT=”quiet” option, see docs for details. (requested by snowsam)
#    Updated path statment for compatibility with OSX.
#    Added “LATEST” to additionally store the last backup to a standard location. (request by Grant29)
# VER 2.3 – (2005-11-07)
#    Better error handling and notification of errors (a long time coming)
#    Compression on Backup server to MySQL server communications.
# VER 2.2 – (2004-12-05)
#    Changed from using depricated “-N” to “–skip-column-names”.
#    Added ability to have compressed backup’s emailed out. (code from Thomas Heiserowski)
#    Added maximum attachment size setting.
# VER 2.1 – (2004-11-04)
#    Fixed a bug in daily rotation when not using gzip compression. (Fix by Rob Rosenfeld)
# VER 2.0 – (2004-07-28)
#    Switched to using IO redirection instead of pipeing the output to the logfile.
#    Added choice of compression of backups being gzip of bzip2.
#    Switched to using functions to facilitate more functionality.
#    Added option of either gzip or bzip2 compression.
# VER 1.10 – (2004-07-17)
#    Another fix for spaces in the paths (fix by Thomas von Eyben)
#    Fixed bug when using PREBACKUP and POSTBACKUP commands containing many arguments.
# VER 1.9 – (2004-05-25)
#    Small bug fix to handle spaces in LOGFILE path which contains spaces (reported by Thomas von Eyben)
#    Updated docs to mention that Log email can be sent to multiple email addresses.
# VER 1.8 – (2004-05-01)
#    Added option to make backups restorable to alternate database names
#    meaning that a copy of the database can be created (Based on patch by Rene Hoffmann)
#    Seperated options into standard and advanced.
#    Removed ” from single file dump DBMANES because it caused an error but
#    this means that if DB’s have spaces in the name they will not dump when SEPDIR=no.
#    Added -p option to mkdir commands to create multiple subdirs without error.
#    Added disk usage and location to the bottom of the backup report.
# VER 1.7 – (2004-04-22)
#    Fixed an issue where weelky backups would only work correctly if server
#    locale was set to English (issue reported by Tom Ingberg)
#    used “eval” for “rm” commands to try and resolve rotation issues.
#    Changed name of status log so multiple scripts can be run at the same time.
# VER 1.6 – (2004-03-14)
#   Added PREBACKUP and POSTBACKUP command functions. (patch by markpustjens)
#   Added support for backing up DB’s with Spaces in the name.
#   (patch by mark pustjens)
# VER 1.5 – (2004-02-24)
#   Added the ability to exclude DB’s when the “all” option is used.
#   (Patch by kampftitan)
# VER 1.4 – (2004-02-02)
#   Project moved to Sourceforge.net
# VER 1.3 – (2003-09-25)
#   Added support for backing up “all” databases on the server without
#    having to list each one seperately in the configuration.
#   Added DB restore instructions.
# VER 1.2 – (2003-03-16)
#   Added server name to the backup log so logs from multiple servers
#   can be easily identified.
# VER 1.1 – (2003-03-13)
#   Small Bug fix in monthly report. (Thanks Stoyanski)
#   Added option to email log to any email address. (Inspired by Stoyanski)
#   Changed Standard file name to .sh extention.
#   Option are set using yes and no rather than 1 or 0.
# VER 1.0 – (2003-01-30)
#   Added the ability to have all databases backup to a single dump
#   file or seperate directory and file for each database.
#   Output is better for log keeping.
# VER 0.6 – (2003-01-22)
#   Bug fix for daily directory (Added in VER 0.5) rotation.
# VER 0.5 – (2003-01-20)
#   Added “daily” directory for daily backups for neatness (suggestion by Jason)
#   Added DBHOST option to allow backing up a remote server (Suggestion by Jason)
#   Added “–quote-names” option to mysqldump command.
#   Bug fix for handling the last and first of the year week rotation.
# VER 0.4 – (2002-11-06)
#   Added the abaility for the script to create its own directory structure.
# VER 0.3 – (2002-10-01)
#   Changed Naming of Weekly backups so they will show in order.
# VER 0.2 – (2002-09-27)
#   Corrected weekly rotation logic to handle weeks 0 – 10
# VER 0.1 – (2002-09-21)
#   Initial Release
#
#=====================================================================
#=====================================================================
#=====================================================================
#
# Should not need to be modified from here down!!
#
#=====================================================================
#=====================================================================
#=====================================================================
PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/mysql/bin
DATE=`date +%Y-%m-%d_%Hh%Mm`                            # Datestamp e.g 2002-09-21
DOW=`date +%A`                                                  # Day of the week e.g. Monday
DNOW=`date +%u`                                         # Day number of the week 1 to 7 where 1 represents Monday
DOM=`date +%d`                                                  # Date of the Month e.g. 27
M=`date +%B`                                                    # Month e.g January
W=`date +%V`                                                    # Week Number e.g 37
VER=2.5                                                                 # Version Number
LOGFILE=$BACKUPDIR/$DBHOST-`date +%N`.log               # Logfile Name
LOGERR=$BACKUPDIR/ERRORS_$DBHOST-`date +%N`.log         # Logfile Name
BACKUPFILES=””
OPT=”–quote-names –opt”                       # OPT string for use with mysqldump ( see man mysqldump )

# Add –compress mysqldump option to $OPT
if [ “$COMMCOMP” = “yes” ];
then
OPT=”$OPT –compress”
fi

# Add –compress mysqldump option to $OPT
if [ “$MAX_ALLOWED_PACKET” ];
then
OPT=”$OPT –max_allowed_packet=$MAX_ALLOWED_PACKET”
fi

# Create required directories
if [ ! -e “$BACKUPDIR” ]                # Check Backup Directory exists.
then
mkdir -p “$BACKUPDIR”
fi

if [ ! -e “$BACKUPDIR/daily” ]          # Check Daily Directory exists.
then
mkdir -p “$BACKUPDIR/daily”
fi

if [ ! -e “$BACKUPDIR/weekly” ]         # Check Weekly Directory exists.
then
mkdir -p “$BACKUPDIR/weekly”
fi

if [ ! -e “$BACKUPDIR/monthly” ]        # Check Monthly Directory exists.
then
mkdir -p “$BACKUPDIR/monthly”
fi

if [ “$LATEST” = “yes” ]
then
if [ ! -e “$BACKUPDIR/latest” ] # Check Latest Directory exists.
then
mkdir -p “$BACKUPDIR/latest”
fi
eval rm -fv “$BACKUPDIR/latest/*”
fi

# IO redirection for logging.
touch $LOGFILE
exec 6>&1           # Link file descriptor #6 with stdout.
# Saves stdout.
exec > $LOGFILE     # stdout replaced with file $LOGFILE.
touch $LOGERR
exec 7>&2           # Link file descriptor #7 with stderr.
# Saves stderr.
exec 2> $LOGERR     # stderr replaced with file $LOGERR.

# Functions

# Database dump function
dbdump () {
mysqldump –user=$USERNAME –password=$PASSWORD –host=$DBHOST $OPT $1 > $2
return 0
}

# Compression function plus latest copy

compression () {
SUFFIX=””
ENCSUF=””
if [ “$COMP” = “gzip” ]; then
SUFFIX=”.gz”
ENCSUF=”.enc.gz”
gzip -f “$1”
echo
echo Backup Information for “$1”
gzip -l $1$SUFFIX
if [ “$ENCRYPTBACKUPS” = “y” ]; then
if [ $ENCPASSWD = “” ]; then
echo “Encrypting…”
openssl enc -aes-256-cbc -e -in $1$SUFFIX -out $1$ENCSUF -pass pass:$ENCPASSWD $2>1
echo “Deleting $1$SUFFIX…”
rm -Rf $1$SUFFIX 2>&1
SUFFIX=”.enc.gz”
echo “encrypted file saved as : $1$SUFFIX”
else
echo “ERROR: Can not encrypt! No Password set!” 1>&2
fi
fi

elif [ “$COMP” = “bzip2” ]; then
echo Compression information for “$1.bz2″
bzip2 -f -v $1 2>&1
SUFFIX=”.bz2″
ENCSUF=”.enc.bz2″
if [ “$ENCRYPTBACKUPS” = “y” ]; then
if [ $ENCPASSWD != “” ]; then
echo “Encrypting…”
openssl enc -aes-256-cbc -e -in $1$SUFFIX -out $1$ENCSUF -pass pass:$ENCPASSWD $2>1
echo “Deleting $1$SUFFIX…”
rm -Rf $1$SUFFIX 2>&1
SUFFIX=”.enc.bz2″
echo “encrypted file saved as : $1$SUFFIX”
else
echo “ERROR: Can not encrypt! No Password set!” 1>&2
fi

fi

else
echo “No compression option set, check advanced settings”
fi
if [ “$LATEST” = “yes” ]; then
cp $1$SUFFIX “$BACKUPDIR/latest/”
fi
return 0
}

# Run command before we begin
if [ “$PREBACKUP” ]
then
echo ======================================================================
echo “Prebackup command output.”
echo
eval $PREBACKUP
echo
echo ======================================================================
echo
fi

if [ “$SEPDIR” = “yes” ]; then # Check if CREATE DATABSE should be included in Dump
if [ “$CREATE_DATABASE” = “no” ]; then
OPT=”$OPT –no-create-db”
else
OPT=”$OPT –databases”
fi
else
OPT=”$OPT –databases”
fi

# Hostname for LOG information
if [ “$DBHOST” = “localhost” ]; then
HOST=`hostname`
if [ “$SOCKET” ]; then
OPT=”$OPT –socket=$SOCKET”
fi
else
HOST=$DBHOST
fi

# If backing up all DBs on the server
if [ “$DBNAMES” = “all” ]; then
DBNAMES=”`mysql –user=$USERNAME –password=$PASSWORD –host=$DBHOST –batch –skip-column-names -e “show databases”| sed ‘s/ /%/g’`”

# If DBs are excluded
for exclude in $DBEXCLUDE
do
DBNAMES=`echo $DBNAMES | sed “s/\b$exclude\b//g”`
done

MDBNAMES=$DBNAMES
fi

echo ======================================================================
echo AutoMySQLBackup VER $VER
echo http://sourceforge.net/projects/automysqlbackup/
echo
echo Backup of Database Server – $HOST
echo ======================================================================

# Test is seperate DB backups are required
if [ “$SEPDIR” = “yes” ]; then
echo Backup Start Time `date`
echo ======================================================================
# Monthly Full Backup of all Databases
if [ $DOM = “01” ]; then
for MDB in $MDBNAMES
do

# Prepare $DB for using
MDB=”`echo $MDB | sed ‘s/%/ /g’`”

if [ ! -e “$BACKUPDIR/monthly/$MDB” ]           # Check Monthly DB Directory exists.
then
mkdir -p “$BACKUPDIR/monthly/$MDB”
fi
echo Monthly Backup of $MDB…
dbdump “$MDB” “$BACKUPDIR/monthly/$MDB/${MDB}_$DATE.$M.$MDB.sql”
compression “$BACKUPDIR/monthly/$MDB/${MDB}_$DATE.$M.$MDB.sql”
BACKUPFILES=”$BACKUPFILES $BACKUPDIR/monthly/$MDB/${MDB}_$DATE.$M.$MDB.sql$SUFFIX”
echo ———————————————————————-
done
fi

for DB in $DBNAMES
do
# Prepare $DB for using
DB=”`echo $DB | sed ‘s/%/ /g’`”

# Create Seperate directory for each DB
if [ ! -e “$BACKUPDIR/daily/$DB” ]              # Check Daily DB Directory exists.
then
mkdir -p “$BACKUPDIR/daily/$DB”
fi

if [ ! -e “$BACKUPDIR/weekly/$DB” ]             # Check Weekly DB Directory exists.
then
mkdir -p “$BACKUPDIR/weekly/$DB”
fi

# Weekly Backup
if [ $DNOW = $DOWEEKLY ]; then
echo Weekly Backup of Database \( $DB \)
echo Rotating 5 weeks Backups…
if [ “$W” -le 05 ];then
REMW=`expr 48 + $W`
elif [ “$W” -lt 15 ];then
REMW=0`expr $W – 5`
else
REMW=`expr $W – 5`
fi
eval rm -fv “$BACKUPDIR/weekly/$DB_week.$REMW.*”
echo
dbdump “$DB” “$BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.sql”
compression “$BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.sql”
BACKUPFILES=”$BACKUPFILES $BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.sql$SUFFIX”
echo ———————————————————————-

# Daily Backup
else
echo Daily Backup of Database \( $DB \)
echo Rotating last weeks Backup…
eval rm -fv “$BACKUPDIR/daily/$DB/*.$DOW.sql.*”
echo
dbdump “$DB” “$BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.sql”
compression “$BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.sql”
BACKUPFILES=”$BACKUPFILES $BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.sql$SUFFIX”
echo ———————————————————————-
fi
done
echo Backup End `date`
echo ======================================================================

else # One backup file for all DBs
echo Backup Start `date`
echo ======================================================================
# Monthly Full Backup of all Databases
if [ $DOM = “01” ]; then
echo Monthly full Backup of \( $MDBNAMES \)…
dbdump “$MDBNAMES” “$BACKUPDIR/monthly/$DATE.$M.all-databases.sql”
compression “$BACKUPDIR/monthly/$DATE.$M.all-databases.sql”
BACKUPFILES=”$BACKUPFILES $BACKUPDIR/monthly/$DATE.$M.all-databases.sql$SUFFIX”
echo ———————————————————————-
fi

# Weekly Backup
if [ $DNOW = $DOWEEKLY ]; then
echo Weekly Backup of Databases \( $DBNAMES \)
echo
echo Rotating 5 weeks Backups…
if [ “$W” -le 05 ];then
REMW=`expr 48 + $W`
elif [ “$W” -lt 15 ];then
REMW=0`expr $W – 5`
else
REMW=`expr $W – 5`
fi
eval rm -fv “$BACKUPDIR/weekly/week.$REMW.*”
echo
dbdump “$DBNAMES” “$BACKUPDIR/weekly/week.$W.$DATE.sql”
compression “$BACKUPDIR/weekly/week.$W.$DATE.sql”
BACKUPFILES=”$BACKUPFILES $BACKUPDIR/weekly/week.$W.$DATE.sql$SUFFIX”
echo ———————————————————————-

# Daily Backup
else
echo Daily Backup of Databases \( $DBNAMES \)
echo
echo Rotating last weeks Backup…
eval rm -fv “$BACKUPDIR/daily/*.$DOW.sql.*”
echo
dbdump “$DBNAMES” “$BACKUPDIR/daily/$DATE.$DOW.sql”
compression “$BACKUPDIR/daily/$DATE.$DOW.sql”
BACKUPFILES=”$BACKUPFILES $BACKUPDIR/daily/$DATE.$DOW.sql$SUFFIX”
echo ———————————————————————-
fi
echo Backup End Time `date`
echo ======================================================================
fi
echo Total disk space used for backup storage..
echo Size – Location
echo `du -hs “$BACKUPDIR”`
echo
echo ======================================================================
echo If you find AutoMySQLBackup valuable please make a donation at
echo http://sourceforge.net/project/project_donations.php?group_id=101066
echo ======================================================================

# Run command when we’re done
if [ “$POSTBACKUP” ]
then
echo ======================================================================
echo “Postbackup command output.”
echo
eval $POSTBACKUP
echo
echo ======================================================================
fi

#Clean up IO redirection
exec 1>&6 6>&-      # Restore stdout and close file descriptor #6.
exec 1>&7 7>&-      # Restore stdout and close file descriptor #7.

if [ “$MAILCONTENT” = “files” ]
then
if [ -s “$LOGERR” ]
then
# Include error log if is larger than zero.
BACKUPFILES=”$BACKUPFILES $LOGERR”
ERRORNOTE=”WARNING: Error Reported – ”
fi
#Get backup size
ATTSIZE=`du -c $BACKUPFILES | grep “[[:digit:][:space:]]total$” |sed s/\s*total//`
if [ $MAXATTSIZE -ge $ATTSIZE ]
then
BACKUPFILES=`echo “$BACKUPFILES” | sed -e “s# # -a #g”` #enable multiple attachments
#               mutt -s “$ERRORNOTE MySQL Backup Log and SQL Files for $HOST – $DATE” $BACKUPFILES — $MAILADDR < $LOGFILE              #send via mutt
mutt -s “$ERRORNOTE MySQL Backup Log and SQL Files for $HOST – $DATE” $BACKUPFILES — $MAILADDR < $LOGFILE #send via mutt
else
cat “$LOGFILE” | mail -s “WARNING! – MySQL Backup exceeds set maximum attachment size on $HOST – $DATE” $MAILADDR
fi
elif [ “$MAILCONTENT” = “log” ]
then
cat “$LOGFILE” | mail -s “MySQL Backup Log for $HOST – $DATE” $MAILADDR
if [ -s “$LOGERR” ]
then
cat “$LOGERR” | mail -s “ERRORS REPORTED: MySQL Backup error Log for $HOST – $DATE” $MAILADDR
fi
elif [ “$MAILCONTENT” = “quiet” ]
then
if [ -s “$LOGERR” ]
then
cat “$LOGERR” | mail -s “ERRORS REPORTED: MySQL Backup error Log for $HOST – $DATE” $MAILADDR
cat “$LOGFILE” | mail -s “MySQL Backup Log for $HOST – $DATE” $MAILADDR
fi
else
if [ -s “$LOGERR” ]
then
cat “$LOGFILE”
echo
echo “###### WARNING ######”
echo “Errors reported during AutoMySQLBackup execution.. Backup failed”
echo “Error log below..”
cat “$LOGERR”
else
cat “$LOGFILE”
fi
fi

if [ -s “$LOGERR” ]
then
STATUS=1
else
STATUS=0
fi

# Clean up Logfile
eval rm -f “$LOGFILE”
eval rm -f “$LOGERR”

exit $STATUS

_______________________________________
PLEASE HELP BY BOOKMARKING OUR SITE...
[del.icio.us] [Digg] [StumbleUpon]

Topics: Uncategorized | 6 Comments »

Fix for: “SQL server was not detected on __________…” when adding the ADRMS service role

By Jesse | June 22, 2011

If you are trying to add the ADRMS Role to your server and cannot validate the server (when you type the server name), verify that you granted LOCAL ADMIN rights for the user you’re logged in with to the SQL Box.

If you get the “SQL server was not detected on…. and it fails to validate, it’s generally either related to the firewall rules on the SQL server or the fact that the user you’re currently logged in with doesnt have local admin rights on sql.

Once you’ve added the user to the local admins group, usually your problem will go away.

Microsoft is making a remote registry request to the sql box to get the sql instances available.  it is NOT making a request to port 1433 which is why granting SA rights and access to 1433 is not enough.

_______________________________________
PLEASE HELP BY BOOKMARKING OUR SITE...
[del.icio.us] [Digg] [StumbleUpon]

Topics: Uncategorized | No Comments »

Fix for: hard drive lost partition

By Jesse | April 7, 2011

We have had a number customer machines over the year that have “forgotten” their partition information.   Generally the behavior when this happens is that for os partitions, the machine doesn’t boot, or for data partitions the drive is missing and if you go into computer management, you see a now blank drive, and when you click on the drive it may ask you to initialize the disk..

DONT INITIALIZE THE DISK….   just leave it …

If the missing partition is a data partition and your machine is still bootable goto :

http://www.cgsecurity.org/wiki/TestDisk_Download

Download the version for your OS and install it.. If you’re running Vista or Windows 7 make sure you run it as administrator.  The instructions for recovery are here:

http://www.cgsecurity.org/wiki/TestDisk_Step_By_Step

In addition, I’ve had some scenarios where when I go to write the partition information back to the disk, I got a Partition: Write Error.  I found that it was an erroneous error and that the application had successfully repaired the partition table.  Also to get it to re-read the partition information information, we rebooted the machine.   After boot drives showed back up.

 

If your machine is not bootable, download a copy of the Ultimate Boot CD which contains a copy of TestDisk.  then just follow the on screen prompts and launch testdisk (which believe is buried in the PartEd Magic portion of the dvd).  Once TestDisk is running, follow the above instructions for testdisk.

We have had luck recovering FAT, GPT, and NTFS formatted partitions with this tool.  With an almost 100% success rate.

_______________________________________
PLEASE HELP BY BOOKMARKING OUR SITE...
[del.icio.us] [Digg] [StumbleUpon]

Topics: Uncategorized | No Comments »

How to run as the Network Service Account in Windows 2008

By Jesse | March 24, 2011

Download Psexec.exe from systernals. then run this command from cmd.exe:

DO NOT USE COPY PASTE.. RETYPE IT MANUALLY.. for some reason if you copy and paste it, it doesnt work.. dont know why
DO NOT COPY IT .. ReTYPE IT…

psexec -i -u “nt authority\network service” cmd.exe

run whoami to confirm you are now running as network service.

_______________________________________
PLEASE HELP BY BOOKMARKING OUR SITE...
[del.icio.us] [Digg] [StumbleUpon]

Topics: Uncategorized | 1 Comment »

How to Run as System Account on Windows 2008

By Jesse | March 24, 2011

To run an app as System, download psexec from systernals. Then run:

psexec -i -s cmd.exe

this will launch the cmd application interactively, you can then launch whatever application you want as sytem.

_______________________________________
PLEASE HELP BY BOOKMARKING OUR SITE...
[del.icio.us] [Digg] [StumbleUpon]

Topics: Uncategorized | No Comments »

Why to use Google adwords and not Bing: Bing is stealing google results.

By Jesse | February 1, 2011

http://searchengineland.com/google-bing-is-cheating-copying-our-search-results-62914

Honestly I cant say I’m surprised that Microsoft has sunk as low as stealing results- as it it hard to compete when you are #2. But as an IT Professional, behaviour like this from a company that’s trying to win my business is not appropriate.

In addition it underscores the reason never to use toolbars as you never know what the developers are really spying on- and Even companies like microsoft use their toolbar to watch what you’re doing.

Perhaps we net denizens can help fight practices like this by supporting honest companies and showing our disapproval for those who are not.

I found it interesting that they’re not sure whether Microsoft has done anything illegal as there is no damage. Honestly I disagree- Bing increases their seach engine use by improving their search results (as a direct result of google’s IP). That loss of search volume on google directly impacts their adwords revenue. Which is a direct cost to google for what Microsoft has done.

_______________________________________
PLEASE HELP BY BOOKMARKING OUR SITE...
[del.icio.us] [Digg] [StumbleUpon]

Topics: Uncategorized | No Comments »

Calling LoadLibraryEx on ISAPI filter “C:\Windows\Microsoft.NET\ Framework\v4.0.21006\ aspnet_filter.dll” failed

By Jesse | January 24, 2011

If you get the error ‘Calling LoadLibraryEx on ISAPI filter “C:\Windows\Microsoft.NET\Framework\v4.0.21006\aspnet_filter.dll” failed’, it can be fixed by opening IIS manager (start–>run–>inetmgr)  and then going down to the websites section.  Click on the appropriate website then select ISAPI Filters.  under ISAPI filters click on the ASP 4.0 filter and select the remove button.  this will remove the ASP.NET 4.0 ISAPI filter.  Unless you have a product that you know needs ASP.net 4.0 you are fine.

I have not yet encountered a problem that requires the asp.net 4.0 filter remain in place.

To restore the filter, you would just click add, type a friendly name for the filter then point it back to the file : C:\Windows\Microsoft.NET\Framework\v4.0.21006\aspnet_filter.dll.   this would return the server back to the state it was in before you removed it.

After removing the filter do an IIS reset from the command prompt (iisreset).

This error may sometimes be encountered after installing ASP.Net 1.1 on a Server 2008 system but could also occur at other times.  Removing the filter does not harm the machine in any way since the process is reversible.

Calling LoadLibraryEx on ISAPI filter “C:\Windows\Microsoft.NET\Framework\v4.0.21006\aspnet_filter.dll” failed

_______________________________________
PLEASE HELP BY BOOKMARKING OUR SITE...
[del.icio.us] [Digg] [StumbleUpon]

Topics: Uncategorized | 4 Comments »

Failed to build the subject name blob: 0x80092023

By Jesse | January 5, 2011

We got the error: “Failed to build the subject name blog: 0x80092023”  recently when trying to create self-signed IIS 6.0 certificate.

This error is caused when we ran the following command:

selfssl /n:site.name.com /k:1024 /v:365 /s:1 /p:443

This problem is caused because the site name does not have cn= in front of it.

To fix this error change the command to this:

selfssl /n:cn=site.name.com /k:1024 /v:365 /s:1 /p:443

The certificate will now build correctly.

_______________________________________
PLEASE HELP BY BOOKMARKING OUR SITE...
[del.icio.us] [Digg] [StumbleUpon]

Topics: Uncategorized | 1 Comment »


« Previous Entries Next Entries »
Technorati Profile