Nxlog im_dbi无法正常工作 [英] Nxlog im_dbi is not working
问题描述
我能够使用nxlog（om_dbi）将数据插入PostgreSQL。
I am able to insert data into PostgreSQL using nxlog(om_dbi).
但是我无法使用nxlog从PostgreSQL选择数据（或获取数据）。我尝试了许多选项，但没有任何效果。
But I am not able to select data(or fetch data) from PostgreSQL using nxlog. I tried many options nothing is working.
在IM_DBI模块的nxlog文档中，模块描述也只提到了 FIXME。
And in nxlog document also for IM_DBI module description has only "FIXME" mentioned.
文档链接： http://nxlog.org/ documentation / nxlog-community-edition-reference-manual-v20928＃im_dbi
请帮助我解决这个问题。
Please help me to solve this.
日志：
<Input dbiin>
Module im_dbi
SavePos TRUE
SQL SELECT * FROM NEW_TABLE
Driver pgsql
Option host 127.0.0.1
Option username chitta
Option password ''
Option dbname db
</Input>
2014-10-16 14:29:17 WARNING nxlog-ce received a termination request signal, exiting...
2014-10-16 14:29:18 INFO nxlog-ce-2.8.1248 started
2014-10-16 14:29:18 ERROR im_dbi failed to execute SQL statement. ERROR: column "id" does not exist;LINE 1: SELECT * FROM NEW_TABLE WHERE id = 1;
Note:
the module will automatically prepends a "WHERE id > %d" clause.
推荐答案
没有答案，但是这里有一些帮助。
Not an answer, but here's some help.
缺少最重要的指令：SQL Select ID为id，
DateOccured为EventTime，日志表中的数据
The most important directive is missing: SQL Select ID as id, DateOccured as EventTime, data from logtable
来源： https://www.mail-archive.com/nxlog-ce-users@lists.sourceforge.net/msg00225.html
我目前在同一条船上。我的假设是，您的数据没有以nxlog可以解释的方式格式化。故障排除，如果我能找到解决方法，会尽快与您联系。
I'm currently in the same boat. My assumption is that your data is not formatted in a way that nxlog can interpret. Troubleshooting and will get back to you if I can find a resolution.
还可以挖掘im_dbi模块的源代码。
Also digging through the source code for the im_dbi module.
https://github.com/lamby/pkg-nxlog-ce/blob/master/src/modules/input/dbi/im_dbi.c
这篇关于Nxlog im_dbi无法正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
