Hello friends, i am currently finishing my ShinyApps and like to deploy to Shiny.io for a multiple user use, but i have an issue for the deployment.
my Apps is about a Pharmacy management, it controls a CRUD operation, so clearly it is binded with db Connection using these options configuration (running this in locally)
options(mysql = list( "host" = "127.0.0.1", "port" = 3306, "user" = "root", "password" = "" ))
one more thing, that i usually started my XAMPP apps and switched on mysql admin so my apps can connect the database locally. it worked flawlessly and clear before deploy
but it crashed instantly when i try to run it in the shiny.io after delpoy (what i mean is disconnected automatically). so i did try to change the host ip to publically like this , (i am trying to get ip address on user local machine)
configA <- system("ipconfig", intern=TRUE) configB <- configA[grep("IPv4", configA)] configC <- gsub(".*? ([[:digit:]])", "\\1", configB) options(mysql = list( "host" = configC, "port" = 3306, "user" = "root", "password" = "" ))
but it didn't affect the crash.. can anyone help me give some appointment of a proper way to do these?