I have an external lookup script (written in python) that uses the pymssql module to query a SQL Server 2005 database. The script works with a 32bit python interpreter but my splunk instances are all running on Windows x64 and pymssql won't run with a 64bit python so I'm a bit hosed.
As I see it, I have two options:
I can specify that splunk use a python interpreter other than the one it ships with
Find another way to query a Microsoft SQL server from the built-in python
I have no idea how to go about accomplishing either. Has anyone figured out how to query a SQL Server 2005 database from an external lookup script on x64?
You could use PyODBC, which has a 64-bit windows build. It looks like it installs only a few files into Python\lib\site-packages, which could probably be copied into $SPLUNK_HOME\lib\Python2.6\site-packages
I think you want to just run the external python interpreter.
Something like this, treat as pseudocode.
import os, sys
if "PYTHONPATH" in os.environ:
if "LD_LIBRARY_PATH" in os.environ:
os.execv(your_python_interpreter, [your_python_interpreter, your_script] + sys.argv[1:])
When I wrote this i probably should have mentioned that you are likely to want to manipulate the PATH environment variable, to select which will win when running additional commands between system binaries, splunk-provided binaries and any custom binaries (eg in usr/local or special paths) in case of name conflict.
This is typically relevant for bzip2, python itself, cherryd, the openssl utility program, node.js's node executable, but but more executables could possibly be added to splunk in the future.