SSPI Support

[KingDanx]

I'm seeking support for connecting to my postgres database via SSPI. I've spent hours trying to find a solution to work with my application and I'm hopeful I do not have to abandon the code and start over in another programing language with postgres SSPI authentication support.

pg_hba.conf example:

My Go database connection example

psqlConnString := fmt.Sprintf("host=%s port=%d dbname='%s' sslmode=disable", d.host, d.port, d.dbname)
database, err := sql.Open("postgres", psqlConnString)
if err != nil {
  fmt.Println(err)
  return err
}

err = database.Ping()
if err != nil {
  return err
}

Returned error :

Error connecting to the database: pq: unknown authentication response: 9

Thank you for viewing my issue. If you need anymore information from me please let me know. Any support or suggestions will be greatly appreciated.

[KingDanx]

I have found a temporary solution to this by using github.com/alexbrainman/odbc

I had to change my connection string:

I also had to change how some of my returned values were being processed. Previous values that were returned as int64 are now being returned as int32 and previous Boolean values are now being returned as strings "1" or "0":

Hopefully this information is helpful to anyone else seeking SSPI authentication within their Go application.

[arp242]

There is basically zero chance I will work on this, so if you want this you'll have to send a PR.

The first step would be to make the CI run for Windows. I couldn't really get it to work due to some Windows firewall thing or something. I don't know – not really familiar with Windows. There's some commented out bits in the workflow file.