I forgot to mention that to install xwiki, i extracted the zip file and copied it to webapps/
On Thu, Jan 7, 2010 at 6:31 PM, Ziggy <zigg...@gmail.com> wrote: > I just installed a fresh install of xwiki 2.1.1 > > I had previously used v2.0 without any problems. I did the following to > install 2.1.1 > > - Got a backup of the mysql database folder and the tomcat webapps/xwiki > folder to backup the v2.0 > - delete the database > - Created the database as shown below > > mysql> show databases; > +--------------------+ > | Database | > +--------------------+ > | information_schema | > | mysql | > +--------------------+ > 2 rows in set (0.13 sec) > > mysql> create database xwiki > -> ; > Query OK, 1 row affected (0.08 sec) > > mysql> grant all privileges on xwiki.* to xw...@127.0.0.1 identified by > 'xwiki' > -> ; > Query OK, 0 rows affected (0.34 sec) > > mysql> > > - I then updated the hibernate.cfg.xml file. All i did in this file is > comment out the hsqldb configuration and uncommented the mysql > configuration. > > Here is my hibernate.cfg.xml file > > --- > > <?xml version='1.0' encoding='utf-8'?> > <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate > Configuration DTD//EN" > "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> > <hibernate-configuration> > <session-factory> > > <!-- Please refer to the installation guide on > http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installationfor > configuring your > database. You'll need to do 2 things: > 1) Copy your database driver JAR in WEB-INF/lib or in some shared > lib directory > 2) Uncomment the properties below for your specific DB (and > comment the default > database configuration if it doesn't match your DB) > --> > > <!-- Generic parameters common to all Databases --> > > <property name="show_sql">false</property> > <property name="use_outer_join">true</property> > > <property name="dbcp.defaultAutoCommit">false</property> > <property name="dbcp.maxActive">50</property> > <property name="dbcp.maxIdle">5</property> > <property name="dbcp.maxWait">30000</property> > <property name="dbcp.whenExhaustedAction">1</property> > <property name="dbcp.ps.whenExhaustedAction">1</property> > <property name="dbcp.ps.maxActive">20</property> > <property name="dbcp.ps.maxWait">120000</property> > <property name="dbcp.ps.maxIdle">20</property> > <!-- Without it, some queries fail in MS SQL. XWiki doesn't need > scrollable result sets, anyway. --> > <property name="jdbc.use_scrollable_resultset">false</property> > > <!-- Configuration for the default database. > Comment out this section and uncomment other sections below if you > want to use another database. > Note that the database tables will be created automatically if > they don't already exist. > > <property > name="connection.url">jdbc:hsqldb:file:database/xwiki_db;shutdown=true</property> > <property name="connection.username">sa</property> > <property name="connection.password"></property> > <property > name="connection.driver_class">org.hsqldb.jdbcDriver</property> > <property name="dialect">org.hibernate.dialect.HSQLDialect</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"/>--> > > <!-- MySQL configuration. > Uncomment if you want to use MySQL and comment out other database > configurations. > We need to set the sql_mode to a less strict value, see > XWIKI-1945--> > <property > name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8&sessionVariables=sql_mode=''</property> > <property name="connection.username">xwiki</property> > <property name="connection.password">xwiki</property> > <property > name="connection.driver_class">com.mysql.jdbc.Driver</property> > <property name="dialect">org.hibernate.dialect.MySQLDialect</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"/> > > > <!-- HSQLDB configuration. > Uncomment if you want to use HSQLDB and comment out other database > configurations. > <property > name="connection.url">jdbc:hsqldb:file:/some/path/xwikidb;shutdown=true</property> > <property name="connection.username">sa</property> > <property name="connection.password"></property> > <property > name="connection.driver_class">org.hsqldb.jdbcDriver</property> > <property name="dialect">org.hibernate.dialect.HSQLDialect</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"/> > --> > > <!-- PostgreSQL configuration. > Uncomment if you want to use PostgreSQL and comment out other > database configurations. > <property name="connection.url">jdbc:postgresql:xwiki</property> > <property name="connection.username">xwiki</property> > <property name="connection.password">xwiki</property> > <property > name="connection.driver_class">org.postgresql.Driver</property> > <property > name="dialect">org.hibernate.dialect.PostgreSQLDialect</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"/> > --> > > <!-- Oracle configuration. > Uncomment if you want to use Oracle and comment out other database > configurations. > Note: the 2 properties named > "hibernate.connection.SetBigStringTryClob" and > "hibernate.jdbc.batch_size". They are required to tell Oracle to > allow CLOBs larger than > 32K. > <property name="connection.url">jdbc:oracle:thin:@localhost > :1521:XE</property> > <property name="connection.username">xwiki</property> > <property name="connection.password">xwiki</property> > <property > name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> > <property > name="dialect">org.hibernate.dialect.Oracle10gDialect</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> > <property > name="hibernate.connection.SetBigStringTryClob">true</property> > <property name="hibernate.jdbc.batch_size">0</property> > <mapping resource="xwiki.oracle.hbm.xml"/> > <mapping resource="feeds.oracle.hbm.xml"/> > <mapping resource="activitystream.hbm.xml"/> > --> > > <!-- Derby configuration. > Uncomment if you want to use Derby and comment out other database > configurations. > <property > name="connection.url">jdbc:derby:/some/path/xwikidb;create=true</property> > <property > name="connection.driver_class">org.apache.derby.jdbc.EmbeddedDriver</property> > <property name="dialect">org.hibernate.dialect.DerbyDialect</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.derby.hbm.xml"/> > <mapping resource="feeds.hbm.xml"/> > <mapping resource="activitystream.hbm.xml"/> > --> > > </session-factory> > </hibernate-configuration> > > ---- > > > I tried to launch xwiki via http://localhost:8080/xwiki and i got this > error on the browser.. > > HTTP Status 500 - > ------------------------------ > > *type* Exception report > > *message* > > *description* *The server encountered an internal error () that prevented > it from fulfilling this request.* > > *exception* > > javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 > in 0: Could not initialize main XWiki context > > Wrapped Exception: Error number 3001 in 3: Cannot load class > com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from > param xwiki.store.migration.manager.class > Wrapped Exception: Error number 0 in 3: Exception while hibernate execute > > Wrapped Exception: could not execute query > > 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.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152) > > com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:117) > > com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) > > com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:295) > > > com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) > > *root cause* > > com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main > XWiki context > > Wrapped Exception: Error number 3001 in 3: Cannot load class > com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from > param xwiki.store.migration.manager.class > Wrapped Exception: Error number 0 in 3: Exception while hibernate execute > > Wrapped Exception: could not execute query > com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:341) > com.xpn.xwiki.XWiki.getXWiki(XWiki.java:402) > com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135) > com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115) > > > 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.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152) > > com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:117) > > com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) > > com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:295) > > > com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) > > *note* *The full stack trace of the root cause is available in the Apache > Tomcat/6.0.20 logs.* > > > > *Any cluses as to what i need to do to get it to work? > * > ------------------------------ > Apache Tomcat/6.0.20 > > > > > > > > > _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users