|
|
|
|
|
|
|
[Original]
[Print]
[Top]
|
Client emailed...
Here is the request:
Being able to login wih SSH, I could see that I don't have access to PostgreSQL configuration files. The thing is that we need remote access to the database. We need to access the database remotely so that we can see all the tables and fields from inside our local development environment. This remote access is being configured through the setup of a local Data Source Name, using PostgreSQL ODBC driver, but the following error message is being issued:
Data Link Error
Test Connection failed because of provider initialization error.
Could not connect to the server;
Could not connect to remote socket.
I know we should configure PostgreSQL configuration files for remote access (pg_hba.conf), but logging in with SSH I could see that I don't seem to have access to this file. Could you setup this permission for us? (since for the time I have a fixed IP address, you could even restrict DB access to my IP address only!).
I can see PHP is now configured for accessing both MySQL as well as PostgreSQL (at first it was configured only for MySQL). But now I receive the following error message issued from the PHP page which tries to access the database:
Warning: pg_pconnect(): Unable to connect to PostgreSQL server: could not connect to server: Connection refused Is the server running on host localhost and accepting TCP/IP connections on port 5432? in /home/fwintern/public_html/db_pgsql.php on line 72
Database error: Link-ID == false, pconnect failed
PostgreSQL Error: 0 ()
Session halted.
Normally this would indicate that the Postmaster is not running, or most probably that PostgreSQL was started without accepting TCP/IP connections.
What exactly should I do? I am a little concerned about enabling remote access here but is there a way around this without full remote access? Are there security concerns to allow remote access? I have APF firewall installed on this particular server. Also, if necessary HOW would I enable remote access?
|
|
|
[Original]
[Print]
[Top]
|
|
|
The content of this page is collected from Linux Forum, All copyrights and other associated rights are reserved by the original authors of the articles.