[kath] | the following is code snippet I used to run plink command from Python. | If I run plink command directly it pops out a command prompt | window. To make the command promot window invisible I used WMI | as follows.
I'm not sure WMI is necessarily the best way to do this. You might want to look at win32process.CreateProcess. But to address the particular issue... | The command runs perfect. But it throughs the error | following the code snipet. | def run_command(): | cmd="plink -v -N -batch -l username-pw password-L | 3307:127.0.0.1:3306 dbb.mydatabase.com" | c = wmi.WMI () | startup = c.Win32_ProcessStartup.new (ShowWindow=win32con.SW_HIDE) | pid, result = | c.Win32_Process.Create(CommandLine=cmd,ProcessStartupInformati on=startup) | D:\...\...\library.zip\wmi.py:215: The fact that wmi.py is in library.zip suggests that you're running from py2exe or something similar. Might have a bearing on the situation... | Unhandled exception in thread started by <function run_command at | 0x00D05130> "... exception in thread" is almost certainly the vital bit of that traceback, along with "wmi.pyc ... in connect" | Traceback (most recent call last): | File "newfma.py", line 159, in run_command | File "wmi.pyc", line 975, in connect | File "wmi.pyc", line 220, in handle_com_error | wmi.x_wmi: 0x800401e4 - Invalid syntax It's almost certainly -- despite the misleading "Invalid syntax" message -- the fact that you're running in a thread (albeit unwittingly) and need to call pythoncom.CoInitialize () somwhere before the c = wmi.WMI () line. That's basically because under the covers WMI is based on COM/DCOM which needs to be instructed how to thread. TJG ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ -- http://mail.python.org/mailman/listinfo/python-list
