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 <dun...@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 <har...@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]]
______________________________________________
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.
