Re: [R] RGoogleDocs stopped working
t;>> > On Mon, Nov 15, 2010 at 12:16 PM, Harlan Harris >> >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
>>> >>> 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 >> >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)
>>> >>>
>>> &g
Re: [R] RGoogleDocs stopped working
No joy for me. :(
I'd had version 0.4-1 installed previously, and re-pulling that URL and
reinstalling, plus setting RCurlOptions as specified, do not help for me.
Exactly the same behavior. It doesn't matter whether I call getGoogleAuth
directly or let getGoogleDocsConnection do it for me.
-Harlan
On Fri, Nov 19, 2010 at 10:27 PM, Farrel Buchinsky wrote:
> 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("fjb...@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
>
>
On Fri, Nov 19, 2010 at 1:35 PM, Tal Galili wrote:
> I second Harlan's call.
>
>
> Contact
> Details:---
> Contact me: tal.gal...@gmail.com | 972-52-7275845
> Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) |
> www.r-statistics.com (English)
>
> --
>
>
>
>
> On Fri, Nov 19, 2010 at 5:00 PM, Harlan Harris wrote:
>
>> 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
>> 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 > >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
>> >>
>> >>
>> >>
>> >&
Re: [R] RGoogleDocs stopped working
Dear Farrel,
Now, using the most updated version of the packages, I was able to make your
example work for me - thank you very much for your help!
Best,
Tal
Contact
Details:---
Contact me: tal.gal...@gmail.com | 972-52-7275845
Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) |
www.r-statistics.com (English)
--
On Fri, Nov 19, 2010 at 10:27 PM, Farrel Buchinsky wrote:
> 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("fjb...@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]]
__
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.
Re: [R] RGoogleDocs stopped working
I second Harlan's call. Contact Details:--- Contact me: tal.gal...@gmail.com | 972-52-7275845 Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) | www.r-statistics.com (English) -- On Fri, Nov 19, 2010 at 5:00 PM, Harlan Harris wrote: > 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 > 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 >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 > >>> 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 >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: getGoogleDocsCon
Re: [R] RGoogleDocs stopped working
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 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 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
>>> 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 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"
>>> ExpiresDate
>>&
Re: [R] RGoogleDocs stopped working
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 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
>> 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 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"
>> ExpiresDate
>> 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] "
>> htt
Re: [R] RGoogleDocs stopped working
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
> 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 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"
> ExpiresDate
> 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', '
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 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"
> ExpiresDate
> 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 NANA
> 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.
__
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.
