- Zope-Dev - Zope lists

I'm having troubles with MySQL MONTHNAME() function
by Andres Sanchez Gomez 27 Oct '00

27 Oct '00

Hello: I'm from Argentina, as you shoud now, I speak spanish. I'm usig MySQL, as you sould also now, it's in English. I have to give de time informatio in letters. Like 'Febrero' (02, February). I found two ways, but non of them gives me good results. The first way is to ask to the database a select statemment with it's own MONTHNAME() functio. But I couldn't translate to Spanish that is what I need. The other way is to make a little function that compares the month number (selected with te MONTH() function). In this case I had the same trouble: I can't compare a DateTime MySQL function var with an other var. I can't do this: <dtml-if " Month(DATE)==' 1' >Diciembre <dtml-elif " Month(DATE)==' 2' >Febrero etc.... Thanks to anyone who can help me, or read me. And please, forget my english. Andres Sanchez Gomez

2 1

DTML Entity Syntax, was (no subject)
by Spicklemire, Jerry 27 Oct '00

27 Oct '00

Johann Loibl wonders: > What does the following line means? > > href="&dtml.url-mail_password_form; > > how to work with '&' ? This means to substitue the value stored in the variable "mail_password_form" as an "absolute URL". It's known as "DTML Entity Syntax". Check out: http://www.zope.org/Members/AlexR/EntitySyntax BTW, this is a pretty basic question, and is best addressed to the generic Zope List: zope(a)zope.org Later, Jerry S.

1 0

ZPatterns + Skinscript
by Joachim Schmitz 27 Oct '00

27 Oct '00

I trying to understand ZPatterns and using it for a real world example which uses a SQL-based storage. can I do it just by defining the appropriate SkinScript Method in my defaultrack as data plugin. Do I define everything in one SkinScript Method, and what must be the name of that method. Can I delete the Specialist Plugins, PersistentSheets and PersistenceAttributes which are created, when I add a new rack ? Could you provide a simple example ? The SkinScript syntax wiki has many examples, but not in context of a working example. Any hints are welcome Mit freundlichen Grüßen Joachim Schmitz AixtraWare, Ing. Büro für Internetanwendungen Hüsgenstr. 33a, D-52457 Aldenhoven Telefon: +49-2464-8851, FAX: +49-2464-905163

2 1

RE: [Zope-dev] Command Line Database Packing ?
by Keith Larson 27 Oct '00

27 Oct '00

Of course Zope has a script for this now as well http://www.zope.org/Members/phd/cron-zope/pack-db_fs -----Original Message----- From: Keith Larson [mailto:keith.larson@spatial.com] Sent: Friday, October 27, 2000 9:25 AM To: 'Chris Withers'; Federico Di Gregorio Cc: Keith Larson; Zope Dev Subject: RE: [Zope-dev] Command Line Database Packing ? hehe Yea u do! -----Original Message----- From: Chris Withers [mailto:chrisw@nipltd.com] Sent: Friday, October 27, 2000 9:14 AM To: Federico Di Gregorio Cc: Keith Larson; Zope Dev Subject: Re: [Zope-dev] Command Line Database Packing ? Federico Di Gregorio wrote: > > Scavenging the mail folder uncovered Keith Larson's letter: > > Hello , > > > > Is there a way to run a script that could pack the database from the command > > line ? > > wget your.zope.server:<port>/Control_Panel/Database/manage_pack?days=<n> > > and substitute the right port for <port> and the number of days for <n>. I'm really hoping you'll have to supply a username and password in there somewhere too ;-) cheers, Chris _______________________________________________ Zope-Dev maillist - Zope-Dev(a)zope.org http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope ) _______________________________________________ Zope-Dev maillist - Zope-Dev(a)zope.org http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )

1 0

(no subject)
by Loibl Johann 27 Oct '00

27 Oct '00

Hi, What does the following line means? href="&dtml.url-mail_password_form; how to work with '&' ? Thanks, Hannes

1 0

RE: [Zope-dev] Command Line Database Packing ?
by Keith Larson 27 Oct '00

27 Oct '00

hehe Yea u do! -----Original Message----- From: Chris Withers [mailto:chrisw@nipltd.com] Sent: Friday, October 27, 2000 9:14 AM To: Federico Di Gregorio Cc: Keith Larson; Zope Dev Subject: Re: [Zope-dev] Command Line Database Packing ? Federico Di Gregorio wrote: > > Scavenging the mail folder uncovered Keith Larson's letter: > > Hello , > > > > Is there a way to run a script that could pack the database from the command > > line ? > > wget your.zope.server:<port>/Control_Panel/Database/manage_pack?days=<n> > > and substitute the right port for <port> and the number of days for <n>. I'm really hoping you'll have to supply a username and password in there somewhere too ;-) cheers, Chris _______________________________________________ Zope-Dev maillist - Zope-Dev(a)zope.org http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )

1 0

Command Line Database Packing ?
by Keith Larson 27 Oct '00

27 Oct '00

Hello , Is there a way to run a script that could pack the database from the command line ? I am set up on a Linux system and would like a cron job to pack my database after it updates the live version of Zope. Thanks klarson(a)spatial.com

3 2

RE: [Zope-dev] Command Line Database Packing ?
by Keith Larson 27 Oct '00

