Still doesn't work but the exception is different. I've granted *.* so now the create database is made automatically, that's good. But when I point to my newly create virtual wiki, I get the following exception. Any idea it looks like this is an encoding error. From the database maybe ? What set of characters should be set in MySQL ? :
javax.servlet.ServletException 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) *cause mère* java.lang.NullPointerException com.xpn.xwiki.plugin.applicationmanager.ApplicationManager.updateApplicationsTranslation(ApplicationManager.java:326) com.xpn.xwiki.plugin.applicationmanager.ApplicationManager.notify(ApplicationManager.java:126) com.xpn.xwiki.notify.DocChangeRule.verify(DocChangeRule.java:46) com.xpn.xwiki.notify.XWikiNotificationManager.verify(XWikiNotificationManager.java:112) com.xpn.xwiki.XWiki.saveDocument(XWiki.java:960) com.xpn.xwiki.XWiki.saveDocument(XWiki.java:935) 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) com.xpn.xwiki.plugin.applicationmanager.ApplicationManager.notify(ApplicationManager.java:119) com.xpn.xwiki.notify.DocChangeRule.verify(DocChangeRule.java:46) com.xpn.xwiki.notify.XWikiNotificationManager.verify(XWikiNotificationManager.java:112) com.xpn.xwiki.XWiki.saveDocument(XWiki.java:960) com.xpn.xwiki.XWiki.saveDocument(XWiki.java:935) 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) com.xpn.xwiki.plugin.applicationmanager.ApplicationManager.notify(ApplicationManager.java:119) com.xpn.xwiki.notify.DocChangeRule.verify(DocChangeRule.java:46) com.xpn.xwiki.notify.XWikiNotificationManager.verify(XWikiNotificationManager.java:112) com.xpn.xwiki.XWiki.saveDocument(XWiki.java:960) com.xpn.xwiki.XWiki.saveDocument(XWiki.java:935) 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) com.xpn.xwiki.plugin.applicationmanager.ApplicationManager.notify(ApplicationManager.java:119) com.xpn.xwiki.notify.DocChangeRule.verify(DocChangeRule.java:46) com.xpn.xwiki.notify.XWikiNotificationManager.verify(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) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) 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) 2007/12/28, Benoit Hug <[EMAIL PROTECTED]>: > > > 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 > >> [EMAIL PROTECTED] 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 [EMAIL PROTECTED] identified by 'xwiki' > > > > Then you're good to go. > > > > Thanks > > -Vincent > > > >> 2007/12/28, Benoit Hug <[EMAIL PROTECTED]>: > >> > >> 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 [EMAIL PROTECTED] identified by > >> 'sales' > >> grant all privileges on xwiki.* to [EMAIL PROTECTED] 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 > >> > [EMAIL PROTECTED] 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 > >> > Manager > >> > should do these things automatically and I think I'm doing to much > >> hand > >> > work. I'm using MySQL 5.0.45. Any idea ? > >> > > >> > Thanks, > >> > > >> > Antonio > >> > > >> > 2007/12/26, Vincent Massol < [EMAIL PROTECTED]>: > >> > > >> >> 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 > >> when > >> >> > you already have an instance of xwiki running and you want to add > >> >> > the management capabilities ? Is it when the Wiki Manager 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@xwiki.org > >> >> http://lists.xwiki.org/mailman/listinfo/users > >> >> > >> > > >> > > >> > > >> > -- > >> > -- > >> > Antonio Goncalves ([EMAIL PROTECTED]) > >> > 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@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-confused-tp14504548p14525535.html > >> Sent from the XWiki- Users mailing list archive at Nabble.com. > >> > >> _______________________________________________ > >> users mailing list > >> users@xwiki.org > >> http://lists.xwiki.org/mailman/listinfo/users > >> > >> > >> > >> -- > >> -- > >> Antonio Goncalves ([EMAIL PROTECTED]) > >> 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@xwiki.org > >> http://lists.xwiki.org/mailman/listinfo/users > > > > > > _______________________________________________ > > users mailing list > > users@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-confused-tp14504548p14528511.html > Sent from the XWiki- Users mailing list archive at Nabble.com. > > _______________________________________________ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > -- -- Antonio Goncalves ([EMAIL PROTECTED]) 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@xwiki.org http://lists.xwiki.org/mailman/listinfo/users