vim on Debian 9 issue with cut and paste

July 25, 2017 Comments off

While using vi (vim) on Debian 9 via cli, there is an issue with cut and paste with a mouse.
This can be corrected by adding a .vimrc file to your user folder as shown below
##CONTENTS OF .vimrc
set mouse=””

This will re-enable the mouse cut and paste feature from a terminal.

Categories: sysadmin

Upgrade Debian Jessie to Strech

June 24, 2017 Comments off

The upgrade process is easy via the cli.
Just complete the following and answer any questions.
I let the system restart daemons automatically and kept original conf files.
This has worked on three Debian 8 systems without a hitch.

apt-get update
apt-get upgrade
apt-get dist-upgrade
cp /etc/apt/sources.list /etc/apt/sources.list_backup
sed -i ‘s/jessie/stretch/g’ /etc/apt/sources.list
apt-get update
apt list –upgradable
apt-get upgrade
apt-get dist-upgrade

After completing you can reboot and autoremove old packages.

Categories: sysadmin

copy your debian installed packages to a new machine

June 17, 2017 Comments off

Run this to retrieve a list of installed packages:

dpkg -l | grep ^ii | awk ‘{print $2}’ > installed_packages

Then install on new system with:

apt-get install $(cat installed_packages)

You should probably look at installed_packages and remove any obvious

Categories: sysadmin

Turn on syntax (color) in vim for Debian

February 8, 2017 Comments off

To add syntax checking to vim with Debian, just edit /etc/vim/vimrc and uncomment
the “syntax on” line.

Then your editor will show (in color) syntax errors in Postfix and html/css files.

Categories: sysadmin

disable or enable ipv6 ssh

September 20, 2016 Comments off

You may experience problems with ssh and ipv6. If so edit the /etc/ssh/sshd_config file
and enable the ListenAddress option. You can also enable (unpound) the ipv6
option ListenAddress ::.

You may experience lockouts from ssh if you have AAAA ipv6 records in your nameserver if
you don’t make theses changes.

Be sure and restart ssh after changes.

Categories: sysadmin

Check Spamassassin perl modules

June 19, 2016 Comments off

To check spamassassin and verify all required perl modules are installed
run this:

spamassassin -D –lint 2>&1 | grep -i failed

then use cpan install module::name ie
cpan install Digest::SHA1

Some additions are required to augment the default install. There is benefit
to adding missing modules as a more complete spam analysis will occur.

Categories: sysadmin

Backup/Copy mysql or mariadb database

March 19, 2016 Leave a comment

You can copy or backup all your databases with these commands including
coping to another server.

# backup
mysqldump -u root -p yourdb > mysqlbak.sql
or for dumping all databases
mysqldump –all-databases -u root -p > mysqlbakall.sql
# restore
mysql -u root -p yourdb < mysqlbak.sql
to restore all databases
mysql -u root -p < mysqlbakall.sql

Categories: sysadmin