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

    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.