Connect to OTRS Appliance DB via PHP using SSH

[zyousafi]

I am trying to create a dashboard in PHP that is based on the data in OTRS. Unfortunately the dashboards available in OTRS, out of the box, just aren't that appealing. I have created my desired report via SQL; however I cannot get PHP to connect to the OTRS Appliance DB. I have tried using ssh2_connect, shell_exec, and exec; however I just can't connect to the DB. Can anyone help me with this? Is there some permission I need to set in OTRS that allows PHP to talk to the DB?

[crythias]

Don't use the appliance for production.

[zyousafi]

The appliance has now been in production for several months. It's on its own server in the datacenter and it has been performing extremely well. Is there anyway to connect to it the way I am looking to connect?

[crythias]

Is there anyway to connect to it the way I am looking to connect?

is the php connection on the OTRS appliance or on another box?
Is PGSQL provisioned to allow IP connectivity from the PHP box to the OTRS box?
Is there a firewall/iptables preventing connection?

Note that you're asking for assistance from a non-OTRS specific reason (Yes, we understand it's OTRS data and it's on the appliance, but the request is about connectivity to a PGSQL database from [remote?] PHP, not what happens *in OTRS* after that occurs.)

[zyousafi]

The PHP application is on another server. Is there an IP restriction in OTRS that doesn't allow external connections via PHP or other third-party applications? Meaning OTRS only allows the localhost to connect to the DB. Maybe there is a setting I need to update or something. There's no firewall that's preventing the connection.

Yes I know this is not really an OTRS question but it was OTRS-related so I thought I would run it by the forum and see if anyone had the same experience and/or issue.

[crythias]

Start https://www.google.com/search?q=pgsql+c ... +listen+ip here and see if there's a config you can use on PGSQL to adjust.