January 2001 - Zope - Zope lists

Re: [Zope] What's up with MySQL and Zope?
by paul_s_johnson＠urscorp.com 09 Jan '01

09 Jan '01

Why? I don't know, but here's what I did (still not 100% successfully so user beware). Use MySQLDA (a Zope Product) and MySQL-python (not a Zope Product, but a helper python module). The most painless way to get them installed (on Linux) is from RPMs at ftp://ftp.logicetc.com/pub/Zope/RPMS/MySQL-python-0.2.1-1.i386.rpm ftp://ftp.logicetc.com/pub/Zope/RPMS/Zope-ZMySQLDA-1.2.0-1.i386.rpm There may be some other rpm dependencies such mysql-devel and python-devel that if you don't have handy, you can find at http://www.rpmfind.net Some follow-up threads that will likely contain critical information (some reconstruction may be necessary if the following lengthy links are word-wrapped in your email reader): http://zope.nipltd.com/public/lists/zope-archive.nsf/Main/BB05A28ADA1495338… [Zope]TroublecompilingZMySQLDA http://zope.nipltd.com/public/lists/zope-archive.nsf/Main/A74B8510060DD8248… [Zope]problemconnectingtomysql Your point about this being complicated is valid. I am on day three of trying to make it work myself. The Howtos on http://www.zope.org are out-of-date. Some Zope guru out there should cook up a current Howto for us pathetic newbies (hint, hint). >What's up with MySQL and Zope? > >Now there are four different products that are related >to MySQL and Zope. Which one should I use? > >Some don't even look like DA's for zope. Why are >these listed in Zope's product page anyway? > >Why can't they all get coordinated? > >Jason

1 0

RE: [Zope] Currency formatting
by Menard.Jean-Francois＠hydro.qc.ca 09 Jan '01

09 Jan '01

Tanks! Work great! -----Message d'origine----- De : Andy McKay [mailto:andym@ActiveState.com] Envoyé : mardi 9 janvier 2001 14:31 À : Menard.Jean-Francois(a)hydro.qc.ca; zope(a)zope.org Objet : Re: [Zope] Currency formatting >From the quick hack department: 1: hack the source: DT_Var line 375... or 2: Write a bit DTML method that is along the lines of: return_money: <dtml-var value thousands_commas fmt=dollars-and-cents> then a DTML Document that has wher value is the value you want: <dtml-call "REQUEST.set('v', return_money(_.None, _, value=value))"> <dtml-call "REQUEST.set('v', _.string.replace(v, ',', ' '))"> <dtml-call "REQUEST.set('v', _.string.replace(v, '.', ','))"> <dtml-var v> 3: This could of course using PythonScript much better.... -- Andy McKay. ----- Original Message ----- From: <Menard.Jean-Francois(a)hydro.qc.ca> To: <zope(a)zope.org> Sent: Tuesday, January 09, 2001 10:41 AM Subject: [Zope] Currency formatting > I would like to output currency as: 1 300 459,63$ > I looked at the documention, and I cannot figure how to: > > - Place spaces instead of commas as thousand separators. > - Replace the dot by a comma for the decimals. > > Any clues? > > Jean-François Ménard > Intranet DPAS > Pratiques d'affaires et orientations > * (514) 840-3000 poste 3939 > * (514) 840-5585 > * menard.jean-francois(a)hydro.qc.ca > * 855 Ste-Catherine est, 6e étage > Montréal, Qué. H2L 4P5 > > > _______________________________________________ > Zope maillist - Zope(a)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 ) > _______________________________________________ Zope maillist - Zope(a)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 )

2 1

Re: [Zope-dev] RE: [Zope] ZDESIGN IDEAS = How to improve 'manage' ? ?
by Ken Manheimer 09 Jan '01

09 Jan '01

This thread should not be crossposted to both mailling lists. I posted a followup to zope-dev, please see there if you want to respond. In general, please do *not* cross-post - it's almost never justified, certainly isn't in this case. Ken Manheimer klm(a)digicool.com

1 0

RE: [Zope] MySQL connection woes
by paul_s_johnson＠urscorp.com 09 Jan '01

09 Jan '01

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 that all privileges are on and still no luck. P. Johnson >>For a quick test, run the mysql client from the command line. >> >>Let's say your connection string was: >> foodb paul passwd >> >>Start mysql like this: >>$ mysql -u paul -p foodb >> >>And when prompted for the password, enter passwd. >> >>This will ensure mysql is setup correctly. Make sure you do this from >>the same machine that is running Zope, as MySql can be configured for >>different access from different machines. >> >>If you want to play with "null" passwords and such, look at the >>mysql.user and mysql.db tables. Remember to run "mysqladmin >>flush-privileges" after making changes to the user and db tables. > >This last part I did not know, thanks! > >Ok, I am getting closer. I finally found a connection string that Zope >accepts, but now when I test the connection with a query like "SHOW >TABLES;" or a SELECT query it I get the message: > > "There was no data matching this Z MySQL Database Connection >(connected) query." > >- even though I know these tables exist. The connection says that it is >open and it will only accept connection strings of databases that really >exist in MySQL. >INFO: >MySQL user name: root >hostname: www.myhost.com >password: none > >Zope Connection string: mydatabase(a)www.myhost.com root > >In the grant tables there is the following entries: >In user: root(a)www.myhost.com with no privileges >In db: root(a)www.myhost.com with all privileges for mydatabase.* except for >Grant_priv > >One other parameter that may have a bearing: the box's name is >station99.ispname.net even though it hosts www.myhost.com (or is it the >other way around?). > >Any suggestions why the connection is not working properly?

