[R] Confirming MySQL Alive

[Stephen H. Dawson, DSL]

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