Re: [Qgis-user] Fresh install of QGIS Server doesn't work as expected

2023-05-02 Thread Jérémy Garniaux via QGIS-User 

Hi Benoît,

Thanks for your answer.

In the meantime I solved this issue (and the ones that popped up 
after!). Unfortunately I'm not sure exactly what was causing the issue 
here so I can't report it precisely for the record...


Best regards,

Jeremy

Le 02/05/2023 à 13:58, B. De Mezzo via QGIS-User a écrit :

Hi,

can you check if qgis_mapserv.fcgi is in /usr/lib/cgi-bin/?

Regards.

Le 27/04/2023 à 23:14, Jeremy Garniaux via QGIS-User a écrit :

Hi,

I'm trying to deploy QGIS Server on a Debian 11 VPS.
Following the doc (1)(2), I installed QGIS 3.30. Then I tested the 
install with


> /usr/lib/cgi-bin/qgis_mapserv.fcgi

Here's the output:

> $ /usr/lib/cgi-bin/qgis_mapserv.fcgi
> Application path not initialized
> Application path not initialized
> Application path not initialized
> Application path not initialized
> 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.

> "Loading native module /usr/lib/qgis/server/libdummy.so"
> "Loading native module /usr/lib/qgis/server/liblandingpage.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/libwfs3.so"
> "Loading native module /usr/lib/qgis/server/libwms.so"
> "Loading native module /usr/lib/qgis/server/libwmts.so"
> Content-Length: 0
> Location: http:/index.json
> Server:  QGIS FCGI server - QGIS version 3.30.1-'s-Hertogenbosch
> Status:  302

It's not what I expected after reading the doc but I kept going 
anyway, uploaded my custom QGIS project to the server, set up Apache 
and scrupulously followed the doc. Then I checked the availability of 
QGIS Server with


> 
http://qgis.demo/cgi-bin/qgis_mapserv.fcgi?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetCapabilities


...but got a 404 error.

Any suggestion on what I'm doing wrong?

Thanks for your help.

Best regards,

Jeremy


(1) 
https://docs.qgis.org/3.28/en/docs/server_manual/getting_started.html

(2) https://qgis.org/en/site/forusers/alldownloads.html



___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



--
Jérémy Garniaux
https://mapper.fr
https://mapstodon.space

___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Autogeneration id codes

2023-05-02 Thread Erik Wienhold via QGIS-User 
> On 02/05/2023 17:28 CEST Riccardo via QGIS-User  
> wrote:
>
> I have some tables already created that have a column with autogeneration id
> codes.

I assume this is about the primary key column.  What database system do you use?

> From self-generation I often don’t get codes that start from 1 onwards but
> start with other numbers.

That's the point of autogenerated IDs that they are not reused.  You can restart
the underlying sequence, depending on the database system.

> I made some tests and I noticed that if I create a table and add 10 lines the
> autogeneration creates id codes from 1 to 10. If I delete these lines to empty
> the table when I create a new line Qgis autogenerates that with the code 11,
> it seems that Qgis keeps in memory the number/id code of the created elements,
> and keep the numbering as a fixed counter.
>
> How can I impose a autogeneration of id codes starting from 1?

Why do you want to reuse previously generated IDs?  QGIS (or the database for
its part) must ensure that generated IDs are unique.  Two or more users
inserting rows in the same table at the same time should get different IDs.
If QGIS or the database would generate ID 1 because it's not used by any row,
users would insert their rows with the same ID and get a primary key constraint
violation.

--
Erik
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Autogeneration id codes

2023-05-02 Thread Richard McDonnell via QGIS-User 
Hi Riccardo,
Have you tried, after you delete your rows, disabling editing and then enabling 
editing again before you add your new rows?

Also have a look at this

https://gis.stackexchange.com/questions/132346/is-there-a-way-of-auto-increment-for-the-id-column-in-qgis

Regards,

Richard.



--
Richard McDonnell MSc GIS, FME Certified Professional
FRM Data Management

--
Oifig na nOibreacha Poiblí
Office of Public Works

Sráid Jonathan Swift, Baile Átha Troim, Co na Mí, C15 NX36
Jonathan Swift Street, Trim, Co Meath, C15 NX36
--
M +353 87 688 5964 T +353 46 942 2409
https://gov.ie/opw

--
To send me files larger than 30MB, please use the link below 
https://filetransfer.opw.ie/filedrop/richard.mcdonn...@opw.ie

