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]]
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 11/10/10 7:36 AM, Harlan Harris 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 at 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.
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]]
Harlan and Tal have had problems. I had lots too. I spent hours getting it
to work. Terrible process to go through but RGoogleDocs is so useful that
the time was worth it - I think!
My problems were overcome when
1. I used the latest zip file by Duncan Temple Lang see below
2. I inserted an options line that loosened the ssl security - do not
know if that was a good thing or not but it got it to work
Duncan said:
"I have put an updated version of the source of the package with
these changes. It is available from
http://www.omegahat.org/RGoogleDocs/RGoogleDocs_0.4-1.tar.gz
There is a binary for Windows in
http://www.omegahat.org/RGoogleDocs/RGoogleDocs_0.4-1.zip
Here is my script that works. Does yours look like this?
library(RGoogleDocs)
packageDescription("RGoogleDocs")
ps <-readline(prompt="get the password in ")
options(RCurlOptions = list(capath = system.file("CurlSSL",
"cacert.pem",
package = "RCurl"), ssl.verifypeer = FALSE))
sheets.con = getGoogleDocsConnection(getGoogleAuth("fjbuch@gmail.com",
ps,
service ="wise"))
ts2=getWorksheets("OnCall",sheets.con) #OnCall is just the name of a
spreadsheet
names(ts2)
y2005<-sheetAsMatrix(ts2$y2005,header=TRUE, as.data.frame=TRUE, trim=TRUE)
Finally, I am willing to offer you a TeamViewer session where we can take
control of one another's computers and see if the problem is code or the
installation. I warn you that I am neither a programmer nor a developer,
just a very enthusiastic RGoogleDocs user who probably perseveres more than
is good for him.
Farrel Buchinsky
[[alternative HTML version deleted]]
Reasonably Related Threads
- RGoogleDocs not working for me with "wise" service
- RGoogleDocs: getDocs() - "problems connecting to get the list of documents"
- RGoogleDocs
- RGoogleDocs ability to write to spreadsheets broken as of yesterday - CAN PAY FOR FIX
- RGoogleDocs ability to write to spreadsheets broken as of yesterday