Junior Spellweaver
- Joined
- Aug 6, 2015
- Messages
- 105
- Reaction score
- 0
can we set this up in other linux distro like debian?
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
probably yes. in ubuntu 14.04 runs fine
After following everything on the first post and reading most pages within this thread
im stuck with navicat not connecting to the database
a, ip is pingable
b, winscp / secureCRT - connect without an issue at all
I've changed the ips for postgresql multiple times and just cannot connect i currently have it now set to accept all ips and it still will not connect to the database
any help would be great
I think your issue is with the listening IP for postgres...
- Open /var/lib/pgsql/{your-version}/data/postgresql.conf
- Look for line listen_addresses, uncomment it and set it to *, or replace it with listen_addresses = '*'
Try to check if the database is listening in the correct ip/port, a simple netstat -an should answer that for you
tcp 0 0 :::5432 :::* LIST
I think your issue is with the listening IP for postgres...
- Open /var/lib/pgsql/{your-version}/data/postgresql.conf
- Look for line listen_addresses, uncomment it and set it to *, or replace it with listen_addresses = '*'
on centos 6.* -> service iptables stop
on centos 7.* -> systemctl firewalld (or firewall idr) stop
then try connect to postgre
" FATAL: no pg_hba.conf entry for host "192.168.0.101" user postgres database template1
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 192.168.0.108/32 ident
# IPv6 local connections:
host all all ::1/128 ident
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local replication postgres peer
#host replication postgres 127.0.0.1/32 ident
#host replication postgres ::1/128 ident
changetoCode:# IPv4 local connections: host all all 192.168.0.108/32 ident
Code:# IPv4 local connections: host all all 0.0.0.0/0 md5
in pg_hba.conf then restart your postgresql