Experimental Physics and
Industrial Control System

Hi all,

  I want to import MySQLdb module in CSS to operate the mysql database.

  In order to do this, I have looked up the CSS manual and add the MySQLdb module path ("/usr/lib64/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg/") in the PYTHONPATH that obtained from sys.path;

 

  The content of python script that I wrote only contain two lines:

  from org.csstudio.opibuilder.scriptUtil import PVUtil
  import MySQLdb

  however, when running the python script in CSS, an error occured and print out the following message:

  Traceback (most recent call last):

  File "<script>", line 2, in <module>
  File "/usr/lib64/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg/MySQLdb/__init__.py", line 19, in <module>
  File "/usr/lib64/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg/_mysql.py", line 7, in <module>
  File "/usr/lib64/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg/_mysql.py", line 6, in __bootstrap__
  ImportError: No module named _mysql

 

  If I import MySQLdb module directly in python terminal window and everything is OK and no error occurred !

  Any help will be appreciated and thanks in advance !

Zhefu