Excel Writer Pear and Centos

Dealing with 3rdparty modules can be difficult but at Blue Box we know how to fix them.

Recently I moved from an Ubuntu Server to Centos 5.6 server. Everything worked well except for one really annoying 3rdparty application that led us down a really black hole.

History
Spreadsheet_Excel_Writer

Spreadsheet_Excel_Writer was born as a porting of the Spreadsheet::WriteExcel Perl module to PHP.
It allows writing of Excel spreadsheets without the need for COM objects.

After 2 days of looking we found that when you install pear (yum install php-pear) it created File.php which was been loaded dynamically into php and ignoring the correct File.php in the bluebox 3rdparty engine directory. This meant when calling the Excel function it did not load all its required modules.

The fix. #rm /usr/share/php/File.php

Now we able to build excel spreadsheets again.

Keeping a eye!!

Recently I have made use of a SaaS application called Server Density by boxedice.com it is really awesome web based app that monitors your servers in realtime and alerts you on events that you create. For instance I need to know when my Server load reaches 4.00 I get a email and if it gets to 6.00 I get a txt. Pretty handy when you need to manage many servers.

What is really handy besides monitoring the OS you can set triggers for services like apache and mysql.

The best part of this product is I can snapshot those events so If I am out of the office and the load spikes It will snap shot and email me a link to the snap shot telling me exactly what triggered the load. This is useful when trying to find out what scripts are killing my server farm!

The power of mobile is another plus in my life. Been a Open Source fan I love the Google Andriod push technology to get alerts on my phone.

How does this tie back to Blue Box 2.0. Well having to manage many servers you tend to lose sight of what is actually happening and this product is a niche fit to my growing network. To get Server Density installed on your BB 2.0 system drop us a line in the callcenter and we will assist you.

Geek Out :)

Raid

Hardware raid on linux seems to have its moments. I spent 2 days fighting a raid card and eventually wrote it off. I have been running 90% of my servers on software raid1. This has proven very stable and reliable.

What I quiet enjoy is using reiserfs filesystem it seems to handle power outages as well with very little failure.

Some tips on Software raid

I always use raid 1.

I set the raid subset to boot in degraded mode (great when you can not access the console).

I set the swap and raid size exactly the same on both drives.

Weekly check the control using cat /proc/mdstat ;-)

When choosing software raid on Ubuntu use the alternative disk it is easier to configure at install level.

When you prompted for the guided partition

Setup manual partition
Follow this useful link.

https://help.ubuntu.com/community/Installation/SoftwareRAID

Chat latter while I complete this server install :)

Backup Your Blue Box2 by Shell and store data remotely

Hi Geeks

Tooday I will share a simple shell backup script. The purpose of this backup script is to enable you to backup your server data quickly without doing much. You can then FTP your www and Mysql database to a remote server.

I have chosen to download my backup my data to my local linux server. the local path is /backup

So firstly create a local store

#mkdir /backup

Now Create the backup script in the global bin directory

#cd /usr/local/bin

#vi backup

Add the backup script below and edit the variables to suit your server

Save the file. Set the permissions to be executed you can run a 777 should you wish then finally test it.

Before testing if you opted for FTP remote transfer enable ncftpd

#apt-get install ncftpd

Happy Backups

Simply edit your choices.

#################################################

## ##

## Backup Procedure Start ##

## ##

#################################################

LOG="/tmp/log.txt"

EMAIL="me@email.com"

CLIENTMSG="ServerName-Bkup"

DATESTAMP="`date '+%a%H'`"

DATEMKDIR="`date '+%A'`"

CODE="/var/www/"

BAK="/backup"

NOW=$(date +"%m-%d-%Y") # mm-dd-yyyy format

FILE="fs-full.tar.gz"

#* MySQL login user name *#

MUSER="root"

#* MySQL login PASSWORD name *#

MPASS="somepass"

#* MySQL login HOST name *#

MHOST="127.0.0.1"

#* System binaries *#

MYSQL="$(which mysql)"

MYSQLDUMP="$(which mysqldump)"

GZIP="$(which gzip)"

TAR="$(which tar)"

FTP="$(which ftp)"

ZIP="$(which zip)"

#*FTP Transfer Optional

### FTP server Setup ###

FTPD="My_Backup_folder/"

FTPU="myusername"

FTPP="mypassword"

FTPS="some.ftp.server"

NCFTP="$(which ncftpput)"

#############################################################################

# #

#Starting Backup System - Backup creates folders for the DAY #

# I.E. \\server\backup\DAY Of The Week (Tuesday) #

#############################################################################

#** Clean Up Load Files

