Themenwahl

Freitag, 17 November 2017 16:15

RMySQL

geschrieben von
Artikel bewerten
(0 Stimmen)

Unter Ubuntu muss der MariaDB Client installiert werden:

jmz@Linux-Server:~$ sudo -s

[sudo] Passwort für jmz:

root@Linux-Server:~# apt-get install libmariadb-client-lgpl-dev
 
Anschliessend wird R gestartet:
 
R
 
Dann wird in R-Crane folgender Befehlt für die Installation der MySQL Librarry durchgeführt. Hier die Konsolenausgabe:
 

> install.packages("RMySQL")
Installiere Paket nach ‘/usr/local/lib/R/site-library’
(da ‘lib’ nicht spezifiziert)
versuche URL 'https://cran.uni-muenster.de/src/contrib/RMySQL_0.10.9.tar.gz'
Content type 'application/x-gzip' length 54012 bytes (52 KB)
==================================================
downloaded 52 KB

* installing *source* package ‘RMySQL’ ...
** Paket ‘RMySQL’ erfolgreich entpackt und MD5 Summen überprüft
Found mysql_config cflags and libs!
Using PKG_CFLAGS=-I/usr/include/mariadb -g -O2 -fstack-protector-strong -Wformat -Werror=format-s ecurity -D_FORTIFY_SOURCE=2 -Wunused -Wno-uninitialized
Using PKG_LIBS=-L/usr/lib/x86_64-linux-gnu -lmariadb
** libs
gcc -std=gnu99 -I/usr/share/R/include -DNDEBUG -I/usr/include/mariadb -g -O2 -fstack-protector-st rong -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2 -Wunused -Wno-uninitialized -fpic -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -Wdate-time -D_FORTIFY_SOURCE=2 -g -c RMySQL-init.c -o RMySQL-init.o
gcc -std=gnu99 -I/usr/share/R/include -DNDEBUG -I/usr/include/mariadb -g -O2 -fstack-protector-st rong -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2 -Wunused -Wno-uninitialized -fpic -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -Wdate-time -D_FORTIFY_SOURCE=2 -g -c connection.c -o connection.o
gcc -std=gnu99 -I/usr/share/R/include -DNDEBUG -I/usr/include/mariadb -g -O2 -fstack-protector-st rong -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2 -Wunused -Wno-uninitialized -fpic -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -Wdate-time -D_FORTIFY_SOURCE=2 -g -c db-apply.c -o db-apply.o
gcc -std=gnu99 -I/usr/share/R/include -DNDEBUG -I/usr/include/mariadb -g -O2 -fstack-protector-st rong -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2 -Wunused -Wno-uninitialized -fpic -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -Wdate-time -D_FORTIFY_SOURCE=2 -g -c driver.c -o driver.o
gcc -std=gnu99 -I/usr/share/R/include -DNDEBUG -I/usr/include/mariadb -g -O2 -fstack-protector-st rong -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2 -Wunused -Wno-uninitialized -fpic -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -Wdate-time -D_FORTIFY_SOURCE=2 -g -c exception.c -o exception.o
gcc -std=gnu99 -I/usr/share/R/include -DNDEBUG -I/usr/include/mariadb -g -O2 -fstack-protector-st rong -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2 -Wunused -Wno-uninitialized -fpic -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -Wdate-time -D_FORTIFY_SOURCE=2 -g -c fields.c -o fields.o
gcc -std=gnu99 -I/usr/share/R/include -DNDEBUG -I/usr/include/mariadb -g -O2 -fstack-protector-st rong -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2 -Wunused -Wno-uninitialized -fpic -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -Wdate-time -D_FORTIFY_SOURCE=2 -g -c result.c -o result.o
gcc -std=gnu99 -I/usr/share/R/include -DNDEBUG -I/usr/include/mariadb -g -O2 -fstack-protector-st rong -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2 -Wunused -Wno-uninitialized -fpic -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -Wdate-time -D_FORTIFY_SOURCE=2 -g -c utils.c -o utils.o
gcc -std=gnu99 -shared -L/usr/lib/R/lib -Wl,-Bsymbolic-functions -Wl,-z,relro -o RMySQL.so RMySQL -init.o connection.o db-apply.o driver.o exception.o fields.o result.o utils.o -L/usr/lib/x86_64- linux-gnu -lmariadb -L/usr/lib/R/lib -lR
installing to /usr/local/lib/R/site-library/RMySQL/libs
** R
** preparing package for lazy loading
** help
*** installing help indices
** building package indices
** testing if installed package can be loaded
* DONE (RMySQL)

Die heruntergeladenen Quellpakete sind in
‘/tmp/Rtmpu2AaXI/downloaded_packages’
> library(RMySQL)


Gelesen 25 mal Letzte Änderung am Freitag, 17 November 2017 16:15

Schreibe einen Kommentar

Bitte achten Sie darauf, alle Felder mit Stern * zu füllen. HTML-Code ist nicht erlaubt.