Re: [WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 105180
interpreted = N
texte = 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
wrote: > The first thing that comes to mind is to verify proper permissions on the > db. > Make sure that you [flushdatabases] first because changing permissions wh= en > the databases is loaded in RAM has no effect. You need to unload it, chan= ge > 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 perfect= ly. > > 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 [ListDatabase= s] > 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 Solve= r/ > Head of you name it I do it Department > Olde Carriage Realty, Inc. > 92 Charlotte St. > St. Augustine,=A0FL=A032084 > Phone: 904-824-4500 > Mobile: 904-377-5582 > Fax: 904-824-6866 > Toll-Free: 800-555-6138 > Web:=A0www.oldecarriage.com > > > > >
Associated Messages, from the most recent to the oldest:
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 wrote: > The first thing that comes to mind is to verify proper permissions on the > db. > Make sure that you [flushdatabases] first because changing permissions wh= en > the databases is loaded in RAM has no effect. You need to unload it, chan= ge > 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 perfect= ly. > > 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 [ListDatabase= s] > 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 Solve= r/ > Head of you name it I do it Department > Olde Carriage Realty, Inc. > 92 Charlotte St. > St. Augustine,=A0FL=A032084 > Phone: 904-824-4500 > Mobile: 904-377-5582 > Fax: 904-824-6866 > Toll-Free: 800-555-6138 > Web:=A0www.oldecarriage.com > > > > >
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:
Quit revisited (1997)
WebDNA 5.1 is now available! (2003)
[lookup] [search] Issue (2005)
Re:Searching for ALL / empty form field (1997)
Frames and WebCat (1997)
WebCatalog for Postcards ? (1997)
WebCat for Unix?? (1997)
[ot] G5 Desktop as Server (2004)
Updating fields from different platforms (1998)
user/password validation (1998)
Problem (1997)
[WebDNA] Downloadable file protection (2011)
ReturnRaw, download link for mov (2007)
For those of you not on the WebCatalog Beta... (1997)
Mozilla/4. and Browser Info.txt (1997)
taxrate - off by 1 cent (1997)
Calculating multiple shipping... (1997)
Getting total number of items ordered (1997)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
Emailer setup (1997)