I had this problem too and was able to work around by replacing the _mysql.so in
MythBox/resources/lib/MySQLdb/linux/_mysql.so with the one from my
python2.5/site-packages. After that I am stuck. Please let me know if you get further

Fixed in SVN 676 - Needs verification. Someone with 64bit please verify.

(No comment was entered for this change.)

I'm using xbmc SVN 19630
mythbox SVN 865
mythtv 0.21 from fixes branch.
On Archlinux x86_64
mysql-python-1.2.3b2-1
libmysqlclient 5.1.34-1
Python 2.6.1

cat mythbox.log
DEBUG | __init__.py | Line 1072 | Mythbox Logger Initialized
ERROR | __init__.py | Line 1072 | Initializing stage 2
Traceback (most recent call last):
  File "/home/rich/.xbmc/scripts/MythBox/default.py", line 141, in ?
    import mythtv
  File "/home/rich/.xbmc/scripts/MythBox/resources/src/mythtv.py", line 22, in ?
    import mythdb
  File "/home/rich/.xbmc/scripts/MythBox/resources/src/mythdb.py", line 22, in ?
    import MySQLdb
  File "/home/rich/.xbmc/scripts/MythBox/resources/lib/MySQLdb/MySQLdb/__init__.py",
line 19, in ?
    import _mysql
ImportError: unknown dlopen() error

atkinsonr, please attach your xbmc.log

The fun starts on line 323:

http://pastebin.com/f59b18025

thanks very much!

Was the xbmc.log useful? 

I'm happy to provide any further information that might assist with solving the issue.

A thought: Is it possible for mythbox to use a system provided MySQLdb instead of a
bundled one?

many thanks.

Well, since my copy of _mysql.so obviously didn't work on your amd64 box, can you
just attach your version which works and I'll bundle that binary instead. 

Hi there.
Sorry I thought I had this issue starred, not sure why I didn't get notified about
your update.

Attached is the _mysql.so from my AMD64 system.

thanks so much!

_mysql.so 70.9 KB   Download

Fixed in svn 1081

I just downloaded this today. This is my missing link in mediacenter land....

This isue is holding me back! ;-)

Traceback (most recent call last):
  File "/home/[USERNAME]/.xbmc/scripts/My Scripts/MythBox/default.py", line 149, in ?
    import mythtv
  File "/home/[USERNAME]/.xbmc/scripts/My Scripts/MythBox/resources/src/mythtv.py",
line 22, in ?
    import mythdb
  File "/home/[USERNAME]/.xbmc/scripts/My Scripts/MythBox/resources/src/mythdb.py",
line 22, in ?
    import MySQLdb
  File "/home/[USERNAME]/.xbmc/scripts/My
Scripts/MythBox/resources/lib/MySQLdb/MySQLdb/__init__.py", line 19, in ?
    import _mysql
ImportError: unknown dlopen() error

uname -a:
Linux mc-001 2.6.27-14-generic #1 SMP Wed Apr 15 19:29:46 UTC 2009 x86_64 GNU/Linux
cat /etc/lsb-release 
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=8.10
DISTRIB_CODENAME=intrepid
DISTRIB_DESCRIPTION="Ubuntu 8.10"

Thanks in advance,

I've tried linking MythBox/resources/lib/MySQLdb/linux64/_mysql.so to the python one
and i've tried copying the system one.

That results in crashes.
Thanks in advance!

I can confirm this issue it's not fixed. I've just tried with Beta 4 (SVN 1105)
version and results are the same described by wout.van.heeswijk (May 31, 2009) with
exactly the same log. I have also tried replacing
MythBox/resources/lib/MySQLdb/linux64/_mysql.so with
MythBox/resources/lib/MySQLdb/linux64/_mysql.so, and crashed after calling the script:

mythtv@linuxhost:~$ xbmc
/usr/share/xbmc/xbmc.bin: symbol lookup error:
/home/guindous/.xbmc/scripts/MythBox/resources/lib/MySQLdb/linux64/_mysql.so:
undefined symbol: Py_InitModule4_64

My XBMC-MythTV system is:
- Ubuntu Jaunty 9.04 (x64 version)
- XBMC 9.04.1
- Python 2.6 / python-mysqldb 1.2.2-7ubuntu1

