Dear useRs, I'm having a hard time installing RMySQL on a FC4 x86_64 box (R 2.1.0 and MySQL 4.1.11-2 installed through yum). After an initial configuration error ("could not find the MySQL installation include and/or library directories") I managed to install RMySQL with # export PKG_LIBS="-L</usr/lib64/mysql> -lmysqlclient" # R CMD INSTALL RMySQL_0.5-5.tar.gz
However, when I load the package I get this error: > require(RMySQL) Loading required package: RMySQL Loading required package: DBI Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library '/usr/lib64/R/library/RMySQL/libs/RMySQL.so': /usr/lib64/R/library/RMySQL/libs/RMySQL.so: undefined symbol: mysql_field_count [1] FALSE Can anyone offer a suggestion, or perhaps email me a precompiled binary? Thank you, b. platform "x86_64-redhat-linux-gnu" arch "x86_64" os "linux-gnu" system "x86_64, linux-gnu" status "" major "2" minor "1.0" year "2005" month "04" day "18" language "R" # yum list installed mysql Installed Packages mysql.i386 4.1.11-2 installed mysql.x86_64 4.1.11-2 installed ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html