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

Fri Dec 13 01:03:06 PST 2019

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20191213/71fe923d/attachment.html>