Re: Security::cipher() and mysqldump

I was never able to convert the encoding of my ciphered data back to its original form. I was able to find a random backup I didn't realize I had and used that to restore the "corrupted" fields. Just wanted to report back for anyone following this thread. On Wednesday, April 11, 2012 7:03:11 PM

Re: Security::cipher() and mysqldump

To get the char encoding: file -bi dumpfilename To convert it to UTF-8: iconv -f [encoding from above] -t utf8 dumpfilename > dumpfile_utf8.sql -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org

Re: Security::cipher() and mysqldump

Much obliged, AD ;-) I'm traveling the next 2 days on business and won't be able to put the proper time into troubleshooting this until I return. I'll post my results here for thread completeness. Thank you all. On Wednesday, April 11, 2012 2:04:13 AM UTC-7, AD7six wrote: > > > > On Tuesday, 1

Re: Security::cipher() and mysqldump

On Tuesday, 10 April 2012 22:17:46 UTC+2, etipaced wrote: > > If these were only passwords... :-/ You can fix this with either mysql alone, or a shell. Either way though you're going to need to go through some trial and error and if you get stuck know that a mysql forum/irc channel will giv

Re: Security::cipher() and mysqldump

I see. How would I go about doing that? I'm reading that ASCII is UTF-8 already. Running utf8_encode() didn't produce any usable results. I'm just very in the dark when it comes to encoding issues. On Tuesday, April 10, 2012 11:58:44 AM UTC-7, bobzibub wrote: > > Note that one string is double

Re: Security::cipher() and mysqldump

If these were only passwords... :-/ On Tuesday, April 10, 2012 1:13:49 PM UTC-7, Thiago Belem wrote: > > Maybe you should just orient your users to reset their passwords? > > > -- > ***Thiago Belem* > Desenvolvedor > Rio de Janeiro - RJ - Brasil > > *Assando Sites* - Curso online de *CakePHP* >

Re: Security::cipher() and mysqldump

Maybe you should just orient your users to reset their passwords? -- ***Thiago Belem* Desenvolvedor Rio de Janeiro - RJ - Brasil *Assando Sites* - Curso online de *CakePHP* assando-sites.com.br thiagobelem.net cont...@thiagobelem.net *Skype / gTalk **»* thiago.belem.web *

Re: Security::cipher() and mysqldump

Yes. Same code in all cases. Also, take note that the dump/export file was created by the production server that originally ciphered the value and stored it in the db. So I'm not sure that those values play into my current scenario. On Tuesday, April 10, 2012 11:52:10 AM UTC-7, Thiago Belem wr

Re: Security::cipher() and mysqldump

Note that one string is double the length of the other. Ôd§5ð£ïäì vs Ó`ª5ñ¦ïìíµM And UTF-8 typically takes 16 bits and ascii 8.. Just a hunch but I'd bet you should be able to make a PHP function to convert them back. b On Tue, 2012-04-10 at 15:52 -0300, Thiago Belem wrot

Re: Security::cipher() and mysqldump

Are you using the same Security.cipherSeed and Security.salt? -- ***Thiago Belem* Desenvolvedor Rio de Janeiro - RJ - Brasil thiagobelem.net cont...@thiagobelem.net *Skype / gTalk **»* thiago.belem.web *LinkedIn* *»* br.linkedin.com/in/thiagobelem/pt* Assando Sites*, curso de CakePHP *»* assando-

Re: Security::cipher() and mysqldump

Thanks for the help. Unfortunately, it didn't work. My database, table and fields are all UTF-8. The ciphered values import from the dump file into the table correctly. The problem is that I believe they are incorrect in the dump file itself. Meaning, mysqldump did not export them properly and

Re: Security::cipher() and mysqldump

On Mon, Apr 9, 2012 at 1:24 PM, etipaced wrote: > I know there have been discussions surrounding the issue of suhosin with > Cake's Security::cipher() method. I am in the process of discontinuing usage > of Cake's ciphering functionality due to this issue. However, I do have > existing data that h

Security::cipher() and mysqldump

I know there have been discussions surrounding the issue of suhosin with Cake's Security::cipher() method. I am in the process of discontinuing usage of Cake's ciphering functionality due to this issue. However, I do have existing data that has been ciphered already. My problem is that the data