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

Fri Dec 13 00:17:11 PST 2019

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.html>