Postgresql 9.x Streaming Repilication on FreeBSD – Part II SSL

Configuring SSL for Postgresql:

Setting up SSL on Postgresql is quite simple.  Our requirements are to enforce SSL Encryption on all Postgresql database connections.  To that end, the creation of self-signed certificates will not be explored in this post. Continue reading “Postgresql 9.x Streaming Repilication on FreeBSD – Part II SSL”

AWStats on FreeBSD

AWStats PreRequisites:

Since AWStats is a web server log file analyzer, the first prerequisite is a fully functional web server.  In our case, it is Apache 2.4 on a FreeBSD 10 Server.  Additionally, the web server should have the cgi_module loaded.  Also, if geographical data is desired, then the additional port – p5-geo-ip is required. Continue reading “AWStats on FreeBSD”

Postgresql 9.x Streaming Repilication on FreeBSD – Part I

Installing Postgresql 9.3:

Installing and configuring Postgresql 9.3 for streaming replication is complex but not difficult.  Although replication can provide a certain level of redundancy it should never take the place of a good backup strategy. Continue reading “Postgresql 9.x Streaming Repilication on FreeBSD – Part I”

Apache, PHP, MySQL, and Drupal in FreeBSD 10 – Part IV: Drupal 7 & SSL

Part IV: Drupal 7 & SSL:

The next step in the process is to use an ssl certificate to protect the connections to secure pages.  Obtaining a certificate is left to the reader to fulfill.  The author recommends obtaining an ssl certificate from a certificate authority such as verisign, godaddy, geotrust, etc. Continue reading “Apache, PHP, MySQL, and Drupal in FreeBSD 10 – Part IV: Drupal 7 & SSL”

Apache, PHP, MySQL, and Drupal in FreeBSD 10 – Part III: Drupal 7

Part III – Drupal 7:

In Part I and II, Apache, PHP, MySQL were installed and configured.  In Part III, Drupal 7 configuration is the focus.  This information can be derived from Drupal 7 installation documentation.  The reader is encouraged to review the documentation at www.drupal.org. Continue reading “Apache, PHP, MySQL, and Drupal in FreeBSD 10 – Part III: Drupal 7”

Apache, PHP, MySQL, and Drupal in FreeBSD 10 – Part I: Apache24 and PHP5

Part I – Installing Apache24 and PHP5:

An Apache, PHP, MySQL and Drupal stack on FreeBSD is not difficult to install and configure.  In this case, the Drupal installation will contain only one website and will not employ the use of virtual hosts.  So let’s get started installing Apache24 and PHP5. Continue reading “Apache, PHP, MySQL, and Drupal in FreeBSD 10 – Part I: Apache24 and PHP5”

Apache, PHP, MySQL, and Drupal in FreeBSD 10 – Part II: MySQL55 and phpMyAdmin

Managing MySQL55 with phpMyAdmin:

In Part 1 of this article, Apache24 Server and PHP5 were installed and configured.  The next step towards having a functional FAMP (FreeBSD, Apache, MySQL, PHP) Stack is to install mysql and phpmyadmin. Continue reading “Apache, PHP, MySQL, and Drupal in FreeBSD 10 – Part II: MySQL55 and phpMyAdmin”

OpenLDAP Multi-Master Replication in FreeBSD – Part VIII: Clean Up

Clean Up:

After going through this exercise, several aspects of the software configuration needed cleaning up.

  • phpldapadmin:   Generic: User Account password hash defaults to md5
  • phpldapadmin:  Template Warnings of Attributes and Schemas not configured
  • Sendmail.schema:  Include sendmail.schema to slapd.conf
  • Samba.schema:  Include samba.schema to slapd.conf

Continue reading “OpenLDAP Multi-Master Replication in FreeBSD – Part VIII: Clean Up”

How to Recover from “Recovering vi editor sessions”

Recently, a ssh session terminated while editing a text file.  Unfortunately, tmux was not utilized and the session ended abruptly.  Not giving it much thought, the server was rebooted and during the dmesg output, the following message was produced: “recovering vi editor session”.

After searching the internet, I discovered vi saves its session by default in “/var/tmp/vi.recover”.  Since the saved sessions were not need, the contents of the directory were deleted and the resulting error message on boot up disappeared as well.

Checking for Root Kits on FreeBSD

Checking for Root Kits on FreeBSD

Whether one uses a FreeBSD Server at home, at the office, or rents a dedicated server, it is important to scan for dangerous root kits especially if the server is facing the internet.  In the FreeBSD Ports Collection, two root kit ports are available:  revealrk and rkhunter.  For this post, rkhunter was chosen. Continue reading “Checking for Root Kits on FreeBSD”