prompt assignment is not working. Provide example on how to execute interactive scripts in ssh?

[spooning]

Originally submitted to Google Code by sriharshatn on 16 Feb 2012

What steps will reproduce the problem?
Open Connection <ip address>
Login <username> <password>
${prompt} set prompt #
${result} start command mysql
log ${result}
${result} write exit
log ${result}
Close Connection

Also as per below example prompt assignment to scalar is not working
${prompt} Set Prompt $
Do Something
Set Prompt ${prompt}

What is the expected output? What do you see instead?
${prompt} =
has no variable assignment
Log is attached. I want to interactively execute sql statements and exit from mysql.
Pls suggest how this can be done?

What version of the product are you using? On what operating system?
pybot --version
Robot Framework 2.5.4 (Python 2.6.2 on win32)

Please provide any additional information below.
Also unable to end the command execution if logging in to mysql through the mysql command.

[spooning]

Originally submitted to Google Code by @yanne on 23 Feb 2012

In your first example the problem is that Write keyword does not return a value, instead you have to use some Read x keyword variant.

The first invocation of Set Prompt never returns a value, since a prompt has not been set.

Additionally, if you want to interact with a database, I suggest using some dedicated database library, for example https://github.com/franz-see/Robotframework-Database-Library

Lastly, this issue tracker is not meant for general discussion, so please send additional comments/questions to the users mailing list at http://groups.google.com/group/robotframework-users