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

Werner Macho werner.macho at gmail.com
Fri Dec 13 01:07:59 PST 2019 

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.sig at 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 <apasotti at gmail.com> a
> écrit :
>
>>
>>
>> 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
>>
> _______________________________________________
> 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/625a9e13/attachment.html>

More information about the Qgis-user mailing list