[Qgis-user] Record the cracks in our (private) streets

2019-12-13 Per discussione Doug
I have imported a set of drone pictures to QGIS. They show the streets
in my subdivision. I want to "record" the cracks in the pavement to be
able to compare  them over time. I want to be able to segment the
streets in arbitrary lengths. For each segment, I want to "draw" the
cracks (in layers) to record where they are. Every year or two I will
repeat the process. The purpose is to be able to compare the set of
cracks in successive snapshots to see how the asphalt is holding up
and identify underlying problems. I would love to have some software
to find the cracks for me and generate the crack layer, if anyone
knows of such software.

 

First problem: I can trace the outline of the streets to generate a
layer which represents to road surface. Is there a way to slice that
layer by picking two points to "slice" the layer and then have two
layers? And then repeat the process so that I get the segments that I
want? Alternatively, is there a way to create a segment and "snap" to
next segment so there is not overlap or missing space?

 

Second problem. Given that I have a layer representing a segment of
the road surface, can I "draw" the cracks for that segment such that
every line in the cracks layer is related (as in SQL) to the segment
it reside in?

 

Once I have the road surface segments, and the associated cracks, I
can then use SQL to generate all sorts of reports on the cracks:
average and median length, number of horizontal and vertical cracks,
total crack length per road surface segment (or square feet), etc.

 

Thanks.

Doug

 

 

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Working with DEMs

2019-12-13 Per discussione Bernd Vogelgesang

Hey Dave,

whats up?

Sent you a raster and steps to reproduce. No answer?

Am 13.12.19 um 17:22 schrieb qgis-u...@stripfamily.net:

On 12/13/2019 8:20 AM, Dave Gardiner wrote:
> Hi
>
> I just can't find a suitable one in New zealand
>
> Dave
The SRTM covers New Zealand. This website provides
a fairly friendly interface to download 30M SRTM DEM tiles.

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] ITRF00

2019-12-13 Per discussione Even Rouault
On vendredi 13 décembre 2019 13:01:36 CET malcolm wrote:
> The proj definition below is what I am using to convert data using PostGIS
> from NAD83 to WGS84 in a separate application. This creates data that
> matches what is transformed from ArcMap using the ITRF00 transformation
> (which is default in the latest version). The NAD83 datum in PostGIS is
> simply towgs84=0,0,0,0,0,0,0. I am using the 3735 projection for NAD83
> (Ohio SP South).
> 
> +proj=lcc +lat_1=40.03 +lat_2=38.73 +lat_0=38
> +lon_0=-82.5 +x_0=60 +y_0=0 +ellps=GRS80
> +towgs84=-0.9956,1.9013,0.5215,0.025915,0.009246,0.011599,-0.00062
> +units=us-ft +no_defs
> 

(adding back the list)

OK, so from the above parameters and digging into the EPSG database, it seems 
to be the NAD83(CORS96) to ITRF2000 transformation, with the omission of the 
time dependant terms:

$ projinfo -s "NAD83(CORS96)" -t ITRF2000 --spatial-test intersects -o PROJ
Candidate operations found: 2
-
Operation n°1:

unknown id, Conversion from NAD83(CORS96) (geog2D) to NAD83(CORS96) 
(geocentric) + Inverse of ITRF2000 to NAD83(CORS96) (1) + Conversion from 
ITRF2000 (geocentric) to ITRF2000 (geog2D), 0 m, USA - CONUS and Alaska; PRVI

PROJ string:
+proj=pipeline +step +proj=axisswap +order=2,1 +step +proj=unitconvert 
+xy_in=deg +xy_out=rad +step +proj=cart +ellps=GRS80 +step +inv +proj=helmert 
+x=0.9956 +y=-1.9013 +z=-0.5215 +rx=0.025915 +ry=0.009426 +rz=0.011599 
+s=0.00062 +dx=0.0007 +dy=-0.0007 +dz=0.0005 +drx=6.7e-05 +dry=-0.000757 
+drz=-5.1e-05 +ds=-0.00018 +t_epoch=1997 +convention=coordinate_frame +step 
+inv +proj=cart +ellps=GRS80 +step +proj=unitconvert +xy_in=rad +xy_out=deg 
+step +proj=axisswap +order=2,1


-- 
Spatialys - Geospatial professional services
http://www.spatialys.com
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] ITRF00

2019-12-13 Per discussione Even Rouault
On vendredi 13 décembre 2019 12:00:23 CET malcolm wrote:
> Question on how QGIS chooses its transformations. I am assuming it is from
> some proj defaults?? I want to know because I do not see the current
> NAD83<>WGS84 transformation (ITRF00) which is used by HAZUS and Esri. Is
> there any way to add this upstream so it is used if not by default at least
> as an option in QGIS?

Which transformations do they use ?

I can get non-null transformations with PROJ if using NAD83(2011) as source 
CRS and ITRF2000 as target:

They go through ITRF2008 or ITRF2014 as intermediate. However as those are 
time-dependent transformations, you'd need to specify a coordinate epoch to 
get very accurate results, which is not (yet?) possible through QGIS AFAIK.


$ projinfo -s "NAD83(2011)" -t ITRF2000 --spatial-test intersects -o PROJ
Candidate operations found: 2
-
Operation n°1:

unknown id, Conversion from NAD83(2011) (geog2D) to NAD83(2011) (geocentric) + 
Inverse of ITRF2008 to NAD83(2011) (1) + Inverse of ITRF2000 to ITRF2008 (1) + 
Conversion from ITRF2000 (geocentric) to ITRF2000 (geog2D), 0.01 m, USA - 
CONUS and Alaska; PRVI

PROJ string:
+proj=pipeline +step +proj=axisswap +order=2,1 +step +proj=unitconvert 
+xy_in=deg +xy_out=rad +step +proj=cart +ellps=GRS80 +step +inv +proj=helmert 
+x=0.99343 +y=-1.90331 +z=-0.52655 +rx=0.02591467 +ry=0.00942645 
+rz=0.01159935 +s=0.00171504 +dx=0.00079 +dy=-0.0006 +dz=-0.00134 
+drx=6.667e-05 +dry=-0.00075744 +drz=-5.133e-05 +ds=-0.00010201 +t_epoch=1997 
+convention=coordinate_frame +step +inv +proj=helmert +x=0.0019 +y=0.0017 
+z=0.0105 +rx=0 +ry=0 +rz=0 +s=-0.00134 +dx=-0.0001 +dy=-0.0001 +dz=0.0018 
+drx=0 +dry=0 +drz=0 +ds=-8e-05 +t_epoch=2000 +convention=position_vector 
+step +inv +proj=cart +ellps=GRS80 +step +proj=unitconvert +xy_in=rad 
+xy_out=deg +step +proj=axisswap +order=2,1

