RE: [Serusers] Python Script with IVR - sr-users

1 Jun 2004

Hi, 

Thank you for reply. I have tried your method but I still the error below
when I run the ivr.py from SEMS. Is it that I cannot import the MySQLdb
module from the IVR.py file.
Please help

Traceback (most recent call last):
  File "/root/answer_machine/plug-in/ivr/scripts/ivr.py", line 4, in
?
    import MySQLdb
  File "/usr/lib/python2.2/site-packages/MySQLdb/__init__.py", line
27, in ?
    import _mysql
ImportError: No module named _mysql
(11533) WARNING: sig_usr (sems.cpp:72): signal 17 received
(11533) INFO: sig_usr (sems.cpp:81): finished

regards, 
shirley

...
  -----Original Message-----
 From:	Martin Solli [SMTP:martin@strangedays.no]
 Sent:	Monday, May 24, 2004 10:39 PM
 To:	Shirley Toh
 Cc:	serusers(a)lists.iptel.org
 Subject:	Re: [Serusers] Python Script with IVR

 Shirley Toh:
  I am trying to read the import MySQLdb into the
ivr.py script to
 read values
 from the sql database but I got error in missing modules. Please
 help. What
 should I do to be able to read values from the database in the
 ivr.py script
 for development purpose. Please help......Thanks in advance.   
 What you need to do is to link the MySQLdb module into Sems when
 you compile it. In plug-in/ivr/Makefile, change the module_ldflags
 line to something like this:

 module_ldflags = -L/usr/lib/python$(PYTHON_VERSION)/config \
         -lpython$(PYTHON_VERSION) -ldl -lpthread -lutil -lm \
         -Xlinker -export-dynamic \
         /usr/lib/python2.2/site-packages/_mysql.so \
         /usr/lib/python2.2/lib-dynload/time.so \
         /usr/lib/python2.2/lib-dynload/array.so

 In short, you will need to link statically against any shared
 libray module that you use in Python, ie. any module whose name
 ends with '.so'.

 This problem was recently discussed on the Sems list. I suggest
 you have a look in the archives for more info on this.
 <http://lists.iptel.org/cgi-bin/mailman/listinfo/sems>

 -- 
 .\\artin
 Despite it's high cost, living remains popular. 