On Tue, Mar 06, 2001 at 06:44:31PM -0500, Boulat Khakimov wrote:
> Hi,
>
> Im writing a function in C (encode) for PG that uses blowfish encryption
> here is how I compile it.
>
> gcc -I/usr/src/postgresql-7.0.3/src/include
> -I/usr/src/postgresql-7.0.3/src/backend -O2 -Wall -Wmissing-prototypes
> -Wmissing-declarations -lcrypt
> -I/usr/src/postgresql-7.0.3/src/interfaces/libpq
> -I/usr/src/postgresql-7.0.3/src/include -fpic
> -I/home/boulat/Funio.com/database/libblowfish.a -c -o encode.o
> encode.c
I suspect you want
...
-L/usr/src/postgresql-7.0.3/src/interfaces/
/home/boulat/Funio.com/database/libblowfish.a -c -o encode -lpq
But I wonder if, libblowfish.a is compiled with position independent
code *and* if libpq is reachable by the backend database. I don't think
your libblowfish is getting linked into the object.
> it compiles nicely with 0 error or warnings,
>
> then i do
> gcc -shared -o encode.so encode.o
> rm encode.o
>
> so now im left we a ready to go encode.so , So now I add that function
> to DB
>
> testdb=# CREATE FUNCTION encode(text,text)
> testdb-# RETURNS text
> testdb-# AS '/home/boulat/Funio.com/database/encode.so'
> testdb-# LANGUAGE 'C';
> CREATE
>
> no problems there either, BUT ...
>
> testdb=# select encode('bob','bob');
> ERROR: Load of file /home/boulat/Funio.com/database/encode.so failed:
> /home/boulat/Funio.com/database/encode.so: undefined symbol:
> BF_cfb64_encrypt
>
> thats the function that I call from inside my c code...
> but Why??? It compiled with no errors or warning, and I have all the
> right includes in my source code.
>
> Im confused!
>
> Any help would be appreciated.
>
> Regards,
> Boulat Khakimov
>
> --
> Nothing Like the Sun
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
--
Eric G. Miller <egm2@jps.net>
