Re: I can't connect to phpPgAdmin - Mailing list pgsql-admin

From Devi Munandar
Subject Re: I can't connect to phpPgAdmin
Date
Msg-id 00f401c2f03f$b93a3240$a6f0cda7@informatika.lipi.go.id
Whole thread Raw
In response to Re: I can't connect to phpPgAdmin  (aris_it@csahome.com)
Responses Re: I can't connect to phpPgAdmin
List 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


pgsql-admin by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Which files does PostgreSQL need from initscripts RPM?
Next
From: "A.Bhuvaneswaran"
Date:
Subject: Method to avoid deadlock detected