Copy file To Remote using ssh

scp

To copy a file from one local machine to a remote machine using ssh, do the following;

scp /local/path/to/file username@ip_address:/path/to/remote/destination

or if we wish to get a file from a remote machine to the local machine, we can do;

scp username@ip_address:/path/to/remote/file /local/path/to/destination

 

Linux Serial Ports

TODO

[source]

Add static route to windows

To add a static route to windows, do the following;

route add destination mask gateway metric interface

route add 23.128.16.0 255.255.240.0 23.128.16.1 IF 13

Note, in the above we are ignoring the metric.

The interface number can be found from;

netsh interface ipv4 show interfaces

Selecting distinct columns with MySQL

In the past I was sure it was not possible in MySQL to use DISTINCT on multiple columns, such as below;

SELECT DISTINCT a,b FROM my_table;

and have in the past, instead used something similar to the below as a workaround;

SELECT DISTINCT CONCAT (a,' ', b) FROM my_table;

However, it seems I am remiss and MySQL does indeed support DISTINCT on multiple columns.

 

Windows shares not connecting from Thunar in Linux

I came across an issue where Windows network shares would not open using Thunar file manager in Slackware.

With a fair bit of digging around, I eventually downgraded samba from 4.15.13 to 4.15.5 which in my case was what was installed with Slackware 15.

Cell Background colour not showing in LibreOffice Calc

This can be resolved in Tools>Options>LibreOffice>Accessibility and ensuring that Options For High Contrast Appearance is Disabled, as below;

Add custom command to nagios

 In this example, we add the plugin to check MySQL replication status [source]

Show mysql variables

We can show mysql variables with the following;

SHOW VARIABLES WHERE variable_name = 'some_variable';

SHOW VARIABLES LIKE '%some_variable%';

Example, to show the number of days binary logs are retained for;

SHOW VARIABLES WHERE variable_name = 'expire_logs_days';

Set date as a string

The following format allows you to set the current date from a string;

sudo date -s '2023-01-14 11:22:00'

where the above date refers to 14th Jan 2023

Debian Archive

Debian archive for sources.list

http://archive.debian.org/debian-archive/debian/dists/ 

The sources.list file may look like (need to check the deb-src entries);

deb [trusted=yes] http://archive.debian.org/debian-archive/debian/ squeeze main non-free contrib

deb-src [trusted=yes] http://archive.debian.org/debian-archive/debian/ squeeze main non-free contrib

deb [trusted=yes] http://archive.debian.org/debian-archive/debian/ wheezy main non-free contrib

deb-src [trusted=yes] http://archive.debian.org/debian-archive/debian/ wheezy main non-free contrib

deb [trusted=yes] http://archive.debian.org/debian-archive/debian/ jessie main non-free contrib

deb-src [trusted=yes] http://archive.debian.org/debian-archive/debian/ jessie main non-free contrib

deb [trusted=yes] http://deb.debian.org/debian/ buster main non-free contrib

deb-src [trusted=yes] http://deb.debian.org/debian/ buster main non-free contrib

Also:

echo "Acquire::Check-Valid-Until "false";" >> /etc/apt/apt.conf.d/99no-check-valid-until
echo "Acquire::AllowInsecureRepositories "true";" >> /etc/apt/apt.conf.d/99no-check-valid-until
echo "APT::Get::AllowUnauthenticated "true";" >> /etc/apt/apt.conf.d/99no-check-valid-until

apt-key add /root/archive-key-6.0.asc (acquired from the keys.html link below *)

See also:

https://wiki.debian.org/SourcesList

https://ftp-master.debian.org/keys.html (* get key file from here and do apt-ket add key-file)