Re: how to STORE encrypted string in database
hi, i have tried all the datatype in SQLite that can hold string and char (CHARACTER,VARCHAR,VARYING CHARACTER,NCHAR,NATIVE CHARACTER,NVARCHAR,TEXT,CLOB,BLOB) BUT NONE have hold the encrypted string that i'm trying to Store and retieve i even tried on to store on text file but with the same result?? base 64 fail for cases where the bizzare symbol is 00x00 PLZ can anyone help - to store encrypted text generated by Openssl (EVP) to STORE in Database SQLite On Mon, Apr 1, 2013 at 8:48 AM, Daniel Black daniel.s...@internode.on.netwrote: On 29/03/13 05:24, Matthias Apitz wrote: El día Thursday, March 28, 2013 a las 01:14:35PM -0500, Salz, Rich escribió: Encrypted data is not a text string, it is an array of binary octets. You will have to do something like base64 encode/decode when treating it as a text string. Or the OP should use a data type of the database which allows storing binary actets, like BLOB (Sybase) or IMAGE (Oracle) or ... depends on your DBS. matthias Since SQlite was mentioned that would be BLOB. http://sqlite.org/datatype3.html I've done this before with mysql and the BINARY type and requires no conversion __ OpenSSL Project http://www.openssl.org User Support Mailing Listopenssl-users@openssl.org Automated List Manager majord...@openssl.org -- From:- Shanil J.S
Re: how to STORE encrypted string in database
One solution i thought could work was to convert the char into int and use mode 128 to bring then in the range of ascii caracters but it consists of negative number as well which complicate thing difficult to fit in the ascii space when convert same int to char get different char A sample example is :: int test = -90; // == to '▓' when char converted to int char letter = '▓'; printf(Char TO int %c \n,(int)letter); // -90 printf(int TO Char %c \n,(char)test); //ª WHICH is not = '▓' PLZ can someone provide a solution -- to store encrypted text in a database - SQLite?? On Mon, Apr 1, 2013 at 2:42 PM, Jevin Sonut j.so...@gmail.com wrote: hi, i have tried all the datatype in SQLite that can hold string and char (CHARACTER,VARCHAR,VARYING CHARACTER,NCHAR,NATIVE CHARACTER,NVARCHAR,TEXT,CLOB,BLOB) BUT NONE have hold the encrypted string that i'm trying to Store and retieve i even tried on to store on text file but with the same result?? base 64 fail for cases where the bizzare symbol is 00x00 PLZ can anyone help - to store encrypted text generated by Openssl (EVP) to STORE in Database SQLite On Mon, Apr 1, 2013 at 8:48 AM, Daniel Black daniel.s...@internode.on.net wrote: On 29/03/13 05:24, Matthias Apitz wrote: El día Thursday, March 28, 2013 a las 01:14:35PM -0500, Salz, Rich escribió: Encrypted data is not a text string, it is an array of binary octets. You will have to do something like base64 encode/decode when treating it as a text string. Or the OP should use a data type of the database which allows storing binary actets, like BLOB (Sybase) or IMAGE (Oracle) or ... depends on your DBS. matthias Since SQlite was mentioned that would be BLOB. http://sqlite.org/datatype3.html I've done this before with mysql and the BINARY type and requires no conversion __ OpenSSL Project http://www.openssl.org User Support Mailing Listopenssl-users@openssl.org Automated List Manager majord...@openssl.org -- From:- Shanil J.S -- From:- Shanil J.S
how to STORE encrypted string in database
hi, i have encrypted a string using Blowfish from Openssl library i got the following string A▓☼LÝ$øä²↓j╗ú¤Ä:ðï▲ i inserted the data into my database BUT when i retrieved the data i got A¦¤LÝ$øä²?j+ú¤Ä:ðï? (NOT same to the original the one i inserted) thus when i decrypt the loaded string from the database i donot get the original string Can anyone ply help to solve the problem i'm using SQLITE and c/c++ I google the problem but came along a c# solution http://stackoverflow.com/questions/8389412/md5-encrypted-string-returns-different-from-database-than-it-is-inserted Can anyone PLZ help From:- Shanil J.S
Re: how to STORE encrypted string in database
Can anyone PLZ tell me how can one do base64 encode/decode on OPENSSL PLz provide a link where can learn how to use the base64 in openssl On Thu, Mar 28, 2013 at 10:14 PM, Salz, Rich rs...@akamai.com wrote: Encrypted data is not a text string, it is an array of binary octets. You will have to do something like base64 encode/decode when treating it as a text string. ** ** /r$ ** ** -- Principal Security Engineer Akamai Technology Cambridge, MA ** ** -- From:- Shanil J.S
Store generated keys for later use on windows
what is the best way to store keys that will be used by openssl can someone plz explain how to create the pem/p7 file for keys found some info @ http://www.mail-archive.com/openssl-users@openssl.org/msg18775.html Another unanswered question about pem file manipulation http://www.mail-archive.com/openssl-users@openssl.org/msg69377.html if there is any other better way plz tell me Actually i defined a char and enters the passkey and IV in the program itself??? From:- Shanil J.S
Encrypt / DECRYPT a XML file using AES - break the file into 256 bits...
hi, can anyone please tell me how to load a file and break the file into specific size bits (256 bits) then encrypt the different sizes PLZ provide a link which explain this ++ IS AES still safe to use or it is no more safe as what i have read the pawwkey can be obtained + What the best way to keep a key in a program ?? as a string or in a specific file -- From:- Shanil J.S
access all the question n queries on openSSL
How can i view all the Question the other openssl user has posted ??? PLZ tell me the link where all the questions posted by different users are -- From:- Shanil J.S
QT .pro file configuration
Can someone plz tell the content of the QT .pro file where we link the library of OpenSSL to QT hope someone is using QT and openssl out here ?? thanks in advance -- From:- Shanil J.S __ OpenSSL Project http://www.openssl.org User Support Mailing Listopenssl-users@openssl.org Automated List Manager majord...@openssl.org
compile OpenSSL on windows using MSVC
the following two links is of great help http://www.askyb.com/windows/compiling-and-installing-openssl-for-32-bit-windows/ http://developer.covenanteyes.com/building-openssl-for-visual-studio/#foot_text_58_5 give detail explanation of how to build the library great job. Shanil j.s __ OpenSSL Project http://www.openssl.org User Support Mailing Listopenssl-users@openssl.org Automated List Manager majord...@openssl.org
Encrypt a text file in Openssl
Can anyone post a sample code how to load and break a text file and prepare the text to be encrypted using AES or DES thanks -- From:- Shanil J.S __ OpenSSL Project http://www.openssl.org User Support Mailing Listopenssl-users@openssl.org Automated List Manager majord...@openssl.org
Linking error
HI, can anyone understand what this error means:: libeay32.lib(cryptlib.obj) : error LNK2019: unresolved external symbol __imp__GetUserObjectInformationW@20 referenced in function _OPENSSL_isservice libeay32.lib(cryptlib.obj) : error LNK2019: unresolved external symbol __imp__GetProcessWindowStation@0 referenced in function _OPENSSL_isservice libeay32.lib(cryptlib.obj) : error LNK2019: unresolved external symbol __imp__GetDesktopWindow@0 referenced in function _OPENSSL_isservice libeay32.lib(cryptlib.obj) : error LNK2019: unresolved external symbol __imp__MessageBoxA@16 referenced in function _OPENSSL_showfatal libeay32.lib(cryptlib.obj) : error LNK2019: unresolved external symbol __imp__DeregisterEventSource@4 referenced in function _OPENSSL_showfatal libeay32.lib(cryptlib.obj) : error LNK2019: unresolved external symbol __imp__ReportEventA@36 referenced in function _OPENSSL_showfatal libeay32.lib(cryptlib.obj) : error LNK2019: unresolved external symbol __imp__RegisterEventSourceA@8 referenced in function _OPENSSL_showfatal debug\Openssl2.exe : fatal error LNK1120: 7 unresolved externals I tried to link QT with open ssl i tried to run the code from http://www.askyb.com/cpp/openssl-sha512-hashing-example-in-cpp/ the first part and i get the above error DO you think its an error with the linking:: MY QT .pro file :: INCLUDEPATH == C:\\openssl-1.0.1eBuild_Debug\\include LIBS += -LC:\\openssl-1.0.1eBuild_Debug\\lib \ -llibeay32 \ -lssleay32 openssl-1.0.1eBuild_Debug -- is the folder where i built the DEBUG version thanks in advance if Someone can help -- From:- Shanil J.S __ OpenSSL Project http://www.openssl.org User Support Mailing Listopenssl-users@openssl.org Automated List Manager majord...@openssl.org
configure QT with openssl library
hi, i have been trying to link QT with the openssl library since Friday but in vain can anyone plz help to configure QT to link with Openssl library thanks in advance for any useful material - links or detain explanation -- From:- Shanil J.S __ OpenSSL Project http://www.openssl.org User Support Mailing Listopenssl-users@openssl.org Automated List Manager majord...@openssl.org