-
Operation n°2:

unknown id, Conversion from NAD83(2011) (geog2D) to NAD83(2011) (geocentric) + 
Inverse of ITRF2014 to NAD83(2011) (1) + Inverse of ITRF2000 to ITRF2014 (1) + 
Conversion from ITRF2000 (geocentric) to ITRF2000 (geog2D), 0.01 m, USA - 
CONUS and Alaska; PRVI

PROJ string:
+proj=pipeline +step +proj=axisswap +order=2,1 +step +proj=unitconvert 
+xy_in=deg +xy_out=rad +step +proj=cart +ellps=GRS80 +step +inv +proj=helmert 
+x=1.0053 +y=-1.9092 +z=-0.5416 +rx=0.0267814 +ry=-0.0004203 +rz=0.0109321 
+s=0.00037 +dx=0.0008 +dy=-0.0006 +dz=-0.0014 +drx=6.67e-05 +dry=-0.0007574 
+drz=-5.13e-05 +ds=-7.01e-05 +t_epoch=2010 
+convention=coordinate_frame +step +inv +proj=helmert +x=-0.0007 +y=-0.0012 
+z=0.0261 +rx=0 +ry=0 +rz=0 +s=-0.00212 +dx=-0.0001 +dy=-0.0001 +dz=0.0019 
+drx=0 +dry=0 +drz=0 +ds=-0.00011 +t_epoch=2010 +convention=position_vector 
+step +inv +proj=cart +ellps=GRS80 +step +proj=unitconvert +xy_in=rad 
+xy_out=deg +step +proj=axisswap +order=2,1


Even


-- 
Spatialys - Geospatial professional services
http://www.spatialys.com
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] question about GDAL module ( QGIS 3.4.14-1 and 3.10.1-A)

2019-12-13 Per discussione andreaerdna
It seems another user has a very similar problem:

QGIS 3: Python doesn't find gdal module
https://gis.stackexchange.com/questions/344713/qgis-3-python-doesnt-find-gdal-module



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] ITRF00

2019-12-13 Per discussione malcolm
Question on how QGIS chooses its transformations. I am assuming it is from
some proj defaults?? I want to know because I do not see the current
NAD83<>WGS84 transformation (ITRF00) which is used by HAZUS and Esri. Is
there any way to add this upstream so it is used if not by default at least
as an option in QGIS?

Thanks
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Working with DEMs

2019-12-13 Per discussione qgis-user

  
  
On 12/13/2019 8:20 AM, Dave Gardiner
  wrote:

Hi
  
  
  I just can't find a suitable one in New zealand
  
  
  Dave

The SRTM covers New Zealand. This website provides a fairly
friendly interface to download 30M SRTM DEM tiles.
  

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [QGIS-it-user] Importazione modelli 3d in qgis

2019-12-13 Per discussione Luca Bellani
Molto interessante! lo provo!



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user


Re: [QGIS-it-user] Importazione modelli 3d in qgis

2019-12-13 Per discussione Daniele Samez
Non ho una risposta per il tuo caso specifico ma per importare in QGIS
2.18.23 un file TIN con formato .xyz ho fatto così : 
1)  ho utilizzato “Crea un vettore da file di testo testo delimitato” ,
specificando tutti i file *.*.
2)  ho selezionato il file .xyz, “Delimitatori personalizzati : Spazio”,
deselezionare “Il primo record ha i nomi dei campi”, campo X :”field_1”,
campo Y : “field_2”
3)  Se il file d'origine è in un'altro SR riproietti in SR 6708
4)  Per aggiungere la coordinata z ho rinominato per comodità i campi
field_1,…_2,..._3 con x, y, z, 
 e dopo ho utilizzato il comando  v.to.3D presente tra gli algoritmi di
Grass in processing
 





--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user


Re: [Qgis-user] Editing Oracle table - can't add feature

2019-12-13 Per discussione p.jeremie
Hello, 

I found that if the table contains geometry in 3D with SRID 2154, QGIS can't
add the geometry in the table.
If the geometry is 2D, it's ok.

Still, I don't understand why I don't have the PRIMARY KEY column not filled
whereas it is defined in the database...
And why QGIS tells me that the SRID is not defined whereas it is defined in
the MDSYS.USER_SDO_GEOM_METADATA view.

Any idea ?



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Working with DEMs

2019-12-13 Per discussione Nicolas Cadieux
Hi,
Try an input and output paths without spaces or accents. Is your z value a int 
or float rather than a string (text)?
Nicolas

> Le 13 déc. 2019 à 02:50, Dave Gardiner <2dave.gardi...@gmail.com> a écrit :
> 
> I see them all and every one I use fails. Take the TIN Interpolation for
> example for which my input was:
> 
> Vector Layer = Vertices (this is the layer with the extracted vector
> endpoint nodes on)
> Interpolation Attribute = Elevation
> Use Z point for Interpolation - ticked
> Input Layer = (Vector Layer = Vertices, Attribute=ZCOORD, type=POINT)
> Interpolation Method=Linear
> Extent=Canvas Extend
> 
> This is my error.
> 
> Traceback (most recent call last):
> File
> "C:/PROGRA~2/QGIS3~1.4/apps/qgis-ltr/./python/plugins\processing\algs\qgis\TinInterpolation.py",
> line 187, in processAlgorithm
> writer.writeFile(feedback)
> Exception: unknown
> 
> Execution failed after 16.94 seconds
> 
> Any thoughts please?
> 
> Dave
> 
> 
> 
> 
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] WMS Problem in QGIS 3.10

2019-12-13 Per discussione Nick Hopton
Thanks again Alessandro, it's quite a problem for me.

Best, N.



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] problemas botón "mover selección arriba del todo" - " Move the selection at the top"

2019-12-13 Per discussione Matthias Kuhn

Hi,

