# Logstash Statment Dynamic Parameter

**URL:** <https://discuss.elastic.co/t/logstash-statment-dynamic-parameter/79037>\
**Category:** Logstash\
**Created:** [March 17, 2017, 2:08pm UTC](https://discuss.elastic.co/t/logstash-statment-dynamic-parameter/79037 "2017-03-17T14:08:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yur\_Gasparyan](https://avatars.discourse-cdn.com/v4/letter/y/7c8e57/32.png) [@Yur\_Gasparyan](https://discuss.elastic.co/u/Yur_Gasparyan)\
**Post date:** [March 17, 2017, 2:08pm UTC](https://discuss.elastic.co/t/logstash-statment-dynamic-parameter/79037/1 "2017-03-17T14:08:37Z")

</div>

Hi all. I have tried to connect logstash with mysql and now I am getting error associated with dynamic parameter of statment.

```
jdbc_connection_string => "jdbc:mysql://localhost:3306/mydb"
		jdbc_user => "vuser"
		jdbc_password => "_aerhi64N_"
		jdbc_driver_library => "C:\servers\Elasticsearch\logstash-2.2.2\drivers\mysql-connector-java-5.1.5.jar"
		jdbc_driver_class => "com.mysql.jdbc.Driver"
		statement => "SELECT * FROM :table_name"

```

I want to pass this table\_name parameter via php.

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [March 20, 2017, 6:22am UTC](https://discuss.elastic.co/t/logstash-statment-dynamic-parameter/79037/2 "2017-03-20T06:22:46Z")

</div>

You're starting Logstash from PHP, or what do you mean? If yes, your best bet is probably to generate a file with the SQL statement and pass that file to Logstash via the `statement_filepath` option.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [April 17, 2017, 6:22am UTC](https://discuss.elastic.co/t/logstash-statment-dynamic-parameter/79037/3 "2017-04-17T06:22:53Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.