Connect R with MYSQL database

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...

Ubuntu remote login xrdp failed error

 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...