If you need more information about it, i will be happy helping you and testing
mythbox on my amd64 box.

Thanks in advance,

--
elSeba

I can also confirm the not-fixed-yet state as described by scardello and
wout.van.heeswijk. XBMC returns the ' unknown dlopen() error'; and after replacing
the _mysql.so in mythbox with the version from Ubuntu, it crashes with exactly the
same message als scardello posted in #12 (so it is reproducable). Possibly, however,
it's not made to work with the Ubuntu version of _mysql.so.

I followed scardello's comments in #12 and have the exact same error.  This issue is
not yet fixed.

I, too, am running
* Ubuntu Jaunty 9.04 (x64)
* XBMC 9.04.2+svn20937
* mythbox-svn-1105.tar.gz 
* Python 2.6 / python-mysqldb 1.2.2-7ubuntu1

This might be of some help:

"Typically this means that an extension was compiled against the wrong Python.h.

This just means that the calling Python interpreter and the extension don't use the
same version (one is Python 2.4, the other 2.5). They were both 64-bit but the name
changed in http://www.python.org/dev/peps/pep-0353/

Some commands to help debug this are ldd (to show dymanic library linking) and nm (to
list exports)."

http://timhatch.com/ark/2008/08/07/py_initmodule4_64

Just confirmed our suspicions by installing your script on an x86 machine.  It works
fine on that box, but still does not work on the AMD64 box.

I am also having this problem. If there is anything that someone that knows very
little can do to help please let me know.

hello,
i have the same probleme...
xbmcbuntu : ubuntu9.04 amd64
an issu ?
thanks

I can also confirm that this is still an issue in svn 1105 on Ubuntu Jaunty 9.04.

I found a working _mysql.so in python-mysqldb for intrepid.
Download the python-mysqldb deb from
http://packages.ubuntu.com/intrepid/python-mysqldb and put
usr/lib/python-support/python-mysqldb/python2.4/_mysql.so in
/MythBox/resources/lib/MySQLdb/linux64

Doing what anders.ejdeling said in comment 19 worked for me. Thanks!

Same here, Jaunty 9.04 amd64.  The intrepid _mysql.so helps things.

I am on Ubuntu 9.04 AMD64 and the script errors as well. I tried copying the
_mysql.so file from /usr/lib/python-support/python-mysqldb/python2.6 and
/usr/lib/python-support/python-mysqldb/python2.5 (I do not have 2.4) and now xbmc
crashes at 'importing mythtv' without error.

On my i386 Ubuntu everything seems to work fine, until I actually play a recording,
then I get the error Exception: (-5, 'No address associated with hostname') Function:
<function onInit at 0xa40c394c>.

The internal mythtv:// isn't working, i can't play via upnp or get this script to
work on amd64 or i386, so this is a big blocker for me.

Re-opening. Working on a solution that will use your distribution's python bindings
and shared lib instead of me having to bundle a version to work with all possible
permutations:
- 32 bit vs 64bit
- python 2.4 vs 2.5 vs 2.6
- mysql client 5.0 vs 5.1

Please add a comment to this issue with your email address if you are willing to test
and provide feedback and I'll send out a version when it is ready. 

 Issue 48  has been merged into this issue.

 Issue 47  has been merged into this issue.

Willing to test. Thanks for your efforts.

also willing to test. I'm happy to make reports in the same style as my previous
reports if that helps. Send me an email.

earlne & beatbreaker: email addys plz

sorry i thought it came up - beatbreaker82@gmail.com

If testing on ubuntu is needed: henry78@gmx.at

I'm on a 64-bit machine (Gentoo, Python2.6) using mythbox-svn-1260. After installing
the script for the first time I received a dlopen() error. I attempted to use an
external copy _mysql.so as described here:
http://blog.xbmc.org/forum/showpost.php?p=384841&postcount=164

To no surprise that resulted in a crash.

I've attached the log file.

mythbox.log 636 bytes   Download

Just thought I'd comment that I'm seeing the same issue on 64-bit Ubuntu 9.04 and am also willing to test a fix.

Fixed in svn 1510

 Issue 62  has been merged into this issue.

I can confirm this is fixed on amd64 using svn 1558. 

Thanks and keep up the good work!