[prev in list] [next in list] [prev in thread] [next in thread]
List: qgis-user
Subject: Re: [Qgis-user] QGIS Server sometimes not sending commits to postgis
From: Aitor Gil Martin <sigeo.agmartin () getxo ! eus>
Date: 2016-01-27 14:50:28
Message-ID: 04AEE41FF41CFC44BA6837497D1327ABA679F4CB () EPOSTAMX1 ! GETXO ! ORG
[Download RAW message or body]
Hi Alessandro,
Thanks for your answer.
I've tried that config but the log file is not generated...
________________________________
De: Alessandro Pasotti [mailto:apasotti@gmail.com]
Enviado el: martes, 26 de enero de 2016 14:30
Para: Aitor Gil Martin
CC: qgis-user
Asunto: Re: [Qgis-user] QGIS Server sometimes not sending commits to postgi=
s
2016-01-26 13:37 GMT+01:00 jaitor <sigeo.agmartin@getxo.eus<mailto:sigeo.ag=
martin@getxo.eus>>:
Hi,
I am running a Windows Server 2012 server.
PostgreSQL 9.3.5, 64-bit
POSTGIS 2.1.3
QGIS Server 2.6.1-2
QGIS Desktop 2.8.3
I am using a Microsoft Surface Pro 4 tablet using QGIS Desktop 2.12 to edit
some layers stored in the Postgresql database. The layers in the tablet are
WFS layers served by QGIS Server.
When I toogle editing after inserting some data in the layer to force the
data to be sent and stored in the server sometimes the commit is not being
done from QGIS Server to the Database.
I can see that the POST http request arrives to the server ok, but sometime=
s
I can't see a commit (update) in the database and some other times it works
ok and does the commit.
I ensure every time that internet connection is fine.
When loading the QGIS project with 50 WFS layers in the tablet (client),
sometimes two or three layers are not read and I need to click in apply
several times until they are read properly and the project finishes
loading.. I don't know if this problem is related to the one I mentioned
before.
The problem that worries me is the first one, because there is people
working in field inserting data the whole day, and when they arrive to thei=
r
office they connect teh tablet to wifi (or even ethernet cable) to ensure
internet is fine and they toogle edition to save changes. As mentioned
before, sometimes data is not stored in postgis but no error is propagated
to QGIS Client, so the user thinks that the data has been stores correctly.
The funny thing is that they have been working for 40 days and hey only got
this problem once, but since last week they have had this problem every
day...
I've been trying to activate QGIS Server logs to see what error it is givin=
g
adding these two lines to D:\OSGeo4W\httpd.d\httpd_qgis.conf
SetEnv QGIS_SERVER_LOG_FILE /var/tmp/qgislog.txt
SetEnv QGIS_SERVER_LOG_LEVEL 0
But no log file is being generated.
If you are using FAST CGI, you can try:
FcgidInitialEnv QGIS_DEBUG 1
FcgidInitialEnv QGIS_SERVER_LOG_FILE /tmp/qgis-000.log
FcgidInitialEnv QGIS_SERVER_LOG_LEVEL 0
Hope this helps.
--
Alessandro Pasotti
w3: www.itopen.it<http://www.itopen.it>
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="GENERATOR" content="MSHTML 11.00.9600.18163">
</head>
<body>
<div dir="ltr" align="left"><span class="041224914-27012016"><font color="#0000ff" \
size="2" face="Arial">Hi Alessandro,</font></span></div> <div dir="ltr" \
align="left"><span class="041224914-27012016"><font color="#0000ff" size="2" \
face="Arial"></font></span> </div> <div dir="ltr" align="left"><span \
class="041224914-27012016"><font color="#0000ff" size="2" face="Arial">Thanks for \
your answer.</font></span></div> <div dir="ltr" align="left"><span \
class="041224914-27012016"><font color="#0000ff" size="2" \
face="Arial"></font></span> </div> <div dir="ltr" align="left"><span \
class="041224914-27012016"><font color="#0000ff" size="2" face="Arial">I've tried \
that config but the log file is not generated...</font></span></div> <br>
<div lang="es" class="OutlookMessageHeader" dir="ltr" align="left">
<hr tabindex="-1">
<font size="2" face="Tahoma"><b>De:</b> Alessandro Pasotti \
[mailto:apasotti@gmail.com] <br>
<b>Enviado el:</b> martes, 26 de enero de 2016 14:30<br>
<b>Para:</b> Aitor Gil Martin<br>
<b>CC:</b> qgis-user<br>
<b>Asunto:</b> Re: [Qgis-user] QGIS Server sometimes not sending commits to \
postgis<br> </font><br>
</div>
<div></div>
<div dir="ltr">
<div class="gmail_extra">
<div class="gmail_quote">2016-01-26 13:37 GMT+01:00 jaitor <span dir="ltr"><<a \
href="mailto:sigeo.agmartin@getxo.eus" \
target="_blank">sigeo.agmartin@getxo.eus</a>></span>:<br> <blockquote \
class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: \
rgb(204,204,204) 1px solid"> Hi,<br>
<br>
I am running a Windows Server 2012 server.<br>
PostgreSQL 9.3.5, 64-bit<br>
POSTGIS 2.1.3<br>
QGIS Server 2.6.1-2<br>
QGIS Desktop 2.8.3<br>
<br>
I am using a Microsoft Surface Pro 4 tablet using QGIS Desktop 2.12 to edit<br>
some layers stored in the Postgresql database. The layers in the tablet are<br>
WFS layers served by QGIS Server.<br>
<br>
When I toogle editing after inserting some data in the layer to force the<br>
data to be sent and stored in the server sometimes the commit is not being<br>
done from QGIS Server to the Database.<br>
<br>
I can see that the POST http request arrives to the server ok, but sometimes<br>
I can't see a commit (update) in the database and some other times it works<br>
ok and does the commit.<br>
<br>
I ensure every time that internet connection is fine.<br>
<br>
When loading the QGIS project with 50 WFS layers in the tablet (client),<br>
sometimes two or three layers are not read and I need to click in apply<br>
several times until they are read properly and the project finishes<br>
loading.. I don't know if this problem is related to the one I mentioned<br>
before.<br>
<br>
The problem that worries me is the first one, because there is people<br>
working in field inserting data the whole day, and when they arrive to their<br>
office they connect teh tablet to wifi (or even ethernet cable) to ensure<br>
internet is fine and they toogle edition to save changes. As mentioned<br>
before, sometimes data is not stored in postgis but no error is propagated<br>
to QGIS Client, so the user thinks that the data has been stores correctly.<br>
<br>
The funny thing is that they have been working for 40 days and hey only got<br>
this problem once, but since last week they have had this problem every<br>
day...<br>
<br>
I've been trying to activate QGIS Server logs to see what error it is giving<br>
adding these two lines to D:\OSGeo4W\httpd.d\httpd_qgis.conf<br>
<br>
SetEnv QGIS_SERVER_LOG_FILE /var/tmp/qgislog.txt<br>
SetEnv QGIS_SERVER_LOG_LEVEL 0<br>
<br>
But no log file is being generated.<br>
</blockquote>
<div><br>
</div>
<div>If you are using FAST CGI, you can try:<br>
<span><br>
FcgidInitialEnv QGIS_DEBUG 1</span><span><br>
FcgidInitialEnv QGIS_SERVER_LOG_FILE /tmp/qgis-000.log</span><span></span><span><br>
FcgidInitialEnv QGIS_SERVER_LOG_LEVEL 0</span><br>
</div>
<div><br clear="all">
</div>
</div>
<br>
</div>
<div class="gmail_extra">Hope this helps.<br>
<br>
</div>
<div class="gmail_extra">-- <br>
<div class="gmail_signature">Alessandro Pasotti<br>
w3: <a href="http://www.itopen.it" \
target="_blank">www.itopen.it</a></div> </div>
</div>
</body>
</html>
[Attachment #4 (unknown)]
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic