Re: [Zope] Problem on connect to MySQL
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: [EMAIL PROTECTED]
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!
___
Zope maillist - [EMAIL PROTECTED]
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 )
Re: [Zope] Problem on connect to MySQL
Correction - Too early in the morning, sorry for the inconvenience
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
You have named the user password, hence your connection string should be:
CustomerDb password pass52696
Just for the record, I'm sure you figured this out by yourself.
Best regards
Petter Enholm
- Original Message -
From: "Petter Enholm" [EMAIL PROTECTED]
To: "Angietel" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, December 12, 2000 9:23 AM
Subject: Re: [Zope] Problem on connect to MySQL
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
___
Zope maillist - [EMAIL PROTECTED]
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 )
[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
2000
Authorizer:None Hostname:
angie Port:
8021--2000-12-12T03:15:11 INFO(0) ZServer PCGI Server started at Tue
Dec 12 11:15:11 2000 Inet
socket port: 8090--2000-12-12T03:15:11 INFO(0) ZServer Monitor
Server (V1.8) started on port 8099
C:\Program Files\WebSite #//
Thisis 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!
RE: [Zope] Problem on connect to MySQL
Hello Angie,
Are you able to create a "Z MySQL Database Connection" inside Zope?
I'm not sure exactly when you are receiving your error message. Is it when
you Click the "Change" button while in the "Z MySQL Database Connection?"
Your connection string looks like it is missing a user name. It should look
something like (assuming your MySQL user name is "angie"):
customerDb@localhost angie pass52696
or in general terms
database@host user passwd
Generally when you see square brackets [ ] in documentation, the enclosed
code is optional. In the case of the connection string, the host name is
optional.
However, in my setup, I have to include the host name or my connection to
the database will fail.
Hope that helps.
Eric.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Angietel
Sent: Monday, December 11, 2000 7:37 PM
To: [EMAIL PROTECTED]
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!
___
Zope maillist - [EMAIL PROTECTED]
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 )
