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

[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

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

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

Pyinstaller Installation On ARM


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