pyodbc 0x2746 (10054) fıx ubuntu 20.04 lts

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


system_default = system_default_sect

MinProtocol = TLSv1.2
CipherString = DEFAULT:@SECLEVEL=1

thanks to:

virtualmin mysqlclient error

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


Pyinstaller Installation On ARM

ARCH=$(uname -m)
curl -L | 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
cd borg
git checkout 1.0.3
pip install -r requirements.d/development.txt
cd /opt
git clone
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/

Credits: bauerj‘s comment on