Re: encrypt/decrypt problem - Mailing list pgsql-general
From | Dennis Gearon |
---|---|
Subject | Re: encrypt/decrypt problem |
Date | |
Msg-id | 3EAEBEEB.4010509@cvc.net Whole thread Raw |
In response to | Re: encrypt/decrypt problem ("Ivan" <perseus@444.net>) |
List | pgsql-general |
read the file: ../contrib/pgcrypto/README.pgcrypto Ivan wrote: > thanx for the link!! it have cool info, well i learn how to use the > encrypt function: > > UPDATE tabla2 SET lastname = encrypt('pass', 'pass', 'bf') where apellido > = 'noriega'; > > with that i change the fields i need to be encrypted... but there is > another problem... how i can obtain the decrypted data??, i suppose that i > need to use the "decrypt" function, i was trying to use it in that way: > > SELECT decrypt('lastname', 'pass', 'bf') as "worked" from tabla2 where > apellido = 'noriega'; > > but i only obtain an encrypted value (different that the i already had in > the db)... anyone knows how to obtain the decrypted data??? > > ivan > > > > >>If the encrypt function is from the contribs, it CAN do reversible >>encryption, you just have to choose which encryption type you want to >>use. Please look in the archives at: >> >>http://marc.theaimsgroup.com/?l=postgresql-general&w=2&r=1&s=encrypt+contrib&q=b >> >>Ivan wrote: >> >>>>Ivan wrote: >>>> >>>> >>>>>hi >>>>> >>>>>i need to encrypt some fields in a table of my postgre db, my table >>>>>is named clients and the fields are "id", "name" and "password", i >>>>>was looking and i find the pgcrypto utility, i read something about >>>>>the pgcrypto functions and i see the "crypto" function and use it, >>>>>well the fields change and i supose that was encrypted... but how i >>>>>could obtain the decrypt info??? (i don't know it), well next i read >>>>>about the "encrypt-decrypt" function, maybe it is what i need i try >>>>>to use the encrypt function from the EMS PostgreSQL Manager (SQL >>>>>editor) in that form >>>>> >>>>>UPDATE tabla2 SET pass = encrypt(pass, 'iv', 'bf'); >>>>> >>>>>next i try: >>>>> >>>>>encrypt(pass,'fooz','bf') >>>>> >>>>>but either work... i don't find much examples about it, pls does >>>>>anyone have an idea of how i can implement the "encrypt-decrypt on my >>>>>table??? >>>> >>>>You may be running into a "one-way-hash" encryption system - in which >>>>when you use the crypto function, the data is stored in encrypted >>>>format, with the idea that you take your input supplied, encrypt it, >>>>and >>>>compare it to the field (containing the previously encrypted data) - >>>>if it matches, then the "password" or whatever was entered correctly. >>>> >>>>It typically isn't possible to reverse this one-way hash back to >>>>plaintext easily. >>>> >>>>Andrew Ayers >>> >>> >>> >>>thanks Andrew. well now i know that the crypt function is not what i >>>need, i need to encrypt all the fields of some tables not only the >>>passwords, if someone knows how to use the encrypt/decrypt function >>>and could tell me something, i will be grateful >>> >>>ivan >>> >>> >>>-------------------------------------------- >>>Free Webmail courtesy of http://www.444.net/ >>> >>> >>>---------------------------(end of >>>broadcast)--------------------------- TIP 3: if posting/reading >>>through Usenet, please send an appropriate subscribe-nomail command to >>>majordomo@postgresql.org so that your message can get through to the >>>mailing list cleanly >>> >> >> >>---------------------------(end of broadcast)--------------------------- >>TIP 5: Have you checked our extensive FAQ? >> >>http://www.postgresql.org/docs/faqs/FAQ.html > > > > > -------------------------------------------- > Free Webmail courtesy of http://www.444.net/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
pgsql-general by date: