Database Encryption

[dave1167]

Hi

I am writing an application in J1.6 which will store peoples names and addresses the client wants the names and addresses encrypted. Is there any easy way to do this ? i.e. any built in encryption routines I can call or is this quite a complicated process ? There would probably be only one table to encrypt

Regards Dave

[3dgtech]

Whatever encryption you use, keep in mind that you will need to provide decoding to any core function that needs acces to these fields.

[3dgtech]

I have used php mcrypt on the php level
And AES_ENCRYPT on the mysql level.
If anyone knows any joomla API calls please enlighten...

[dave1167]

thanks 3dg

I have just found JSimpleCrypt which may be what I am looking for. The level of encryption does not need to be that high so this may do the trick. I will experiment and report back

[3dgtech]

Great let us know how it is getting seeded...

[3dgtech]

(if at all)

[nicolasbzh]

Hi,

I use ACYmailing and would like to encrypt names and email addresses in the database. So I am very interesting in your solution as your problem was similar.

Thanks
Nico

[budiperkasa]

Wow, that's a big idea, but how about SQL Performance ? could your extensions give a heavy load to SQL data-base or completely no ?

Thanks