Re: [Zope] Some help required but no sarcastic comments this time please

2001-01-24 Thread Stephane Bortzmeyer

On Tuesday 23 January 2001, at 23 h 17, the keyboard of "alankirk" 
[EMAIL PROTECTED] wrote:

 I am using Zope 2.2.2 on windows(this time i'd appreciate no sarcastic =
 comments this time)

Feel free to interpret every comment you don't like as "sarcastic", but it 
will not save your business.

 to this address) and the response has been pretty poor, i've even tried =
 to email people involved with the mysql database adaptors and got no =
 response.

You use a commercial operating system: pay for a commercial support.

 It is really important that i get this problem sorted now if possible as =
 my final year project for university depends on this 'bug' getting =
 fixed.

If it is important, do not run it on MS-Windows. Otherwise, some people may think you 
know nothing about software...



___
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] Some help required but no sarcastic comments this time please

2001-01-24 Thread Dario Lopez-Kästen

- Original Message -
From: "Stephane Bortzmeyer" [EMAIL PROTECTED]
Subject: Re: [Zope] Some help required but no sarcastic comments this time
please


 On Tuesday 23 January 2001, at 23 h 17, the keyboard of "alankirk"
 [EMAIL PROTECTED] wrote:

  I am using Zope 2.2.2 on windows(this time i'd appreciate no sarcastic =
  comments this time)

 Feel free to interpret every comment you don't like as "sarcastic", but it
 will not save your business.

  to this address) and the response has been pretty poor, i've even tried
=
  to email people involved with the mysql database adaptors and got no =
  response.

 You use a commercial operating system: pay for a commercial support.

  It is really important that i get this problem sorted now if possible as
=
  my final year project for university depends on this 'bug' getting =
  fixed.

 If it is important, do not run it on MS-Windows. Otherwise, some people
may think
 you know nothing about software...


And this kind of harsh response was necessary, because... ?

/dario

*end of thread*

- 
Dario Lopez-Ksten Systems Developer  Chalmers Univ. of Technology
[EMAIL PROTECTED]  ICQ will yield no hitsIT Systems  Services



___
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] Some help required but no sarcastic comments this time please

2001-01-24 Thread Geoffrey L. Wright

[EMAIL PROTECTED] writes:

 On Tue, Jan 23, 2001 at 11:17:32PM -, alankirk wrote:
  Hi there,
 
  i sent an email the other week regarding problems i've been
  experiencing with zope and MySQL. I've set up a database
  connection for zope and mysql and it sort of works. I can send
  queries to add data to my database ok but when i send a query to
  get data from my database i get one of 3 errors and my python
  server that zope runs from stops. The errors i get are Python
  experienced an error in (either nothing,MYSQL.DLL or
  PYTHON15.DLL).
 
  I am using Zope 2.2.2 on windows(this time i'd appreciate no
  sarcastic comments this time) I've sent a few emails about this
  problem to various people (including to this address) and the
  response has been pretty poor, i've even tried to email people
  involved with the mysql database adaptors and got no response.

  It is really important that i get this problem sorted now if
  possible as my final year project for university depends on this
  'bug' getting fixed.
  
  If you can give me help on this or point me in the direction of
  someone who can, i'd be grateful
 
  Cheers
  
  Alan
 
 Alan:
 
 This is not meant sarcastically.
 
 You are probably the only person who has ever tried to do this!
 Probably no one can help you.  (In case people don't remember, Alan
 is working on Win9x; windows 98, as I recall.)

I thought it was ME.  But hopefully it was 98

 You are working on a platform which is known for instability, with
 limited debugging capabilities.
 
 I urge you to either change to NT/SQL Server or to Linux/MySql or to
 Linux/PostgeSQL.  I can help you with the last, I suspect others can
 help you with either of the first two.
[...]

I have to concur here.  I do a _lot_ of development against MySQL --
I've dealt with it on both Win32 and various *NIXes.  MySQL is really
much more at home in a *NIX environment.  If you're completely tied to
Win32, you'd likely save yourself a lot of grief by moving to Win NT.
And if you go that far, I have to agree with Mr. Penny that SQL Server
would be a much better choice on NT for a DB.  My experiences with
MySQL on NT have tended to be frustrating -- but then I'm a fairly
poor NT admin.  But on *NIX MySQL is both extremely easy to administer
and solid as a rock.

Of course, I was a college student not so long ago, and know well that
an NT license isn't cheap.  And neither is SQL Server.  But maybe you
have a rich relative.  If not and you still really want this to work,
here's my sarcasm-free suggestion.

Pick up a used low-end Pentium.  I just grabbed a P120 with 32 megs of
RAM, a 750 meg HD and a 3Com EtherLink III for 80 bucks for use as a
firewall.  You could probably do better if you shopped around.  If you
intend to put both Zope and MySQL on the this box, I would up the RAM
to 64 megs.  The whole thing should certainly set you back less than
100 bucks.