it is resolved in QGIS master and QGIS 3.10.1 (See this issue report for 
reference https://github.com/qgis/QGIS/issues/28914)


Best regards
Matthias

On 12/13/19 11:55 AM, Alejandro Chamizo de Castro wrote:

Muy buenas,

llevo ya tiempo teniendo problemas con el botón "mover selección 
arriba del todo" de la tabla de atributos, no realiza la función, si 
no recuerdo mal, desde las versiones 3.0. Actualmente continuo con ese 
problema con la versión 3.8 Zanzibar.


¿Es un problema general de estas versiones o es algún problema de mi 
configuración o pc?


Muchas gracias




I have been having problems with the "move selection at the top" 
button of the attribute table for some time, it does not perform the 
function, if I remember correctly, since versions 3.0. Currently I 
continue with this problem with version 3.8 Zanzibar.


Is it a general problem of these versions or is it a problem with my 
configuration or pc?

Thank you very much

--
Alejandro Chamizo de Castro
+34 653681823
www.gisland.es 



Mailtrack 
 
	Remitente notificado con
Mailtrack 
 
13/12/19 11:55:10 	



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] WMS Problem in QGIS 3.10

2019-12-13 Per discussione Alessandro Pasotti
Hi Nick,

I've just checked the ticket https://github.com/qgis/QGIS/issues/32740
the issue was fixed but it was not backported to 3.10.x (it still not
backported, I'll see if I can do it).

In any event it won't be available until the next point release.


On Fri, Dec 13, 2019 at 12:02 PM Nick Hopton  wrote:

> Thanks Alessandro, it was merged and closed. I'll reopen it and add the
> comment there.
>
> Best,
> Nick.
>
>
>
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] WMS Problem in QGIS 3.10

2019-12-13 Per discussione Nick Hopton
Thanks Alessandro, it was merged and closed. I'll reopen it and add the
comment there.

Best,
Nick. 



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Qgis-user Digest, Vol 166, Issue 14

2019-12-13 Per discussione Arnaud Vandecasteele
t; layers (XYZ Tiles for example)
> Message-ID:
>  j...@mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Hi Arnaud,
>
> It looks like a cache write issue.
>
> QGIS_OPTIONS_PATH must be a directory, not a file path.
>
> https://docs.qgis.org/testing/en/docs/user_manual/working_with_ogc/server/config.html#qgis-options-path
>
> I would add QGIS_OPTIONS_PATH too. And check that the profile is writable
> for QGIS Server (www-data?). After the GetPrint request, I think you should
> see the cache folder created.
>
> This my config :
>
> QGIS_CUSTOM_CONFIG_PATH=/home/etienne/dev/qgis/server_home/profile
> QGIS_OPTIONS_PATH=/home/etienne/dev/qgis/server_home
> QGIS_PLUGINPATH=/home/etienne/dev/qgis/server_plugin
>
> Can you check that?
>
>
>
> Le ven. 13 déc. 2019 à 07:25, Arnaud Vandecasteele 
> a
> écrit :
>
> > 
> > Distribution Ubuntu
> > QGIS Server on server -> Version: 3.4.11+dfsg-2~bionic1
> > QGIS Server on computer -> Version: 3.4.13+dfsg-3~bionic2
> > 
> >
> > I have QGIS Server installed on my computer and on my server. The same
> > project is used on both. This project is very simple and contains a SHP
> > layer and a XYZ OpenStreetMap layer. When printing the map (GetPrint) on
> my
> > computer all layers are correctly displayed.
> > The same operation on the server displays only the SHP layer and not the
> > XYZ layer.
> >
> > When the GetPrint request is made on the server, the following lines are
> > added to the log file:
> > ERROR: Opening of authentication db FAILED
> > QSqlQuery::prepare: database not open
> > WARNING: Auth db query exec() FAILED
> >
> > However, I have the impression that my configuration file is correctly
> > configured:
> >
> > FcgidInitialEnv DISPLAY":99"
> > FcgidInitialEnv QGIS_SERVER_LOG_LEVEL "0"
> > FcgidInitialEnv QGIS_SERVER_LOG_STDERR "1"
> > FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH "/home/qgis/qgisserverdb"
> > FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE
> > "/home/qgis/qgisserverdb/qgis-auth.db"
> > FcgidInitialEnv QGIS_PREFIX_PATH /usr
> > FcgidInitialEnv QGIS_OPTIONS_PATH
> >
> /data/owncloud-data/arnaud/files/GEOLAB/Transfert/webmapping-lizmap/QGIS3.ini
> > 
> > SetHandler fcgid-script
> > FcgidWrapper /usr/lib/cgi-bin/qgis_mapserv.fcgi virtual
> > Options +ExecCGI -MultiViews +FollowSymLinks
> > Require all granted
> > 
> >
> > ErrorLog ${APACHE_LOG_DIR}/map-error.log
> > LogLevel warn
> > CustomLog ${APACHE_LOG_DIR}/map-access.log combined
> >
> > And the permissions look good:
> > ls -l /home/qgis/
> > drwxr-xr-x 2 www-data www-data www-data 4096 Oct 25 08:46 cache
> > drwxr-xr-xx 2 www-data www-data www-data 4096 Jun 20 07:32 qgisserverdb
> >
> > Do you have any idea what might cause this problem?
> >
> > Thank you in advance,
> >
> > Arnaud
> > ___
> > Qgis-user mailing list
> > Qgis-user@lists.osgeo.org
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> -- next part --
> An HTML attachment was scrubbed...
> URL: <
> http://lists.osgeo.org/pipermail/qgis-user/attachments/20191213/79de864d/attachment-0001.html
> >
>
> --
>
> Message: 4
> Date: Fri, 13 Dec 2019 00:50:23 -0700 (MST)
> From: Dave Gardiner <2dave.gardi...@gmail.com>
> To: qgis-user@lists.osgeo.org
> Subject: Re: [Qgis-user] Working with DEMs
> Message-ID: <1576223423876-0.p...@n6.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> I see them all and every one I use fails. Take the TIN Interpolation for
> example for which my input was:
>
> Vector Layer = Vertices (this is the layer with the extracted vector
> endpoint nodes on)
> Interpolation Attribute = Elevation
> Use Z point for Interpolation - ticked
> Input Layer = (Vector Layer = Vertices, Attribute=ZCOORD, type=POINT)
> Interpolation Method=Linear
> Extent=Canvas Extend
>
> This is my error.
>
> Traceback (most recent call last):
> File
>
> "C:/PROGRA~2/QGIS3~1.4/apps/qgis-ltr/./python/plugins\processing\algs\qgis\TinInterpolation.py",
> line 187, in processAlgorithm
> writer.writeFile(feedback)
> Exception: unknown
>
> Executio

