You don't need sudo to run: systemctl status On Sat, Oct 7, 2023, 17:09 Stephen H. Dawson, DSL via R-help < r-help@r-project.org> wrote:
> Hi, > > > Getting some data from an older MySQL box. I had an event recently where > the MySQL box went off-line for maintenance without a prior announcement > of service disruption. > > I decided to add a line on my local version of MySQL as I considered how > to handle this condition going forward. > > system("sudo systemctl status mysql", input = > rstudioapi::askForPassword("sudo password")) > > system("sudo systemctl status mysql",input=readline("Enter Password: ")) > > > Both fail for the same reason, saying I need a terminal. > > > > system("sudo systemctl status mysql", input = > rstudioapi::askForPassword("sudo password")) > sudo: a terminal is required to read the password; either use the -S > option to read from standard input or configure an askpass helper > sudo: a password is required > > > > > > > system("sudo systemctl status mysql",input=readline("Enter Password: ")) > Enter Password: ***REDACTED*** > sudo: a terminal is required to read the password; either use the -S > option to read from standard input or configure an askpass helper > sudo: a password is required > > > > > > I can run the code segments for things like ls and pwd. So, there is > something unique about systemctl and R that is beyond my understanding > today. > > QUESTIONS > What is so special about systemctl and R in a system syntax statement? > > What are some of the best practices to confirm a box I am hitting for > data with R , either local or across the network, has MySQL up and running? > > > Thanks, > -- > *Stephen Dawson, DSL* > /Executive Strategy Consultant/ > Business & Technology > +1 (865) 804-3454 > http://www.shdawson.com > > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.