Received: from mail.matriplex.com (ns1.matriplex.com [208.131.42.8]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f741fW681109 for ; Fri, 3 Aug 2001 21:41:32 -0400 (EDT) (envelope-from rh@matriplex.com) Received: from mail.matriplex.com (mail.matriplex.com [208.131.42.9]) by mail.matriplex.com (8.9.2/8.9.2) with ESMTP id SAA97125 for ; Fri, 3 Aug 2001 18:41:28 -0700 (PDT) (envelope-from rh@matriplex.com) Date: Fri, 3 Aug 2001 18:41:27 -0700 (PDT) From: Richard Hodges To: pgsql-docs@postgresql.org Subject: Differences in crypt hash? Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200108/1 X-Sequence-Number: 888 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