Report of failure with installation of MonetDB.R
The error message looks as if you need /bin on the end of the path: it's looking for /usr/local/monetdb/mserver5 but the file is probably /usr/local/monetdb/bin/mserver5 Personally, I start the server from the Terminal command line, per http://www.monetdb.com/Documentation/monetdbd First time only /usr/local/monetdb/bin/monetdbd create ~/my-dbfarm Subsequent times: Before starting R /usr/local/monetdb/bin/monetdbd start ~/my-dbfarm After exiting R /usr/local/monetdb/bin/monetdbd start ~/my-dbfarm -thomas
On Wed, May 7, 2014 at 2:53 PM, David Winsemius <dwinsemius at comcast.net> wrote:
Dear Hannes or anybody; I did not find any pages (despite searching) for the installation process of MonetDB on a Mac. I'm currently running MacOS 10.7.5 and R 3.1.0 Patched (2014-04-21 r65431) -- "Spring Dance". There is a source package for MonetDB at: https://www.monetdb.org/downloads/MacOSX/Jan2014-SP1/MonetDB-11.17.13-x86_64-Darwin-9-bin.tar.bz2 It's home page has direction for installation on Linux and PC but makes no mention of Macs. Downloading that file resulted in a couple of automatic steps and the creation in my ~/Download/ directory of a hierarchy of usr2/local/monetdb Reading the MacOS R-FAQ in "For R.app you may need to add e.g. /usr/local/bin and it is usually most convenient to use command-line R." Reasoning that the files in monetdb should actually go into usr/local/ I dragged them to that location with Finder.app, and authenticated when requested. (This process failed and I am now looking for instruction on properly installing on a Mac. Is this page going to lead me on the path of righteousness? https://developer.apple.com/library/mac/documentation/porting/conceptual/portingunix/compiling/compiling.html My reading of Mac-SIG leads me to believe that using MacPorts will not be a stable strategy for interaction with R. -- David. ========= failed efforts recorded below ================== I installed MonetDB.R from R.app using the Package installation dialog with "install dependencies" checked. library(MonetDB.R) # succeeded without complaint and reported: Loading required package: DBI Loading required package: digest help(package="MonetDB.r") # Trying the Example code in monetdb.server.setup
startscript <- monetdb.server.setup("/tmp/database","/usr/local/monetdb/", "db1", 50001)
pid <- monetdb.server.start(startscript)
/private/tmp/database/db1.sh: line 2: /usr/local/monetdb/mserver5: No such file or directory Read 1 item
monetdb.server.stop(pid)
/bin/sh: line 0: kill: (22661) - No such process
conn <- dbConnect(MonetDB.R(), "monetdb://localhost:50001/db1")
Error in .local(drv, ...) : Could not connect to localhost:50001 Then tried the code on the help page for 'MonetDB.R-package'
conn <- dbConnect(MonetDB.R(), "monetdb://localhost/demo")
Error in .local(drv, ...) : Could not connect to localhost:50000
dbListTables(conn)
Error in is(object, Cl) : error in evaluating the argument 'conn' in selecting a method for function 'dbListTables': Error: object 'conn' not found
data(iris) dbWriteTable(conn, "iris", iris)
Error in is(object, Cl) : error in evaluating the argument 'conn' in selecting a method for function 'dbWriteTable': Error: object 'conn' not found
dbGetQuery(conn, "SELECT COUNT(*) FROM iris;")
Error in dbGetQuery(conn, "SELECT COUNT(*) FROM iris;") : error in evaluating the argument 'conn' in selecting a method for function 'dbGetQuery': Error: object 'conn' not found
d <- dbReadTable(conn, "iris")
Error in is(object, Cl) : error in evaluating the argument 'conn' in selecting a method for function 'dbReadTable': Error: object 'conn' not found So obviously there is something about this client server setup that I have not done properly or understood how to access. I've been through the R-FAQ many times and still do not understand the issues surrounding the use of homebrew and MacPorts. It's something to do with binary files in the right places and I fear this is another instance of such failure. (I'm also unable to scroll the Mac-FAQ to see the end of the file when the window is wider than about 60 characters.) -- David Winsemius Alameda, CA, USA
_______________________________________________ R-SIG-Mac mailing list R-SIG-Mac at r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-mac
Thomas Lumley Professor of Biostatistics University of Auckland