Gary/Josh,
That's good to hear since we're using the last open source version of SGE and the commands should all be similar. Recently I've made to the Petunia web interface (
tpp_gui.pl) that should also work for you. What I've done is made two simple modifications The first will prepend the "qrsh" to the list of commands. That way the commands are submitted to the cluster instead of running locally on the web server. The second (and more controversial) change does yet another prepend to the command list, this time using "sudo" to switch to the logged in user. Since Petunia already has a undocumented feature that allows you to change its authentication mechanism (we happen to use this to use LDAP to authenticate our TPP users) this then allows one to make sure jobs are submitted as the appropriate user.
I've tested this out on our development systems here at ISB and it seems to work pretty well. We haven't deployed it into production yet for as you can imagine the security implications of having a CGI script using sudo and being tied to a cluster are significant. We do intend to eventually roll some solution like this but only after we can change our current system configuration. (Our IT wants to ensure the web server node is locked down and strictly controlled before they'll let any program use sudo so freely).
If your interested I could share the code with you now -- or you can wait until we release 4.7 which will have said hooks in place with hopefully some documentation.