[Zope] mysql trouble

Andy Dustman andy@dustman.net
Sat, 21 Apr 2001 01:54:27 -0400 (EDT)


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