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:

NEWBIE ? help with link (1998) using showpage and showcart commands (1996) Running 2 two WebCatalog.acgi's (1996) SiteGuard Use Question (1997) Triggers (2003) [CART] inside a [LOOP] (1997) Single Link browsing (1997) Re2: frames & carts (1997) expiring a cookie each thursday (2000) Fwd: Handling Charges (1999) Showif, Hideif reverse logic ? (1997) Is there a max number of fields? (1998) ampersand in a sendmail body (2007) WebCat website for developers and hosters (2001) syntax question, not in online refernce (1997) Thanks Grant (1997) webcat NT (1998) Search/sort in URL Was: GuestBook example (1997) How can I record purchases to a database? (1998) [WebDNA] WebDNA Host being retired (2014)