Discussion :

[Drmalcolm]

Bonjour, j'ai un soucis avec phppgadmin, il affiche "login failed", à chaque fois que je tente de me connecter. Pourtant, je peux me connecter avec pgadmin III et le client psql.


Voici mon extrait config.inc.php:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
 
<?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.
        $conf['servers'][0]['host'] = '';
 
        // 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'] = '';
 
        // 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';
 
 
        // Default language for the login screen if there's no translation
        // matching user's browser request. Eg: 'english', 'polish', etc.
        $conf['default_lang'] = 'english';
 
        // 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'] = true;
 
        // 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'] = true;
 
?>

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
 
# Database administrative login by UNIX sockets
local   all         postgres                          ident sameuser
local   all         postgres                          md5
 
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
 
# "local" is for Unix domain socket connections only
local   all         all                               ident sameuser
#local   all        all                                 md5
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
host    all         all         192.168.1.0/24        trust
#host   all         all         192.168.1.0/24          password
# IPv6 local connections:
host    all         all         ::1/128               md5

et de postgresql.conf

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
 
#---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------
 
# - Connection Settings -
 
listen_addresses = '*'  # what IP interface(s) to listen on;
                                # defaults to localhost, '*' = any
port = 5432
max_connections = 100
        # note: increasing max_connections costs about 500 bytes of shared
        # memory per connection slot, in addition to costs from shared_buffers
        # and max_locks_per_transaction.
#superuser_reserved_connections = 2
unix_socket_directory = '/tmp'
#unix_socket_group = ''
#unix_socket_permissions = 0777 # octal
#rendezvous_name = ''           # defaults to the computer name
 
# - Security & Authentication -
 
#authentication_timeout = 60    # 1-600, in seconds
ssl = true
#password_encryption = true
#krb_server_keyfile = ''
#db_user_namespace = false

[peppena]

bonjour
dans le fichier postgresql.conf tu dois verifier que postgres accepte les connections tcp/ip

vérifie que cette instruction n'est pas commentée ou n'est pas à false

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
 
 
# - Connection Settings -
 
tcpip_socket = true

[Drmalcolm]

bonjour
dans le fichier postgresql.conf tu dois verifier que postgres accepte les connections tcp/ip

vérifie que cette instruction n'est pas commentée ou n'est pas à false

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
 
 
# - Connection Settings -
 
tcpip_socket = true

Ca c'est uniquement pour la version 7!
La version 8 et supérieur c'est

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
 
listen_addresses = '*'  # what IP interface(s) to listen on;