[Closed] Carbonio files fails on RHEL

Posted by: @amitchell

Database: 127.0.0.1:5432 user carbonio_adm Check postgres connection: psql: FATAL ERROR (exit code 2). (see EXIT STATUS section in psql man documentation)

@amitchell

Hi,

Sorry to hear about the issue.

Please allow some time to check and get back to you.

Meanwhile, could you please tell us what kind of subscription your RHEL OS has?
developer/professional ?

Thanks for your patience.

Regards,
Sharif

Thank you for the reply. I am using Centos 8 with developer subscription.

@amitchell 

Hi,

Can you please share the output of this command:

grep host /var/lib/pgsql/12/data/pg_hba.conf

Thanks and regards,

Sharif

@amitchell we do not support officially CentOS as operating system on which to install Carbonio, so it is possible that you need to make some specific adjustment to the installation procedure.

@shariful-islam I have pasted the output here you requested to this message below:

[root@cmail ~]# grep host /var/lib/pgsql/12/data/pg_hba.conf
# This file controls: which hosts are allowed to connect, how clients
# host          DATABASE  USER  ADDRESS  METHOD  [OPTIONS]
# hostssl       DATABASE  USER  ADDRESS  METHOD  [OPTIONS]
# hostnossl     DATABASE  USER  ADDRESS  METHOD  [OPTIONS]
# hostgssenc    DATABASE  USER  ADDRESS  METHOD  [OPTIONS]
# hostnogssenc  DATABASE  USER  ADDRESS  METHOD  [OPTIONS]
# socket, "host" is either a plain or SSL-encrypted TCP/IP socket,
# "hostssl" is an SSL-encrypted TCP/IP socket, and "hostnossl" is a
# non-SSL TCP/IP socket.  Similarly, "hostgssenc" uses a
# GSSAPI-encrypted TCP/IP socket, while "hostnogssenc" uses a
# ADDRESS specifies the set of hosts the record matches.  It can be a
# host name, or it is made up of an IP address and a CIDR mask that is
# specifies the number of significant bits in the mask.  A host name
# that starts with a dot (.) matches a suffix of the actual host name.
# columns to specify the set of hosts.  Instead of a CIDR-address, you
# can write "samehost" to match any of the server's own IP addresses,
# "host" records.  In that case you will also need to make PostgreSQL
# host    all             all             127.0.0.1/32            ident
# host    all             all             127.0.0.1/32            
host    all             all             ::1/128                 ident
# Allow replication connections from localhost, by a user with the
host    replication     all             127.0.0.1/32            ident
host    replication     all             ::1/128                 ident

Your request for this information does remind me of a question I had when reading the documentation and conducting the install. A change to /var/lib/pgsql/12/data/pg_hba.conf is documented in the prerequisites section. However in the example we are told to look for a line that is commented out and edit it to another line that is commented out. As shown by the '#'. Was this a misunderstanding on my part?

@amitchell 

Hi,

Yes. You got it right this time.

To, avoid any confusion let me share an image. Modify your file accordingly and reload the postgresql-12

systemctl reload postgresql-12

Thanks,

Sharif

@shariful-islam Thank you for the help. Unfortunately, even tho I am a registered user of the forum, I am not allowed to download the screenshot you sent. Perhaps you can show or tell me what changes I need to make, please?

@shariful-islam Thank you for your help. I was able to resolve the error. 

@amitchell

Hi,

Sorry, you got trouble downloading the image.

But we are glad you have been able to resolve the issue.

Thank you so much for being with us.

Thanks,

Sharif

😊