2 Replies Latest reply: Feb 19, 2013 10:30 AM by dkeyser
I'm following the steps from another post here:
1. setup IP address(es) that can attach the database:
in /var/lib/pgsql/data/pg_hba.conf add this line:
host all all xx.yy.zz.0/24 trust
where xx.yy.zz.0 is set of IP addresses which will be able to connect the DB, 24 is a subnet mask (adjust it to your needs)
2. enable listening to the addresses:
in /var/lib/pgsql/data/postgresql.conf add this line:
listen_addresses = '*'
3. restart postgresql service
After that the hyper9db database will be accessible from outside. Recommended SQL clients are "HeidiSQL", "SQuirreL SQL", "pgAdmin", etc.
I can't seem to access the directories mentioned above and get access denied. Will chmod allow me to access this and if so what permissions will I need to set. I'm really just trying to look at the database structure so I can better understand the syntax for queries in VMAN.