[Qgis-user] problemas botón "mover selección arriba del todo" - " Move the selection at the top"

2019-12-13 Per discussione Alejandro Chamizo de Castro
Muy buenas,

llevo ya tiempo teniendo problemas con el botón "mover selección arriba del
todo" de la tabla de atributos, no realiza la función, si no recuerdo mal,
desde las versiones 3.0. Actualmente continuo con ese problema con la
versión 3.8 Zanzibar.

¿Es un problema general de estas versiones o es algún problema de mi
configuración o pc?

Muchas gracias




I have been having problems with the "move selection at the top" button of
the attribute table for some time, it does not perform the function, if I
remember correctly, since versions 3.0. Currently I continue with this
problem with version 3.8 Zanzibar.

Is it a general problem of these versions or is it a problem with my
configuration or pc?
Thank you very much

-- 
Alejandro Chamizo de Castro
+34 653681823
www.gisland.es



[image: Mailtrack]

Remitente
notificado con
Mailtrack

13/12/19
11:55:10
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] WMS Problem in QGIS 3.10

2019-12-13 Per discussione Alessandro Pasotti
On Fri, Dec 13, 2019 at 11:44 AM Nick Hopton  wrote:

> Version 3.10.1 arrived here during the week. Sad to say it would appear
> that
> the WMS problem persists. Could anyone confirm this?
>
> Should I report this as a bug too?
>

No, if you already reported the original issue please add a comment to that
one.


> Best,
> Nick.
>
>
>
>
>
>
>
>
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



-- 
Alessandro Pasotti
w3:   www.itopen.it
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] WMS Problem in QGIS 3.10

2019-12-13 Per discussione Nick Hopton
Version 3.10.1 arrived here during the week. Sad to say it would appear that
the WMS problem persists. Could anyone confirm this?

Should I report this as a bug too?

Best,
Nick.








--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] WMS Problem in QGIS 3.10

2019-12-13 Per discussione Nick Hopton
Version 3.10.1 arrived here during the week. Sad to say it would appear that
the WMS problem persists. Could anyone confirm this?

Should I report this as a bug too?

Best,
Nick.








--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS Server / GetPrint not rendering all the layers (XYZ Tiles for example)

2019-12-13 Per discussione Arnaud Vandecasteele
Hi All,

I've changed the configuration fro :
FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH "/tmp/qgisserver"
FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE "/tmp/qgisserver/qgis-auth.db"

The qgisserver Folder inside tmp belongs to www-data and for tje test I set
the permission to 777 :
ls -l /tmp/
drwxrwxrwx 2 www-data www-data 4096 Dec 13 11:01 qgisserver

Event with that no qgis-auth.db has been created and still the same error
messages :

ERROR: Auth db directory path could not be created
Initializing server modules from  "/usr/lib/qgis/server"
"Checking /usr/lib/qgis/server for native services modules"
"Loading native module /usr/lib/qgis/server/libdummy.so"
"Loading native module /usr/lib/qgis/server/libwcs.so"
"Loading native module /usr/lib/qgis/server/libwfs.so"
"Loading native module /usr/lib/qgis/server/libwms.so"
"Loading native module /usr/lib/qgis/server/libwmts.so"
ERROR: Opening of authentication db FAILED
QSqlQuery::prepare: database not open
WARNING: Auth db query exec() FAILED


Arnaud



On Fri, Dec 13, 2019 at 1:06 PM Werner Macho  wrote:

> Hi,
>
> To me it looks like the server cannot create the path to store its
> credentials:
>
> ERROR: Auth db directory path could not be created
>
> Could you probably check permissions if the server is allowed to write
> there?
>
> regards
> Werner
>
> On Fri, Dec 13, 2019 at 10:03 AM Arnaud Vandecasteele <
> arnaud@gmail.com> wrote:
>
>> Hi Alessandro,
>>
>> Indeed there is no db file created.
>> I've checked the link you gave me, but I don't know what to with this. Am
>> I suppose to execute something ?
>>
>> Best,
>>
>> Arnaud
>>
>>
>> Le ven. 13 déc. 2019 à 12:50, Alessandro Pasotti  a
>> écrit :
>>
>>>
>>>
>>> On Fri, Dec 13, 2019 at 9:17 AM Arnaud Vandecasteele <
>>> arnaud@gmail.com> wrote:
>>>
 Hi Etienne,

 Thanks for your help.
 As suggested, I change the config for :

 FcgidInitialEnv DISPLAY ":99"
 FcgidInitialEnv QGIS_SERVER_LOG_LEVEL "0"
 FcgidInitialEnv QGIS_SERVER_LOG_STDERR "1"
 FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH
 "/home/arnaudvandecasteele/qgisserver"
 FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE
 "/home/arnaudvandecasteele/qgisserver/qgis-auth.db"
 FcgidInitialEnv QGIS_PREFIX_PATH /usr
 FcgidInitialEnv QGIS_OPTIONS_PATH
 "/home/arnaudvandecasteele/qgisserver/

 The folder rights looks ok.
 ls -l
 drwxrwxr-x 2 www-datawww-data  4096 Dec 13
 08:45 qgisserver

 Unfortunately the error remain :
 *
 Warning 1: Unable to find driver ECW to unload from GDAL_SKIP
 environment variable.
 Warning 1: Unable to find driver ECW to unload from GDAL_SKIP
 environment variable.
 Warning 1: Unable to find driver JP2ECW to unload from GDAL_SKIP
 environment variable.
 Warning 1: Unable to find driver ECW to unload from GDAL_SKIP
 environment variable.
 Warning 1: Unable to find driver JP2ECW to unload from GDAL_SKIP
 environment variable.
 ERROR: Auth db directory path could not be created
 Initializing server modules from  "/usr/lib/qgis/server"

 "Checking /usr/lib/qgis/server for native services modules"
 "Loading native module /usr/lib/qgis/server/libdummy.so"
 "Loading native module /usr/lib/qgis/server/libwcs.so"
 "Loading native module /usr/lib/qgis/server/libwfs.so"
 "Loading native module /usr/lib/qgis/server/libwms.so"
 "Loading native module /usr/lib/qgis/server/libwmts.so"
 ERROR: Opening of authentication db FAILED
 QSqlQuery::prepare: database not open
 WARNING: Auth db query exec() FAILED
 *

 As I understand the use of the authentification system in desktop mode,
 it is still a bit confusing for me when using a server.
 For example, I don't have any qgis-auth.db file on my server. Do I have
 to copy it from my desktop ?

