- Zope - Zope lists

Re: [Zope] SyBase connection problem
by Hung Jung Lu 12 Jan '00

12 Jan '00

Thanks to Chris McDonough for the help. My SybaseDAv2 is running, now! :) Before getting it to work, besides the shared library problem (/etc/ld.so.conf and ldconfig) I also ran into another problem. I will mention it so if other people run into the same problem they can look it up here. My Zope was throwing the error message: "The context allocation routine failed when it tried to load localization files!! One or more following problems may caused the failure Your sybase home directory is /opt/sybase-11.9.2 Check the environment variable SYBASE if it is not the one you want! Using locale name "en_US" defined in environment variable LC_ALL Local name "en_US" doesn't exist in your /opt/sybase-11.9.2/locales/locales.dat file" What happened was that in my locales.dat file, under the [linux] section, I did not have the "en_US" entry... I only had the locale = ENGLISH, us_english, iso_1 entry. So I had to duplicate this entry and change it to: locale = en_US, us_english, iso_1 After that, I restarted Sybase and Zope, and it worked. thanks again! Hung Jung >From: Chris McDonough <chrism(a)digicool.com> > >SybaseDAv2 takes all its information from the interfaces file. As long >as you put a hostname in the server field and that hostname resolves to >the IP address that's listed in the interfaces file, it uses that >interfaces entry to access the database. This also means that the port >it looks to on the server is the one that is specified within the >interfaces file. Usually, you can just type the name you've defined in >the interfaces file into the server textbox within SybaseDAv2. > >AFAIK, the interfaces file only controls the client library lookups, and >you'll need to go change the server port somewhere else (where, I don't >know). > >Before you run Zope, in the start script you'll need to set the $SYBASE >environment variable to the sybase home directory, and you'll need to >make sure that the /etc/ld.so.conf file lists $SYBASE/lib as a place to >find shared libraries. If you add an entry to ld.so.conf, you'll need >to run ldconfig to reparse the ld.so.conf file. This is on Linux. On >solaris, you can define an environment variable ($LD_LIBRARY_PATH) that >points to the sybase lib dir. > >If all is well with the world after that, you should be able to connect >to your database. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

1 0

Re: Photo Update
by Andrew Lahser 12 Jan '00

12 Jan '00

> Sounds interesting! I hope it will work seamlessly with my other > things stored in ZCatalogs... ZPhotoAlbum will be its own ZCatalog. If you want to search it by itself you can, or you can select multiple ZCatalogs to search. This should be what you want, let me know otherwise. > > The new format of referencing photos in dtml gives me headaches... > > If I try to step through an unknown number of photos in a folder, I would do: > > <dtml-in "objectIds('Photo')"> > <dtml-var "_['sequence-item'](REQUEST, pdcookie='true', border=0)"> > </dtml-in> > Sure. I can see that. Try this. <dtml-in "objectValues('Photo')"> <dtml-var "tag(REQUEST, pdcookie='1', border=0)"> </dtml-in> > But this does not work. I tried several versions of this - nothing. > How would you do this??? Let me know right away if this does not work. > > Next, I have Articles that store the name of a top-image in a > property called topimage. How can I reference the original photo > object? The old way was : > > <img src="/<dtml-var "getpath(data_record_id_)">/<dtml-var > topimg>/thumbnail" border="0" alt="<dtml-var title>" align=right> > > How can I transform this to the new way??? > This came up on the list last night. Try this. <dtml-with "_.getitem(topimage,0)"> # Return a reference to the Photo object that is named in topimage # Place the Photo on top of the namespace stack <dtml-var "tag(display='thumbnail', border=0)"> # Call the tag method of the current object with parameters. # The REQUEST variable isn't necessary because we only want thumbnails. # Note that the alt tag defaults to the title # Further note that the /thumbnail method-interface is deprecated, all # displays are set through the display parameter. </dtml-with> I am open to suggestions on making this dtml-interface better, but I found this to be the most flexible so far. It also reads more like Zope code, but it takes a little getting used to. I may still have much to learn here. Drew

2 1

Re: [Zope] Simple ZSQL question -- variable expansion in dtml-if?
by J C Lawrence 12 Jan '00

12 Jan '00

On Tue, 11 Jan 2000 18:22:38 -0600 Jim Sanford <jsanford(a)atinucleus.com> wrote: > If X is being returned from an html form it will actually be a > string. (Putting "X:int" in the parameter line of the ZSQL method > will not coerce it to an integer.) In that case use "_.int(X)==1" > etc. or make the varaible name "X:int" in your form. Ahhhhh! Light dawns! <<testing quickly>> Yes, this works _and_ makes sense. Thanks. -- J C Lawrence Internet: claw(a)kanga.nu ----------(*) Internet: coder(a)kanga.nu ...Honorary Member of Clan McFud -- Teamer's Avenging Monolith...

1 0

Re: Photo Update
by Jochen Haeberle 12 Jan '00

