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:
Tcp Connect and IPaddress (2000)
Major problem (1999)
Help formatting search results w/ table (1997)
[SearchString] problem with [search] context (1997)
Progress !! WAS: Trouble with formula.db (1997)
emailer (1997)
WebCatalog Mac and cgi-bin (WebSTAR 2.0) (1997)
Languages (1997)
PCS Frames (1997)
ISAPI WC6a and Windows 2003 Web Edition (2006)
problems with WebCat-Plugin (1997)
WebCatalog can't find database (1997)
$Quit, $CloseDatabase corrections (1997)
Now when I send TeaRoom Order fields it does not post in Invoice. (1997)
One other big addition... (1997)
Dummy Credit Card Number for debug? (1997)
Email check problems (1999)
Just another thing regarding my weird ShoppingCarts (2003)
[OT], Sorta: WebCat-Talk List (2000)
[WebDNA] Successful, working WebDNA7/CentOS install? (2013)