Unable to launch powa web

[abgarg2022]

powa-web conf has details as below

Extension details of powa database(DBName = ioc )

Running powa wb as below but how to get UI ??

[rjuju]

hi

I'm not sure that I fully understand the problem. have you tried opening the given URL in your browser? it should understand that 0.0.0.0 is your local address.

[abgarg2022]

hi I'm not sure that I fully understand the problem. have you tried opening the given URL in your browser? it should understand that 0.0.0.0 is your local address.

Hi @rjuju , I got postgresql on ubuntu and installed powa also at same place. Can you please guide me with pg_hba.conf setup or something else as URL http://0.0.0.0:8888/ is not yielding anything.

[rjuju]

I got postgresql on ubuntu and installed powa also at same place. Can you please guide me with pg_hba.conf setup or something else as URL http://0.0.0.0:8888/ is not yielding anything.

do you get an error, an empty page or it's just hitting a timeout?

is this Ubuntu your local machine or a vm or some other distant server?

[abgarg2022]

I got postgresql on ubuntu and installed powa also at same place. Can you please guide me with pg_hba.conf setup or something else as URL http://0.0.0.0:8888/ is not yielding anything. do you get an error, an empty page or it's just hitting a timeout? is this Ubuntu your local machine or a vm or some other distant server? …

Yes. ubuntu is VM.

[abgarg2022]

Do I need to add my windows Public IP in Security Group of configured VM and then try this URL again?

[rjuju]

ubuntu is VM.

ah that explains it powa-web is acting as a web server, so you need to configure your server if you want to access it from outside of the vm. one simple way to do that would be to authorize the 8888 tcp port in the vm firewall if any, and use instead the ip of that vm in the URL, still with the 8888 port. you should probably have already done that to accees your postgres server from outside the vm.

[abgarg2022]

@rjuju

To access postgres server, we are using SSH tunnel and private key. How can we access powa UI in such a case?

[rjuju]

To access postgres server, we are using SSH tunnel and private key. How can we access powa UI in such a case?

I'm confused. it means you have to get a shell on the vm to then connect to postgres? how is your application able to connect then? but anyway, it means that you made the SSH port (22) available from outside the vm. you just need to do the exact same thing with the port 8888 and the UI will be available the same as SSH.

[abgarg2022]

Got the UI running now after enabling port 8888, but getting this error now

[rjuju]

Got the UI running now after enabling port 8888

good news!

, but getting this error now

you have a version mismatch between the extension and the UI. how did you install both powa-archivist and powa-web to have different supported versions?

[abgarg2022]

@rjuju

Followed from https://powa.readthedocs.io/en/latest/quickstart.html#id2

Can we connect over Teams Meeting ?

https://teams.microsoft.com/l/meetup-join/19%3ameeting_ODk0MzAxYzQtMGIzZS00YTk1LTg4YTEtNjg0ODE3Y2M0MTRj%40thread.v2/0?context=%7b%22Tid%22%3a%225d471751-9675-428d-917b-70f44f9630b0%22%2c%22Oid%22%3a%2243a98f6c-0805-4dd0-92fa-26663c1cf7ab%22%7d

[rjuju]

It doesn't say which method you used. Since you're using ubuntu, the preferred installation method would be from pgdg repository, and looking at the content right now:

• http://apt.postgresql.org/pub/repos/apt/pool/main/p/powa-archivist/ powa-archivist is in version 4.1.4
• http://apt.postgresql.org/pub/repos/apt/pool/main/p/powa-web/ powa web is in version 4.1.3

So I don't know how you installed powa-web, but you made a mistake somewhere. You need to make sure that you have a version 4.1.x, ideally the latest version which is currently 4.1.3

[abgarg2022]

It doesn't say which method you used. Since you're using ubuntu, the preferred installation method would be from pgdg repository, and looking at the content right now:

• http://apt.postgresql.org/pub/repos/apt/pool/main/p/powa-archivist/ powa-archivist is in version 4.1.4
• http://apt.postgresql.org/pub/repos/apt/pool/main/p/powa-web/ powa web is in version 4.1.3

