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