- Joined
- Nov 28, 2012
- Messages
- 2
- Reaction score
- 0
Hello,
using 3CX v11, i need to connect to DB PostgreSql with 3rd party app.
3CX server: WIn7 64bit, firewall down, uac disabled, no antivirus
I red several posts about this topic and i applied the following changes to C:\Program Files\3CX PhoneSystem\Data\DB
FILE pg_hba.conf
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 password
host all logsreader 0.0.0.0/32 password
# IPv6 local connections:
host all all ::1/128 password
FILE posgresql.conf
listen_addresses = '*'
At this point, PostgreSql DB should listen on 5480, on the whole lan.
THE PROBLEM:
Anyway, connecting with pgAdmin from a lan client (no localhost) i get:
"Access to Database Denied"
indicating that there is no valid entry in pg_ba.conf .
If i use pgAdmin from localhost (3CX server) i get an athentication error.
I took a look at file pg_auth :
"logsreader" "md5xxx" ""
"phoneadmin" "" ""
"phonesystem" "md5xxx" ""
3 users, among them "logsreader", indicated as the user to employ, to connect from the lan.
I see that passwords are md5 coded, but in pg_hba.conf i specified a "password" encoding. I did follow this article
http://apetec.com/voip/3CX-RemoteDB.htm
I try to connect on port 5480 (cheked in postgresql.conf) with ssl Disable .
Can anyone help?
Thanks a lot.
using 3CX v11, i need to connect to DB PostgreSql with 3rd party app.
3CX server: WIn7 64bit, firewall down, uac disabled, no antivirus
I red several posts about this topic and i applied the following changes to C:\Program Files\3CX PhoneSystem\Data\DB
FILE pg_hba.conf
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 password
host all logsreader 0.0.0.0/32 password
# IPv6 local connections:
host all all ::1/128 password
FILE posgresql.conf
listen_addresses = '*'
At this point, PostgreSql DB should listen on 5480, on the whole lan.
THE PROBLEM:
Anyway, connecting with pgAdmin from a lan client (no localhost) i get:
"Access to Database Denied"
indicating that there is no valid entry in pg_ba.conf .
If i use pgAdmin from localhost (3CX server) i get an athentication error.
I took a look at file pg_auth :
"logsreader" "md5xxx" ""
"phoneadmin" "" ""
"phonesystem" "md5xxx" ""
3 users, among them "logsreader", indicated as the user to employ, to connect from the lan.
I see that passwords are md5 coded, but in pg_hba.conf i specified a "password" encoding. I did follow this article
http://apetec.com/voip/3CX-RemoteDB.htm
I try to connect on port 5480 (cheked in postgresql.conf) with ssl Disable .
Can anyone help?
Thanks a lot.