2 Replies Latest reply: Feb 19, 2013 10:30 AM by dkeyser RSS

access denied when trying to access postgreDB config files

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
/etc/init.d/postgresql restart

 

After that the hyper9db database will be accessible from outside. Recommended SQL clients are "HeidiSQL", "SQuirreL SQL", "pgAdmin", etc.

 

DB credentials

username: h9pgsu

Password: <blank>

 

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.