>>>
>>>
>>> Hi,
>>>
>>> no, you don't need to copy it unless you want to use the credentials
>>> you've stored in it.
>>>
>>> The DB will be created automatically if it doesn't exist when QGIS
>>> Server process starts.
>>>
>>> See:
>>> https://github.com/qgis/QGIS/blob/master/src/server/qgsserver.cpp#L245
>>>
>>>
>>>
 Thanks again,

 Best,

 Arnaud


 On Fri, Dec 13, 2019 at 11:37 AM Etienne Trimaille <
 etienne.trimai...@gmail.com> wrote:

> Hi Arnaud,
>
> It looks like a cache write issue.
>
> QGIS_OPTIONS_PATH must be a directory, not a file path.
>
> https://docs.qgis.org/testing/en/docs/user_manual/working_with_ogc/server/config.html#qgis-options-path
>
> I would add QGIS_OPTIONS_PATH too. And check that the profile is
> writable for QGIS Server (www-data?). After the GetPrint request, I think
> you should see the cache folder created.
>
> This my config :
>
> 

Re: [Qgis-user] QGIS Server / GetPrint not rendering all the layers (XYZ Tiles for example)

2019-12-13 Per discussione Werner Macho
Hi,

To me it looks like the server cannot create the path to store its
credentials:

ERROR: Auth db directory path could not be created

Could you probably check permissions if the server is allowed to write
there?

regards
Werner

On Fri, Dec 13, 2019 at 10:03 AM Arnaud Vandecasteele 
wrote:

> Hi Alessandro,
>
> Indeed there is no db file created.
> I've checked the link you gave me, but I don't know what to with this. Am
> I suppose to execute something ?
>
> Best,
>
> Arnaud
>
>
> Le ven. 13 déc. 2019 à 12:50, Alessandro Pasotti  a
> écrit :
>
>>
>>
>> On Fri, Dec 13, 2019 at 9:17 AM Arnaud Vandecasteele <
>> arnaud@gmail.com> wrote:
>>
>>> Hi Etienne,
>>>
>>> Thanks for your help.
>>> As suggested, I change the config for :
>>>
>>> FcgidInitialEnv DISPLAY ":99"
>>> FcgidInitialEnv QGIS_SERVER_LOG_LEVEL "0"
>>> FcgidInitialEnv QGIS_SERVER_LOG_STDERR "1"
>>> FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH
>>> "/home/arnaudvandecasteele/qgisserver"
>>> FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE
>>> "/home/arnaudvandecasteele/qgisserver/qgis-auth.db"
>>> FcgidInitialEnv QGIS_PREFIX_PATH /usr
>>> FcgidInitialEnv QGIS_OPTIONS_PATH
>>> "/home/arnaudvandecasteele/qgisserver/
>>>
>>> The folder rights looks ok.
>>> ls -l
>>> drwxrwxr-x 2 www-datawww-data  4096 Dec 13
>>> 08:45 qgisserver
>>>
>>> Unfortunately the error remain :
>>> *
>>> Warning 1: Unable to find driver ECW to unload from GDAL_SKIP
>>> environment variable.
>>> Warning 1: Unable to find driver ECW to unload from GDAL_SKIP
>>> environment variable.
>>> Warning 1: Unable to find driver JP2ECW to unload from GDAL_SKIP
>>> environment variable.
>>> Warning 1: Unable to find driver ECW to unload from GDAL_SKIP
>>> environment variable.
>>> Warning 1: Unable to find driver JP2ECW to unload from GDAL_SKIP
>>> environment variable.
>>> ERROR: Auth db directory path could not be created
>>> Initializing server modules from  "/usr/lib/qgis/server"
>>>
>>> "Checking /usr/lib/qgis/server for native services modules"
>>> "Loading native module /usr/lib/qgis/server/libdummy.so"
>>> "Loading native module /usr/lib/qgis/server/libwcs.so"
>>> "Loading native module /usr/lib/qgis/server/libwfs.so"
>>> "Loading native module /usr/lib/qgis/server/libwms.so"
>>> "Loading native module /usr/lib/qgis/server/libwmts.so"
>>> ERROR: Opening of authentication db FAILED
>>> QSqlQuery::prepare: database not open
>>> WARNING: Auth db query exec() FAILED
>>> *
>>>
>>> As I understand the use of the authentification system in desktop mode,
>>> it is still a bit confusing for me when using a server.
>>> For example, I don't have any qgis-auth.db file on my server. Do I have
>>> to copy it from my desktop ?
>>>
>>
>>
>> Hi,
>>
>> no, you don't need to copy it unless you want to use the credentials
>> you've stored in it.
>>
>> The DB will be created automatically if it doesn't exist when QGIS Server
>> process starts.
>>
>> See:
>> https://github.com/qgis/QGIS/blob/master/src/server/qgsserver.cpp#L245
>>
>>
>>
>>> Thanks again,
>>>
>>> Best,
>>>
>>> Arnaud
>>>
>>>
>>> On Fri, Dec 13, 2019 at 11:37 AM Etienne Trimaille <
>>> etienne.trimai...@gmail.com> wrote:
>>>
 Hi Arnaud,

 It looks like a cache write issue.

 QGIS_OPTIONS_PATH must be a directory, not a file path.

 https://docs.qgis.org/testing/en/docs/user_manual/working_with_ogc/server/config.html#qgis-options-path

 I would add QGIS_OPTIONS_PATH too. And check that the profile is
 writable for QGIS Server (www-data?). After the GetPrint request, I think
 you should see the cache folder created.

 This my config :

 QGIS_CUSTOM_CONFIG_PATH=/home/etienne/dev/qgis/server_home/profile
 QGIS_OPTIONS_PATH=/home/etienne/dev/qgis/server_home
 QGIS_PLUGINPATH=/home/etienne/dev/qgis/server_plugin

 Can you check that?



 Le ven. 13 déc. 2019 à 07:25, Arnaud Vandecasteele <
 arnaud@gmail.com> a écrit :

