OperationalError at /api/…

(‘08001’, ‘[08001] [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x2746 (10054) (SQLDriverConnect)’)

edit /etc/ssl/openssl.cnf

add this to beginning of the file:

openssl_conf = default_conf

end this to end of the file:

[ default_conf ]

ssl_conf = ssl_sect

[ssl_sect]

system_default = system_default_sect

[system_default_sect]
MinProtocol = TLSv1.2
CipherString = DEFAULT:@SECLEVEL=1

thanks to: https://github.com/mkleehammer/pyodbc/issues/610

You can type

sudo snap abort --last=install

if you get “OSError: mysql_config not found” error while installing mysqlclient with python pip

you can use the following command to install necessary library

sudo apt-get install libmysqlclient-dev

Note that this solution is tested on ubuntu 18.04 lts

Thanks: https://stackoverflow.com/questions/7475223/mysql-config-not-found-when-installing-mysqldb-python-interface

nano /etc/rc.local

echo nameserver 127.0.0.1 >> /etc/resolv.conf

https://vpsfix.com/6430/fix-system-is-not-setup-to-use-itself-as-a-dns-server/

static const uint8_t D0 = 16;
static const uint8_t D1 = 5;
static const uint8_t D2 = 4;
static const uint8_t D3 = 0;
static const uint8_t D4 = 2;
static const uint8_t D5 = 14;
static const uint8_t D6 = 12;
static const uint8_t D7 = 13;
static const uint8_t D8 = 15;
static const uint8_t D9 = 3;
static const uint8_t D10 = 1;

Thanks to https://github.com/esp8266/Arduino/issues/584#issuecomment-123715951


ARCH=$(uname -m)
PYTHON="3.5.2"
curl -L https://raw.githubusercontent.com/yyuu/pyenv-installer/master/bin/pyenv-installer | bash
apt-get install -y libssl-dev libacl1-dev liblz4-dev libfuse-dev fuse pkg-config
apt-get install -y fakeroot build-essential git
apt-get install -y zlib1g-dev libbz2-dev libncurses5-dev libreadline-dev liblzma-dev libsqlite3-dev
env PYTHON_CONFIGURE_OPTS="--enable-shared" pyenv install -v $PYTHON
pyenv shell $PYTHON
cd /opt
git clone https://github.com/borgbackup/borg/
cd borg
git checkout 1.0.3
pip install -r requirements.d/development.txt
cd /opt
git clone https://github.com/pyinstaller/pyinstaller.git
cd pyinstaller
git checkout v3.1.1
cd bootloader
python ./waf all --no-lsb
cd ..
pip install -e .
cd /opt/borg
pip install -e .
LD_LIBRARY_PATH=~/.pyenv/versions/$PYTHON/lib/ pyinstaller -F -n borg-$ARCH --clean borg/__main__.py

Credits: bauerj‘s comment on https://github.com/borgbackup/borg/issues/1018

df -h -x tmpfs -x devtmpfs

docker exec -it <containerIdOrName> bash

thanks: https://askubuntu.com/a/543057

stop running container

docker stop test01

commit the container

docker commit test01 test02

NOTE: The above, test02 is a new image that I’m constructing from the test01 container.

re-run from the commited image

docker run -p 8080:8080 -td test02

thanks: https://stackoverflow.com/a/26622041