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:
Rhapsody? (1997)
Database Fields (1997)
Add command creates new cart but I'm passing existing cart...? (2000)
More on the email templates (1997)
Search context not finding recent entries (1998)
Logging purchases (1997)
No more misunderstanding ... yay! :) (1997)
[WebDNA] Setting up a new server, hierarchy question (2014)
[WebDNA] Silly question (2016)
Emailer 1.01 bombs (1997)
[searchString] (1997)
RE: Can a database get stomped by simultaneous access? (1997)
Running 2 two WebCatalog.acgi's (1996)
[WebDNA] PGP Encrypted Emails using [sendmail] (2009)
[sendmail] bug? (2000)
BUG NOTICE: (2003)
New public beta available (1997)
serial number dishing (1997)
WC TableGrinder (1997)
Founditems context returning only 1 item (1997)