Re: [Zope] MySQL-python-1.2.2 ImportError

2009-01-21 Thread Michael Backhaus
Well, I guess it was my bet ... solaris uses 'crle' for the ld configuration. I included the mysql-lib directory and it seems to work now. On Wed, 2009-01-21 at 06:20 +0530, Chetan Kumar wrote: On Wed, Jan 21, 2009 at 3:19 AM, SolidEther solidet...@gmx.net wrote: ImportError: ld.so.1: python:

[Zope] MySQL-python-1.2.2 ImportError

2009-01-20 Thread SolidEther
Hi Everyone, I am having trouble to make use of a compiled version of MySQL- python-1.2.2 with Zope/Python under OpenSolaris snv_101b. I installed Zope/Plone (running) and need mysql-python to be compiled with the python version (2.4) that came with zope. I further compiled MySQL 5.1.30 and

Re: [Zope] mysql and LOAD DATA INFILE

2008-10-15 Thread Andreas Jung
On 15.10.2008 13:16 Uhr, [EMAIL PROTECTED] wrote: hello everybody! this is a 50%zope and 50%mysql question..hope somebody here will help me..:-) in PC1: are running a mysql and zope+Plone server. A zsql method imports a csv file into mysql using a LOAD DATA LOCAL INFILE and all runs OK when

[Zope] mysql and LOAD DATA INFILE

2008-10-15 Thread tangonights
hello everybody! this is a 50%zope and 50%mysql question..hope somebody here will help me..:-) in PC1: are running a mysql and zope+Plone server. A zsql method imports a csv file into mysql using a LOAD DATA LOCAL INFILE and all runs OK when the file is in the PC1 filesystem. I know that

Re: [Zope] MySQL reconnects on zope application level

2008-07-17 Thread Jonas Meurer
On 16/07/2008 Peter Bengtsson wrote: I don't have an easy answer but if you do dig into Andy's code and try to implement this, I would suggest you look at the ZPsycopgDA code perhaps and look for inspiration since I think that one works much better. Thanks, but finally I found an easier

[Zope] MySQL reconnects on zope application level

2008-07-16 Thread Jonas
Hello, On several zope 2.10.6 instances we discovered issues with database connections to MySQL. Apparently MySQL seems to not automaticly reconnect connections with a timeout since version 5.0.3 due to issues with transactions. Until now, mysql-python was patched to restore that behaviour to

Re: [Zope] MySQL reconnects on zope application level

2008-07-16 Thread Peter Bengtsson
I don't have an easy answer but if you do dig into Andy's code and try to implement this, I would suggest you look at the ZPsycopgDA code perhaps and look for inspiration since I think that one works much better. 2008/7/16 Jonas [EMAIL PROTECTED]: Hello, On several zope 2.10.6 instances we

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-21 Thread Hugo Ramos
Hello David, It makes sense to me! The only thing I was using as a binary was Python 2.4.4 universal binary. I guess if I was using Python from the source it should work then. Thank you very much. Hugo On Thu, Feb 21, 2008 at 3:01 AM, David Pratt [EMAIL PROTECTED] wrote: Hi Hugo. I believe

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-21 Thread David Pratt
Hi Hugo. Yes, that's true but of course you have to consider all of the other frameworks that apple has already put on your machine. Much of the problem will come when linking the libraries when compiling. So in fact it is a bigger issue and requires much of the base software to recompiled

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-21 Thread Tino Wildenhain
Hugo Ramos wrote: Well, I went googling for this error... Google gives 1 (one) answer!!! The worst part is that it's related to django and mod_python. I guess nobody solved this yet... I'll have to go back to OS X 10.4 (Tiger). You could also forward to Postgres :-) Unless you have a very

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-20 Thread Hugo Ramos
Hey Kumar, I like to think that the amount of time I could make anyone here spend looking for something is VERY well spent. That link you sent me is just 1 of the about 50 I searched on google before posting the problem. :-) I can tell you now that cp, mv and ln are not the solution. I can also

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-20 Thread Hugo Ramos
Hello Chetan, Well thank you very much! I must be very tired to forget to compile MySQL without --enable-thread-safe-client !!! It seems that MySQL-python now compiles with a warning: ld: warning in /usr/local/mysql/lib/mysql/libmysqlclient_r.dylib, file is not of required architecture But when

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-20 Thread Hugo Ramos
Well, I went googling for this error... Google gives 1 (one) answer!!! The worst part is that it's related to django and mod_python. I guess nobody solved this yet... I'll have to go back to OS X 10.4 (Tiger). omg... Thanks Hugo On Feb 20, 2008 12:31 PM, Hugo Ramos [EMAIL PROTECTED] wrote:

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-20 Thread Hugo Ramos
Where did you get that file? MySQL-Python at sourceforge? Thanks On Feb 20, 2008 5:28 PM, Giampiero Benvenuti [EMAIL PROTECTED] wrote: I used MySQL_Python-1.2.1_p2-py2.4-macosx10.4.zip with 10.5 and It works just fine. Giampiero On Feb 20, 2008, at 8:52 AM, Hugo Ramos wrote: Well,

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-20 Thread Hugo Ramos
Forget it... Just found the file at: http://pythonmac.org/packages/py24-fat/index.html Thanks a lot! Hugo On Feb 20, 2008 5:57 PM, Hugo Ramos [EMAIL PROTECTED] wrote: Where did you get that file? MySQL-Python at sourceforge? Thanks On Feb 20, 2008 5:28 PM, Giampiero Benvenuti [EMAIL

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-20 Thread Hugo Ramos
Man... I should buy you a drink at Lisbon when you decide to come here!!! :-) The binary package works fine now! I just wish someone would answer about the compilation warning and import error in Zope. Thank you very much Really appreciated Hugo On Wed, Feb 20, 2008 at 8:47 PM, Giampiero

