Re: [mapserver-users] data parameter in tileindex

[Carlos Ruiz via mapserver-users]

Zmitser,
You have to have the following on a MAP file:
LAYER
...

 CONNECTION "host= ... password="CONNECTIONTYPE 

DATA " FROM  USING UNIQUE  USING SRID="
...
END
On DATA you must specify the name of the geometry column and the table, if 
you're using a database. If you are using a shape file you just have to include 
the DATA keyword with the path and the name of the SHP file.


On Tuesday, March 23, 2021, 2:34:48 AM CST, Zmitser Kozhukh via 
mapserver-users  wrote:  
 
 Dear mapserver users, I need to specify data parameter at the location item of 
tileindex.So far, I have tried many possibilities but none works:
‘host=127.0.0.1 dbname=database user=admin password=admin DATA "geom from table 
using unique id using srid=4326"’orhost=127.0.0.1 dbname=database user=admin 
password=admin data="geom from table using unique id using srid=4326"etc.Still 
I get an error :msDrawMap(): Image handling error. Failed to draw layer named 
'layer'. msPostGISLayerOpen(): Query error. Nothing specified in DATA 
statement.Could someone please tell in which format data statement should be?In 
documentation it is written vaguely:Normally the location should contain the 
path to the tile file relative to the shapepath, not relative to the tileindex 
itself. If the DATA parameter contains a value then it is added to the end of 
the location. --
Zmitser Kozhukh___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] PostgreSQL authentication method.

[Carlos Ruiz via mapserver-users]

The key is the message "authentication method 10 not supported". It seems that 
PostgreSQL client library's version is older and does not support that 
encryption method. Versions 10 and later supports it.

On Thursday, February 18, 2021, 3:49:48 PM CST, Steve Lime 
 wrote:  
 
 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.
On Thu, Feb 18, 2021 at 2:25 PM Moen, Paul T.  wrote:

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).

[Thu Feb 18 13:57:02.652879 2021] [php7:warn] [pid 16668] [client 
192.168.100.4:57341] 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: 
http://stagmapservice.swc.nd.gov/
Database connection failed (authentication method 10 not supported
) with connect string 'user=dauser password=** dbname=swc 
host=dadatabase.blah.blah.blah port=5432'
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?
msDrawMap(): Image handling error. Failed to draw layer named 'Countries - Natl 
Atlas'.

Is this an issue with MapServer?  If so, will scram-sha-256 authentication be 
supported by Mapserver?

Thanks,

Paul

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

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users