Metricbeat: Sql Module: Oracle Driver: Sql Query Error :ERROR error opening connection: opening connection: sql: unknown driver "oracle" (forgotten import?)

Elastic Stack Beats
1

I have configured Metricbeat Oracle Module(For Default Metrices/Dashboard ) & I am using Sql Module for customized queries to fetch the data from Oracle DB.

Oracle Module is working perfectly but for Sql module I am getting below error.

metricbeat test modules sql
sql...
query...
error... ERROR error opening connection: opening connection: sql: unknown driver "oracle" (forgotten import?)

2

Which version of Beats are you using? This issue was solved in this PR https://github.com/elastic/beats/pull/17378

As a workaround, you can try using the driver name godror

3

Hello Mario,

Thanks for you reply..!!

I am using metricbeat version 7.7.1
metricbeat version
metricbeat version 7.7.1 (amd64), libbeat 7.7.1 [932b273e8940575e15f10390882be205bad29e1f built 2020-05-28 15:27:59.

By using godror driver I am able to fetch the data from oracle database.

Thanks a lot..!!

4

Hi @Sunil18

Yeah, if I recall correctly, this was fixed for 7.8 if you want to upgrade your Beats. I'm glad that I helped :slightly_smiling_face:

5

Hello Mario,

Yes, Sure I will upgrade it to the latest one.

thanks again

6

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