[Zope] Loading ZMySQLda on Solaris 7

Lee Marzke lmarzke@kns.com
Wed, 31 Jan 2001 17:30:46 -0500 (EST)


Well I can't seem to get MySQLdb to load into any version
of Python-1.5.2

I've went from MySQL 3.22.32 to 3.22.30 from source
 ( that version works on Linux RH6.1 for me )
I've recompiled Python 1.5.2 from source
I've recompiled GCC 2.95.1 from source
( all with --prefix=/sw/scm/usr )


I'm using the MySQLdb-0.1.2 that is part of MySQLDA-0.3.1

The Python error when loading MySQLdb is:

Traceback (innermost last):
  File "<stdin>", line 1, in ?
  File "/sw/scm/usr/lib/python1.5/site-packages/MySQLdb.py", line 19, in ?
    import _mysql
ImportError: ld.so.1: python1.5: fatal: relocation error: file
/sw/scm/usr/lib/python1.5/site-packages/_mysql.so: symbol PyTuple_New:
referenced symbol not found

Seperate question:
I also am using the precompiled Zope sparc binary, which has a
copy of Python 1.5.2, but I'm not of what to do with modules
that I compile with my Python1.5.2 so that it uses them.

Thanks for any hints, as Linux is my home box, but I need this
to work on Solaris at work.

On 31-Jan-01 Andy Dustman wrote:
> On Tue, 30 Jan 2001, Lee Marzke wrote:
> 
>> 
>> Hi,
>> 
>> After having no problems at all with Zope 2.3, and Mysql on Linux RedHad6.1
>> I tried getting this to work on a Solaris 7 SPARC machine with no luck.
>> 
>> Im using:
>> 
>> Solaris 7 (SunOS 5.7 )
>> GCC 2.95.1
>> Zope 2.3.0 
>> ZMySQLDA 1.2 
>> MySQL 3.22.32  compiled from source
>> Python 1.5.2, Python 1.6, Python2.0  all compiled with thread support.
>> 
>> When I try to load a ZMySQL object in Zope I keep getting the following
>> error:  Any ideas?
> 
> Was MySQLdb/_mysql compiled against the version of Python that you are
> using with Zope? In general, modules compiled against Python 1.5.2 won't
> load with Python 2.0, and vice versa. Interestingly, you seem to have
> installed _mysql in multiple places.
>  
>> Thanks,
>> 
>> 
>> ImportError: ld.so.1: python: fatal: relocation error: file
>> /sw/scm/usr/lib/python1.5/site-packages/_mysql.so: symbol PyTuple_New:
>> referenced symbol not found
>> 
>> 
>> Traceback (innermost last):
>>   File
>> "/sw/scm/usr/Zope-2.3.0-solaris-2.6-sparc/lib/python/OFS/Application.py",
>> line
>> 530, in import_products
>>     product=__import__(pname, global_dict, global_dict, silly)
>>   File
>> "/sw/scm/usr/Zope-2.3.0-solaris-2.6-sparc/lib/python/Products/ZMySQLDA/__init
>> __.
>> py", line 106, in ?
>>     import sys, os, Globals, DA
>>   File
>> "/sw/scm/usr/Zope-2.3.0-solaris-2.6-sparc/lib/python/Products/ZMySQLDA/DA.py"
>> ,
>> line 108, in ?
>>     from db import DB
>>   File "/usr/share/zope/lib/python/Products/ZMySQLDA/db.py", line 106, in ?
>> ImportError: ld.so.1: /sw/scm/usr/Zope-2.3.0-solaris-2.6-sparc/bin/python:
>> fatal: relocation error: file
>> /sw/scm/usr/Zope-2.3.0-solaris-2.6-sparc/lib/python/Products/ZMySQLDA/_mysqlm
>> odu
>> le.so: symbol PyObject_Init: referenced symbol not found
>> 
>> 
>> 
>> ee Marzke <lmarzke@kns.com>             30-Jan-01, 15:10:04
>> Kulicke & Soffa Industries
>> 2101 Blair Mill Rd                       +1 215 784-6217
>> Willow Grove, PA 19090                   +1 215 784-6014 fax
>> 
>> 
>> _______________________________________________
>> Zope maillist  -  Zope@zope.org
>> http://lists.zope.org/mailman/listinfo/zope
>> **   No cross posts or HTML encoding!  **
>> (Related lists - 
>>  http://lists.zope.org/mailman/listinfo/zope-announce
>>  http://lists.zope.org/mailman/listinfo/zope-dev )
>> 
> 
> -- 
> Andy Dustman         PGP: 0xC72F3F1D
>     @       .net     http://dustman.net/andy
> "Normally with carbonara you use eggs, but I used lobster brains instead."
>     -- Masahiko Kobe (Iron Chef Italian): 30-year-old Giant Lobster Battle


Lee Marzke <lmarzke@kns.com>             31-Jan-01, 17:22:45
Kulicke & Soffa Industries
2101 Blair Mill Rd                       +1 215 784-6217
Willow Grove, PA 19090                   +1 215 784-6014 fax