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 = 29075
interpreted = N
texte = 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.dband two sub-sites referring to that database with sym links:/stores/store1/DB/products.db/stores/store1/DB/products.dbwhere 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>>>> Technical Support **********************************>> Smith Micro, Internet Solutions Div | eCommerce (WebCatalog)>> 16855 West Bernardo Drive, #380 | ------------------------->> San Diego, CA 92127 | Software & Site Development>> WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com>> Fax: (858) 675-0372 *********************************>>>> -----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>> >>>> ------------------------------------------------------------->> 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 >>>>>------------------------------------------------------------->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 >-------------------------------------------------------------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:
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.dband two sub-sites referring to that database with sym links:/stores/store1/DB/products.db/stores/store1/DB/products.dbwhere 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>>>> Technical Support **********************************>> Smith Micro, Internet Solutions Div | eCommerce (WebCatalog)>> 16855 West Bernardo Drive, #380 | ------------------------->> San Diego, CA 92127 | Software & Site Development>> WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com>> Fax: (858) 675-0372 *********************************>>>> -----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>> >>>> ------------------------------------------------------------->> 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 >>>>>------------------------------------------------------------->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 >-------------------------------------------------------------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
Clement Ross
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:
page redirect in webDNA (1997)
Stop the madness. (1997)
Database Options (1997)
select multiple (1997)
Showif ~ Netscape : Showif ~ MSIE (2001)
Enhancement Request for WebCatalog-NT (1996)
DataBaseHelper Flawed (1997)
RE: Formulas.db + Users.db (1997)
[carts] and databases (1997)
international time (1997)
Press Release hit the NewsWire!!! (1997)
Another question about credit cards (1997)
WebCatalog2 Feature Feedback (1996)
Loops and [index] (1998)
Thanks Grant (1997)
[body_include] (2001)
[WebDNA] problems with [protect] on new OSX lion install (2012)
WebCat2 beta 11 - new prefs ... (1997)
Deleting Orders (1997)
Location of Browser Info.txt file (1997)