# \[logstash.config.source.multilocal\] Ignoring the 'pipelines.yml' file because modules or command line options are specified **URL:** \ **Category:** Logstash\ **Created:** [December 3, 2019, 1:05pm UTC](https://discuss.elastic.co/t/logstash-config-source-multilocal-ignoring-the-pipelines-yml-file-because-modules-or-command-line-options-are-specified/210343 "2019-12-03T13:05:33Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![sampath1](https://avatars.discourse-cdn.com/v4/letter/s/e480ec/32.png) [@sampath1](https://discuss.elastic.co/u/sampath1)\ **Post date:** [December 3, 2019, 1:05pm UTC](https://discuss.elastic.co/t/logstash-config-source-multilocal-ignoring-the-pipelines-yml-file-because-modules-or-command-line-options-are-specified/210343/1 "2019-12-03T13:05:33Z")
Hi, I am facing an issue. can anyone help me out this. config.code: input { jdbc { jdbc\_connection\_string =\> "jdbc:mysql://192.168.10.111:3306/MTv5" # The user we wish to execute our statement as jdbc\_user =\> "readuser" jdbc\_password =\> "es\_pass" jdbc\_password\_filepath =\> "C:\logstash-6.7.0\config" # The path to our downloaded jdbc driver jdbc\_driver\_library =\> "C:\logstash-6.7.0\bin\mysql-connector-java-8.0.13.jar" jdbc\_driver\_class =\> "com.mysql.jdbc.Driver" # our query statement =\> "Select \* from MTv5.University\_Details" } } output { stdout { codec =\> json\_lines } elasticsearch { "hosts" =\> "localhost:9200" "index" =\> "variable" } } C:\logstash-6.7.0\bin\>logstash -f validation.conf Sending Logstash logs to C:/logstash-6.7.0/logs which is now configured via log4j2.properties [2019-12-03T18:28:03,153][WARN][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified [2019-12-03T18:28:03,171][INFO][logstash.runner] Starting Logstash {"logstash.version"=\>"6.7.0"} [2019-12-03T18:28:09,721][INFO][logstash.pipeline] Starting pipeline {:pipeline\_id=\>"main", "pipeline.workers"=\>4, "pipeline.batch.size"=\>125, "pipeline.batch.delay"=\>50} [2019-12-03T18:28:10,138][INFO][logstash.outputs.elasticsearch] Elasticsearch pool URLs updated {:changes=\>{:removed=\>, :added=\>[[http://localhost:9200/](http://localhost:9200/)]}} [2019-12-03T18:28:10,331][WARN][logstash.outputs.elasticsearch] Restored connection to ES instance {:url=\>"[http://localhost:9200/](http://localhost:9200/)"} [2019-12-03T18:28:10,393][INFO][logstash.outputs.elasticsearch] ES Output version determined {:es\_version=\>6} [2019-12-03T18:28:10,399][WARN][logstash.outputs.elasticsearch] Detected a 6.x and above cluster: the `type` event field won't be used to determine the document \_type {:es\_version=\>6} [2019-12-03T18:28:10,436][INFO][logstash.outputs.elasticsearch] New Elasticsearch output {:class=\>"LogStash::Outputs::ElasticSearch", :hosts=\>["[//localhost:9200](https://localhost:9200)"]} [2019-12-03T18:28:10,449][INFO][logstash.outputs.elasticsearch] Using default mapping template [2019-12-03T18:28:10,481][INFO][logstash.outputs.elasticsearch] Attempting to install template {:manage\_template=\>{"template"=\>"logstash-_", "version"=\>60001, "settings"=\>{"index.refresh\_interval"=\>"5s"}, "mappings"=\>{"default"=\>{"dynamic\_templates"=\>[{"message\_field"=\>{"path\_match"=\>"message", "match\_mapping\_type"=\>"string", "mapping"=\>{"type"=\>"text", "norms"=\>false}}}, {"string\_fields"=\>{"match"=\>"_", "match\_mapping\_type"=\>"string", "mapping"=\>{"type"=\>"text", "norms"=\>false, "fields"=\>{"keyword"=\>{"type"=\>"keyword", "ignore\_above"=\>256}}}}}], "properties"=\>{"@timestamp"=\>{"type"=\>"date"}, "@version"=\>{"type"=\>"keyword"}, "geoip"=\>{"dynamic"=\>true, "properties"=\>{"ip"=\>{"type"=\>"ip"}, "location"=\>{"type"=\>"geo\_point"}, "latitude"=\>{"type"=\>"half\_float"}, "longitude"=\>{"type"=\>"half\_float"}}}}}}}} [2019-12-03T18:28:10,759][ERROR][logstash.pipeline] Error registering plugin {:pipeline\_id=\>"main", :plugin=\>"\"readuser", jdbc\_password\_filepath=\>"C:\\logstash-6.7.0\\config", jdbc\_password=\>, statement=\>"Select \* from MTv5.University\_Details", jdbc\_driver\_library=\>"C:\\logstash-6.7.0\\bin\\mysql-connector-java-8.0.13.jar", jdbc\_connection\_string=\>"jdbc:mysql://192.168.10.111:3306/MTv5", id=\>"c7150c965f5e9f25f94c2a7488b611e151ff4cf74b66258d89e75dad8faee6e3", jdbc\_driver\_class=\>"com.mysql.jdbc.Driver", enable\_metric=\>true, codec=\>\"plain\_952cc36e-34de-4856-9fc7-cf437c597b4a", enable\_metric=\>true, charset=\>"UTF-8"\>, jdbc\_paging\_enabled=\>false, jdbc\_page\_size=\>100000, jdbc\_validate\_connection=\>false, jdbc\_validation\_timeout=\>3600, jdbc\_pool\_timeout=\>5, sql\_log\_level=\>"info", connection\_retry\_attempts=\>1, connection\_retry\_attempts\_wait\_time=\>0.5, last\_run\_metadata\_path=\>"C:\\Users\\Sampath/.logstash\_jdbc\_last\_run", use\_column\_value=\>false, tracking\_column\_type=\>"numeric", clean\_run=\>false, record\_last\_run=\>true, lowercase\_column\_names=\>true\>", :error=\>"Only one of :jdbc\_password, :jdbc\_password\_filepath may be set at a time.", :thread=\>"#\"} [2019-12-03T18:28:11,452][ERROR][logstash.pipeline] Pipeline aborted due to error {:pipeline\_id=\>"main", :exception=\>#\, :backtrace=\>["C:/logstash-6.7.0/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.13/lib/logstash/inputs/jdbc.rb:228:in `register'", "C:/logstash-6.7.0/logstash-core/lib/logstash/pipeline.rb:259:in `register\_plugin'", "C:/logstash-6.7.0/logstash-core/lib/logstash/pipeline.rb:270:in `block in register_plugins'", "org/jruby/RubyArray.java:1792:in `each'", "C:/logstash-6.7.0/logstash-core/lib/logstash/pipeline.rb:270:in `register_plugins'", "C:/logstash-6.7.0/logstash-core/lib/logstash/pipeline.rb:413:in `start\_inputs'", "C:/logstash-6.7.0/logstash-core/lib/logstash/pipeline.rb:311:in `start_workers'", "C:/logstash-6.7.0/logstash-core/lib/logstash/pipeline.rb:217:in `run'", "C:/logstash-6.7.0/logstash-core/lib/logstash/pipeline.rb:176:in `block in start'"], :thread=\>"#\"} [2019-12-03T18:28:11,483][ERROR][logstash.agent] Failed to execute action {:id=\>:main, :action\_type=\>LogStash::ConvergeResult::FailedAction, :message=\>"Could not execute action: PipelineAction::Create, action\_result: false", :backtrace=\>nil} [2019-12-03T18:28:11,867][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600} ---
**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\ **Post date:** [December 3, 2019, 1:11pm UTC](https://discuss.elastic.co/t/logstash-config-source-multilocal-ignoring-the-pipelines-yml-file-because-modules-or-command-line-options-are-specified/210343/2 "2019-12-03T13:11:36Z")
> [@sampath1](#): > > LogStash::ConfigurationError: Only one of :jdbc\_password, :jdbc\_password\_filepath may be set at a time. What is unclear about that error message? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [December 31, 2019, 1:25pm UTC](https://discuss.elastic.co/t/logstash-config-source-multilocal-ignoring-the-pipelines-yml-file-because-modules-or-command-line-options-are-specified/210343/3 "2019-12-31T13:25:06Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.