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

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105183
interpreted = N
texte = This is a multi-part message in MIME format. --------------050107040303030307070706 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: quoted-printable Here's a thought. Are you working in a sandbox? On my servers I can't make a DB call to /var/www/html/sitename/data.db I would have to make the DB call to /sitename/data.db On the other hand, [shell] calls do use the full filesystem directory=20 structure. Matt William DeVaul wrote: > 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 = wrote: > =20 >> 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 [listfield= s] >> context. >> >> (??) >> >> -G >> >> On Apr 23, 2010, at 11:16 AM, William DeVaul wrote: >> >> =20 >>> 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 canno= t >>> 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 wr= ote: >>> =20 >>>> The first thing that comes to mind is to verify proper permissions o= n the >>>> db. >>>> Make sure that you [flushdatabases] first because changing permissio= ns >>>> 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 Design= er/ >>>> 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 >>>> >>>> >>>> >>>> >>>> >>>> =20 >>> --------------------------------------------------------- >>> 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&categ= ory=3D288 >>> =20 >> ------------ >> 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&catego= ry=3D288 >> >> =20 > --------------------------------------------------------- > 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&categor= y=3D288 > > > =20 --=20 Matthew A Perosi =20 SEO Analyst Senior Web Developer =20 Psi Prime, Inc. 323 Union Blvd. Totowa, NJ 07512 Pre-Sales: 888.872.0274 Service: 973.413.8213 Training: 973.413.8214 Fax: 973.413.8217 http://www.psiprime.com --------------050107040303030307070706 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Here's a thought.
Are you working in a sandbox?
On my servers I can't make a DB call to /var/www/html/sitename/data.db I would have to make the DB call to /sitename/data.db

On the other hand, [shell] calls do use the full filesystem directory structure.

Matt

William DeVaul wrote: 
Good point.  The flush and shell show that the perms sho=uld be OK.That was a test based on an earlier comment from Patrick.On Fri, Apr 23, 2010 at 2:30 PM, Govinda <govinda.webdnatalk@gm=ail.com> wrote:  
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.(??)-GOn 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]<div>=A0[listfields db=3D/var/www/html/sitename/data.db]=A0 [fieldname]=A0[/listfields]</div>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 thedatabase. =A0Failed even when I changed the file perms to 777. =A0I canno=tchange 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?BillOn Wed, Oct 15, 2008 at 11:12 AM, Patrick McCormick <pm@webdna.us> wrote=:      
The first thing that comes to mind is to verify pr=oper permissions on thedb.Make sure that you [flushdatabases] first because changing permissionswhenthe databases is loaded in RAM has no effect. You need to unload it,changethe permissions, then re-load it.PatOn Oct 15, 2008, at 10:06 AM, Michael A. DeLorenzo wrote:I=92m getting the following error:Fields in databasec:\inetpub\wwwroot\oldecarriage_live\dbs\oldecarriage.db:An unknown error occurred:DBErrorc:\inetpub\wwwroot\oldecarriage_live\dbs\oldecarriage.dbDatabase file could not be found or openedIt happens when I use this code from the 6.0 docs:[ListDatabases]Fields in database [name]:<br>[ListFields db=3D[name]]Fieldname: [FieldName]<br>[/ListFields]<hr>[/ListDatabases]The funny thing is that the code above lists the system databasesperfectly.Also, this code works just fine if I want to list the fields from aspecified db:[ListFields db=3Doldecarriage.db][FieldName]<br>[/ListFields]Which leads me to believe there is something buggy with the[ListDatabases]tag.Anyone else having the same problem?Michael A. DeLorenzoBroker - AssociateGeneral ManagerWeb Master / Systems Engineer/ Network Administrator/ Graphic Designer/Director of Advertising/ Director of Marketing/ Mr. Fix It/ ProblemSolver/Head of you name it I do it DepartmentOlde Carriage Realty, Inc.92 Charlotte St.St. Augustine, FL 32084Phone: 904-824-4500Mobile: 904-377-5582Fax: 904-824-6866Toll-Free: 800-555-6138Web: www.oldecarriage.com        
----------------------------------------------------=-----This message is sent to you because you are subscribed tothe mailing list <talk@webdna.us>.To unsubscribe, E-mail to: <talk-leave@webdna.us>archives: http://mail.webdna.us/list/talk@webdna.usold archives: http://dev.webdna.us/TalkListArchive/Bug Reporting: http://forum.webdna.us/=eucabb.html?page=3Dtopics&category=3D288      
------------Govindagovinda.webdnatalk@gmail.com---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list <talk@webdna.us>.To unsubscribe, E-mail to: <talk-leave@webdna.us>archives: http://mail.webdna.us/list/talk@webdna.usold archives: http://dev.webdna.us/TalkListArchive/Bug Reporting: http://forum.webdna.us/=eucabb.html?page=3Dtopics&category=3D288    
-------------------------------------------------=--------This message is sent to you because you are subscribed tothe mailing list <talk@webdna.us>.To unsubscribe, E-mail to: <talk-leave@webdna.us>archives: http://mail.webdna.us/list/talk@webdna.usold archives: http://dev.webdna.us/TalkListArchive/Bug Reporting: http://forum.webdna.us/=eucabb.html?page=3Dtopics&category=3D288  

