Patrix, Now I am puzzled. The only file that I know of that would generate an ident authentication error is the pg_hba.conf and pg_ident.conf files. If the authentication for a particular host/user combination in the pg_hba.conf is specified as ident <ident user> then postgres looks up that <ident user> in the pg_ident.conf to locate the corresponding postgres user id. The only situation I know that would generate such an error is if there is an invalid <ident user> (one that is not in the pg_ident.conf file or the <ident user> is left blank). There may be a default line such as: local all all ident sameuser in the pg_hba.conf file that may be above the commented table headings line. Do a grep for ident on the pg_hba.conf file to see if one shows up. There is also a list at "pgsql-sql@postgresql.org" that you can probably get more info on this issue.
The error message is : Server message: FATAL: Ident authentication failed for user "patrix"
Stuart On Sunday 22 January 2006 02:20, Patrix Linux wrote:
Hi Stuart.
I don't find any 'ident' in my pg_hba.conf. So where is the mistake? please keep teaching me.
====here is my pg_hba.conf postgres@acer-suse:~/data/base/rumahsakit> whoami postgres postgres@acer-suse:~/data/base/rumahsakit> pwd /var/lib/pgsql/data/base/rumahsakit ....<<SNIP>>.... # TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only local all all password # IPv4 local connections: host all all 127.0.0.1/32 password host all all 0.0.0.0 0.0.0.0 password # IPv6 local connections: host all all ::1/128 md5 postgres@acer-suse:~/data/base/rumahsakit> whoami postgres postgres@acer-suse:~/data/base/rumahsakit> pwd /var/lib/pgsql/data/base/rumahsakit postgres@acer-suse:~/data/base/rumahsakit>
====/etc/sysconfig/postgresql postgres@acer-suse:/etc/sysconfig> pwd /etc/sysconfig postgres@acer-suse:/etc/sysconfig> cat postgresql ## Path: Applications/PostgreSQL ## Description: The PostgreSQL Database System ## Type: string() ## Default: "~postgres/data" ## ServiceRestart: postgresql # # In which directory should the PostgreSQL database reside? # POSTGRES_DATADIR="~postgres/data"
## Path: Applications/PostgreSQL ## Description: The PostgreSQL Database System ## Type: string() ## Default: "" ## ServiceRestart: postgresql # # The options that are given to the PostgreSQL master daemon on startup. # See the manual pages for postmaster and postgres for valid options. # # Don't put "-D datadir" here since it is set by the startup script # based on the variable POSTGRES_DATADIR above. # POSTGRES_OPTIONS="-i"
## Path: Applications/PostgreSQL ## Description: The PostgreSQL Database System ## Type: string() ## Default: "C" ## ServiceRestart: "" # # Specifies the locale under which the PostgreSQL database location # should be initialized and run. If needed, it has to be changed # before PostgreSQL is started for the first time. To change the # locale of an existsing PostgreSQL database location, it must be # dumped, removed and initialized from scratch using the new locale. # # If unset or empty $RC_LANG from /etc/sysconfig/language is used. # POSTGRES_LANG="" postgres@acer-suse:/etc/sysconfig>
On Sat, 2006-01-21 at 16:42 -0500, Stuart wrote:
Patix,
Sounds like you have an entry in your pg_hba.conf file that tells psql to go to pg_ident.conf to verify the user patrix or possibly all users. Check your pg_hba.conf file and remove references to ident. Check any default statements that might include ident.
On Saturday 21 January 2006 14:38, Patrix Linux wrote:
pg_hba.conf'