Re: [Geoserver-users] Get stacktrace error in WFS

2020-05-29 Thread Vitor Fonseca 
yes!

using openlayers one could also drop the constraints in postgis and making
those checks with a library like jsts


Vera Green  escreveu no dia quinta, 28/05/2020
à(s) 17:26:

> Hmmm...it's a little bit round about but...
> 1. Front end triggers error
> 2. PG populates table with error
> 3. Code looks up error in PG table ( through GeoServer or directly)
> 4. User is provided error
>
> Theoretically it could work. Also with this method you could "translate"
> common errors to user friendly language in the table automatically.
>
> Vera
>
> On Thu., May 28, 2020, 10:21 a.m. Vitor Fonseca, 
> wrote:
>
>>
>> are you using check constraints or triggers in postgis?
>>
>> maybe you could use a trigger that performs the checks and in case of
>> error sends an email or inserts a record in some table that the developers
>> can poll
>>
>>
>> fibizzo  escreveu no dia quinta, 28/05/2020 à(s)
>> 16:34:
>>
>>> Hello
>>>
>>> This is exactly my concern, the front end developers (using openlayers
>>> btw)
>>> does not have any clue about what exactly happened with the transaction,
>>> specially in this case when I have postgis constraints
>>>
>>>
>>>
>>> --
>>> Sent from:
>>> http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html
>>>
>>>
>>> ___
>>> Geoserver-users mailing list
>>>
>>> Please make sure you read the following two resources before posting to
>>> this list:
>>> - Earning your support instead of buying it, but Ian Turton:
>>> http://www.ianturton.com/talks/foss4g.html#/
>>> - The GeoServer user list posting guidelines:
>>> http://geoserver.org/comm/userlist-guidelines.html
>>>
>>> If you want to request a feature or an improvement, also see this:
>>> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>>>
>>>
>>> Geoserver-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>>
>>
>>
>> --
>>
>> www.vfonsecaz.pt
>>
>> ___
>> Geoserver-users mailing list
>>
>> Please make sure you read the following two resources before posting to
>> this list:
>> - Earning your support instead of buying it, but Ian Turton:
>> http://www.ianturton.com/talks/foss4g.html#/
>> - The GeoServer user list posting guidelines:
>> http://geoserver.org/comm/userlist-guidelines.html
>>
>> If you want to request a feature or an improvement, also see this:
>> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>>
>>
>> Geoserver-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>

-- 

www.vfonsecaz.pt
___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Get stacktrace error in WFS

2020-05-28 Thread Vera Green 
Hmmm...it's a little bit round about but...
1. Front end triggers error
2. PG populates table with error
3. Code looks up error in PG table ( through GeoServer or directly)
4. User is provided error

Theoretically it could work. Also with this method you could "translate"
common errors to user friendly language in the table automatically.

Vera

On Thu., May 28, 2020, 10:21 a.m. Vitor Fonseca, 
wrote:

>
> are you using check constraints or triggers in postgis?
>
> maybe you could use a trigger that performs the checks and in case of
> error sends an email or inserts a record in some table that the developers
> can poll
>
>
> fibizzo  escreveu no dia quinta, 28/05/2020 à(s) 16:34:
>
>> Hello
>>
>> This is exactly my concern, the front end developers (using openlayers
>> btw)
>> does not have any clue about what exactly happened with the transaction,
>> specially in this case when I have postgis constraints
>>
>>
>>
>> --
>> Sent from:
>> http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html
>>
>>
>> ___
>> Geoserver-users mailing list
>>
>> Please make sure you read the following two resources before posting to
>> this list:
>> - Earning your support instead of buying it, but Ian Turton:
>> http://www.ianturton.com/talks/foss4g.html#/
>> - The GeoServer user list posting guidelines:
>> http://geoserver.org/comm/userlist-guidelines.html
>>
>> If you want to request a feature or an improvement, also see this:
>> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>>
>>
>> Geoserver-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>
>
> --
>
> www.vfonsecaz.pt
>
> ___
> Geoserver-users mailing list
>
> Please make sure you read the following two resources before posting to
> this list:
> - Earning your support instead of buying it, but Ian Turton:
> http://www.ianturton.com/talks/foss4g.html#/
> - The GeoServer user list posting guidelines:
> http://geoserver.org/comm/userlist-guidelines.html
>
> If you want to request a feature or an improvement, also see this:
> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>
>
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Get stacktrace error in WFS

2020-05-28 Thread Vitor Fonseca 
are you using check constraints or triggers in postgis?

maybe you could use a trigger that performs the checks and in case of error
sends an email or inserts a record in some table that the developers can
poll


fibizzo  escreveu no dia quinta, 28/05/2020 à(s) 16:34:

