Hello Ramiro, I am still not sure why do you need to encrypt/decrypt data in R. One can encrypt/decrypt data in the SQL server side.
https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html If your concern is on the web traffic, again, sql servers supports SSL http://dev.mysql.com/doc/refman/5.1/en/ssl-connections.html I think RMySQL can connect via SSL. Also you may consider RCurl to talk to your php code. Best, -m On 9 January 2013 21:54, Ramiro Barrantes <ram...@precisionbioassay.com> wrote: > Dear Suzen, > > Thank you for your reply. What I meant was that some fields in the database > will be encrypted (the data for those fields will be entered via php web > interface and then encrypted and stored on the mysql db), and then I will use > R to read such database and do appropriate post-processing, which will then > need to be encrypted and stored into the mysql db (with R hopefully). In > other words, I have a shared mysql database with some encrypted fields, and I > need R and php to both understand the encryption/decryption. > > I thought this would be an appropriate question for the group as perhaps > someone might know of an R encrypt/decrypt mechanism that also has a > counterpart on php or has suggestions about the situation. Sorry for the > confusion in my question. > > Thank you, > Ramiro > > > > > ________________________________________ > From: mehmet.su...@gmail.com [mehmet.su...@gmail.com] on behalf of Suzen, > Mehmet [msu...@gmail.com] > Sent: Wednesday, January 09, 2013 3:38 PM > To: Ramiro Barrantes > Cc: r-help@r-project.org > Subject: Re: [R] R encrypt/decrypt > > On 9 January 2013 18:59, Ramiro Barrantes <ram...@precisionbioassay.com> > wrote: >> I am working on a web system (php) that uses R in the backend, and we need >> some basic fast encryption/decryption for the underlying mysql database that >> can be used by both R AND php. It does not need to be top-of-the-line, but >> just provide some basic level of fast encryption/decryption. >> >>> Any suggestions? > > Sounds too generic. This is not really an R-help question. > Not sure what do you mean by underlying mysql. Are you going to > encrypt data into db? If it > is about transport between sql and web servers: these servers can be > configured to use SSL! > What is your aim? > > BTW: Maybe you should remove php and use R directly via Rook; > http://cran.r-project.org/web/packages/Rook/index.html ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
