OpenSSH Tip: Check Syntax Errors before Restarting SSHD Server

Posted on in Categories Linux, Networking, OpenBSD, RedHat/Fedora Linux, Security, Sys admin, Tips, Troubleshooting, UNIX last updated June 17, 2017
OpenSSH - SSHD Logo

OOpenSSH (OpenBSD Secure Shell) is a default secure shell for encrypted communication sessions over a computer network using the ssh protocol. Usually, you log in using ssh and makes changes to its configuration file /etc/ssh/sshd_conf over a remote session. If there is an error in configuration, the server may not start (i.e. no remote login allowed). This will result in a disaster; if you didn’t have access to the remote console. But how do you find out a syntax error for the sshd_config file?
Continue reading “OpenSSH Tip: Check Syntax Errors before Restarting SSHD Server”

Quickly Backup / dump MySql / Postgres database to another remote server securely

Posted on in Categories Backup, FreeBSD, Howto, Linux, MySQL, Postgresql, RedHat/Fedora Linux, Sys admin, Tips, UNIX last updated October 1, 2007

Using UNIX pipe concept one can dump database to another server securely using ssh protocol. All you need remote execution rights for the ‘dd’ command, over SSH. This allows you to run database dumps across an encrypted channel.

Dump Postgres Database using ssh

Use pg_dump command command:
pg_dump -U USERNAME YOUR-DATABASE-NAME | ssh [email protected] "dd of=/pgsql/$(date +'%d-%m-%y')"

Dump MySQL Database using ssh

Type the following command:
mysqldump -u USERnAME -p'PASSWORD' YOUR-DATABASE-NAME | ssh [email protected] "dd of=/mysql/$(date +'%d-%m-%y')"

Happy 8th Birthday, OpenSSH!

Posted on in Categories News, OpenBSD last updated September 27, 2007

OpenSSH is most prominent implementation of the SSH protocol. I can’t imagine my life without OpenSSH. Almost all of my devices / server / network equipment such as routers and tiny embedded device has OpenSSH these days.
Happy 8th Birthday, OpenSSH! - Logo
From OpenBSD journal:

Eight years ago today, Sept 26 1999, Theo de Raadt committed the initial source code for OpenSSH to the OpenBSD repository. The code was a fork of Björn Grönvall’s OSSH, which was derived from an early version of the increasingly “less free” ssh from Tatu Ylönen.