Discussion :

[_matt_44]

J'ai une base de données que j'ai crée qui s'appelle netmap avec les tables associés a l'interieur.
Une interface graphique php + cgi.

Et deux fichiers intermediaire qui serve a faire la liaison entre ma base et l'interface appellé db.conf et netmap.conf.

Cependant quand je suis sur mon site les modifications que j'effectue ne sont pas prise en compte.

je vous met en code leur contenu :

************************************db.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
 
<?php
/*
        Sample configuration file for the web interface.
        Only the databasename and the user/pass are defined
        here. Everything else is done using the admin web
        interface.
 
        * IT IS MANDATORY NOT TO ADD ANY EMPTY LINES BEFORE AND
        * AFTER THE php MARKS
 
        Just change the koko to the database name
        and the lala/lulu to the username/password for the
        database connection.
*/
 
$dbname="netmap";
$dbuser="netmap";
$dbpass="************";
 
?>

**************************************netmap.conf**********************************************

Code :

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

1
2
3
4
 
DBNAME=netmap
DBUSER=netmap
DBPASS=****************

*************************************pg_hba.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
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
65
66
67
 
# PostgreSQL Client Authentication Configuration File
# ===================================================
#
# Refer to the PostgreSQL Administrator's Guide, chapter "Client
# Authentication" for a complete description.  A short synopsis
# follows.
#
# This file controls: which hosts are allowed to connect, how clients
# are authenticated, which PostgreSQL user names they can use, which
# databases they can access.  Records take one of seven forms:
#
# local      DATABASE  USER  METHOD  [OPTION]
# host       DATABASE  USER  IP-ADDRESS  IP-MASK   METHOD  [OPTION]
# hostssl    DATABASE  USER  IP-ADDRESS  IP-MASK   METHOD  [OPTION]
# hostnossl  DATABASE  USER  IP-ADDRESS  IP-MASK   METHOD  [OPTION]
# host       DATABASE  USER  IP-ADDRESS/CIDR-MASK  METHOD  [OPTION]
# hostssl    DATABASE  USER  IP-ADDRESS/CIDR-MASK  METHOD  [OPTION]
# hostnossl  DATABASE  USER  IP-ADDRESS/CIDR-MASK  METHOD  [OPTION]
#
# (The uppercase quantities should be replaced by actual values.)
# The first field is the connection type: "local" is a Unix-domain socket,
# "host" is either a plain or SSL-encrypted TCP/IP socket, "hostssl" is an
# SSL-encrypted TCP/IP socket, and "hostnossl" is a plain TCP/IP socket.
# DATABASE can be "all", "sameuser", "samegroup", a database name (or
# a comma-separated list thereof), or a file name prefixed with "@".
# USER can be "all", an actual user name or a group name prefixed with
# "+" or a list containing either.  IP-ADDRESS and IP-MASK specify the
# set of hosts the record matches.  CIDR-MASK is an integer between 0
# and 32 (IPv6) or 128(IPv6) inclusive, that specifies the number of
# significant bits in the mask, so an IPv4 CIDR-MASK of 8 is equivalent
# to an IP-MASK of 255.0.0.0, and an IPv6 CIDR-MASK of 64 is equivalent
# to an IP-MASK of ffff:ffff:ffff:ffff::. METHOD can be "trust", "reject",
# "md5", "crypt", "password", "krb4", "krb5", "ident", or "pam".  Note
# that "password" uses clear-text passwords; "md5" is preferred for
# encrypted passwords.  OPTION is the ident map or the name of the PAM
# service.
#
# This file is read on server startup and when the postmaster receives
# a SIGHUP signal.  If you edit the file on a running system, you have
# to SIGHUP the postmaster for the changes to take effect, or use
# "pg_ctl reload".
 
# Put your actual configuration here
# ----------------------------------
#
# CAUTION: The default configuration allows any local user to connect
# using any PostgreSQL user name, including the superuser, over either
# Unix-domain sockets or TCP/IP.  If you are on a multiple-user
# machine, the default configuration is probably too liberal for you.
# Change it to use something other than "trust" authentication.
#
# If you want to allow non-local connections, you need to add more
# "host" records.  Also, remember TCP/IP connections are only enabled
# if you enable "tcpip_socket" in postgresql.conf.
 
# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
 
#local   all         all                                             trust
# IPv4-style local connections:
#host    all         all         127.0.0.1         255.255.255.255   trust
# IPv6-style local connections:
#host    all         all         ::1               ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        trust
 
# Using sockets credentials for improved security. Not available everywhere,
# but works on Linux, *BSD (and probably some others)
local  all     all     ident   sameuser

Et j'ai une erreur du type :

Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "netmap" . in /usr/local/netmap/www/admin/db.inc on line 10 Error connecting to database

Voila si qqun a une idée ? merci
A+ Matthieu

[papy_tergnier]

essaye de decommenter ta première ligne de ton pg_hba.conf pour tester
celle ou c'est écrit :

Code :

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

local    all    all                       trust

[_matt_44]

Ce changement donne tjs le meme erreur.

[greg64]

si tu enlève les commentaires de tes connections cela marcherai je pense ####

[_matt_44]

idem tjs la meme erreur!!