> Hello
>
> This is exactly my concern, the front end developers (using openlayers btw)
> does not have any clue about what exactly happened with the transaction,
> specially in this case when I have postgis constraints
>
>
>
> --
> Sent from:
> http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html
>
>
> ___
> Geoserver-users mailing list
>
> Please make sure you read the following two resources before posting to
> this list:
> - Earning your support instead of buying it, but Ian Turton:
> http://www.ianturton.com/talks/foss4g.html#/
> - The GeoServer user list posting guidelines:
> http://geoserver.org/comm/userlist-guidelines.html
>
> If you want to request a feature or an improvement, also see this:
> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>
>
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>


-- 

www.vfonsecaz.pt
___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Get stacktrace error in WFS

2020-05-28 Thread fibizzo 
Hello

This is exactly my concern, the front end developers (using openlayers btw)
does not have any clue about what exactly happened with the transaction,
specially in this case when I have postgis constraints 



--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html


___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Get stacktrace error in WFS

2020-05-28 Thread Vera Green 
Interesting. So it would be possible for the admin to look up the error
later but the front end could not "pass" a meaningful error to the front
end user because the error can't be passed through with the users
authentication programmatically, user would not have access to server
side

I am currently not using wfs but going straight through PHP to postGIS with
my app and this allows me to capture the full error from Postgres.  This
list has suggested wfs is the preferred method however, this is good to
know.

Vera

On Thu., May 28, 2020, 4:45 a.m. Vitor Fonseca,  wrote:

