Authentication Manager 8.1 - Access to Internal DB

[AndreaSaldamarc]

Hi,

I'm trying to access with a DBClient in a RSA Authentication Manager 8.1 Database, but I can't find the following connection parametrers:

- Database port;

- SID;

- Database UserID;

- Database UserPassword.

During the installation I have not changed a default value of parameters and I tried to look (the above mentioned connection parameters) in "AdministrationGuide", but without success

Thanks

[HusseinElBaz]

Hello Andrea,

Please the following KBA 000027335 - Connecting to or querying the RSA Authentication Manager 8.1 database using pgSQL as it addresses all of your queries.

So kindly check and advise us back if there is any assistance needed from our side.

Best Regards,

[AndreaSaldamarc]

Unfortunately I cannot access at "AM Developer'sGuide" documents.

Can you kindly tell me what kind of database (Oracle, MySQL, SLQ server) is installed to RSA AM8.1 appliance?

Thanks

Andrea Saldamarco

[HusseinElBaz]

Hello Andrea,

The type of database used in Authentication Manager 8.1 is PostgreSQL 9.2.4.

So kindly check and advise us back if there is any assistance needed from our side.

Best Regards,

[KevinDouglas]

It's a PostGres database. You don't need the developers guide. 

Step 1 in the KB gives the instruction for creating a Read-Only user.

Step 2 gives a command for querying the database

Database Port is 7050 and the identifier is db

UserName and Password is what you make in Step 1 of the KB.

[AndreaSaldamarc]

Hi,

i'm tryinig to connect in AM DB with a DBClient without success

Can you tell me about the problem?

Thanks

[AndreaSaldamarc]

Hi,

i'm tryinig to connect in AM DB with a DBClient without success

Can you tell me about the problem?

Thanks

[KevinDouglas]

Were you successful with the rsautil command to create a Read_only UserID?    The screen grab does not show a UserName and what is the error when you try to connect.

[AndreaSaldamarc]

Hi Kevin,

I do not think that the error is due to the fact that I have not created a Read_only UserID because I have only tried a ping server.

Anyway can you kindly explain how I can create a Read_only UserID?

Thanks for collaboration

AS

[MartinPiroh]

Hi Kevin,

cd /opt/rsa/am/utils
./rsautil manage-readonly-dbusers -a create -o ocadmin -u rouser -i <IP address where SSH is enabled>
Enter Operations Console (OC) password: <enter Operations Console admin user name> - In this step you mention to enter OC password, but in <> you state to enter OP admin user name? is this correct?
Enter password for the read-only database user: <enter password for the read-only user>
Confirm password for the read-only database user: <confirm password for the read-only user>
Executing action: 'create'
Trusted Root SSL CA certificate was copied in file '/opt/rsa/am/utils/RSAAMTrustedRootSSLCA.crt'.
'create' action complete.

Is there any more detailed description of how this step should be executed? Should this all be done within go? I'm not very familiar with how to execute command in postgreSQL.

Thank you