Quick copy/paste MySQL Replication Manual

This quick manual tells how to set up database replication in MySQL. Basically it was written for 5.* MySQL versions but is also applicable for 3.23/4.0 ones (btw they are still in use, believe me). As you might already know, replication allows you to create a copy of certain MySQL database from a master server on another server (slave). What is the most important, all updates made to that database […]

Read more →

 

FAQ: How to block/allow packets sent by specific Operating System with iptables?

Question: How can I block traffic coming from specific operating system in Linux? In other words, how can I block traffic from Windows users on my firewall and allows other people? Answer: There is an iptables module named OSF (passive OS Fingerprinting) that was written by Evgeniy Polyakov. This module allows passively detect OS packet was sent from and perform various netfilter actions based on this match. Packets with SYN […]

Read more →

 

Create .deb or .rpm from .tar.gz with checkinstall

Checkinstall is extremely useful utility to create .deb packages for Debian, Ubuntu (or .rpm packages for Fedora, RedHat, CentOs) from .tar.gz (or .tgz) source tarball after it’s compiled at your Linux box. In other words you can prepare binary package for later usage without need to compile software from sources every time you need to get it installed on certain Linux box. Another application of checkinstall is software deinstallation that […]

Read more →

 

OpenBSD: Secure Mail Server with Postfix, MySQL, ClamAV, SpamAssassin, Amavis-new

Few days ago I started configuring corporate mail server that should be deployed on OpenBSD and comprise the following features: Easy to configure and powerful MTA (Postfix) Virtual domains and user accounts (this information is stored in MySQL database) Antispam and antivirus checking for all accounts (spamassassin and clamav via amavis-new) Secure access to mailboxes through POP3, IMAP and HTTP (squirellmail) Secure SMTP server Extremal Stability and Security Actually OpenBSD […]

Read more →

 

Running Cisco Packet Tracer in Linux

Packet Tracer is Cisco Network Simulation Software that is natively available for Micro$oft Windows users only. But thanks to Wine project we can use it in Linux as well. Packet Tracer is a self-paced, visual, interactive teaching and learning tool. It is designed to increase interaction between students and instructors, promote student learning, and enhance instructor presentations. This technology is a new and fun way to expand teaching and learning […]

Read more →