>
> Maybe it would be better to check postgres logs to get that kind of info.
> I don't recall getting any database specific eror messages in geoserver
> log/responses...
>
> Richard Duivenvoorde  escreveu no dia quinta,
> 28/05/2020 à(s) 07:31:
>
>> Hi,
>>
>> If you raise the log file level (via the admin interface
>> Settings/Global/Logging Settings one of the developer or verbose
>> settings will show you queries and responses of the database.
>>
>> You can see the logs on your server, OR in the admin interface in
>> About/Geoserver Logs.
>>
>> Hope this helps,
>>
>> Regards,
>> Richard Duivenvoorde
>> On 5/27/20 9:34 PM, fibizzo wrote:
>> > I have deployed geoserver 2.14.5 in Wildfly 11
>> >
>> > My geoserver layers are connected to a postgres database with postgis;
>> in
>> > postgis I added certain constraints about inserting new records, i.e.
>> two
>> > polygons cannot touch each other/cannot contain another polygon
>> >
>> > In a POST request of inserting or updating, how can I get the constraint
>> > errors? with a WFS insert request, I just get this message:
>> >
>> > http://www.w3.org/2001/XMLSchema;
>> > xmlns:ows="http://www.opengis.net/ows;
>> > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance; version="1.0.0"
>> > xsi:schemaLocation="http://www.opengis.net/ows
>> > http://myserver:8080/geoserver/schemas/ows/1.0.0/owsExceptionReport.xsd
>> ">
>> > 
>> > Update error: Error occured updating
>> > features
>> > 
>> > 
>> >
>> > I can get the entire stacktrace in geoserver and make sure what
>> constraint
>> > was triggered, is there a way to obtain more detail in my response?
>> >
>> >
>> >
>> >
>> > --
>> > Sent from:
>> http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html
>> >
>> >
>> > ___
>> > Geoserver-users mailing list
>> >
>> > Please make sure you read the following two resources before posting to
>> this list:
>> > - Earning your support instead of buying it, but Ian Turton:
>> http://www.ianturton.com/talks/foss4g.html#/
>> > - The GeoServer user list posting guidelines:
>> http://geoserver.org/comm/userlist-guidelines.html
>> >
>> > If you want to request a feature or an improvement, also see this:
>> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>> >
>> >
>> > Geoserver-users@lists.sourceforge.net
>> > https://lists.sourceforge.net/lists/listinfo/geoserver-users
>> >
>>
>>
>>
>> ___
>> Geoserver-users mailing list
>>
>> Please make sure you read the following two resources before posting to
>> this list:
>> - Earning your support instead of buying it, but Ian Turton:
>> http://www.ianturton.com/talks/foss4g.html#/
>> - The GeoServer user list posting guidelines:
>> http://geoserver.org/comm/userlist-guidelines.html
>>
>> If you want to request a feature or an improvement, also see this:
>> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>>
>>
>> Geoserver-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>
>
> --
>
> www.vfonsecaz.pt
>
> ___
> Geoserver-users mailing list
>
> Please make sure you read the following two resources before posting to
> this list:
> - Earning your support instead of buying it, but Ian Turton:
> http://www.ianturton.com/talks/foss4g.html#/
> - The GeoServer user list posting guidelines:
> http://geoserver.org/comm/userlist-guidelines.html
>
> If you want to request a feature or an improvement, also see this:
> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>
>
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this:

Re: [Geoserver-users] Get stacktrace error in WFS

2020-05-28 Thread Vitor Fonseca 
Maybe it would be better to check postgres logs to get that kind of info.
I don't recall getting any database specific eror messages in geoserver
log/responses...

Richard Duivenvoorde  escreveu no dia quinta,
28/05/2020 à(s) 07:31:

> Hi,
>
> If you raise the log file level (via the admin interface
> Settings/Global/Logging Settings one of the developer or verbose
> settings will show you queries and responses of the database.
>
> You can see the logs on your server, OR in the admin interface in
> About/Geoserver Logs.
>
> Hope this helps,
>
> Regards,
> Richard Duivenvoorde
> On 5/27/20 9:34 PM, fibizzo wrote:
> > I have deployed geoserver 2.14.5 in Wildfly 11
> >
> > My geoserver layers are connected to a postgres database with postgis; in
> > postgis I added certain constraints about inserting new records, i.e. two
> > polygons cannot touch each other/cannot contain another polygon
> >
> > In a POST request of inserting or updating, how can I get the constraint
> > errors? with a WFS insert request, I just get this message:
> >
> > http://www.w3.org/2001/XMLSchema;
> > xmlns:ows="http://www.opengis.net/ows;
> > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance; version="1.0.0"
> > xsi:schemaLocation="http://www.opengis.net/ows
> > http://myserver:8080/geoserver/schemas/ows/1.0.0/owsExceptionReport.xsd
> ">
> > 
> > Update error: Error occured updating
> > features
> > 
> > 
> >
> > I can get the entire stacktrace in geoserver and make sure what
> constraint
> > was triggered, is there a way to obtain more detail in my response?
> >
> >
> >
> >
> > --
> > Sent from:
> http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html
> >
> >
> > ___
> > Geoserver-users mailing list
> >
> > Please make sure you read the following two resources before posting to
> this list:
> > - Earning your support instead of buying it, but Ian Turton:
> http://www.ianturton.com/talks/foss4g.html#/
> > - The GeoServer user list posting guidelines:
> http://geoserver.org/comm/userlist-guidelines.html
> >
> > If you want to request a feature or an improvement, also see this:
> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
> >
> >
> > Geoserver-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/geoserver-users
> >
>
>
>
> ___
> Geoserver-users mailing list
>
> Please make sure you read the following two resources before posting to
> this list:
> - Earning your support instead of buying it, but Ian Turton:
> http://www.ianturton.com/talks/foss4g.html#/
> - The GeoServer user list posting guidelines:
> http://geoserver.org/comm/userlist-guidelines.html
>
> If you want to request a feature or an improvement, also see this:
> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>
>
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>


-- 

www.vfonsecaz.pt
___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Get stacktrace error in WFS

2020-05-28 Thread Richard Duivenvoorde 
Hi,

If you raise the log file level (via the admin interface
Settings/Global/Logging Settings one of the developer or verbose
settings will show you queries and responses of the database.

You can see the logs on your server, OR in the admin interface in
About/Geoserver Logs.

Hope this helps,

Regards,
Richard Duivenvoorde
On 5/27/20 9:34 PM, fibizzo wrote:
> I have deployed geoserver 2.14.5 in Wildfly 11
> 
> My geoserver layers are connected to a postgres database with postgis; in
> postgis I added certain constraints about inserting new records, i.e. two
> polygons cannot touch each other/cannot contain another polygon
> 
> In a POST request of inserting or updating, how can I get the constraint
> errors? with a WFS insert request, I just get this message:
> 
> http://www.w3.org/2001/XMLSchema;
> xmlns:ows="http://www.opengis.net/ows;
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance; version="1.0.0"
> xsi:schemaLocation="http://www.opengis.net/ows
> http://myserver:8080/geoserver/schemas/ows/1.0.0/owsExceptionReport.xsd;>
> 
> Update error: Error occured updating
> features
> 
> 
> 
> I can get the entire stacktrace in geoserver and make sure what constraint
> was triggered, is there a way to obtain more detail in my response?
> 
> 
> 
> 
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html
> 
> 
> ___
> Geoserver-users mailing list
> 
> Please make sure you read the following two resources before posting to this 
> list:
> - Earning your support instead of buying it, but Ian Turton: 
> http://www.ianturton.com/talks/foss4g.html#/
> - The GeoServer user list posting guidelines: 
> http://geoserver.org/comm/userlist-guidelines.html
> 
> If you want to request a feature or an improvement, also see this: 
> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
> 
> 
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
> 



___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users