search

powa-team / powa-web

PoWA user interface
http://powa.readthedocs.io/
73 stars 31 forks source link

POWA configuration page displays Collector status for this instance: stopped #126

Closed HerbertKoelman closed 3 years ago

HerbertKoelman commented 3 years ago

Hello,

This is my first setup of POWA and I failed to understand why the server's config page is displaying Collector status for this instance: stopped.

I have installed what I thought was missing : powa-collector.py. But I have taylored the configutation file and when I run the command, it's returning 

$ powa-collector.py
2021-01-21 16:40:31,574 - INFO  : Starting powa-collector...
2021-01-21 16:40:31,577 - ERROR : Error connecting:
fe_sendauth: no password supplied

I have setup the database and added the extension in it. The database I want to monitor is run on the same postgresql instance.

I'm running

powa-conf.zip

Any suggestion ?

banlex73 commented 3 years ago

Hello in powa-collector.conf you are missing a password { "repository": { "dsn": "postgresql://powa:@localhost:5432/powa" }, "debug": false }

чт, 21 січ. 2021 о 08:00 Herbert Koelman notifications@github.com пише:

Hello,

This is my first setup of POWA and I failed to understand why the server's config page is displaying Collector status for this instance: stopped.

I have installed what I thought was missing : powa-collector.py. But I have taylored the configutation file and when I run the command, it's returning

$ powa-collector.py 2021-01-21 16:40:31,574 - INFO : Starting powa-collector... 2021-01-21 16:40:31,577 - ERROR : Error connecting: fe_sendauth: no password supplied

I have setup the database and added the extension in it. The database I want to monitor is run on the same postgresql instance.

I'm running

  • RedHat 7
  • Postgres 12
  • powa-collector.noarch 1.1.0-1.rhel7 @pgdg-common
  • powa_12.x86_64 4.1.2-1.rhel7 @pgdg12
  • powa_12-web.x86_64 4.1.2-1.rhel7 @pgdg12

powa-conf.zip https://github.com/powa-team/powa-web/files/5850473/powa-conf.zip

Any suggestion ?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/powa-team/powa-web/issues/126, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIHWEYCHGLJ73ESXW6VCS3DS3BFQLANCNFSM4WNDJXKA .

rjuju commented 3 years ago

Hi,

Indeed, as @banlex73 mentioned you can add a password in the dsn, but also use a .pgpass file or other authentication methods.

But maybe you don't need the collector at all. You have 2 ways to use powa: in "standalone" mode (as documented in https://powa.readthedocs.io/en/latest/quickstart.html), where the data collection is done by a background worker. This is the original mode, and requires a restart to activate powa.

The other and new mode is the "remote" mode (as documented in https://powa.readthedocs.io/en/latest/remote_setup.html), where no background worker (and therefore no restart) is needed, and can be used on standby nodes too. But obviously you'll have extra configuration step and another service to monitor.