/bin/rm $BAK/$DATEMKDIR/*

/bin/echo "Old data cleaned up" >> $LOG

/bin/echo "Database Backup Time Started" >> $LOG

/bin/date >> $LOG

###Mysql backup All databases

#$MYSQLDUMP $DBNAME > /tmp/$DBNAME.sql

/bin/echo "Database Backup Time Completed" >> $LOG

/bin/date >> /tmp/log.txt

/bin/mkdir $BAK/$DATEMKDIR

#* Start Backup Mysql

# get all database listing

#DBS="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')"

DBS="$($MYSQL -u $MUSER -h $MHOST -Bse 'show databases')"

# start to dump database one by one

for db in $DBS

do

FILE=$BAK/$DATEMKDIR/mysql-$db.gz

# gzip compression for each backup file

$MYSQLDUMP -u $MUSER -h $MHOST $db | $GZIP -9 > $FILE

done

/bin/echo "Database Backup Time Completed" >> $LOG

/bin/date >> /tmp/log.txt

#*Code Base Backup

$TAR zcvf $BAK/$DATEMKDIR/www.tgz $CODE

###ETC System Backup

$TAR zcvf $BAK/$DATEMKDIR/etc.tgz /etc

#### FTP Dump

cd $BAK

### Dump backup using FTP ###

#Start FTP backup using ncftp

ncftp -u"$FTPU" -p"$FTPP" $FTPS<

mkdir $FTPD

mkdir $FTPD/$NOW

cd $FTPD/$NOW

lcd $BAK/$DATEMKDIR/

mput *

quit

EOF

#**Mail

/bin/cat $LOG | mail -s $CLIENTMSG $EMAIL

FireFox 4 is here

And after the hype of I.E. 9 and the millions of downloads posted by Microsoft Mozilla batted back and launched FireFox 4.

I installed it and noticed a vast difference in speed of load and general browser enhancements. They seem to have taken a lot of time into cleaning up the browser clutter and making tab flicking a lot faster. The general feel is a lot less clunky and more clean.

I managed to install all of my POS requirements back into version 4 with very little conflicts. The engine remained the same to me.

What I enjoyed was going from version 3.x to 4 kept my add ons. In a POS environment the Full Screen add on is one of my favorites so having this in 4 was a pleasure. They seem to also give you a bit more control over updates and settings, this is very useful in a large network environment where you need to restrict users from making personal changes.

I can say I am impressed and will continue to recommend firefox as the Blue Box 2.0 browser choice.

Date on your BB2

BB2 uses date from the server time stamp. On a traditional BB2 server the date is normally set by typing

#date -s "hh:mm:ss dd:mm:yyyy"

Also bear in mind Time Zones so to correct this on ubuntu type

#dpkg-reconfigure tzdata

This will allow you to correct the time zone of your bb2 server

Also have a look at your bb2_config.php file in the engine/conf/ direcorty you can control your date by time zone using php time zones.

Prevent Bots from searching your Portal DATA

Because bb2 is web based the chances of a web boot (like google) caching some data files stored in your portal directory is very likely. In order to bypass your core data been available to the world add the following the the route of your web_folder in this case we will assume bb2 is installed in

/var/www

Within the the /var/www directory add the following to the .htaccess file

IndexIgnore *

This file needs to be saved now. Once saved your subdirectories will no longer be brows eable to the world.

Upgrade your Blue Box Ubuntu OS

Quick update

If you need to update your OS online simply run

#apt-get update

#apt-get upgrade

Well let it run reboot and you on the latest distro Simple as that

Why Web Business Solutions

So why would you choose a web based application. This is normally the question that runs through many technology officers heads when making that big purchase. Well my answer is simple. To super charge your business...

Choosing the right solution is always difficult. Not only do you need to ensure your software choice will be compatible with the current hardware and software infrastructure in your business. You also need to ensure the use ability and adaptability of it in your business.

Over the past few years we have seem a massive take up of “The Web”. With broadband been more accessible to many countries and applications like Twitter Facebook and MySpace running into the TOP3 used websites. Business Powered systems have also taken the major leap towards the area of Hosted Business Systems. Fortunately at Blue Box we started in this Sphere 10 years ago with Blue Box Ver1.5, and as browsers and Web 2.0 became more apparent we rapidly developed Blue Box 2.0.

A web based business system is a reality. From a start-up to a multibillion dollar corporation you can deploy these services at a click. Gone are the days of Massive IT departments having to deploy machines and version control software roll outs. With web development as an ITO your version control is managed at a central point. Distribution of software no longer a costly exercise or does it require massive process management.

You able to deploy to any environment with a web browser. So whether it is Mac Microsoft or Linux you able to make use of what you have.

Rapid Application Development is probably the biggest plus to web based business solutions. The ability to quickly change your solution and adapt it to your needs without having to stop your business will increase your operations.

From a CEO point of view the whole work any where at anytime will be the highlight of your choice. From the back of a limo to the terminal at the airport you can get sales figures update your company news check your sales force and setup new customers. Bit limiting if all of this can only be done at the office? You have now turned your teams Iphone or Blackberry into a super charged business investment.

In a nutshell what does web based applications give you.

Greater ROI
Reduced IT support
Capitalize on lower hardware outlay
Hosted infrastructure
Reduce administration costs
Rapid Application Development
Centralized data storage
Faster reporting
Reduced IT Training

Faster deployment and business growth!!!

This post was written on a Dell Vostro laptop using Google Chrome from a broadband connection at the Blue Box Business Park ;-)