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:

[protect admin] (1997) WebCommerce: Folder organization ? (1997) using showpage and showcart commands (1996) WebCat 4.0 & WebMerchant (2000) bcc and sendmail (2001) Email within tmpl ? (1997) Shipcost lookup? (1997) [append] problem (1997) includes and cart numbers (1997) Date Calulation (1997) Shop till you drop dead on the avenue ... (1997) [WebDNA] BBEdit WebDNA Configuration.plist (Language (2013) [SameAsShipping] (2005) Emailer (WebCat2) (1997) shipping costs (1997) Tip O' the Week (1996) [WebDNA] Triggers not working (2014) New public beta available (1997) WebCat2 beta 11 - new prefs ... (1997) Image editing in browser (2005)