[GENERAL] openssl & postgresql

[Doug McNaught]

Richard Welty <rwe...@averillpark.net> writes:

> is there code sitting around some where to allow me to access the OpenSSL
> crypto library from postgresql? i'm just looking for the md5 and sha1 hash
> functions right now.

contrib/pgcrypto/

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majo...@postgresql.org

[Richard Welty]

On Tue, 23 Oct 2001 14:19:18 -0600 Keary Suska <hiero...@pcisys.net> wrote:
> I wrote:
> > is there code sitting around some where to allow me to access the OpenSSL
> > crypto library from postgresql? i'm just looking for the md5 and sha1 hash
> > functions right now.

> Look at pg_crypto in the contrib/ directory of the source installation tree.
> I think that has at least some of the functionality you desire, and looking
> at the source would show you how to extend it.

thanks, i went looking at contrib/ first on a couple of the mirrors,
figuring that someone must have wanted to do this sometime before, and
it was empty, so i decided to try asking here.

since none of the ftp mirrors i've checked (about 8 of them) have any
contrib/ files at all, what's up?

and does anyone have a copy of pg_crypto they could make available to me,
since the semi-official copies are all MIA?

thanks,
richard
--
Richard Welty Averill Park Networking
rwe...@averillpark.net 518-573-7592

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majo...@postgresql.org so that your
message can get through to the mailing list cleanly

[Keary Suska]

The contrib/ directory is not listed separately--it is part of the postgres
distribution, and comes with the tarball. If you don't have the source, you
will need to download the tarball. When you unpack it, you will see the
contrib directory inside. You can probably just run 'make' inside the
pgcrypto directory, but if it fails, you may have to build postgres. You
won't have to install it again, just build it. 'make install' for items in
contrib/ may not work properly if the postgres build isn't configured
properly.

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"

---------------------------(end of broadcast)---------------------------