Re: [GENERAL] Problem with encode () and hmac() in pgcrypto

2011-02-03 Thread hlcborg
Hi For now, I already can use in my PG database the PL/Python to create functions. But I need a library that can do the: > Plain SHA1, which is signed with RSA signature. Do you known any PL/Python wrapper libraries around OpenSSL (or any other crypto library) that I could use. I have found s

Re: [GENERAL] Problem with encode () and hmac() in pgcrypto

2011-02-01 Thread hlcborg
Hi Marko, OK, > These two operations are not equivalent. But... Can I have this operation done in the Stored Procedure inside the Database? Plain SHA1, which is signed with RSA signature. and in the end encoded to base64? I was looking in the pgcrypto functions, and I havenĀ“t found any that

[GENERAL] Problem with encode () and hmac() in pgcrypto

2011-02-01 Thread hlcborg
Hi, I am trying to compute a hash string with 172 bytes. I have a openssl RSA private key stored in the postgresql db and a string with some text. I want to sign that string with the private key and the SHA1 algorithm and encode the result in the base64 format. I am writing it inside the pg da