stefan-wegener

Bluetooth

Add user pi to bluetooth group

sudo adduser pi bluetooth
newgrp bluetooth

Change capabilities of bluetooth-service (/lib/systemd/system/bluetooth.service) add CAP_NET_RAW

CapabilityBoundingSet=CAP_NET_ADMIN CAP_NET_BIND_SERVICE CAP_NET_RAW

stefan-wegener

Install appropriate ODBC driver

curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo
sudo yum remove unixODBC-utf16 unixODBC-utf16-devel #to avoid conflicts
sudo ACCEPT_EULA=Y yum install msodbcsql17

(Source)[https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017]

Make sure dependencies for pyodbc package are met

On RHEL7:

stefan-wegener

Packages to install:
apt-get install libmyodbc unixodbc-bin freetds-dev freetds-bin tdsodbc unixodbc unixodbc-dev unixodbc-bin libodbc1 libtool autotools-dev

The path: /usr/lib/x86_64-linux-gnu/odbc/ may vary (under Raspbian it is: /usr/lib/arm-linux-gnueabihf/odbc/)

/etc/odbc.ini:
[<name>]
Driver = FreeTDS 
Servername=<yourname>
Port = 1433

stefan-wegener

Create key

ssh-keygen -b 4096 -t rsa -C <comment> -f <keyfile-name>

Config

Create file ~/.ssh/config

Host 10.8.0.1
 Hostname 10.8.0.1

stefan-wegener

Multiple environments with different DB connections:
Besides appsettings.json, create  appsettings.development.json, appsettings.staging.json, appsettings.production.json and move your connections strings there.

In code:
cs: if (env.IsDevelopment()) { ... }
cshtml:  <environment names="Development"> ... </environment> 

stefan-wegener

Variable usage

echo '${test}' // prints ${test}
echo "${test}" // prints value of variable

Loops