Hi Kevin,
Thanks for looking into this. I am using Character version of logstash. I am running the below command from Windows Command Prompt
D:\EKL\Conf>logstash -f cachesql.conf
content of cachesql.conf is below
input {
jdbc {
clean_run => true
jdbc_driver_library => "D://EKL//logstash-7.7.0//JDK17//cache-jdbc-2.0.0.jar"
jdbc_driver_class => "com.intersys.jdbc.CacheDriver"
jdbc_connection_string => "jdbc:Cache://130.78.88.54:1972/PC61T"
jdbc_user => "dialup"
jdbc_password => "Banbury1"
schedule => "* * * * *"
statement => "SELECT * FROM AEADOCTOR "
}
}
output {
elasticsearch {
hosts => ["localhost:9200"]
index => "cachesql"
}
stdout { codec => rubydebug }
}
Produced the below error
[2020-06-01T21:46:00,204][ERROR][logstash.inputs.jdbc ][main][4a64f0663ba619
5668b7646c5df76a994f06d2a1987af2f0cfd9e6d43b7ff5f8] Unable to connect to databas
e. Tried 1 times {:error_message=>"Java::JavaSql::SQLException: No suitable driv
er found for jdbc:Cache://130.78.88.54:1972/PC61T"}
Java Version used
C:\Windows\system32>java -version
openjdk version "14" 2020-03-17
OpenJDK Runtime Environment AdoptOpenJDK (build 14+36)
OpenJDK 64-Bit Server VM AdoptOpenJDK (build 14+36, mixed mode, sharing)
Many Thanks
Regards,
Sadagopan TS
Hi Eduard Lebedyuk ,
Thanks for your quick response, i have given the correct Ipadress and portnumber(1972) where the CacheDB is installed.
I have copied the .jar files into path where the logstash application is installed, also i tried with double slash as below, but no luck.
jdbc_driver_library => "D://EKL//logstash-7.7.0//JDK18//cache-jdbc-2.0.0.jar"
Regarding using iFind, we have other applications used ELK (Elasticsearch,Logstash,Kibana) for their logs, we would like to provide a generic solution which uses ELK
Anything else can i try ?
Thanks & Regards,
Sadagopan TS
Many Thanks Kevin, i am jumping in joy. I just copied the .jar file into the logstash Install Directory , Jars file folder it worked.
Thanks a ton for your help