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 = 105181
interpreted = N
texte = just an idea: what if you comment out the [shell] line? Once you set the perms, then why even have that in there (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 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 permissions =20= >> 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=20 >> \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 =20 >> 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 =20 >> [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 =20= >> 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 Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows IIS 5.1 - Windows XP Pro Dev Box (Govinda 2010)
  2. Re: [WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows IIS 5.1 - Windows XP Pro Dev Box (Govinda 2010)
just an idea: what if you comment out the [shell] line? Once you set the perms, then why even have that in there (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 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 permissions =20= >> 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=20 >> \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 =20 >> 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 =20 >> [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 =20= >> 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 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:

Me know logical no need (2002) [WebDNA] Authorize.net and [tcpconnect] (2016) Change extension (2000) [WebDNA] Docs Update (2015) Configuring E-mail (1997) wierd [cart] action! (1997) Counting records (2000) AOL displays strange header info (2000) General WebCatalog Questions (1997) Editing the search string (1997) Shopping Cart Problem (1998) Re:Merging databases (1997) [ListWords] BUG? (2003) why won't this work, please tell me??? (2001) Associative lookup style? (1997) Keep away (1997) Cold Fusion Buster (1997) b12 cannot limit records returned and more. (1997) 2.1 pricing? (1998) OT: Variables in printed URL (2007)