Email Disclaimer: 
https://www.gov.ie/en/organisation-information/439daf-email-disclaimer/

--
MSc GIS, FME Certified Professional

--
Oifig na nOibreacha Poiblí
Office of Public Works

Sráid Jonathan Swift, Baile Átha Troim, Co na Mí, C15 NX36
Jonathan Swift Street, Trim, Co Meath, C15 NX36
--
M +353 87 688 5964 T +353 46 942 2409
https://https://gov.ie/opw

--
Email Disclaimer: 
https://www.gov.ie/en/organisation-information/439daf-email-disclaimer/
From: QGIS-User  On Behalf Of Riccardo via 
QGIS-User
Sent: 02 May 2023 16:28
To: Riccardo via QGIS-User 
Subject: [Qgis-user] Autogeneration id codes


Good morning to all,



first I would like to thank Bernhard Ströbl, Richard McDonnell, Andrea 
Giudiceandrea and Bernd Vogelgesang for suggestions related to some of my 
previous posts.



Now I have another problem.



I have some tables already created that have a column with autogeneration id 
codes.



>From self-generation I often don't get codes that start from 1 onwards but 
>start with other numbers.



I made some tests and I noticed that if I create a table and add 10 lines the 
autogeneration creates id codes from 1 to 10. If I delete these lines to empty 
the table when I create a new line Qgis autogenerates that with the code 11, it 
seems that Qgis keeps in memory the number/id code of the created elements, and 
keep the numbering as a fixed counter.



How can I impose a autogeneration of id codes starting from 1?



Many many thanks!



Best Regards.



Riccardo.

___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Autogeneration id codes

2023-05-02 Thread Riccardo via QGIS-User 
Good morning to all,


first I would like to thank Bernhard Ströbl, Richard McDonnell, Andrea 
Giudiceandrea and Bernd Vogelgesang for suggestions related to some of my 
previous posts.


Now I have another problem.


I have some tables already created that have a column with autogeneration id 
codes.


>From self-generation I often don’t get codes that start from 1 onwards but 
>start with other numbers.


I made some tests and I noticed that if I create a table and add 10 lines the 
autogeneration creates id codes from 1 to 10. If I delete these lines to empty 
the table when I create a new line Qgis autogenerates that with the code 11, it 
seems that Qgis keeps in memory the number/id code of the created elements, and 
keep the numbering as a fixed counter.


How can I impose a autogeneration of id codes starting from 1?


Many many thanks!


Best Regards.


Riccardo.

___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Fresh install of QGIS Server doesn't work as expected

2023-05-02 Thread B. De Mezzo via QGIS-User 

Hi,

can you check if qgis_mapserv.fcgi is in /usr/lib/cgi-bin/?

Regards.

Le 27/04/2023 à 23:14, Jeremy Garniaux via QGIS-User a écrit :

Hi,

I'm trying to deploy QGIS Server on a Debian 11 VPS.
Following the doc (1)(2), I installed QGIS 3.30. Then I tested the 
install with


> /usr/lib/cgi-bin/qgis_mapserv.fcgi

Here's the output:

> $ /usr/lib/cgi-bin/qgis_mapserv.fcgi
> Application path not initialized
> Application path not initialized
> Application path not initialized
> Application path not initialized
> 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.

> "Loading native module /usr/lib/qgis/server/libdummy.so"
> "Loading native module /usr/lib/qgis/server/liblandingpage.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/libwfs3.so"
> "Loading native module /usr/lib/qgis/server/libwms.so"
> "Loading native module /usr/lib/qgis/server/libwmts.so"
> Content-Length: 0
> Location: http:/index.json
> Server:  QGIS FCGI server - QGIS version 3.30.1-'s-Hertogenbosch
> Status:  302

It's not what I expected after reading the doc but I kept going 
anyway, uploaded my custom QGIS project to the server, set up Apache 
and scrupulously followed the doc. Then I checked the availability of 
QGIS Server with


> 
http://qgis.demo/cgi-bin/qgis_mapserv.fcgi?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetCapabilities


...but got a 404 error.

Any suggestion on what I'm doing wrong?

Thanks for your help.

Best regards,

Jeremy


(1) https://docs.qgis.org/3.28/en/docs/server_manual/getting_started.html
(2) https://qgis.org/en/site/forusers/alldownloads.html



OpenPGP_signature
Description: OpenPGP digital signature
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user