[Pywps-dev] Deactivate sqlalchemy logging

[Sylvain Beorchia]

No.

Seems like my pywps.cfg is ignored. I checked my all drive, i've got only
one pywps.cfg. You can see it there :

https://friendpaste.com/26jVmZ4v26KAzEP0ptyZ6i

I haven't changed lots of things, and somes settings are incorrect (for
exemple : serveraddress=http://localhost/cgi-bin/wps). I use my wps server
 with wsgi, configured via apache.
Is it possible that other settings cause a bad reading of the logging
section ?





2016-12-23 23:08 GMT+01:00 Jáchym Čepický <jachym.cepicky at gmail.com>:

> So
>
> try 'WARNING'
>
> did it help?
>
> J
>
> Dne 23.12.2016 v 23:06 Sylvain Beorchia napsal(a):
>
> Hi Jachym,
>>
>> Mmm not sure to well understand.
>> According to the doc, level=INFO is the default.
>> In dblog.py, we have :
>>
>> ...
>> level = configuration.get_config_value('logging', 'level')
>> if level in ['INFO']:
>>     echo = False
>> try:
>>     engine = sqlalchemy.create_engine(database, echo=echo)
>> ...
>>
>> If we set level = INFO (which is default), log shouldn't be activated. I
>> don't understand.
>> Anyway, i've tried the force the setting to INFO:
>>
>> [logging]
>> level=INFO
>>
>>  and no luck. I still have got lots of logs.
>>
>>
>> I'm going to try to debug that.
>>
>> Sylvain.
>>
>>
>>
>> 2016-12-23 16:53 GMT+01:00 Jáchym Čepický <jachym.cepicky at gmail.com>:
>>
>> Hi,
>>>
>>> sorry for later response
>>>
>>> in PyWPS configuration file, you can set log level to anything but INFO -
>>> in that case, in dblog.py
>>>
>>> 172   engine = sqlalchemy.create_engine(database, echo=echo_level)
>>>
>>> echo_level will be set to False
>>>
>>> See
>>>
>>> http://pywps.readthedocs.io/en/latest/configuration.html#logging
>>>
>>> for how to set this in configuration file
>>>
>>> Is that ok?
>>>
>>> Jachym
>>>
>>> Dne 16.12.2016 v 09:41 Sylvain Beorchia napsal(a):
>>>
>>> Hi all,
>>>>
>>>> Using my firsts pywps processes, i've got plenty of unwanted logs.
>>>> Here's
>>>> an extract :
>>>>
>>>> ...
>>>> [Fri Dec 16 09:34:36.637934 2016] [:error] [pid 27598]
>>>> INFO:sqlalchemy.engine.base.Engine:
>>>> [Fri Dec 16 09:34:36.637937 2016] [:error] [pid 27598] CREATE TABLE
>>>> pywps_stored_requests (
>>>> [Fri Dec 16 09:34:36.637938 2016] [:error] [pid 27598] \tuuid
>>>> VARCHAR(255)
>>>> NOT NULL,
>>>> [Fri Dec 16 09:34:36.637940 2016] [:error] [pid 27598] \trequest BLOB
>>>> NOT
>>>> NULL,
>>>> [Fri Dec 16 09:34:36.637942 2016] [:error] [pid 27598] \tPRIMARY KEY
>>>> (uuid)
>>>> [Fri Dec 16 09:34:36.637944 2016] [:error] [pid 27598] )
>>>> [Fri Dec 16 09:34:36.637946 2016] [:error] [pid 27598]
>>>> [Fri Dec 16 09:34:36.637947 2016] [:error] [pid 27598]
>>>> [Fri Dec 16 09:34:36.637998 2016] [:error] [pid 27598] 2016-12-16
>>>> 09:34:36,637 INFO sqlalchemy.engine.base.Engine ()
>>>> [Fri Dec 16 09:34:36.638017 2016] [:error] [pid 27598]
>>>> INFO:sqlalchemy.engine.base.Engine:()
>>>> [Fri Dec 16 09:34:36.638229 2016] [:error] [pid 27598] 2016
>>>> ...
>>>>
>>>> I tried to deactivate the logging by doing :
>>>>
>>>> logging.basicConfig()
>>>> logging.getLogger('sqlalchemy.engine').setLevel(logging.WARNING)
>>>>
>>>> in my wsgi file, but does no work.
>>>>
>>>> Am i missing something ?
>>>>
>>>> Thank you.
>>>>
>>>> Sylvain.
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> pywps-dev mailing list
>>>> pywps-dev at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/pywps-dev
>>>>
>>>>
>>>> --
>>> Jachym Cepicky
>>> e-mail: jachym.cepicky at gmail.com
>>> twitter: @jachymc
>>>
>>>
>>
> --
> Jachym Cepicky
> e-mail: jachym.cepicky at gmail.com
> twitter: @jachymc
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pywps-dev/attachments/20161223/ffcfe347/attachment.html>