Any new thoughts on this? I really want to get this working again! Is there someone else that can help or somewhere else I should be asking?
Thanks! -Harlan On Wed, Nov 17, 2010 at 10:16 AM, Harlan Harris <har...@harris.name> wrote: > 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.