Re: [WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105182
interpreted = N
texte = 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 wro= te: > 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 [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] >>
>> =A0[listfields db=3D/var/www/html/sitename/data.db] >> =A0 [fieldname] >> =A0[/listfields] >>
>> >> The file perms show up as 664. =A0The folder all the way down are 755. >> This means any user should be able to get to the folder and read the >> database. =A0Failed even when I changed the file perms to 777. =A0I cann= ot >> change the folder to be that permissive. >> >> Works fine if I use just the filename to the webdna script, i.e >> ../data.db. =A0Seems 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 wrote= : >>> >>> The first thing that comes to mind is to verify proper permissions on t= he >>> db. >>> Make sure that you [flushdatabases] first because changing permissions >>> when >>> the databases is loaded in RAM has no effect. You need to unload 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 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 > Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows (William DeVaul 2010)
  2. Re: [WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows IIS 5.1 - Windows XP Pro Dev Box (Govinda 2010)
  3. Re: [WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows (William DeVaul 2010)
  4. Re: [WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows IIS 5.1 - Windows XP Pro Dev Box (Govinda 2010)
  5. Re: [WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows (William DeVaul 2010)
  6. Re: [WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows IIS 5.1 - Windows XP Pro Dev Box (Patrick McCormick 2008)
  7. [WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows IIS 5.1 - Windows XP Pro Dev Box ("Michael A. DeLorenzo" 2008)
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 wro= te: > 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 [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] >>
>> =A0[listfields db=3D/var/www/html/sitename/data.db] >> =A0 [fieldname] >> =A0[/listfields] >>
>> >> The file perms show up as 664. =A0The folder all the way down are 755. >> This means any user should be able to get to the folder and read the >> database. =A0Failed even when I changed the file perms to 777. =A0I cann= ot >> change the folder to be that permissive. >> >> Works fine if I use just the filename to the webdna script, i.e >> ../data.db. =A0Seems 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 wrote= : >>> >>> The first thing that comes to mind is to verify proper permissions on t= he >>> db. >>> Make sure that you [flushdatabases] first because changing permissions >>> when >>> the databases is loaded in RAM has no effect. You need to unload 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 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 > William DeVaul

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:

Thanks Grant (1997) My slower response (1997) More to Expire (1998) [ConvertChars] problem (1997) WebCat2 Append problem (B14Macacgi) (1997) Tracking (2004) Help formatting search results w/ table (1997) problems with 2 tags (1997) NetForms for mail, sorry (1998) Friday night shopping site joke (1997) Where's Cart Created ? (1997) Logging purchases (1997) Poll Results (2002) [DOS]/DOS query perhaps OT (2003) Off-Topic: Automatic FTP scripts for OSX (2003) WebCat2 - Getting to the browser's username/password data (1997) RE: problem with applets embedded in tpl files (1997) [WebDNA] How to code a 301 redirect (2008) Time Tracking (2003) RAM variables (1997)