Re: Witango-Talk: encrypting into mysql

2009-11-24 Thread Roland Dumas
thanks. that looks promising. On Nov 24, 2009, at 11:11 AM, Robert Garcia wrote: > I would agree using mysql, but I think you mean use aes_crypt() > aes_decrypt(), or encode decode, there is no decrypt(). > > So to insert a record > > insert into sometable ('name','somestringname') values > (

Re: Witango-Talk: encrypting into mysql

2009-11-24 Thread Robert Garcia
I would agree using mysql, but I think you mean use aes_crypt() aes_decrypt(), or encode decode, there is no decrypt(). So to insert a record insert into sometable ('name','somestringname') values ('namevalue',aes_crypt('somestringvalue','somekey')) Then to retrieve unencrypted: select na

Re: Witango-Talk: encrypting into mysql

2009-11-24 Thread John McGowan
Roland, Since you mentioned specifically mysql, don't forget that you can do your encryption with a mysql function call. So you just need to do a custom column or a direcdbms action. http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html you can call encrypt() when doing inserts or up

Re: Witango-Talk: encrypting into mysql

2009-11-24 Thread Anthony Humphreys
All of the hashes and encryption methods are found in Witango by using the built-in Meta Tag @CIPHER. <@CIPHER ACTION=action TYPE=type STR=string [KEY=key] [KEYTYPE] [ENCODING= encoding]> Hashes are perfect for a password; you don't need to store the password itself, just the hash of the password

Re: Witango-Talk: encrypting into mysql

2009-11-24 Thread Beverly Voth
<@cipher> doesn't work for you? On 11/24/09 11:48 AM, "Roland Dumas" wrote in whole or in part: > thank you. I'm ignorant about these things and need more explicit steps: > > how does one "hash" a string? There's no <@hash> tag in witango > > What if you really want the unhashed string back ou

RE: Witango-Talk: encrypting into mysql

2009-11-24 Thread Robert Shubert
: encrypting into mysql thank you. I'm ignorant about these things and need more explicit steps: how does one "hash" a string? There's no <@hash> tag in witango What if you really want the unhashed string back out? Say, a credit card number? On Nov 24, 2009, at 8:17 AM, Be

Re: Witango-Talk: encrypting into mysql

2009-11-24 Thread Roland Dumas
thank you. I'm ignorant about these things and need more explicit steps: how does one "hash" a string? There's no <@hash> tag in witango What if you really want the unhashed string back out? Say, a credit card number? On Nov 24, 2009, at 8:17 AM, Beverly Voth wrote: > On 11/24/09 11:08 AM, "

Re: Witango-Talk: encrypting into mysql

2009-11-24 Thread Beverly Voth
On 11/24/09 11:08 AM, "Roland Dumas" wrote in whole or in part: > > How does one insert a field into a database - mysql - so that it ends up > encrypted? > Needless to say, the field must be unencryptable in order to compare it to > submissions, as in a password, or unencryptable for export, as

Witango-Talk: encrypting into mysql

2009-11-24 Thread Roland Dumas
How does one insert a field into a database - mysql - so that it ends up encrypted? Needless to say, the field must be unencryptable in order to compare it to submissions, as in a password, or unencryptable for export, as in a cc number. How does this work? ___