Hi: Not sure if this is a DB question, or DTML question, so I'm sending it to the general Zope list. I've been banging my head over this relatively simple query, which (if my understanding of the dtml-sqltest tag is correct), should be fine. The idea is simple, get 3 columns from company_index, and display the results, if there's further constrains set (like ticker, company_name, etc.), taylor the query accordingly: select company_name,ticker,primary_exchange from company_index <dtml-sqlgroup where> <dtml-sqltest ticker op=eq type=nb> <dtml-sqltest company_name op=like type=nb> <dtml-sqltest industry_group op=eq type=nb> <dtml-sqltest industry_subgroup op=eq type=nb> <dtml-sqltest market_cap op=eq type=nb> <dtml-sqltest market_sector op=eq type=nb> <dtml-sqltest primary_exchange op=eq type=nb> </dtml-sqlgroup> but it's not happy. It keeps displaying errors like this: ************* Zope has encountered an error while publishing this resource. Error Type: KeyError Error Value: industry_group Troubleshooting Suggestions * This resource may be trying to reference a nonexistent object or variable industry_group. * The URL may be incorrect. * The parameters passed to this resource may be incorrect. * A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the HTML source for this page. If the error persists please contact the site maintainer. Thank you for your patience. ************** Which in my opinion does not make sense. I intedended for only one var to be set, and leave the others non-existing alone. I get this error when I only set the company_name, and I expect my query to be: select company_name,ticker,primary_exchange from company_index where company_index like 'Value I passed%' Shouldn't sqltest should recognize that, and not raise an error? ------------------------- I used a variation, which I don't think should be used because supposedly sqltest's job is to test if a var is set, and include it in my 'where' if it is. As you can see, I check with a <dtml-if ..> if the var is set, but I think I should not have to do it since, I think based on docs I've read, that <dtml-sqltest...> should do that. select company_name,ticker,primary_exchange from company_index <dtml-sqlgroup where> <dtml-if ticker> <dtml-sqltest ticker op=eq type=nb> </dtml-if> <dtml-if company_name> <dtml-sqltest company_name op=like type=nb> </dtml-if> <dtml-if industry_group> <dtml-sqltest industry_group op=eq type=nb> </dtml-if> <dtml-if industry_subgroup> <dtml-sqltest industry_subgroup op=eq type=nb> </dtml-if> <dtml-if market_cap> <dtml-sqltest market_cap op=eq type=nb> </dtml-if> <dtml-if market_sector> <dtml-sqltest market_sector op=eq type=nb> </dtml-if> <dtml-if primary_exchange> <dtml-sqltest primary_exchange op=eq type=nb> </dtml-if> </dtml-sqlgroup> By the way, this way does not work either, I also get an error using the above syntax: **************** Zope Error Zope has encountered an error while publishing this resource. Error Type: DatabaseError Error Value: (933, 'ORA-00933: SQL command not properly ended') Troubleshooting Suggestions * The URL may be incorrect. * The parameters passed to this resource may be incorrect. * A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the HTML source for this page. If the error persists please contact the site maintainer. Thank you for your patience. **************** Any hints are gretly appreciated. Regards, Jorge M. -- Jorge O. Martinez MIS Senior Associate eMediaMillWorks 1100 Mercantile Lane, Suite 119 Largo, MD 20774 E-mail => jmartinez@eMediaMillWorks.com Phone => (301)883-2482 ext. 105 Fax => (301)883-9754
industry_group is supposed to be a variable known to the Zope namespace. If this variable doe snot exist, you would get the error you quote. Make sure you have created the variable and assigned it a value. Cheers, Tom P [Jorge O. Martinez]
Not sure if this is a DB question, or DTML question, so I'm sending it to
the
general Zope list.
I've been banging my head over this relatively simple query, which (if my understanding of the dtml-sqltest tag is correct), should be fine. The idea is simple, get 3 columns from company_index, and display the results, if there's further constrains set (like ticker, company_name, etc.), taylor the query accordingly:
select company_name,ticker,primary_exchange from company_index <dtml-sqlgroup where> <dtml-sqltest ticker op=eq type=nb> <dtml-sqltest company_name op=like type=nb> <dtml-sqltest industry_group op=eq type=nb> <dtml-sqltest industry_subgroup op=eq type=nb> <dtml-sqltest market_cap op=eq type=nb> <dtml-sqltest market_sector op=eq type=nb> <dtml-sqltest primary_exchange op=eq type=nb> </dtml-sqlgroup>
but it's not happy. It keeps displaying errors like this:
*************
Zope has encountered an error while publishing this resource.
Error Type: KeyError Error Value: industry_group
Hi Thomas: However, wouldn't that defeat the purpose of sqltest? I mean, precisely I want to be able to only set one (ticker, company_name, etc.), or none, and have sqltest evaluate them, and ignore the ones not set, or that do not exist, and then, have it dynamically create my query based on the one that do exists and is set. BTW, I used David's suggestion, and that seems to have improved things, as the logic now at least works in the 'test' mode, but I am still not getting it to work with the rest of the code, but there might be some other thing I may have missed there. Thanks for the tips, Jorge M. Thomas B. Passin wrote:
industry_group is supposed to be a variable known to the Zope namespace. If this variable doe snot exist, you would get the error you quote. Make sure you have created the variable and assigned it a value.
Cheers,
Tom P
[Jorge O. Martinez]
Not sure if this is a DB question, or DTML question, so I'm sending it to
the
general Zope list.
I've been banging my head over this relatively simple query, which (if my understanding of the dtml-sqltest tag is correct), should be fine. The
idea is
simple, get 3 columns from company_index, and display the results, if
there's
further constrains set (like ticker, company_name, etc.), taylor the query accordingly:
select company_name,ticker,primary_exchange from company_index <dtml-sqlgroup where> <dtml-sqltest ticker op=eq type=nb> <dtml-sqltest company_name op=like type=nb> <dtml-sqltest industry_group op=eq type=nb> <dtml-sqltest industry_subgroup op=eq type=nb> <dtml-sqltest market_cap op=eq type=nb> <dtml-sqltest market_sector op=eq type=nb> <dtml-sqltest primary_exchange op=eq type=nb> </dtml-sqlgroup>
but it's not happy. It keeps displaying errors like this:
*************
Zope has encountered an error while publishing this resource.
Error Type: KeyError Error Value: industry_group
_______________________________________________ Zope maillist - Zope@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 )
-- Jorge O. Martinez MIS Senior Associate eMediaMillWorks 1100 Mercantile Lane, Suite 119 Largo, MD 20774 E-mail => jmartinez@eMediaMillWorks.com Phone => (301)883-2482 ext. 105 Fax => (301)883-9754
I'm just going by the docs in Zope Help. I haven't used sqltest myself (so far, I usually just write out the queries by hand). According to the docs (reading between the lines a bit), <dtml-sqltest industry_group op=eq type=nb> will look for a Zope variable named "industry_group", and compare it against the value of the column of that name for the row currently being processed, equivalent to: select .... where industry_group='<dtml-var industry_group>' I'm not quite clear about what you want to do. Do you want to retrieve rows where ***any*** of [ticker,company_name,...] are non-empty? If so, your query would be like this: select company_name,ticker,primary_exchange from company_index where ticker <>'' OR company_name <>'' OR industry_group <>'' OR industry_subgroup <>'' OR market_cap <>'' OR market_sector <>'' OR primary_exchange<>'' If this is not what you have in mind, you'd better explain just what you do want. Cheers, Tom P [Jorge O. Martinez]
Hi Thomas:
However, wouldn't that defeat the purpose of sqltest? I mean, precisely I want to be able to only set one (ticker, company_name, etc.), or none, and have sqltest evaluate them, and ignore the ones not set, or that do not exist, and then, have it dynamically create my query based on the one that do exists and is set.
BTW, I used David's suggestion, and that seems to have improved things, as the logic now at least works in the 'test' mode, but I am still not getting it to work with the rest of the code, but there might be some other thing I may have missed there.
Thanks for the tips,
Jorge M.
Thomas B. Passin wrote:
industry_group is supposed to be a variable known to the Zope namespace. If this variable doe snot exist, you would get the error you quote. Make sure you have created the variable and assigned it a value.
Cheers,
Tom P
[Jorge O. Martinez]
Not sure if this is a DB question, or DTML question, so I'm sending it to
the
general Zope list.
I've been banging my head over this relatively simple query, which (if my understanding of the dtml-sqltest tag is correct), should be fine. The
idea is
simple, get 3 columns from company_index, and display the results, if
there's
further constrains set (like ticker, company_name, etc.), taylor the query accordingly:
select company_name,ticker,primary_exchange from company_index <dtml-sqlgroup where> <dtml-sqltest ticker op=eq type=nb> <dtml-sqltest company_name op=like type=nb> <dtml-sqltest industry_group op=eq type=nb> <dtml-sqltest industry_subgroup op=eq type=nb> <dtml-sqltest market_cap op=eq type=nb> <dtml-sqltest market_sector op=eq type=nb> <dtml-sqltest primary_exchange op=eq type=nb> </dtml-sqlgroup>
but it's not happy. It keeps displaying errors like this:
That's where you need the 'optional' argument - e.g. <dtml-sqltest company_name op=like type=nb optional> so that you don't get key errors when the variable doesn't exist. HTH, David Burton 07/06/2002 17:53:30, "Jorge O. Martinez" <jmartinez@eMediaMillWorks.com> wrote:
Hi Thomas:
However, wouldn't that defeat the purpose of sqltest? I mean, precisely I want to be able to only set one (ticker, company_name, etc.), or none, and have sqltest evaluate them, and ignore the ones not set, or that do not exist, and then, have it dynamically create my query based on the one that do exists and is set.
BTW, I used David's suggestion, and that seems to have improved things, as the logic now at least works in the 'test' mode, but I am still not getting it to work with the rest of the code, but there might be some other thing I may have missed there.
Thanks for the tips,
Jorge M.
Thomas B. Passin wrote:
industry_group is supposed to be a variable known to the Zope namespace. If this variable doe snot exist, you would get the error you quote. Make sure you have created the variable and assigned it a value.
Cheers,
Tom P
[Jorge O. Martinez]
Not sure if this is a DB question, or DTML question, so I'm sending it to
the
general Zope list.
I've been banging my head over this relatively simple query, which (if my understanding of the dtml-sqltest tag is correct), should be fine. The
idea is
simple, get 3 columns from company_index, and display the results, if
there's
further constrains set (like ticker, company_name, etc.), taylor the query accordingly:
select company_name,ticker,primary_exchange from company_index <dtml-sqlgroup where> <dtml-sqltest ticker op=eq type=nb> <dtml-sqltest company_name op=like type=nb> <dtml-sqltest industry_group op=eq type=nb> <dtml-sqltest industry_subgroup op=eq type=nb> <dtml-sqltest market_cap op=eq type=nb> <dtml-sqltest market_sector op=eq type=nb> <dtml-sqltest primary_exchange op=eq type=nb> </dtml-sqlgroup>
but it's not happy. It keeps displaying errors like this:
*************
Zope has encountered an error while publishing this resource.
Error Type: KeyError Error Value: industry_group
_______________________________________________ Zope maillist - Zope@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 )
-- Jorge O. Martinez MIS Senior Associate eMediaMillWorks 1100 Mercantile Lane, Suite 119 Largo, MD 20774 E-mail => jmartinez@eMediaMillWorks.com Phone => (301)883-2482 ext. 105 Fax => (301)883-9754
_______________________________________________ Zope maillist - Zope@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 )
"Into the abyss we stare, hoping that the abyss does not gaze so intently upon us"
Jorge O. Martinez writes:
... I've been banging my head over this relatively simple query, ... select company_name,ticker,primary_exchange from company_index <dtml-sqlgroup where> <dtml-sqltest ticker op=eq type=nb> You may need the "optional" attribute to "dtml-sqltest" ( maybe in addition to give "ticker" an empty default value).
Dieter
Sorry, for the late reply, seems like not many ppl really use sqltest. The sqgroup/sqltest combo has some things you didn't find out: sqltest works like the if, when you add the optional attribute, like this: <dtml-sqltest ticker type="nb" optional> (op=eq is the default) the sqlgroup provides you with some additional tags, the "and" and "or" tag, so it looks for itself when to set the `and' and 'or' operators, depending if the previous sqltest did something or didn't create a statement, due to the `optional' tag. This could be your complete query: SELECT company_name,ticker,primary_exchange FROM company_index <dtml-sqlgroup where> <dtml-sqltest ticker type=nb optional> <dtml-and> <dtml-sqltest company_name op=like type=nb optional> <dtml-and> <dtml-sqltest industry_group type=nb optional> <dtml-and> <dtml-sqltest industry_subgroup type=nb optional> <dtml-and> <dtml-sqltest market_cap type=nb optional> <dtml-and> <dtml-sqltest market_sector type=nb optional> <dtml-and> <dtml-sqltest primary_exchange type=nb optional> </dtml-sqlgroup> Regards Christian * Jorge O. Martinez <jmartinez@eMediaMillWorks.com> [020607 18:02]:
Hi:
Not sure if this is a DB question, or DTML question, so I'm sending it to the general Zope list.
I've been banging my head over this relatively simple query, which (if my understanding of the dtml-sqltest tag is correct), should be fine. The idea is simple, get 3 columns from company_index, and display the results, if there's further constrains set (like ticker, company_name, etc.), taylor the query accordingly:
select company_name,ticker,primary_exchange from company_index <dtml-sqlgroup where> <dtml-sqltest ticker op=eq type=nb> <dtml-sqltest company_name op=like type=nb> <dtml-sqltest industry_group op=eq type=nb> <dtml-sqltest industry_subgroup op=eq type=nb> <dtml-sqltest market_cap op=eq type=nb> <dtml-sqltest market_sector op=eq type=nb> <dtml-sqltest primary_exchange op=eq type=nb> </dtml-sqlgroup>
but it's not happy. It keeps displaying errors like this:
*************
Zope has encountered an error while publishing this resource.
Error Type: KeyError Error Value: industry_group
Troubleshooting Suggestions
* This resource may be trying to reference a nonexistent object or variable industry_group. * The URL may be incorrect. * The parameters passed to this resource may be incorrect. * A resource that this resource relies on may be encountering an error.
For more detailed information about the error, please refer to the HTML source for this page.
If the error persists please contact the site maintainer. Thank you for your patience.
**************
Which in my opinion does not make sense. I intedended for only one var to be set, and leave the others non-existing alone. I get this error when I only set the company_name, and I expect my query to be:
select company_name,ticker,primary_exchange from company_index where company_index like 'Value I passed%'
Shouldn't sqltest should recognize that, and not raise an error?
-------------------------
I used a variation, which I don't think should be used because supposedly sqltest's job is to test if a var is set, and include it in my 'where' if it is. As you can see, I check with a <dtml-if ..> if the var is set, but I think I should not have to do it since, I think based on docs I've read, that <dtml-sqltest...> should do that.
select company_name,ticker,primary_exchange from company_index <dtml-sqlgroup where> <dtml-if ticker> <dtml-sqltest ticker op=eq type=nb> </dtml-if> <dtml-if company_name> <dtml-sqltest company_name op=like type=nb> </dtml-if> <dtml-if industry_group> <dtml-sqltest industry_group op=eq type=nb> </dtml-if> <dtml-if industry_subgroup> <dtml-sqltest industry_subgroup op=eq type=nb> </dtml-if> <dtml-if market_cap> <dtml-sqltest market_cap op=eq type=nb> </dtml-if> <dtml-if market_sector> <dtml-sqltest market_sector op=eq type=nb> </dtml-if> <dtml-if primary_exchange> <dtml-sqltest primary_exchange op=eq type=nb> </dtml-if> </dtml-sqlgroup>
By the way, this way does not work either, I also get an error using the above syntax:
****************
Zope Error
Zope has encountered an error while publishing this resource.
Error Type: DatabaseError Error Value: (933, 'ORA-00933: SQL command not properly ended')
Troubleshooting Suggestions
* The URL may be incorrect. * The parameters passed to this resource may be incorrect. * A resource that this resource relies on may be encountering an error.
For more detailed information about the error, please refer to the HTML source for this page.
If the error persists please contact the site maintainer. Thank you for your patience.
****************
Any hints are gretly appreciated.
Regards,
Jorge M.
-- Jorge O. Martinez MIS Senior Associate eMediaMillWorks 1100 Mercantile Lane, Suite 119 Largo, MD 20774 E-mail => jmartinez@eMediaMillWorks.com Phone => (301)883-2482 ext. 105 Fax => (301)883-9754
_______________________________________________ Zope maillist - Zope@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 )
-- Christian Theune - ct@gocept.com gocept gmbh & co.kg - schalaunische strasse 6 - 06366 koethen/anhalt tel.+49 3496 3099112 - fax.+49 3496 3099118 mob. - 0178 48 33 981 reduce(lambda x,y:x+y,[chr(ord(x)^42) for x in 'zS^BED\nX_FOY\x0b'])
*This is what happens when you take a break from work to see your newborn son* Everytime when we try to access Zope trough FTP at 8021, the whole Zope server locks out and has to be restarted. This occurred after my colleague downloaded some files directly from the source of zope while zope was still running. He says he only downloaded stuff like stupidFileLogger and index_html.dmtl and main.dtml. Result: we can no longer FTP into the zope database When restarting zope it also says Hotfix_2002-04-15 is broken FTP log file : WINSOCK.DLL: WinSock 2.0 WS_FTP LE 5.08 2000.01.13, Copyright C 1992-2000 Ipswitch, Inc. - - connecting to 194.78.49.253:8021 Connected to 194.78.49.253 port 8021 220 piwebserver.planetinterior.be FTP server (Medusa Async V1.18.60.1 [experimental]) ready. USER TimW 331 Password required. PASS (hidden) 230 Login successful. PWD 451 Server Error: exceptions.IOError, [Errno 32] Broken pipe: file: /home/zope/2-5-0/lib/python/ZLogger/stupidFileLogg SYST 257 "/" is the current directory. Host type (3): UNIX (standard) PASV 214-The following commands are recognized cdup change to parent of current working directory cwd change working directory list give list files in a directory mdtm show last modification time of file nlst give name list of files in directory pass specify password pwd print the current working directory rnfr rename from size return size of file stor store a file user specify user name xpwd print the current working directory 214 ! Unable to parse info 214 PORT 192,168,200,4,4,242 227 Entering Passive Mode (194,78,49,253,6,98) LIST 200 PORT command successful. ! Retrieve of folder listing failed (0) Zope Start up Log: ------ 2002-06-10T08:10:35 INFO(0) Hotfixes Applying Hotfix_2002-03-01 ------ 2002-06-10T08:10:35 INFO(0) Hotfixes Applying Hotfix_2002-04-15 /home/zope/2-5-0/lib/python/ts_regex.py:15: DeprecationWarning: the regex module is deprecated; please use the re module import regex, regsub #, Sync /home/zope/2-5-0/lib/python2.1/regsub.py:15: DeprecationWarning: the regsub module is deprecated; please use re.sub() DeprecationWarning) ------ 2002-06-10T08:10:36 INFO(0) ZODB Opening database for mounting: '15865520_1015339766.246000' ------ 2002-06-10T08:10:36 INFO(0) ZODB Mounted database '15865520_1015339766.246000' at /temp_folder ------ 2002-06-10T08:10:38 INFO(0) ZServer HTTP server started at Mon Jun 10 10:10:38 2002 Hostname: piwebserver.planetinterior.be Port: 8000 ------ 2002-06-10T08:10:38 INFO(0) ZServer HTTP server started at Mon Jun 10 10:10:38 2002 Hostname: piwebserver.planetinterior.be Port: 9800 ------ 2002-06-10T08:10:38 INFO(0) ZServer FTP server started at Mon Jun 10 10:10:38 2002 Hostname: piwebserver.planetinterior.be Port: 8021 ------ 2002-06-10T08:10:38 INFO(0) ZServer PCGI Server started at Mon Jun 10 10:10:38 2002 Unix socket: /home/zope/2-5-0/var/pcgi.soc
Roel, It seems as if Zope is trying to write to a nonexistent console... although it probably shouldn't. If you are using UNIX, try to start Zope using "nohup". On Mon, 2002-06-10 at 04:17, Roel Van den Bergh wrote:
*This is what happens when you take a break from work to see your newborn son*
Everytime when we try to access Zope trough FTP at 8021, the whole Zope server locks out and has to be restarted.
This occurred after my colleague downloaded some files directly from the source of zope while zope was still running. He says he only downloaded stuff like stupidFileLogger and index_html.dmtl and main.dtml.
Result: we can no longer FTP into the zope database When restarting zope it also says Hotfix_2002-04-15 is broken
FTP log file :
WINSOCK.DLL: WinSock 2.0 WS_FTP LE 5.08 2000.01.13, Copyright C 1992-2000 Ipswitch, Inc. - - connecting to 194.78.49.253:8021 Connected to 194.78.49.253 port 8021 220 piwebserver.planetinterior.be FTP server (Medusa Async V1.18.60.1 [experimental]) ready. USER TimW 331 Password required. PASS (hidden) 230 Login successful. PWD 451 Server Error: exceptions.IOError, [Errno 32] Broken pipe: file: /home/zope/2-5-0/lib/python/ZLogger/stupidFileLogg SYST 257 "/" is the current directory. Host type (3): UNIX (standard) PASV 214-The following commands are recognized cdup change to parent of current working directory cwd change working directory list give list files in a directory mdtm show last modification time of file nlst give name list of files in directory pass specify password pwd print the current working directory rnfr rename from size return size of file stor store a file user specify user name xpwd print the current working directory 214 ! Unable to parse info 214 PORT 192,168,200,4,4,242 227 Entering Passive Mode (194,78,49,253,6,98) LIST 200 PORT command successful. ! Retrieve of folder listing failed (0)
Zope Start up Log: ------ 2002-06-10T08:10:35 INFO(0) Hotfixes Applying Hotfix_2002-03-01 ------ 2002-06-10T08:10:35 INFO(0) Hotfixes Applying Hotfix_2002-04-15 /home/zope/2-5-0/lib/python/ts_regex.py:15: DeprecationWarning: the regex module is deprecated; please use the re module import regex, regsub #, Sync /home/zope/2-5-0/lib/python2.1/regsub.py:15: DeprecationWarning: the regsub module is deprecated; please use re.sub() DeprecationWarning)
------ 2002-06-10T08:10:36 INFO(0) ZODB Opening database for mounting: '15865520_1015339766.246000' ------ 2002-06-10T08:10:36 INFO(0) ZODB Mounted database '15865520_1015339766.246000' at /temp_folder ------ 2002-06-10T08:10:38 INFO(0) ZServer HTTP server started at Mon Jun 10 10:10:38 2002 Hostname: piwebserver.planetinterior.be Port: 8000 ------ 2002-06-10T08:10:38 INFO(0) ZServer HTTP server started at Mon Jun 10 10:10:38 2002 Hostname: piwebserver.planetinterior.be Port: 9800 ------ 2002-06-10T08:10:38 INFO(0) ZServer FTP server started at Mon Jun 10 10:10:38 2002 Hostname: piwebserver.planetinterior.be Port: 8021 ------ 2002-06-10T08:10:38 INFO(0) ZServer PCGI Server started at Mon Jun 10 10:10:38 2002 Unix socket: /home/zope/2-5-0/var/pcgi.soc
_______________________________________________ Zope maillist - Zope@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 )
Tnx very much, everything seems to be working fine now!
-----Oorspronkelijk bericht----- Van: Chris McDonough [mailto:chrism@zope.com] Verzonden: maandag 10 juni 2002 14:42 Aan: roel@planetinterior.com CC: zope@zope.org Onderwerp: Re: [Zope] Help! FTP access shuts down Zope
Roel,
It seems as if Zope is trying to write to a nonexistent console... although it probably shouldn't. If you are using UNIX, try to start Zope using "nohup".
On Mon, 2002-06-10 at 04:17, Roel Van den Bergh wrote:
*This is what happens when you take a break from work to see your newborn son*
Everytime when we try to access Zope trough FTP at 8021, the whole Zope server locks out and has to be restarted.
This occurred after my colleague downloaded some files directly from the source of zope while zope was still running. He says he only downloaded stuff like stupidFileLogger and index_html.dmtl and main.dtml.
Result: we can no longer FTP into the zope database When restarting zope it also says Hotfix_2002-04-15 is broken
FTP log file :
WINSOCK.DLL: WinSock 2.0 WS_FTP LE 5.08 2000.01.13, Copyright C 1992-2000 Ipswitch, Inc. - - connecting to 194.78.49.253:8021 Connected to 194.78.49.253 port 8021 220 piwebserver.planetinterior.be FTP server (Medusa Async V1.18.60.1 [experimental]) ready. USER TimW 331 Password required. PASS (hidden) 230 Login successful. PWD 451 Server Error: exceptions.IOError, [Errno 32] Broken pipe: file: /home/zope/2-5-0/lib/python/ZLogger/stupidFileLogg 10:10:38 2002 Hostname: piwebserver.planetinterior.be Port: 9800 ------ 2002-06-10T08:10:38 INFO(0) ZServer FTP server started at Mon Jun 10 10:10:38 2002 Hostname: piwebserver.planetinterior.be Port: 8021 ------ 2002-06-10T08:10:38 INFO(0) ZServer PCGI Server started at Mon Jun 10 10:10:38 2002 Unix socket: /home/zope/2-5-0/var/pcgi.soc
After starting with 'nohup' we got FTP access to Zope again. But after 1 or 2 FTP logins (with no errors and clean exits) the retrieval of the filelisting fails and everything hangs again. This occurs wheither we start normally or with the 'nohup' prefix. Anny suggestions? TIA, R. zope 2.5.1, linux redhat 7.0, cmf 1.2
-----Oorspronkelijk bericht----- Van: zope-admin@zope.org [mailto:zope-admin@zope.org]Namens Roel Van den Bergh Verzonden: maandag 10 juni 2002 15:09 Aan: Chris McDonough CC: zope@zope.org Onderwerp: RE: [Zope] Help! FTP access shuts down Zope (solved)
Tnx very much, everything seems to be working fine now!
-----Oorspronkelijk bericht----- Van: Chris McDonough [mailto:chrism@zope.com] Verzonden: maandag 10 juni 2002 14:42 Aan: roel@planetinterior.com CC: zope@zope.org Onderwerp: Re: [Zope] Help! FTP access shuts down Zope
Roel,
It seems as if Zope is trying to write to a nonexistent console... although it probably shouldn't. If you are using UNIX, try to start Zope using "nohup".
On Mon, 2002-06-10 at 04:17, Roel Van den Bergh wrote:
*This is what happens when you take a break from work to see your newborn son*
Everytime when we try to access Zope trough FTP at 8021, the whole Zope server locks out and has to be restarted.
This occurred after my colleague downloaded some files directly from the source of zope while zope was still running. He says he only downloaded stuff like stupidFileLogger and index_html.dmtl and main.dtml.
Result: we can no longer FTP into the zope database When restarting zope it also says Hotfix_2002-04-15 is broken
FTP log file :
WINSOCK.DLL: WinSock 2.0 WS_FTP LE 5.08 2000.01.13, Copyright C 1992-2000 Ipswitch, Inc. - - connecting to 194.78.49.253:8021 Connected to 194.78.49.253 port 8021 220 piwebserver.planetinterior.be FTP server (Medusa Async V1.18.60.1 [experimental]) ready. USER TimW 331 Password required. PASS (hidden) 230 Login successful. PWD 451 Server Error: exceptions.IOError, [Errno 32] Broken pipe: file: /home/zope/2-5-0/lib/python/ZLogger/stupidFileLogg 10:10:38 2002 Hostname: piwebserver.planetinterior.be Port: 9800 ------ 2002-06-10T08:10:38 INFO(0) ZServer FTP server started at Mon Jun 10 10:10:38 2002 Hostname: piwebserver.planetinterior.be Port: 8021 ------ 2002-06-10T08:10:38 INFO(0) ZServer PCGI Server started at Mon Jun 10 10:10:38 2002 Unix socket: /home/zope/2-5-0/var/pcgi.soc
_______________________________________________ Zope maillist - Zope@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 )
Hi Christian, On Monday, June 10, 2002, at 02:00 AM, Christian Theune wrote:
Sorry, for the late reply,
seems like not many ppl really use sqltest.
The sqgroup/sqltest combo has some things you didn't find out:
sqltest works like the if, when you add the optional attribute, like this:
<dtml-sqltest ticker type="nb" optional> (op=eq is the default)
Good show! I misinterpreted the docs here.. it sounded to me like nb/optional were mutually exclusive, so I never even tried them together. Doh! Time to clean up some code. ;-) take care, -steve
participants (8)
-
Chris McDonough -
Christian Theune -
David Burton -
Dieter Maurer -
Jorge O. Martinez -
Roel Van den Bergh -
Steve Spicklemire -
Thomas B. Passin