Problemas con Postgres y phpPgAdmin 4

From: Emilio Capolupo <ecapolup(at)ta(dot)telecom(dot)com(dot)ar>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Problemas con Postgres y phpPgAdmin 4
Date: 2007-01-24 19:39:14
Message-ID: OF5E0FD3F6.592C6A17-ON0325726D.006B30D4-0325726D.006BF6D8@ta.telecom.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Hola:

Tengo una bd Postgres 7.4 e instale phpPgAdmin 4 en el mismo
servidor. Cuando me quiero loguear a la base con cualquier usuario me da
"login failed"... (el mismo usuario entrando con psql funciona bien)

Gracias....

este es mi pg_hba.conf
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD

local all all trust
host all all 127.0.0.1 255.255.255.255 trust
host all all 0.0.0.0 255.255.255.255 trust
host all all 10.68.33.48 255.255.255.0 trust
host all all 10.9.7.98 255.255.255.255 trust

tengo habilitado pg para que reciba consultas TCP/IP

y este es mi config.inc.php

// An example server. Create as many of these as you wish,
// indexed from zero upwards.

// Display name for the server on the login screen
$conf['servers'][0]['desc'] = 'PostgreSQL';

// Hostname or IP address for server. Use '' for UNIX domain
socket.
// use 'localhost' for TCP/IP connection on this computer
$conf['servers'][0]['host'] = 'localhost';

// Database port on server (5432 is the PostgreSQL default)
$conf['servers'][0]['port'] = 5432;

// Database SSL mode
// Possible options: disable, allow, prefer, require
$conf['servers'][0]['sslmode'] = 'allow';

// Change the default database only if you cannot connect to
template1.
// For a PostgreSQL 8.1 server, you need to set this to
'postgres'.
$conf['servers'][0]['defaultdb'] = 'template1';

// Specify the path to the database dump utilities for this
server.
// You can set these to '' if no dumper is available.
$conf['servers'][0]['pg_dump_path'] = '/usr/bin/pg_dump';
$conf['servers'][0]['pg_dumpall_path'] = '/usr/bin/pg_dumpall';

// Slony (www.slony.info) support?
$conf['servers'][0]['slony_support'] = false;
// Specify the path to the Slony SQL scripts (where
slony1_base.sql is located, etc.)
// No trailing slash.
$conf['servers'][0]['slony_sql'] = '/usr/share/pgsql';
$conf['default_lang'] = 'auto';

// AutoComplete uses ajaxy interaction to list FK options on
insert fields
// It currently only works on single column foreign keys. You can
control
// it's behavior with the following settings.
// 'default on' enables AutoComplete and turns it on by default.
// 'default off' enables AutoComplete but turns it off by default.
// 'disable' disables AutoComplete.
$conf['autocomplete'] = 'default on';

// If extra login security is true, then logins via phpPgAdmin
with no
// password or certain usernames (pgsql, postgres, root,
administrator)
// will be denied. Only set this false once you have read the FAQ
and
// understand how to change PostgreSQL's pg_hba.conf to enable
// passworded local connections.
$conf['extra_login_security'] = false;

// Only show owned databases?
// Note: This will simply hide other databases in the list - this
does
// not in any way prevent your users from seeing other database by
// other means. (eg. Run 'SELECT * FROM pg_database' in the SQL
area.)
$conf['owned_only'] = false;

// Display comments on objects? Comments are a good way of
documenting
// a database, but they do take up space in the interface.
$conf['show_comments'] = true;

// Display "advanced" objects? Setting this to true will show
types,
// operators conversions, languages and casts in phpPgAdmin. These
// objects are rarely administered and can clutter the interface.
$conf['show_advanced'] = false;

// Display "system" objects?
$conf['show_system'] = false;

// Display reports feature? For this feature to work, you must
// install the reports database as explained in the INSTALL file.
$conf['show_reports'] = true;

// Only show owned reports?
// Note: This does not prevent people from accessing other reports
by
// other means.
$conf['owned_reports_only'] = false;
// Minimum length users can set their password to.
$conf['min_password_length'] = 1;

// Width of the left frame in pixels (object browser)
$conf['left_width'] = 200;

// Which look & feel theme to use
$conf['theme'] = 'default';

// Show OIDs when browsing tables?
$conf['show_oids'] = false;

// Max rows to show on a page when browsing record sets
$conf['max_rows'] = 30;

// Max chars of each field to display by default in browse mode
$conf['max_chars'] = 50;

// Send XHTML headers? Unless debugging, it's best to leave this
off
$conf['use_xhtml'] = false;

// Base URL for PostgreSQL documentation.
// '%s', if present, will be replaced with the PostgreSQL version
// (7, 7.1, 7.2, 7.3, 7.4, or 8.0)
$conf['help_base'] =
'http://www.postgresql.org/docs/%s/interactive/';

/*****************************************
* Don't modify anything below this line *
*****************************************/

$conf['version'] = 17;

------------------------------------------------------------------------------------------------------------------------------------------

Cuando me quiero loguear a la base con cualquier usuario me da "login
failed"... (el mismo usuario entrando con psql funciona bien)

Gracias....

Emilio Capolupo
Tel: 4968-1965
---------------------------------------------------------------
-Gerencia de Operaciones y Tecnología
- Monitoreo de la Operación

AVISO LEGAL:
Esta información es privada y confidencial y está dirigida únicamente a su destinatario. Si usted no es el destinatario
original de este mensaje y por este medio pudo acceder a dicha información por favor elimine el mensaje. La
distribución o copia de este mensaje está estrictamente prohibida. Esta comunicación es sólo para propósitos de
información y no debe ser considerada como propuesta, aceptación ni como una declaración de voluntad oficial de
TELECOM ARGENTINA S.A. . La transmisión de e-mails no garantiza que el correo electrónico sea seguro o
libre de error. Por consiguiente, no manifestamos que esta información sea completa o precisa. Toda información
está sujeta a alterarse sin previo aviso.
This information is private and confidential and intended for the recipient only. If you are not the intended recipient
of this message you are hereby notified that any review, dissemination, distribution or copying of this message is
strictly prohibited. This communication is for information purposes only and shall not be regarded neither as a
proposal, acceptance nor as a statement of will or official statement from TELECOM ARGENTINA S.A. .
Email transmission cannot be guaranteed to be secure or error-free. Therefore, we do not represent that this
information is complete or accurate and it should not be relied upon as such. All information is subject to change
without notice.

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Eugenio Segura 2007-01-24 19:52:12 Misma tabla ayuda!
Previous Message Leonel Nunez 2007-01-24 19:38:08 Re: Problemas al conectar postgresql