Following up again. I found on the forums for the Google Apps API this
thread that seems to be about a similar issue:
http://www.google.com/support/forum/p/apps-apis/thread?tid=1c22cb44eb5cbba6&hl=en&search_impression_id=ab161b010ecf8803%3A12c5a65ce83&search_source=related_question
It's using Java and is rather over my head, but it seems to suggest that
something related to the content type might be wrong? Does this offer any
suggestions on how to fix my use of RGoogleDocs?
Thanks,
-Harlan
On Mon, Nov 15, 2010 at 12:16 PM, Harlan Harris <har...@harris.name> wrote:
> 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.