--=20Matthew A Perosi           =20SEO AnalystSenior Web Developer            =20Psi Prime, Inc.323 Union Blvd.Totowa, NJ 07512Pre-Sales: 888.872.0274Service:   973.413.8213Training:  973.413.8214Fax:       973.413.8217http:=//www.psiprime.com
--------------050107040303030307070706-- 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 (Matthew A Perosi 2010)
  4. Re: [WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows (William DeVaul 2010)
  5. Re: [WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows IIS 5.1 - Windows XP Pro Dev Box (Govinda 2010)
  6. Re: [WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows (William DeVaul 2010)
  7. Re: [WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows IIS 5.1 - Windows XP Pro Dev Box (Patrick McCormick 2008)
  8. [WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows IIS 5.1 - Windows XP Pro Dev Box ("Michael A. DeLorenzo" 2008)
This is a multi-part message in MIME format. --------------050107040303030307070706 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: quoted-printable Here's a thought. Are you working in a sandbox? On my servers I can't make a DB call to /var/www/html/sitename/data.db I would have to make the DB call to /sitename/data.db On the other hand, [shell] calls do use the full filesystem directory=20 structure. Matt William DeVaul wrote: > 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 = wrote: > =20 >> 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 [listfield= s] >> context. >> >> (??) >> >> -G >> >> On Apr 23, 2010, at 11:16 AM, William DeVaul wrote: >> >> =20 >>> 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 canno= t >>> 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 wr= ote: >>> =20 >>>> The first thing that comes to mind is to verify proper permissions o= n the >>>> db. >>>> Make sure that you [flushdatabases] first because changing permissio= ns >>>> 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 Design= er/ >>>> 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 >>>> >>>> >>>> >>>> >>>> >>>> =20 >>> --------------------------------------------------------- >>> 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&categ= ory=3D288 >>> =20 >> ------------ >> 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&catego= ry=3D288 >> >> =20 > --------------------------------------------------------- > 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&categor= y=3D288 > > > =20 --=20 Matthew A Perosi =20 SEO Analyst Senior Web Developer =20 Psi Prime, Inc. 323 Union Blvd. Totowa, NJ 07512 Pre-Sales: 888.872.0274 Service: 973.413.8213 Training: 973.413.8214 Fax: 973.413.8217 http://www.psiprime.com --------------050107040303030307070706 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Here's a thought.
Are you working in a sandbox?
On my servers I can't make a DB call to /var/www/html/sitename/data.db I would have to make the DB call to /sitename/data.db

On the other hand, [shell] calls do use the full filesystem directory structure.

Matt

William DeVaul wrote: 
Good point.  The flush and shell show that the perms sho=uld be OK.That was a test based on an earlier comment from Patrick.On Fri, Apr 23, 2010 at 2:30 PM, Govinda <govinda.webdnatalk@gm=ail.com> wrote:  
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.(??)-GOn 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]<div>=A0[listfields db=3D/var/www/html/sitename/data.db]=A0 [fieldname]=A0[/listfields]</div>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 thedatabase. =A0Failed even when I changed the file perms to 777. =A0I canno=tchange 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?BillOn Wed, Oct 15, 2008 at 11:12 AM, Patrick McCormick <pm@webdna.us> wrote=:      
The first thing that comes to mind is to verify pr=oper permissions on thedb.Make sure that you [flushdatabases] first because changing permissionswhenthe databases is loaded in RAM has no effect. You need to unload it,changethe permissions, then re-load it.PatOn Oct 15, 2008, at 10:06 AM, Michael A. DeLorenzo wrote:I=92m getting the following error:Fields in databasec:\inetpub\wwwroot\oldecarriage_live\dbs\oldecarriage.db:An unknown error occurred:DBErrorc:\inetpub\wwwroot\oldecarriage_live\dbs\oldecarriage.dbDatabase file could not be found or openedIt happens when I use this code from the 6.0 docs:[listdatabases]Fields in database [name]:<br>[ListFields db=3D[name]]Fieldname: [FieldName]<br>[/ListFields]<hr>[/ListDatabases]The funny thing is that the code above lists the system databasesperfectly.Also, this code works just fine if I want to list the fields from aspecified db:[ListFields db=3Doldecarriage.db][FieldName]<br>[/ListFields]Which leads me to believe there is something buggy with the[listdatabases]tag.Anyone else having the same problem?Michael A. DeLorenzoBroker - AssociateGeneral ManagerWeb Master / Systems Engineer/ Network Administrator/ Graphic Designer/Director of Advertising/ Director of Marketing/ Mr. Fix It/ ProblemSolver/Head of you name it I do it DepartmentOlde Carriage Realty, Inc.92 Charlotte St.St. Augustine, FL 32084Phone: 904-824-4500Mobile: 904-377-5582Fax: 904-824-6866Toll-Free: 800-555-6138Web: www.oldecarriage.com        
----------------------------------------------------=-----This message is sent to you because you are subscribed tothe mailing list <talk@webdna.us>.To unsubscribe, E-mail to: <talk-leave@webdna.us>archives: http://mail.webdna.us/list/talk@webdna.usold archives: http://dev.webdna.us/TalkListArchive/Bug Reporting: http://forum.webdna.us/=eucabb.html?page=3Dtopics&category=3D288      
------------Govindagovinda.webdnatalk@gmail.com---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list <talk@webdna.us>.To unsubscribe, E-mail to: <talk-leave@webdna.us>archives: http://mail.webdna.us/list/talk@webdna.usold archives: http://dev.webdna.us/TalkListArchive/Bug Reporting: http://forum.webdna.us/=eucabb.html?page=3Dtopics&category=3D288    
-------------------------------------------------=--------This message is sent to you because you are subscribed tothe mailing list <talk@webdna.us>.To unsubscribe, E-mail to: <talk-leave@webdna.us>archives: http://mail.webdna.us/list/talk@webdna.usold archives: http://dev.webdna.us/TalkListArchive/Bug Reporting: http://forum.webdna.us/=eucabb.html?page=3Dtopics&category=3D288  

--=20Matthew A Perosi           =20SEO AnalystSenior Web Developer            =20Psi Prime, Inc.323 Union Blvd.Totowa, NJ 07512Pre-Sales: 888.872.0274Service:   973.413.8213Training:  973.413.8214Fax:       973.413.8217http:=//www.psiprime.com
--------------050107040303030307070706-- Matthew A Perosi

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:

security (1997) RE: NewCart+Search with one click ? (1997) RE: [WebDNA] Reformatting database headers (2009) Bit off subject -- Faxing orders (1997) Problems with ^ could be solved with [REPLACE CHARACTERS] (1997) [convertchars] (2000) webcat NT (1998) how is this possible (2000) Signal Raised (1997) WebCat Contest Please Clarify (1998) Doing VALIDCARD right? (1998) Emailer (WebCat2) (1997) Exclude by date - multiple (1997) [WebDNA] Apple Server (2013) WebCatalog NT beta 18 now available (1997) Standalone Testing (1998) carts on MacOS X Server (2000) upgrading (1997) [WebDNA] Friday's.. WIP thread (2009) PROTECT PAGES (2002)