Describe what you would like us to do:

For case 1, our other apps just do a http datagrepper query...

ie, see https://apps.fedoraproject.org/datagrepper/

For 2, @asaleh has been working on some openshift metrics/datagrepper query dashboards, perhaps we could share those and they might meet your needs.

If not, where would you want this access from?

Hello
dumping existing messages from HTTP requires much more time if to compare psql.

This I can say with 100% confidence.

https://apps.fedoraproject.org/datagrepper/ is super slow, even when I specify start=&end= window.

Just to compare in downstream: https://apps.fedoraproject.org/datagrepper/ -- dumps necessary messages in 2 days, where psql can dump the same messages in 10 min. (please believe me)
+ https://apps.fedoraproject.org/datagrepper/ replies with very high error rate.

Access from from batcave is fine.

The RO user exists and is in ansible. If you can login, you can try

https://monitor-dashboard-web-monitor-dashboard.app.os.fedoraproject.org/explore

as long as you have at least one project on openshift, you should be able to log-in, and the grafana instance running there has the datanommer configured as a datasource.

Ah yeah, would this meet your needs?

:-) hello

I still need some more info.

I can login into:

https://monitor-dashboard-web-monitor-dashboard.app.os.fedoraproject.org/explore

I can see PostgreSQL Connection in Settings.
I have "hostname" and "username" from this dialog.
I cannot see password.

Now I tried to use this, and without success.

batcave01 doesn't have psql installed command

I tried to spin a container: https://quay.io/repository/bitnami/postgresql
on https://console.app.os.fedoraproject.org/

I logged into: oc login --token=<TOKEN> --server=https://os.fedoraproject.org:443

I created a project.

I spinned container:

oc get pods
NAME READY STATUS RESTARTS AGE
command-demo-0 1/1 Running 0 14m

oc rsh command-demo-0
Error from server (BadRequest): Upgrade request required

:-) For me It sounds that I am doing something not right. + password :-)

Sorry, I was not clear.

I meant... does doing queries via the dashboard get you what you need? Or do you have to get raw data for some other purpose?
I didn't mean to spin up other instances or try and use the same user as the dashboard. :)

Hi :-) Is it possible to get list of all known topics from Graphana?
Or dump a raw messages with help of Graphana?
I already know: host name with db, username (that has RO access).
All I need: have psql on batcave01 and password for this user :-) That would be enough.

ok. I guess it's just easier to set you up with psql...

So, I have installed pqsl on batcave01, and put the ro user db password in your home directory in a file called 'db-pass'. Please keep this secret.

Let us know if you need anything further.

I confirm it works:

psql .....

datanommer=> SELECT msg_id from messages LIMIT 1;
                  msg_id                   
-------------------------------------------
 2020-81c09db0-6120-46ad-8695-b0fd63d58392
(1 row)

@kevin thank you!