<div dir="ltr"><div>Hi,</div><div><br></div><div>I've finally found the problem.</div><div><br></div><div>My qgis server works configuration is defined inside a virtual host :</div><div><VirtualHost *:80><br> ServerAdmin ***<br> ServerName ***<br> ServerAlias ***<br> DocumentRoot***<br><br> FcgidInitialEnv DISPLAY ":99"<br> FcgidInitialEnv QGIS_SERVER_LOG_LEVEL "0"<br> FcgidInitialEnv QGIS_SERVER_LOG_STDERR "1"<br> FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH "/home/qgis/qgisserverdb/"<br> FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE "/home/qgis/qgisserverdb/qgis-auth.db"<br> FcgidInitialEnv QGIS_PREFIX_PATH /usradd <br> FcgidInitialEnv QGIS_OPTIONS_PATH "/home/qgis/qgisserver/"<br> <Location /qgisserver><br> SetHandler fcgid-script<br> FcgidWrapper /usr/lib/cgi-bin/qgis_mapserv.fcgi virtual<br> Options +ExecCGI -MultiViews +FollowSymLinks<br> Require all granted<br> </Location><br><br> ErrorLog ${APACHE_LOG_DIR}/map-error.log<br> LogLevel warn<br> CustomLog ${APACHE_LOG_DIR}/map-access.log combined<br></VirtualHost></div><div><br></div><div>Now if I add the parameters QGIS_AUTH_DB_DIR_PATH and QGIS_AUTH_PASSWORD_FILE in 000-default.conf (instead of the specific map virtual host) the XYZ tiles are loaded and the qgis-auth.db files is created.<br><br></div><div>I would prefer to keep all the parameters inside the same virtual host config file but at least I've a working solution.</div><div><br></div><div>Thanks all of you for help !</div><div><br></div><div></div><div>Best,</div><div><br></div><div>Arnaud<br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Dec 13, 2019 at 12:51 PM <<a href="mailto:qgis-user-request@lists.osgeo.org">qgis-user-request@lists.osgeo.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Send Qgis-user mailing list submissions to<br>
<a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:qgis-user-request@lists.osgeo.org" target="_blank">qgis-user-request@lists.osgeo.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:qgis-user-owner@lists.osgeo.org" target="_blank">qgis-user-owner@lists.osgeo.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Qgis-user digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: Working with DEMs (Dave Gardiner)<br>
2. Re: Working with DEMs (Bernd Vogelgesang)<br>
3. Re: QGIS Server / GetPrint not rendering all the layers (XYZ<br>
Tiles for example) (Etienne Trimaille)<br>
4. Re: Working with DEMs (Dave Gardiner)<br>
5. Re: Working with DEMs (Bernd Vogelgesang)<br>
6. Re: QGIS Server / GetPrint not rendering all the layers (XYZ<br>
Tiles for example) (Arnaud Vandecasteele)<br>
7. Re: QGIS Server / GetPrint not rendering all the layers (XYZ<br>
Tiles for example) (Alessandro Pasotti)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Thu, 12 Dec 2019 23:55:15 -0700 (MST)<br>
From: Dave Gardiner <<a href="mailto:2dave.gardiner@gmail.com" target="_blank">2dave.gardiner@gmail.com</a>><br>
To: <a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a><br>
Subject: Re: [Qgis-user] Working with DEMs<br>
Message-ID: <<a href="mailto:1576220115629-0.post@n6.nabble.com" target="_blank">1576220115629-0.post@n6.nabble.com</a>><br>
Content-Type: text/plain; charset=us-ascii<br>
<br>
Hi Harvard<br>
<br>
I have extracted the nodes from the contour lines with the elevation field<br>
extracted. Could you please explain further how I generate a raster using a<br>
tin or spline interpolation. Where are these commands (Version 3.4.13).<br>
<br>
Kind Regards<br>
Dave<br>
<br>
<br>
<br>
--<br>
Sent from: <a href="http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html" rel="noreferrer" target="_blank">http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html</a><br>
<br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Fri, 13 Dec 2019 08:05:58 +0100<br>
From: Bernd Vogelgesang <<a href="mailto:bernd.vogelgesang@gmx.de" target="_blank">bernd.vogelgesang@gmx.de</a>><br>
To: <a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a><br>
Subject: Re: [Qgis-user] Working with DEMs<br>
Message-ID: <<a href="mailto:94cc9324-c6a0-d5d5-9b42-74ae35192048@gmx.de" target="_blank">94cc9324-c6a0-d5d5-9b42-74ae35192048@gmx.de</a>><br>
Content-Type: text/plain; charset=utf-8; format=flowed<br>
<br>
just type "interpolation" into the search field of the tool box, and all<br>
the functions will jump right into your face.<br>
<br>
Am 13.12.19 um 07:55 schrieb Dave Gardiner:<br>
> Hi Harvard<br>
><br>
> I have extracted the nodes from the contour lines with the elevation field<br>
> extracted. Could you please explain further how I generate a raster using a<br>
> tin or spline interpolation. Where are these commands (Version 3.4.13).<br>
><br>
> Kind Regards<br>
> Dave<br>
><br>
><br>
><br>
> --<br>
> Sent from: <a href="http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html" rel="noreferrer" target="_blank">http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html</a><br>
> _______________________________________________<br>
> Qgis-user mailing list<br>
> <a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
> List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
> Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
<br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Fri, 13 Dec 2019 08:36:59 +0100<br>
From: Etienne Trimaille <<a href="mailto:etienne.trimaille@gmail.com" target="_blank">etienne.trimaille@gmail.com</a>><br>
To: Arnaud Vandecasteele <<a href="mailto:arnaud.sig@gmail.com" target="_blank">arnaud.sig@gmail.com</a>><br>
Cc: qgis-user <<a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a>><br>
Subject: Re: [Qgis-user] QGIS Server / GetPrint not rendering all the<br>
layers (XYZ Tiles for example)<br>
Message-ID:<br>
<CAMtDFLL=n7x_O=gQbxHYrVopfE2WQdYgOiOy9tOt+qHYg4=<a href="mailto:J-g@mail.gmail.com" target="_blank">J-g@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi Arnaud,<br>
<br>
It looks like a cache write issue.<br>
<br>
QGIS_OPTIONS_PATH must be a directory, not a file path.<br>
<a href="https://docs.qgis.org/testing/en/docs/user_manual/working_with_ogc/server/config.html#qgis-options-path" rel="noreferrer" target="_blank">https://docs.qgis.org/testing/en/docs/user_manual/working_with_ogc/server/config.html#qgis-options-path</a><br>
<br>
I would add QGIS_OPTIONS_PATH too. And check that the profile is writable<br>
for QGIS Server (www-data?). After the GetPrint request, I think you should<br>
see the cache folder created.<br>
<br>
This my config :<br>
<br>
QGIS_CUSTOM_CONFIG_PATH=/home/etienne/dev/qgis/server_home/profile<br>
QGIS_OPTIONS_PATH=/home/etienne/dev/qgis/server_home<br>
QGIS_PLUGINPATH=/home/etienne/dev/qgis/server_plugin<br>
<br>
Can you check that?<br>
<br>
<br>
<br>
Le ven. 13 déc. 2019 à 07:25, Arnaud Vandecasteele <<a href="mailto:arnaud.sig@gmail.com" target="_blank">arnaud.sig@gmail.com</a>> a<br>
écrit :<br>
<br>
> ****<br>
> Distribution Ubuntu<br>
> QGIS Server on server -> Version: 3.4.11+dfsg-2~bionic1<br>
> QGIS Server on computer -> Version: 3.4.13+dfsg-3~bionic2<br>
> ****<br>
><br>
> I have QGIS Server installed on my computer and on my server. The same<br>
> project is used on both. This project is very simple and contains a SHP<br>
> layer and a XYZ OpenStreetMap layer. When printing the map (GetPrint) on my<br>
> computer all layers are correctly displayed.<br>
> The same operation on the server displays only the SHP layer and not the<br>
> XYZ layer.<br>
><br>
> When the GetPrint request is made on the server, the following lines are<br>
> added to the log file:<br>
> ERROR: Opening of authentication db FAILED<br>
> QSqlQuery::prepare: database not open<br>
> WARNING: Auth db query exec() FAILED<br>
><br>
> However, I have the impression that my configuration file is correctly<br>
> configured:<br>
><br>
> FcgidInitialEnv DISPLAY":99"<br>
> FcgidInitialEnv QGIS_SERVER_LOG_LEVEL "0"<br>
> FcgidInitialEnv QGIS_SERVER_LOG_STDERR "1"<br>
> FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH "/home/qgis/qgisserverdb"<br>
> FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE<br>
> "/home/qgis/qgisserverdb/qgis-auth.db"<br>
> FcgidInitialEnv QGIS_PREFIX_PATH /usr<br>
> FcgidInitialEnv QGIS_OPTIONS_PATH<br>
> /data/owncloud-data/arnaud/files/GEOLAB/Transfert/webmapping-lizmap/QGIS3.ini<br>
> <Rental /qgisserver><br>
> SetHandler fcgid-script<br>
> FcgidWrapper /usr/lib/cgi-bin/qgis_mapserv.fcgi virtual<br>
> Options +ExecCGI -MultiViews +FollowSymLinks<br>
> Require all granted<br>
> </Location><br>
><br>
> ErrorLog ${APACHE_LOG_DIR}/map-error.log<br>
> LogLevel warn<br>
> CustomLog ${APACHE_LOG_DIR}/map-access.log combined<br>
><br>
> And the permissions look good:<br>
> ls -l /home/qgis/<br>
> drwxr-xr-x 2 www-data www-data www-data 4096 Oct 25 08:46 cache<br>
> drwxr-xr-xx 2 www-data www-data www-data 4096 Jun 20 07:32 qgisserverdb<br>
><br>
> Do you have any idea what might cause this problem?<br>
><br>
> Thank you in advance,<br>
><br>
> Arnaud<br>
> _______________________________________________<br>
> Qgis-user mailing list<br>
> <a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
> List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
> Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20191213/79de864d/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20191213/79de864d/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 4<br>
Date: Fri, 13 Dec 2019 00:50:23 -0700 (MST)<br>
From: Dave Gardiner <<a href="mailto:2dave.gardiner@gmail.com" target="_blank">2dave.gardiner@gmail.com</a>><br>
To: <a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a><br>
Subject: Re: [Qgis-user] Working with DEMs<br>
Message-ID: <<a href="mailto:1576223423876-0.post@n6.nabble.com" target="_blank">1576223423876-0.post@n6.nabble.com</a>><br>
Content-Type: text/plain; charset=us-ascii<br>
<br>
I see them all and every one I use fails. Take the TIN Interpolation for<br>
example for which my input was:<br>
<br>
Vector Layer = Vertices (this is the layer with the extracted vector<br>
endpoint nodes on)<br>
Interpolation Attribute = Elevation<br>
Use Z point for Interpolation - ticked<br>
Input Layer = (Vector Layer = Vertices, Attribute=ZCOORD, type=POINT)<br>
Interpolation Method=Linear<br>
Extent=Canvas Extend<br>
<br>
This is my error.<br>
<br>
Traceback (most recent call last):<br>
File<br>
"C:/PROGRA~2/QGIS3~1.4/apps/qgis-ltr/./python/plugins\processing\algs\qgis\TinInterpolation.py",<br>
line 187, in processAlgorithm<br>
writer.writeFile(feedback)<br>
Exception: unknown<br>
<br>
Execution failed after 16.94 seconds<br>
<br>
Any thoughts please?<br>
<br>
Dave<br>
<br>
<br>
<br>
<br>
--<br>
Sent from: <a href="http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html" rel="noreferrer" target="_blank">http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html</a><br>
<br>
<br>
------------------------------<br>
<br>
Message: 5<br>
Date: Fri, 13 Dec 2019 09:16:10 +0100<br>
From: Bernd Vogelgesang <<a href="mailto:bernd.vogelgesang@gmx.de" target="_blank">bernd.vogelgesang@gmx.de</a>><br>
To: <a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a><br>
Subject: Re: [Qgis-user] Working with DEMs<br>
Message-ID: <<a href="mailto:17da1ed3-a3dd-1715-8046-23f137500569@gmx.de" target="_blank">17da1ed3-a3dd-1715-8046-23f137500569@gmx.de</a>><br>
Content-Type: text/plain; charset=utf-8; format=flowed<br>
<br>
mhm, not a single one works? can you send me a sample of your points?<br>
<br>
Am 13.12.19 um 08:50 schrieb Dave Gardiner:<br>
> I see them all and every one I use fails. Take the TIN Interpolation for<br>
> example for which my input was:<br>
><br>
> Vector Layer = Vertices (this is the layer with the extracted vector<br>
> endpoint nodes on)<br>
> Interpolation Attribute = Elevation<br>
> Use Z point for Interpolation - ticked<br>
> Input Layer = (Vector Layer = Vertices, Attribute=ZCOORD, type=POINT)<br>
> Interpolation Method=Linear<br>
> Extent=Canvas Extend<br>
><br>
> This is my error.<br>
><br>
> Traceback (most recent call last):<br>
> File<br>
> "C:/PROGRA~2/QGIS3~1.4/apps/qgis-ltr/./python/plugins\processing\algs\qgis\TinInterpolation.py",<br>
> line 187, in processAlgorithm<br>
> writer.writeFile(feedback)<br>
> Exception: unknown<br>
><br>
> Execution failed after 16.94 seconds<br>
><br>
> Any thoughts please?<br>
><br>
> Dave<br>
><br>
><br>
><br>
><br>
> --<br>
> Sent from: <a href="http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html" rel="noreferrer" target="_blank">http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html</a><br>
> _______________________________________________<br>
> Qgis-user mailing list<br>
> <a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
> List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
> Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
<br>
<br>
------------------------------<br>
<br>
Message: 6<br>
Date: Fri, 13 Dec 2019 12:17:11 +0400<br>
From: Arnaud Vandecasteele <<a href="mailto:arnaud.sig@gmail.com" target="_blank">arnaud.sig@gmail.com</a>><br>
To: Etienne Trimaille <<a href="mailto:etienne.trimaille@gmail.com" target="_blank">etienne.trimaille@gmail.com</a>><br>
Cc: qgis-user <<a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a>><br>
Subject: Re: [Qgis-user] QGIS Server / GetPrint not rendering all the<br>
layers (XYZ Tiles for example)<br>
Message-ID:<br>
<<a href="mailto:CAHZ2jmAcCSOxeVqA11OyqPPv2U6u2DQ_6z2NJbDxKOqy99DnvA@mail.gmail.com" target="_blank">CAHZ2jmAcCSOxeVqA11OyqPPv2U6u2DQ_6z2NJbDxKOqy99DnvA@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi Etienne,<br>
<br>
Thanks for your help.<br>
As suggested, I change the config for :<br>
<br>
FcgidInitialEnv DISPLAY ":99"<br>
FcgidInitialEnv QGIS_SERVER_LOG_LEVEL "0"<br>
FcgidInitialEnv QGIS_SERVER_LOG_STDERR "1"<br>
FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH<br>
"/home/arnaudvandecasteele/qgisserver"<br>
FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE<br>
"/home/arnaudvandecasteele/qgisserver/qgis-auth.db"<br>
FcgidInitialEnv QGIS_PREFIX_PATH /usr<br>
FcgidInitialEnv QGIS_OPTIONS_PATH<br>
"/home/arnaudvandecasteele/qgisserver/<br>
<br>
The folder rights looks ok.<br>
ls -l<br>
drwxrwxr-x 2 www-data www-data 4096 Dec 13<br>
08:45 qgisserver<br>
<br>
Unfortunately the error remain :<br>
*************<br>
Warning 1: Unable to find driver ECW to unload from GDAL_SKIP environment<br>
variable.<br>
Warning 1: Unable to find driver ECW to unload from GDAL_SKIP environment<br>
variable.<br>
Warning 1: Unable to find driver JP2ECW to unload from GDAL_SKIP<br>
environment variable.<br>
Warning 1: Unable to find driver ECW to unload from GDAL_SKIP environment<br>
variable.<br>
Warning 1: Unable to find driver JP2ECW to unload from GDAL_SKIP<br>
environment variable.<br>
ERROR: Auth db directory path could not be created<br>
Initializing server modules from "/usr/lib/qgis/server"<br>
<br>
"Checking /usr/lib/qgis/server for native services modules"<br>
"Loading native module /usr/lib/qgis/server/libdummy.so"<br>
"Loading native module /usr/lib/qgis/server/libwcs.so"<br>
"Loading native module /usr/lib/qgis/server/libwfs.so"<br>
"Loading native module /usr/lib/qgis/server/libwms.so"<br>
"Loading native module /usr/lib/qgis/server/libwmts.so"<br>
ERROR: Opening of authentication db FAILED<br>
QSqlQuery::prepare: database not open<br>
WARNING: Auth db query exec() FAILED<br>
*************<br>
<br>
As I understand the use of the authentification system in desktop mode, it<br>
is still a bit confusing for me when using a server.<br>
For example, I don't have any qgis-auth.db file on my server. Do I have to<br>
copy it from my desktop ?<br>
<br>
Thanks again,<br>
<br>
Best,<br>
<br>
Arnaud<br>
<br>
<br>
On Fri, Dec 13, 2019 at 11:37 AM Etienne Trimaille <<br>
<a href="mailto:etienne.trimaille@gmail.com" target="_blank">etienne.trimaille@gmail.com</a>> wrote:<br>
<br>
> Hi Arnaud,<br>
><br>
> It looks like a cache write issue.<br>
><br>
> QGIS_OPTIONS_PATH must be a directory, not a file path.<br>
><br>
> <a href="https://docs.qgis.org/testing/en/docs/user_manual/working_with_ogc/server/config.html#qgis-options-path" rel="noreferrer" target="_blank">https://docs.qgis.org/testing/en/docs/user_manual/working_with_ogc/server/config.html#qgis-options-path</a><br>
><br>
> I would add QGIS_OPTIONS_PATH too. And check that the profile is writable<br>
> for QGIS Server (www-data?). After the GetPrint request, I think you should<br>
> see the cache folder created.<br>
><br>
> This my config :<br>
><br>
> QGIS_CUSTOM_CONFIG_PATH=/home/etienne/dev/qgis/server_home/profile<br>
> QGIS_OPTIONS_PATH=/home/etienne/dev/qgis/server_home<br>
> QGIS_PLUGINPATH=/home/etienne/dev/qgis/server_plugin<br>
><br>
> Can you check that?<br>
><br>
><br>
><br>
> Le ven. 13 déc. 2019 à 07:25, Arnaud Vandecasteele <<a href="mailto:arnaud.sig@gmail.com" target="_blank">arnaud.sig@gmail.com</a>><br>
> a écrit :<br>
><br>
>> ****<br>
>> Distribution Ubuntu<br>
>> QGIS Server on server -> Version: 3.4.11+dfsg-2~bionic1<br>
>> QGIS Server on computer -> Version: 3.4.13+dfsg-3~bionic2<br>
>> ****<br>
>><br>
>> I have QGIS Server installed on my computer and on my server. The same<br>
>> project is used on both. This project is very simple and contains a SHP<br>
>> layer and a XYZ OpenStreetMap layer. When printing the map (GetPrint) on my<br>
>> computer all layers are correctly displayed.<br>
>> The same operation on the server displays only the SHP layer and not the<br>
>> XYZ layer.<br>
>><br>
>> When the GetPrint request is made on the server, the following lines are<br>
>> added to the log file:<br>
>> ERROR: Opening of authentication db FAILED<br>
>> QSqlQuery::prepare: database not open<br>
>> WARNING: Auth db query exec() FAILED<br>
>><br>
>> However, I have the impression that my configuration file is correctly<br>
>> configured:<br>
>><br>
>> FcgidInitialEnv DISPLAY":99"<br>
>> FcgidInitialEnv QGIS_SERVER_LOG_LEVEL "0"<br>
>> FcgidInitialEnv QGIS_SERVER_LOG_STDERR "1"<br>
>> FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH "/home/qgis/qgisserverdb"<br>
>> FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE<br>
>> "/home/qgis/qgisserverdb/qgis-auth.db"<br>
>> FcgidInitialEnv QGIS_PREFIX_PATH /usr<br>
>> FcgidInitialEnv QGIS_OPTIONS_PATH<br>
>> /data/owncloud-data/arnaud/files/GEOLAB/Transfert/webmapping-lizmap/QGIS3.ini<br>
>> <Rental /qgisserver><br>
>> SetHandler fcgid-script<br>
>> FcgidWrapper /usr/lib/cgi-bin/qgis_mapserv.fcgi virtual<br>
>> Options +ExecCGI -MultiViews +FollowSymLinks<br>
>> Require all granted<br>
>> </Location><br>
>><br>
>> ErrorLog ${APACHE_LOG_DIR}/map-error.log<br>
>> LogLevel warn<br>
>> CustomLog ${APACHE_LOG_DIR}/map-access.log combined<br>
>><br>
>> And the permissions look good:<br>
>> ls -l /home/qgis/<br>
>> drwxr-xr-x 2 www-data www-data www-data 4096 Oct 25 08:46 cache<br>
>> drwxr-xr-xx 2 www-data www-data www-data 4096 Jun 20 07:32 qgisserverdb<br>
>><br>
>> Do you have any idea what might cause this problem?<br>
>><br>
>> Thank you in advance,<br>
>><br>
>> Arnaud<br>
>> _______________________________________________<br>
>> Qgis-user mailing list<br>
>> <a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
>> List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
>> Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
><br>
><br>
<br>
-- <br>
--------------------------------------------------------------------<br>
Arnaud Vandecasteele<br>
SIG - WebMapping - Spatial Ontology - GeoCollaboration<br>
<br>
Web Site<br>
<a href="http://geotribu.net/" rel="noreferrer" target="_blank">http://geotribu.net/</a><br>
<a href="http://about.me/arnaud_vandecasteele" rel="noreferrer" target="_blank">http://about.me/arnaud_vandecasteele</a><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20191213/d8b194e9/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20191213/d8b194e9/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 7<br>
Date: Fri, 13 Dec 2019 09:50:20 +0100<br>
From: Alessandro Pasotti <<a href="mailto:apasotti@gmail.com" target="_blank">apasotti@gmail.com</a>><br>
To: Arnaud Vandecasteele <<a href="mailto:arnaud.sig@gmail.com" target="_blank">arnaud.sig@gmail.com</a>><br>
Cc: Etienne Trimaille <<a href="mailto:etienne.trimaille@gmail.com" target="_blank">etienne.trimaille@gmail.com</a>>, qgis-user<br>
<<a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a>><br>
Subject: Re: [Qgis-user] QGIS Server / GetPrint not rendering all the<br>
layers (XYZ Tiles for example)<br>
Message-ID:<br>
<<a href="mailto:CAL5Q671A-dO9HGnA8N3YYmVaBaW4O65PfLop0Fe-3QJ4f4%2BesA@mail.gmail.com" target="_blank">CAL5Q671A-dO9HGnA8N3YYmVaBaW4O65PfLop0Fe-3QJ4f4+esA@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
On Fri, Dec 13, 2019 at 9:17 AM Arnaud Vandecasteele <<a href="mailto:arnaud.sig@gmail.com" target="_blank">arnaud.sig@gmail.com</a>><br>
wrote:<br>
<br>
> Hi Etienne,<br>
><br>
> Thanks for your help.<br>
> As suggested, I change the config for :<br>
><br>
> FcgidInitialEnv DISPLAY ":99"<br>
> FcgidInitialEnv QGIS_SERVER_LOG_LEVEL "0"<br>
> FcgidInitialEnv QGIS_SERVER_LOG_STDERR "1"<br>
> FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH<br>
> "/home/arnaudvandecasteele/qgisserver"<br>
> FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE<br>
> "/home/arnaudvandecasteele/qgisserver/qgis-auth.db"<br>
> FcgidInitialEnv QGIS_PREFIX_PATH /usr<br>
> FcgidInitialEnv QGIS_OPTIONS_PATH<br>
> "/home/arnaudvandecasteele/qgisserver/<br>
><br>
> The folder rights looks ok.<br>
> ls -l<br>
> drwxrwxr-x 2 www-data www-data 4096 Dec 13<br>
> 08:45 qgisserver<br>
><br>
> Unfortunately the error remain :<br>
> *************<br>
> Warning 1: Unable to find driver ECW to unload from GDAL_SKIP environment<br>
> variable.<br>
> Warning 1: Unable to find driver ECW to unload from GDAL_SKIP environment<br>
> variable.<br>
> Warning 1: Unable to find driver JP2ECW to unload from GDAL_SKIP<br>
> environment variable.<br>
> Warning 1: Unable to find driver ECW to unload from GDAL_SKIP environment<br>
> variable.<br>
> Warning 1: Unable to find driver JP2ECW to unload from GDAL_SKIP<br>
> environment variable.<br>
> ERROR: Auth db directory path could not be created<br>
> Initializing server modules from "/usr/lib/qgis/server"<br>
><br>
> "Checking /usr/lib/qgis/server for native services modules"<br>
> "Loading native module /usr/lib/qgis/server/libdummy.so"<br>
> "Loading native module /usr/lib/qgis/server/libwcs.so"<br>
> "Loading native module /usr/lib/qgis/server/libwfs.so"<br>
> "Loading native module /usr/lib/qgis/server/libwms.so"<br>
> "Loading native module /usr/lib/qgis/server/libwmts.so"<br>
> ERROR: Opening of authentication db FAILED<br>
> QSqlQuery::prepare: database not open<br>
> WARNING: Auth db query exec() FAILED<br>
> *************<br>
><br>
> As I understand the use of the authentification system in desktop mode, it<br>
> is still a bit confusing for me when using a server.<br>
> For example, I don't have any qgis-auth.db file on my server. Do I have to<br>
> copy it from my desktop ?<br>
><br>
<br>
<br>
Hi,<br>
<br>
no, you don't need to copy it unless you want to use the credentials you've<br>
stored in it.<br>
<br>
The DB will be created automatically if it doesn't exist when QGIS Server<br>
process starts.<br>
<br>
See: <a href="https://github.com/qgis/QGIS/blob/master/src/server/qgsserver.cpp#L245" rel="noreferrer" target="_blank">https://github.com/qgis/QGIS/blob/master/src/server/qgsserver.cpp#L245</a><br>
<br>
<br>
<br>
> Thanks again,<br>
><br>
> Best,<br>
><br>
> Arnaud<br>
><br>
><br>
> On Fri, Dec 13, 2019 at 11:37 AM Etienne Trimaille <<br>
> <a href="mailto:etienne.trimaille@gmail.com" target="_blank">etienne.trimaille@gmail.com</a>> wrote:<br>
><br>
>> Hi Arnaud,<br>
>><br>
>> It looks like a cache write issue.<br>
>><br>
>> QGIS_OPTIONS_PATH must be a directory, not a file path.<br>
>><br>
>> <a href="https://docs.qgis.org/testing/en/docs/user_manual/working_with_ogc/server/config.html#qgis-options-path" rel="noreferrer" target="_blank">https://docs.qgis.org/testing/en/docs/user_manual/working_with_ogc/server/config.html#qgis-options-path</a><br>
>><br>
>> I would add QGIS_OPTIONS_PATH too. And check that the profile is writable<br>
>> for QGIS Server (www-data?). After the GetPrint request, I think you should<br>
>> see the cache folder created.<br>
>><br>
>> This my config :<br>
>><br>
>> QGIS_CUSTOM_CONFIG_PATH=/home/etienne/dev/qgis/server_home/profile<br>
>> QGIS_OPTIONS_PATH=/home/etienne/dev/qgis/server_home<br>
>> QGIS_PLUGINPATH=/home/etienne/dev/qgis/server_plugin<br>
>><br>
>> Can you check that?<br>
>><br>
>><br>
>><br>
>> Le ven. 13 déc. 2019 à 07:25, Arnaud Vandecasteele <<a href="mailto:arnaud.sig@gmail.com" target="_blank">arnaud.sig@gmail.com</a>><br>
>> a écrit :<br>
>><br>
>>> ****<br>
>>> Distribution Ubuntu<br>
>>> QGIS Server on server -> Version: 3.4.11+dfsg-2~bionic1<br>
>>> QGIS Server on computer -> Version: 3.4.13+dfsg-3~bionic2<br>
>>> ****<br>
>>><br>
>>> I have QGIS Server installed on my computer and on my server. The same<br>
>>> project is used on both. This project is very simple and contains a SHP<br>
>>> layer and a XYZ OpenStreetMap layer. When printing the map (GetPrint) on my<br>
>>> computer all layers are correctly displayed.<br>
>>> The same operation on the server displays only the SHP layer and not the<br>
>>> XYZ layer.<br>
>>><br>
>>> When the GetPrint request is made on the server, the following lines are<br>
>>> added to the log file:<br>
>>> ERROR: Opening of authentication db FAILED<br>
>>> QSqlQuery::prepare: database not open<br>
>>> WARNING: Auth db query exec() FAILED<br>
>>><br>
>>> However, I have the impression that my configuration file is correctly<br>
>>> configured:<br>
>>><br>
>>> FcgidInitialEnv DISPLAY":99"<br>
>>> FcgidInitialEnv QGIS_SERVER_LOG_LEVEL "0"<br>
>>> FcgidInitialEnv QGIS_SERVER_LOG_STDERR "1"<br>
>>> FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH "/home/qgis/qgisserverdb"<br>
>>> FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE<br>
>>> "/home/qgis/qgisserverdb/qgis-auth.db"<br>
>>> FcgidInitialEnv QGIS_PREFIX_PATH /usr<br>
>>> FcgidInitialEnv QGIS_OPTIONS_PATH<br>
>>> /data/owncloud-data/arnaud/files/GEOLAB/Transfert/webmapping-lizmap/QGIS3.ini<br>
>>> <Rental /qgisserver><br>
>>> SetHandler fcgid-script<br>
>>> FcgidWrapper /usr/lib/cgi-bin/qgis_mapserv.fcgi virtual<br>
>>> Options +ExecCGI -MultiViews +FollowSymLinks<br>
>>> Require all granted<br>
>>> </Location><br>
>>><br>
>>> ErrorLog ${APACHE_LOG_DIR}/map-error.log<br>
>>> LogLevel warn<br>
>>> CustomLog ${APACHE_LOG_DIR}/map-access.log combined<br>
>>><br>
>>> And the permissions look good:<br>
>>> ls -l /home/qgis/<br>
>>> drwxr-xr-x 2 www-data www-data www-data 4096 Oct 25 08:46 cache<br>
>>> drwxr-xr-xx 2 www-data www-data www-data 4096 Jun 20 07:32 qgisserverdb<br>
>>><br>
>>> Do you have any idea what might cause this problem?<br>
>>><br>
>>> Thank you in advance,<br>
>>><br>
>>> Arnaud<br>
>>> _______________________________________________<br>
>>> Qgis-user mailing list<br>
>>> <a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
>>> List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
>>> Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
>><br>
>><br>
><br>
> --<br>
> --------------------------------------------------------------------<br>
> Arnaud Vandecasteele<br>
> SIG - WebMapping - Spatial Ontology - GeoCollaboration<br>
><br>
> Web Site<br>
> <a href="http://geotribu.net/" rel="noreferrer" target="_blank">http://geotribu.net/</a><br>
> <a href="http://about.me/arnaud_vandecasteele" rel="noreferrer" target="_blank">http://about.me/arnaud_vandecasteele</a><br>
><br>
> _______________________________________________<br>
> Qgis-user mailing list<br>
> <a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
> List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
> Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
<br>
<br>
<br>
-- <br>
Alessandro Pasotti<br>
w3: <a href="http://www.itopen.it" rel="noreferrer" target="_blank">www.itopen.it</a><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20191213/4c55d3d7/attachment.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20191213/4c55d3d7/attachment.html</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
<br>
------------------------------<br>
<br>
End of Qgis-user Digest, Vol 166, Issue 14<br>
******************************************<br>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr">--------------------------------------------------------------------<br>Arnaud Vandecasteele<br>SIG - WebMapping - Spatial Ontology - GeoCollaboration<br><br>Web Site<br><a href="http://geotribu.net/" target="_blank">http://geotribu.net/</a><br><a href="http://about.me/arnaud_vandecasteele" target="_blank">http://about.me/arnaud_vandecasteele</a><br><br></div></div>