Why isn't logging working?

Question

I'm trying to log sql events to the ir_logging table. My config is as follows;
log_db = True
log_db_level = warning
log_handler = :INFO
log_level = debug_sql
logfile = /var/log/odoo/odoo-server.log
logrotate = False
I've also tried "info" for the log_db_level parameter and restarted the odoo service before each test. I've created sales orders and performed stock moves, but had zero rows written to the ir_logging table. I can't find this properly documented anywhere. How does it work?

Ray Carnes · Accepted Answer

https://www.odoo.com/documentation/8.0/reference/cmdline.html [1]
--log-db <dbname>
logs to the ir.logging model (ir_logging table) of the specified database. The database can be the name of a database in the "current" PostgreSQL, or a PostgreSQL URI for e.g. log aggregation

[1] https://www.odoo.com/documentation/8.0/reference/cmdline.html

Bole · Answer

also.. try this setting :
log_level  = :DEBUG
will output more log messages...

Michael Scorpio · Answer

@Ray; thanks, the only documentation I could find (http://www.mindissoftware.com/2014/09/07/Odoo-logging-configuration-usage-implementation/) had log_db as True and given that is was originally False in my config, this sounded reasonable. I've changed it to the name of my database, and I'm getting some logging, but not logging of SQL statements. Tried a number of things including setting the log_handler = openerp.sql_db:DEBUG. Still no SQL logging.

相關帖文	回覆	瀏覽次數
Usage Of SQl Queries In odoo sql	1 11月 22	5604
sql constraints aren't being detected in my model sql	1 10月 21	3285
Odoo on microsoft sql server instead postgres sql? sql	2 11月 18	10193
How can I turn off "client logs" ? logging	0 2月 18	3919
Logstash Parser? logging	2 7月 16	7556

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！