Re: [Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-20 Thread David Pratt
Hi Hugo. I believe 'file is not of required architecture' may be the clue here. Ever since mac went to universal binaries, folks with ppc have been having trouble since it is compiled with i386 arch flags and vice versa for folks with intel macs (with ppc arch flags). The only way to get

[Zope] MySQL-python-1.2.2 breaks compiling on Mac OS X 10.5 (Andy Dustman?)

2008-02-19 Thread Hugo Ramos
Yellow ppl, I'm having a problem I didn't have in OS X 10.4 (tiger)... When compiling MySQL-python-1.2.2 on OS X 10.5 (leopard) I get a very annoying error I'm not being able to solve. I've tried moving, copying and linking libraries around but nothing seems to work. Anyone seen this before?

Re: [Zope] MySql connector error

2007-08-27 Thread Pelletier Vincent
Le Samedi 25 Août 2007 17:07, Kevin a écrit : Intermittently, I recieve an error *Shouldn't load state for 0xf5f137 when the connection is closed * This means there is somewhere a reference to a persistent object which keeps it past transaction commit, which is a bad behaviour. I

Re: [Zope] MySql connector error

2007-08-27 Thread Kevin
Your right, the older mysql da I was using gave 'Shouldn't Load State When Connection is Closed'. It turns out that my DA is implemented correctly, but the database cursor is being persisted in another object(past transaction commit) as you noted. So, with some readjusting, the error seems

[Zope] MySql connector error

2007-08-25 Thread Kevin
I have a mysqldb connector object based on http://svn.zope.org/mysqldbda/ under zope 2.9.7 Intermittently, I recieve an error *Shouldn't load state for 0xf5f137 when the connection is closed * I implemented this object because the standard mysql database adapter would fail if the connection

[Zope] Mysql Lock Unlock with zsql

2007-05-04 Thread trashman
Hi, I must use mysql lock/unlock with zsql. I haven't found anything about it. There is any solutions? I must lock a table but i don't know how do it :( max ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No

Re: [Zope] Mysql Lock Unlock with zsql

2007-05-04 Thread Andreas Jung
--On 4. Mai 2007 17:34:23 +0200 [EMAIL PROTECTED] wrote: Hi, I must use mysql lock/unlock with zsql. I haven't found anything about it. There is any solutions? I must lock a table but i don't know how do it :( Since LOCK is a SQL statement you can *of course* integrate with ZSQL

Re: [Zope-DB] URL Loading Error - Zope+MySQL

2006-11-16 Thread Jens Vagelpohl
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 16 Nov 2006, at 06:23, oknam park wrote: Hi All, I'm trying to add data in mysql database using DTML in Zope. But, all other fields are okay. But, url fiels does not call URL I entered. Instead it generates the url for add dtml method like

[Zope-DB] URL Loading Error - Zope+MySQL

2006-11-15 Thread oknam park
Hi All, I'm trying to add data in mysql database using DTML in Zope. But, all other fields are okay. But, url fiels does not call URL I entered. Instead it generates the url for add dtml method like http://www.thegateway.org/about/gemingeneral/gemConsortium/memberDirectory/contactadd. Could

Re: [Zope-DB] URL Loading Error - Zope+MySQL

2006-11-15 Thread oknam park
Hi, Terribly Sorry for cross posting. and not clear explanation. Sincerely, Nam From: Andreas Jung [EMAIL PROTECTED] Reply-To: Andreas Jung [EMAIL PROTECTED] To: oknam park [EMAIL PROTECTED], zope-db@zope.org Subject: Re: [Zope-DB] URL Loading Error - Zope+MySQL Date: Thu, 16 Nov 2006 06:44

Re: [Zope-DB] URL Loading Error - Zope+MySQL

2006-11-15 Thread Andreas Jung
--On 16. November 2006 06:10:11 + oknam park [EMAIL PROTECTED] wrote: Hi, Terribly Sorry for cross posting. and not clear explanation. Unclear? You posted a simple HTML form and said something about MySQL. All RDMBS issues *including examples* are documented when you follow the

[Zope] mysql socket problem, MOSX 10.4.7

2006-08-09 Thread baiewola
Yesterday I finally updated my MOSX Server 10.4.6 to 10.4.7. In addition to usual list of hosed configuration files and scripts, we now have a problem with Zope 2.7.x connecting to MySQL through a unix socket. We can connect with PHP apps, Filemaker Pro, and MySQL client. However, all Z MySQL

Re: [Zope] mysql socket problem, MOSX 10.4.7

2006-08-09 Thread Dieter Maurer
baiewola wrote at 2006-8-9 05:16 -0700: ... We can connect with PHP apps, Filemaker Pro, and MySQL client. However, all Z MySQL database connections are broken. Here is the error: OperationalError: (2002, Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)) After googling

[Zope] MySQL queries in Python

2006-08-01 Thread Muk Yan
Dear Coveted Braintrust,I was wondering if anyone had any experience with MySQL queries in Python in Zope:import MySQLdbimport stringrequest = container.REQUESTsession = request.SESSION result = (context.aq_parent).selects.select_from_table()print resultreturn printedWHERE

Re: [Zope] MySQL queries in Python

2006-08-01 Thread Jonathan
Have a look at this: http://www.zope.org/Members/spinwing/ZSQL_Results Jonathan - Original Message - From: Muk Yan To: zope@zope.org Sent: Tuesday, August 01, 2006 2:50 PM Subject: [Zope] MySQL queries in Python Dear Coveted Braintrust,I was wondering

Re: [Zope] MySQL queries in Python

2006-08-01 Thread Andreas Jung
--On 1. August 2006 14:50:19 -0400 Muk Yan [EMAIL PROTECTED] wrote: I know the MySQL query works, but I get garbage results from the python script (Shared.DC.ZRDB.Results.Results instance at 0x132a5c88). All I want is to contain the results of the SQL query in a list or container. Zope

Re: [Zope] MySQL queries in Python

2006-08-01 Thread John Barham
import MySQLdb This is probably redundant. import string request = container.REQUEST session = request.SESSION result = (context.aq_parent).selects.select_from_table() print result Assuming you want the person's name printed, change this line to: print result[0].name Think of the

Re: [Zope] MySQL queries in Python

2006-08-01 Thread Dennis Allison
Usually you install the database adaptor ZMySQLDB and make queries through a ZSQL Method object. On Tue, 1 Aug 2006, Muk Yan wrote: Dear Coveted Braintrust, I was wondering if anyone had any experience with MySQL queries in Python in Zope: import MySQLdb import string request =

Re: [Zope] MySQL queries in Python

2006-08-01 Thread Paul Winkler
On Tue, Aug 01, 2006 at 02:50:19PM -0400, Muk Yan wrote: Dear Coveted Braintrust, I was wondering if anyone had any experience with MySQL queries in Python in Zope: People have already answered your main question, but: SELECT name FROM person WHERE ID = dtml-var

Re: [Zope] MySql 5.0, ZMySQLDA and stored procedures

2006-01-17 Thread Greg Fischer
Yeah, I put up a patch on the MySQLDb Sourceforge page a long time ago for that. Doing almost the same thing. Only I made it so you specify the client flag in the Zope connection object. Doesnt do any good for windows though, they still have a problem with the mysql lib. (I think I posted a bug on

Re: [Zope] MySql 5.0, ZMySQLDA and stored procedures

2006-01-17 Thread Dieter Maurer
Cameron Beattie wrote at 2006-1-17 17:37 +1300: I was getting the following error when attempting to call a stored procedure via a Z SQL Method: _mysql_exceptions.OperationalError: (1312, etc You consult your MySQL documentation to find out what the error code 1312 means... -- Dieter

[Zope] MySql 5.0, ZMySQLDA and stored procedures

2006-01-16 Thread Cameron Beattie
I was getting the following error when attempting to call a stored procedure via a Z SQL Method: _mysql_exceptions.OperationalError: (1312, etc So I made the following change to /usr/lib/zope/lib/python/Products/ZMySQLDA/db.py: def _parse_connection_string(self, connection): kwargs

[Zope] MySql problems

2005-12-01 Thread Dennis Allison
I have not yet completed differential diagnosis, but I was hoping someone had encountered a similar problem and could pass along a fix/workaround. The following program fails to do the writes -- import MySQLdb initdb='test' dbuser = 'root' dbpass = 'XX' host = 'localhost' connection =

Re: [Zope] MySql problems

2005-12-01 Thread Tino Wildenhain
Am Donnerstag, den 01.12.2005, 15:45 -0800 schrieb Dennis Allison: I have not yet completed differential diagnosis, but I was hoping someone had encountered a similar problem and could pass along a fix/workaround. The following program fails to do the writes -- import MySQLdb

Re: [Zope-DB] related to Plone+Zope+MySQL

2005-11-13 Thread -bhavana -
hi, i mean to say i create one protlet and search to my MySQL database but the result is shown in non Plone page. how to i display my result in body of Plone? please help. thankx in advance. bh On 11/11/05, Andreas Jung [EMAIL PROTECTED] wrote: --On 11. November 2005 14:27:49 +0700 -bhavana -

[Zope-DB] related to Plone+Zope+MySQL

2005-11-10 Thread -bhavana -
Dear all, i have connection with MySQL from Zope and Plone and i create search from Zope and Plone too. But i cant search from the portlet that is in Plone interface to MySQL database. Please help me out of this... thankx in advance bh ___ Zope-DB

Re: [Zope-DB] related to Plone+Zope+MySQL

2005-11-10 Thread Andreas Jung
--On 11. November 2005 14:27:49 +0700 -bhavana - [EMAIL PROTECTED] wrote: Dear all, i have connection with MySQL from Zope and Plone and i create search from Zope and Plone too. But i cant search from the portlet that is in Plone interface to MySQL database. Please help me out of this...

Re: [Zope] Mysql 5? Just curious.

2005-10-06 Thread Chris Withers
Richard Smith wrote: A very quick test shows the basics work just fine (adding a record to a table and displaying the whole table). Just watch authentication - they've changed the password algorithms again as in the 3/4 upgrade. The work around is in the manual. rats, probably only an

Re: [Zope] Mysql 5? Just curious.

2005-10-06 Thread Tino Wildenhain
Greg Fischer schrieb: This is totally unimportant, but I was just curious to know if anyone is running Mysql 5 on Zope right now. why should one? :) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or

Re: [Zope] Mysql 5? Just curious.

2005-10-06 Thread Greg Fischer
I guess it's not a matter of should, but rather a preference. I am running it just fine on Linux. Had to do some tweeks to the ZMySQLDA, but it works great. Stored Procedures and everything. I just havent seen hardly anyone testing it, so I thought I would ask around and see if others are running

Re: [Zope] Mysql 5? Just curious.

2005-10-05 Thread Chris Withers
Greg Fischer wrote: This is totally unimportant, but I was just curious to know if anyone is running Mysql 5 on Zope right now. That would be some achievement! ISn't MySQL written in C++ or something? Seriously though, Andy Dustman is your man, maybe try compiling mySQLdb and seeing if it'll

[Zope] Mysql 5? Just curious.

2005-10-04 Thread Greg Fischer
This is totally unimportant, but I was just curious to know if anyone is running Mysql 5 on Zope right now. -- Greg Fischer1st Byte Solutionshttp://www.1stbyte.com ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No

[Zope] mysql-python build error

2005-09-13 Thread Sophia Grimm
I installed Plone 2.1 from the binary installer at plone.org and MySQL 4.1 from the binary at mysql.com. When attempting to build MySQL-python-1.2.0 on MOSX 10.4.2 client, I get this error: sh: line 1: mysql_config: command not found sh: line 1: mysql_config: command not found running build

Re: [Zope] mysql-python build error

2005-09-13 Thread Sophia Grimm
It turned out there were two different problems at work here. First, I had to hard code the paths of my include_dirs and include_lib. Second, I didn't realize my bash shell wasn't taking the export command. I had to edit my bash profile to set the mysqlclient environment variable (which is the

[Zope] error: release unlocked lock with Zope/MySQL

2005-08-06 Thread Dennis Allison
[Reposted with a non-blank Subject field] We've been seeing this problem for some time. Earlier postings to the list were helpful in that we have eliminated possible causes, but the problem has never been resolved. Any assistance in tracking down the problem and fixing it would be greatly

Re: [Zope] MySQL timestamp issue

2005-06-06 Thread Hugo Ramos
Yellow Andy, In fact what you've said works! That line was missing on db.py and after I inserted it there everything works the right way. I guess this thread is now over. Thanks!!! Cheers Hugo On 6/3/05, Andy Dustman [EMAIL PROTECTED] wrote: On 6/3/05, Hugo Ramos [EMAIL PROTECTED] wrote:

Re: [Zope] MySQL timestamp issue

2005-06-03 Thread Chris Withers
Hugo Ramos wrote: Could anyone explain me why this works in Zope 2.7.0 final and doesn't work in Zope 2.7.6 final and/or 2.8.0b1 ?? If Zope is really hanging, look at DeadlockDebugger and find out where it's hanging... Chris -- Simplistix - Content Management, Zope Python Consulting

Re: [Zope] MySQL timestamp issue

2005-06-03 Thread Hugo Ramos
I already know what exactly makes Zope hang! The problem is located at times.py that was installed by MySQL-Python 1.2.0 (MySQL-python.exe-1.2.0.win32-py2.4.zip) ==OLD== def mysql_timestamp_converter(s): Convert a MySQL TIMESTAMP to a Timestamp object. s = s +

Re: [Zope] MySQL timestamp issue

2005-06-03 Thread Andy Dustman
On 6/3/05, Hugo Ramos [EMAIL PROTECTED] wrote: I already know what exactly makes Zope hang! The problem is located at times.py that was installed by MySQL-Python 1.2.0 (MySQL-python.exe-1.2.0.win32-py2.4.zip) This is a package for Python-2.4. Are you using Python-2.4 with Zope-2.7? If you are,

Re: [Zope] MySQL timestamp issue

2005-06-03 Thread Hugo Ramos
Yellow, I wrote the wrong version. I'm using MySQL 4.0.24 + Zope 276 + mysql-python 1.0.0 + ZMySQLDA 2.0.9b3 This is the DTML code generating the error: dtml-var docdataemissao fmt=%Y-%m-%d docdataemissao is a timestamp field in a table like: 200406011023 The traceback: Error Type: ValueError

Re: [Zope] MySQL timestamp issue

2005-06-03 Thread Andy Dustman
On 6/3/05, Hugo Ramos [EMAIL PROTECTED] wrote: Yellow, I wrote the wrong version. I'm using MySQL 4.0.24 + Zope 276 + mysql-python 1.0.0 + ZMySQLDA 2.0.9b3 Take a look at ZMySQLDA/db.py:

[Zope] MySQL timestamp issue

2005-06-02 Thread Hugo Ramos
Yellow, Could anyone explain me why this works in Zope 2.7.0 final and doesn't work in Zope 2.7.6 final and/or 2.8.0b1 ?? dtml-var timestampvar fmt=%Y-%m-%d also when I try this: dtml-var _.DateTime(timestampvar) fmt=%Y-%m-%d Zope hangs!!! ps: timestampvar is a timestamp var comming

Re: [Zope] MYSQL Problem

2001-01-29 Thread Andy Dustman
On Sun, 28 Jan 2001, Jens Grewen wrote: I installed mySQL-3.23.32 mySQLdb 0.3.1 ZmySQLDA 2.0.4 When I change to mediumint (database field description) I get the expected 233. How can I fix this. You just did. :) If a mediumint is big enough for you, use that. As Ron points out,

[Zope] MYSQL Problem

2001-01-27 Thread Jens Grewen
I installed mySQL-3.23.32 mySQLdb 0.3.1 ZmySQLDA 2.0.4 on Win98 From the following SQL statmentI get the result 233L and not 233 as expected select count(PID)from product When I run this SQL Statment from another program I get the expected value 233. In my installation there are a

RE: [Zope] MYSQL Problem

2001-01-27 Thread Ron Bickers
ns, though it does happen to work with Zope 2.3.0. ___ Ron Bickers Logic Etc, Inc. [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jens Grewen Sent: Saturday, January 27, 2001 11:36 PM To: Zope Maillist Subject: [Zope] MYS

[Zope] MySQL

2001-01-26 Thread Piotr Kozbial
I have upgraded to MySQL 3.23.28 and both ZMySQLDA and ZMySQLTDA were broken.Thus I have installed latest ZMySQLDA-2.0.4 and MySQLdb 0.3.1. Ufter upgrade it does not work. I am able to search pages, ie.: http://arete.ibb.waw.pl/html/leksykon/cd_rom_report_en?nazwa_angielska=b but I am unable to

Re: [Zope] MySQL

2001-01-26 Thread Andy Dustman
On Fri, 26 Jan 2001, Piotr Kozbial wrote: I have upgraded to MySQL 3.23.28 and both ZMySQLDA and ZMySQLTDA were broken.Thus I have installed latest ZMySQLDA-2.0.4 and MySQLdb 0.3.1. MySQL-3.23.32 would be a good idea. It has at least one security fix, and a lot of bug fixes. Ufter

Re: [Zope] MySQL connection string.

2001-01-21 Thread Joachim Werner
Indra Gunawan wrote: Hello, could anyone tell me how to make connection string to MySQL in Linux? I use Zope 2.3 and I've tried the database@[host] username password This should work. Your problem is probably somewhere else. Are you sure that the database adapter, database etc. are all

[Zope] MySQL connection string.

2001-01-20 Thread Indra Gunawan
Hello, could anyone tell me how to make connection string to MySQL in Linux? I use Zope 2.3 and I've tried the database@[host] username password format, and still no luck, TIA, -IGUN- ___ Zope maillist - [EMAIL PROTECTED]

[Zope] mysql connection string

2001-01-15 Thread Olaf Zanger
hi there, two times trouble first: right now my setup uses a connection string "db root" which doesn't seam to give a lot of savety :-). at my provider i have a login, but sure no root access to the db. * how does the connection string look for user name "peter-hauser" and password

Re: [Zope] mysql connection string

2001-01-15 Thread Oleg Broytmann
On Mon, 15 Jan 2001, Olaf Zanger wrote: right now my setup uses a connection string "db root" which doesn't seam to give a lot of savety :-). at my provider i have a login, but sure no root access to the db. * how does the connection string look for user name "peter-hauser" and password

RE: [Zope] MySQL

2001-01-11 Thread Eric Walstad
http://www.zope.org/Members/alanpog/zmysqlda_steps Should get you started... Eric. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of vishnu prasad Sent: Tuesday, January 09, 2001 3:17 PM To: [EMAIL PROTECTED] Subject: [Zope] MySQL can anyone update me

Re: [Zope] MySQL

2001-01-11 Thread Petter Enholm
documentation. Best regards Petter Enholm Also: - Original Message - From: "Eric Walstad" [EMAIL PROTECTED] To: "vishnu prasad" Cc: "[EMAIL PROTECTED]" [EMAIL PROTECTED] Sent: Wednesday, January 10, 2001 12:32 AM Subject: RE: [Zope] MySQL http://www.zope.org/

[Zope] MySQL connection woes

2001-01-09 Thread paul_s_johnson
s whole thing (Linux, Zope, MySQL, etc.), how do I create a null login in MySQL with blanket privleges? Could it still be a faulty ZMySQLDA setup? How do I troubleshoot that possibility? Thanks, P. Johnson ___ Zope maillist - [EMAIL PROTECTED] h

Re: [Zope] MySQL connection woes

2001-01-09 Thread Luciano Ramalho
roblem. I have tried a nologin mysql and it worked with database@myhost !!! :) so i know i have a grant table problem in mysql (no big deal - i hope :) ) QUESTION: Being a relative newbie to this whole thing (Linux, Zope, MySQL, etc.), how do I create a null login in MySQL with blanket privl

RE: [Zope] MySQL connection woes

2001-01-09 Thread paul_s_johnson
andy@spoke.Subject: RE: [Zope] MySQL connection woes

RE: [Zope] MySQL connection woes

2001-01-09 Thread paul_s_johnson
One other bizarre symptom: when I test the database connection with a INSERT query it works and inserts data into the designated MySQL table in the query, although there is no indication that it is working in Zope. I changed the user table for the MySQL user cited in the connection string so

[Zope] MySQL

2001-01-09 Thread vishnu prasad
can anyone update me with list of activities that I need to follow for having MySQL installed and integrated with Zope? thanks in advance, vp

[Zope] mySQL DA on Win32

2000-12-14 Thread Lee Reilly CS1997
Hi, Zope is currently being installed on the Unix machines at my uni but it won't be available for a while. However, I have set up a mySQL database in the Dept. and installed Zope on a Dept. machine (Windows 95). I can only access the database from uni so I must have a database adpater setup on

Re: [Zope] mySQL DA on Win32

2000-12-14 Thread Phil Harris
Lee, Have you read the MySQL on Win32 howto? btw, give my regards to Duncan. Phil [EMAIL PROTECTED] - Original Message - From: "Lee Reilly CS1997" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 14, 2000 2:46 PM Subject: [Zope] mySQL DA on Win32 H

Re: [Zope] mySQL DA on Win32

2000-12-14 Thread Petter Enholm
From: "Lee Reilly CS1997" [EMAIL PROTECTED] I have seen the mySQL DA on Zope.org but I understand that it "does not support win32 platforms at this time". I need database access ASAP so can anyone offer any advice? There is a HOW-TO for this: How-To: ZMySQLDA on Win32 Search for it on

Re: [Zope] mySQL DA on Win32

2000-12-14 Thread Jim Washington
Hi, Lee I got zope and mysql working together last night on win2k. I used the instructions in http://www.zope.org/Members/philh/mysql (Thanks, Phil Harris!) I did have to use the custom dll and pyd mentioned there. http://www.google.com/search?q=mysql+zope+win32 might have more clues if

RE: [Zope] mySQL DA on Win32

2000-12-14 Thread sean . upton
Couldn't one just use MyODBC and the ODBC DA? What disadvantages (besides latency from yet another API to go through) are there to this approach? Sean ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross

Re: [Zope] mySQL DA on Win32

2000-12-14 Thread Lloyd Kvam
I came across links that recommended recompiling both MySQL and the MySQL DA. I did so without too much difficuly. The batch compile scripts did not work, but compiling through the MicroSoft IDE did work. The source code I pulled down required the Microsoft compiler, not gcc++. I still have

[Zope] MySQL

2000-11-30 Thread K H Subrahmanyan
hi, I want to add MySQL to my ZOPE. Please help me in installing it. Please give the links, necessary information. thanks bye subrahmayan. ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts

Re: [Zope] MySQL

2000-11-30 Thread Chris Withers
K H Subrahmanyan wrote: hi, I want to add MySQL to my ZOPE. Please help me in installing it. Please give the links, necessary information. How about actually doing some work for yourself for a change rather than expecting everyone else to do it for you? Chris

[Zope] mysql zope

2000-11-30 Thread Alexander DePauli
Hi Zopistas! we are looking for a method to do a better integration of mysql 3.23.27 with zope 2.2.2. (we are using the Z MySQL database adapter Z MySQL DA 1.1.3.) We have to store data in a mysql database - we can´t use ZODB because we need the data accessible by other programs via ODBC. We

Re: [Zope] mysql zope

2000-11-30 Thread Steve Spicklemire
Hi Ruediger, You might consider ZPatterns. It allows you to develop applications with ZODB, and then, later, 'easily' switch to other forms of attribute storage for your objects. -steve "Alexander" == Alexander DePauli [EMAIL PROTECTED] writes: Alexander Hi Zopistas! Alexander

[Zope] MySQL Connection String

2000-11-17 Thread Aitor Grajal Crespo
I have installed ZMySQLDA 1.1.4, anybody knows the format of the database connection string??? I have put database user passw , and doesn't work Thanks

Re: [Zope] MySQL Connection String

2000-11-17 Thread Tony McDonald
On 17/11/00 4:36 pm, "Aitor Grajal Crespo" [EMAIL PROTECTED] wrote: I have installed ZMySQLDA 1.1.4, anybody knows the format of the database connection string??? I have put database user passw , and doesn't work Thanks database@host user passwd 'host' can be 'localhost' for

RE: [Zope] MySQL Connection String

2000-11-17 Thread Eric Walstad
Eric. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Aitor Grajal Crespo Sent: Friday, November 17, 2000 8:37 AM To: [EMAIL PROTECTED] Subject: [Zope] MySQL Connection String I have installed ZMySQLDA 1.1.4, anybody knows the format of the database connecti

Re: [Zope] MySQL and Zope struggles

2000-10-18 Thread Richard Moon
Thanks Monty, I did try the temporary table route - problem is that Zope keeps the connection open so the temporary table stays there. Of course you can explicitly drop the temporary table after you've used it. However if the update fails for any reason the temporary table will still exist so

RE: [Zope] MySQL and Zope struggles

2000-10-18 Thread Baker, Dennis [sjmr]
, October 16, 2000 2:48 AM To: [EMAIL PROTECTED] Subject: [Zope] MySQL and Zope struggles I'm struggling to migrate an application from Zope/PostgreSQL to Zope MySQL (Why ? - because I've got a kind offer of free hosting if I use MySQL). MySQL offers a limited set of features and is missing

Re: [Zope] MySQL and Zope struggles

2000-10-17 Thread Monty Taylor
You can do it with temporary tables. Like this- create temporary table foo ( note_id int, notes varchar ); insert into foo select Note.note_id, Note.notes from Note, Artist where Note.note_id=Artist.note_id and Artist.artist_id=23; update foo set notes="asdlfna"; replace into Note select

[Zope] MySQL and Zope struggles

2000-10-16 Thread Richard Moon
I'm struggling to migrate an application from Zope/PostgreSQL to Zope MySQL (Why ? - because I've got a kind offer of free hosting if I use MySQL). MySQL offers a limited set of features and is missing, among other things, the ability to use subqueries - so for example in PostgreSQL you can

Re: [Zope] MySQL and Zope struggles

2000-10-16 Thread administrator
I don't know if the following link can solve your problem, but maybe it gives you an idea: http://www.zope.org/Members/Roug/new_record_with_subrecords (How-To: Creating a new record with subrecords in MySQL) Arno I'm struggling to migrate an application from Zope/PostgreSQL to Zope MySQL

RE: [Zope] MySQL and Zope struggles

2000-10-16 Thread dale . w . lance
around this. It probably doesn't solve real complex scenarios either. JAT Dale -Original Message- From: administrator [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 6:11 AM To: zope Cc: administrator Subject: Re: [Zope] MySQL and Zope struggles I don't know if the following link

[Zope] Zope MySQL on Win98

2000-08-10 Thread William BC Crandall
Hello Zope and MySQL users, I'm trying to access MySQL through Zope. I hope someone can point out my set-up error(s). Environment: Windows98: 4.10.98 MySQL Server: 3.23.21-beta-debug Zope v.: 2.2.0 (binary release, python 1.5.2, win32-x86) Python v.: 1.5.2 (#0, Jul 30 1999,

[Zope] mySQL - Z SQL - dtml-var

2000-07-17 Thread Gijs Reulen
Why does this not work inside a Z SQL Method (using MySQL) ?! INSERT INTO test1 ( id, content, phone ) VALUES ( dtml-var 12.12, dtml-sqlvar content type=nb, dtml-sqlvar phone type=nb optional ) According to the doc I should be able to use dtml-var statements in Z SQL Methods. However, this

Re: [Zope] mySQL - Z SQL - dtml-var

2000-07-17 Thread Dieter Maurer
Gijs Reulen writes: INSERT INTO test1 ( id, content, phone ) VALUES ( dtml-var 12.12, dtml-sqlvar content type=nb, dtml-sqlvar phone type=nb optional ) According to the doc I should be able to use dtml-var statements in Z SQL Methods. However, this returns an error: Error,

[Zope] MySQL LIKE operator

2000-07-12 Thread Aaron Williamson
Hello, I'm writing a search query to a MySQL database. I want to keep people from screwing around with my database by running searches like "; delete from ... yada yada. So I should use dtml-sqlvar, right? But what if I want to use LIKE? If I say: WHERE goo LIKE "%dtml-sqlvar name=bar

RE: [Zope] MySQL LIKE operator

2000-07-12 Thread Ron Bickers
PROTECTED]] Sent: Wednesday, July 12, 2000 11:03 AM To: [EMAIL PROTECTED] Subject: [Zope] MySQL LIKE operator Hello, I'm writing a search query to a MySQL database. I want to keep people from screwing around with my database by running searches like "; delete from ... yada yada.

Re: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-07-04 Thread Monty Taylor
Original Message On 7/4/00, 12:47:07 AM, Andy Dustman [EMAIL PROTECTED] wrote regarding Re: [Zope] MySQL transaction support (was: MySQL Select Statements): Note also: With non-transactional databases, you would expect to get better performance by having several open connections which

RE: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-07-03 Thread Andy Dustman
On Mon, 3 Jul 2000, Monty Taylor wrote: Why not have one ZmySQLDA that attempts to determine whether it is transactional or not when the connect method is executed. That way you could have a DA connect to your 3.22 database, upgrade your database to 3.23.15 and not see any problems. A

  1   2   >