Connecting to RHEV-History database Remotely
Hi All,
Is there any guide to connect to rhevm_history database remotely? Since, we need to enable some configuration in postgresql db. Administration guide doesnot talk about all these procedures. Also, is it recommended to connect to the rhevm_history db remotely? So that other applications/tools can connect to the db.
Regards,
Vijay
Responses
That would require a change to the PostgeSQL hba.conf, to allow remote connections, as well as iptables on RHEV-M I suppose. Let me see if there is a better way
Usually allowing remote connection involves below steps.
cd /var/lib/pgsql/data
# vi postgresql.conf
listen_addresses = '*'
# vi pg_hba.conf
host all all 10.65.192.208/23 md5
# service postgresql restart
Configure firewall to allow connection to port 5432
Readonly connection is ok, but please take care for them to be non resource intensive.
It is not recommended to access the database directly. Instead, use the interfaces provided by the reporting engine, I think http://jasperforge.org/uploads/publish//jasperreportswebsite/JR%20Website/jasperreports_tutorial.html should do the trick, but I haven't tried it myself yet.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
