cli TMUX script stop

[wiggim]

I would like to shut down the nzedb server remotely via SSH, as its on a dumb UPS with lots of uptime but no interfacing (just extends certain death). I have nzedb installed on ubuntu server 13.10 and can easily get the system to power down over SSH when another system on a smartUPS shutdown is triggered. My question is how can I stop nzedb cleanly first? The config is in the GUI now. Any help is appreciated.

[ruhllatio]

Send a SQL command to stop the scripts then kill tmux.

UPDATE tmux SET value = 0 WHERE setting = 'running';
Wait up to however long it takes on average for monitor.php to loop and see the running value is 0
tmux kill-session
shutdown server