Hi,

I do the following:
On a remote server (debian, exim, mysql, ftp...) we have a Mysql database.
In the database we store a program (rekall based) to manage our small offices (10).
So, we start rekall on a local machine (suse linux 10), it go's and get data/ screens / python programs
from the mysql server remote. All is run locally, interactivily on a Gnome desktop.

Now we have an application where the user selects texts fromp records from the database to compose mail messages.
These records are completed with photos (large .jpg files on the same remote server).

The idea was, that after the user selected his records, the photos where added to the texts and a 'new mail' window is presented to him (Evoluition).

This does not work:
1. Evolution cannot open a new mail window with an external command (shell) if there are photos / html etc in the messages (it crasches).
2. the photos are BIG (about 1.5 mio each and I have 20 or so), it takes much to long to transfer them from the server, show them to the user, and then the user sends his -eventually corrected- e-mail trough the same server to the final destination, a destinatiuon that is allready known by the program.

So, I thought I construct the e-mail message in rekall -text only-, have the user rectify it, and then have the server run a shell script combining an ftp-fransferred text from the local user with the photos on the server and send it directly to the end-target.

The problem is, that I cannot understand how to -easy- bring ssh to execute the mail script on the remote server. It keeps asking for a password, that I cannot pipe into the script. I cannot travel around to install complicated procedures with RSA keys (sic?) or so on the various local machines. The whole concept of our setup is that everything can be aranged from the central server.

Anybody any ideas ?

Steven