topic Recurring postgres "qlogs_reader" error on server. in Management & Governance

Recurring postgres "qlogs_reader" error on server.

Anonymous — Wed, 04 Oct 2017 17:29:23 GMT

Hi everyone,

Soooooo...Since we updated from Qlik sense 3.2 to September 2017 release (skipping over June 2017 release) we have been getting a recurring error every hour on the server that hosts QLIK. Has anyone else seen this and van give me some direction? Google literally returned zero matches on the error. (never really seen THAT before). Thanks in advance. The full error text is below.

FATAL: password authentication failed for user "qlogs_reader" DETAIL: Role "qlogs_reader" does not exist. Connection matched pg_hba.conf line 82: "host all all ::1/128 md5"

Re: Recurring postgres "qlogs_reader" error on server.

jaisoni_trp — Mon, 09 Oct 2017 14:58:07 GMT

Did you configure Centralized Logging during the upgrade? If yes, do you see Qlogs database in repository database. If not, you can simple disable logging service on Qlik host or install the database as explained here

https://help.qlik.com/en-US/sense/September2017/Subsystems/PlanningQlikSenseDeployments/Content/Deployment/Qlik-Logging-…

Re: Recurring postgres "qlogs_reader" error on server.

Anonymous — Mon, 09 Oct 2017 16:50:42 GMT

Hi Jai,

First thank you for your reply,

one question (ok maybe two)...

Will disabling the service mean that All logs will cease? We only have the one node at this point so centralized logging is probably not really needed. But I still want to locally log. If I need to keep the service running? Does the qlog reader and qlog writer need to be added to AD? or can they be local user account to the machine?

Thanks for you help

Re: Recurring postgres "qlogs_reader" error on server.

jaisoni_trp — Mon, 09 Oct 2017 16:54:37 GMT

There wont be any harm even if you disable the service since logs will still be available as physical files. With this new concept of Centralized logging logs will be also be moved to repository database. qlog reader and writer are local accounts specific to postgres only and they have nothing to do with AD groups. They will created once you enable Centralized logging.

Re: Recurring postgres "qlogs_reader" error on server.

Anonymous — Tue, 10 Oct 2017 16:20:47 GMT

Thank you.

Re: Recurring postgres "qlogs_reader" error on server.

damian_thomson — Thu, 09 Nov 2017 14:27:10 GMT

Stumbled across this as we are seeing the same issue, we did deploy the centralised logging.

Looking at the URL you listed I can validate the logging service:

C:\Program Files\Qlik\Sense\Logging>qlik.logging.service.exe validate

Successfully validated logging database and schema version.

CentralizedLoggingEnabled: True

LoggingToFileEnabled: True

archive_age_in_days: 30

last_forced_db_trim: 2017-10-17 20:12:24.138551+01

purge_age_in_days: 60

version: 0.1

But still see the twice hourly error in windows event log:

FATAL: password authentication failed for user "qlogs_reader"

DETAIL: Password does not match for user "qlogs_reader".

Connection matched pg_hba.conf line 82: "host all all ::1/128 md5"

Can anyone advise how we update the password for the reading to what we set on the install

Re: Recurring postgres "qlogs_reader" error on server.

piotr_gora — Mon, 20 Nov 2017 08:01:36 GMT

Hello

Any new information about this one? I'm having the exact same issue as you, I think it's not the logging service writing to the log repository but some other processes trying to read from it, but I can not find which one.

Cheers,

Piotr

Re: Recurring postgres "qlogs_reader" error on server.

Anonymous — Mon, 20 Nov 2017 17:55:00 GMT

Here is my latest update....I disabled the logging service, and it is still disabled. I just noticed that it solved the problem for about a day or so and now we are getting the error again, although the error is slightly different

The description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

FATAL: password authentication failed for user "qlogs_reader"

DETAIL: Role "qlogs_reader" does not exist.

Connection matched pg_hba.conf line 82: "host all all ::1/128 md5"

Re: Recurring postgres "qlogs_reader" error on server.

piotr_gora — Tue, 21 Nov 2017 11:33:02 GMT

Hi!

Disabling the logging server did not work for me, I would guess that the logging server uses the role/user qlogswriter, during other work I found that the data connection "QLogs" uses the user/role Qlogs_reader, I think the data connection is used by Operations Monitor app. I checked that my password for Qlogs_reader was correct by connecting to the database using psql

PS C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin> ./psql -p xxxx -U qlogs_reader -d QLogs

Password for user qlogs_reader:

psql (9.6.3)

Type "help" for help.

QLogs=> \dt

List of relations

Schema | Name | Type | Owner

--------+-----------------+-------+--------------

public | archive_entries | table | qlogs_writer

public | log_entries | table | qlogs_writer

public | settings | table | qlogs_writer

(3 rows)

After that I went to the Data connections in QMC, took edit on QLogs and inserted the password for the Qlogs_reader user and applied the changes. For now at least it looks like the error messages have stopped coming. A lot of "I guess" and "I think" but it seems to work...for now.

Re: Recurring postgres "qlogs_reader" error on server.

_armoco_ — Tue, 09 Oct 2018 08:46:52 GMT

Hi,

Exact same issue. Any solutions yet? Can someone help out?

Thanks.

Re: Recurring postgres "qlogs_reader" error on server.

piotr_gora — Fri, 12 Oct 2018 05:56:41 GMT

Maybe try my solution above?

Re: Recurring postgres "qlogs_reader" error on server.

ift_isabelle — Fri, 21 Dec 2018 11:17:31 GMT

I have the same issue, but I cannot see the disable function on the link you shared.

Can you tell me how to disable it?

Thanks in advance,

Isabelle

Re: Recurring postgres "qlogs_reader" error on server.

konidena — Fri, 04 Jan 2019 09:59:20 GMT

Hi Domain_thomson,

How to validate the "C:\Program Files\Qlik\Sense\Logging>qlik.logging.service.exe"
Could you please tell me the process to validate.

Also, we use Qlik.Logging.Service.exe --Update command. Where to use this command .
In help doc, they are saying command line. But I am getting error while using the above command.

Regards
Srinivas