# Sequel\_opts to pass securityMechanism as a parmeter to jdbc

**URL:** <https://discuss.elastic.co/t/sequel-opts-to-pass-securitymechanism-as-a-parmeter-to-jdbc/41539>\
**Category:** Logstash\
**Created:** [February 11, 2016, 6:11pm UTC](https://discuss.elastic.co/t/sequel-opts-to-pass-securitymechanism-as-a-parmeter-to-jdbc/41539 "2016-02-11T18:11:40Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![kirankumarchava](https://avatars.discourse-cdn.com/v4/letter/k/73ab20/32.png) [@kirankumarchava](https://discuss.elastic.co/u/kirankumarchava)\
**Post date:** [February 11, 2016, 6:11pm UTC](https://discuss.elastic.co/t/sequel-opts-to-pass-securitymechanism-as-a-parmeter-to-jdbc/41539/1 "2016-02-11T18:11:40Z")

</div>

how can we pass the property securityMechanism using the sequel\_opts in logstash configuration. I tried sequel\_opts =\> {"securityMechanism" =\> "7"} but no use.

Equivalent to

pOpts.put("securityMechanism", sMech);  
Connection pCxn = DriverManager.getConnection(sURL, pOpts);

---

<div class="post-metadata">

**Author:** ![wiibaa](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wiibaa/32/44931_2.png) [@wiibaa](https://discuss.elastic.co/u/wiibaa)\
**Post date:** [February 12, 2016, 5:20am UTC](https://discuss.elastic.co/t/sequel-opts-to-pass-securitymechanism-as-a-parmeter-to-jdbc/41539/2 "2016-02-12T05:20:29Z")

</div>

Hello,

I do not see this options listed under [https://github.com/jeremyevans/sequel/blob/master/doc/opening\_databases.rdoc](https://github.com/jeremyevans/sequel/blob/master/doc/opening_databases.rdoc)

Which database vendor are you using ?  
Did you try to set it directly in the JDBC url, maybe it is the correct way to do it as in this example [http://docs.oracle.com/javadb/10.8.3.0/ref/rrefattribsecmech.html](http://docs.oracle.com/javadb/10.8.3.0/ref/rrefattribsecmech.html)

---

<div class="post-metadata">

**Author:** ![kirankumarchava](https://avatars.discourse-cdn.com/v4/letter/k/73ab20/32.png) [@kirankumarchava](https://discuss.elastic.co/u/kirankumarchava)\
**Post date:** [February 12, 2016, 3:14pm UTC](https://discuss.elastic.co/t/sequel-opts-to-pass-securitymechanism-as-a-parmeter-to-jdbc/41539/3 "2016-02-12T15:14:37Z")

</div>

I tried setting it up in the URL but it says  
Java::ComIbmDb2JccAm::SqlSyntaxErrorException: [jcc][10165][10036][4.15.120] Invalid database URL syntax ERRORCODE=-4461, SQLSTATE=42815

I am trying to connect to DB2 database.

---

<div class="post-metadata">

**Author:** ![wiibaa](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wiibaa/32/44931_2.png) [@wiibaa](https://discuss.elastic.co/u/wiibaa)\
**Post date:** [February 13, 2016, 7:29am UTC](https://discuss.elastic.co/t/sequel-opts-to-pass-securitymechanism-as-a-parmeter-to-jdbc/41539/4 "2016-02-13T07:29:50Z")

</div>

Ok DB2.  
So indeed this can only be set as a property =\> [https://www-01.ibm.com/support/knowledgecenter/SSEPGG\_9.5.0/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc\_cjvjcsec.html](https://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.5.0/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc_cjvjcsec.html)

I did not find much about this in sequel documentation, so I took a look in the github repository and found a reference to positioning such option into the jdbc\_properties. Can you please try to set it as such

```
input {
  jdbc {
    [...]
    sequel_opts => {
      jdbc_properties => {"securityMechanism" => "7"}
    }
  }
}

```

HTH

---

<div class="post-metadata">

**Author:** ![kirankumarchava](https://avatars.discourse-cdn.com/v4/letter/k/73ab20/32.png) [@kirankumarchava](https://discuss.elastic.co/u/kirankumarchava)\
**Post date:** [February 13, 2016, 4:47pm UTC](https://discuss.elastic.co/t/sequel-opts-to-pass-securitymechanism-as-a-parmeter-to-jdbc/41539/5 "2016-02-13T16:47:25Z")

</div>

jdbc\_properties is not a valid option for logstash jdbc plugin.

---

<div class="post-metadata">

**Author:** ![wiibaa](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wiibaa/32/44931_2.png) [@wiibaa](https://discuss.elastic.co/u/wiibaa)\
**Post date:** [February 13, 2016, 5:30pm UTC](https://discuss.elastic.co/t/sequel-opts-to-pass-securitymechanism-as-a-parmeter-to-jdbc/41539/6 "2016-02-13T17:30:17Z")

</div>

Please read carefully, You need to put jdbc\_properties **inside** the sequel\_opts

---

<div class="post-metadata">

**Author:** ![kirankumarchava](https://avatars.discourse-cdn.com/v4/letter/k/73ab20/32.png) [@kirankumarchava](https://discuss.elastic.co/u/kirankumarchava)\
**Post date:** [February 13, 2016, 5:41pm UTC](https://discuss.elastic.co/t/sequel-opts-to-pass-securitymechanism-as-a-parmeter-to-jdbc/41539/7 "2016-02-13T17:41:18Z")

</div>

It did work indeed.. with sequel\_opts Thanks a lot. Have been trying this for a while...

---

<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:** [July 6, 2017, 5:11am UTC](https://discuss.elastic.co/t/sequel-opts-to-pass-securitymechanism-as-a-parmeter-to-jdbc/41539/8 "2017-07-06T05:11:41Z")

</div>