Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

getSRAdbFile() error, cannot download file #10

Closed
jakeyeung opened this issue Sep 6, 2017 · 17 comments
Closed

getSRAdbFile() error, cannot download file #10

jakeyeung opened this issue Sep 6, 2017 · 17 comments

Comments

@jakeyeung
Copy link

Hello, I am unable to run the getSRAdbFile() function. It appears the 3 links to download the sqlite file are broken.

srafile = getSRAdbFile()

trying URL 'http://dl.dropbox.com/u/51653511/SRAmetadb.sqlite.gz'
Error in download.file(url_sra, destfile = localfile, mode = "wb", method = method) :
  cannot open URL 'http://dl.dropbox.com/u/51653511/SRAmetadb.sqlite.gz'

The other urls also do not work

    url_sra_1 = "http://gbnci.abcc.ncifcrf.gov/backup/SRAmetadb.sqlite.gz"
    url_sra_2 = "http://watson.nci.nih.gov/~zhujack/SRAmetadb.sqlite.gz"
    url_sra_3 = "http://dl.dropbox.com/u/51653511/SRAmetadb.sqlite.gz"

Thanks in advance.

Jake

@seandavi
Copy link
Owner

seandavi commented Sep 7, 2017

Can you give this a try again? I was able to use the first URL (which is now supposed to be pretty stable). If this doesn't work for you in R, can you try simply downloading using a browser?

@jakeyeung
Copy link
Author

Downloading using a browser still gives me a 404 not found. It looks like others have the same problem (Issue #11).

@seandavi
Copy link
Owner

seandavi commented Sep 13, 2017

@jakeyeung, I am going to move this over to #11, so I'll close this one for now. If, once we get a solution in place you are still having problems, we can reopen this. Thanks for the patience and for reporting the problem.

@modarzi
Copy link

modarzi commented Apr 11, 2018

Hi,
I install SRAdb but when I run sqlfile <- getSRAdbFile() , I see below error:

Error in download.file(url_sra, destfile = localfile, mode = "wb", method = method) :
cannot open URL 'http://watson.nci.nih.gov/~zhujack/SRAmetadb.sqlite.gz'

I appricite if you guide me for solving this problem.
Best Regards,
Mohammad

@seandavi
Copy link
Owner

Hi, @modarzi. Upgrading R to at least version 3.4 and then reinstalling SRAdb should get things working again. Alternatively, you can download by hand using the links here:

https://github.com/seandavi/SRAdb/blob/master/README.md#raw-database-downloads

@modarzi
Copy link

modarzi commented Apr 11, 2018

Hi,@seandavi. I upgrade R to latest version but again I see below error:

Error in download.file(url_sra, destfile = localfile, mode = "wb", method = method) :
cannot open URL 'http://watson.nci.nih.gov/~zhujack/SRAmetadb.sqlite.gz'

For your second solution, is it possible to explain more.in other words which files should I download and how can I read it in my Rstudio?
Best Regards,
Mohammad

@seandavi
Copy link
Owner

You'll need to upgrade SRAdb also.

biocLite('SRAdb')

If that doesn't work, could you open a new issue and post the output of sessionInfo()?

Sorry for the inconvenience.

@AIRibone
Copy link

AIRibone commented Jul 2, 2018

Hi, same problem here

R 3.4

srafile=getSRAdbFile()
trying URL 'http://dl.dropbox.com/u/51653511/SRAmetadb.sqlite.gz'
Error in download.file(url_sra, destfile = localfile, mode = "wb", method = method) :
  cannot open URL 'http://dl.dropbox.com/u/51653511/SRAmetadb.sqlite.gz'

@seandavi
Copy link
Owner

seandavi commented Jul 2, 2018

@AIRibone, could you post the output of sessionInfo() after loading SRAdb? In the meantime, the download link for SRAdb is on the README for this repo.

@Diwadkar
Copy link

Diwadkar commented Jul 3, 2018

I am having the same problem.
screen shot 2018-07-03 at 2 14 05 pm
screen shot 2018-07-03 at 2 14 13 pm

@AIRibone
Copy link

AIRibone commented Jul 3, 2018

Hi!
I downloaded the SRAdb using biocLite("SRAdb")

> library(SRAdb)
Loading required package: RSQLite
Loading required package: graph
Loading required package: RCurl
Loading required package: bitops
Setting options('download.file.method.GEOquery'='auto')
Setting options('GEOquery.inmemory.gpl'=FALSE)
>
>
> sessionInfo()
R version 3.4.4 (2018-03-15)
Platform: x86_64-pc-linux-gnu (64-bit)
Running under: Ubuntu 16.04.4 LTS

Matrix products: default
BLAS: /usr/lib/libblas/libblas.so.3.6.0
LAPACK: /usr/lib/lapack/liblapack.so.3.6.0

locale:
 [1] LC_CTYPE=en_US.UTF-8       LC_NUMERIC=C              
 [3] LC_TIME=en_US.UTF-8        LC_COLLATE=en_US.UTF-8    
 [5] LC_MONETARY=en_US.UTF-8    LC_MESSAGES=en_US.UTF-8   
 [7] LC_PAPER=en_US.UTF-8       LC_NAME=C                 
 [9] LC_ADDRESS=C               LC_TELEPHONE=C            
[11] LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C       

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] SRAdb_1.28.1    RCurl_1.95-4.10 bitops_1.0-6    graph_1.48.0   
[5] RSQLite_2.1.1  

