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:

OrdersFolder parm missing and DBServer Access Violations (2000) Lookup & Form Variables (2000) WebCat hosting providers? (1997) Itools, WEBCAT OSX (2003) Running _every_ page through WebCat ? (1997) [WebDNA] making a gift cert. (in effect) it's own lineitem/'product' with negative price - pros/cons? (2008) Re:Help name our technology! (1997) Did you hear about this? (1997) select multiple 2 more cents (1997) Shell traceroute (2001) RE: Problems with shopping cart (1997) Single Link browsing (1997) Forbidden CGI Error (1997) Multiple catalog databases and showcart (1997) quantity minimum problem (1997) Line ending nuisance (2005) Trigger alternatives please ... (2004) authorizenet and netscape (2002) WebCat2 - Getting to the browser's username/password data (1997) search command (1999)