Subject: bug#11908: 24.1; "Unable to locate SQL program" when using sql-mysql with tramp and the client does not have the SQL program (but the server does)

From: Francis Devereux <[email-masked]>
Date: Fri, 13 Jul 2012 15:45:41 +0100

On 13 Jul 2012, at 15:31, Michael Albinus wrote:

> Francis Devereux <[email-masked]> writes:
> 
>> However, if you comment out the following lines in sql-comint in sql.el:
>> ;    (unless (executable-find program)
>> ;      (error "Unable to locate SQL program \'%s\'" program))
>> then it works - you get an SQLi buffer running mysql in an ssh session on
>> the server.
> 
> Indeed, `executable-find' does not work in this case. I would propose
> the following check, which keeps the test for local processes:

[ patch snipped]

> Could you, please, check, whether this works for you?

Yes, this does work for me. I have tested both for a remote host, where the check is correctly skipped, and for the local host, where the check is done and correctly fails when sql-mysql-program can't be found.

Thanks Michael :-)

Francis