[R] Problems Building RMySQL in Windows

[Prof Brian Ripley]

On Wed, 15 Oct 2003, "Héctor Villafuerte D." wrote:

> Hi all,
> Unfortunately I must use winXP at my job, so I'm trying install
> from source RMySQL. Here are some details about this problem:
> - R 1.7.1
> - RMySQL 0.5-2
> - mysql  4.1.0-alpha-max-nt
> I followed the instructions posted in 
> http://www.biostat.jhsph.edu/~kbroman/Rintro/Rwinpack.html
> and the following messages appeared. BTW, thanks in advance for your 
> help and comments.

It hasn't found the mysql entry points: have you built an import
library for the mysql client and is it in c:/mysql/lib/opt, for example.

Error messages very similar to these are covered 
in the README.windows file in the RMySQL package.

Please read the documentation in the RMySQL package and in the current
R for Windows relase (that web page is long out of date and I believe was 
never as accurate as the official documentation).

> 
> 
> C:\Program Files\R\rw1071\src\gnuwin32>make pkg-RMySQL
> 
> ---------- Making package RMySQL ------------
> 
>    **********************************************
>    WARNING: this package has a configure script
>          It probably needs manual configuration
>    **********************************************
> 
>   installing inst files
>   adding build stamp to DESCRIPTION
>   making DLL ...
> making RS-DBI.d from RS-DBI.c
> making RS-MySQL.d from RS-MySQL.c
> gcc  -Ic:/mysql/include  -IC:/PROGRA~1/R/rw1071/src/include -Wall -O2   
> -c RS-DBI.c -o RS-DBI.o
> gcc  -Ic:/mysql/include  -IC:/PROGRA~1/R/rw1071/src/include -Wall -O2   
> -c RS-MySQL.c -o RS-MySQL.o
> ar cr RMySQL.a *.o
> ranlib RMySQL.a
> windres --include-dir C:/PROGRA~1/R/rw1071/src/include  -i RMySQL_res.rc 
> -o RMySQL_res.o
> gcc  --shared -s  -o RMySQL.dll RMySQL.def RMySQL.a RMySQL_res.o  
> -LC:/PROGRA~1/R/rw1071/src/gnuwin32 -Lc:/mysql/lib/opt
>  -lmysql -liberty -lg2c -lR
> RMySQL.a(RS-MySQL.o)(.text+0x216):RS-MySQL.c: undefined reference to 
> `_mysql_get_client_info'
> RMySQL.a(RS-MySQL.o)(.text+0x7f9):RS-MySQL.c: undefined reference to 
> `_mysql_init'
> RMySQL.a(RS-MySQL.o)(.text+0x817):RS-MySQL.c: undefined reference to 
> `_mysql_options'
> RMySQL.a(RS-MySQL.o)(.text+0x879):RS-MySQL.c: undefined reference to 
> `_mysql_options'
> RMySQL.a(RS-MySQL.o)(.text+0x8e4):RS-MySQL.c: undefined reference to 
> `_load_defaults'
> RMySQL.a(RS-MySQL.o)(.text+0xb39):RS-MySQL.c: undefined reference to 
> `_mysql_real_connect'
> RMySQL.a(RS-MySQL.o)(.text+0xc3d):RS-MySQL.c: undefined reference to 
> `_mysql_close'
> RMySQL.a(RS-MySQL.o)(.text+0xd31):RS-MySQL.c: undefined reference to 
> `_mysql_options'
> RMySQL.a(RS-MySQL.o)(.text+0xde1):RS-MySQL.c: undefined reference to 
> `_mysql_close'
> RMySQL.a(RS-MySQL.o)(.text+0xf89):RS-MySQL.c: undefined reference to 
> `_mysql_query'
> RMySQL.a(RS-MySQL.o)(.text+0xfa4):RS-MySQL.c: undefined reference to 
> `_mysql_use_result'
> RMySQL.a(RS-MySQL.o)(.text+0xfbe):RS-MySQL.c: undefined reference to 
> `_mysql_field_count'
> RMySQL.a(RS-MySQL.o)(.text+0x106a):RS-MySQL.c: undefined reference to 
> `_mysql_affected_rows'
> RMySQL.a(RS-MySQL.o)(.text+0x10de):RS-MySQL.c: undefined reference to 
> `_mysql_error'
> RMySQL.a(RS-MySQL.o)(.text+0x116f):RS-MySQL.c: undefined reference to 
> `_mysql_fetch_fields'
> RMySQL.a(RS-MySQL.o)(.text+0x1188):RS-MySQL.c: undefined reference to 
> `_mysql_field_count'
> RMySQL.a(RS-MySQL.o)(.text+0x155c):RS-MySQL.c: undefined reference to 
> `_mysql_fetch_row'
> RMySQL.a(RS-MySQL.o)(.text+0x1576):RS-MySQL.c: undefined reference to 
> `_mysql_fetch_lengths'
> RMySQL.a(RS-MySQL.o)(.text+0x17c3):RS-MySQL.c: undefined reference to 
> `_mysql_errno'
> RMySQL.a(RS-MySQL.o)(.text+0x19e4):RS-MySQL.c: undefined reference to 
> `_mysql_errno'
> RMySQL.a(RS-MySQL.o)(.text+0x19ef):RS-MySQL.c: undefined reference to 
> `_mysql_error'
> RMySQL.a(RS-MySQL.o)(.text+0x1a64):RS-MySQL.c: undefined reference to 
> `_mysql_fetch_row'
> RMySQL.a(RS-MySQL.o)(.text+0x1a74):RS-MySQL.c: undefined reference to 
> `_mysql_free_result'
> RMySQL.a(RS-MySQL.o)(.text+0x1d1b):RS-MySQL.c: undefined reference to 
> `_mysql_get_client_info'
> RMySQL.a(RS-MySQL.o)(.text+0x1f4e):RS-MySQL.c: undefined reference to 
> `_mysql_get_host_info'
> RMySQL.a(RS-MySQL.o)(.text+0x1f78):RS-MySQL.c: undefined reference to 
> `_mysql_get_server_info'
> RMySQL.a(RS-MySQL.o)(.text+0x1fa5):RS-MySQL.c: undefined reference to 
> `_mysql_get_proto_info'
> RMySQL.a(RS-MySQL.o)(.text+0x1fb6):RS-MySQL.c: undefined reference to 
> `_mysql_thread_id'
> RMySQL.a(RS-MySQL.o)(.text+0x2c32):RS-MySQL.c: undefined reference to 
> `_mysql_fetch_lengths'
> RMySQL.a(RS-MySQL.o)(.text+0x2c59):RS-MySQL.c: undefined reference to 
> `_mysql_errno'
> RMySQL.a(RS-MySQL.o)(.text+0x2eda):RS-MySQL.c: undefined reference to 
> `_mysql_fetch_row'
> collect2: ld returned 1 exit status
> make[2]: *** [RMySQL.dll] Error 1
> make[1]: *** [src/RMySQL.dll] Error 2
> make: *** [pkg-RMySQL] Error 2
> 
> C:\Program Files\R\rw1071\src\gnuwin32>
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
> 
> 

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595