Thanks to DR Roger Nevell from my Colleague (Deadalus) for the suggestion to Run the IE in Compatibility Mode. I have added our server ip to the Compatibility View in IE and it resolved the issue

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

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 for your advice

Hi On further checking, i am able to found the below C code to get the %ZNODENAME. Is there any equivalent Cache class to get this. Ideally, uname -n is the unix command, for which equivalent Cache class is required

#include <sys/utsname.h>

int get_nodename(STRING)
char *STRING;
{
        struct utsname name;

        uname(&name);
        strcpy(STRING, name.nodename);
        return(0);
}

There is no such routine available in the application. We are using HP-UX. It looks like it return the Servername. 

Excellent. Many Thanks

Many Thanks for your command. It works fine. Looks it will not work in Cache 2008 and it will work only in Cache 2015