CODEWITHSUNDEEP
rsqldf
Max van der Heijden
Max van der Heijden

Reputation: 1125

Unable to install sqldf on Linux

I'm running R version 2.14.1 on Linux. When I try to install sqldf with

install.packages(sqldf, dependencies=TRUE)

I get the following errors: (these errors result in running the command from the terminal as with the use of the Rcmdr UI)

open log here

I can't seem to find someone with a similar problem. If I run the install command on a Windows PC, it installs without any problems.

Upvotes: 3

Views: 2530

Answers (3)

Pepe Alvarez
Pepe Alvarez

Reputation: 1624

I just did almost almost what you had but with "sqldf" in the interactive R terminal and everything went ok

install.packages("sqldf", dependencies=TRUE)

Upvotes: 0

Max van der Heijden
Max van der Heijden

Reputation: 1125

Installed libpq-dev, MySQL, reinstalled JAVA and updated R to the latest version. SQLdf is now working like a charm. Thanks for the heads up everybody.

Upvotes: 0

csgillespie
csgillespie

Reputation: 60462

You error log has the line:

In file included from RS-PQescape.c:7:0:
RS-PostgreSQL.h:23:26: fatal error: libpq-fe.h: No such file or directory
compilation terminated.
make: *** [RS-PQescape.o] Error 1

Try installing the libpq-dev package for your particular linux distribution.

As an aside, when you get an error like this, it's fairly clear that libpq-fe.h is missing. Just type libpq-fe.h ubuntu into google to see what package you need to install.

Upvotes: 6

Related Questions