Re: Problemas con Postgres y phpPgAdmin 4

Tienes que poner en METHOD md5.

2007/1/24, Emilio Capolupo <ecapolup(at)ta(dot)telecom(dot)com(dot)ar>:
>
>
> 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/<http://www.postgresql.org/docs/%25s/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.
>
>

--
"Comparte lo que sabes, aprende lo que no sepas"
Todo por el conocimiento libre