I have a CGI (Bash) script in a tool account's public_html on Toolforge which is supposed to run a fixed MySQL query on the database replica and output its result. I am convinced it used to work before, but now it's broken because /usr/bin/mysql is not available to the webservice at all.
@Blahma Which backend are you using to run your webservice? I think the issue here is that you have legacy code which is expecting to run on the job grid which has a very broad set of software installed. When running on the Kubernetes backend your webservice is hosted inside a Docker container which has a very narrow set of installed software. The php5.6, php7.2, and php7.3 runtimes for the Kubernetes backend do include mariadb libraries and their PHP bindings, but they do not include cli tools like /usr/bin/mysql.
The fix is either to update your tool to use PHP to query the database, or to run your tool on the grid engine rather than on Kubernetes. The first option is a bit more work, but recommended as the grid engine backend is not as robust for keeping webservices running as Kubernetes is.
@bd808: Hello, thank you for investigating this. I didn't mean to create anything fancy – just an HTTP gateway to executed a fixed SQL query on the database replica and obtain its results.
That's why I chose Bash and CGI (as mentioned in the original post) because that means just a few lines of code in a .sh file. If that is not supported, that should probably be documented somewhere and I should think of replacing it with a PHP script, although I consider that an overkill for such a simple task as dumping the results of a database query.