Thanks, Jeff.
So, how do you know in your work if the box you are hitting for data is
alive in the moment?
*Stephen Dawson, DSL*
/Executive Strategy Consultant/
Business & Technology
+1 (865) 804-3454
http://www.shdawson.com
On 10/7/23 11:26, Jeff Newmiller wrote:
Not really an R question, but some processes are connected to interactive
terminals (where someone can type) and some are not (because they were created
and managed by another process). The system call creates a process and controls
all interactions with that process. You really should not be messing with sudo
in the background like that.
On October 7, 2023 8:09:25 AM PDT, "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,
______________________________________________
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.
