- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
RSA AM 8.1 connect to PostgreSQL database
I am trying to establish a connection from a remote server to execute SQL queries against the RSA AM 8.1 SP1 database using the open source ADO.Net provider from Npgsql
I am attempting to open the connection with the following connection string:
"Host=rsaserver.company.com;Port=7050;Database=db;Username=rsa_dba;Password=xxxxxxxxxx;SSL Mode=Require;Trust Server Certificate=True"
On Connection.Open(), I receive the following exception:
"No connection could be made because the target machine actively refused it"
I am able to execute queries over an SSH connection using the identical User/Password with the local rsautil utility. Is there some configuration that needs to be changed to allow the PostgreSQL SQL server to accept connections remotely? Is the rsa_dba account forbidden to connect remotely? I am attempting to mimic the functionality found in the SDK's SQLSample.vbs example script. Has anyone else been able to get this working?
- Tags:
- AM
- Auth Manager
- Authentication Manager
- Community Thread
- Discussion
- Forum Thread
- postgresql
- rsa am 8
- RSA Authentication Manager
- RSA SecurID
- RSA SecurID Access
- SecurID
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You need a Read-Only Database user, which also opens up port 7050 in the firewall for remote access to PGSQL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You need a Read-Only Database user, which also opens up port 7050 in the firewall for remote access to PGSQL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Works perfectly!
Thanks for the quick response!
