Probleme mit Postgresql

MySQL, PostgreSQL, SQLite
dragon001
Posts: 28
Joined: 2004-01-03 15:37

Probleme mit Postgresql

Post by dragon001 » 2005-03-16 20:30

Hallo hab folgendes Problem:

verwende PGSQL in der Version7.3 (standart suse version zum testen, falls es sich für mich lohnt update ich auf die aktuelle Version).
So nun mein Problem:

PgSQL startet sauber und ohne Macken.
Ich kann mich halt nur nicht anmelden über phppgadmin.
Bin fast am Verzweifeln.
hier ein auszu aus der postgres log file


LOG: redo record is at 0/807A8C; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 491; next oid: 16977
LOG: database system is ready
FATAL: IDENT authentication failed for user "postgres"
LOG: fast shutdown request
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2005-03-16 20:23:45 CET
LOG: checkpoint record is at 0/807ACC
LOG: redo record is at 0/807ACC; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 494; next oid: 16977
FATAL: The database system is starting up
LOG: database system is ready


kann mit diesen Fehlermeldungen leider nichts anfangen.
Hof mal das hilft fürs erste weiter.

MFG
dragon001

captaincrunch
Userprojekt
Userprojekt
Posts: 7225
Joined: 2002-10-09 14:30
Location: Dorsten

Re: Probleme mit Postgresql

Post by captaincrunch » 2005-03-17 10:14

Die Timestamps wären hier noch interessant. Der Fehler liegt wohl hier:

FATAL: IDENT authentication failed for user "postgres"

Wie sieht deine pg_hba.conf und die Konfiguration deines phppgadmin aus?
DebianHowTo
echo "[q]sa[ln0=aln256%Pln256/snlbx]sb729901041524823122snlbxq"|dc

dragon001
Posts: 28
Joined: 2004-01-03 15:37

Re: Probleme mit Postgresql

Post by dragon001 » 2005-03-17 12:21

die pg_gba.conf sieht so aus:

# Using sockets credentials for improved security. Not available everywhere,
# but works on Linux, *BSD (and probably some others)
# TYPE DATABASE USER IP-ADDRESS
local all all ident sameuser
domain.tld all all xx.xx.xx.xx(ipaddresse des Servers)

pgsqladmin configuration
<?php

/**
* Central phpPgAdmin configuration. As a user you may modify the
* settings here for your particular configuration.
*
* $Id: config.inc.php-dist,v 1.35.2.2 2005/02/11 11:23:39 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 Server';

// Hostname or IP address for server. Use '' for UNIX domain socket.
$conf['servers'][0]['host'] = xx.xxx.xxx.xx';

// 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
$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';

// 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';

// Default language for the login screen if there's no translation
// matching user's browser request. Eg: 'english', 'polish', etc.
$conf['default_lang'] = 'german';

// 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;

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

$conf['version'] = 13;

?>

So hof mal ihr könnt mir weiterhelfen.

MFG
dragon001

outofbound
Posts: 470
Joined: 2002-05-14 13:02
Location: Karlsruhe City

Re: Probleme mit Postgresql

Post by outofbound » 2005-03-18 11:43

Darf der User, den du verwendest auch von der IP aus zugreifen, die du im Configfile angegeben hast?

Willst du die DB wirklich von aussen zugänglich haben?

Gruss,

Out

dragon001
Posts: 28
Joined: 2004-01-03 15:37

Re: Probleme mit Postgresql

Post by dragon001 » 2005-03-20 13:23

Ich möchte halt pgsql verwalten können wie bei mysql (==> ähnlich rootuser) und diese auch verwenden via php und perl.
Hab in der Config selbst die ip des servers angegeben, da er ja als client auf sich selbst zugreift.