I am seeking some assistance and or advice running a python scripts on SME 7.3.
Basically what I wish to do is monitor some ASCII data on a serial port analyse the data within a received line and write that data to a table within a MySQL database. I have selected to use Python with modules PySerial and python-mysql. I am aware that any additions, changes or modifications to a base SME distribution have security implications so my questions are as follows.
I have loaded and tested the PySerial module without problem and done some testing without error, but to date I have had no luck getting python-mysql loaded onto my SME 7.3 test box. I have trawled through contribs org and many python and mysql sites and have either missed the answer completely or come up empty.
I installed gcc with yum install gcc which resolved the first batch of errors but to date I cannot compile or install the python-mysql onto an SME box. I an a relative newbie here and do not want to load anything else onto the SME box that I do no understand the implications of. Can anyone point me in the right direction here? No flames please, I have tried to resolve my own problems first but am getting nowhere, which is why I am asking for help.
Is my intended approach the best ways to achieve some relatively simple programming on an SME 7.3 box? If not what would be a better approach?
$ tar xfz MySQL-python-1.2.1.tar.gz
$ cd MySQL-python-1.2.1
$ # edit site.cfg if necessary
$ python setup.py build
$ sudo python setup.py install # or su first
I am getting errors at the console at the line $ python setup.py build which make no sense to me, can anyone tell me what I am missing?
Thanks for an assistance.