Wednesday, May 2, 2012

Re: Cakephp SSN Encryption

You can do it in batches.  You can also set the timeout.  http://php.net/manual/en/function.set-time-limit.php

'conditions' => array('User.id <' => '200')

On Wed, May 2, 2012 at 3:39 PM, Steven Scaffidi <sscaff1@gmail.com> wrote:
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 <justinledwards@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.   




On Tue, May 1, 2012 at 7:18 PM, Steven Scaffidi <sscaff1@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 <sscaff1@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...
> #2http://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 For more options, visit this group
> > athttp://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

--
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 <justinledwards@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.   




On Tue, May 1, 2012 at 7:18 PM, Steven Scaffidi <sscaff1@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 <sscaff1@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...
> #2http://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 For more options, visit this group
> > athttp://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

--
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 <justinledwards@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.   




On Tue, May 1, 2012 at 7:18 PM, Steven Scaffidi <sscaff1@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 <sscaff1@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...
> #2http://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 For more options, visit this group
> > athttp://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

--
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 <justinledwards@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.   




On Tue, May 1, 2012 at 7:18 PM, Steven Scaffidi <sscaff1@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 <sscaff1@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...
> #2http://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 For more options, visit this group
> > athttp://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

--
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


--
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

--
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

posted by twitter @ 2:02 PM   0 Comments

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home


Real Estate