Humm, that might be a bug because meanwhile I was having a look at MySQL documentation, I clicked a second time of my virtual wiki link, and it works. So now, each time I create a new virtual wiki, I go to its home page a first time and get the encoding exception, I click a second time and it works. I'm using :
 
XEM 1.0_M2
JDK 1.5.0_14
MySQL Server 5.0.45
Driver JDBC Connector/J 5.1.5
Tomcat 5.5.25

Antonio

2007/12/29, Antonio Goncalves <antonio.mailing@gmail.com>:
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 <benoit.hug@eipfr.com>:

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 <benoit.hug@eipfr.com>:
>>
>> 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
>> > 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 < vincent@massol.net >:
>> >
>> >> 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 ( antonio.goncalves@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@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 (antonio.goncalves@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@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 ( antonio.goncalves@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



--
--
Antonio Goncalves (antonio.goncalves@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