August 18, 2017

How to Join Two CSV Files on Unix, Linux and BSD Systems

Administration Logo

Suppose you have two CSV files and want to join them to one CSV file. For this you need a tool to extract selected fields and combine them to a new file. The tool should also arrange the fields in a specific order. The command-line tool join can do exactly that. In this tutorial we will show you how to join two CSV files.

[Read More...]

How to Install Zabbix on FreeBSD

Zabbix Logo

Zabbix is a very useful tool for availability and performance monitoring. Alerting you by E-Mail, Jabber or SMS once a service is not reachable is one of the key features of Zabbix.

Here is a short list of some features available in Zabbix:

  • auto-discovery of servers and network devices
  • low-level discovery
  • distributed monitoring with centralized web administration
  • support for both polling and trapping mechanisms
  • agent-less monitoring
  • secure user authentication
  • flexible user permissions
  • web-based interface
  • flexible e-mail notification of predefined events
  • high-level (business) view of monitored resources
  • audit log

In this tutorial we show you how to get a Zabbix server, the Zabbix agents and the Zabbix frontend running on FreeBSD.

[Read More...]

How to Add a Second IP Address to an Existing Network Adapter on CentOS

CentOS Logo

In this tutorial we will show you the steps to add a second IP address on an already configured NIC. This is useful for various cases. For example we use this to split the requests to a production and development website. Proxy caching is an other scenario where you can use a second IP address.

[Read More...]

How to Find the Owner of an IP Address on Unix, Linux and BSD Systems

Administration Logo

Every IP address is registered to an ISP or organisation. On Unix, Linux and BSD systems you can check the WHOIS database entry with the whois command in your command-line interface. The WHOIS record holds the name, email address, phone and many more of the IP address owner.

[Read More...]

How to Prevent Users From Seeing Processes That run Under Another UID on FreeBSD

FreeBSD Logo

An important step to harden you FreeBSD system is to to disallow users to see processes that are being run under another UID. For this we need to set some kernel states to avoid others from fetching these information with commands like ps, top, sockstat and many more. This changes also applies to jailed systems.

[Read More...]

How to Install shred to Permanently Delete Files on FreeBSD

FreeBSD Logo

With the Unix command shred you can securely delete files and devices by overwriting the specified files repeatedly. Recovering them after shred has deleted the files and devices is extremely difficult and needs specialised hardware. The GNU Core Utilities holds the gshred command and can be installed from the FreeBSD ports tree.

[Read More...]

How to Compress and Extract a complete Linux or UNIX Directory

Administration Logo

Sometimes it is useful to compress a complete directory. For example to backup the files or to send them to an other server. Transfering a compressed directory will save you some time. In this tutorial we show you how to compress and extract a complete directory on a Linux or UNIX system.

[Read More...]

How to Install NTP to Synchronize the System Clock on FreeBSD

FreeBSD Logo

On FreeBSD you can synchronize your system clock with the Network Time Protocol (NTP). The NTP client can be installed from the FreeBSD ports tree. Once the NTP client is installed you can use the ntpdate command to synchronize the system clock with a NTP server.

[Read More...]

How to Backup and Restore a MySQL Database

MySQL Logo

Backing up MySQL databases is an area that is often forgotten. The only time you probably think of backing up your MySQL data is when you change your web host or switch to an other database server. With this instruction we will show you how easy it is to backup and restore a MySQL database.

[Read More...]

How to Install phpMyAdmin on CentOS

phpMyAdmin Logo

With phpMyAdmin you can easily handle your MySQL databases through a web interface. This web interface is almost as powerful as the MySQL Command-Line tool. You can execute SQL statements, create, modify and delete databases, tables, fields or rows and manage users or permissions.

[Read More...]