1 0

What's up with MySQL and Zope?
by Jason Byron 09 Jan '01

09 Jan '01

What's up with MySQL and Zope? Now there are four different products that are related to MySQL and Zope. Which one should I use? Some don't even look like DA's for zope. Why are these listed in Zope's product page anyway? Why can't they all get coordinated? Jason __________________________________________________ Do You Yahoo!? Yahoo! Photos - Share your holiday photos online! http://photos.yahoo.com/

1 0

RE: [Zope] Creating a Database connection.
by Farrell, Troy 09 Jan '01

09 Jan '01

We need more specific information to help you. I'll give you an example: I run one zope installation on Windows NT 4.0SP6. I use PostgreSQL 7.0.3 on WindowsNT with Cygwin. 1)install Zope 2)compile PostgreSQL with ODBC support and install it 3)install ZODBCDA (Zope ODBC Database adapter) 4)install psqlodbc.dll to enable Windows ODBC to connect to Postgres through ODBC 5)add an ODBC connection to PostgreSQL through the Windows Control Panel 6)Start Zope and login as a Manager 7)Add a ZODBCDA connection through the drop-down box at the bottom. 7a)select your new-fangled ODBC connection as the connect string 8)select the test tab of your connection object to test the connection 9)create a new ZSQL method to use your connection See...Easier than a 12-step program Troy -----Original Message----- From: Spicklemire, Jerry [mailto:Jerry.Spicklemire@IFLYATA.COM] Sent: Saturday, January 06, 2001 3:49 PM To: 'darren.carney(a)RevolutionLtd.com' Cc: 'zope(a)zope.org' Subject: [Zope] Creating a Database connection. Darren wrote: > I am very new to the Zope idea. I like what Zope is trying > to do. But I am trying to set up an external SQL database > connection While it would be ideal for one set of instructions to serve every possible requirement, in reality it will be best for you to provide as much detail as you can about the specific scenario you are facing. For starters: What Operating System will Zope be hosted on? What Database "backend" do you need to connect to? Will the Database be resident on the same system as Zope? If not, what Operating System will be hosting the Database? Get back to the list with the answers, and anything else you think might help, plus what you have already tried, that hasn't worked. Later, Jerry S. _______________________________________________ Zope maillist - Zope(a)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 )

1 0

RE: [Zope] MySQL connection woes
by paul_s_johnson＠urscorp.com 09 Jan '01

09 Jan '01

"Randall F. To: <paul_s_johnson(a)urscorp.com> Kern" cc: <randy@spoke. Subject: RE: [Zope] MySQL connection woes net> 01/09/01 12:08 PM >For a quick test, run the mysql client from the command line. > >Let's say your connection string was: > foodb paul passwd > >Start mysql like this: >$ mysql -u paul -p foodb > >And when prompted for the password, enter passwd. > >This will ensure mysql is setup correctly. Make sure you do this from >the same machine that is running Zope, as MySql can be configured for >different access from different machines. > >If you want to play with "null" passwords and such, look at the >mysql.user and mysql.db tables. Remember to run "mysqladmin >flush-privileges" after making changes to the user and db tables. This last part I did not know, thanks! Ok, I am getting closer. I finally found a connection string that Zope accepts, but now when I test the connection with a query like "SHOW TABLES;" or a SELECT query it I get the message: "There was no data matching this Z MySQL Database Connection (connected) query." - even though I know these tables exist. The connection says that it is open and it will only accept connection strings of databases that really exist in MySQL. INFO: MySQL user name: root hostname: www.myhost.com password: none Zope Connection string: mydatabase(a)www.myhost.com root In the grant tables there is the following entries: In user: root(a)www.myhost.com with no privileges In db: root(a)www.myhost.com with all privileges for mydatabase.* except for Grant_priv One other parameter that may have a bearing: the box's name is station99.ispname.net even though it hosts www.myhost.com (or is it the other way around?). Any suggestions why the connection is not working properly?

1 0

Re: [Zope] How to set a REQUEST variable inside a PythonMethod?
by Dieter Maurer 09 Jan '01

09 Jan '01

=?iso-8859-1?Q?Juan_Carlos_Coru=F1a?= writes: > REQUEST.update({'NoRows': 4}) REQUEST.other.update({'NoRows': 4}) > REQUEST.set('NoRows', 4) This, too, should work, as Evan already said. Dieter

1 0

RE: [Zope] [Newbie] Can Zope ...
by Dieter Maurer 09 Jan '01

09 Jan '01

=?iso-8859-1?Q?Max_M=F8ller_Rasmussen?= writes: > Zope can easily do most all of the things you mention in zClasses. The most > difficult items you are requesting though is calendaring and discussion. I looked at SquishDot, at it seems not to be bad for discussions (a la bulletin board). Calender generation is facilitated by the "Calendar" tag. Dieter

1 0

Re: [Zope] Unidentified problem with SiteRoot
by Dieter Maurer 09 Jan '01

09 Jan '01

Kelvin Cheong writes: > ... ZSQL methods stick to their connections, even if copied ... This is not a site access problem (as Evan already told you). Search the searchable list archive. I think, I saw this (or a similar) problem already in the list. Dieter

1 0