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(a)eipfr.com>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
> > 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(a)massol.net>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
> 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(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:
>
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
.
_______________________________________________
users mailing list
users(a)xwiki.org