How 2 #CentOS A Centos Installation Repository

28Feb/100

Fight Spam With #ASSP (Anti-Spam SMTP Proxy) On CentOS 5.4

The Anti-Spam SMTP Proxy (ASSP) server project is an Open Source, Perl based, platform-independent transparent SMTP proxy server that leverages numerous methodologies and technologies to both rigidly and adaptively identify e-mail spam. ASSP is easy to set up because it requires only minor changes to the configuration of your your Mail Transfer Agent.

Also please read the ASSP documentation

Preliminary Note

In this tutorial I use a base 32 bit server install with the hostname server1.example.co.za with the IP address 10.0.0.10. These settings might differ for you, so you have to replace them where appropriate.

Adjust any package names if installing the EL4 or 64 bit packages. If any dependencies are unsatisfied, install the required packages and retry

12Nov/094

#Remus applied to the official #Xen repository

The one problem with Xen is transparent high availability of your servers, sure you can snapshot an image but thats only of you shutdown the virtual machine. How excited was I when Remus announced that it has been applied to the official Xen repository, and is expected to be included with the next major release. Bookmark this page for a soon to be released how to install Xen with Remus support on CentOS 5.4!

What is Remus?

Remus provides transparent, comprehensive high availability to ordinary virtual machines running on the Xen virtual machine monitor. It does this by maintaining a completely up-to-date copy of a running VM on a backup server, which automatically activates if the primary server fails. Key features:

* The backup VM is an exact copy of the primary VM. When failure happens, it continues running on the backup host as if failure had never occurred.
* The backup is completely up-to-date. Even active TCP sessions are maintained without interruption.
* Protection is transparent. Existing guests can be protected without modifying them in any way.

For a full description and evaluation, see their NSDI paper.

Visit the project: http://dsg.cs.ubc.ca/remus/

6Nov/090

Installing #Jasper reporting for #MySQL on #CentOS 5.4

bitnami_stackcentosWhat is BitNami?

BitNami Native Installers automate the setup of a BitNami Stack on Windows, Linux or Mac OS X. Each installer includes all of the software necessary to run out of the box (the Stack). The process is simple; just download, click next-next-next and you are done! BitNami Stacks are completely self contained and will not interfere with other software on your system.

http://bitnami.org/

What is Jasper for MySQL?

JasperServer Professional is a high-performance standalone and embeddable report server that provides non-technical business users with:

* Drag and drop ad hoc report building
* Drag and drop dashboarding with live-refresh, and mash-ups with external content
* A rich business metadata layer for easy ad hoc query
* Integrated and in-memory data analysis
* Built-in charting and integration with third-party visualization tools
* Self-service parameterized web reporting
* Report scheduling, distribution and historical versioning
* A secure report and metadata repository
* Access to any data source including relational, XML, Hibernate, EJB, POJO, and custom
* Row and column level data security

http://www.jaspersoft.com/jasperserver

Preliminary Note:

I am using a CentOS 5.4 x86_64 base installation in this tutorial

* server1.example.co.za (IP 10.0.0.100): CentOS 5.4 x86_64 Base installation

Download and Install BitNami JasperSever Stack

# wget http://bitnami.org/files/stacks/jasperserver/bitnami-jasperserver-3.5.0-0-linux-installer.bin
# chmod 755 ./bitnami-jasperserver-3.5.0-0-linux-installer.bin
# ./bitnami-jasperserver-3.5.0-0-linux-installer.bin

----------------------------------------------------------------------------
Welcome to the BitNami JasperServer Stack Setup Wizard.

----------------------------------------------------------------------------
Installation folder

Please, choose a folder to install BitNami JasperServer Stack

Select a folder [/opt/jasperserver-3.5.0-0]:

----------------------------------------------------------------------------
MySQL Information

Please enter your MySQL database information:

MySQL Server port [3306]:

----------------------------------------------------------------------------
MySQL Credentials

Please enter your database root user password

MySQL Server root password :
Re-enter password :
----------------------------------------------------------------------------
Setup is now ready to begin installing BitNami JasperServer Stack on your computer.

Do you want to continue? [Y/n]:

In this installation I went ahead and chose all the defaults

Note: if you get this error:

-bash: ./bitnami-jasperserver-3.5.0-0-linux-installer.bin: /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory

make sure the i386 version of ibstdc++ is installed:

# rpm -qa | grep ibstdc++
# yum install libstdc++

Starting and Stopping the JasperServer

# ./catalina.sh start
# ./catalina.sh stop

Once you have started the JasperServer point your browser to the following URL to access the JasperServer GUI

http://server1.example.co.za:8080/jasperserver/login.html

jasperserver
Now your MySQL reporting can begin.

3Nov/091

How to keep a detailed audit trail on your #CentOS 5.4 servers

centosThe psacct package contains several utilities for monitoring process activities, including ac, lastcomm, accton and sa. The ac command displays statistics about how long users have been logged on. The lastcomm command displays information about previous executed commands. The accton command turns process accounting on or off. The sa command summarizes information about previously executed commmands. Install the psacct package if you'd like to use its utilities for monitoring process activities on your CentOS 5.4 system.

Installing the psacct package

Use yum command if you are using CentOS 5.4 / Fedora 11 / RHEL 5.4:

# yum install psacct

MySQL query error