I have been using the Devart dbExpress driver for postgres in my Delphi XE2 applications for years, and it has been working very well. But now I'm with a situation that I need to use the sspi method authentication in postgres, in the pg_hba.conf, like this:
# TYPE DATABASE USER ADDRESS METHOD
# IPv4 local connections:
host MYDB APPUSER samenet sspi map=mymap
# IPv6 local connections:
#host all all ::1/128 md5 mymap
host MYDB APPUSER samenet sspi map=mymap
When I try to connect the application with the database, using the dbExpress driver, it gives me the message:
" Cannot connect to database. Unknown auth method"
When I try the connection in the pgAdmin ( postresql client ), it works normally.
Is there a configuration tha I can set in the connection parameters to suport this auth method? Or is there any other way that I can connect the databaset using the devart driver that supports this?
I didn't found anything related in the documentation, so I'm asking for help.
dbExpress driver using sspi method authentication
-
- Posts: 1
- Joined: Fri 28 Jul 2017 11:51
Re: dbExpress driver using sspi method authentication
We have not tested SSPI Authentication for PostgreSQL using our driver. Now we are performing such testing and after its completion we will inform you about the results.
-
- Posts: 1
- Joined: Fri 28 Jul 2017 11:51
Re: dbExpress driver using sspi method authentication
Hi there,
Any news about this topic?
It would be very usefull for me if Devart dbExpress driver for PostgreSQL could work with the SSPI Authentication
Thanks
Any news about this topic?
It would be very usefull for me if Devart dbExpress driver for PostgreSQL could work with the SSPI Authentication
Thanks
Re: dbExpress driver using sspi method authentication
We've detected an issue in our product when using the sspi method authentication, and are currently working to resolve it. We'll update you on the progress.