[Zope] Problem on connect to MySQL

[Petter Enholm]

Hi,

The connection string is written like this;

database@host user password

hence you should give the following connection string:

customerDb localhost pass52696

You do not need to specify the host name when running Zope and SQL-server on
the same machine.
Also note that you should not use brackets (  [ ]  )  when specifying the
host name, if you intend to do so.

Best regards

Petter Enholm
Snapper as

----- Original Message -----
From: Angietel
To: zope@zope.org
Sent: Tuesday, December 12, 2000 4:37 AM
Subject: [Zope] Problem on connect to MySQL


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

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=Password('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!