Re: [Zope] Zeo as a Zeo Client
--On 2. Mai 2006 08:31:17 +0200 Gerhard Schmidt <[EMAIL PROTECTED]> wrote: Hallo, I am trying to install a setup like shown below ZEO_M | -- ZEO_B | | -- ZOPE | | -- ZOPE | | -- ZOPE | ... | -- ZOPE | -- ZOPE ... You are trying to create a cascade of multiple ZEO Clients? That looks very odd. Usually a ZEO client talks directly to a ZEO server. -aj -- ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376 E-Publishing, Python, Zope & Plone development, Consulting pgpNFM1rW1QOH.pgp Description: PGP signature ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Zeo as a Zeo Client
Hallo, I am trying to install a setup like shown below ZEO_M | -- ZEO_B | | -- ZOPE | | -- ZOPE | | -- ZOPE | ... | -- ZOPE | -- ZOPE ... The ZEO_B should be a zeoclient of the ZEO_M (MainZEO). The reason for this setup ist that the ZEO_B is located in a backup computing center on the other side of our campus. When I configured the ZEO_B as a zeoclient of the ZEO_M. I comes up without problem. I've connected the first client, the connection is establisched but the server never come up. Here is the log from ZEO_B level debug 2006-05-02T08:21:45 BLATHER ZEO.zrpc (65280) connect from ('10.152.64.1', 54853): -- 2006-05-02T08:21:45 INFO ZEO.zrpc.Connection(S) (10.152.64.1:54853) received handshake 'Z303' -- 2006-05-02T08:21:45 DEBUG ZEO.zrpc.Connection(S) (10.152.64.1:54853) calling getAuthProtocol() -- 2006-05-02T08:21:45 DEBUG ZEO.zrpc.Connection(S) (10.152.64.1:54853) getAuthProtocol returns None -- 2006-05-02T08:21:45 DEBUG ZEO.zrpc.Connection(S) (10.152.64.1:54853) calling register('main', False) -- 2006-05-02T08:21:45 DEBUG ZEO.zrpc.Connection(S) (10.152.64.1:54853) register returns None -- 2006-05-02T08:21:45 DEBUG ZEO.zrpc.Connection(S) (10.152.64.1:54853) calling get_info() -- 2006-05-02T08:21:45 DEBUG ZEO.zrpc.Connection(S) (10.152.64.1:54853) get_info returns {'supportsVersions': 1, 'name': 'main (connected)', 'length'... -- 2006-05-02T08:21:45 DEBUG ZEO.zrpc.Connection(S) (10.152.64.1:54853) calling endZeoVerify() -- 2006-05-02T08:21:45 DEBUG ZEO.zrpc.Connection(S) (10.152.64.1:54853) calling loadEx('\x00\x00\x00\x00\x00\x00\x00\x00', '') here is the log for the zope server on ZEO_B 2006-05-02 08:21:45 INFO ZEO.ClientStorage (65292) ClientStorage (pid=65292) created RW/normal for storage: 'main' 2006-05-02 08:21:45 INFO ZEO.cache reusing persistent cache file '/data/zope/console28/var/frontend-main.zec' 2006-05-02 08:21:45 INFO ZEO.ClientStorage (65292) Testing connection 2006-05-02 08:21:45 INFO ZEO.zrpc.Connection(C) (10.152.64.1:8110) received handshake 'Z303' 2006-05-02 08:21:45 INFO ZEO.ClientStorage (65292) Server authentication protocol None 2006-05-02 08:21:45 INFO ZEO.ClientStorage (65292) Connected to storage: ('10.152.64.1', 8110) 2006-05-02 08:21:45 INFO ZEO.ClientStorage (65292) Verifying cache 2006-05-02 08:21:45 INFO ZEO.ClientStorage (65292) Waiting for cache verification to finish 2006-05-02 08:21:45 INFO ZEO.ClientStorage (65292) Waiting for cache verification to finish 2006-05-02 08:21:45 INFO ZEO.ClientStorage (65292) endVerify finishing 2006-05-02 08:21:45 INFO ZEO.ClientStorage (65292) endVerify finished ^C2006-05-02 08:22:09 INFO ZEO.ClientStorage (65292) Disconnected from storage: "('10.152.64.1', 8110)" Traceback (most recent call last): File "/usr/local/www/Zope28/lib/python/Zope2/Startup/run.py", line 56, in ? run() File "/usr/local/www/Zope28/lib/python/Zope2/Startup/run.py", line 21, in run starter.prepare() File "/usr/local/www/Zope28/lib/python/Zope2/Startup/__init__.py", line 98, in prepare self.startZope() File "/usr/local/www/Zope28/lib/python/Zope2/Startup/__init__.py", line 257, in startZope Zope2.startup() File "/usr/local/www/Zope28/lib/python/Zope2/__init__.py", line 47, in startup _startup() File "/usr/local/www/Zope28/lib/python/Zope2/App/startup.py", line 57, in startup DB = configuration.dbtab.getDatabase('/', is_root=1) File "/usr/local/www/Zope28/lib/python/DBTab/DBTab.py", line 96, in getDatabase db = self._createDatabase(name, is_root) File "/usr/local/www/Zope28/lib/python/DBTab/DBTab.py", line 113, in _createDatabase db = factory.open() File "/usr/local/www/Zope28/lib/python/Zope2/Startup/datatypes.py", line 163, in open DB = self.createDB() File "/usr/local/www/Zope28/lib/python/Zope2/Startup/datatypes.py", line 160, in createDB return ZODBDatabase.open(self) File "/usr/local/www/Zope28/lib/python/ZODB/config.py", line 103, in open version_cache_size=section.version_cache_size) File "/usr/local/www/Zope28/lib/python/ZODB/DB.py", line 239, in __init__ storage.load(z64,'') File "/usr/local/www/Zope28/lib/python/ZEO/ClientStorage.py", line 746, in load return self.loadEx(oid, version)[:2] File "/usr/local/www/Zope28/lib/python/ZEO/ClientStorage.py", line 769, in loadEx data, tid, ver = self._server.loadEx(oid, version) File "/usr/local/www/Zope28/lib/python/ZEO/ServerStub.py", line 192, in loadEx return self.rpc.call("loadEx", oid, version) File "/usr/local/www/Zope28/lib/python/ZEO/zrpc/connection.py", line 531, in call r_flags, r_args = self.wait(msgid) File "/usr/local/www/Zope28/lib/python/ZEO/zrpc/connection.py", line 638, in wait asyncore.poll(delay, self._singleton) File "/usr/local/lib/python2.4/asyncore.py", line 122, in poll r, w, e = select.select(r, w, e, timeout) KeyboardInterrupt I started it with runzope and killed it with
[Zope] strange behaviour:can not access source-view.gif but a copy of it
Hi there, in a plone site (but I see nothing plone related with my problem) I can not access an image with the id view-source.gif (it is used by kupu). when I copied it to the plone root the copy was named copy_of_view-source.gif all tough no prior object of that name existed. After renaming to view-source.gif and trying to access it trough its URL www.xxx.yy/view-source.gif nothing happens, only the watch is spinning to tell that the browser is still busy. if I copy that very same image to an other name, the copy can be accessed without problems. Can anybody give me a hint what the reason could be, or give me an idea how to hunt it down. thanks robert begin:vcard fn:robert rottermann n:rottermann;robert email;internet:[EMAIL PROTECTED] tel;work:031 333 10 20 tel;fax:031 333 10 23 tel;home:031 333 36 03 x-mozilla-html:FALSE version:2.1 end:vcard ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: ZEO ClientDisconnected error
Hi Tres, thanks for your response: it is very helpful. The posting you refer to is particularly helpful. Thanks for digging it up for me! Cheers, Cyrille Tres Seaver wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Cyrille Bonnet wrote: Hi there, One of my clients is using Plone on Solaris 9. We have set up one ZEO client on a Solaris machine and a ZEO server on another Solaris machine (for testing purposes only at this stage). Performance is great but every morning, the first hit to the Plone site returns a ClientDisconnected error (see full error log below). It looks like the socket on the server gets corrupted or something. When the error occurs, the server is non-responsive for a while (anywhere between 10 sec and 2 minutes) and then eventually the server responds. Has anybody seen that before? Is it Zope related or should I look in other directions? Researching Zope on Solaris, I read somewhere (can't remember where now) that Solaris doesn't like long-running processes too much (well, the Zope process, for instance). Could it be the culprit here? Any advise or pointer welcome. I would check for a "rude" firewall between your appserver and the storage server: one which is closing sockets it sees as "idle" for too long. Dieter Maurer has a product which works around such scenarios: http://mail.zope.org/pipermail/zodb-dev/2005-June/008967.html Tres. - -- === Tres Seaver +1 202-558-7113 [EMAIL PROTECTED] Palladion Software "Excellence by Design"http://palladion.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFEVsxj+gerLs4ltQ4RAh+IAKChzq20oj0sFmD9jNxpzQWtis98xQCfamtY Fyeu1abM7pUBG4P1ANbQ8mM= =eXdz -END PGP SIGNATURE- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: ZEO ClientDisconnected error
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Cyrille Bonnet wrote: > Hi there, > > One of my clients is using Plone on Solaris 9. We have set up one ZEO > client on a Solaris machine and a ZEO server on another Solaris machine > (for testing purposes only at this stage). > > Performance is great but every morning, the first hit to the Plone site > returns a ClientDisconnected error (see full error log below). It looks > like the socket on the server gets corrupted or something. > > When the error occurs, the server is non-responsive for a while > (anywhere between 10 sec and 2 minutes) and then eventually the server > responds. > > Has anybody seen that before? Is it Zope related or should I look in > other directions? > > Researching Zope on Solaris, I read somewhere (can't remember where now) > that Solaris doesn't like long-running processes too much (well, the > Zope process, for instance). Could it be the culprit here? > > Any advise or pointer welcome. I would check for a "rude" firewall between your appserver and the storage server: one which is closing sockets it sees as "idle" for too long. Dieter Maurer has a product which works around such scenarios: http://mail.zope.org/pipermail/zodb-dev/2005-June/008967.html Tres. - -- === Tres Seaver +1 202-558-7113 [EMAIL PROTECTED] Palladion Software "Excellence by Design"http://palladion.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFEVsxj+gerLs4ltQ4RAh+IAKChzq20oj0sFmD9jNxpzQWtis98xQCfamtY Fyeu1abM7pUBG4P1ANbQ8mM= =eXdz -END PGP SIGNATURE- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] ZEO ClientDisconnected error
Hi there, One of my clients is using Plone on Solaris 9. We have set up one ZEO client on a Solaris machine and a ZEO server on another Solaris machine (for testing purposes only at this stage). Performance is great but every morning, the first hit to the Plone site returns a ClientDisconnected error (see full error log below). It looks like the socket on the server gets corrupted or something. When the error occurs, the server is non-responsive for a while (anywhere between 10 sec and 2 minutes) and then eventually the server responds. Has anybody seen that before? Is it Zope related or should I look in other directions? Researching Zope on Solaris, I read somewhere (can't remember where now) that Solaris doesn't like long-running processes too much (well, the Zope process, for instance). Could it be the culprit here? Any advise or pointer welcome. Cyrille (in the logs below, "appserv05" is the ZEO client, "pehi" is the ZEO server) From event.log: = ERROR ZEO.zrpc.Connection(C) (pehi.myclient.govt.nz:8100) Error caught in asyncore raise socket.error, why error: (9, 'Bad file descriptor') 2006-04-28T09:09:52 = From the error log: = Time 2006-04-28 09:09 User Name admin (admin) Request URL http://plone.appserv05.myclient.govt.nz/front-page/document_view Exception Type ClientDisconnected Exception Value Traceback (innermost last): •Module ZPublisher.Publish, line 114, in publish •Module ZPublisher.mapply, line 88, in mapply •Module ZPublisher.Publish, line 40, in call_object •Module Shared.DC.Scripts.Bindings, line 311, in __call__ •Module Shared.DC.Scripts.Bindings, line 348, in _bindAndExec •Module Products.CMFCore.FSPageTemplate, line 195, in _exec •Module Products.CMFCore.FSPageTemplate, line 134, in pt_render •Module Products.PageTemplates.PageTemplate, line 104, in pt_render /myclient/Plone/front-page> •Module TAL.TALInterpreter, line 206, in __call__ •Module TAL.TALInterpreter, line 250, in interpret •Module TAL.TALInterpreter, line 711, in do_useMacro •Module TAL.TALInterpreter, line 250, in interpret •Module TAL.TALInterpreter, line 426, in do_optTag_tal •Module TAL.TALInterpreter, line 411, in do_optTag •Module TAL.TALInterpreter, line 406, in no_tag •Module TAL.TALInterpreter, line 250, in interpret •Module TAL.TALInterpreter, line 711, in do_useMacro •Module TAL.TALInterpreter, line 250, in interpret •Module TAL.TALInterpreter, line 481, in do_setGlobal_tal •Module Products.PageTemplates.TALES, line 221, in evaluate URL: file:CMFPlone/skins/plone_templates/global_defines.pt Line 3, Column 0 Expression: Names: •{'container': , • 'context': , • 'default': 0xacaf58>, • 'here': , • 'loop': 0x22027d8>, • 'modules': 0xabd5d0>, • 'nothing': None, • 'options': {'args': ()}, • 'repeat': 0x22027d8>, • 'request': URL=http://plone.appserv05.myclient.govt.nz/front-page/document_view>, • 'root': , • 'template': for /myclient/Plone/front-page>, • 'traverse_subpath': [], 'user': admin} •Module Products.PageTemplates.ZRPythonExpr, line 47, in __call__ __traceback_info__: language or here.Language() or default_language •Module Python expression "language or here.Language() or default_language", line 1, in •Module Products.Archetypes.ClassGen, line 58, in generatedAccessor •Module Products.Archetypes.Field, line 768, in get •Module Products.Archetypes.Field, line 637, in get __traceback_info__: ('language', /myclient/Plone/front-page>, {'field': , 'schema': }) •Module Products.Archetypes.Storage, line 175, in get •Module UserDict, line 19, in __getitem__ •Module ZODB.Connection, line 704, in setstate •Module ZODB.Connection, line 760, in _setstate •Module ZODB.serialize, line 495, in setGhostState •Module ZODB.serialize, line 488, in getState •Module ZODB.serialize, line 436, in _persistent_load •Module ZODB.Connection, line 207, in get •Module ZEO.ClientStorage, line 746, in load •Module ZEO.ClientStorage, line 769, in loadEx •Module ZEO.ClientStorage, line 79, in __getattr__ ClientDisconnected Display traceback as text REQUEST form cookies SaneID'210.55.131.118-1146009986253' lazy items SESSION> other _oai_cache{56460528: instance at 0x630cb48>} TraversalRequestNameStack[] AUTHENTICATED_USERadmin URL'http://plone.appserv05.myclient.govt.nz/front-page/document_view' VirtualRootPhysicalPath('', 'myclient', 'Plone') _pts_catalog_names_plone_en-us['PloneTranslations.i18n-plone-en.po', 'PloneTranslations.i18n-archetypes-en.po'] VIRTUAL_URL'http://plone.appserv05.myclient.govt.nz/' SERVER_URL'http://plone.appserv05.myclient.govt
Re: [Zope] Re: Windows Server 2003, II6 and ASP404 vs form posts
For anyone else who might search the list in the future: Microsoft has confirmed that ASP error handlers in current versions of IIS 6 do not, can not, and will not -- no matter what the security settings -- get at POST data. There's a discussion of the changes at: I think that is not 100% true-- I am not sure where the difference lies -- but as we discussed I am using ASP404 on Windows 2003 (at http://www.coursesbywire.com) with form Posting functioning. The only issue (that I ran up against and had to solve) is that the method used in ASP404 to determine whether the original request was a POST or a GET no longer works on Win2003 (as it did on Win2000) -- it is necessary to introduce a kludge in the ASP code. http://blogs.msdn.com/david.wang/archive/2005/11/29/Child_URL_Execution_and_SSI_exec.aspx The author confirmed that the changes also affect custom error handlers. So, the days of serving Zope pages on IIS via the 404handler.asp approach are pretty much over. Not quite -- but maybe numbered. I agree though that starting out now using it when it was not previously in use might be a bad plan. I am not totally sure what is causing your problem but on my (fully patched Win2003)server the Post data is available. I had a look at Enfold's Proxy when I this issue first came up for me but found that it did not solve my problem (though it could be that I just didn't understand something about it). In my case putting Apache in front did not seem a reasonable solution either as I am running IIS on the box and needed it to stay. ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Converting from week no. to date
On 5/1/06, Jonas Nielsen <[EMAIL PROTECTED]> wrote: DateTime().strftime("%U") converts from date to week no. Is it possible to convert from (week,year,weekday) to a specific date in a python script in zope ? I could install the mx.DateTime module in python and then make a product with a method that used ISO.Week() but is there a more straight forward approach ? Well, steal some code from http://svn.nuxeo.org/trac/pub/file/CalCore/trunk/src/calcore/isoweek.py maybe? -- Lennart Regebro, Nuxeo http://www.nuxeo.com/ CPS Content Management http://www.cps-project.org/ ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Converting from week no. to date
--On 1. Mai 2006 17:16:13 +0200 Jonas Nielsen <[EMAIL PROTECTED]> wrote: DateTime().strftime("%U") converts from date to week no. Is it possible to convert from (week,year,weekday) to a specific date in a python script in zope ? The DateTime API does not support this. -aj -- ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376 E-Publishing, Python, Zope & Plone development, Consulting pgpHibAFnV5by.pgp Description: PGP signature ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: Windows Server 2003, II6 and ASP404 vs form posts
For anyone else who might search the list in the future: Microsoft has confirmed that ASP error handlers in current versions of IIS 6 do not, can not, and will not -- no matter what the security settings -- get at POST data. There's a discussion of the changes at: http://blogs.msdn.com/david.wang/archive/2005/11/29/Child_URL_Execution_and_SSI_exec.aspx The author confirmed that the changes also affect custom error handlers. So, the days of serving Zope pages on IIS via the 404handler.asp approach are pretty much over. Steve McMahon wrote: Anyone out there using Zope inside IIS 6 on Server 2003 via the ASP404 technique? I've done this successfully on Windows 200 and XP, but on Server 2003, IIS does not seem to be passing the post data to the error handler. When Win2003 was young, there was some list traffic on a similar problem, and Brian Sullivan figured out that IIS was reporting a REQUEST_METHOD of "GET" even for POST requests. However, the POST data was still passing, so it was possible to check Request.totalBytes (this is the ASP Request, not Zope's) to determine the real nature of the request. Now, though, many an IIS patch later, IIS is invoking the error handler with http content length set to zero (even though it reports that content type is www-urlencoded). So, form submissions do nothing. And, if there's nothing to be done about this, does anyone know if the Fresh Logic or Enfold ISAPI solutions have any way to intermix serving of IIS and Zope content? If I didn't have to do that, I'd be using Apache, and be done by now ;) . Thanks! ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Converting from week no. to date
DateTime().strftime("%U") converts from date to week no. Is it possible to convert from (week,year,weekday) to a specific date in a python script in zope ? I could install the mx.DateTime module in python and then make a product with a method that used ISO.Week() but is there a more straight forward approach ? ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: Missing content! Urgent
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael Havard wrote: > We're missing 16 days worth of content. > > Python 2.3.5, Zope 2.8.4, Plone 2.1.2, and a host of other products. ZEO > configuration. Persistent disk caching is on. > > Yesterday everything was fine. All the content was there and accessible. > Today I try to log in and the server doesn't respond. I go out and restart > the zope client, still no response. I restart the zeo server and the site > delivers content. Problem! The content is from two weeks ago. All of the > content from the last 16 days is missing. Thinking maybe someone restored > from an older backup I went out to our daily backups and pulled the previous > days data.fs backup. A restore didn't work. It still shows the outdated > content. I went out to look at the backups again and noticed that the date > on the data.fs was 4/14 while the date on data.fs.tmp was 4/26. data.fs.tmp > is a 9 meg file. > > Is the missing content somehow captured in data.fs.tmp or is it somewhere > else that I can retrieve it? If it is how do I get it back? You could try the following (back up everything first, of course!): - Stop the application server, then the storage server. - Test the existing storage file: $ /path/to/python /path/to/zope/utilities/ZODBTools/fstest.py \ var/Data.fs - On the storage server, concatenate the 'tmp' file to the end of the main file, e.g.:: $ cat var/Data.fs.tmp >> var/Data.fs - Move the 'tmp' file aside, e.g.:: $ mv var/Data.fs.tmp var/Data.fs.tmp-ASIDE - Test the concatenated storage file: $ /path/to/python /path/to/zope/utilities/ZODBTools/fstest.py \ var/Data.fs - Restart the storage server in debug mode and watch the log output: $ bin/zeoctl start && tail -100f var/error.log Tres. - -- === Tres Seaver +1 202-558-7113 [EMAIL PROTECTED] Palladion Software "Excellence by Design"http://palladion.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFEVjS6+gerLs4ltQ4RAiqrAKC1AVhW1A1yobCieSsNWgivaJ4rZACg1yfj b9muiVfu4p5MlWbf1xG14Po= =nIFY -END PGP SIGNATURE- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] LAST INSERT ID driving me crazy
I don't think Zope provide the said feature.1. I use ZopeTime (e.g. datetime_id.) as the last_insert_query id. You can use python date time too.2. All related database tables have a datetime_id column3. Using zsql method: insert into table_name set t_datetime_id=, Good LuckCYAlric Aneron <[EMAIL PROTECTED]> wrote: Hi guys, HOW HOW HOW HOW!!! Do I get at the last_insert_id() function, this is driving me absolutely crazy!! Zope docs say use "select last_insert_id()" but it doesn't work, gives me an error about bad SQL syntax around "LIMIT 1000". I tried googling it, I tried searching through other docs. And it just won't do it! I would like to make a separate ZSQL Method that will return to me the last insert id. Any help would be appreciated. Thank you.Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2�/min or less.___Zope maillist - Zope@zope.orghttp://mail.zope.org/mailman/listinfo/zope** No cross posts or HTML encoding! **(Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: Missing content! Urgent
Sorry. I know better, just got in a panic. "Chris Withers" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Michael Havard wrote: >> We're missing 16 days worth of content. > > Have a read of this: > http://www.catb.org/~esr/faqs/smart-questions.html#urgent > >> Python 2.3.5, Zope 2.8.4, Plone 2.1.2, and a host of other products. ZEO >> configuration. Persistent disk caching is on. > > You've got Plone in the mix, you may get more help asking on a > Plone-specific list... > >> Is the missing content somehow captured in data.fs.tmp or is it somewhere >> else that I can retrieve it? If it is how do I get it back? > > You may want to ask about that on zodb-dev@zope.org > but I've never heard of symptoms like yours. I can only hope/guess that > it's one of your extra products that's done something weird. > > You could help by providing more information about what type of objects > made up your missing data: was it a Plone site? specific types of content > in a Plone site? Instances of some other type of object? > > cheers, > > Chris - this is why you should test backups ;-) > > -- > Simplistix - Content Management, Zope & Python Consulting >- http://www.simplistix.co.uk > ___ > Zope maillist - Zope@zope.org > http://mail.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce > http://mail.zope.org/mailman/listinfo/zope-dev ) > ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] LAST INSERT ID driving me crazy
This is how it works for MySQL: insert into table_name ( ItemID, ItemDate, etc ) values ( , , etc ) select LAST_INSERT_ID() as BaptismID You have to have the select LAST_INSERT_ID call in the same query as the insert, and you have to have the sql_delimiter. I have a vague recollection that LAST_INSERT_ID is MySQL specific. Cliff Alric Aneron wrote: Hi guys, HOW HOW HOW HOW!!! Do I get at the last_insert_id() function, this is driving me absolutely crazy!! Zope docs say use "select last_insert_id()" but it doesn't work, gives me an error about bad SQL syntax around "LIMIT 1000". I tried googling it, I tried searching through other docs. And it just won't do it! I would like to make a separate ZSQL Method that will return to me the last insert id. Any help would be appreciated. Thank you. - Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Missing content! Urgent
Michael Havard wrote: We're missing 16 days worth of content. Have a read of this: http://www.catb.org/~esr/faqs/smart-questions.html#urgent Python 2.3.5, Zope 2.8.4, Plone 2.1.2, and a host of other products. ZEO configuration. Persistent disk caching is on. You've got Plone in the mix, you may get more help asking on a Plone-specific list... Is the missing content somehow captured in data.fs.tmp or is it somewhere else that I can retrieve it? If it is how do I get it back? You may want to ask about that on zodb-dev@zope.org but I've never heard of symptoms like yours. I can only hope/guess that it's one of your extra products that's done something weird. You could help by providing more information about what type of objects made up your missing data: was it a Plone site? specific types of content in a Plone site? Instances of some other type of object? cheers, Chris - this is why you should test backups ;-) -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: [Zope-Annce] Technical Preview of Blob support in ZODB
Christian Theune wrote: the ZODB team is proud to announce a technical preview of a Blob implementation for ZODB. Cool :-) Blobs are used to efficiently storage large amounts of binary data within a database. This implementation uses real files on the file system in combination with any ZODB storage (FileStorage, ...) and native support for ZEO clusters. It is efficient in terms of memory and CPU usage. Hmm, can all the other benefits be used without storing blobs in seperate files on filesystems? FileStorage backup semantics are now "nice" with repozo, how would you back up related blobs? I guess I also have an irrational paranoia about separate files having the correct transactional semantics. Anything I can read to prove my paranoia to be irrational? ;-) cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )