search

bmaitner / RBIEN

Tools for accessing the Botanical Information and Ecology Network (BIEN) database
http://bien.nceas.ucsb.edu/bien/
Other
43 stars 10 forks source link

Error in postgresqlNewConnection #10

Open julianastropp opened 6 years ago

julianastropp commented 6 years ago

I'm trying to use the R package BIEN to retrieve information of species traits.

However, I'm getting the following error message:

Error in postgresqlNewConnection(drv, ...) : RS-DBI driver: (could not connect public_bien@vegbiendev.nceas.ucsb.edu:5432 on dbname "public_vegbien": could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "vegbiendev.nceas.ucsb.edu" (128.111.84.31) and accepting TCP/IP connections on port 5432?

Could you kindly let me know how to solve this problem?

Thank you very much,

mcgregorian1 commented 5 years ago

From vignette("BIEN")

Database connection issues

Some institution and computer programs (e.g. some antivirus programs) block the SQL connections that this package relies on. While we are exploring ways around this issue, at present the simplest method is to use the package on a computer/network that doesn’t block SQL connections.