I solved the problem, R studio was installing libraries in places which were not visible for some reason when R was started from php. I just reinstalled (I had tried that before) RMySQL at a the right place and it works now.
Christoph ________________________________________ From: [email protected] [[email protected]] on behalf of Christoph Knapp [[email protected]] Sent: Friday, January 27, 2012 13:21 To: [email protected] Subject: [R-sig-Debian] php and RMySQL produces R crash Hi all, I have a very strange problem with the RMySql package. I'm running linux ubuntu 64 bit and R 2.14. I'm trying to solve this now for a week and could not find anything helpful on the net. Now the problem If I start my R script from php (script attached) the output is as followed Start R Script from php R version 2.14.1 (2011-12-22) Copyright (C) 2011 The R Foundation for Statistical Computing ISBN 3-900051-07-0 Platform: x86_64-pc-linux-gnu (64-bit) R is free software and comes with ABSOLUTELY NO WARRANTY. You are welcome to redistribute it under certain conditions. Type 'license()' or 'licence()' for distribution details. R is a collaborative project with many contributors. Type 'contributors()' for more information and 'citation()' on how to cite R or R packages in publications. Type 'demo()' for some demos, 'help()' for on-line help, or 'help.start()' for an HTML browser interface to help. Type 'q()' to quit R. > print(try(library(RMySQL))) [1] "Error in library(RMySQL) : there is no package called 'RMySQL'\n" attr(,"class") [1] "try-error" attr(,"condition") > cat("running R script\n") running R script It fails to load the library RMySQL. if I start my R script from terminal with the same command used in php christoph@dell-desktop:~/Desktop$ R -f "reproduceProblem.R" R version 2.14.1 (2011-12-22) Copyright (C) 2011 The R Foundation for Statistical Computing ISBN 3-900051-07-0 Platform: x86_64-pc-linux-gnu (64-bit) R is free software and comes with ABSOLUTELY NO WARRANTY. You are welcome to redistribute it under certain conditions. Type 'license()' or 'licence()' for distribution details. Natural language support but running in an English locale R is a collaborative project with many contributors. Type 'contributors()' for more information and 'citation()' on how to cite R or R packages in publications. Type 'demo()' for some demos, 'help()' for on-line help, or 'help.start()' for an HTML browser interface to help. Type 'q()' to quit R. > print(try(library(RMySQL))) Loading required package: DBI [1] "RMySQL" "DBI" "stats" "graphics" "grDevices" "utils" [7] "datasets" "methods" "base" > cat("running R script\n") running R script > it works If I use require instead of library it returns FALSE and R crashes when the database connection is made and the code also loads the DBI package. I assume this is because RMySQL is never loaded but DBI. Any ideas why R can not load RMySQL when started from a php script but otherwise there is no problem? I attached two small scripts which reproduce the problem for me. Any help is much appreciated. Christoph _______________________________________________ R-SIG-Debian mailing list [email protected] https://stat.ethz.ch/mailman/listinfo/r-sig-debian
