[Zope-dev] MailHost, 2.2.0, and qmail mailserver
The change in the sendmail tag to use the SMTP module has caused a problem for me when sending to a qmail mailserver. After investigation, it would appear that the smtplib module function: SMTP.mail(self,sender,options=[]): appends a space to the end of the FROM: address when there are no options. The offending line is: self.putcmd("mail", "FROM:%s %s" % (quoteaddr(sender) ,optionlist)) This space upsets the qmail server which response with SMTPSenderRefused. A quick fix is to remove this space and home that no optionlist is ever past. A more permanent fix to smtplib would seem in order. Richard ___ Zope-Dev maillist - [EMAIL PROTECTED] 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] Problem with database packing (major data loss)
We have discovered a rather nasty problem. On Zope 2.1.6 if you you pack the database with '0' in the days box and then pack it again with '1' in the days box bad things happen. In our case the first pack resulted in a Data.fs of 17MBytes (not bad from a started point of nearly 2GBytes) the second pack (which I assumed would do nothing) resulted in a Data.fs of 3MBytes. Great I thought, however it also broke most of my site. Some of the symptoms are: Accessing existing folders gives KeyError Many of my ZClasses are turned into DTML Methods (that is the icon next to them in the folder view is a DTML Method icon) All the instances of the broken classes are broken. Thankfully I kept backups before performing the packs. This is repeatable on both the servers I run. I am now nervous of packing but have no choice. Richard PS. I still think Zope is great! I am just learning slowing how to run it defensively ___ 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 with database packing (major data loss)
Brian Lloyd [EMAIL PROTECTED] writes: On Zope 2.1.6 if you you pack the database with '0' in the days box and then pack it again with '1' in the days box bad things happen. In our case the first pack resulted in a Data.fs of 17MBytes (not bad from a started point of nearly 2GBytes) the second pack (which I assumed would do nothing) resulted in a Data.fs of 3MBytes. Great I thought, however it also broke most of my site. Some of the symptoms are: Accessing existing folders gives KeyError Many of my ZClasses are turned into DTML Methods (that is the icon next to them in the folder view is a DTML Method icon) All the instances of the broken classes are broken. Thankfully I kept backups before performing the packs. Richard - A notice was sent out to the list a week or so ago on this - there is a bug in the packing machinery that (as you found) doesn't correctly handle things when you pack to certain time and then subsequently pack to an earlier time. The fix for this is already checked in for 2.2. Brian Lloyd[EMAIL PROTECTED] Software Engineer 540.371.6909 Digital Creations http://www.digicool.com Brian You have my apology I did not spot the this notice. I shall move to 2.2 just as soon as it is out of Beta testing. Richard ___ 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] CorruptTransactionError (Bad news for production site!)
Today I had to role back two days of transactions from my production site because when I packed the database I was informed of a CorruptTransactionError. We are using Zope for an internal knowledge management application where anyone in the organization can add objects. So I have no way of know what was added after the fateful transaction and no way of getting any of it back. Bummer! I think this raises a few questions about ZDB: 1) We need some tools for selectively removing bad transactions rather than just truncating Data.fs back to the last good one and loosing everything that comes after it. 2) We could do with a tools that can verify the ZODB offline. This could then be run at regular intervals (maybe once an hour from cron) so that corruptions can be picked up earlier. 3) Some way to find out what was added after a corrupt transaction is needed so that at least I could see who I need to ask to re-add their stuff. I love Zope I think it the best web application framework I have use (and I have used many), but this incident has shaken my confidence in the ZODB. I can live with the occasional error and I don't object to having to do some work to recover things. But, this appears to be an error from which I can not recover my data even though I have backups. Richard PS. Is there anyone offering commercial support for Zope in the UK. The more I am relying on Zope the more I think I need someone to provide guaranteed backup. ___ 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-dev] Searching a relational database
James Henstridge [EMAIL PROTECTED] writes: On Sat, 24 Jun 2000, Thomas Weholt wrote: Hi, How can I search a relational database thru Zope? ( I`m using PostgreSQL 7.0.2 on Linux ). I have a DVD/VHS-organizing project that would be pretty useless if people couldn`t search for movies by entering just parts of the title. Ex. typing alien should show "Alien" and "Alien 3". If you just want to do a single search term, you could easily set up an SQL method that read something like: select * from table where title like '%dtml-sqlvar search%' (I hope that syntax works with MS SQL server). It is probably possible to get zope to escape special characters in the string for you as well. I use the regexp search option in Postgresql (~*) to do complex searches. Unfortunately this means that your users will have to write regular expressions. If anyone is interested in writing a booleans search syntax to regexp converter I would be very interested. Can ZCatalog be used for this? If I have a SQL-statement that returns all rows in a database, can ZCatalog index this? This would negate the benefits of having an SQL database (eg. indexing, etc). Just write an sql method that does the search. What I`m looking for is similar to full-text searching on MS SQL 7.0 etc. Tips, hints or pointers?? Thomas James. Richard ___ Zope-Dev maillist - [EMAIL PROTECTED] 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 )