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 20815 mal Letzte Änderung am Freitag, 17 November 2017 16:15

251 Kommentare

  • Kommentar-Link Chante Mittwoch, 20 Januar 2021 23:23 gepostet von Chante

    Undeniably believe that which you stated. Your favorite reason appeared
    to be on the web the easiest thing to be aware of. I say to you,
    I certainly get annoyed while people think about worries that they
    plainly don't know about. You managed to hit the nail upon the top and defined
    out the whole thing without having side effect , people can take a signal.
    Will likely be back to get more. Thanks

  • Kommentar-Link s128.net Mittwoch, 20 Januar 2021 22:20 gepostet von s128.net

    Yes! Finally something about s128.

  • Kommentar-Link Jvcbximmus Mittwoch, 20 Januar 2021 19:09 gepostet von Jvcbximmus

    cialis manufactured in canada cialis supplier uk canada cialis [url=http://phrcialiled.com/]cialis overnight shipping[/url] ’

  • Kommentar-Link Modesta Mittwoch, 20 Januar 2021 08:19 gepostet von Modesta

    Thanks for your marvelous posting! I seriously enjoyed reading it, you could be a great
    author.I will make sure to bookmark your blog and will come back in the future.
    I want to encourage you to continue your great job, have a nice day!

  • Kommentar-Link NlbxGooth Mittwoch, 20 Januar 2021 06:47 gepostet von NlbxGooth

    generic cialis 10 mg price cheap cialis lilly australia cialis free trial canada [url=http://cialijomen.com/]cialis canadian[/url] ’

  • Kommentar-Link Fsbxbeigo Mittwoch, 20 Januar 2021 05:28 gepostet von Fsbxbeigo

    viagra for females how to buy viagra in shanghai generic viagra with next day delivery [url=http://genericrxxx.com/]watch viagra at work[/url] ’

  • Kommentar-Link Aqbvbeigo Mittwoch, 20 Januar 2021 03:30 gepostet von Aqbvbeigo

    buy viagra cheap usa viagra in india online viagra video [url=http://acialaarx.com/]canadian viagra online[/url] ’

  • Kommentar-Link Aqbvwilla Dienstag, 19 Januar 2021 19:57 gepostet von Aqbvwilla

    viagra no prescription usa viagra on line myrtle beach viagra [url=http://acialaarx.com/]viagra paypal[/url] ’

  • Kommentar-Link Beetech Group Dienstag, 19 Januar 2021 19:49 gepostet von Beetech Group

    It's a pity you don't have a donate button! I'd certainly donate to this outstanding blog!
    I guess for now i'll settle for book-marking and adding your RSS
    feed to my Google account. I look forward to brand new
    updates and will talk about this site with my Facebook group.
    Chat soon!

  • Kommentar-Link Geraldo Dienstag, 19 Januar 2021 18:05 gepostet von Geraldo

    Inhaled steroids aren’t the go-to remedy for COPD,
    so your doctor will doubtless prescribe a bronchodilator, too.
    This is medication in an inhaler that relaxes your airway
    muscle tissue that will help you breathe extra simply.
    The doctor could prescribe considered one of each kind or a mix inhaler that has each a corticosteroid and a bronchodilator.
    But sometimes they can trigger unpleasant unwanted effects,
    similar to an increased urge for food, temper modifications and problem sleeping.

    Making wise food decisions and together with some physical activity in your every day routine should assist you to avoid placing on weight.

    These are extra probably should you’re on a excessive dose or when you’re taking steroids for a very long time.
    You may not have the ability to start steroids if you have an an infection,
    or if you have any wounds in your physique, as steroids would possibly delay these getting higher or cowl up a few of your symptoms.
    Once the receptors are stimulated, a domino effect of metabolic reactions takes place because the drug
    instructs the body to increase muscle tissue manufacturing.
    Anabolic steroids have a similar chemical composition to testosterone and
    subsequently are capable of activate testosterone receptors.


    This is in order that when you become sick, or are involved in an accident
    in which you’re injured or turn out to be unconscious, the docs treating you'll know that you just’ve been taking steroids and can have
    the ability to carry on your treatment. Sometimes
    steroid treatments can stop your body producing sufficient natural hormones which can be harmful if you’re
    ill or injured. However, some drugs can interact with steroids, so you should talk about any
    new drugs together with your physician before beginning them,
    and you should tell anybody else treating you what you’re taking.

    Because steroids may cause you to put on weight or have an elevated
    urge for food, it’s necessary to control your
    weight while taking them.

    What Is Multiple Sclerosis? Ms Signs, Causes, Diagnosis

    If you're not predisposed to male pattern baldness, you will not lose
    any hair; you can't in case you are not genetically predisposed.
    It ought to be noted; those that are predisposed, you'll be able to
    attempt utilizing a Finasteride product similar to Proscar or Propecia to guard your hair-line.
    Finasteride can work quite nicely; nonetheless, it
    could possibly additionally create a hormonal imbalance should you're not
    cautious, and responsible use must be exercised.
    Live vaccines embody measles, mumps, rubella , rotavirus, yellow fever,
    varicella , one kind of the typhoid vaccine and nasal flu vaccine.

    There are many little identified side effects which
    are very serious and might cause life-long injury.
    Above we listed the more critical bad unwanted effects of steroids but here is a basic list starting from minor to
    severe unfavorable unwanted effects of steroids that may affect men and women. The ensuing exams discovered that
    many samples were not actually steroids however pharmaceuticals, various kinds of veterinary medicines and unapproved, untested medicine that had the potential to be more harmful than actual steroids.
    Perhaps probably the most significant brief-time period bad unwanted effects of
    steroids are the psychologic changes related to their use.

    In addition to steroids being illegal to be used in the first
    place, there have been many reports of significant sickness
    or deaths ensuing from their use. Inflammation is a key
    element of so many illnesses that steroids have seemingly endless medical functions.


    Beyond Gynecomastia, water retention, blood stress and cholesterol points can all be protected with AI
    use; nonetheless, there are other things to notice.
    First and foremost, there are non-aromatizing
    steroids that may have an effect on blood strain and ldl cholesterol;
    nonetheless, in most all circumstances it'll only
    be aromatizing steroids that may cause water retention. In either case, this can be
    very essential that you reside a healthy lifestyle and control your diet; should you
    management your food plan water retention ought to not often be
    an issue, especially should you're utilizing an AI. Even so, as a result
    of genetic response some should still have an issue, simply as some have
    issues with NSAID's, however for the average healthy grownup male,
    he ought to have the ability to preserve proper levels.
    Potential authorized issues, the mark of a felony conviction, are unwanted
    side effects of steroids that should not be ignored.
    these medicine can turn into contaminated creating extra health dangers.
    Dosage ranges are inconceivable to accurately decide and therefore "secure as possible" use by even probably the most responsible of
    users is compromised.


    In conjunction with other drugs similar to Clenbuterol and Nolvadex, most any woman can build a physique others will be envious of.


    This is very true of steroids, which may change
    numerous parts of your pet's well being in ways that aren't
    necessarily expected.

    Read on for a brief overview of a few of the unwanted
    effects of steroids in canines.

    Although anti-inflammatory steroid medicine are among the many most potent and powerful medicines that you could give to your pet, the various steroid unwanted side effects which accompany them
    are oftentimes quite severe.

    If it is testosterone that promotes male characteristics then exogenous use
    of pure testosterone is going to tremendously enhance your risk
    of steroid aspect-results.


    During my time using Advair, I also observed a major change in my
    imaginative and prescient. Many folks sometimes disregard this facet effect and do not always take it seriously.
    But, when taking Advair, you have to notice that this medication does include a steroid.
    This steroid may cause many negative unwanted effects that may trigger you problems for the remainder of
    your life. If you do experience blurred imaginative and prescient,
    head to your local eye doctor. Your doctor will be capable of help make
    certain your eyes are taken care of with a brand new glasses/contact prescription. I have been warned of
    those side effects from every bronchial asthma-associated
    medication I have ever taken; anybody who has used some sort
    of steroid inhaler knows that these unwanted side effects are common.

    Male And Female Steroid Unwanted Side Effects

    Because of this, doctors normally begin COPD sufferers with bronchodilators and other
    therapies like schooling and train packages earlier than they prescribe inhaled
    steroids. For people with average to severe COPD who even have exacerbations, studies present that a long-performing
    bronchodilator used along with inhaled steroids works better
    than only one or the opposite. Together, they'll enhance
    your lung perform, decrease the variety of exacerbations, and increase your general health.



    Anabolic steroids are often referred to as a
    ‘efficiency and image enhancing drug’, and are
    used to increase sporting efficiency and outcomes.
    By injecting steroids by needle, teens can add HIV and hepatitis B
    and C to their listing of well being hazards. Many abusers share non-sterile
    "works" or drug injection equipment that can unfold life-threatening viral infections.
    When steroids get into the physique, they go to completely different organs
    and muscles. There’s some debate over whether or not or not inhaled steroids are a good remedy for stable COPD, particularly since bronchodilators have more benefits and fewer unwanted side effects.

    I would assume that most people would understand that putting a medication that contains a steroid
    into your physique is going to have some kind of various
    outcomes and unwanted effects, relying on each individual patient’s response.
    Cushing's syndrome as a result of extreme steroid within the body,
    which might result in varied effects on the physique, including thinning of the pores and skin, easy bruising and stretch marks.
    Topical steroids used for the skin can be found as lotions, ointments or
    lotions. The quantity of topical steroid that you need to apply is commonly
    measured by fingertip units. For extra information see
    the separate leaflets calledTopical Steroids
    for Eczema and Fingertip Units for Topical Steroids.
    Topical steroids include those used for the pores and skin, nasal
    sprays and inhalers. Prednisone may improve your threat of harmful effects from a stay vaccine.


    Is It Worth Being On Steroids?

    Because legal steroids are difficult to realize and because there's a big
    demand for their potential benefits, a black market has developed
    advertising each authentic as well as counterfeit variations of
    the medicine. Women are advised to take further care in a decision to use anabolic steroids and, if
    used, should be monitored even more intently than men. Many instances the early warning indicators of soon-to-be visible
    unwanted side effects of steroids could be tough to discern and continued
    use can create permanence. The potential unwanted side effects of steroids are sufficient to scare the typical particular person away from use.
    Although small amounts of steroids may move into breast milk,
    there’s no analysis that has shown that it’s dangerous to your child, so guidelines say that folks can breastfeed while taking steroid tablets.

    You ought to discuss the risks together with your doctor in case you have any considerations.

Schreibe einen Kommentar

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