Message-ID: <CAK2H+ecmnuKikzm3r59gmVGjCuVEsNS6dfHEhwfKcApn5dfP4w@mail.gmail.com>
Date: 2014-10-29T20:20:34Z
From: Mark Knecht
Subject: RFC: quantmod::getSymbols.MySQL
In-Reply-To: <CAK2H+edoXza5WGYnWEqE-Gc8b7ZJPjybBpMYjqGi5TyRM5Fy3w@mail.gmail.com>
On Wed, Oct 29, 2014 at 7:36 AM, Mark Knecht <markknecht at gmail.com> wrote:
> On Wed, Oct 29, 2014 at 6:38 AM, Zachary Deane-Mayer
> <zach.mayer at gmail.com> wrote:
>> Hi Mark,
>>
>> It'd be a little cumbersome, but couldn't you also source() an R script at
>> the start of your session that loads the parameters from .my.cnf and passes
>> them to options()?
>>
>> Alternatively, maybe getSymbols.MySQL could look for a cnf_file option, and
>> then if that is not present look for a username and password?
>>
>> -Zach
>
> Hi Zach & Josh,
> Yes, I'm sure there's lots of ways to do this, and as an individual
> user just working by myself I'll be happy for anything that works.
>
> That said, the nice security feature about the way it was done
> before was TTBOMK the R environment never saw the MySQL username &
> password.
I've gone back and looked at my code only to find that R has never
TTBOMK looked at .my.cnf. I've confused this whole thing with an
earlier request that never gained traction.
My apologies for the noise.
- Mark