Re: Unix webcat perms & multiple versions of same db in cacheissue
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 29197
interpreted = N
texte = SM webcat support- Is this what you would say? Can you confirm what Clem is saying and also add anything else relevent please! Is there anything else that a total unix newbie should be aware of to make SURE this issue never arises? I don't mean to beat a dead horse... I just don't know enough about this issue to know when I have my complete answer.-JohnClement Ross wrote:> Hello John, > > Just to be on the safe side, products.db should probably be owned by > nobody:web. > > Another thing, do not use sym links to refer to you databases. > > If you have: > > /stores/db/products.db > > and two sub-sites referring to that database with sym links: > > /stores/store1/DB/products.db > /stores/store1/DB/products.db > > where DB->/stores/db/ > > WebCat will load products.db twice because it does not resolve the > sym link to the original directory and takes the links at face value. > > Clem. > > At 13:46 3/15/00, John Butler wrote: > >Can we discuss this further here? I tried the support phone but I > >always get a > >machine. If I was well learn-ed on permissions then I would feel > >competent to leave a > >detailed message... but actually I need to ask some real basic Qs first: > > > >I am not the server admin (just a developer) so I don't know what > >perms are set on > >webcat itself (if that even makes sense or applies) > > > >the root of my site is set like this (linux/RedHat)- > >drwxr-xr-x 11 johnbutl web 4096 Mar 10 13:37 www.domain.com > > > >inside the site's root we find: > >-rw-r--r-- 1 johnbutl web 4527 Mar 5 11:38 > >MostOfTheTemplates.tpl (how most > >of the pages are set) > >drwxrwxrwx 3 nobody web 1024 Mar 13 23:29 WriteHere > >(where I keep the > >db's that webcat manipulates) > >drwxrwx--- 2 nobody web 5120 Mar 15 13:15 ShoppingCarts > >(same with > >Orders directory) > > > >inside the WriteHere directory we find: > >-rwxrwxrwx 1 johnbutl web 58764 Mar 13 23:29 products.db > >(this is how all the > >db's that webcat manipulates are set) (This products.db is the one > >I previously had > >the issue arise with - where there were at least 2 versions in > >webcat's cache being > >served up alternately.) > > > >So does this look like a setup that is asking for that issue to > >arise? Should it be > >different? If you say it should be changed could you mention > >security issues and any > >other concerns that apply? The system admin and I played with the > >perms until we could > >append as well as delete records from a db, while also allowing me > >to ftp remotely, > >while allowing the pages to be served up at all in a remote browser... > > > >Thanks! > > > >-John > > > >WebDNA Support wrote: > > > >> If WebCatalog is not running with permission nobody then it is possible > >> for more than > >> one Webcatalog Parent Process to run and manipulating databases. On RED HAT > >> WebCatalog spawns one parent process and two children processes, so if you > >> see more than > >> three processes then you are in trouble (you will always see multiples of 3 > >> processes for WebCatalog under RED HAT) > >> > >> You can always call us at the number below for off list help > >> > >> -----Original Message----- > >> From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > >> Behalf Of John Butler > >> Sent: Tuesday, March 14, 2000 8:55 AM > >> To: WebCatalog Talk > >> Subject: Unix webcat perms & multiple versions of same db in cache issue > >> > >> John or Sam or ________? > >> (please direct to the person who posted yesterday on the talklist about > >> webcat's having 2 versions of the same db in cache problem due to > >> permissions improperly set) > >> > >> Hi . :-) I am the guy who had that problem once but was NOT the one > >> who you apparently helped offlist to solve this. I posted yesterday > >> saying I would ask for your permissions insight if it ever happened to > >> me again, but why wait?! Please tell me what you have discovered > >> about the possibility of unix (Linux only?) webcat holding 2+ versions > >> of the same db in cache because of some improper permissions. I worked > > > with the system admin to get the perms set the best we could figure out > >> to make webcat work and provide as much security as possible... but > >> maybe we have not done best?. Please share!! > >> > >> -John > >> ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
SM webcat support- Is this what you would say? Can you confirm what Clem is saying and also add anything else relevent please! Is there anything else that a total unix newbie should be aware of to make SURE this issue never arises? I don't mean to beat a dead horse... I just don't know enough about this issue to know when I have my complete answer.-JohnClement Ross wrote:> Hello John, > > Just to be on the safe side, products.db should probably be owned by > nobody:web. > > Another thing, do not use sym links to refer to you databases. > > If you have: > > /stores/db/products.db > > and two sub-sites referring to that database with sym links: > > /stores/store1/DB/products.db > /stores/store1/DB/products.db > > where DB->/stores/db/ > > WebCat will load products.db twice because it does not resolve the > sym link to the original directory and takes the links at face value. > > Clem. > > At 13:46 3/15/00, John Butler wrote: > >Can we discuss this further here? I tried the support phone but I > >always get a > >machine. If I was well learn-ed on permissions then I would feel > >competent to leave a > >detailed message... but actually I need to ask some real basic Qs first: > > > >I am not the server admin (just a developer) so I don't know what > >perms are set on > >webcat itself (if that even makes sense or applies) > > > >the root of my site is set like this (linux/RedHat)- > >drwxr-xr-x 11 johnbutl web 4096 Mar 10 13:37 www.domain.com > > > >inside the site's root we find: > >-rw-r--r-- 1 johnbutl web 4527 Mar 5 11:38 > >MostOfTheTemplates.tpl (how most > >of the pages are set) > >drwxrwxrwx 3 nobody web 1024 Mar 13 23:29 WriteHere > >(where I keep the > >db's that webcat manipulates) > >drwxrwx--- 2 nobody web 5120 Mar 15 13:15 ShoppingCarts > >(same with > >Orders directory) > > > >inside the WriteHere directory we find: > >-rwxrwxrwx 1 johnbutl web 58764 Mar 13 23:29 products.db > >(this is how all the > >db's that webcat manipulates are set) (This products.db is the one > >I previously had > >the issue arise with - where there were at least 2 versions in > >webcat's cache being > >served up alternately.) > > > >So does this look like a setup that is asking for that issue to > >arise? Should it be > >different? If you say it should be changed could you mention > >security issues and any > >other concerns that apply? The system admin and I played with the > >perms until we could > >append as well as delete records from a db, while also allowing me > >to ftp remotely, > >while allowing the pages to be served up at all in a remote browser... > > > >Thanks! > > > >-John > > > >WebDNA Support wrote: > > > >> If WebCatalog is not running with permission nobody then it is possible > >> for more than > >> one Webcatalog Parent Process to run and manipulating databases. On RED HAT > >> WebCatalog spawns one parent process and two children processes, so if you > >> see more than > >> three processes then you are in trouble (you will always see multiples of 3 > >> processes for WebCatalog under RED HAT) > >> > >> You can always call us at the number below for off list help > >> > >> -----Original Message----- > >> From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > >> Behalf Of John Butler > >> Sent: Tuesday, March 14, 2000 8:55 AM > >> To: WebCatalog Talk > >> Subject: Unix webcat perms & multiple versions of same db in cache issue > >> > >> John or Sam or ________? > >> (please direct to the person who posted yesterday on the talklist about > >> webcat's having 2 versions of the same db in cache problem due to > >> permissions improperly set) > >> > >> Hi . :-) I am the guy who had that problem once but was NOT the one > >> who you apparently helped offlist to solve this. I posted yesterday > >> saying I would ask for your permissions insight if it ever happened to > >> me again, but why wait?! Please tell me what you have discovered > >> about the possibility of unix (Linux only?) webcat holding 2+ versions > >> of the same db in cache because of some improper permissions. I worked > > > with the system admin to get the perms set the best we could figure out > >> to make webcat work and provide as much security as possible... but > >> maybe we have not done best?. Please share!! > >> > >> -John > >> ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
John Butler
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:
WebCat editing, SiteGuard & SiteEdit (1997)
Country & Ship-to address & other fields ? (1997)
how does [middle] work? (1998)
Re:quit command on NT (1997)
[SHOWNEXT] Examples (1997)
(2006)
template includes encrypted template (1999)
target=_blank and form variables (1997)
[WriteFile] problems (1997)
[isfile] ? (1997)
WebDNA Payment Alternatives (2003)
WebCat2 - [SendNews] (1997)
Not really WebCat- (1997)
Different Email recipients? (1998)
Sendmail and textarea (1998)
Size limit for tmpl editor ? (1997)
Multiple security dbs (1997)
Permissions (2002)
New Command prefs ... (1997)
Redirect (2003)