No Image

Fixing pymssql 2.1.5 from pip to work on CentOS7

26/09/2020 juliogonzalez 0

Updating the tds_fdw Continuous Integration to test CentOS7, I noticed pymsql 2.1.5 could not connect anymore to our Azure SQL Database and all I could get was:

pymssql.OperationalError: (20002, 'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (instance.database.windows.net)\n')

Enabling TDS debugging revealed that, for some reason, the Azure SQL database just rejected the logging information:

(more…)
No Image

optirun/primusrun on openSUSE Leap 15.2

05/09/2020 juliogonzalez 0

After updating to from openSUSE Leap 15.1 to openSUSE Leap 15.2, the good optirun command stopped working, even with all the Nvidia required packages installed:

$ optirun -b primus ./start.sh  
primus: fatal: failed to load any of the libraries: /usr/lib64/nvidia/libGL.so.1:/usr/lib/nvidia/libGL.so.1
/usr/lib64/nvidia/libGL.so.1: cannot open shared object file: No such file or directory
/usr/lib/nvidia/libGL.so.1: cannot open shared object file: No such file or directory

The thing is that in the end I do not want to switch the graphics card using prime-select, as that means using the card for everything, and requires closing the session.

So thanks to this reddit post I noticed that there could be a solution.

Running (as root):

ln -s /usr/X11R6/lib/libGL.so.1 /usr/lib/nvidia/libGL.so.1
ln -s /usr/X11R6/lib64/libGL.so.1 /usr/lib64/nvidia/libGL.so.1

And ready, optirun runs fine once again. And it seems primusrun works as well.