[Zope] Re: [Zope-DB] Re:MySQL problems (Adam Shallcross)

working4aliving working4aliving@hotmail.com
Thu, 22 Aug 2002 13:21:37 -0400


I would kill the w2k windows "~" directories by uninstalling and then
installing in something simple.
(C:\zope)
Don't install python, it'll get installed automatically w/ zope.
Install mysql-3.23.51-win.zip (from mysql.org) if  you want a local mysql
server. (probably?)
install Mysql-python-0.9.1.win32.py2.1.exe
then install that exe that I had posted before.
Give it a try.  Good luck, keep the faith.. it'll be worth it.

----- Original Message -----
From: "Adam Shallcross" <aes@starfishuk.com>
To: "working4aliving" <working4aliving@hotmail.com>; <zope-db@zope.org>
Sent: Thursday, August 22, 2002 12:56 PM
Subject: RE: [Zope-DB] Re:MySQL problems (Adam Shallcross)


HI there again...

Forgive me for disturbing you again, but I am still having major
problems trying to get this to work.

Is there any chance you could give me a quick rundown of the process I
have to go through from beginning to end.  I am new to Zope and Python
and am keen to learn what I am doing wrong.

My setup is:-

Zope Version (Zope 2.5.1 (binary release, python 2.1, win32-x86),
python 2.1.3, win32)
Python Version 2.1.3 (#35, Apr 8 2002, 17:47:50) [MSC 32 bit (Intel)]
System Platform win32
SOFTWARE_HOME C:\PROGRA~1\DISCOV~1\lib\python
INSTANCE_HOME C:\PROGRA~1\DISCOV~1
CLIENT_HOME C:\PROGRA~1\DISCOV~1\var

Still get the error

Traceback (most recent call last):
  File "C:\PROGRA~1\DISCOV~1\lib\python\OFS\Application.py", line 531,
in import_product
    product=__import__(pname, global_dict, global_dict, silly)
  File "C:\PROGRA~1\DISCOV~1\lib\python\Products\ZMySQLDA\__init__.py",
line 91, in ?
    import DA
  File "C:\PROGRA~1\DISCOV~1\lib\python\Products\ZMySQLDA\DA.py", line
92, in ?
    from db import DB
  File "C:\PROGRA~1\DISCOV~1\lib\python\Products\ZMySQLDA\db.py", line
89, in ?
    import _mysql
ImportError: No module named _mysql

I have tried the executable that you recommended and it had no effect.
I restarted Zope after installing the .exe and it still had no effect.

Your hopefully

Adam Shallcross
Programmer/Developer
aes@starfishuk.com

Office:       +44 (0) 20 8674 9161
Fax:          +44 (0) 20 8674 2849
Telephone: +44 (0) 70 0390 2293

www.starfishuk.com
www.teamstarfish.com

WARNING: For your own safety all email attachments should be
virus scanned prior to opening. This communication contains
information which is confidential and may be privileged. If you are not
the addressee, you may not copy or otherwise use the information.
Please note that the opinions expressed in this communication are
not necessarily those of Starfish Media UK Ltd.

If you receive this email by mistake, please notify us immediately at:
info@starfishuk.com

Thank you.

 -----Original Message-----
From: working4aliving [mailto:working4aliving@hotmail.com]
Sent: 22 August 2002 13:08
To: zope-db@zope.org
Subject: [Zope-DB] Re:MySQL problems (Adam Shallcross)

Adam, there is a MYSQLdb binary (windows msi installer) version
available.
This, coupled with the link below ...ch.fhm.edu... should be all you
need.
(I think).

You shouldn't have to do any compiling on the w2k box version.

----- Original Message -----
From: <zope-db-request@zope.org>
To: <zope-db@zope.org>
Sent: Wednesday, August 21, 2002 12:00 PM
Subject: Zope-DB digest, Vol 1 #252 - 2 msgs


> Send Zope-DB mailing list submissions to
> zope-db@zope.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.zope.org/mailman/listinfo/zope-db
> or, via email, send a message with subject or body 'help' to
> zope-db-request@zope.org
>
> You can reach the person managing the list at
> zope-db-admin@zope.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Zope-DB digest..."
>
>
> Today's Topics:
>
>    1. Fw: MySQLDA and Windows - a perennial problem (Dan Smith)
(working4aliving)
>    2. MySQL problems (Adam Shallcross)
>
> --__--__--
>
> Message: 1
> From: "working4aliving" <working4aliving@hotmail.com>
> To: <zope-db@zope.org>
> Date: Tue, 20 Aug 2002 13:19:56 -0400
> Subject: [Zope-DB] Fw: MySQLDA and Windows - a perennial problem (Dan
Smith)
>
> Hey Dan, check out the following... It "unbroke MySQLda"
>
> http://www.cs.fhm.edu/~ifw00065/downloads/ZMySQLDA-Zope24.exe
>
>
> ----- Original Message -----
> From: "working4aliving" <working4aliving@hotmail.com>
> To: <zope-db@zope.org>
> Sent: Monday, August 19, 2002 12:28 PM
> Subject: Re: MySQLDA and Windows - a perennial problem (Dan Smith)
>
>
> > Alas, dear Dan, fore I too have the same issue (me thinks), without
any
> > result.
> > I have a "broken product" for MYSQLda.
> >
>
>
> --__--__--
>
> Message: 2
> Date: Wed, 21 Aug 2002 11:13:28 +0100
> From: "Adam Shallcross" <aes@starfishuk.com>
> To: <zope-db@zope.org>
> Subject: [Zope-DB] MySQL problems
>
> Hello everyone..
>
> I need some quick help please.  I am new to the Zope and Python fields
> and am very interested in learning the product.
>
> I have downloaded the latest release of Zope and the latest release of
> MySQL.  Also I have downloaded the latest versions of MySQLdb and
> ZMySQLda....i am trying to get the modules to work in Zope, however I
am
> having problems getting the module to install properly.
>
> The error I get in the command window is=20
>
> building '_mysql' extension
> cl.exe /c /nologo /Ox /MD /W3 /GX -Ic:\mysql\include -IC:\Py
> ysql.c /Fobuild\temp.win32-2.2\Release\_mysql.obj
> error: command 'cl.exe' failed: No such file or directory
>
> I understand that I need to have a C comiler installed on my system,
but
> I do not know where to get a decent free c compiler.  The only help I
> have found so far is telling me to install Microsoft Visual C++, which
I
> don't want to do really.  There must be a way of doing this without
> installing this package.
>
> I am using a Windows 2000 box.
>
> Thanks=20
>
>
> Adam Shallcross
> Programmer/Developer
> aes@starfishuk.com
>
> Office:       +44 (0) 20 8674 9161
> Fax:          +44 (0) 20 8674 2849
> Telephone: +44 (0) 70 0390 2293
>
> www.starfishuk.com <http://www.starfishuk.com/>=20
> www.teamstarfish.com <http://www.teamstarfish.com/>=20
>
> WARNING: For your own safety all email attachments should be=20
> virus scanned prior to opening. This communication contains=20
> information which is confidential and may be privileged. If you are
not=20
> the addressee, you may not copy or otherwise use the information.=20
> Please note that the opinions expressed in this communication are=20
> not necessarily those of Starfish Media UK Ltd.
>
> If you receive this email by mistake, please notify us immediately at:
> info@starfishuk.com
>
> Thank you.
>
>
>
>
> --__--__--
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://lists.zope.org/mailman/listinfo/zope-db
>
>
> End of Zope-DB Digest
>

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://lists.zope.org/mailman/listinfo/zope-db