loaded via a namespace (and not attached):
 [1] Rcpp_0.12.17        XML_3.98-1.11       digest_0.6.15      
 [4] DBI_1.0.0           stats4_3.4.4        blob_1.1.1         
 [7] tools_3.4.4         bit64_0.9-7         Biobase_2.30.0     
[10] bit_1.1-14          parallel_3.4.4      compiler_3.4.4     
[13] BiocGenerics_0.16.1 memoise_1.1.0       GEOquery_2.36.0 

@Diwadkar
Copy link

Diwadkar commented Jul 3, 2018

Yes, it worked when I upgraded to R 3.4 and also updated biocLite(). Thank you!

@seandavi
Copy link
Owner

seandavi commented Jul 3, 2018

Awesome! Thanks for the patience....

@vpdesai2020
Copy link

install.packages("SRAdb")
Installing package into ‘/home/desai/R/x86_64-pc-linux-gnu-library/3.4’
(as ‘lib’ is unspecified)
Warning in install.packages :
package ‘SRAdb’ is not available (for R version 3.4.4)

@seandavi
Copy link
Owner

@vpdesai2020, SRAdb is a Bioconductor package.

install.packages("BiocManager")
BiocManager::install("SRAdb")

@maciematt
Copy link

Unfortunately, looks like this issue has made a return. I've just installed SRAdb, and tried running srafile <- SRAdb::getSRAdbFile() - here's the resulting error message:

> srafile <- SRAdb::getSRAdbFile() 
trying URL 'https://gbnci-abcc.ncifcrf.gov/backup/SRAmetadb.sqlite.gz' Error in download.file(url_sra, destfile = localfile, mode = "wb", method = method) :
    cannot open URL 'https://gbnci-abcc.ncifcrf.gov/backup/SRAmetadb.sqlite.gz'
> 

@kowshikasarker
Copy link

kowshikasarker commented Sep 22, 2022

I installed SRAdb on MacOS and tried getSRAdbFile(), but it's not working.
getSRAdbFile() trying URL 'https://gbnci-abcc.ncifcrf.gov/backup/SRAmetadb.sqlite.gz' Error in download.file(url_sra, destfile = localfile, mode = "wb", method = method) : cannot open URL 'https://gbnci-abcc.ncifcrf.gov/backup/SRAmetadb.sqlite.gz'

I tried to directly download from the following two links using curl, but none worked.

curl https://s3.amazonaws.com/starbuck1/sradb/SRAmetadb.sqlite.gz curl https://gbnci-abcc.ncifcrf.gov/backup/SRAmetadb.sqlite.gz

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

8 participants