FortiSIEM Discussions
adem_netsys
Contributor

JDBC Error Issue

Hi guys,

 

We made a JDBC connection with a database and we were regularly getting logs from the table, then suddenly the log flow was interrupted and when we test it, we get this error. What could be the problem? 

 

Ekran görüntüsü 2024-03-05 104232.png

3 REPLIES 3
Goutham_FTNT
Staff
Staff

Hi ,

 

So his was working fine and stopped to work all of a sudden ?
Any upgrade done recently on SIEM ?
Version on the SIEM ?
Also any changed done on the server side ?


adem_netsys

Hi @Goutham_FTNT 

 

Suddenly it stopped, and yes, we upgraded the version of our SIEM to 7.1.3

 

Thanks 
 
Goutham_FTNT

Hi @adem_netsys 
Strange that it stopped without any changes on the server or client
Here is the command which you can run from collector (if the pull is via collector) or super to get the complete error :
runJdbcProbe.sh jdbcType hostIP hostPort dbName userName password sqlStat timeout [authType]

Eg:
runJdbcProbe.sh oracle '10.x.x.x' 1521 DNName user pass!2! 'select count(*) from unified_audit_trail;' 120
You can use a relevant table like audit_trail - You can execute this query in the server side to make sure you get a response