[Qgis-user] Qgis-user Digest, Vol 166, Issue 14
Arnaud Vandecasteele
arnaud.sig at gmail.com
Fri Dec 13 02:59:21 PST 2019
Hi,
I've finally found the problem.
My qgis server works configuration is defined inside a virtual host :
<VirtualHost *:80>
ServerAdmin ***
ServerName ***
ServerAlias ***
DocumentRoot***
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 /usradd
FcgidInitialEnv QGIS_OPTIONS_PATH "/home/qgis/qgisserver/"
<Location /qgisserver>
SetHandler fcgid-script
FcgidWrapper /usr/lib/cgi-bin/qgis_mapserv.fcgi virtual
Options +ExecCGI -MultiViews +FollowSymLinks
Require all granted
</Location>
ErrorLog ${APACHE_LOG_DIR}/map-error.log
LogLevel warn
CustomLog ${APACHE_LOG_DIR}/map-access.log combined
</VirtualHost>
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.
I would prefer to keep all the parameters inside the same virtual host
config file but at least I've a working solution.
Thanks all of you for help !
Best,
Arnaud
On Fri, Dec 13, 2019 at 12:51 PM <qgis-user-request at lists.osgeo.org> wrote:
> Send Qgis-user mailing list submissions to
> qgis-user at lists.osgeo.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.osgeo.org/mailman/listinfo/qgis-user
> or, via email, send a message with subject or body 'help' to
> qgis-user-request at lists.osgeo.org
>
> You can reach the person managing the list at
> qgis-user-owner at lists.osgeo.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Qgis-user digest..."
>
>
> Today's Topics:
>
> 1. Re: Working with DEMs (Dave Gardiner)
> 2. Re: Working with DEMs (Bernd Vogelgesang)
> 3. Re: QGIS Server / GetPrint not rendering all the layers (XYZ
> Tiles for example) (Etienne Trimaille)
> 4. Re: Working with DEMs (Dave Gardiner)
> 5. Re: Working with DEMs (Bernd Vogelgesang)
> 6. Re: QGIS Server / GetPrint not rendering all the layers (XYZ
> Tiles for example) (Arnaud Vandecasteele)
> 7. Re: QGIS Server / GetPrint not rendering all the layers (XYZ
> Tiles for example) (Alessandro Pasotti)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 12 Dec 2019 23:55:15 -0700 (MST)
> From: Dave Gardiner <2dave.gardiner at gmail.com>
> To: qgis-user at lists.osgeo.org
> Subject: Re: [Qgis-user] Working with DEMs
> Message-ID: <1576220115629-0.post at n6.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> Hi Harvard
>
> I have extracted the nodes from the contour lines with the elevation field
> extracted. Could you please explain further how I generate a raster using a
> tin or spline interpolation. Where are these commands (Version 3.4.13).
>
> Kind Regards
> Dave
>
>
>
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 13 Dec 2019 08:05:58 +0100
> From: Bernd Vogelgesang <bernd.vogelgesang at gmx.de>
> To: qgis-user at lists.osgeo.org
> Subject: Re: [Qgis-user] Working with DEMs
> Message-ID: <94cc9324-c6a0-d5d5-9b42-74ae35192048 at gmx.de>
> Content-Type: text/plain; charset=utf-8; format=flowed
>
> just type "interpolation" into the search field of the tool box, and all
> the functions will jump right into your face.
>
> Am 13.12.19 um 07:55 schrieb Dave Gardiner:
> > Hi Harvard
> >
> > I have extracted the nodes from the contour lines with the elevation
> field
> > extracted. Could you please explain further how I generate a raster
> using a
> > tin or spline interpolation. Where are these commands (Version 3.4.13).
> >
> > Kind Regards
> > Dave
> >
> >
> >
> > --
> > Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
> > _______________________________________________
> > Qgis-user mailing list
> > Qgis-user at lists.osgeo.org
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
> ------------------------------
>
> Message: 3
> Date: Fri, 13 Dec 2019 08:36:59 +0100
> From: Etienne Trimaille <etienne.trimaille at gmail.com>
> To: Arnaud Vandecasteele <arnaud.sig at gmail.com>
> Cc: qgis-user <qgis-user at lists.osgeo.org>
> Subject: Re: [Qgis-user] QGIS Server / GetPrint not rendering all the
> layers (XYZ Tiles for example)
> Message-ID:
> <CAMtDFLL=n7x_O=gQbxHYrVopfE2WQdYgOiOy9tOt+qHYg4=
> J-g at 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 <arnaud.sig at 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:
> >
> > 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
> > <Rental /qgisserver>
> > SetHandler fcgid-script
> > FcgidWrapper /usr/lib/cgi-bin/qgis_mapserv.fcgi virtual
> > Options +ExecCGI -MultiViews +FollowSymLinks
> > Require all granted
> > </Location>
> >
> > 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 at 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.gardiner at gmail.com>
> To: qgis-user at lists.osgeo.org
> Subject: Re: [Qgis-user] Working with DEMs
> Message-ID: <1576223423876-0.post at 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
>
> Execution failed after 16.94 seconds
>
> Any thoughts please?
>
> Dave
>
>
>
>
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
>
>
> ------------------------------
>
> Message: 5
> Date: Fri, 13 Dec 2019 09:16:10 +0100
> From: Bernd Vogelgesang <bernd.vogelgesang at gmx.de>
> To: qgis-user at lists.osgeo.org
> Subject: Re: [Qgis-user] Working with DEMs
> Message-ID: <17da1ed3-a3dd-1715-8046-23f137500569 at gmx.de>
> Content-Type: text/plain; charset=utf-8; format=flowed
>
> 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 at lists.osgeo.org
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
> ------------------------------
>
> Message: 6
> Date: Fri, 13 Dec 2019 12:17:11 +0400
> From: Arnaud Vandecasteele <arnaud.sig at gmail.com>
> To: Etienne Trimaille <etienne.trimaille at gmail.com>
> Cc: qgis-user <qgis-user at lists.osgeo.org>
> Subject: Re: [Qgis-user] QGIS Server / GetPrint not rendering all the
> layers (XYZ Tiles for example)
> Message-ID:
> <
> CAHZ2jmAcCSOxeVqA11OyqPPv2U6u2DQ_6z2NJbDxKOqy99DnvA at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> 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-data www-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.trimaille at 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.sig at 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:
> >>
> >> 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
> >> <Rental /qgisserver>
> >> SetHandler fcgid-script
> >> FcgidWrapper /usr/lib/cgi-bin/qgis_mapserv.fcgi virtual
> >> Options +ExecCGI -MultiViews +FollowSymLinks
> >> Require all granted
> >> </Location>
> >>
> >> 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 at lists.osgeo.org
> >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >
> >
>
> --
> --------------------------------------------------------------------
> Arnaud Vandecasteele
> SIG - WebMapping - Spatial Ontology - GeoCollaboration
>
> Web Site
> http://geotribu.net/
> http://about.me/arnaud_vandecasteele
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.osgeo.org/pipermail/qgis-user/attachments/20191213/d8b194e9/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 7
> Date: Fri, 13 Dec 2019 09:50:20 +0100
> From: Alessandro Pasotti <apasotti at gmail.com>
> To: Arnaud Vandecasteele <arnaud.sig at gmail.com>
> Cc: Etienne Trimaille <etienne.trimaille at gmail.com>, qgis-user
> <qgis-user at lists.osgeo.org>
> Subject: Re: [Qgis-user] QGIS Server / GetPrint not rendering all the
> layers (XYZ Tiles for example)
> Message-ID:
> <
> CAL5Q671A-dO9HGnA8N3YYmVaBaW4O65PfLop0Fe-3QJ4f4+esA at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> On Fri, Dec 13, 2019 at 9:17 AM Arnaud Vandecasteele <arnaud.sig at 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-data www-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.trimaille at 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.sig at 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:
> >>>
> >>> 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
> >>> <Rental /qgisserver>
> >>> SetHandler fcgid-script
> >>> FcgidWrapper /usr/lib/cgi-bin/qgis_mapserv.fcgi virtual
> >>> Options +ExecCGI -MultiViews +FollowSymLinks
> >>> Require all granted
> >>> </Location>
> >>>
> >>> 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 at lists.osgeo.org
> >>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >>
> >>
> >
> > --
> > --------------------------------------------------------------------
> > Arnaud Vandecasteele
> > SIG - WebMapping - Spatial Ontology - GeoCollaboration
> >
> > Web Site
> > http://geotribu.net/
> > http://about.me/arnaud_vandecasteele
> >
> > _______________________________________________
> > Qgis-user mailing list
> > Qgis-user at 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
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.osgeo.org/pipermail/qgis-user/attachments/20191213/4c55d3d7/attachment.html
> >
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
> ------------------------------
>
> End of Qgis-user Digest, Vol 166, Issue 14
> ******************************************
>
--
--------------------------------------------------------------------
Arnaud Vandecasteele
SIG - WebMapping - Spatial Ontology - GeoCollaboration
Web Site
http://geotribu.net/
http://about.me/arnaud_vandecasteele
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20191213/f5fce562/attachment-0001.html>
More information about the Qgis-user
mailing list