> 
> Distribution Ubuntu
> QGIS Server on server -> Version: 3.4.11+dfsg-2~bionic1
> QGIS Server on computer -> Version: 3.4.13+dfsg-3~bionic2
> 
>
> I have QGIS Server installed on my computer and on my server. The same
> project is used on both. This project is very simple and contains a SHP
> layer and a XYZ OpenStreetMap layer. When printing the map (GetPrint) on 
> my
> computer all layers are correctly displayed.
> The same operation on the server displays only the SHP layer and not
> the XYZ layer.
>
> When the GetPrint request is made on the server, the following lines
> are added to the log file:
> ERROR: Opening of authentication db FAILED
> QSqlQuery::prepare: database not open
> WARNING: Auth db query exec() FAILED
>
> However, I have the impression that my configuration file is correctly
> configured:
>
> 

Re: [Qgis-user] QGIS Server / GetPrint not rendering all the layers (XYZ Tiles for example)

2019-12-13 Per discussione Arnaud Vandecasteele
Hi Alessandro,

Indeed there is no db file created.
I've checked the link you gave me, but I don't know what to with this. Am I
suppose to execute something ?

Best,

Arnaud


Le ven. 13 déc. 2019 à 12:50, Alessandro Pasotti  a
écrit :

>
>
> On Fri, Dec 13, 2019 at 9:17 AM Arnaud Vandecasteele 
> wrote:
>
>> Hi Etienne,
>>
>> Thanks for your help.
>> As suggested, I change the config for :
>>
>> FcgidInitialEnv DISPLAY ":99"
>> FcgidInitialEnv QGIS_SERVER_LOG_LEVEL "0"
>> FcgidInitialEnv QGIS_SERVER_LOG_STDERR "1"
>> FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH
>> "/home/arnaudvandecasteele/qgisserver"
>> FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE
>> "/home/arnaudvandecasteele/qgisserver/qgis-auth.db"
>> FcgidInitialEnv QGIS_PREFIX_PATH /usr
>> FcgidInitialEnv QGIS_OPTIONS_PATH
>> "/home/arnaudvandecasteele/qgisserver/
>>
>> The folder rights looks ok.
>> ls -l
>> drwxrwxr-x 2 www-datawww-data  4096 Dec 13
>> 08:45 qgisserver
>>
>> Unfortunately the error remain :
>> *
>> Warning 1: Unable to find driver ECW to unload from GDAL_SKIP environment
>> variable.
>> Warning 1: Unable to find driver ECW to unload from GDAL_SKIP environment
>> variable.
>> Warning 1: Unable to find driver JP2ECW to unload from GDAL_SKIP
>> environment variable.
>> Warning 1: Unable to find driver ECW to unload from GDAL_SKIP environment
>> variable.
>> Warning 1: Unable to find driver JP2ECW to unload from GDAL_SKIP
>> environment variable.
>> ERROR: Auth db directory path could not be created
>> Initializing server modules from  "/usr/lib/qgis/server"
>>
>> "Checking /usr/lib/qgis/server for native services modules"
>> "Loading native module /usr/lib/qgis/server/libdummy.so"
>> "Loading native module /usr/lib/qgis/server/libwcs.so"
>> "Loading native module /usr/lib/qgis/server/libwfs.so"
>> "Loading native module /usr/lib/qgis/server/libwms.so"
>> "Loading native module /usr/lib/qgis/server/libwmts.so"
>> ERROR: Opening of authentication db FAILED
>> QSqlQuery::prepare: database not open
>> WARNING: Auth db query exec() FAILED
>> *
>>
>> As I understand the use of the authentification system in desktop mode,
>> it is still a bit confusing for me when using a server.
>> For example, I don't have any qgis-auth.db file on my server. Do I have
>> to copy it from my desktop ?
>>
>
>
> Hi,
>
> no, you don't need to copy it unless you want to use the credentials
> you've stored in it.
>
> The DB will be created automatically if it doesn't exist when QGIS Server
> process starts.
>
> See:
> https://github.com/qgis/QGIS/blob/master/src/server/qgsserver.cpp#L245
>
>
>
>> Thanks again,
>>
>> Best,
>>
>> Arnaud
>>
>>
>> On Fri, Dec 13, 2019 at 11:37 AM Etienne Trimaille <
>> etienne.trimai...@gmail.com> wrote:
>>
>>> Hi Arnaud,
>>>
>>> It looks like a cache write issue.
>>>
>>> QGIS_OPTIONS_PATH must be a directory, not a file path.
>>>
>>> https://docs.qgis.org/testing/en/docs/user_manual/working_with_ogc/server/config.html#qgis-options-path
>>>
>>> I would add QGIS_OPTIONS_PATH too. And check that the profile is
>>> writable for QGIS Server (www-data?). After the GetPrint request, I think
>>> you should see the cache folder created.
>>>
>>> This my config :
>>>
>>> QGIS_CUSTOM_CONFIG_PATH=/home/etienne/dev/qgis/server_home/profile
>>> QGIS_OPTIONS_PATH=/home/etienne/dev/qgis/server_home
>>> QGIS_PLUGINPATH=/home/etienne/dev/qgis/server_plugin
>>>
>>> Can you check that?
>>>
>>>
>>>
>>> Le ven. 13 déc. 2019 à 07:25, Arnaud Vandecasteele 
>>> a écrit :
>>>
 
 Distribution Ubuntu
 QGIS Server on server -> Version: 3.4.11+dfsg-2~bionic1
 QGIS Server on computer -> Version: 3.4.13+dfsg-3~bionic2
 

 I have QGIS Server installed on my computer and on my server. The same
 project is used on both. This project is very simple and contains a SHP
 layer and a XYZ OpenStreetMap layer. When printing the map (GetPrint) on my
 computer all layers are correctly displayed.
 The same operation on the server displays only the SHP layer and not
 the XYZ layer.

 When the GetPrint request is made on the server, the following lines
 are added to the log file:
 ERROR: Opening of authentication db FAILED
 QSqlQuery::prepare: database not open
 WARNING: Auth db query exec() FAILED

 However, I have the impression that my configuration file is correctly
 configured:

 FcgidInitialEnv DISPLAY":99"
 FcgidInitialEnv QGIS_SERVER_LOG_LEVEL "0"
 FcgidInitialEnv QGIS_SERVER_LOG_STDERR "1"
 FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH "/home/qgis/qgisserverdb"
 FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE
 "/home/qgis/qgisserverdb/qgis-auth.db"
 FcgidInitialEnv QGIS_PREFIX_PATH /usr
 FcgidInitialEnv QGIS_OPTIONS_PATH
 /data/owncloud-data/arnaud/files/GEOLAB/Transfert/webmapping-lizmap/QGIS3.ini
   

