<html><head></head><body><div class="ydpc7034318yahoo-style-wrap" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif; font-size: 13px;"><div><div dir="ltr" data-setdir="false">The key is <span>the message "authentication method 10 not supported</span>". It seems that PostgreSQL client library's version is older and does not support that encryption method. Versions 10 and later supports it.<br></div><br></div>
</div><div id="ydpa8ff6e64yahoo_quoted_3947295943" class="ydpa8ff6e64yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Thursday, February 18, 2021, 3:49:48 PM CST, Steve Lime <sdlime@gmail.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydpa8ff6e64yiv5882022191"><div><div dir="ltr">I wonder if that's more a function of the PostgreSQL client library version/capabilities. Do you know what MapServer is compiled against? You might try connecting to your database with psql as another test of the client lib.</div><br clear="none"><div class="ydpa8ff6e64yiv5882022191yqt3646189048" id="ydpa8ff6e64yiv5882022191yqt30325"><div class="ydpa8ff6e64yiv5882022191gmail_quote"><div class="ydpa8ff6e64yiv5882022191gmail_attr" dir="ltr">On Thu, Feb 18, 2021 at 2:25 PM Moen, Paul T. <<a shape="rect" href="mailto:pmoen@nd.gov" rel="nofollow" target="_blank">pmoen@nd.gov</a>> wrote:<br clear="none"></div><blockquote class="ydpa8ff6e64yiv5882022191gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex;">I recently tried a Mapserver layer connected to a PostgreSQL 13.2 database that had password_encryption = scram-sha-256. I was unsuccessful in getting it to work until I switched it to md5 and reset the passwords. The following error was logged and the interesting part seems to be (authentication method 10 not supported).<br clear="none">
<br clear="none">
[Thu Feb 18 13:57:02.652879 2021] [php7:warn] [pid 16668] [client <a shape="rect" href="http://192.168.100.4:57341" rel="nofollow" target="_blank">192.168.100.4:57341</a>] PHP Warning: mapObj::drawQuery(): [MapServer Error]: msPostGISLayerOpen(): Database connection failed. Check server logs for more details.Is the database running? Is it allowing connections? Does the specified user exist? Is the password valid? Is the database on the standard port?\n in /Volumes/Data/WebServer/newswc/php/drawmappm.php on line 243, referer: <a shape="rect" href="http://stagmapservice.swc.nd.gov/" rel="nofollow" target="_blank">http://stagmapservice.swc.nd.gov/</a><br clear="none">
Database connection failed (authentication method 10 not supported<br clear="none">
) with connect string 'user=dauser password=****** dbname=swc host=dadatabase.blah.blah.blah port=5432'<br clear="none">
Is the database running? Is it allowing connections? Does the specified user exist? Is the password valid? Is the database on the standard port? in msPostGISLayerOpen()msPostGISLayerOpen(): Query error. Database connection failed. Check server logs for more details.Is the database running? Is it allowing connections? Does the specified user exist? Is the password valid? Is the database on the standard port?<br clear="none">
msDrawMap(): Image handling error. Failed to draw layer named 'Countries - Natl Atlas'.<br clear="none">
<br clear="none">
Is this an issue with MapServer? If so, will scram-sha-256 authentication be supported by Mapserver?<br clear="none">
<br clear="none">
Thanks,<br clear="none">
<br clear="none">
Paul<br clear="none">
<br clear="none">
MapServer version 7.6.2 OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=CAIRO SUPPORTS=ICONV SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=GEOS SUPPORTS=POINT_Z_M SUPPORTS=PBF INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE<br clear="none">
<br clear="none">
_______________________________________________<br clear="none">
mapserver-users mailing list<br clear="none">
<a shape="rect" href="mailto:mapserver-users@lists.osgeo.org" rel="nofollow" target="_blank">mapserver-users@lists.osgeo.org</a><br clear="none">
<a shape="rect" href="https://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="nofollow" target="_blank">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br clear="none">
</blockquote></div></div>
</div></div><div class="ydpa8ff6e64yqt3646189048" id="ydpa8ff6e64yqt63377">_______________________________________________<br clear="none">mapserver-users mailing list<br clear="none"><a shape="rect" href="mailto:mapserver-users@lists.osgeo.org" rel="nofollow" target="_blank">mapserver-users@lists.osgeo.org</a><br clear="none"><a shape="rect" href="https://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="nofollow" target="_blank">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br clear="none"></div></div>
</div>
</div></body></html>