php connection cannot establish to postgresql on linode
I create Database Clusters postgresql on linode service.
I try to connect database by Navicat it working fine!!
But when I try my web application php it cannot establish a connection.
I already setup 0.0.0.0/0 on access manage .
How can i do?
3 Replies
A post with, essentially, "I did this and it doesn't work" in it is not going to get much response:
What error are you getting?
What log entries are being generated?
A snippet of your code might be helpful.
Post each between the appropriate Markdown marker: a line containing ``` (3 backtick characters…the backtick character is next to the 1 on your keyboard).
-- sw
I download a ca certificate (from database server) then I upload this ca to my php server .
then I add this text to my php postgresql connection string : "sslmode=verify-full sslrootcert=/var/app/current/mcscloudca.crt"
I still get error message :
Warning: pg_connect(): Unable to connect to PostgreSQL server: SSL SYSCALL error: Connection reset by peer FATAL