Highlighted
Respected Contributor.
Respected Contributor.
376 views

Connect to sentinel database

Hi,

we have sentinel 8.2.1 installed on appliance.  Sentinel 8.2.1 uses  postgres 9.5.11. i would need to connect to this database.  Having pgadmin in windows server unable to connect to this database. 

 

is there a way to install pgadmin in appliance and login to the db using pgadmin or is there any other way

 

i could not find rpm  for pgadmin for sles11 sp1.  any help would be appreciated

 

 

 

Regards,

Vidhya.

Labels (2)
0 Likes
6 Replies
Highlighted
Regular Contributor.
Regular Contributor.

Hi

Perhaps the problem is that you din't configure pg_hba for accept external connecttions

I use PGAdmin to get information from tables and I have not problems, provided that I configured postgre to accept incoming connections from IPs other than localhost.

Regards,

0 Likes
Highlighted
Respected Contributor.
Respected Contributor.

Could you please tell me what to change in pg_hba file to accept external connections.


Regards,
Vidhya.
0 Likes
Highlighted
Regular Contributor.
Regular Contributor.

Sure, next monday I will send some example of modifications

Keep in mind that modify databases or tables could cause unrecoverable failures from Sentinel. 

0 Likes
Highlighted
Regular Contributor.
Regular Contributor.

Hi Vidhya,

The procedure below let me connect to database on Sentinel 8.1 over RHEL, Sentinel 8.3 over RHEL and a Sentinel appliance with Suse Linux 12 SP4 and Sentinel 8.3. I hope this help you

You need to do the following sequence of commands and take the specified actions

[root@mysentinel ~]# cd /var/opt/novell/sentinel/3rdparty/postgresql/data

[root@mysentinel ~]# vi pg_hba.conf

in the following file section:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local all all peer map=siemuser
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5

You need to add similar lines:
host    all         all         nnn.nnn.nnn.0/24    	md5
host    all         all         mmm.mmm.mmm.mmm/32        md5
host    all         all         qqq.qqq.qqq.0/24        md5

where 	nnn.nnn.nnn
	mmm.mmm.mmm.mmm
	qqq.qqq.qqq

are the IP address subnets or specifics, from which you can get connected (IP addresses for the machine were you run PGAdmin)


after that you run 

[root@mysentinel ~]# vi postgresql.conf

The following section should be modified as shown below, keeping in file any other modification that you made previously



#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------

# - Connection Settings -

#listen_addresses = 'localhost'         # what IP address(es) to listen on;
                                        # comma-separated list of addresses;
                                        # defaults to 'localhost', '*' = all
                                        # (change requires restart)
listen_addresses = '*'
port = 5432                             # (change requires restart)
max_connections = 100                   # (change requires restart)
# Note:  Increasing max_connections costs ~400 bytes of shared memory per
# connection slot, plus lock space (see max_locks_per_transaction).  You might
# also need to raise shared_buffers to support more connections.
#superuser_reserved_connections = 3     # (change requires restart)
#unix_socket_directory = ''             # (change requires restart)
#unix_socket_group = ''                 # (change requires restart)
#unix_socket_permissions = 0777         # begin with 0 to use octal notation
                                        # (change requires restart)
#bonjour_name = ''                      # defaults to the computer name
                                        # (change requires restart)


Also, probably you need to open the port 5432 TCP in the machine firewall

 

0 Likes
Highlighted
Respected Contributor.
Respected Contributor.

Thankyou so much for the reply.
Running the script as per document let me connect to db from external server.
https://www.netiq.com/documentation/sentinel-74/s74_admin/data/bq8rumc.html
0 Likes
Highlighted
Regular Contributor.
Regular Contributor.

I am glad to have been useful for you

regards

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.