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)

[Francis Devereux]

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

> Francis Devereux <francis@devrx.org> 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