Differences in crypt hash? - Mailing list pgsql-docs

From Richard Hodges
Subject Differences in crypt hash?
Date
Msg-id Pine.BSF.4.10.10108031827060.96346-100000@mail.matriplex.com
Whole thread Raw
Responses Re: Differences in crypt hash?
List pgsql-docs
Hi all,

I am trying to figure out exactly what is going on with a client
that I have just compiled for Solaris 2.7  I have compiled both
7.0.3 and 7.1.2, and neither gave me any obvious compilation errors,
but I did note these interesting (relevant?) warnings:
  UX tsort: INFORM: cycle in data
          fe-connect.o
          fe-auth.o
  UX tsort: INFORM: cycle in data
          fe-exec.o
          fe-connect.o

My Solaris client uses the three files: libpq-fe.h, postgres_ext.h,
and libpq.a (nothing else).

The problem is that my Solaris client does not authenticate against
my server (7.0.3 built on FreeBSD).  I added the following line to
  src/backend/libpq/crypt.c, function crypt_verify() for logging:
  fprintf(stderr, "crypt_verify: user='%s' pass='%s', crypt='%s'\n",
    user, pgpass, crypt_pwd);

When my FreeBSD client connects, this logging prints success:
  crypt_verify: user='dtvuser'
     pass='$1$hI$eaByHtOxTYKOygT1.JMsU.',
    crypt='$1$hI$eaByHtOxTYKOygT1.JMsU.'
  crypt_verify: user='dtvuser'
     pass='$1$ZH$YGGYInw6oH0P29Ze6hlo.1',
    crypt='$1$ZH$YGGYInw6oH0P29Ze6hlo.1'

When my Solaris client tries to connect, the hash is totally wrong:
  crypt_verify: user='dtvuser'
     pass='lBeX8.2tWJup.',
    crypt='$1$lB$ajOq8TJJdUAAyDZcSGDfM.'
  crypt_verify: user='dtvuser'
     pass='3HW/UXZhFVXhs',
    crypt='$1$3H$QzIURSP9F/v/nI5jFwwXn.'

My FreeBSD client is apparently using a salted MD5 hash, where my
Solaris client seems to be just throwing something else.

Is there a configuration item I missed while compiling?  Or is there
a run-time option involved?

Thanks for any insight into this!

-Richard

-------------------------------------------
   Richard Hodges   | Matriplex, inc.
   Product Manager  | 769 Basque Way
  rh@matriplex.com  | Carson City, NV 89706
    775-886-6477    | www.matriplex.com


pgsql-docs by date:

Previous
From: speeves
Date:
Subject: security docs
Next
From: Tom Lane
Date:
Subject: Re: Differences in crypt hash?