On Thu, Aug 28, 2014 at 2:35 PM, Michael Albinus <michael.albinus@gmx.de> wrote:
> Sam Steingold <sds@gnu.org> writes:
>
>> Now I am getting
>>
>> Tramp: Opening connection for dbadmin@vertica using sudo...
>> Tramp: Sending command `exec ssh   -o
>> ControlPath=/var/folders/5k/3w_vc1qs6pv4k3wvnrwr_5100000gn/T/tramp.19861UFF.%r@%h:%p
>> -o ControlMaster=auto -o ControlPersist=no -e none vertica'
>> Tramp: Waiting for prompts from remote shell...done
>> Tramp: Found remote shell prompt on `vertica'
>> Tramp: Sending command `exec env SHELL=/bin/sh sudo -u dbadmin -s -H
>> -p Password:'
>> Tramp: Waiting for prompts from remote shell...done
>> Tramp: Found remote shell prompt on `vertica'
>> Tramp: Opening connection for dbadmin@vertica using sudo...done
>> File error: "Searching for program", "no such file or directory", "vsql"
>>
>> despite
>>
>> vertica$ type vsql
>> vsql is /usr/bin/vsql
>>
>> do you need the "debug" tramp buffer?
>
> Yes, please. With tramp-verbose set to 6.

now I got "sh: cd: : Permission denied" in *SQL*.

Tramp: Opening connection for dbadmin@vertica using sudo...
Tramp: Sending command `exec ssh   -o
ControlPath=/var/folders/5k/3w_vc1qs6pv4k3wvnrwr_5100000gn/T/tramp.19861Iud.%r@%h:%p
-o ControlMaster=auto -o ControlPersist=no -e none vertica'
Tramp: Waiting for prompts from remote shell...done
Tramp: Found remote shell prompt on `vertica'
Tramp: Sending command `exec env SHELL=/bin/sh sudo -u dbadmin -s -H
-p Password:'
Tramp: Waiting for prompts from remote shell...done
Tramp: Found remote shell prompt on `vertica'
Tramp: Opening connection for dbadmin@vertica using sudo...done
Tramp: Opening connection for dbadmin@vertica using sudo...
Tramp: Sending command `exec ssh -q   -o
ControlPath=/var/folders/5k/3w_vc1qs6pv4k3wvnrwr_5100000gn/T/tramp.19861Iud.%r@%h:%p
-o ControlMaster=auto -o ControlPersist=no -e none vertica'
Tramp: Waiting for prompts from remote shell...done
Tramp: Found remote shell prompt on `vertica'
Tramp: Sending command `exec env SHELL=/bin/sh sudo -u dbadmin -s -H
-p Password:'
Tramp: Waiting for prompts from remote shell...done
Tramp: Found remote shell prompt on `vertica'
Tramp: Opening connection for dbadmin@vertica using sudo...done
Login...done



tramp debug is attached


>> also, when I use shell, "sudo -u dbadmin" asks me for a password.
>> tramp does not.
>> I wonder why.
>
> Tramp uses a password cache. Likely, it is in action.

is there a way to specify the password in the default-dir?
is it "sudo:dbadmin#passwd@vertica"?

thanks!

-- 
Sam Steingold <http://sds.podval.org> <http://www.childpsy.net/>