Some of our users in MariaDB are authenticated via PAM. the authentication works as they can login from the command line.
When trying to login using HeidiSQL v9.4.0.5125 portable, the application throws and error:
date/time : 2016-12-01, 10:22:19, 885ms
registered owner : capture
operating system : Windows 7 x64 Service Pack 1 build 7601
system language : English
system up time : 2 hours 21 minutes
program up time : 3 minutes 13 seconds
processors : 4x Intel(R) Core(TM) i5-4300M CPU @ 2.60GHz
physical memory : 4489/7877 MB (free/total)
free disk space : (C:) 27.68 GB (I:) 304.99 MB
display mode : 1366x768, 32 bit
process id : $720
allocated memory : 52.13 MB
largest free block : 1.22 GB
executable : heidisql.exe
exec. date/time : 2016-10-21 13:41
version : 9.4.0.5125
compiled with : Delphi XE5
madExcept version : 4.0.12
callstack crc : $5a1912d9, $b1044206, $b1044206
exception number : 1
exception class : EAccessViolation
exception message : Access violation at address 5A1912D9 in module 'dialog.dll'. Read of address 02100301.
main thread ($16c8):
5a1912d9 dialog.dll
5587b1c4 libmysql.dll mysql_real_connect
00845772 heidisql.exe dbconnection 1680 +63 TMySQLConnection.SetActive
0095db07 heidisql.exe Main 3627 +7 TMainForm.InitConnection
008dabe6 heidisql.exe connections 330 +5 Tconnform.btnOpenClick
005b1563 heidisql.exe Vcl.Controls TControl.Click
005d3f42 heidisql.exe Vcl.StdCtrls TCustomButton.Click
005d4abc heidisql.exe Vcl.StdCtrls TCustomButton.CNCommand
005b100d heidisql.exe Vcl.Controls TControl.WndProc
005b5b2d heidisql.exe Vcl.Controls TWinControl.WndProc
005d3bec heidisql.exe Vcl.StdCtrls TButtonControl.WndProc
005b0c48 heidisql.exe Vcl.Controls TControl.Perform
005b5c93 heidisql.exe Vcl.Controls DoControlMsg
005b6723 heidisql.exe Vcl.Controls TWinControl.WMCommand
0067fc8c heidisql.exe Vcl.Forms TCustomForm.WMCommand
005b100d heidisql.exe Vcl.Controls TControl.WndProc
005b5b2d heidisql.exe Vcl.Controls TWinControl.WndProc
0067ca99 heidisql.exe Vcl.Forms TCustomForm.WndProc
0053c65c heidisql.exe System.Classes StdWndProc
005b5170 heidisql.exe Vcl.Controls TWinControl.MainWndProc
0053c65c heidisql.exe System.Classes StdWndProc
765196d0 USER32.dll SendMessageW
76520d58 USER32.dll CallWindowProcW
005b5c3e heidisql.exe Vcl.Controls TWinControl.DefaultHandler
005b19b8 heidisql.exe Vcl.Controls TControl.WMLButtonUp
005b100d heidisql.exe Vcl.Controls TControl.WndProc
005b5b2d heidisql.exe Vcl.Controls TWinControl.WndProc
005d3bec heidisql.exe Vcl.StdCtrls TButtonControl.WndProc
005b5170 heidisql.exe Vcl.Controls TWinControl.MainWndProc
0053c65c heidisql.exe System.Classes StdWndProc
76517895 USER32.dll DispatchMessageW
00686167 heidisql.exe Vcl.Forms TApplication.ProcessMessage
006861aa heidisql.exe Vcl.Forms TApplication.HandleMessage
00681516 heidisql.exe Vcl.Forms TCustomForm.ShowModal
00956297 heidisql.exe Main 2062 +11 TMainForm.actDisconnectExecute
0053b94b heidisql.exe System.Classes TBasicAction.Execute
00595523 heidisql.exe Vcl.ActnList TCustomAction.Execute
0053b7eb heidisql.exe System.Classes TBasicActionLink.Execute
005b154c heidisql.exe Vcl.Controls TControl.Click
005f80f8 heidisql.exe Vcl.ComCtrls TToolButton.Click
005b1a0d heidisql.exe Vcl.Controls TControl.WMLButtonUp
005b100d heidisql.exe Vcl.Controls TControl.WndProc
005b0c48 heidisql.exe Vcl.Controls TControl.Perform
005b5268 heidisql.exe Vcl.Controls GetControlAtPos
005b5332 heidisql.exe Vcl.Controls TWinControl.ControlAtPos
005b0c48 heidisql.exe Vcl.Controls TControl.Perform
005b53fc heidisql.exe Vcl.Controls TWinControl.IsControlMouseMsg
005b59a9 heidisql.exe Vcl.Controls TWinControl.WndProc
005fcc68 heidisql.exe Vcl.ComCtrls TToolBar.WndProc
005b5170 heidisql.exe Vcl.Controls TWinControl.MainWndProc
0053c65c heidisql.exe System.Classes StdWndProc
76517895 USER32.dll DispatchMessageW
00686167 heidisql.exe Vcl.Forms TApplication.ProcessMessage
006861aa heidisql.exe Vcl.Forms TApplication.HandleMessage
006864e5 heidisql.exe Vcl.Forms TApplication.Run
76943388 kernel32.dll BaseThreadInitThunk
I managed to solve the issue.
I downloaded the MariaDB window version (10.0.20) that corresponded to the version on our server and replaced the libmysql.dll and dialog.dll files that were shipped with HeidiSQL with the ones from MariaDB.
Not sure if it will introduce any new problems, but at least I can login now.