Re: [xwiki-users] Can't find [/WEB-INF/hibernate.cfg.xml] for hibernate configuration

On Mon, Mar 5, 2012 at 8:36 AM, Thomas Mortagne <thomas.mortagne(a)xwiki.com> wrote: > On Sun, Mar 4, 2012 at 2:08 PM, Richard Rafalski > <mail(a)richard-rafalski.de> wrote: >> >> Am 03.03.2012 13:07, schrieb Thomas Mortagne: >>> On Sat, Mar 3, 2012 at 11:56 AM, Thomas Mortagne >>> <thomas.mortagne(a)xwiki.com> wrote: >>>> On Sat, Mar 3, 2012 at 12:46 AM, Richard Rafalski >>>> <mail(a)richard-rafalski.de> wrote: >>>>> >>>>> >>>>> Am 02.03.2012 19:47, schrieb Thomas Mortagne: >>>>>> On Fri, Mar 2, 2012 at 7:36 PM, Thomas Mortagne >>>>>> <thomas.mortagne(a)xwiki.com> wrote: >>>>>>> On Fri, Mar 2, 2012 at 7:34 PM, Thomas Mortagne >>>>>>> <thomas.mortagne(a)xwiki.com> wrote: >>>>>>>> On Fri, Mar 2, 2012 at 5:33 PM, Richard Rafalski >>>>>>>> <mail(a)richard-rafalski.de> wrote: >>>>>>>>> Hi Thomas, >>>>>>>>> >>>>>>>>> thank you for the last modifications on the deb packages. >>>>>>>>> >>>>>>>>> I've installed the package xwiki-enterprise-tomcat7-pgsql. The >>>>>>>>> installation ran without probelms. >>>>>>>>> Great! >>>>>>>>> >>>>>>>>> But I'am sorry to inform you that after pointing the webbrowser to >>>>>>>>> http://xwikipg:8080/xwiki/ I got the well known >>>>>>>>> "Can't find [/WEB-INF/hibernate.cfg.xml] for hibernate configuration" >>>>>>>>> message. >>>>>>>>> >>>>>>>>> A quik look into /etc/xwiki showed >>>>>>>>> -rw-r----- 1 root root 8.1K Mar  2 16:08 hibernate.cfg.xml >>>>>>>>> >>>>>>>>> Changing group from root to tomcat7 and restarting the tomcat7 service >>>>>>>>> solved the problem. >>>>>>>>> >>>>>>>>> Maybe there is still a problem with setting group/rights on >>>>>>>>> hibernate.cfg.xml. I'am not shure. >>>>>>>> >>>>>>>> That's weird I was sure I changed the right for it to be 644, will >>>>>>>> checking this, maybe I modified it only in the mysql package. Should >>>>>>>> be quickly fixed. >>>>>>> >>>>>>> I did fixed it but forgot to backport it on 3.5 actually... >>>>>> >>>>>> Should be better now. Thanks for the report ! >>>>> I think it is very dangerous to make hibernate.cfg.xml readable for >>>>> evryone. If you can not avoid it you should mention this fact in the >>>>> installation documentation. >>>> >>>> I can probably change the owner to tomcat and remove the readright for >>>> all in the xwiki-enterprise-tomcat*-pgsql and >>>> xwiki-enterprise-tomcat*-mysql (my problem was that the install script >>>> does not know the aplication server in xwiki-enterprise-pgsql-common >>>> and xwiki-enterprise-mysql-common). >> >> Yes I see. >> >>> >>> Done, the right of the hibernate conf file is now 640 and the whole >>> /etc/xwiki folder has the proper tomcat5/tomcat6/tomcat7 user as >>> owner. >>> >> >> While installing the new package xwiki-enterprise-tomcat7-pgsql I ran >> into this regression bug >> >> dpkg: error processing >> /var/cache/apt/archives/xwiki-enterprise-common_3.5_all.deb (--unpack): >>  name of conffile (starting `/etc/xwiki/web.xml') is too long (>1000 >> characters) >> ... >> dpkg: error processing >> /var/cache/apt/archives/xwiki-enterprise-tomcat-common_3.5_all.deb >> (--unpack): >>  name of conffile (starting `/etc/xwiki/xwiki-tomcat.xml') is too long >> (>1000 characters) > > I probably forgot to re-apply the ending new line (restarted from the > tag). Checking. Should ok now.

> >> >>> Does this sounds right to you ? >> >> From a technical point of view this should work. >> >> But what are you thinking about the idea to introduce a user and group >> xwiki, set the needed rights for the user xwiki and group xwiki in the >> packages xwiki-enterprise-common and xwiki-enterprise-<data base>-common >> (so the install script does not to have to know the application server) >> and let the package xwiki-enterprise-<application server>-common add the >> user of the application server to the group xwiki (e.g. addgroup tomcat7 >> xwiki). >> >> Adding and removing users to or form the group xwiki instead of >> fiddleling around with file permissions will make the live of the system >> administrator more convenient (e.g. if one want to try out a different >> application server). >> >> But i think more important is the fact that a group based right >> management will lead to more flexibility and so to fewer future preblems. >> >> Your opinion? > > Sounds like a good idea. Could you create a jira issue for it ? I will > not have time to work on it right now.