Now install Linux.  If you're new to it, pick an easy distro like
RedHat or Mandrake.  Both have a very strait-forward install process.
If the idea if installing Linux by yourself for the first time makes
your hands tremble, find your local Linux User Group (LUG).  If you're
at a big university, check with the CS department.  They can probably
give you a contact.  In all likelihood, somebody in the LUG will be
falling over himself (herself?) to help you out.  FreeNIX people are
usually like that.  Worst come to worst, a case of cheap beer should
buy you a working install of Linux/MySQL.  In fact, if you happen to
live in Alaska I'll do it for that price!

Once you're at that point you'll probably find a lot more help.  I
think your problem at this point is simply that you have a fairly
exotic configuration.  Most people haven't seen the problems you're
having because they aren't using the same platform.  Both Zope and
MySQL are server software packages, and server software usually finds
its home on server OSes.

And even though Zope seems to bridge the great MS/*NIX cultural divide
quite nicely, MySQL is really from a *NIX world.  I think it's just
not a common choice for databases amongst Microsoft devotees.  I
would guess that 95+ percent of people who have tried to connect Zope
and MySQL have been working with some UNIX variant, and of those the
majority are probably using some flavor of Linux.

So I guess I could distill all of this advice down to one simple
statement:

If you pick a software combination used by a large number of people,
you'll likely find yourself with a strong base of user support.  If you
use an unusual combination, you may have to tough it out on your own.


Best 'o luck!


//glw


___
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] Some help required but no sarcastic comments this time please

2001-01-24 Thread Petter Enholm



Hi,

I see that you get all kinds of responses on the 
zope mailing list regarding Zope, mySQL and Windows. Hate to see that ... 
well .. to your problems:

I run Windows 2000 on my laptop with Zope 2.2.4 and 
mySQL 3.23.30. 

I even run the same Zope and mySQL setup on a 
Compaq server with Windows 4.0 in a production environment. Not the kind of 
setup I would prefer, but my customer wanted it installed on this server. 
Anyway: the setup is 100% stable, and I and my customer is really satisfied with 
the solution.

I had problems getting things working when I 
compiled the mysql.dll file manually. Instead, I downloaded the files as 
specified in the HOW-TO on mySQL in win32 environment. 

With these files installed I have no problems 
performing different queries, inserts, updates etc in the mySQL database. I have 
not experienced one crash!!

The setup has also been tested (though not 
thorougly) under Windows 95 and Windows 98!

So: try to follow the HOW-TO and download the files 
specified there. Setting up Zope  mySQL on Win32 machines takes no for me 
at all, and it always runs very well!!

Best of luck to you!

Best regards

Petter Enholm


RE: [Zope] Some help required but no sarcastic comments this time please

2001-01-24 Thread Jeff Peterson


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of alankirk
Sent: Tuesday, January 23, 2001 5:18 PM
To: [EMAIL PROTECTED]
Subject: [Zope] Some help required but no sarcastic comments this time
please


I am using Zope 2.2.2 on windows(this time i'd appreciate no sarcastic
comments this time)

I just installed MySQL 3.23.32 on Win 2000 Pro with Zope 2.3b2 by following
this HowTo:

http://www.zope.org/Members/philh/mysql

I had to edit the DA.py file at zope dir\lib\python\Products\ZMySQLDA and
change the path to the connectionAdd.dtml from
'Shared/DC/ZRDB/connectionAdd' to 'Shared/DC/ZRDB/dtml/connectionAdd'. I
then started ZOPE, created the DB from the MySQL admin interface, created a
connection object, connected, created a table and did some minor testing.
All seems to work fine currently.

So, from what I can tell, aside from the minor change noted above (which
without actually looking, I assume is a change from 2.2.x to 2.3) everything
worked fine for me, I hope that this will help or at least give you some
hope.

__
Jeffrey D. Peterson
Webmaster/Web  Web Applications Developer
Range TV Cable  Broadband
1813 E. 3rd Ave.  Hibbing, MN 55746
[EMAIL PROTECTED]


___
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] Some help required but no sarcastic comments this time please

2001-01-23 Thread alankirk



Hi there,
i sent an email the other week regarding problems 
i've been experiencing with zope and MySQL. I've set up a database connection 
for zope and mysql and it sort of works. I can send queries to add data to my 
database ok but when i send a query to get data from my database i get one of 3 
errors and my python server that zope runs from stops. The errors i get are 
Python experienced an error in (either nothing,MYSQL.DLL or PYTHON15.DLL). 

I am using Zope 2.2.2on windows(this time i'd 
appreciate no sarcastic comments this time)
I've sent a few emails about this problem to 
various people (including to this address) and the response has been pretty 
poor, i've even tried to email people involved with the mysql database adaptors 
and got no response.
It is really important that i get this problem 
sorted now if possible as my final year project for university depends on this 
'bug' getting fixed.

If you can give me help on this or point me in the 
direction of someone who can, i'd be grateful

Cheers

Alan


Re: [Zope] Some help required but no sarcastic comments this time please

2001-01-23 Thread jpenny

On Tue, Jan 23, 2001 at 11:17:32PM -, alankirk wrote:
 Hi there,
 i sent an email the other week regarding problems i've been experiencing with zope 
and MySQL. I've set up a database connection for zope and mysql and it sort of works. 
I can send queries to add data to my database ok but when i send a query to get data 
from my database i get one of 3 errors and my python server that zope runs from 
stops. The errors i get are Python experienced an error in (either nothing,MYSQL.DLL 
or PYTHON15.DLL). 
 I am using Zope 2.2.2 on windows(this time i'd appreciate no sarcastic comments this 
time)
 I've sent a few emails about this problem to various people (including to this 
address) and the response has been pretty poor, i've even tried to email people 
involved with the mysql database adaptors and got no response.
 It is really important that i get this problem sorted now if possible as my final 
year project for university depends on this 'bug' getting fixed.
 
 If you can give me help on this or point me in the direction of someone who can, i'd 
be grateful
 
 Cheers
 
 Alan

Alan:

This is not meant sarcastically.

You are probably the only person who has ever tried to do this!  Probably
no one can help you.  (In case people don't remember, Alan is working
on Win9x; windows 98, as I recall.)

You are working on a platform which is known for instability, with
limited debugging capabilities.

I urge you to either change to NT/SQL Server or to Linux/MySql or
to Linux/PostgeSQL.  I can help you with the last, I suspect others
can help you with either of the first two.

Moreover, the fact that you are getting crashes in multiple places and
.dll's suggests that you have hardware problems, like an overheating CPU,
or failing RAM.

Jim Penny

___
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] Some help required but no sarcastic comments this time please

2001-01-23 Thread Phil Harris

Alan,

So what are the errors, are there any tracebacks, does the thing your trying 
to do work when outside of Zope?

What version of MySQL is it?

Can you run any queries, or is it one particular query?

What versions of the MySQLDB and MySQLDA are you using?

Answering some/all of these questions will get you closer to an answer.

I can give you some hope though.  I have a Zope+MySQL site that has been 
running non-stop for about 7-8 months with no problems at all, so it can be 
done.

One final note, the people on the list are, as I'm sure you are, busy people. 
 They do their best to help and generally do.  Some posts slip through the 
net though, I wouldn't take offence at not getting answered.

hth

Phil
[EMAIL PROTECTED]

On Tuesday 23 January 2001 23:17, alankirk wrote:
 Hi there,
 i sent an email the other week regarding problems i've been experiencing
 with zope and MySQL. I've set up a database connection for zope and mysql
 and it sort of works. I can send queries to add data to my database ok but
 when i send a query to get data from my database i get one of 3 errors and
 my python server that zope runs from stops. The errors i get are Python
 experienced an error in (either nothing,MYSQL.DLL or PYTHON15.DLL). I am
 using Zope 2.2.2 on windows(this time i'd appreciate no sarcastic comments
 this time) I've sent a few emails about this problem to various people
 (including to this address) and the response has been pretty poor, i've
 even tried to email people involved with the mysql database adaptors and
 got no response. It is really important that i get this problem sorted now
 if possible as my final year project for university depends on this 'bug'
 getting fixed.

 If you can give me help on this or point me in the direction of someone who
 can, i'd be grateful

 Cheers

 Alan


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 


___
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] Some help required but no sarcastic comments this time please

2001-01-23 Thread Bill Anderson

Phil Harris wrote:

 Alan,
 
 So what are the errors, are there any tracebacks, does the thing your trying 
 to do work when outside of Zope?
 
 What version of MySQL is it?
 
 Can you run any queries, or is it one particular query?
 
 What versions of the MySQLDB and MySQLDA are you using?
 
 Answering some/all of these questions will get you closer to an answer.

Agreed

 I can give you some hope though.  I have a Zope+MySQL site that has been 
 running non-stop for about 7-8 months with no problems at all, so it can be 
 done.
 
 One final note, the people on the list are, as I'm sure you are, busy people. 
  They do their best to help and generally do.  Some posts slip through the 
 net though, I wouldn't take offence at not getting answered.

I would add that many of us (specially the more busy ones) ignore posts in 
HTML, so posting in plain text is very helpful. Just thought I'd help you 
to get help quicker. :)

Bill

PS. I skipped the request for help because I don't use MySQl, and thus 
wouldn't be able to help much, if any. ;^)=


___
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] Some help required but no sarcastic comments this time please

2001-01-23 Thread alan

alan,

it seems like people are trying to help you.  NOTE: no ones getting paid to
answer your questions :)

here are binaries for win32 for PostgreSQL and MySQL,
http://highqualdev.com/

you can probably try these w/ the existing DA's

~runyaga




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