[xwiki-users] XEM.war, XEM.war and Plugin Wiki Manager... getting confused
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.xarfile, 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) Thnaks, Antonio
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
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 <[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 [email protected] 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
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 <[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 [email protected] 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 [email protected] 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-... Sent from the XWiki- Users mailing list archive at Nabble.com.
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 ? Antonio 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 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 <[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 [email protected] 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 [email protected] 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-... Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________ users mailing list [email protected] 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
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 <[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 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 < [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 [email protected] 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 [email protected] 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-... Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________ users mailing list [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
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 <[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 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 < [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 [email protected] 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 [email protected] 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-... Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________ users mailing list [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] 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-... Sent from the XWiki- Users mailing list archive at Nabble.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 <[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 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 <[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 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 < [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 [email protected] 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 [email protected] 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-...
Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________ users mailing list [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] 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-... Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________ users mailing list [email protected] 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
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 <[email protected]>:
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 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 <[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 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 < [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 [email protected] 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 [email protected] 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-...
Sent from the XWiki- Users mailing list archive at Nabble.com<http://nabble.com/> .
_______________________________________________ users mailing list [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] 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-...
Sent from the XWiki- Users mailing list archive at Nabble.com<http://nabble.com/> .
_______________________________________________ users mailing list [email protected] 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
-- -- 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
Hi, This looks like an Application Manager plugin bug but I think it's fixed for the coming 1.0M3 (next week) version. Could you add this bug in http://jira.xwiki.org/jira/browse/XEM ? I will look at this tomorrow. Thanks 2007/12/29, Antonio Goncalves <[email protected]>:
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 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 <[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 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 (
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 < [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 [email protected] 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 [email protected] 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-...
Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________ users mailing list [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] 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-... Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________ users mailing list [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
Here it is : http://jira.xwiki.org/jira/browse/XEM-76 2008/1/3, Thomas Mortagne <[email protected]>:
Hi,
This looks like an Application Manager plugin bug but I think it's fixed for the coming 1.0M3 (next week) version. Could you add this bug in http://jira.xwiki.org/jira/browse/XEM ? I will look at this tomorrow.
Thanks
2007/12/29, Antonio Goncalves <[email protected]>:
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 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 <[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 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 < [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 > [email protected] > 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 [email protected] 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-...
Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________ users mailing list [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] 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-...
Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________ users mailing list [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne _______________________________________________ users mailing list [email protected] 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
I looked, I can't reproduce it with pre-M3 version. I think it was caused by http://jira.xwiki.org/jira/browse/XAAM-39. Thanks for your XEM beta test. 2008/1/3, Antonio Goncalves <[email protected]>:
Here it is : http://jira.xwiki.org/jira/browse/XEM-76
2008/1/3, Thomas Mortagne <[email protected]>:
Hi,
This looks like an Application Manager plugin bug but I think it's fixed for the coming 1.0M3 (next week) version. Could you add this bug in http://jira.xwiki.org/jira/browse/XEM ? I will look at this tomorrow.
Thanks
2007/12/29, Antonio Goncalves < [email protected]>:
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 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 < [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 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 < [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 >> [email protected] >> 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 > [email protected] > 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-...
Sent from the XWiki- Users mailing list archive at Nabble.com .
_______________________________________________ users mailing list [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] 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-...
Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________ users mailing list [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne _______________________________________________ users mailing list [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
participants (4)
-
Antonio Goncalves -
Benoit Hug -
Thomas Mortagne -
Vincent Massol