PowerBI or access from outside to DB

Infos:

  • Used Zammad version: 4.0.x
  • Used Zammad installation type: package
  • Operating system: Centos7
  • Browser + version: Chrome 101

Expected behavior:

Zammad uses websocket, so I cant connect from outside to the DB (to analize data)

Actual behavior:

DB is Blocked from a outside localhost

Steps to reproduce the behavior:

Try to connect to postgresql from Outside, you can’t

I broke, zammad trying to enable this, I have it back again and working, but I was playing around with “ALL ALL 0.0.0.0/32 md5” config in nginx, setting postgres password…
a thousands of things just to try to connect to DB, even broke zammad the weekend, was 1 day and a half trying to fix it… was awful.

How can I access to DB from another SQL Client? Exactly. Powerbi?

No offense - but: If you don’t know on how to adjust your postgresqls security configuration you probably shouldn’t do it. Database access and authentication is a very security critical topic, you’ll never want an open database server in the wild.

There’s a lot tutorials on how to open up your database server but again, I’m not sure if you really are ready for that. This is out of scope of Zammad sorry.

1 Like