[xwiki-users] Another installation problem....
Hi everyone, I'm new on xwiki, never heard of it before but here in the company they want to give it a try. I've been searching a lot now about this error and I think mine is quite particular from what I read and my conf. I followed this steps in order to complete the xwiki installation. 1) Copy the xwiki.war into the webapps folder,inside a new folder called xwiki 2) Copy the mysql driver (mysql-connector-java-5.1.9.jar) into $TOMCAT_HOME/webapps/xwiki/WEB_INF/lib 3) Edit the hibernate.cfg.xml file to use the mysql database 4) Then opened Mozilla at http://myaddres:9191/xwiki/ I get the following error pointing to hibernate.cfg.xml from what I see javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3202 in 3: Exception while reading document [name = [XWikiPreferences], type = [DOCUMENT], parent = [name = [XWiki], type = [SPACE], parent = [name = [xwiki], type = [WIKI], parent = [null]]]] Wrapped Exception: Could not create a DBCP pool. There is an error in the hibernate configuration file, please review it. 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:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144) com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) causa raíz com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3202 in 3: Exception while reading document [name = [XWikiPreferences], type = [DOCUMENT], parent = [name = [XWiki], type = [SPACE], parent = [name = [xwiki], type = [WIKI], parent = [null]]]] Wrapped Exception: Could not create a DBCP pool. There is an error in the hibernate configuration file, please review it. com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:417) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:486) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) 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:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144) com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) Heres the mysql configuration part.. <property name="connection.url">jdbc:mysql://localhost/xwiki</property> <property name="connection.username"></property> <property name="connection.password"></property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> Then why my case is particular... here's why. The server has XAMMP installed (PHP, MySQL, Apache) configured with another application, so I assume that I dont need to install MySQL since it's working now across XAMMP, and the process mysqld is running (we are using Linux CentOS, based on Red Hat), so we are not sure what's next about this problem. Any help would be appreciated, thanks in advance. -- View this message in context: http://xwiki.475771.n2.nabble.com/Another-installation-problem-tp7580408.htm... Sent from the XWiki- Users mailing list archive at Nabble.com.
Hello, Are you sure you commented out the "Configuration for the Defaut Database" part in the hibernate.xml.cfg file, after uncommenting the MySQL part? After that, try to connect to mysql with the same creds you used in the hibernate file (in command line). So connect with this user and try to create the 'xwiki' DB if it doesn't exist yet. Good Luck! Guillaume Fenollar XWiki SysAdmin 2012/7/17 raav2012 <[email protected]>
Hi everyone,
I'm new on xwiki, never heard of it before but here in the company they want to give it a try. I've been searching a lot now about this error and I think mine is quite particular from what I read and my conf.
I followed this steps in order to complete the xwiki installation. 1) Copy the xwiki.war into the webapps folder,inside a new folder called xwiki 2) Copy the mysql driver (mysql-connector-java-5.1.9.jar) into $TOMCAT_HOME/webapps/xwiki/WEB_INF/lib 3) Edit the hibernate.cfg.xml file to use the mysql database 4) Then opened Mozilla at http://myaddres:9191/xwiki/
I get the following error pointing to hibernate.cfg.xml from what I see
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3202 in 3: Exception while reading document [name = [XWikiPreferences], type = [DOCUMENT], parent = [name = [XWiki], type = [SPACE], parent = [name = [xwiki], type = [WIKI], parent = [null]]]] Wrapped Exception: Could not create a DBCP pool. There is an error in the hibernate configuration file, please review it.
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:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144)
com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66)
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
causa raíz
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3202 in 3: Exception while reading document [name = [XWikiPreferences], type = [DOCUMENT], parent = [name = [XWiki], type = [SPACE], parent = [name = [xwiki], type = [WIKI], parent = [null]]]] Wrapped Exception: Could not create a DBCP pool. There is an error in the hibernate configuration file, please review it. com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:417) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:486) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
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:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144)
com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66)
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
Heres the mysql configuration part..
<property name="connection.url">jdbc:mysql://localhost/xwiki</property> <property name="connection.username"></property> <property name="connection.password"></property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property
name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/>
Then why my case is particular... here's why.
The server has XAMMP installed (PHP, MySQL, Apache) configured with another application, so I assume that I dont need to install MySQL since it's working now across XAMMP, and the process mysqld is running (we are using Linux CentOS, based on Red Hat), so we are not sure what's next about this problem.
Any help would be appreciated, thanks in advance.
-- View this message in context: http://xwiki.475771.n2.nabble.com/Another-installation-problem-tp7580408.htm... Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Hi Guillaume, thanks for the reply Yeah that part is commented, here's a screenshot of that part I was thinkin maybe is the connection url property because in order to login to the databse I have to use this path: /opt/lammp/bin/mysql .... gonna try that but i'm not sure The dabatabse xwiki is created but empty, is that a problem or xwiki will fill it? http://xwiki.475771.n2.nabble.com/file/n7580410/xml-conf.jpg Thanks again. -- View this message in context: http://xwiki.475771.n2.nabble.com/Another-installation-problem-tp7580408p758... Sent from the XWiki- Users mailing list archive at Nabble.com.
Hello! Have you forgot to fill the username/password in the mysql part, or have you deleted the properties only for the screenshot? (connection.username and connection.password) And don't pay attention about the way that you have to access mysql. It's using sockets, so can check if the server is listening well, and on what port, with the command "netstat -antup|grep mysql", should be ok. If it doesn't reply anything, check that the nestat command without the "pipe grep" returns a list with 3306 port listening. Good luck Guillaume Fenollar 2012/7/17 raav2012 <[email protected]>
Hi Guillaume, thanks for the reply
Yeah that part is commented, here's a screenshot of that part I was thinkin maybe is the connection url property because in order to login to the databse I have to use this path: /opt/lammp/bin/mysql .... gonna try that but i'm not sure The dabatabse xwiki is created but empty, is that a problem or xwiki will fill it?
http://xwiki.475771.n2.nabble.com/file/n7580410/xml-conf.jpg
Thanks again.
-- View this message in context: http://xwiki.475771.n2.nabble.com/Another-installation-problem-tp7580408p758... Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
participants (2)
-
Guillaume Fenollar -
raav2012