Sqlite shipper config settings
Description
Gliffy Diagrams
Activity
Show:

Philippe Weber May 16, 2014 at 10:50 AM
As noted on top of sqllite documentation
This is most useful in cases where you are logging directly to a table.
Any tables being watched must have an 'id' column that is monotonically
increasing.
If still an issue for you, can you please register a ticket into the logstash-contrib repository where this plugin has moved since 1.4.x:
https://github.com/elasticsearch/logstash-contrib/issues

Karan Singh October 24, 2013 at 6:47 AM
Hi,
Is there anyway i could get some information or another plugin being in place of this ?
Somehow not getting much out of it.
Hi,
I am struggling in setting up my logstash agent shipper configuration. I have the source file of *.sqlite extension where fetch information from one of the tables with rows and columns listed.
however as per the sqlite plugin documentation (http://logstash.net/docs/1.2.1/inputs/sqlite).
Can we have an option to write a sqlite query to fetch the information from that .sqlite file mentioned under path.
My Example configuration:
input {
file {
type => "syslog"
path => ["/var/log/*.log", "/var/log/syslog"]
exclude => ["*.gz", "shipper.log"]
sincedb_path => "/var/cache/logstash/.sincedb"
}
sqlite {
add_field => {}
batch => 5
codec => "plain"
debug => true
path => "/root/.mozilla/firefox/default_profile/places.sqlite"
exclude_tables => []
}
}
output {
stdout { }
redis {
host => "x.x.x.x" ## My Logstash collector
data_type => "list"
key => "logstash"
------------------------------------------------
Using the same i get an error message in my shipper's log file which is..
{:timestamp=>"2013-10-22T12:01:47.172000+0530", :message=>"A plugin had an unrecoverable error. Will restart this plugin.\n Plugin: <LogStash::Inputs::Sqlite path=>\"/root/.mozilla/firefox/profile.default/places.sqlite\">\n Error: Java::JavaSql::SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: id)", :level=>:error}
--------------------------------------------------
Could you please let me know what can go wrong...