Re: [Qgis-user] QGIS Server / GetPrint not rendering all the layers (XYZ Tiles for example)

2019-12-13 Per discussione Alessandro Pasotti
On Fri, Dec 13, 2019 at 9:17 AM Arnaud Vandecasteele 
wrote:

> Hi Etienne,
>
> Thanks for your help.
> As suggested, I change the config for :
>
> FcgidInitialEnv DISPLAY ":99"
> FcgidInitialEnv QGIS_SERVER_LOG_LEVEL "0"
> FcgidInitialEnv QGIS_SERVER_LOG_STDERR "1"
> FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH
> "/home/arnaudvandecasteele/qgisserver"
> FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE
> "/home/arnaudvandecasteele/qgisserver/qgis-auth.db"
> FcgidInitialEnv QGIS_PREFIX_PATH /usr
> FcgidInitialEnv QGIS_OPTIONS_PATH
> "/home/arnaudvandecasteele/qgisserver/
>
> The folder rights looks ok.
> ls -l
> drwxrwxr-x 2 www-datawww-data  4096 Dec 13
> 08:45 qgisserver
>
> Unfortunately the error remain :
> *
> Warning 1: Unable to find driver ECW to unload from GDAL_SKIP environment
> variable.
> Warning 1: Unable to find driver ECW to unload from GDAL_SKIP environment
> variable.
> Warning 1: Unable to find driver JP2ECW to unload from GDAL_SKIP
> environment variable.
> Warning 1: Unable to find driver ECW to unload from GDAL_SKIP environment
> variable.
> Warning 1: Unable to find driver JP2ECW to unload from GDAL_SKIP
> environment variable.
> ERROR: Auth db directory path could not be created
> Initializing server modules from  "/usr/lib/qgis/server"
>
> "Checking /usr/lib/qgis/server for native services modules"
> "Loading native module /usr/lib/qgis/server/libdummy.so"
> "Loading native module /usr/lib/qgis/server/libwcs.so"
> "Loading native module /usr/lib/qgis/server/libwfs.so"
> "Loading native module /usr/lib/qgis/server/libwms.so"
> "Loading native module /usr/lib/qgis/server/libwmts.so"
> ERROR: Opening of authentication db FAILED
> QSqlQuery::prepare: database not open
> WARNING: Auth db query exec() FAILED
> *
>
> As I understand the use of the authentification system in desktop mode, it
> is still a bit confusing for me when using a server.
> For example, I don't have any qgis-auth.db file on my server. Do I have to
> copy it from my desktop ?
>


Hi,

no, you don't need to copy it unless you want to use the credentials you've
stored in it.

The DB will be created automatically if it doesn't exist when QGIS Server
process starts.

See: https://github.com/qgis/QGIS/blob/master/src/server/qgsserver.cpp#L245



> Thanks again,
>
> Best,
>
> Arnaud
>
>
> On Fri, Dec 13, 2019 at 11:37 AM Etienne Trimaille <
> etienne.trimai...@gmail.com> wrote:
>
>> Hi Arnaud,
>>
>> It looks like a cache write issue.
>>
>> QGIS_OPTIONS_PATH must be a directory, not a file path.
>>
>> https://docs.qgis.org/testing/en/docs/user_manual/working_with_ogc/server/config.html#qgis-options-path
>>
>> I would add QGIS_OPTIONS_PATH too. And check that the profile is writable
>> for QGIS Server (www-data?). After the GetPrint request, I think you should
>> see the cache folder created.
>>
>> This my config :
>>
>> QGIS_CUSTOM_CONFIG_PATH=/home/etienne/dev/qgis/server_home/profile
>> QGIS_OPTIONS_PATH=/home/etienne/dev/qgis/server_home
>> QGIS_PLUGINPATH=/home/etienne/dev/qgis/server_plugin
>>
>> Can you check that?
>>
>>
>>
>> Le ven. 13 déc. 2019 à 07:25, Arnaud Vandecasteele 
>> a écrit :
>>
>>> 
>>> Distribution Ubuntu
>>> QGIS Server on server -> Version: 3.4.11+dfsg-2~bionic1
>>> QGIS Server on computer -> Version: 3.4.13+dfsg-3~bionic2
>>> 
>>>
>>> I have QGIS Server installed on my computer and on my server. The same
>>> project is used on both. This project is very simple and contains a SHP
>>> layer and a XYZ OpenStreetMap layer. When printing the map (GetPrint) on my
>>> computer all layers are correctly displayed.
>>> The same operation on the server displays only the SHP layer and not the
>>> XYZ layer.
>>>
>>> When the GetPrint request is made on the server, the following lines are
>>> added to the log file:
>>> ERROR: Opening of authentication db FAILED
>>> QSqlQuery::prepare: database not open
>>> WARNING: Auth db query exec() FAILED
>>>
>>> However, I have the impression that my configuration file is correctly
>>> configured:
>>>
>>> FcgidInitialEnv DISPLAY":99"
>>> FcgidInitialEnv QGIS_SERVER_LOG_LEVEL "0"
>>> FcgidInitialEnv QGIS_SERVER_LOG_STDERR "1"
>>> FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH "/home/qgis/qgisserverdb"
>>> FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE
>>> "/home/qgis/qgisserverdb/qgis-auth.db"
>>> FcgidInitialEnv QGIS_PREFIX_PATH /usr
>>> FcgidInitialEnv QGIS_OPTIONS_PATH
>>> /data/owncloud-data/arnaud/files/GEOLAB/Transfert/webmapping-lizmap/QGIS3.ini
>>> 
>>> SetHandler fcgid-script
>>> FcgidWrapper /usr/lib/cgi-bin/qgis_mapserv.fcgi virtual
>>> Options +ExecCGI -MultiViews +FollowSymLinks
>>> Require all granted
>>> 
>>>
>>> ErrorLog ${APACHE_LOG_DIR}/map-error.log
>>> LogLevel warn
>>> CustomLog ${APACHE_LOG_DIR}/map-access.log 

Re: [Qgis-user] QGIS Server / GetPrint not rendering all the layers (XYZ Tiles for example)

2019-12-13 Per discussione Arnaud Vandecasteele
Hi Etienne,

Thanks for your help.
As suggested, I change the config for :

