Re: I can't connect to phpPgAdmin

From: "Devi Munandar" <devi(at)informatika(dot)lipi(dot)go(dot)id>
To: <aris_it(at)csahome(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: I can't connect to phpPgAdmin
Date: 2003-03-22 06:53:19
Message-ID: 00f401c2f03f$b93a3240$a6f0cda7@informatika.lipi.go.id
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Than'k Mr.Aris

I''ve tried to set up pg_hba.conf and postgres.conf, and then execution
>psql -h 167.205.240.67 -- that is my IP Address server-- but still get
problem and gei message "could not connect to server : connection refuse,
is the server running on 167.205.240.67 and accepting TCP/IP connections on
port 5432", so what can i do?

pg_hba.conf
********************
.................
..................
TYPE DATABASE USER IP_ADRESS MASK
AUTH_TYPE
local all all 167.205.240.67
255.255.255.0 trust
...................
.................

postgesql.conf
*********************
..........
............
.........
##connections parameter
tcpip_socket=true
max_connection = 32
ssl=true
port=5432
hostname_lookup=false
show_source_port=false
................
............

config.inc.php in phpPgAdmin
************************
/* $Id: config.inc.php-dist,v 1.10 2002/06/04 18:24:50 killroyboy Exp $ */

// Set the name and version
$cfgProgName = "phpPgAdmin";
$cfgVersion = "2.4.2";

// The default database is used to connect to the database to check the
adv_auth
// This can actually be any database you currently have on your system. It
just
// needs _a_ database to connect and check the system tables.
$cfgDefaultDB = "template1";

// You should change the superuser if different from postgres
// This is just used to filter out the system functions when listing
$cfgSuperUser = "postgres";

// If you want to be able to view the contents and structure of the System
Catalog/Tables set this to true.
// If you are new to Postgres or are not familiar with the system tables, it
is suggested you leave this as false
$cfgSysTables = true;

// If you want the web interface to administer postgres user, set this as
true.
$cfgUserAdmin = true;

// If you want to enable reporting
$cfgReports = true;

// If you want to filter the databases to only the ones the user has created
or owns.
// This has no affect if the user is a superuser.
$cfgUserDatabases = true;

// Set this to true during development of phpPgAdmin
$cfgDebug = false;

// If you do NOT want to quote all relations, set this to false
$cfgQuotes = true;

// Maximum pages to display link in browse
$cfgMaxPages = 9;

// If you do not want to display the tables of a database in the left frame,
add it to this array
// This feature is very useful when you have a database that has many tables
and slowes down the load of the left frame.
// $cfgNoTables[] = "big_table";

/******************************** IMPORTANT SECURITY NOTICE
********************************
By default, Postgres does not check passwords through a local connection.
This is
a major security if connecting through a local unix socket with phpPgAdmin.
You
have a few options to close this security hole:
1. You can connect through a TCP connection (use the -i option to start
postgres)
- Set $cfgServers[*]['local'] = false;
- Edit your $PGDATA/pg_hba.conf file to accept connections from localhost
with password authentication
2. Edit your $PGDATA/pg_hba.conf file to use password authentication
through a
local connection.
********************************* IMPORTANT SECURITY NOTICE
*******************************/

// The $cfgServers array starts with $cfgServers[1]. Do not use
$cfgServers[0].
// You can disable a server config entry by setting host to ''.
$cfgServers[1]['local'] = false;
$cfgServers[1]['host'] = 'localhost';
$cfgServers[1]['port'] = '5432';
$cfgServers[1]['adv_auth'] = true;

$cfgServers[1]['user'] = ''; // if you are not using adv_auth, enter the
username to connect all the time
$cfgServers[1]['password'] = ''; // if you are not using adv_auth and a
password is required enter a password
$cfgServers[1]['only_db'] = ''; // if set to a db-name, only this db is
accessible

$cfgServers[2]['local'] = false;
$cfgServers[2]['host'] = '';
$cfgServers[2]['port'] = '5432';
$cfgServers[2]['adv_auth'] = true;

$cfgServers[2]['user'] = ''; // if you are not using adv_auth, enter the
username to connect all the time
$cfgServers[2]['password'] = ''; // if you are not using adv_auth and a
password is required enter a password
$cfgServers[2]['only_db'] = ''; // if set to a db-name, only this db is
accessible

$cfgServers[3]['local'] = false;
$cfgServers[3]['host'] = '';
$cfgServers[3]['port'] = '5432';
$cfgServers[3]['adv_auth'] = true;

$cfgServers[3]['user'] = ''; // if you are not using adv_auth, enter the
username to connect all the time
$cfgServers[3]['password'] = ''; // if you are not using adv_auth and a
password is required enter a password
$cfgServers[3]['only_db'] = ''; // if set to a db-name, only this db is
accessible

// If you have more than one server configured, you can set
$cfgServerDefault
// to any one of them to autoconnect to that server when phpPGAdmin is
started,
// or set it to 0 to be given a list of servers without logging in
// If you have only one server configured, $cfgServerDefault *MUST* be
// set to that server.
$cfgServerDefault = 1; // default server (0 = no default server)
$cfgServer = ''; // the selected server is copied here for easier access
unset($cfgServers[0]); // Since 0 = no server, $cfgServers[0] must not be
used

$cfgManualBase = "http://www.postgresql.org/idocs/index.php";

$cfgConfirm = true;
$cfgPersistentConnections = false;

// If you have a table with several thousands of records, you will want to
set this false.
$cfgCountRecs = true;

// If you want the fields alphabetized when inserting/editing
$cfgDoOrder = false;

$cfgBorder = "0";
$cfgThBgcolor = "#D3DCE3";
$cfgBgcolorOne = "#CCCCCC";
$cfgBgcolorTwo = "#DDDDDD";
$cfgMaxRows = 30;
$cfgMaxInputsize = "300px";
$cfgMaxTextAreaSize = "400px";
$cfgOrder = "ASC";

$cfgShowBlob = false;
$cfgShowSQL = true;

// Set the maximum characters in any given field to diplay in "browse"
mode - 0 is unlimited
$cfgMaxText = 255;

$cfgMember = "#CCCCFF";
$cfgNonMember = "#CCCC99";
$cfgMaxTries = 10;

// Set your language preferences here.
include("english.inc.php");

?>

best regards,

--devi munandar

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message A.Bhuvaneswaran 2003-03-22 07:59:14 Method to avoid deadlock detected
Previous Message Lamar Owen 2003-03-22 03:21:43 Re: Which files does PostgreSQL need from initscripts RPM?