Cakephp SSN Encryption - CakePHP

The old Google Groups will be going away soon, but your browser is incompatible with the new version.

« Groups Home

CakePHP

Home

Discussions

+ new post

About this group

Join this group

Message from discussion Cakephp SSN Encryption

Steven Scaffidi

View profile

More options May 2 2012, 4:39 pm

From: Steven Scaffidi <ssca...@gmail.com>

Date: Wed, 2 May 2012 13:39:50 -0700 (PDT)

Local: Wed, May 2 2012 4:39 pm

Subject: Re: Cakephp SSN Encryption

Print | View thread | Show original | Report this message | Find messages by this author

I created SSN through using regular sql and just literally copying whats in
the ssn field to the ssn_temp field. And then, this would work if it didn't
time out on me. How can I change the timeout time? There has to be a better
way to do this though.

public function encryptssn() {
$ssns = $this->User->find('list', array('fields' => array('id',
'ssn_temp')));
$j = 1;
foreach ($ssns as $i) {
$this->User->id = $j;
$this->User->saveField('ssn', $i);
$j++;

}

$this->redirect(array('action' => 'index'));

}
On Wednesday, May 2, 2012 3:03:46 PM UTC-5, Steven Scaffidi wrote:

> Can you give me a specific example of how to use saveMany? I have 4000
> clients in my database. Can I create another encrypted field in the
> database (say ssn_temp) then do something like this:

> $this->User->saveMany(array(array('ssn_temp' => array('User' => 'ssn'))));

> Would something like that work? I'm really confused by the documentation
> on saveMany

> On Tuesday, May 1, 2012 2:51:50 PM UTC-5, Justin Edwards wrote:

>> Sorry temp table* not temp folder

>> On Tue, May 1, 2012 at 7:51 PM, Justin Edwards <justinledwa...@gmail.com>wrote:

>>> Steven,

>>> Create a controller method.

>>> Find the data from the temp folder set it to a variable, and then
>>> saveMany from the variable to the encrypted table.

>>> http://book.cakephp.org/2.0/en/models/saving-your-data.html#model-sav...

>>> On Tue, May 1, 2012 at 7:18 PM, Steven Scaffidi <ssca...@gmail.com>wrote:

>>>> Ok I have the data migrated already (I probably should have used
>>>> something like pentaho instead of writing my own queries but oh well). How
>>>> do I use cake's encryption function on the data?

>>>> On Tuesday, May 1, 2012 2:07:56 PM UTC-5, Justin Edwards wrote:

>>>>> I would migrate it using pentaho. Then you can run cake's encryption
>>>>> function on the data. You could make a temporary table /model and then
>>>>> append it to the production table.

>>>>> On Tue, May 1, 2012 at 7:01 PM, Steven Scaffidi <ssca...@gmail.com>wrote:

>>>>>> Thanks for the plugin that worked great. I still don't understand how
>>>>>> to use pentaho though to encrypt social security numbers listed in the
>>>>>> access database.

>>>>>> On Apr 30, 5:28 pm, Justin Edwards <justinledwa...@gmail.com> wrote:
>>>>>> > #1http://bakery.cakephp.org/**articles/jmillerdesign/2011/**
>>>>>> 12/29/cipher_pl.<http://bakery.cakephp.org/articles/jmillerdesign/2011/12/29/cipher_pl.>
>>>>>> ..
>>>>>> > #2http://www.pentaho.com/**download/<http://www.pentaho.com/download/>

>>>>>> > On Mon, Apr 30, 2012 at 4:46 PM, Steven Scaffidi <ssca...@gmail.com>
>>>>>> wrote:
>>>>>> > > Hi - I'm looking for information on how to encrypt data in
>>>>>> Cakephp. My
>>>>>> > > employer had a client management system built in Microsoft
>>>>>> Access, and
>>>>>> > > I recently took that application and put it on a web-based space
>>>>>> built
>>>>>> > > in cake. I need to now two things:

>>>>>> > > #1 How can I encrypt social security numbers from new clients
>>>>>> coming
>>>>>> > > into the system? I'm encrypting passwords right now, but I'm not
>>>>>> sure
>>>>>> > > how to do social security numbers.