FcgidInitialEnv DISPLAY ":99"
FcgidInitialEnv QGIS_SERVER_LOG_LEVEL "0"
FcgidInitialEnv QGIS_SERVER_LOG_STDERR "1"
FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH
"/home/arnaudvandecasteele/qgisserver"
FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE
"/home/arnaudvandecasteele/qgisserver/qgis-auth.db"
FcgidInitialEnv QGIS_PREFIX_PATH /usr
FcgidInitialEnv QGIS_OPTIONS_PATH
"/home/arnaudvandecasteele/qgisserver/

The folder rights looks ok.
ls -l
drwxrwxr-x 2 www-datawww-data  4096 Dec 13
08:45 qgisserver

Unfortunately the error remain :
*
Warning 1: Unable to find driver ECW to unload from GDAL_SKIP environment
variable.
Warning 1: Unable to find driver ECW to unload from GDAL_SKIP environment
variable.
Warning 1: Unable to find driver JP2ECW to unload from GDAL_SKIP
environment variable.
Warning 1: Unable to find driver ECW to unload from GDAL_SKIP environment
variable.
Warning 1: Unable to find driver JP2ECW to unload from GDAL_SKIP
environment variable.
ERROR: Auth db directory path could not be created
Initializing server modules from  "/usr/lib/qgis/server"

"Checking /usr/lib/qgis/server for native services modules"
"Loading native module /usr/lib/qgis/server/libdummy.so"
"Loading native module /usr/lib/qgis/server/libwcs.so"
"Loading native module /usr/lib/qgis/server/libwfs.so"
"Loading native module /usr/lib/qgis/server/libwms.so"
"Loading native module /usr/lib/qgis/server/libwmts.so"
ERROR: Opening of authentication db FAILED
QSqlQuery::prepare: database not open
WARNING: Auth db query exec() FAILED
*

As I understand the use of the authentification system in desktop mode, it
is still a bit confusing for me when using a server.
For example, I don't have any qgis-auth.db file on my server. Do I have to
copy it from my desktop ?

Thanks again,

Best,

Arnaud


On Fri, Dec 13, 2019 at 11:37 AM Etienne Trimaille <
etienne.trimai...@gmail.com> wrote:

> Hi Arnaud,
>
> It looks like a cache write issue.
>
> QGIS_OPTIONS_PATH must be a directory, not a file path.
>
> https://docs.qgis.org/testing/en/docs/user_manual/working_with_ogc/server/config.html#qgis-options-path
>
> I would add QGIS_OPTIONS_PATH too. And check that the profile is writable
> for QGIS Server (www-data?). After the GetPrint request, I think you should
> see the cache folder created.
>
> This my config :
>
> QGIS_CUSTOM_CONFIG_PATH=/home/etienne/dev/qgis/server_home/profile
> QGIS_OPTIONS_PATH=/home/etienne/dev/qgis/server_home
> QGIS_PLUGINPATH=/home/etienne/dev/qgis/server_plugin
>
> Can you check that?
>
>
>
> Le ven. 13 déc. 2019 à 07:25, Arnaud Vandecasteele 
> a écrit :
>
>> 
>> Distribution Ubuntu
>> QGIS Server on server -> Version: 3.4.11+dfsg-2~bionic1
>> QGIS Server on computer -> Version: 3.4.13+dfsg-3~bionic2
>> 
>>
>> I have QGIS Server installed on my computer and on my server. The same
>> project is used on both. This project is very simple and contains a SHP
>> layer and a XYZ OpenStreetMap layer. When printing the map (GetPrint) on my
>> computer all layers are correctly displayed.
>> The same operation on the server displays only the SHP layer and not the
>> XYZ layer.
>>
>> When the GetPrint request is made on the server, the following lines are
>> added to the log file:
>> ERROR: Opening of authentication db FAILED
>> QSqlQuery::prepare: database not open
>> WARNING: Auth db query exec() FAILED
>>
>> However, I have the impression that my configuration file is correctly
>> configured:
>>
>> FcgidInitialEnv DISPLAY":99"
>> FcgidInitialEnv QGIS_SERVER_LOG_LEVEL "0"
>> FcgidInitialEnv QGIS_SERVER_LOG_STDERR "1"
>> FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH "/home/qgis/qgisserverdb"
>> FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE
>> "/home/qgis/qgisserverdb/qgis-auth.db"
>> FcgidInitialEnv QGIS_PREFIX_PATH /usr
>> FcgidInitialEnv QGIS_OPTIONS_PATH
>> /data/owncloud-data/arnaud/files/GEOLAB/Transfert/webmapping-lizmap/QGIS3.ini
>> 
>> SetHandler fcgid-script
>> FcgidWrapper /usr/lib/cgi-bin/qgis_mapserv.fcgi virtual
>> Options +ExecCGI -MultiViews +FollowSymLinks
>> Require all granted
>> 
>>
>> ErrorLog ${APACHE_LOG_DIR}/map-error.log
>> LogLevel warn
>> CustomLog ${APACHE_LOG_DIR}/map-access.log combined
>>
>> And the permissions look good:
>> ls -l /home/qgis/
>> drwxr-xr-x 2 www-data www-data www-data 4096 Oct 25 08:46 cache
>> drwxr-xr-xx 2 www-data www-data www-data 4096 Jun 20 07:32 qgisserverdb
>>
>> Do you have any idea what might cause this problem?
>>
>> Thank you in advance,
>>
>> Arnaud
>> ___
>> Qgis-user mailing list
>> Qgis-user@lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: 

Re: [Qgis-user] Working with DEMs

2019-12-13 Per discussione Bernd Vogelgesang

mhm, not a single one works?  can you send me a sample of your points?

Am 13.12.19 um 08:50 schrieb Dave Gardiner:

I see them all and every one I use fails. Take the TIN Interpolation for
example for which my input was:

Vector Layer = Vertices (this is the layer with the extracted vector
endpoint nodes on)
Interpolation Attribute = Elevation
Use Z point for Interpolation - ticked
Input Layer = (Vector Layer = Vertices, Attribute=ZCOORD, type=POINT)
Interpolation Method=Linear
Extent=Canvas Extend

This is my error.

Traceback (most recent call last):
File
"C:/PROGRA~2/QGIS3~1.4/apps/qgis-ltr/./python/plugins\processing\algs\qgis\TinInterpolation.py",
line 187, in processAlgorithm
writer.writeFile(feedback)
Exception: unknown

Execution failed after 16.94 seconds

Any thoughts please?

Dave




--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user