CyberArk | Lost connection to server at 'handshake: reading initial communication packet', system error: 0

buatcobadua's profile image buatcobadua posted 10 months ago in General Permalink

Hi everyone,

I am trying to integrate cyberark solution with HeidiSQL. Cyberark will call the client is via command line. The parameter used are like this:

"C:\Program Files\HeidiSQL\heidisql.exe" -n=postgresql -h="10.10.10.10" -u=username -p=password -P=5432

but once executed, it shows "Lost connection to server at 'handshake: reading initial communication packet', system error: 0"

Does anyone faced this issue before, or any advice will be much appreciated.

Thank you!

ansgar's profile image ansgar posted 10 months ago Permalink

You're using the "-n" argument in a wrong way, which makes HeidiSQL fall back to MySQL. You need the internal ID of PostgreSQL, not the name. You can look up these ids in the help page, here's the both for PostgreSQL:

  • 8 = PostgreSQL (TCP/IP)
  • 9 = PostgreSQL (SSH tunnel)

So "-n=8" would be the way to go.

Please login to leave a reply, or register at first.