Amigos, tengo un postgress instalado en debian sarge, pero no me puedo
conectar con el phppgadmin, me dice login incorrecto,
cuando uno un su - postgres , y ejecuto un psql -l me lista la template0
y template1, me acepto crear un usuario, crear una tabla con ese
usuario, pero en el phppgadmin no puedo logear.
Acá les dejo la configuracion del config.inc.php del phppgadmin.
***********************************************
<?php
/**
* Central phpPgAdmin configuration. As a user you may modify the
* settings here for your particular configuration.
*
* $Id: config.inc.php-dist,v 1.44.2.1 2005/11/18 01:47:16
chriskl Exp $
*/
// 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'] = 'localhost';
// 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;
// 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'] = '';
// 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';
// Example for a second server (PostgreSQL for Windows)
//$conf['servers'][1]['desc'] = 'r';
//$conf['servers'][1]['host'] = '127.0.0.1';
//$conf['servers'][1]['port'] = 5432;
//$conf['servers'][1]['defaultdb'] = 'template1';
//$conf['servers'][1]['pg_dump_path'] = 'C:\\Program
Files\\PostgreSQL\\8.0\\bin\\pg_dump.exe';
//$conf['servers'][1]['pg_dumpall_path'] = 'C:\\Program
Files\\PostgreSQL\\8.0\\bin\\pg_dumpall.exe';
//$conf['servers'][1]['slony_support'] = false;
//$conf['servers'][1]['slony_sql'] = 'C:\\Program
Files\\PostgreSQL\\8.0\\share';
// Default language. Eg: 'english', 'polish', etc. See lang/
directory
// for all possibilities. If you specify 'auto' (the default) it
will use
// your browser preference.
$conf['default_lang'] = 'auto';
// 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'] = 0;
// 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'] = 15;
?>
// $conf['servers'][0]['slony_sql'] = '/usr/share/pgsql'; <-- esta
parte la comente por que no encontre el archivo por ninguna parte..
Espero alguien sepa lo que sucede, y me pueda ayudar-.-. y disculpen por
lo largo del mail.
saludos.
--
To UNSUBSCRIBE, email to debian-user-spanish-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org