[R] Confirming MySQL Alive

[Jeff Newmiller]

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 using 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,

-- 
Sent from my phone. Please excuse my brevity.