Re: [WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows IIS 5.1 - Windows XP Pro Dev Box
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 105184
interpreted = N
texte = OK, yes (if you are right) - assuming the perms are fine.. still my =20 point was something else - that maybe the error message is not that =20 perms are wrong, but that the db is unavailable because the underlying =20= OS is still busy with the file (setting the perms) - because of that =20 [shell] line. Maybe that is silly (because the webdna executes line by line and =20 waits for the perm setting to be done before trying to execute the =20 next line of code?).. but if it were me, I would want to know if the =20 problem was still there even if that [shell] line was not there. Did =20= you test without that [shell] line? If you have, and the problem is still there.. then: I would play with [listfields] (and [ListDatabases]?), step by step, =20= one at a time. build up from absolute bare bones simple first baby =20 step.. adding one thing at a time until you see where it breaks. I have used both of those contexts in fairly complex scenarios even.. =20= and so far I am happy with them. Try getting simpler examples of =20 those contexts running (clearly they are valid contexts) and slowly =20 massage to where you need them. Then post again here, from scratch, =20= where it is breaking.. as if the first post on the topic. -Govinda On Apr 23, 2010, at 2:42 PM, William DeVaul wrote: > Good point. The flush and shell show that the perms should be OK. > That was a test based on an earlier comment from Patrick. > > On Fri, Apr 23, 2010 at 2:30 PM, Govinda =20 >
wrote: >> just an idea: >> >> what if you comment out the [shell] line? >> Once you set the perms, then why even have that in there =20 >> (permanently)? >> maybe [shell] is still busy with it when webdna gets to the =20 >> [listfields] >> context. >> >> (??) >> >> -G >> >> On Apr 23, 2010, at 11:16 AM, William DeVaul wrote: >> >>> I am seeing the DB error using the following code: >>> >>> [flushdatabases] >>> [shell]chmod 664 /var/www/html/sitename/data.db[/shell] >>> >>> [listfields db=3D/var/www/html/sitename/data.db] >>> [fieldname] >>> [/listfields] >>>
>>> >>> The file perms show up as 664. The folder all the way down are 755. >>> This means any user should be able to get to the folder and read the >>> database. Failed even when I changed the file perms to 777. I =20 >>> cannot >>> change the folder to be that permissive. >>> >>> Works fine if I use just the filename to the webdna script, i.e >>> ../data.db. Seems unlikely to be a permissions issue. >>> >>> Any thoughts on why this doesn't work? >>> >>> Bill >>> >>> >>> On Wed, Oct 15, 2008 at 11:12 AM, Patrick McCormick =20= >>> wrote: >>>> >>>> The first thing that comes to mind is to verify proper =20 >>>> permissions on the >>>> db. >>>> Make sure that you [flushdatabases] first because changing =20 >>>> permissions >>>> when >>>> the databases is loaded in RAM has no effect. You need to unload =20= >>>> it, >>>> change >>>> the permissions, then re-load it. >>>> Pat >>>> >>>> On Oct 15, 2008, at 10:06 AM, Michael A. DeLorenzo wrote: >>>> >>>> I=92m getting the following error: >>>> >>>> Fields in database >>>> c:\inetpub\wwwroot\oldecarriage_live\dbs\oldecarriage.db: >>>> An unknown error occurred: >>>> DBError >>>> c:\inetpub\wwwroot\oldecarriage_live\dbs\oldecarriage.db >>>> Database file could not be found or opened >>>> >>>> It happens when I use this code from the 6.0 docs: >>>> >>>> [ListDatabases] >>>> Fields in database [name]:
>>>> [ListFields db=3D[name]] >>>> Fieldname: [FieldName]
>>>> [/ListFields] >>>>
>>>> [/ListDatabases] >>>> >>>> The funny thing is that the code above lists the system databases >>>> perfectly. >>>> >>>> Also, this code works just fine if I want to list the fields from a >>>> specified db: >>>> >>>> [ListFields db=3Doldecarriage.db] >>>> [FieldName]
>>>> [/ListFields] >>>> >>>> >>>> Which leads me to believe there is something buggy with the >>>> [ListDatabases] >>>> tag. >>>> >>>> Anyone else having the same problem? >>>> >>>> >>>> >>>> Michael A. DeLorenzo >>>> Broker - Associate >>>> General Manager >>>> Web Master / Systems Engineer/ Network Administrator/ Graphic =20 >>>> Designer/ >>>> Director of Advertising/ Director of Marketing/ Mr. Fix It/ Problem >>>> Solver/ >>>> Head of you name it I do it Department >>>> Olde Carriage Realty, Inc. >>>> 92 Charlotte St. >>>> St. Augustine, FL 32084 >>>> Phone: 904-824-4500 >>>> Mobile: 904-377-5582 >>>> Fax: 904-824-6866 >>>> Toll-Free: 800-555-6138 >>>> Web: www.oldecarriage.com >>>> >>>> >>>> >>>> >>>> >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> old archives: http://dev.webdna.us/TalkListArchive/ >>> Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288 >> >> ------------ >> Govinda >> govinda.webdnatalk@gmail.com >> >> >> >> >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ >> Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288 >> > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288 ------------ Govinda govinda.webdnatalk@gmail.com
Associated Messages, from the most recent to the oldest:
OK, yes (if you are right) - assuming the perms are fine.. still my =20 point was something else - that maybe the error message is not that =20 perms are wrong, but that the db is unavailable because the underlying =20= OS is still busy with the file (setting the perms) - because of that =20 [shell] line. Maybe that is silly (because the webdna executes line by line and =20 waits for the perm setting to be done before trying to execute the =20 next line of code?).. but if it were me, I would want to know if the =20 problem was still there even if that [shell] line was not there. Did =20= you test without that [shell] line? If you have, and the problem is still there.. then: I would play with [listfields] (and [listdatabases]?), step by step, =20= one at a time. build up from absolute bare bones simple first baby =20 step.. adding one thing at a time until you see where it breaks. I have used both of those contexts in fairly complex scenarios even.. =20= and so far I am happy with them. Try getting simpler examples of =20 those contexts running (clearly they are valid contexts) and slowly =20 massage to where you need them. Then post again here, from scratch, =20= where it is breaking.. as if the first post on the topic. -Govinda On Apr 23, 2010, at 2:42 PM, William DeVaul wrote: > Good point. The flush and shell show that the perms should be OK. > That was a test based on an earlier comment from Patrick. > > On Fri, Apr 23, 2010 at 2:30 PM, Govinda =20 > wrote: >> just an idea: >> >> what if you comment out the [shell] line? >> Once you set the perms, then why even have that in there =20 >> (permanently)? >> maybe [shell] is still busy with it when webdna gets to the =20 >> [listfields] >> context. >> >> (??) >> >> -G >> >> On Apr 23, 2010, at 11:16 AM, William DeVaul wrote: >> >>> I am seeing the DB error using the following code: >>> >>> [flushdatabases] >>> [shell]chmod 664 /var/www/html/sitename/data.db[/shell] >>> >>> [listfields db=3D/var/www/html/sitename/data.db] >>> [fieldname] >>> [/listfields] >>>
>>> >>> The file perms show up as 664. The folder all the way down are 755. >>> This means any user should be able to get to the folder and read the >>> database. Failed even when I changed the file perms to 777. I =20 >>> cannot >>> change the folder to be that permissive. >>> >>> Works fine if I use just the filename to the webdna script, i.e >>> ../data.db. Seems unlikely to be a permissions issue. >>> >>> Any thoughts on why this doesn't work? >>> >>> Bill >>> >>> >>> On Wed, Oct 15, 2008 at 11:12 AM, Patrick McCormick =20= >>> wrote: >>>> >>>> The first thing that comes to mind is to verify proper =20 >>>> permissions on the >>>> db. >>>> Make sure that you [flushdatabases] first because changing =20 >>>> permissions >>>> when >>>> the databases is loaded in RAM has no effect. You need to unload =20= >>>> it, >>>> change >>>> the permissions, then re-load it. >>>> Pat >>>> >>>> On Oct 15, 2008, at 10:06 AM, Michael A. DeLorenzo wrote: >>>> >>>> I=92m getting the following error: >>>> >>>> Fields in database >>>> c:\inetpub\wwwroot\oldecarriage_live\dbs\oldecarriage.db: >>>> An unknown error occurred: >>>> DBError >>>> c:\inetpub\wwwroot\oldecarriage_live\dbs\oldecarriage.db >>>> Database file could not be found or opened >>>> >>>> It happens when I use this code from the 6.0 docs: >>>> >>>> [listdatabases] >>>> Fields in database [name]:
>>>> [ListFields db=3D[name]] >>>> Fieldname: [FieldName]
>>>> [/ListFields] >>>>
>>>> [/ListDatabases] >>>> >>>> The funny thing is that the code above lists the system databases >>>> perfectly. >>>> >>>> Also, this code works just fine if I want to list the fields from a >>>> specified db: >>>> >>>> [ListFields db=3Doldecarriage.db] >>>> [FieldName]
>>>> [/ListFields] >>>> >>>> >>>> Which leads me to believe there is something buggy with the >>>> [listdatabases] >>>> tag. >>>> >>>> Anyone else having the same problem? >>>> >>>> >>>> >>>> Michael A. DeLorenzo >>>> Broker - Associate >>>> General Manager >>>> Web Master / Systems Engineer/ Network Administrator/ Graphic =20 >>>> Designer/ >>>> Director of Advertising/ Director of Marketing/ Mr. Fix It/ Problem >>>> Solver/ >>>> Head of you name it I do it Department >>>> Olde Carriage Realty, Inc. >>>> 92 Charlotte St. >>>> St. Augustine, FL 32084 >>>> Phone: 904-824-4500 >>>> Mobile: 904-377-5582 >>>> Fax: 904-824-6866 >>>> Toll-Free: 800-555-6138 >>>> Web: www.oldecarriage.com >>>> >>>> >>>> >>>> >>>> >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> old archives: http://dev.webdna.us/TalkListArchive/ >>> Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288 >> >> ------------ >> Govinda >> govinda.webdnatalk@gmail.com >> >> >> >> >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ >> Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288 >> > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288 ------------ Govinda govinda.webdnatalk@gmail.com
Govinda
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
jpg and gif format thumbnails (2004)
[TaxableTotal] - not working with AOL and IE (1997)
Error: Permision deny. (2005)
[SearchString] problem with [search] context (1997)
Re:One more time (1997)
Hide Cart ID in URL? (2003)
RE: [sendmail]- bcc? (1998)
Click-through/Referral tracking solution needed (2000)
Removing [showif] makes a big difference in speed (1997)
Setting up shop (1997)
Add to a field (1998)
Getting total number of items ordered (1997)
Alpha numeric [CreateDate] (2000)
RE: Quantity (1998)
Cleaning up all the shopping carts (2000)
RE: Renaming textA (1998)
WebCat & WebTen (1997)
Math problems (1998)
Creating a folder with WebCat? (2000)
webCatalog and Stocks (1998)