[Zope] mysql trouble

[Olaf Marc Zanger]

hi there,

after updating a SuSE 7.1 installation (mysql 3.22.32 to 3.32.30) i get the 
error message at the bottom of this email.
Zope 2.3.0 (binary release, python 1.5.2, linux2-x86) 
ZMySQLDA-1-2-0 
MySQLdb-0.1.2 

the crazy thing is, 
1. if i access the database with the mysql command line client i have no 
trouble (about 200 rows) on both win and SuSE,
2. if i access the old database on a win system i can do that, but i 
get no rows back (through the test tab)
3. if i downgrade the mysql on the SuSE system to the old one i have the same 
trouble as in (2).

i also tried to upgrade to build MySQL-python-0.3.5 and get errors i have no 
clue about what they are saying (on the bottom of this message.

i tried to fix this for about 100 hours over time and should really get that 
fixed so help is very appreciated :-)

thanks in before

olaf


error message
---------------------------------------
Remarks for Errortracking

(Please pass this information to your support) 

      Error Type: BadRequest 
      Error Value: Invalid connection string: ipOperate user password
      Error URL: http://sino/ip/translations.db/manage_edit 
      Error Message: Invalid connection string: ipOperate user password
      Error Absolute URL: http://sino/ip/translations.db 

      The URL may be incorrect. 
      The parameters passed to this resource may be incorrect. 
      A resource that this resource relies on may be encountering an error. 

Traceback (innermost last):
  File /home/soli-con/ipOffice/lib/python/ZPublisher/Publish.py, line 222, in 
publish_module
  File /home/soli-con/ipOffice/lib/python/ZPublisher/Publish.py, line 187, in 
publish
  File /home/soli-con/ipOffice/lib/python/Zope/__init__.py, line 221, in 
zpublisher_exception_hook
    (Object: RoleManager)
  File /home/soli-con/ipOffice/lib/python/ZPublisher/Publish.py, line 171, in 
publish
  File /home/soli-con/ipOffice/lib/python/ZPublisher/mapply.py, line 160, in 
mapply
    (Object: manage_edit)
  File /home/soli-con/ipOffice/lib/python/ZPublisher/Publish.py, line 112, in 
call_object
    (Object: manage_edit)
  File /home/soli-con/ipOffice/lib/python/Shared/DC/ZRDB/Connection.py, line 
167, in manage_edit
    (Object: RoleManager)
  File /home/soli-con/ipOffice/lib/python/Shared/DC/ZRDB/Connection.py, line 
161, in edit
    (Object: RoleManager)
  File /home/soli-con/ipOffice/lib/python/Shared/DC/ZRDB/Connection.py, line 
240, in connect
    (Object: RoleManager)
  File /home/soli-con/ipOffice/lib/python/Products/ZMySQLDA/db.py, line 155, 
in __init__
BadRequest: (see above)

mysql-python 0.3.5 build log
-------------------------------------------
.py build
running build
running build_py
not copying MySQLdb.py (output up-to-date)
not copying CompatMysqldb.py (output up-to-date)
not copying _mysql_const/__init__.py (output up-to-date)
not copying _mysql_const/CR.py (output up-to-date)
not copying _mysql_const/FIELD_TYPE.py (output up-to-date)
not copying _mysql_const/ER.py (output up-to-date)
not copying _mysql_const/FLAG.py (output up-to-date)
not copying _mysql_const/REFRESH.py (output up-to-date)
not copying _mysql_const/CLIENT.py (output up-to-date)
running build_ext
building '_mysql' extension
gcc -O2 -m486 -fpic -I/usr/include/mysql -I/usr/include/python2.0 -c 
_mysqlmodule.c -o build/temp.linux-i686-2.0/_mysqlmodule.o
In file included from /usr/include/bits/posix1_lim.h:126,
                 from /usr/include/limits.h:144,
                 from 
/usr/lib/gcc-lib/i486-suse-linux/2.95.2/include/limits.h:117,
                 from 
/usr/lib/gcc-lib/i486-suse-linux/2.95.2/include/syslimits.h:7,
                 from 
/usr/lib/gcc-lib/i486-suse-linux/2.95.2/include/limits.h:11,
                 from /usr/include/python2.0/Python.h:27,
                 from _mysqlmodule.c:29:
/usr/include/bits/local_lim.h:36: linux/limits.h: Datei oder Verzeichnis 
nicht gefunden
In file included from /usr/include/errno.h:36,
                 from /usr/include/python2.0/Python.h:48,
                 from _mysqlmodule.c:29:
/usr/include/bits/errno.h:25: linux/errno.h: Datei oder Verzeichnis nicht 
gefunden
error: command 'gcc' failed with exit status 1
root@sino:/home/soli-con/ip-0.1.1/daten-import-p

-- 
soli-con Engineering Zanger, Dipl.-Ing. (FH) Olaf Marc Zanger
Lorrainestrasse 23, 3013 Bern / Switzerland
fon:+41-31-332 9782, mob:+41-76-572 9782
mailto:olaf.zanger@soli-con.com, http://www.soli-con.com