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
