Client Failed To Authenticate Correctly. Postgres 10.0 Xtuple 4.12-RC

caleb194 · April 16, 2019, 1:46pm

I am attempting to connect to my instance of Xtuple. Running on PostgreSQL 10.6 or 7 whichever is the stable as of 4/16/2019. I have double checked and even changed my password for testing purposes.

My log shows the following.


2019-04-16 08:30:59.942 CDT [10472] FATAL:  password authentication failed for user "admin"
2019-04-16 08:30:59.942 CDT [10472] DETAIL:  Password does not match for user "admin".
	Connection matched pg_hba.conf line 80: "host    all             all             127.0.0.1/32            md5"
2019-04-16 08:30:59.980 CDT [6156] FATAL:  password authentication failed for user "admin"
2019-04-16 08:30:59.980 CDT [6156] DETAIL:  Password does not match for user "admin".
	Connection matched pg_hba.conf line 80: "host    all             all             127.0.0.1/32            md5"
2019-04-16 08:31:00.171 CDT [5688] ERROR:  syntax error at end of input at character 8
2019-04-16 08:31:00.171 CDT [5688] STATEMENT:  LISTEN 
2019-04-16 08:31:03.603 CDT [5688] ERROR:  permission denied for relation measures_sales
2019-04-16 08:31:03.603 CDT [5688] CONTEXT:  SQL statement "REFRESH MATERIALIZED VIEW xtdash.kpi_cust_item_sales_by_month"
	PL/pgSQL function refresh_views(boolean) line 38 at EXECUTE
2019-04-16 08:31:03.603 CDT [5688] STATEMENT:  SELECT xtdash.refresh_views(FALSE );
	SELECT setMetric('DashboardsRefreshing', 'f');
2019-04-16 08:31:06.015 CDT [5688] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

For testing purposes I changed the admin roles password to admin and Have the same results.
I changed my ph_hba.conf to trust from md5 and now I get

2019-04-16 08:44:30.769 CDT [6960] ERROR:  syntax error at end of input at character 8
2019-04-16 08:44:30.769 CDT [6960] STATEMENT:  LISTEN 
2019-04-16 08:44:34.984 CDT [6960] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

davidbeauchamp · April 16, 2019, 1:46pm

Those messages are a red herring, the xTuple application tries a few combinations of SSL on/off, in order to determine what connection parameters to use.

The part that sticks out to me is the ERROR: permission denied for relation measures_sales, are you running the latest package for xtdash? There was a bug fixed a couple versions ago relating to the permissions for the materialized views and this looks like you are running in to it.

caleb194 · April 16, 2019, 2:08pm

I went ahead and updated to the latest version of xtdash. 1.0.4 I was on an older version. I followed along that line and updated all of the packages installed to the most recent versions. now my log looks like this.

2019-04-16 09:06:58.489 CDT [7192] ERROR: syntax error at end of input at character 8 2019-04-16 09:06:58.489 CDT [7192] STATEMENT: LISTEN 2019-04-16 09:07:01.401 CDT [7192] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host.