X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id C41575288E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 16 Aug 2005 13:26:09 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 28851-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 16 Aug 2005 16:26:06 +0000 (GMT)
Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25])
	by svr1.postgresql.org (Postfix) with ESMTP id 68E5252888
	for <pgsql-sql@postgresql.org>; Tue, 16 Aug 2005 13:26:06 -0300 (ADT)
Received: from mail.osl.com (216-21-133-98.ip.van.radiant.net [216.21.133.98])
	by svr2.postgresql.org (Postfix) with ESMTP id D4EE1F0C14
	for <pgsql-sql@postgresql.org>; Tue, 16 Aug 2005 17:21:46 +0100 (BST)
Received: from scottpj ([90.1.0.155]) (authenticated)
	by mail.osl.com (8.11.6/8.11.2) with ESMTP id j7GGQ5c08771
	for <pgsql-sql@postgresql.org>; Tue, 16 Aug 2005 09:26:05 -0700
From: "Owen Jacobson" <ojacobson@osl.com>
To: <pgsql-sql@postgresql.org>
Subject: Re: What libraries need to be included in C program for encrypt and
	decrypt functions?
Date: Tue, 16 Aug 2005 09:25:53 -0700
Message-ID: <000101c5a27f$2d35e420$9b00015a@osl.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0002_01C5A244.80D97D20"
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0)
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
Importance: Normal
In-Reply-To: <20050816135940.80368.qmail@web33902.mail.mud.yahoo.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.093 required=5 tests=[AWL=-0.044,
	FORGED_RCVD_HELO=0.05, HTML_40_50=0.086, HTML_MESSAGE=0.001]
X-Spam-Level: 
X-Archive-Number: 200508/115
X-Sequence-Number: 22343

This is a multi-part message in MIME format.

------=_NextPart_000_0002_01C5A244.80D97D20
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

As I mentioned in email, the function "encrypt" exposed by libcrypt
(the -lcrypt part of your command line) has nothing to do with the "encrypt"
function available in pgcrypto.sql, which You Cannot Call From C.  You have
to embed calls to it inside an SQL query like

INSERT INTO some_table (some_col) VALUES (ENCRYPT ('Hello', 'AAAA0000',
'aes'));
  -----Original Message-----
  From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org]On Behalf Of The One
  Sent: Tuesday, August 16, 2005 7:00 AM
  To: pgsql-sql@postgresql.org
  Subject: [SQL] What libraries need to be included in C program for encrypt
and decrypt functions?


  Hi,

  Can some body tell me what I need to include in the makefile for my C
program so it will call the correct encrypt/decrypt functions.

  This is what I have in the makefile
  testcrypto:
    ${CC} -o ${BIN}/testcrypto.exe
testcrypto.c -I/usr/include/postgresql/server/libpq -L/lib/postgresql -lpq -
lcrypt

  I'm calling the function like this
  printf("test encryption: %s", encrypt("hello", "0000BBBB", "aes");

  But I'm getting too many arguments in function encrypt.

  Thank you




----------------------------------------------------------------------------
--
  Start your day with Yahoo! - make it your home page

------=_NextPart_000_0002_01C5A244.80D97D20
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">


<META content=3D"MSHTML 6.00.2800.1515" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D026502016-16082005>As I=20
mentioned in email, the function "encrypt" exposed by libcrypt (the =
-lcrypt part=20
of your command line) has nothing to do with the "encrypt" function =
available in=20
pgcrypto.sql, which You Cannot Call From C.&nbsp; You have to embed =
calls to it=20
inside an SQL query like</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D026502016-16082005></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D026502016-16082005>INSERT=20
INTO some_table (some_col) VALUES (ENCRYPT ('Hello', 'AAAA0000',=20
'aes'));</SPAN></FONT></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px =
solid">
  <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B>=20
  pgsql-sql-owner@postgresql.org =
[mailto:pgsql-sql-owner@postgresql.org]<B>On=20
  Behalf Of </B>The One<BR><B>Sent:</B> Tuesday, August 16, 2005 7:00=20
  AM<BR><B>To:</B> pgsql-sql@postgresql.org<BR><B>Subject:</B> [SQL] =
What=20
  libraries need to be included in C program for encrypt and decrypt=20
  functions?<BR><BR></FONT></DIV>
  <DIV>Hi,</DIV>
  <DIV>&nbsp;</DIV>
  <DIV>Can some body tell me what I need to include in the makefile for =
my C=20
  program so it will call the correct encrypt/decrypt functions.</DIV>
  <DIV>&nbsp;</DIV>
  <DIV>This is what I have in the makefile</DIV>
  <DIV>testcrypto:<BR>&nbsp;&nbsp;${CC} -o ${BIN}/testcrypto.exe =
testcrypto.c=20
  -I/usr/include/postgresql/server/libpq -L/lib/postgresql -lpq =
-lcrypt</DIV>
  <DIV>&nbsp;</DIV>
  <DIV>I'm calling the function like this </DIV>
  <DIV>printf("test encryption: %s", encrypt("hello", "0000BBBB", =
"aes");</DIV>
  <DIV>&nbsp;</DIV>
  <DIV>But I'm getting too many arguments in function encrypt.</DIV>
  <DIV>&nbsp;</DIV>
  <DIV>Thank you</DIV>
  <DIV>&nbsp;</DIV>
  <DIV>&nbsp;</DIV>
  <P>
  <HR SIZE=3D1>
  <A =
href=3D"http://us.rd.yahoo.com/evt=3D34442/*http://www.yahoo.com/r/hs">St=
art=20
  your day with Yahoo! - make it your home page =
</A></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0002_01C5A244.80D97D20--