D
Dawn
Guest
Separate/External phpPgAdmin
Hi,
I wanted to install a separate phpPgAdmin to administrate my (and my customers) pg-db's without loging into Plesk. I did the same thing for phpMyAdmin and it worked without any problems. But with phpPgAdmin I can't connect to my pg.
I saw the administration of pg is a little bit differnt than mysql-administration. In Plesk over "Server > Database servers > Local PostgreSQL server" I can set the name and password of the root-user. I did that. And pg is running.
Then I set up phpPgAdmin on one of my domains. The running pg server is displayed when I access the installation of phpPgAdmin. When I click on it I can enter user and password. I've entered exactly the same user/password I did in the Plesk but I allways get "Login failed" back. I don't know if there is any log for this?!
But here my phpPgAdmin config.inc.php:
Can anybody tell me please what do I need to change that it works?
Greets and best regards,
Dawn
Hi,
I wanted to install a separate phpPgAdmin to administrate my (and my customers) pg-db's without loging into Plesk. I did the same thing for phpMyAdmin and it worked without any problems. But with phpPgAdmin I can't connect to my pg.
I saw the administration of pg is a little bit differnt than mysql-administration. In Plesk over "Server > Database servers > Local PostgreSQL server" I can set the name and password of the root-user. I did that. And pg is running.
Then I set up phpPgAdmin on one of my domains. The running pg server is displayed when I access the installation of phpPgAdmin. When I click on it I can enter user and password. I've entered exactly the same user/password I did in the Plesk but I allways get "Login failed" back. I don't know if there is any log for this?!
But here my phpPgAdmin config.inc.php:
Code:
<?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'] = '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;
// 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 ([url]www.slony.info[/url]) 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'] = 'Test Server';
//$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'] = true;
// 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'] = 15;
?>
Can anybody tell me please what do I need to change that it works?
Greets and best regards,
Dawn