It looks like your compiler problem with MySQLdb-0.3.5 is the result of missing some important include files (File or Directory not found). Specifically, I don't think you have the kernel headers installed, but you might need a glibc development package; not sure what package this is with SuSE. Also, I suggest trying ZMySQLDA-2.0.6. It now has *working* support for transactions, if your MySQL server supports them via transaction-safe tables. http://www.zope.org/Members/adustman On Fri, 20 Apr 2001, Olaf Marc Zanger wrote:
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
-- 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