12 Jan '00

Hi Drew, both methods work! Thanks a lot. At 18:16 Uhr +0000 11.01.2000, Andrew Lahser wrote: > > Sounds interesting! I hope it will work seamlessly with my other > > things stored in ZCatalogs... >ZPhotoAlbum will be its own ZCatalog. If you want to search it by >itself you can, or you can select multiple ZCatalogs to search. >This should be what you want, let me know otherwise. This sounds like what I want... good! Hopefully it will be as easy to integrate as it sounds :-) >I am open to suggestions on making this dtml-interface better, but >I found this to be the most flexible so far. It also reads more like >Zope code, but it takes a little getting used to. I may still have >much to learn here. I would like to have more control over the way the html-Interface is rendered. This way it builds up its own table and the only way to fo anything to the look ist to redesign the existing styles using css. I guess an bar where the buttons are graphics added to the image for example at the bottom would be more flexible. You were looking for a solution to set up default display sizes... how about an Object "Photo sizes" that can be added anywhere in the hirarchy and sets the display defaults from there on. This way the values would be inherited further down but could easily be set for specific needs or overwritten. Jochen

2 1

Re: [Zope] Simple ZSQL question -- variable expansion in dtml-if?
by J C Lawrence 12 Jan '00

12 Jan '00

On Tue, 11 Jan 2000 07:51:22 -0600 Jim Sanford <jsanford(a)atinucleus.com> wrote: > SELECT * FROM table > <dtml-if "X==1"> > WHERE col=1 > <dtml-elif "X==-1"> > WHERE col=0 > </dtml-if> > should work. It assumes that X will only be between -1 and 1. That's pretty close to what I did at the beginning and what I just triied just now -- X doesn't get expanded for the conditional inside a ZSQL object AFAICT. -- J C Lawrence Home: claw(a)kanga.nu ----------(*) Other: coder(a)kanga.nu --=| A man is as sane as he is dangerous to his environment |=--

2 1

More REQUEST.set() not incrementing
by Jerry.Spicklemire＠IFLYATA.COM 12 Jan '00

12 Jan '00

Hi again, No response to my first distress call, so I thought maybe some more details would help. When I insert some print commands, the assigned "counter" (u_*) variables exist, but are reported as being equal to zero (0). So, it appears that the original assignment is "taking". Except that when I look at all of the variables by printing <dtml-var REQUEST>, the same variables appear as being equal to one (1), so it seeems like the incrementing is happening. Except that, the number never increases beyond one, so that it seems that what appeared to be incrementing was really just re-setting the variable to zero plus 1 (0 + 1), as if each pass through the loop is refreshing the values to the original assignment. So, one might conclude that the _ variables are not persistent, or are too persistent, depending on how you look at it. The assorted ways I've tried to assign and retrieve these variable, e.g. in : <dtml-var u_all> <dtml-var "u_all"> <dtml-var _[u_all]> <dtml-var _["u_all"]> <dtml-var "_[u_all]"> <dtml-var "_['u_all']"> Thanks for looking at this silly thing, Jerry S. <dtml-with "REQUEST.set('z_t', _.string.split(_.str(ZopeTime()))[0])"> <dtml-let u_all="_.string.atoi('0')" u_logged="_.string.atoi('0')" u_today="_.string.atoi('0')"> <dtml-var u_all> <dtml-var u_logged> <dtml-var u_today> REQUEST = <dtml-var REQUEST> <dtml-in count_users_logged> <dtml-call "REQUEST.set('u_all',_.int(u_all)+1)"> users_with_access = <dtml-var u_all> <dtml-if logged_on> <dtml-call "REQUEST.set('u_logged',_.int(u_logged)+1)"> users_logged_ever = <dtml-var u_logged> <dtml-if "z_t==_.string.split(_.str(_.DateTime(logged_on)))[0]"> <dtml-call "REQUEST.set('u_today',_.int(u_today)+1)"> users_logged_today = <dtml-var u_today> </dtml-if> </dtml-if> </dtml-in> users_with_access = <dtml-var u_all> users_logged_ever = <dtml-var u_logged> users_logged_today = <dtml-var u_today> REQUEST = <dtml-var REQUEST></dtml-let> </dtml-with>

4 3

SyBase connection problem
by Hung Jung Lu 12 Jan '00

12 Jan '00

