HandyDBA

SSH Login Banners

There are two places where login banners can be configured.

1. The traditional Message Of The Day
   Typically this is defined in /etc/motd
2. SSH pre authentication banner.
   This is displayed before authentication takes place and is typically defined in the site wide SSH config file /etc/ssh/ssh_config by using “Banner /path/to/banner”

What might be less well known are the techniques for disabling these banners when you login via SSH.

1. Disable motd - this is as simple as

   $ touch $HOME/.hushlogin

2. Disable the SSH pre authentication banner.
   If you are using PuTTY or KiTTY (PuTTY fork) then open the configuration window and navigate to SSH → Auth and uncheck 'Display pre-authentication banner'
   Note that:
   1. If you are using PuTTY you will need version 0.62
      (You should really try KiTTY - it offers some (for me) useful additional features).
   2. This will only work on SSH-2 connections.

MySQL

In my spare time I do some work for a local charity - which has meant getting up to speed with some new (for me) web and database software.

We have recently migrated their CRM to CiviCRM running on Drupal and MySQL. They currently have two environments - test/training and production but there is an impending Drupal and CiviCRM upgrade to consider.

For that we have copied their training environment onto a local NAS for some upgrade testing.

Initial reading made me think that copying the software and database stack would be a bit troublesome - in the event it was fairly straightforward.

• Copy the software install onto the NAS
  Basically just FTP everything from document root.
• Export the databases - we are using separate databases for Drupal and CiviCRM.
• Import databases onto the NAS.
• Edit the sites/default/civicrm.settings.php - change the database DSN, absolute file paths and base URL.
• Delete cached files in
  • sites/default/files/civicrm/templates_c/*
  • sites/default/files/civicrm/ConfigAndLog/Config.IDS.ini
  • sites/default/files/civicrm/ConfigAndLog/*

After that the site came up on the NAS without any issues.

Update:
If you are moving the site into somewhere other than the document root then you might need to rebuild your menu cache by running /civicrm/menu/rebuild?reset=1

Now for the upgrades …

CiviCRM Ref