Thanks for your help. It works now. Le mar. 9 mai 2023 à 12:28, celati Laurent <[email protected]> a écrit :
> Hello, > Following to my previous message, i share an update of my qgis server and > lizmap messages. For those tests, in addition to the .qgs file, i put on > the server the .qgs.cfg. Is it mandatory to do this ? > Please read below the qgis server and lizmap messages : > > *qgis server : * > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > *Code:12:10:06 INFO Server[824190]: ******************** New request > ***************12:10:06 INFO Server[824190]: Request URL: > http://XXX-XXXX.XXXX.fr/cgi-bin/qgis_mapserv.fcgi?map=%2Fhome%2Fdata%2Fftp%2Ftemplate%2Fqgis%2Flizmap_test%2Fzios.qgs&request=getcapabilities&service=WMS&version=1.3.0&Lizmap_User=admin&Lizmap_User_Groups=admins&Lizmap_Override_Filter=1 > <http://XXX-XXXX.XXXX.fr/cgi-bin/qgis_mapserv.fcgi?map=%2Fhome%2Fdata%2Fftp%2Ftemplate%2Fqgis%2Flizmap_test%2Fzios.qgs&request=getcapabilities&service=WMS&version=1.3.0&Lizmap_User=admin&Lizmap_User_Groups=admins&Lizmap_Override_Filter=1>12:10:06 > INFO Server[824190]: Environment:12:10:06 INFO Server[824190]: > ------------------------------------------------12:10:06 INFO > Server[824190]: SERVER_NAME: XXXX-XXXXX.XXXXX.fr > <http://XXXX-XXXXX.XXXXX.fr>12:10:06 INFO Server[824190]: REQUEST_URI: > /cgi-bin/qgis_mapserv.fcgi?map=%2Fhome%2Fdata%2Fftp%2Ftemplate%2Fqgis%2Flizmap%5Ftest%2Fzios%2Eqgs&request=getcapabilities&service=WMS&version=1%2E3%2E0&Lizmap%5FUser=admin&Lizmap%5FUser%5FGroups=admins&Lizmap%5FOverride%5FFilter=112:10:06 > INFO Server[824190]: SCRIPT_NAME: /cgi-bin/qgis_mapserv.fcgi12:10:06 INFO > Server[824190]: REMOTE_ADDR: XXXXXX.XXXXX.XXXX.XXXXX12:10:06 INFO > Server[824190]: SERVER_PORT: 8012:10:06 INFO Server[824190]: QUERY_STRING: > map=%2Fhome%2Fdata%2Fftp%2Ftemplate%2Fqgis%2Flizmap%5Ftest%2Fzios%2Eqgs&request=getcapabilities&service=WMS&version=1%2E3%2E0&Lizmap%5FUser=admin&Lizmap%5FUser%5FGroups=admins&Lizmap%5FOverride%5FFilter=112:10:06 > INFO Server[824190]: REQUEST_METHOD: GET12:10:06 INFO Server[824190]: > QGIS_PROJECT_FILE: /home/qgis/projects/world.qgs12:10:06 INFO > Server[824190]: SERVER_PROTOCOL: HTTP/1.112:10:06 INFO Lizmap[824190]: > Request headers provided12:10:06 INFO Lizmap[824190]: No lizmap user groups > in request headers12:10:06 INFO Lizmap[824190]: Lizmap user groups in > parameters : admins12:10:06 INFO Lizmap[824190]: Fetching > /home/data/ftp/template/qgis/lizmap_test/zios.qgs.cfg cfg file with last > modified timestamp : 1683626320.575111912:10:06 INFO Lizmap[824190]: No acl > defined in Lizmap config12:10:06 INFO Server[824190]: > LIZMAP_OVERRIDE_FILTER:112:10:06 INFO Server[824190]: > LIZMAP_USER:admin12:10:06 INFO Server[824190]: > LIZMAP_USER_GROUPS:admins12:10:06 INFO Server[824190]: > MAP:/home/data/ftp/template/qgis/lizmap_test/zios.qgs12:10:06 INFO > Server[824190]: REQUEST:getcapabilities12:10:06 INFO Server[824190]: > SERVICE:WMS12:10:06 INFO Server[824190]: VERSION:1.3.012:10:06 CRITICAL > Server[824190]: Error, Layer(s) > Cigeo_Zios_Po_20170503_ee7aedcd_2ab0_4b3f_bb42_81725199ad65 not valid in > project /home/data/ftp/template/qgis/lizmap_test/zios.qgs12:10:06 WARNING > Server[824190]: <?xml version="1.0" > encoding="UTF-8"?><ServerException>Layer(s) not > valid</ServerException>12:10:06 INFO Server[824190]: Request finished in 70 > ms* > > *Lizmap message : * > An error occurred while loading the map. Required resources may be > temporarily unavailable. Please try later. > Return to home page. > > *Lizmap Logs : * > > 2023-05-09 12:04:18 [8] Undefined index: repository > /var/www/lizmap/lizmap-web-client-3.6.3/temp/lizmap/www/compiled/templates/modules/admin/server_information_html_t_15.php > 171 > > 2023-05-09 12:04:18 [8] Undefined index: repository > /var/www/lizmap/lizmap-web-client-3.6.3/temp/lizmap/www/compiled/templates/modules/admin/server_information_html_t_15.php > 171 > > 2023-05-09 12:05:04 [8] Undefined index: repository > /var/www/lizmap/lizmap-web-client-3.6.3/temp/lizmap/www/compiled/templates/modules/admin/server_information_html_t_15.php > 171 > > 2023-05-09 12:05:04 [8] Undefined index: repository > /var/www/lizmap/lizmap-web-client-3.6.3/temp/lizmap/www/compiled/templates/modules/admin/server_information_html_t_15.php > 171 > > 2023-05-09 12:05:24 172.21.20.97 error GetCapabilities result code: > 500 > 2023-05-09 12:05:25 172.21.20.97 error GetCapabilities result code: > 500 > 2023-05-09 12:05:28 172.21.20.97 error GetCapabilities result code: > 500 > 2023-05-09 12:05:28 172.21.20.97 error An error has been raised when > loading WMS GetCapabilities: HTTP Code 400 > 2023-05-09 12:06:02 172.21.20.97 error GetCapabilities result code: > 500 > 2023-05-09 12:06:03 172.21.20.97 error GetCapabilities result code: > 500 > 2023-05-09 12:06:03 172.21.20.97 error An error has been raised when > loading WMS GetCapabilities: HTTP Code 400 > 2023-05-09 12:06:06 172.21.20.97 error GetCapabilities result code: > 500 > 2023-05-09 12:07:41 [8] Undefined index: repository > /var/www/lizmap/lizmap-web-client-3.6.3/temp/lizmap/www/compiled/templates/modules/admin/server_information_html_t_15.php > 171 > > 2023-05-09 12:07:41 [8] Undefined index: repository > /var/www/lizmap/lizmap-web-client-3.6.3/temp/lizmap/www/compiled/templates/modules/admin/server_information_html_t_15.php > 171 > > > > Thanks a lot for your help > > Le ven. 5 mai 2023 à 14:24, celati Laurent <[email protected]> a > écrit : > >> Hello, >> Following to my previous message, i validated the ability to connect to >> the postgresql server (with pg_isready). >> I ' m taking the liberty to paste below an update of qgis server log : >> We can see *Connection to database failed **fe_sendauth: no password >> supplied* >> Do you know the meaning of this message and how to fix this erreur ? >> Moreover, what is the meaning of the critical error : *Layer(s) not >> valid ? * >> >> *14:12:37 INFO Server[778180]: ******************** New request >> **************** >> >> *14:12:37 INFO Server[778180]: Request URL: >> http://xxx.xxx.fr/cgi-bin/qgis_mapserv.fcgi?MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs >> <http://xxx.xxx.fr/cgi-bin/qgis_mapserv.fcgi?MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs>* >> >> *14:12:37 INFO Server[778180]: Environment:* >> >> *14:12:37 INFO Server[778180]: >> ------------------------------------------------* >> >> *14:12:37 INFO Server[778180]: SERVER_NAME: xxxx.xxxx.fr >> <http://xxxx.xxxx.fr>* >> >> *14:12:37 INFO Server[778180]: REQUEST_URI: >> /cgi-bin/qgis_mapserv.fcgi?MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs* >> >> *14:12:37 INFO Server[778180]: SCRIPT_NAME: /cgi-bin/qgis_mapserv.fcgi* >> >> *14:12:37 INFO Server[778180]: REMOTE_ADDR: 1xxx.xx.xx.xx* >> >> *14:12:37 INFO Server[778180]: SERVER_PORT: 80* >> >> *14:12:37 INFO Server[778180]: QUERY_STRING: >> MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs* >> >> *14:12:37 INFO Server[778180]: REQUEST_METHOD: GET* >> >> *14:12:37 INFO Server[778180]: QGIS_PROJECT_FILE: >> /home/qgis/projects/world.qgs* >> >> *14:12:37 INFO Server[778180]: SERVER_PROTOCOL: HTTP/1.1* >> >> *14:12:37 INFO Lizmap[778180]: Request headers provided* >> >> *14:12:37 INFO Lizmap[778180]: No lizmap user groups in request headers* >> >> *14:12:37 INFO Server[778180]: >> MAP:/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs* >> >> *14:12:37 WARNING PostGIS[778180]: Connection to database failed* >> >> *fe_sendauth: no password supplied* >> >> >> >> *14:12:37 CRITICAL Server[778180]: Error, Layer(s) >> Ouvrage_a_Realiser_Pt_7249ce6e_1919_4704_8a1c_cce8299e331d not valid in >> project /home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs* >> >> *14:12:37 WARNING Server[778180]: <?xml version="1.0" encoding="UTF-8"?>* >> >> *<ServerException>Layer(s) not valid</ServerException>* >> >> >> >> *14:12:37 INFO Server[778180]: Request finished in 96 ms* >> >> Le ven. 5 mai 2023 à 10:55, celati Laurent <[email protected]> a >> écrit : >> >>> Good morning dear all, >>> >>> i work with debian and apache. Qgis server is working. For example, I >>> can see the world.qgs template project with qgis server. >>> A getcapabilities request also works. On the other hand, I can't up to >>> now see my project with a postgis table. Whether with qgis server and of >>> course with lizmap. >>> Below I share the lizmap and qgis server logs. I have probably several >>> errors. >>> Regarding the postgis aspect, I confess that I don't really understand >>> what to do as settings in the qgis project. I found a forum talking about >>> saving configuration in plain text. What is it exactly? How should I save >>> my id/password? I guess with qgis desktop In the window "edit a postgis >>> connection" ?. I imagine that everything is set in the Authentication >>> section? There are 2 tabs. A configuration and a "basic". Should I put >>> basic authentication? >>> I share my lizmap logs. Although I think they are less relevant at this >>> point than the qgis server logs. >>> >>> In advance, thanks so much for your really usefull help. >>> >>> *Log lizmap :* >>> >>> *2023-05-05 09:34:18 [8] Undefined index: repository >>> /var/www/lizmap/lizmap-web-client-3.6.3/temp/lizmap/www/compiled/templates/modules/admin/server_information_html_t_15.php >>> 171* >>> >>> *Log qgis server :* >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> *10:29:43 INFO Server[778180]: ******************** New request >>> ***************10:29:43 INFO Server[778180]: Request URL: >>> http://XXX.XXX.fr/cgi-bin/qgis_mapserv.fcgi?MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&BBOX=-432786,4372992,3358959,7513746&SRS=EPSG:3857&WIDTH=665&HEIGHT=551&LAYERS=countries&FORMAT=image/jpeg >>> <http://XXX.XXX.fr/cgi-bin/qgis_mapserv.fcgi?MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&BBOX=-432786,4372992,3358959,7513746&SRS=EPSG:3857&WIDTH=665&HEIGHT=551&LAYERS=countries&FORMAT=image/jpeg>10:29:43 >>> INFO Server[778180]: Environment:10:29:43 INFO Server[778180]: >>> ------------------------------------------------10:29:43 INFO >>> Server[778180]: SERVER_NAME: XXX-XXXX.andra.fr >>> <http://XXX-XXXX.andra.fr>10:29:43 INFO Server[778180]: REQUEST_URI: >>> /cgi-bin/qgis_mapserv.fcgi?MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&BBOX=-432786,4372992,3358959,7513746&SRS=EPSG:3857&WIDTH=665&HEIGHT=551&LAYERS=countries&FORMAT=image/jpeg10:29:43 >>> INFO Server[778180]: SCRIPT_NAME: /cgi-bin/qgis_mapserv.fcgi10:29:43 INFO >>> Server[778180]: REMOTE_ADDR: 172.21.20.9710:29:43 INFO Server[778180]: >>> SERVER_PORT: 8010:29:43 INFO Server[778180]: QUERY_STRING: >>> MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&BBOX=-432786,4372992,3358959,7513746&SRS=EPSG:3857&WIDTH=665&HEIGHT=551&LAYERS=countries&FORMAT=image/jpeg10:29:43 >>> INFO Server[778180]: REQUEST_METHOD: GET10:29:43 INFO Server[778180]: >>> QGIS_PROJECT_FILE: /home/qgis/projects/world.qgs10:29:43 INFO >>> Server[778180]: SERVER_PROTOCOL: HTTP/1.110:29:43 INFO Lizmap[778180]: >>> Request headers provided10:29:43 INFO Lizmap[778180]: No lizmap user groups >>> in request headers10:29:43 INFO Server[778180]: >>> BBOX:-432786,4372992,3358959,751374610:29:43 INFO Server[778180]: >>> FORMAT:image/jpeg10:29:43 INFO Server[778180]: HEIGHT:55110:29:43 INFO >>> Server[778180]: LAYERS:countries10:29:43 INFO Server[778180]: >>> MAP:/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs10:29:43 INFO >>> Server[778180]: REQUEST:GetMap10:29:43 INFO Server[778180]: >>> SERVICE:WMS10:29:43 INFO Server[778180]: SRS:EPSG:385710:29:43 INFO >>> Server[778180]: VERSION:1.3.010:29:43 INFO Server[778180]: >>> WIDTH:66510:30:13 WARNING PostGIS[778180]: Connection to database >>> failedtimeout expired10:30:13 CRITICAL Server[778180]: Error, Layer(s) >>> XXXXXX_Ouvrage_a_Realiser_Pt_8db55b4d_dd42_4d46_b5d1_1cffd2768ae1 not valid >>> in project /home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs10:30:13 >>> WARNING Server[778180]: <?xml version="1.0" >>> encoding="UTF-8"?><ServerException>Layer(s) not >>> valid</ServerException>10:30:14 INFO Server[778180]: Request finished in >>> 30136 ms* >>> >>
_______________________________________________ QGIS-User mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
