Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error - Loading csv filter in configuration file :2017-11-07 16:07:32,943 main ERROR Unable to locate appender "${sys:ls.log.format}_rolling" for logger config "root" #57

Open
sconrod-tester opened this issue Nov 8, 2017 · 0 comments

Comments

@sconrod-tester
Copy link

Error trying to load configuration file to import CSV data via logstash to elasticsearch

  • Version: 5.x most recent GA

  • Operating System: Welcome to Ubuntu 16.04.3 LTS (GNU/Linux 4.4.0-87-generic x86_64)

  • Config File (if you have sensitive info, please remove it):
    input {
    file {
    path => "/opt/sample-data/bitcoin-data/*.csv"
    start_position => "beginning"
    sincedb_path => "/dev/null"
    }
    }
    filter {
    csv {
    separator => ","
    #Date,Open,High,Low,Close,Volume (BTC),Volume (Currency),Weighted Price
    columns => ["Date","Open","High","Low","Close","Volume (BTC)", "Volume (Currency)" ,"Weighted Price"]
    user => "logstash_internal"
    password => "XXXXXXX"
    }
    }
    output {
    elasticsearch {
    hosts => "http://localhost:9200"
    index => "bitcoin-prices"
    user => "logstash_internal"
    password => "XXXXXXX"
    }
    stdout {}
    }

  • Sample Data:

  • Steps to Reproduce:
    bin/logstash -f /etc/logstash/conf.d/bitcoin-data.conf -t

My CSF file is sample data downloaded from here:
https://qbox.io/blog/import-csv-elasticsearch-logstash-sincedb

root@ubuntu-16:/usr/share/logstash# bin/logstash -f /etc/logstash/conf.d/bitcoin-data.conf -t
2017-11-07 16:07:32,943 main ERROR Unable to locate appender "${sys:ls.log.format}_rolling" for logger config "root"
WARNING: Could not find logstash.yml which is typically located in $LS_HOME/config or /etc/logstash. You can specify the path using --path.settings. Continuing using the defaults
Could not find log4j2 configuration at path /usr/share/logstash/config/log4j2.properties. Using default config which logs errors to the console

root@ubuntu-16:/usr/share/logstash# ls -la /etc/logstash/
conf.d/ jvm.options log4j2.properties logstash.yml .logstash.yml.swp startup.options
root@ubuntu-16:/usr/share/logstash# ls -la /etc/logstash/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant