Announcements

SecurID® Discussions

Browse the SecurID discussion board to get product help and collaborate with other SecurID users.
MikeGercevich
Beginner
Beginner

RSA AM 8.1 connect to PostgreSQL database

Jump to solution

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?

Labels (1)
0 Likes
1 Solution

Accepted Solutions
JayGuillette
Apprised Contributor Apprised Contributor
Apprised Contributor

You need a Read-Only Database user, which also opens up port 7050 in the firewall for remote access to PGSQL

https://community.rsa.com/docs/DOC-45361 

View solution in original post

2 Replies
JayGuillette
Apprised Contributor Apprised Contributor
Apprised Contributor

You need a Read-Only Database user, which also opens up port 7050 in the firewall for remote access to PGSQL

https://community.rsa.com/docs/DOC-45361 

MikeGercevich
Beginner
Beginner

Works perfectly!

Thanks for the quick response!

0 Likes