Monday, November 9, 2015

0

Connect R with MYSQL database

  • Monday, November 9, 2015
  • R is simple and has more features.
    In this post we can see how write R code to connect Mysql DB which is installed in azure platform.

    I am using R studio .


     RJDBC package to connect Mysql.
    First install RJDBC  by using following command in R studio

    Here we are insert records in table and fetch the result by R script

    DB name is Department
    Table name is Maths

    install.packages("RJDBC")

    mydb = dbConnect(MySQL(), user='root', password='root', host='jay_hadoop.cloudapp.net', dbname="Department")

    To insert value in Maths table

    query1=dbGetQuery(mydb, "INSERT INTO Maths (StudentName, City) VALUES ('Saswath','Bangalore');")

    To fetch values from table Maths

    table_values <-dbGetQuery(mydb, "select * from Maths")

    print(table_values)


    You will get 

    Saswath   Bangalore

    then finally close the connection by

    dbDisconnect(mydb)


    Results are stored in Dataframe table_values , Now you can write r dataframe code .  RJDBC is easy and simple to connect R with mysql.




    Read more...

    Wednesday, November 4, 2015

    0

    Ubuntu remote login xrdp failed error

  • Wednesday, November 4, 2015
  •  Remote Desktop Connection xrdp_mm_process_login_response: login failed in ubuntu Resolved:

     Today i got issues with my Remote login . I cant able to login from my windows machine to Ubuntu installed in  Azure cloud machine got following error.



    connecting to sesman ip 127.0.0.1 port 3350
    sesman connect ok
    sending login info to sesman
    xrdp_mm_process_login_response: login failed


    I restarted the Ubuntu machine and recheck my username and password credentials, no luck . I guess there is problem with xrdp then find the solution . 
    Ubuntu supports multiple session,The issue could be X11 session created by xrdp.
     So i checked session in below path
    #cd /tmp/.X11-unix
    do #ls -lrt
    You can see results like
    srwxrwxrwx 1 root   root   0 Nov  4 05:20 X0
    srwxrwxrwx 1 userjay userjay 0 Nov  4 05:20 X10
    srwxrwxrwx 1 userjay userjay 0 Nov  4 05:36 X11
    srwxrwxrwx 1 userjay userjay 0 Nov  4 05:38 X12
    srwxrwxrwx 1 userjay userjay 0 Nov  4 05:39 X13
    srwxrwxrwx 1 userjay userjay 0 Nov  4 05:40 X14
    srwxrwxrwx 1 userjay userjay 0 Nov  4 05:66 X15
    srwxrwxrwx 1 userjay userjay 0 Nov  4 05:55 X16
    srwxrwxrwx 1 userjay userjay 0 Nov  4 05:56 X17
    srwxrwxrwx 1 userjay userjay 0 Nov  4 05:57 X18
    srwxrwxrwx 1 userjay userjay 0 Nov  4 05:59 X19
    Then i deleted X11,X12...X19 and restarted ubuntu now i can login to the  ubuntu machine.
    To delete use below command
    rm X11
    rm X12

    Read more...

    Subscribe