[Zope] Problem on connect to MySQL

Angietel angietel@hotmail.com
Tue, 12 Dec 2000 11:37:24 +0800


This is a multi-part message in MIME format.

------=_NextPart_000_0017_01C0642F.E5BEC860
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

When i type in the Connection String , it will prompt out the error =
message - "illegal operation" and in my python it will exactly like =
this:-

Files\WebSite\z2.py" -D
------
2000-12-12T03:15:10 PROBLEM(100) ZServer Computing default hostname
------
2000-12-12T03:15:11 INFO(0) ZServer Medusa (V1.16.4.2) started at Tue =
Dec 12 11:
15:11 2000
        Hostname: ANGIE
        Port:8080

------
2000-12-12T03:15:11 INFO(0) ZServer FTP server started at Tue Dec 12 =
11:15:11 20
00
        Authorizer:None
        Hostname: angie
        Port: 8021
------
2000-12-12T03:15:11 INFO(0) ZServer PCGI Server started at Tue Dec 12 =
11:15:11 2
000
        Inet socket port: 8090
------
2000-12-12T03:15:11 INFO(0) ZServer Monitor Server (V1.8) started on =
port 8099

C:\Program Files\WebSite>  #// This is error msg=20

and i would like to confirm to u whether the Connection String is write =
like this:-
customerDb[@localhost]Password pass52696


In mySQL i set up the user password like this:-
INSERT INTO user
VALUES('localhost','password',PASSWORD=3DPassword('pass52696'),'Y','Y','Y=
',Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
and my Database name is CustomerDb

P/s let me know where is my mistake! Thank You!

------=_NextPart_000_0017_01C0642F.E5BEC860
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>When i type in the Connection String , =
it will=20
prompt out the error message - "illegal operation" and in my python it =
will=20
exactly like this:-</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Files\WebSite\z2.py"=20
-D<BR>------<BR>2000-12-12T03:15:10 PROBLEM(100) ZServer Computing =
default=20
hostname<BR>------<BR>2000-12-12T03:15:11 INFO(0) ZServer Medusa =
(V1.16.4.2)=20
started at Tue Dec 12 11:<BR>15:11=20
2000<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hostname:=20
ANGIE<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
Port:8080</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>------<BR>2000-12-12T03:15:11 INFO(0) =
ZServer FTP=20
server started at Tue Dec 12 11:15:11=20
20<BR>00<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Authorizer:None<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hostname:=20
angie<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Port:=20
8021<BR>------<BR>2000-12-12T03:15:11 INFO(0) ZServer PCGI Server =
started at Tue=20
Dec 12 11:15:11 2<BR>000<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
Inet=20
socket port: 8090<BR>------<BR>2000-12-12T03:15:11 INFO(0) ZServer =
Monitor=20
Server (V1.8) started on port 8099</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><STRONG>C:\Program =
Files\WebSite&gt;&nbsp; #//=20
This&nbsp;is error msg </STRONG></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>and i would like to confirm to u =
whether the=20
Connection String is write like this:-</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>customerDb[@localhost]Password=20
pass52696</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>In mySQL i set up the user password =
like=20
this:-</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>INSERT INTO user</FONT></DIV>
<DIV><FONT face=3DArial=20
size=3D2>VALUES('localhost','password',PASSWORD=3DPassword('pass52696'),'=
Y','Y','Y',Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>and my Database name is =
CustomerDb</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>P/s let me know where is my mistake! =
Thank=20
You!</FONT></DIV></BODY></HTML>

------=_NextPart_000_0017_01C0642F.E5BEC860--

_______________________________________________
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 )