Thanks, Duncan. Finally getting a chance to follow up on this...

I tried again, changing and resetting my password, and trying to specify my
login and password manually in the getGoogleDocsConnection argument list. I
also tried removing either or both of the service and error options. No luck
in any case. I also tried a different Google account, also with no luck.

I've also tried tweaking the URL being generated by the code, and in all
cases, I get a 403: Forbidden error with content "Error=BadAuthentication".

I don't really know enough about how authentication is supposed to work to
get much farther. Can you help? Should I try the Google API forum instead?

 -Harlan



> From: Duncan Temple Lang <duncan@wald.ucdavis.edu>
> To: r-help@r-project.org
> Date: Wed, 10 Nov 2010 10:33:47 -0800
> Subject: Re: [R] RGoogleDocs stopped working
>
> Hi Harlan
>
>  I just tried to connect to Google Docs and I had ostensibly the same
> problem.
> However, the password was actually different from what I had specified.
> After resetting it with GoogleDocs, the getGoogleDocsConnection() worked
> fine. So I don't doubt that the login and password are correct, but
> you might just try it again to ensure there are no typos.
> The other thing to look at is the values for Email and Passwd
> sent in the URL, i.e. the string in url in your debugging
> below. (Thanks for that by the way). If either has special characters,
> e.g. &, it is imperative that they are escaped correctly, i.e. converted
> to %24.  This should happen and nothing should have changed, but it is
> worth verifying.
>
>  So things still seem to work for me. It is a data point, but not one
> that gives you much of a clue as to what is wrong on your machine.
>
>  D.
>

On Wed, Nov 10, 2010 at 10:36 AM, Harlan Harris <harlan@harris.name> wrote:

> Hello,
>
> Some code using RGoogleDocs, which had been working smoothly since the
> summer, just stopped working. I know that it worked on November 3rd, but it
> doesn't work today. I've confirmed that the login and password still work
> when I log in manually. I've confirmed that the URL gives the same error
> when I paste it into Firefox. I don't know enough about this web service to
> figure out the problem myself, alas...
>
> Here's the error and other info (login/password omitted):
>
> > ss.con <- getGoogleDocsConnection(login=gd.login, password=gd.password,
> service='wise', error=FALSE)
> Error: Forbidden
>
> Enter a frame number, or 0 to exit
>
> 1: getGoogleDocsConnection(login = gd.login, password = gd.password,
> service = "wise", error = FALSE)
> 2: getGoogleAuth(..., error = error)
> 3: getForm("https://www.google.com/accounts/ClientLogin", accountType =
> "HOSTED_OR_GOOGLE", Email = login, Passw
> 4: getURLContent(uri, .opts = .opts, .encoding = .encoding, binary =
> binary, curl = curl)
> 5: stop.if.HTTP.error(http.header)
>
> Selection: 4
> Called from: eval(expr, envir, enclos)
> Browse[1]> http.header
>                    Content-Type
> Cache-control                          Pragma
>                    "text/plain"            "no-cache,
> no-store"                      "no-cache"
>                         Expires                            Date
> X-Content-Type-Options
> "Mon, 01-Jan-1990 00:00:00 GMT" "Wed, 10 Nov 2010 15:24:39
> GMT"                       "nosniff"
>                X-XSS-Protection
> Content-Length                          Server
>                 "1; mode=block"
> "24"                           "GSE"
>                          status                   statusMessage
>                           "403"                 "Forbidden\r\n"
> Browse[1]> url
> [1] "
> https://www.google.com/accounts/ClientLogin?accountType=HOSTED%5FOR%5FGOOGLE&Email=***&Passwd=***&service=wise&source=R%2DGoogleDocs%2D0%2E1
> "
> Browse[1]> .opts
> $ssl.verifypeer
> [1] FALSE
>
>
> > R.Version()
> $platform
> [1] "i386-apple-darwin9.8.0"
>
> $arch
> [1] "i386"
>
> $os
> [1] "darwin9.8.0"
>
> $system
> [1] "i386, darwin9.8.0"
>
> $status
> [1] ""
>
> $major
> [1] "2"
>
> $minor
> [1] "10.1"
>
> $year
> [1] "2009"
>
> $month
> [1] "12"
>
> $day
> [1] "14"
>
> $`svn rev`
> [1] "50720"
>
> $language
> [1] "R"
>
> $version.string
> [1] "R version 2.10.1 (2009-12-14)"
>
>
> > installed.packages()[c('RCurl', 'RGoogleDocs'), ]
>             Package
> LibPath                                             Version Priority Bundle
> Contains
> RCurl       "RCurl"
> "/Users/hharris/Library/R/2.10/library"             "1.4-3" NA       NA
> NA
> RGoogleDocs "RGoogleDocs"
> "/Library/Frameworks/R.framework/Resources/library" "0.4-1" NA       NA
> NA
>             Depends                         Imports LinkingTo
> Suggests       Enhances OS_type License Built
> RCurl       "R (>= 2.7.0), methods, bitops" NA      NA
> "Rcompression" NA       NA      "BSD"   "2.10.1"
> RGoogleDocs "RCurl, XML, methods"           NA      NA
> NA             NA       NA      "BSD"   "2.10.1"
>
>
> Any ideas? Thank you!
>
>  -Harlan
>
>

	[[alternative HTML version deleted]]