27 Oct '00

Hey Thanks . I looked at the source and realized that is a pretty easy thing to figure out I would have thought about it. I did have to adjust a little for mine to work thou and used /Control_Panel/Database/manage_pack?days:float=0 Thanks a bunch ! Do you know a way to delete all the ACL users from a site from the command line ? Keith -----Original Message----- From: Federico Di Gregorio [mailto:fog@mixadlive.com] Sent: Friday, October 27, 2000 8:58 AM To: Keith Larson Cc: Zope Dev Subject: Re: [Zope-dev] Command Line Database Packing ? Scavenging the mail folder uncovered Keith Larson's letter: > Hello , > > Is there a way to run a script that could pack the database from the command > line ? wget your.zope.server:<port>/Control_Panel/Database/manage_pack?days=<n> and substitute the right port for <port> and the number of days for <n>. ciao, federico -- Federico Di Gregorio MIXAD LIVE System Programmer fog(a)mixadlive.com Debian GNU/Linux Developer & Italian Press Contact fog(a)debian.org Put a GNOME on your desktop! [http://www.gnome.org] -- brought to you by One Line Spam

1 0

xmit_channel
by Robin Becker 27 Oct '00

27 Oct '00

Does ZServer/medusa/ftp_server.py need a handle_connect method in xmit_channel. Unless I add def handle_connect(self): pass to xmit_channel I keep getting connect event errors using FTP. -- Robin Becker

1 0

Urgent code-review: code works on win2k, fails on Linux
by Thomas Weholt 27 Oct '00

27 Oct '00

I try to extend the ftp-server ( and http-server, but that works fine ) in Medusa/Zope to fit into a project I'm working on. The following script works fine under Windows2k, but it fails under Linux giving me a IOException when it tries to open the file I try to upload for writing. A ftp-client says the current working directory is "/" after login, which the user off course doesn't have write-access to, but I cannot seem to get the ftp-server to start in the right folder. I don't even know if that's the real problem ... What I need is a ftp-server that receives files of a specific type ( based on extension) in a specific folder built from FTP_FOLDER + username. That's it. No listing of files, no making of folders, removing etc. It's suppose to plug right into Zope or Medusa and so far everything works great, but only on Windows, and the final product must run on Linux. Sorry for posting something this big, but I'm desperate. Thanks. Best regards, Thomas Weholt ----- script begins --------- # Standard modules import sys, os, sha sys.path.insert(0, /usr/local/Zope/ZServer/medusa/') # Medusa modules import asyncore, http_server, ftp_server, filesys, resolver, logger # my/hs-modules import my_handler # Settings HTTP_PORT = 1900 FTP_PORT = 1921 IP_ADDRESS = 'localhost' INCOMING_ROOT = '/home/' LOG_FILE = 'log.txt' users = {'thomas':'5f50a84c1fa3bcff146405017f36aec1a10a9e38'} fs = filesys.os_filesystem ('.') lg = logger.file_logger (LOG_FILE) class my_ftp_channel(ftp_server.ftp_channel): """A custized ftp_channel for my ftp server""" def __init__(self, server, conn, addr): ftp_server.ftp_channel.__init__(self, server, conn, addr) self.answer = "000 You're not allowed to do that" def cmd_stor (self, line, mode='wb'): if len (line) < 2: self.command_not_understood (string.join (line)) else: if self.restart_position: restart_position = 0 self.respond ('553 restart on STOR not yet supported') return file = line[1] # todo: handle that type flag try: if not os.path.splitext(file)[1] in ['.jgz','jix']: self.respond("000 Cannot store that file") return except IndexError: self.respond("000 Wrong fileformat.") return try: fd = self.open (file, mode) except IOError, why: self.respond ('553 could not open file for writing: %s' % (repr(why))) return self.respond ( '150 Opening %s connection for %s' % ( self.type_map[self.current_mode], file ) ) self.make_recv_channel (fd) def log (self, message): self.server.logger.log ( self.addr[0], '%d %s' % (self.addr[1], message)) # Commands that are not allowed def cmd_help (self, line): self.respond("000 No help is available. This is an automated service.") return def cmd_appe (self, line): self.respond(self.answer) return def cmd_mkd (self, line): self.respond(self.answer) return def cmd_rmd (self, line): self.respond(self.answer) return def cmd_cwd (self, line): self.respond(self.answer) return def cmd_cdup (self, line): self.respond(self.answer) return def cdup (self, line): self.respond(self.answer) return class my_authorizer: def authorize (self, channel, username, password): pwd = sha.new(password) if users.has_key(username) and users[username] == pwd.hexdigest(): channel.read_only = 0 fs = filesys.os_filesystem (INCOMING_ROOT + username + os.sep) return 1, 'Login successful.', fs else: return 0, 'Login failed.', None def __repr__ (self): return '<my User Authorizer>' fp = ftp_server.ftp_server (my_authorizer(), ip=IP_ADDRESS, port=FTP_PORT, logger_object=lg) fp.ftp_channel_class = my_ftp_channel dh = my_handler.default_handler(fs) hs = http_server.http_server (IP_ADDRESS, port=HTTP_PORT) hs.install_handler (dh) asyncore.loop()

1 0