So I don't know how you installed powa-web, but you made a mistake somewhere. You need to make sure that you have a version 4.1.x, ideally the latest version which is currently 4.1.3

I had used below commands

1. wget https://github.com/powa-team/powa-archivist/archive/REL_4_0_0.tar.gz
2. apt-get install postgresql-12-powa postgresql-12-pg-qualstats postgresql-12-pg-stat-kcache postgresql-12-hypopg

[rjuju]

wget https://github.com/powa-team/powa-archivist/archive/REL_4_0_0.tar.gz apt-get install postgresql-12-powa

So you downloaded powa-archivist 4.0.0 and also installed the latest version of powa-archivist via tha packages?

Given the error you're not using powa-archivist 4.0.0. And it's still lacking any information about powa-web.

[abgarg2022]

wget https://github.com/powa-team/powa-archivist/archive/REL_4_0_0.tar.gz apt-get install postgresql-12-powa

So you downloaded powa-archivist 4.0.0 and also installed the latest version of powa-archivist via tha packages?

Given the error you're not using powa-archivist 4.0.0. And it's still lacking any information about powa-web.

@rjuju

Powa web was installed as per https://powa.readthedocs.io/en/latest/quickstart.html#install-powa-web-anywhere

sudo pip install powa-web

[rjuju]

But on pypi the current version is 4.1.3: https://pypi.org/project/powa-web/

and your installation says it's 4.0.x. It looks like you installed multiple version and you're not using the correct one.

[abgarg2022]

This seems to be available now

[abgarg2022]

@rjuju Hi Julien, how to enable collector so that I can view DB sessions running, TOP 5-10 problem Session IDs and details etc.

[rjuju]

Hi Julien, how to enable collector so that I can view DB sessions running, TOP 5-10 problem Session IDs and details etc.

did you face any problem when installing it? or are you using the local mode rather than the remote mode?

[abgarg2022]

Hi Julien, how to enable collector so that I can view DB sessions running, TOP 5-10 problem Session IDs and details etc. did you face any problem when installing it? or are you using the local mode rather than the remote mode? …

No problem in installation, but need to fix below issues I guess before getting DB Stats?

[rjuju]

I still don't know if you use the remote mode or local mode (see https://powa.readthedocs.io/en/latest/remote_setup.html).

[abgarg2022]

I still don't know if you use the remote mode or local mode (see https://powa.readthedocs.io/en/latest/remote_setup.html).

Since all extensions have been enabled on same Database, so I am using local mode only to gather powa stats.

[rjuju]

If you use the local mode you must use the background worker approach (modifying shared_preload_libraries and restarting as documented for instance at https://powa.readthedocs.io/en/latest/quickstart.html). The powa-collector shouldn't be used.

[abgarg2022]

@rjuju

I have stopped powa collector now as per below.

Metrics still not available

[rjuju]

Graphs are only available after 2 snapshots (you need at least 2 points to draw a line), so maybe you didn't wait long enoug?

Otherwise, maybe you didn't configure properly the extension in shared_preload_libraries.

[abgarg2022]

Below are extensions configured

By when will I be able to see the Session details?

[rjuju]

Have you restarted postgres after configuring shared_preload_libraries? This query should show you what is currently used:

SHOW shared_preload_libraries

How did you configure the powa bgowrker? This query will show it (assuming it has been restarted)

SELECT name, current_setting(name) FROM pg_settings WHERE name LIKE 'powa%';

Is there any errors in the postgres logs?

[abgarg2022]

Below is the output. Let me know in case any log file output needs to be checked?

[rjuju]

Can you confirm that the extensions mentioned at https://github.com/powa-team/powa-web/issues/161#issuecomment-1273092248 are installed in the powa database, not any other one?

Let me know in case any log file output needs to be checked?

Yes, please check for any problem in the postgres logs.

[abgarg2022]

Seems to be working now, Thanks a lot.

[rjuju]

Great! I'm closing this issue. Feel free to reopen it or open a new one if you face other problems.