Notifications
Clear all

[Closed] Carbonio files fails on RHEL


amitchell
(@amitchell)
Joined: 1 month ago
Posts: 12
Topic starter  

I have now twice followed the directions to install the RHEL version, that are located at https://docs.zextras.com/carbonio-ce/html/installation.html and have had only one issue on both installs. When you run the following command: 

PGPASSWORD=DB_ADM_PWD carbonio-files-db-bootstrap carbonio_adm 127.0.0.1

Of course I change the DB_ADM_PWD to the password from my installation.

Here is the error I receive:

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)
psql: error: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "carbonio_adm", database "carbonio_adm", SSL off

The strange thing is I have not experienced an error with any of the other postgres commands.  This error is of course preventing Carbonio files from working properly but  no other services appear to have any issue at all.

I would appreciate assistance in resolving this issue. Thank you.


Md. Shariful Islam
(@shariful-islam)
Admin
Joined: 6 months ago
Posts: 127
 
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


amitchell
(@amitchell)
Joined: 1 month ago
Posts: 12
Topic starter  

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


Md. Shariful Islam
(@shariful-islam)
Admin
Joined: 6 months ago
Posts: 127
 

@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


stefanodavid
(@stefanodavid)
Joined: 1 year ago
Posts: 28
 

@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.


amitchell
(@amitchell)
Joined: 1 month ago
Posts: 12
Topic starter  

@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?


Md. Shariful Islam
(@shariful-islam)
Admin
Joined: 6 months ago
Posts: 127
 

@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


amitchell
(@amitchell)
Joined: 1 month ago
Posts: 12
Topic starter  

@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?


amitchell
(@amitchell)
Joined: 1 month ago
Posts: 12
Topic starter  

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


Md. Shariful Islam
(@shariful-islam)
Admin
Joined: 6 months ago
Posts: 127
 

@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

😊