ImportError: libldap_r-2.4.so.2: cannot open shared object file: No such file or directory

Issue: ImportError: libldap_r-2.4.so.2: cannot open shared object file: No such file or directory
Solution: The latest version of your OS may be missing the libldap_r-2.4.so.2 and your software depends on it. Install libldap_r-2.4.so.2 manually.

Head over to http://security.ubuntu.com/ubuntu/pool/main/o/openldap/

sudo wget http://security.ubuntu.com/ubuntu/pool/main/o/openldap/libldap-2.4-2-dbg_2.4.42+dfsg-2ubuntu3.13_amd64.deb	
sudo apt install libldap-2.4-2-dbg_2.4.42+dfsg-2ubuntu3.13_amd64.deb

OR

Head over to http://http.us.debian.org/debian/pool/main/o/openldap/

sudo wget http://http.us.debian.org/debian/pool/main/o/openldap/libldap-2.4-2_2.4.47+dfsg-3+deb10u7_amd64.deb 
sudo apt install libldap-2.4-2_2.4.47+dfsg-3+deb10u7_amd64.deb

ParseError: syntax error, unexpected ‘|’ module content_export_csv

Error:
“ParseError: syntax error, unexpected ‘|’ , expecting ‘;’ or ‘{‘ in Composer\Autoload\{closure}() (line 76 of modules/contrib/content_export_csv/src/ContentExport.php).”

The issue is related to the PHP version and the module in question.
In this case: content_export_csv. The Union Types “: int|array” caused the issue and it is not supported by your PHP version.

Here the line 76 referenced that is giving the error:
"public function getNodeIds(string $nodeType, int $status = 1) : int|array {"


In my case, I simply removed it and I was able to use the module on PHP7.4.
The function now becomes:
public function getNodeIds(string $nodeType, int $status = 1) {

Makefile sqlsrv.la Error 1 Ubuntu 22.04


If you are getting this error while trying to install Microsoft Drivers for PHP for SQL server

sudo pecl install sqlsrv 
sudo pecl install pdo_sqlsrv

you should do the following:

First:

Inspect this folder /usr/lib/x86_64-linux-gnu/ and verify that the following file exists: libltdl.la

Second:

If the file does not exist, just run the following command to create a blank file:

touch /usr/lib/x86_64-linux-gnu/libltdl.la

Try to run the pecl command again

sudo pecl install sqlsrv
sudo pecl install pdo_sqlsrv

Third:

If the issue still persists, create a new file and copy the following content to it:
https://www.apt-browse.org/browse/debian/jessie/main/amd64/libltdl-dev/2.4.2-1.11+b1/file/usr/lib/x86_64-linux-gnu/libltdl.la
and try to install the sqlsrv and pdo_sqlsrv again.
then verify that you can see the pdo_sqlsrv module by running:

php -m

Reference
Linux and macOS Installation Tutorial for the Microsoft Drivers for PHP for SQL Server

Install the Microsoft ODBC driver for SQL Server (Linux)

No HDMI Audio Ubuntu 20.04 and Ubuntu 21.04 NUC Micro PC

Symptoms / Issues
Audio setting is stuck on  “Dummy Output”
NUC is not playing audio via HDMI

Assumption:
No issue with your hardware.
Sound is working USB-C or 3.5mm jack

Findings:
It appears that the issue is related to the Kernel and the Audio Driver.

Solution:
Updated the Linux kernel from the stock ubuntu 20.04 and 21.04 kernel 5.11.x-xx-generic to the version 5.14.9 fix the issue for us.

Here is the kernel that works for us:
NUC HDMI issue fix

Our new kernels were downloaded from the following URL:
https://kernel.ubuntu.com/~kernel-ppa/mainline/v5.14.9/amd64/ 

Use
sudo dpkg -i  linux[exact version number].deb
to install your new kernel.
Do a google search to find information on how to update your Ubuntu 20.04 or 21.04 kernel.

Update your kernel to 5.14:

NB:  Updating your kernel will update your boot files, please make sure that you know what you are doing and that you can recover your system in case the latter becomes unbootable.