IBM Support

GIM client unable to connect to GIM server with "Can't connect to sqlguard server" error

Troubleshooting


Problem

Within the GIM.log, located in the \Guardium Installation Manager\GIM\Current directory of the database server where the GIM client is installed, the following errors are seen:
Can't connect to sqlguard server: Permission denied from gimconnector
send_to_gim_server:: GimConnector returned with error code 1
send_to_gim_server::Processed response:
$VAR1 = {
          'body' => 'Can't connect to sqlguard server: Permission denied
',
          'code' => 400,
          'header' => 'HTTP/1.1 400 HTTP_BAD_REQUEST'

Diagnosing The Problem

These errors indicate a problem with the GIM client connecting to the GIM server on port 8081.
1. Verify on the GIM server that port 8081 is listening by using CLI command "support show port open 127.0.0.1 8081"
2. If port 8081 is listening on the GIM server, verify that a telnet session can be established from the database server to the GIM server on port 8081.
3. If a telnet session can't be established from the database server to the GIM server on port 8081 check any firewalls to verify that port 8081 is open from the database server to the GIM server.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"ARM Category":[{"code":"a8m0z000000Gp0TAAS","label":"GIM"}],"ARM Case Number":"TS004087809","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
21 October 2021

UID

ibm16507381