>>>>>> > > #2 How do I take social security numbers that are currently
>>>>>> listed in
>>>>>> > > Microsoft Access with no encryption and put them into the MySQL
>>>>>> > > database encrypted?

>>>>>> > > Thanks for the help,

>>>>>> > > Steven

>>>>>> > > --
>>>>>> > > Our newest site for the community: CakePHP Video Tutorials
>>>>>> > >http://tv.cakephp.org
>>>>>> > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd
>>>>>> help
>>>>>> > > others with their CakePHP related questions.

>>>>>> > > To unsubscribe from this group, send email to
>>>>>> > > cake-php+unsubscribe@**googlegroups.com<cake-php%2Bunsubscribe@googlegroups .com>For more options, visit this group
>>>>>> > > athttp://groups.google.com/**group/cake-php<http://groups.google.com/group/cake-php>

>>>>>> --
>>>>>> Our newest site for the community: CakePHP Video Tutorials
>>>>>> http://tv.cakephp.org
>>>>>> Check out the new CakePHP Questions site http://ask.cakephp.org and
>>>>>> help others with their CakePHP related questions.

>>>>>> To unsubscribe from this group, send email to
>>>>>> cake-php+unsubscribe@**googlegroups.com<cake-php%2Bunsubscribe@googlegroups .com>For more options, visit this group at
>>>>>> http://groups.google.com/**group/cake-php<http://groups.google.com/group/cake-php>

>>>>> --
>>>> Our newest site for the community: CakePHP Video Tutorials
>>>> http://tv.cakephp.org
>>>> Check out the new CakePHP Questions site http://ask.cakephp.org and
>>>> help others with their CakePHP related questions.

>>>> To unsubscribe from this group, send email to
>>>> cake-php+unsubscribe@googlegroups.com For more options, visit this
>>>> group at http://groups.google.com/group/cake-php

On Wednesday, May 2, 2012 3:03:46 PM UTC-5, Steven Scaffidi wrote:

> Can you give me a specific example of how to use saveMany? I have 4000
> clients in my database. Can I create another encrypted field in the
> database (say ssn_temp) then do something like this:

> $this->User->saveMany(array(array('ssn_temp' => array('User' => 'ssn'))));

> Would something like that work? I'm really confused by the documentation
> on saveMany

> On Tuesday, May 1, 2012 2:51:50 PM UTC-5, Justin Edwards wrote:

>> Sorry temp table* not temp folder

>> On Tue, May 1, 2012 at 7:51 PM, Justin Edwards <justinledwa...@gmail.com>wrote:

>>> Steven,

>>> Create a controller method.

>>> Find the data from the temp folder set it to a variable, and then
>>> saveMany from the variable to the encrypted table.

>>> http://book.cakephp.org/2.0/en/models/saving-your-data.html#model-sav...

>>> On Tue, May 1, 2012 at 7:18 PM, Steven Scaffidi <ssca...@gmail.com>wrote:

>>>> On Tuesday, May 1, 2012 2:07:56 PM UTC-5, Justin Edwards wrote:

>>>>> I would migrate it using pentaho. Then you can run cake's encryption
>>>>> function on the data. You could make a temporary table /model and then
>>>>> append it to the production table.

>>>>> On Tue, May 1, 2012 at 7:01 PM, Steven Scaffidi <ssca...@gmail.com>wrote:

>>>>>> Thanks for the plugin that worked great. I still don't understand how
>>>>>> to use pentaho though to encrypt social security numbers listed in the
>>>>>> access database.

>>>>>> > > #2 How do I take social security numbers that are currently
>>>>>> listed in
>>>>>> > > Microsoft Access with no encryption and put them into the MySQL
>>>>>> > > database encrypted?

>>>>>> > > Thanks for the help,

>>>>>> > > Steven

>>>> To unsubscribe from this group, send email to
>>>> cake-php+unsubscribe@googlegroups.com For more options, visit this
>>>> group at http://groups.google.com/group/cake-php

On Wednesday, May 2, 2012 3:03:46 PM UTC-5, Steven Scaffidi wrote:

> Can you give me a specific example of how to use saveMany? I have 4000
> clients in my database. Can I create another encrypted field in the
> database (say ssn_temp) then do something like this:

> $this->User->saveMany(array(array('ssn_temp' => array('User' => 'ssn'))));

> Would something like that work? I'm really confused by the documentation
> on saveMany

> On Tuesday, May 1, 2012 2:51:50 PM UTC-5, Justin Edwards wrote:

>> Sorry temp table* not temp folder

>> On Tue, May 1, 2012 at 7:51 PM, Justin Edwards <justinledwa...@gmail.com>wrote:

>>> Steven,

>>> Create a controller method.

>>> Find the data from the temp folder set it to a variable, and then
>>> saveMany from the variable to the encrypted table.

>>> http://book.cakephp.org/2.0/en/models/saving-your-data.html#model-sav...

>>> On Tue, May 1, 2012 at 7:18 PM, Steven Scaffidi <ssca...@gmail.com>wrote:

>>>> On Tuesday, May 1, 2012 2:07:56 PM UTC-5, Justin Edwards wrote:

>>>>> I would migrate it using pentaho. Then you can run cake's encryption
>>>>> function on the data. You could make a temporary table /model and then
>>>>> append it to the production table.

>>>>> On Tue, May 1, 2012 at 7:01 PM, Steven Scaffidi <ssca...@gmail.com>wrote:

>>>>>> Thanks for the plugin that worked great. I still don't understand how
>>>>>> to use pentaho though to encrypt social security numbers listed in the
>>>>>> access database.

>>>>>> > > #2 How do I take social security numbers that are currently
>>>>>> listed in
>>>>>> > > Microsoft Access with no encryption and put them into the MySQL
>>>>>> > > database encrypted?

>>>>>> > > Thanks for the help,

>>>>>> > > Steven

>>>> To unsubscribe from this group, send email to
>>>> cake-php+unsubscribe@googlegroups.com For more options, visit this
>>>> group at http://groups.google.com/group/cake-php

On Wednesday, May 2, 2012 3:03:46 PM UTC-5, Steven Scaffidi wrote:

> Can you give me a specific example of how to use saveMany? I have 4000
> clients in my database. Can I create another encrypted field in the
> database (say ssn_temp) then do something like this:

> $this->User->saveMany(array(array('ssn_temp' => array('User' => 'ssn'))));

> Would something like that work? I'm really confused by the documentation
> on saveMany

> On Tuesday, May 1, 2012 2:51:50 PM UTC-5, Justin Edwards wrote:

>> Sorry temp table* not temp folder

>> On Tue, May 1, 2012 at 7:51 PM, Justin Edwards <justinledwa...@gmail.com>wrote:

>>> Steven,

>>> Create a controller method.

>>> Find the data from the temp folder set it to a variable, and then
>>> saveMany from the variable to the encrypted table.

>>> http://book.cakephp.org/2.0/en/models/saving-your-data.html#model-sav...

>>> On Tue, May 1, 2012 at 7:18 PM, Steven Scaffidi <ssca...@gmail.com>wrote:

>>>> On Tuesday, May 1, 2012 2:07:56 PM UTC-5, Justin Edwards wrote:

>>>>> I would migrate it using pentaho. Then you can run cake's encryption
>>>>> function on the data. You could make a temporary table /model and then
>>>>> append it to the production table.

>>>>> On Tue, May 1, 2012 at 7:01 PM, Steven Scaffidi <ssca...@gmail.com>wrote:

>>>>>> Thanks for the plugin that worked great. I still don't understand how
>>>>>> to use pentaho though to encrypt social security numbers listed in the
>>>>>> access database.

>>>>>> > > #2 How do I take social security numbers that are currently
>>>>>> listed in
>>>>>> > > Microsoft Access with no encryption and put them into the MySQL
>>>>>> > > database encrypted?

>>>>>> > > Thanks for the help,

>>>>>> > > Steven

>>>> To unsubscribe from this group, send email to
>>>> cake-php+unsubscribe@googlegroups.com For more options, visit this
>>>> group at http://groups.google.com/group/cake-php

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy

Account Options