Hi, I am new to Sybase. I have installed the SybaseDAv2 product without problem on Zope, I can see it in the product list. But when I click on it, I get the following error: Traceback (innermost last): File "/usr/local/bs_zope_2000_01/lib/python/OFS/Application.py", line 387, in import_products product=__import__(pname, global_dict, global_dict, silly) File "/usr/local/bs_zope_2000_01/lib/python/Products/SybaseDAv2/__init__.py", line 90, in ? import DA File "/usr/local/bs_zope_2000_01/lib/python/Products/SybaseDAv2/DA.py", line 91, in ? from db import DB File "/usr/local/bs_zope_2000_01/lib/python/Products/SybaseDAv2/db.py", line 96, in ? _context=sy_occ.cs_ctx_alloc() sy_occ.error: Could not connect to Sybase The Sybase database itself is running, as I can see it from isql or from the ./showserver commands. One immediate question is: does SybaseDAv2 assume a particular TCP/IP port number (like 4100 or 4002)? If so, how can I change that number? How can I change the the hostname and port number in general? In general, how does SybaseDAv2 know what host and what port number the database is serving from? Is there any configuration file? How does one supply things like username and password in SybaseDAv2 to the Sybase database? Am I asking the right questions? I have tried to tweak the "interfaces" file in Sybase itself so it serves at the port number 4100 or 4002, but neither choice improved the situation. After installing the SybaseDAv2, what else do I need to do before I can start to create SQL methods? thanks in advance, Hung Jung ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

2 1

expression in a tree tag?
by Guy Davis 11 Jan '00

11 Jan '00

Sorry to keep bothering everyone with my numerous questions. Here's the latest... Given a URL like this: http://servername/Projects/ProjectName/Path/To/Document I can use <dtml-var "_.string.split(URL0,'/')[4]"> to get the name of the project. However, on pages in the ProjectName folder, I am using a tree to show the docs available. If my tree tag is: <dtml-tree expr="ProjectName" ... everything works. I want this code to work for multiple projects however so I tried: <dtml-tree expr="_.string.split(URL0,'/')[4]" ... but this doesn't seem to actually evaluate the method call as I got a name error for _. How can I have the dtml-tree tag evaluate that expression and get 'ProjectName'? Thanks again. -- Guy Davis mailto:davis@arc.ab.ca (403) 210-5334 Alberta Research Council

2 1

freaky folder
by Denny Valliant 11 Jan '00

11 Jan '00

Hey all, I wrote the list yesterday about a zope problem that I'm having. A couple of people responded, but I still haven't been able to solve the prob. I have been able to get a little more specific idea of what's wrong. Hopefully someone can HELP ME!!! =) This is what is wrong: I have a folder that has a BUNCH of sql methods, couple of dtml pages, and a bunch of plain ol' methods. In my old install of zope, I can get in and mess around in the folder, no prob. I see all the methods, etc. Now I get new web server, a wild hair up my ass, and I decide "hey! wouldn't it be neat if I could upgrade to the latest ver of zope when I switch it over? YEAH!!" So I convert the old db, import it into the new ver of zope, and everything looks copasetic. I check my site, and the database is working right, it's serving up the content right, heck, I... am... stoked!!! Then I get into the management area. I log in as superuser (like I've always done), and everything looks fine... until I try to get into my training/centers/manager folder. "That's-when-things-got-out-of-control", to coin a phrase from song I like. Instead of showing me the methods, etc., that are in the folder, it brings up the standard_header web page in the frame where its SUPPOSED to be showing me the list of methods, etc. That is the problem. Doesn't seem that complicated, (I think. ha ha) it's gotta be just some funky conversion error, or some such. Here are the things I've tried: First, I tried copying and renaming the folder in my OLD zope db, and then exporting the old db to the new zope db again. No dice. (I was thinking maybe since the name of the folder is 'manager', there is something funky going on.) So that didn't work. I really tried all kinds of ways of exporting the damn folder. I tried copying the methods into other folders, and exporting them, and that worked, but there are WAY TOO MANY to piecemeal them, one by one, into another folder (like 70 or so... maybe not WAY, but still too many, if I can help it). and I still wouldn't know what was originally wrong. (its something that bugs me... not knowing why bugs do what they do, and just going around them. Sometimes they have a way of jumping out at you when you least expect it. =) Annywaze... Nick G. recommended messing with UserDb a little. I tried clearing cookies, logging in as different users, and logging in from different machines. Still no dice. I've copied and pasted the folder within the new zope db, (it copies fine) but it don't matter, every time I go into even a copied and renamed folder, it does the same thing. I'm thinking this must be a conversion issue, which in my mind isn't that bad, since I can piecemeal the damn methods, etc, into a new directory and THEN export 'em, if I *have* to, and this won't come back to haunt me. The scary thing for me is, I don't *know* its a conversion issue, and it would suck to piecemeal the crap only to find it was something else causing the freaky folder nature. If, even with this longer description, know one knows what is happening here... well... oh well, I guess. But it would be neat if someone says "oh, NOW I know what your talking about! All ya gotta do is click on the 'fix error' button in the upper left hand corner!" could happen, right? right!?! =) Thanks for yall's help ennywaze though. Expecially Nick and Michel. You two were quick with suggestions, even though this is obviously just a 'newbie-ish' error (I hope) . -ps if it IS some easy answer, please email me personally... I wouldn't want the whole list to know how retarded I really am. =) Thanks.

2 1

Re: smushed download
by Darrell 11 Jan '00

11 Jan '00

Sorry about the html --Darrell

2 1