PostgreSQL 13+: "[FireDAC][Phys][PG][libpq] authentication method 10 not supported." error

[Torben]

Here is infomation for all users that intend to use mAirList with version 13 and later of the PostgreSQL server:

PostgreSQL 13 (and later) uses the new scram-sha-256 password encryption by default, something that is not supported by the libpq.dll client library shipped with mAirList by the time of this writing (v6.3.6).

Thus, you will see the following error:

[FireDAC][Phys][PG][libpq] authentication method 10 not supported.

We are going to ship an updated libpq.dll in the near future. Until then, you can perform the following steps to work around the problem:

• Edit postgresql.conf on the server, and change password_encryption = 'scram-sha-256' to password_encryption = 'md5'
• Make sure md5 is used in pg_hba.conf for the authentication line that refers to your IP network.
• Restart PostgreSQL service.
• If the SQL user (login role) for your mAirList database has already been created, reset its password, so it is saved in md5 format.

Update 2021-10-28:

Here is a newer version of libpq.dll that should support the new scram-sha-256 password scheme: http://download.mairlist.com/other/libpq-13/libpq.dll

Just replace the existing libpq.dll file in your mAirList program folder (usually C:\Program Files (x86)\mAirList x.x).

Update 2020-10-22:

As the above DLL did not work for everyone, here is a complete package of a libpq.dll (32bit, version 10.8-2) along with all other DLLs it depends on:
libpq10.zip

To unstall it, download libpq10.zip, unzip and copy all content to your mAirList program folder C:\Program Files (x86)\mAirList x.x, overwriting the existing libpq.dll.

Unlike the previous version currently shipped with mAirList, this new libpql.dll may require that you install the Microsoft Visual C++ Redistributable (vcredist) package if it is not installed on your computer yet. You can download it here:

Visual C++ Redistributable Packages for Visual Studio 2013

Important: You need to install the x86 (32-bit) version of vcredist, even if your Windows system is 64-bit.

If vcredist 2013 is missing, you will see the following message when connecting to your mAirListDB database:

[FireDAC][Phys][PGSQL]-314. Cannot load vendor library [LIBPQ.DLL]. The specified module could not be found. Check [LIBPQ.DLL], which is located in one of the PATH directories or in application EXE directory.

This may be slightly misleading, as the libpq.dll file itself is present, it is just a dependency (vcredist) that is actually missing.

We will not ship this new version by default at this point, as the vcredist dependency is likely to break the installation for many existing users, and most are using older PostgreSQL server versions (below 13) anyway.

[Alanqfm]

I was just doing these steps. But on the same pc it works. I can connect the db and i can also connect it to the playout software. But when i try to connect the database on the onair studio pc, it shows same error. “Authentication metho10 not supported”

This is the NEW PC. I want to connect this to Onair studio PC for playout. When i try that it shows the error.

[MartinHeuser]

Hallo @Torben, ich habe diesen Post gefunden, weil ich aktuell eine PostGre SQL Datenbank in einem Hetzner Webhosting als SQL Datenbank nutzen will und ich dann gelernt habe, dass man die dlls tauschen soll, wegen der Authentifizierung mit der neuen Methode in neueren PostGreSQL Datenbanken, die der Hetzner nutzt.

Ich habe das Zip entpackt und die Datein in das Verzeichnis gelegt. Die Fehlermeldung wegen der Methode 10 kommt nicht mehr, aber nun kommt dieser Fehler:

Kannst Du mir hier weiterhelfen, was ich noch anpassen muss?

Viele Grüße
Martin

[Torben]

Der Fehler bedeutet, dass du die x64-Version der libpq.dll dort abgelegt hast; benötigt wird aber die x86-Version (32bit), da mAirList eine 32bit-Anwendung ist.

Bei mAIrList 7 wird die passende DLL aber mittlerweile mitgeliefert, und es sollte keine Notwendigkeit mehr bestehen sie händisch auszutauschen.

[MartinHeuser]

Vielen Dank Torben für Deine schnelle Antwort. Wir sind noch auf Mairlist6. Ich hatte das ZIP entpackt und alle Dateien in das ML Verzeichnis gelegt. War das falsch? Bzw. wo kann ich denn entscheiden, dass ich die 32Bit Version der dll möchte?

Grüße
Martin

[Torben]

vcredist hast du auch installiert wie oben beschrieben?

(Vielleicht liegt es doch nicht an der bitness sondern an fehlenden Abhängigkeiten.)

[MartinHeuser]

Ja, das hab ich gemacht
Ich habe die x86 Version installiert

[shorty.xs]

Sorry to bring up this old thread.
I’m just in my first tests to migrate fom mairlist 6.3.23 to 7.4. PostgreSQL is still the old 13.23, I’d prefere to migrate to a new version in a later stage.

I’m running into the error

@Torben

[FireDAC][Phys][PGSQL]-314. Cannot load vendor library [LIBPQ.DLL]. The specified module could not be found. Check [LIBPQ.DLL], which is located in one of the PATH directories or in application EXE directory.

mAirlist Install method was ZIP file. I took a copy of my old mAirlist and unzipped the 7.4 over it, overvriting all existing files, vcredist 2013 is already installed otherwise mAirlist 6.3 would not work.

Launching command line is: S:\mairlist7\mAirList.exe -mode config -rootfolder “M:\mAirListData\CONF” The error pops up on DB test from the config.
Drive m: and drive s: are both local redirects created with subst, they are no network drives.

I also tried to download https://download.mairlist.com/other/libpq10.zip and copy all of that files into my mairlist 7 root folder. Overwriting all files that were already present. (Seems to be the same versions anyway) No difference in behavior.

Do I need another vcredist? Using the installer, mAirlist 7 installed 2 Version vcredst but I can’t remember the 2nd one.

OS is Win11 21h2

[shorty.xs]

@Stefan_Hillen @Torben kann einer von euch was zu dem Problem sagen?

[Torben]

mAirList 7 and 8 ship with the “modern” libpq.dll, the same that can be downloaded manually from our download servers (see first post).

If you still get the error message that the DLL cannot be found (or actually, cannot be loaded), there is certainly something wrong with the vcredist installation, or another dependency we are not aware of.

[shorty.xs]

Thanks @Torben .

I guess I found it. It must be one of the VCRedist packages.

I reinstalled 2010 (although it was the latest), added 2012, added latest 2013, and v14.

Ignore the x64 ones I am aware these are not required for mAirlist.

Just in case somebody needs the downloads, here is the original Microsoft page:

Latest Supported Visual C++ Redistributable Downloads

By the way, I was able to install these packages without reboooting and mairlist 6 kept on working flawless, while doing so.

[Torben]

Thanks for the feedback!

Maybe the installed package was corrupted in some way? Similar to this thing: Error 0xc000007b when starting mAirList, missing or corrupt vcredist