[mapserver-users] R: Problem with PostGIS 3.0.0

[Roberto Marzocchi]

Sorry it isn't a problem of mapserver.

There is only a problem with permission of public schema. 



All the best, 
R





Eng. Roberto Marzocchi, PhD

CTO - Chief Technology Officer

Gter srl (Unige spin-off)

Via Ruffini 9R - 16128 Genova 

http://P.IVA/CF 01998770992 

ph: 010-0899150 - mob: 349-8786575 

E-mail: mailto:roberto.marzocchi at gter.it http://www.gter.it 



-- 

Gter social 

http://www.twitter.com/Gteronline - http://www.facebook.com/Gteronline 

http://www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-gis 



----------------------------------------------------------------- 

Please consider the environment before printing this email! 






---- Attivato gio, 26 mar 2020 21:56:49 +0100 Roberto Marzocchi <roberto.marzocchi at gter.it> ha scritto ----


On the server log this is the error:



2020-03-26 21:43:32.939 CET [27786] user at dbname STATEMENT:  SELECT postgis_version() 

2020-03-26 21:43:34.185 CET [28060] user at dbname ERROR:  function postgis_version() does not exist at character 8

2020-03-26 21:43:34.185 CET [28060] user at dbname HINT:  No function matches the given name and argument types. You might need to add explicit type casts.




Eng. Roberto Marzocchi, PhD

CTO - Chief Technology Officer

Gter srl (Unige spin-off)

Via Ruffini 9R - 16128 Genova 

http://P.IVA/CF 01998770992 

ph: 010-0899150 - mob: 349-8786575 

E-mail: mailto:roberto.marzocchi at gter.it http://www.gter.it 



-- 

Gter social 

http://www.twitter.com/Gteronline - http://www.facebook.com/Gteronline 

http://www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-gis 



----------------------------------------------------------------- 

Please consider the environment before printing this email! 






---- Attivato gio, 26 mar 2020 21:47:02 +0100 Roberto Marzocchi <mailto:roberto.marzocchi at gter.it> ha scritto ----










I have a mapserver 7.0.7 installed on a Ubuntu server 18.04.



I have updated to PostGIS v. 3.0.0 and for some layers I encountered the following error: 



<?xml version='1.0' encoding="UTF-8" standalone="no" ?>

<!DOCTYPE ServiceExceptionReport SYSTEM "http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd">

<ServiceExceptionReport version="1.1.1">

<ServiceException>

msDrawMap(): Image handling error. Failed to draw layer named 'M_vel_10'.

msPostGISRetrieveVersion(): Query error. Error executing SQL. check server logs.

</ServiceException>

</ServiceExceptionReport>



Anyone have suggestion?



Thanks in advanced,

R 



Eng. Roberto Marzocchi, PhD

CTO - Chief Technology Officer

Gter srl (Unige spin-off)

Via Ruffini 9R - 16128 Genova 

http://P.IVA/CF 01998770992 

ph: 010-0899150 - mob: 349-8786575 

E-mail: mailto:roberto.marzocchi at gter.it http://www.gter.it 



-- 

Gter social 

http://www.twitter.com/Gteronline - http://www.facebook.com/Gteronline 

http://www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-gis 



----------------------------------------------------------------- 

Please consider the environment before printing this email!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20200326/ec3e9c66/attachment.html>