Re: [xwiki-users] XEM.war, XEM.war and Plugin Wiki Manager... getting confused

Hi, This looks like an Application Manager plugin bug but I think it's fixed for the coming 1.0M3 (next week) version. Could you add this bug in http://jira.xwiki.org/jira/browse/XEM ? I will look at this tomorrow. Thanks 2007/12/29, Antonio Goncalves &lt;antonio.mailing(a)gmail.com&gt;om>: now to of RequestProcessor.java:535) RequestProcessor.java:433) :236) SetCharacterEncodingFilter.java:117) com.xpn.xwiki.plugin.applicationmanager.ApplicationManager.updateApplicationsTranslation (ApplicationManager.java:326) ApplicationManager.java:126) XWikiNotificationManager.java:112) com.xpn.xwiki.plugin.applicationmanager.core.doc.objects.classes.AbstractSuperClass.checkClassTemplateDocument (AbstractSuperClass.java:530) com.xpn.xwiki.plugin.applicationmanager.core.doc.objects.classes.AbstractSuperClass.check (AbstractSuperClass.java:370) com.xpn.xwiki.plugin.applicationmanager.doc.XWikiApplicationClass.getInstance (XWikiApplicationClass.java:223) ApplicationManager.java:119) XWikiNotificationManager.java:112) com.xpn.xwiki.plugin.applicationmanager.core.doc.objects.classes.AbstractSuperClass.checkClassSheetDocument (AbstractSuperClass.java:477) com.xpn.xwiki.plugin.applicationmanager.core.doc.objects.classes.AbstractSuperClass.check (AbstractSuperClass.java:369) com.xpn.xwiki.plugin.applicationmanager.doc.XWikiApplicationClass.getInstance (XWikiApplicationClass.java:223) ApplicationManager.java:119) XWikiNotificationManager.java:112) com.xpn.xwiki.plugin.applicationmanager.core.doc.objects.classes.AbstractSuperClass.checkClassDocument (AbstractSuperClass.java:404) com.xpn.xwiki.plugin.applicationmanager.core.doc.objects.classes.AbstractSuperClass.check (AbstractSuperClass.java:368) com.xpn.xwiki.plugin.applicationmanager.doc.XWikiApplicationClass.getInstance (XWikiApplicationClass.java:223) ApplicationManager.java:119) XWikiNotificationManager.java:112) > com.xpn.xwiki.XWiki.saveDocument(XWiki.java:960) > com.xpn.xwiki.XWiki.saveDocument(XWiki.java:935) > com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:2391) > com.xpn.xwiki.XWiki.updateDatabase(XWiki.java:365) > com.xpn.xwiki.XWiki.updateDatabase(XWiki.java:344) > com.xpn.xwiki.XWiki.getXWiki(XWiki.java:460) > com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94) RequestProcessor.java:431) :236) SetCharacterEncodingFilter.java:117) > 2007/12/28, Benoit Hug &lt;benoit.hug(a)eipfr.com&gt;om>: > > > yes, before xem i did it manualy > > create database sales; > > grant all privileges ....; > > > true, now xem does the 'create database ' + some other things for the wiki > > farm > > and I does the grants myself. > > > thanks Vincent for the *.* ! > > > Benoit > > > > > > vmassol wrote: > > > > > > > On Dec 28, 2007, at 5:26 PM, Antonio Goncalves wrote: > > > > >> Humm, doesn't work for me. Benoit, when you create a virtual wiki > > >> (let's say sales), do you create a new sales database ? I wonder if > > >> all the virtual wikis store their data into the xwiki database > > >> (sales stores its data into xwiki DB) or if each one has its own > > >> database (sales stores its data into sales DB) ? > > >> > > >> When you grant the sales user (grant all privileges on sales.* to > > >> sales@localhost identified by 'sales') you are assuming that the > > >> database name is sales and the password is sales too. How does XWiki > > >> handles that ? > > >> > > >> But I really thought that XWiki Manager would handles all that > > >> automatically. Am I wrong ? > > > > > The Wiki Manager plugin does automatically create a new database for > > > the new wiki. However we don't automatically set the privileges (I > > > guess that's because there might not be any standard way of doing this > > > in Hibernate). So what you have to do (once) is: > > > > > grant all privileges on *.* to xwiki@localhost identified by 'xwiki' > > > > > Then you're good to go. > > > > > Thanks > > > -Vincent > > > > >> 2007/12/28, Benoit Hug &lt;benoit.hug(a)eipfr.com&gt;om>: > > >> > > >> Hi Antonio, > > >> > > >> I have the same symptoms. (i have xem 1.0 m1 installed) > > >> and on the log there is a permission problem rc > > >> > > >> So for each new vitual wiki i create, i do the following, (it works) : > > >> grant all privileges on sales.* to sales@localhost identified by > > >> 'sales' > > >> grant all privileges on xwiki.* to xwiki@localhost identified by > > >> 'xwiki' > > >> > > >> (my own problem is that mysql is not my well known database and i > > >> had never > > >> get time to loock in) > > >> > > >> > > >> Benoit > > >> > > >> > > >> > > >> > > >> Antonio Goncalves wrote: > > >> > > >> > Thank you Vincent, I've tried both solutions and it works fine. > > >> > > >> > I'm just confused now about how to create new wikis. When I use > > >> XEM ( > > >> > http://localhost:8080/xwiki/bin/view/WikiManager/ ) > and I click on > > >> "create > > >> > a > > >> > new wiki", no problem. For example, if I create a wiki called > > >> "*sales*", I > > >> > have a new link showing * sales.localdomain.com*. To cheat, I > > >> change my > > >> > hosts > > >> > file (on Windows Vista) and map the * sales.localdomain.com* to > > >> 127.0.0.1. > > >> > But after, when I click on * sales.localdomain.c*om I get an > > >> exception > > >> > that my user xwiki cannot access the database *sales* : > > >> > > >> > > >> > javax.servlet.ServletException: Error number 3202 in 3: Exception > > >> > while reading document XWiki.XWikiPreferences > > >> > Wrapped Exception: Error number 3301 in 3: Exception while switching > > >> > to database sales > > >> > Wrapped Exception: Access denied for user 'xwiki'@'localhost' to > > >> > database '*sales*' > > >> > > >> > > >> org > > >> .apache > > >> .struts > > >> > .action.RequestProcessor.processException(RequestProcessor.java > :535) > > >> > > >> > > >> org > > >> .apache > > >> .struts > > >> > .action.RequestProcessor.processActionPerform(RequestProcessor.java: > > >> 433) > > >> > > >> > > >> org > > >> > .apache.struts.action.RequestProcessor.process(RequestProcessor.java: > > >> 236) > > >> > org.apache.struts.action.ActionServlet.process > > >> (ActionServlet.java:1196) > > >> > > >> > org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) > > >> > javax.servlet.http.HttpServlet.service(HttpServlet.java:690) > > >> > javax.servlet.http.HttpServlet.service > (HttpServlet.java:803) > > >> > > >> > > >> com > > >> .xpn > > >> .xwiki > > >> .web > > >> > .SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java: > > >> 117) > > >> > > >> > > >> > So what I did after is create a new database *sales* and give the > > >> user > > >> > xwiki > > >> > all the priviledges : > > >> > > >> > mysql --user=root --execute="create database *sales*" > > >> > mysql --user=root --execute="grant all privileges on xwiki.* to > > >> > xwiki@localhost identified by '*sales*'" > > >> > > >> > But that doesn't work either. When I go to > > >> *sales.localdomain.com*here > > >> > comes a new exception : > > >> > > >> > > >> > javax.servlet.ServletException: Error number 3 in 0: Could not > > >> > initialize main XWiki context > > >> > Wrapped Exception: Error number 3202 in 3: Exception while reading > > >> > document XWiki.XWikiPreferences > > >> > Wrapped Exception: Could not create a DBCP pool > > >> > > >> > > >> org > > >> .apache > > >> .struts > > >> > .action.RequestProcessor.processException(RequestProcessor.java:535) > > >> > > >> > > >> org > > >> .apache > > >> .struts > > >> > .action.RequestProcessor.processActionPerform(RequestProcessor.java: > > >> 433) > > >> > > >> > org.apache.struts.action.RequestProcessor.process > > >> (RequestProcessor.java:236) > > >> > > >> > org.apache.struts.action.ActionServlet.process(ActionServlet.java: > > >> 1196) > > >> > > >> > org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) > > >> > javax.servlet.http.HttpServlet.service > (HttpServlet.java:690) > > >> > javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > > >> > > >> > > >> com > > >> .xpn > > >> .xwiki > > >> .web > > >> > .SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java: > > >> 117) > > >> > > >> > I think I'm doing something wrong because in my understanding XWiki much > > >> hand > > >> > work. I'm using MySQL 5.0.45. Any idea ? > > >> > > >> > Thanks, > > >> > > >> > Antonio > > >> > > >> > 2007/12/26, Vincent Massol < vincent(a)massol.net&gt;gt;: > > >> > > >> >> Hi Antonio, > > >> >> > > >> >> On Dec 26, 2007, at 6:51 PM, Antonio Goncalves wrote: > > >> >> > > >> >> > Hi, > > >> >> > > >> >> > I'm having a look at virtual wikis and I'm a bit confused with > > >> all > > >> >> > the installation possibilities. In my understanding, XEM is an > > >> easy > > >> >> > way to manage several XWiki instances on one server. Starting > > >> from a > > >> >> > fresh install you would download the XEM.war file into your > > >> tomcat, > > >> >> > import the XEM.xar file, and it should work. But what do you do add plugin > > >> >> > comes along ? Am I right in saying : > > >> >> > > >> >> > * fresh install : XEM.war and XEM.xar > > >> >> > * xwiki already installed ( xwiki.war) : use the Wiki Manager > > >> plugin > > >> >> > and forget about XEM (war and xar) > > >> >> > > >> >> Yes, that's almost correct. We need these instructions on the > > >> >> xwiki.org web site. To transform XE into a XEM install do the > > >> following: > > >> >> > > >> >> * install the Application Manager plugin (JAR) + the Application > > >> >> Manager application (XAR) > > >> >> * install the Wiki Manager plugin (JAR) + the Wiki Manager > > >> application > > >> >> (XAR) > > >> >> * modify xwiki.cfg to set xwiki.virtual to 1 > > >> >> > > >> >> Thanks > > >> >> -Vincent > > >> >> > > >> >> _______________________________________________ > > >> >> users mailing list > > >> >> users(a)xwiki.org > > >> >> http://lists.xwiki.org/mailman/listinfo/users > > >> >> > > >> > > >> > > >> > > >> > -- > > >> > -- > > >> > Antonio Goncalves (antonio.goncalves(a)gmail.com) > > >> > Software architect > > >> > > >> > Paris JUG leader : www.parisjug.org > > >> > Web site : www.antoniogoncalves.org > > >> > Blog: jroller.com/agoncal > > >> > LinkedIn: www.linkedin.com/in/agoncal > > >> > > >> > _______________________________________________ > > >> > users mailing list > > >> > users(a)xwiki.org > > >> > http://lists.xwiki.org/mailman/listinfo/users > > >> > > >> > > >> > > >> -- > > >> View this message in context: > > >> http://www.nabble.com/XEM.war%2C-XEM.war-and-Plugin-Wiki-Manager...-getting… > > >> Sent from the XWiki- Users mailing list archive at Nabble.com. > > >> > > >> _______________________________________________ > > >> users mailing list > > >> users(a)xwiki.org > > >> http://lists.xwiki.org/mailman/listinfo/users > > >> > > >> > > >> > > >> -- > > >> -- > > >> Antonio Goncalves (antonio.goncalves(a)gmail.com ) > > >> Software architect > > >> > > >> Paris JUG leader : www.parisjug.org > > >> Web site : www.antoniogoncalves.org > > >> Blog: jroller.com/agoncal > > >> LinkedIn: www.linkedin.com/in/agoncal > > >> _______________________________________________ > > >> users mailing list > > >> users(a)xwiki.org > > >> http://lists.xwiki.org/mailman/listinfo/users > > > > > > > _______________________________________________ > > > users mailing list > > > users(a)xwiki.org > > > http://lists.xwiki.org/mailman/listinfo/users > > > > > > > -- > > View this message in context: http://www.nabble.com/XEM.war%2C-XEM.war-and-Plugin-Wiki-Manager...-getting… > > Sent from the XWiki- Users mailing list archive at Nabble.com. > > > _______________________________________________ > > users mailing list > > users(a)xwiki.org > > http://lists.xwiki.org/mailman/listinfo/users > > -- > -- > Antonio Goncalves ( antonio.goncalves(a)gmail.com) > Software architect > Paris JUG leader : www.parisjug.org > Web site : www.antoniogoncalves.org > Blog: jroller.com/agoncal > LinkedIn: www.linkedin.com/in/agoncal > _______________________________________________ > users mailing list > users(a)xwiki.org > http://lists.xwiki.org/mailman/listinfo/users -- Thomas Mortagne _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users