On Sat, Dec 5, 2009 at 7:06 PM, Thomas Mortagne <[email protected]>wrote:
> On Sat, Dec 5, 2009 at 16:45, Anamaria Stoica <[email protected]> > wrote: > > Hi, > > > > I'm trying to run xwiki-enterprise-manager-mysql-2.0.4 jetty version on > > mysql db xwiki2, username xwiki2, passw xwiki2, but it keeps trying to > > access database xwiki, and not xwiki2. > > > > See exception here: > > Wrapped Exception: Access denied for user 'xwiki2'@'localhost' to > database > > 'xwiki' > > http://ana-s-private-labs.pastebin.com/m20b049f4 > > > > My hibernate.cfg.xml is here: > > http://ana-s-private-labs.pastebin.com/m3861ac33 > > > > 1. <!-- MySQL configuration. > > 2. Uncomment if you want to use MySQL and comment out other > > database configurations. > > 3. We need to set the sql_mode to a less strict value, see > > XWIKI-1945 > > 4. --> > > 5. <property > > > name="connection.url">jdbc:mysql://localhost/xwiki2?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8&sessionVariables=sql_mode=''</property> > > 6. <property name="connection.username">xwiki2</property> > > 7. <property name="connection.password">xwiki2</property> > > 8. <property > > name="connection.driver_class">com.mysql.jdbc.Driver</property> > > 9. <property > > name="dialect">org.hibernate.dialect.MySQLDialect</property> > > 10. <property > > > name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> > > 11. <property name="connection.pool_size">2</property> > > 12. <property name="statement_cache.size">2</property> > > 13. <mapping resource="xwiki.hbm.xml"/> > > 14. <mapping resource="feeds.hbm.xml"/> > > 15. <mapping resource="activitystream.hbm.xml"/> > > > > > > I then just changed the hibernate.cfg.xml to try to connect to a xwiki4 > db > > (without actually creating it), and it tries to connect to db xwiki4, > > getting this exception this time: > > > > org.apache.commons.dbcp.SQLNestedException: Cannot create > > PoolableConnectionFactory (Access denied for user 'xwiki2'@'localhost' > > to database 'xwiki4') > > > > http://ana-s-private-labs.pastebin.com/m129d56b2 > > > > But after I actually create the database xwiki4, and give all rights to > user > > xwiki2, I get again the first exception, trying to connect to db xwiki, > and > > not xwiki4. > > > > What am I doing wrong? > > In virtual mode, the database set in hibernate configuration is not > taken into account since each wiki its own database. > > If you want to change the main wiki database name ("xwiki" by default) > you have to modify the property xwiki.db in xwiki.cfg file. See > > http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Configuration#HConfigurethenamesofdatabaseschemas28since16M129 > > Yes, I'm trying to use another database as the main wiki base, called xwiki2. I have another XE using the xwiki one, and if I try to run this XEM on it, a mysql process goes at 100% and nothing loads. (don't want to find out why, just to use a new one). I changed xwiki.db=xwiki2, but I get the same exception: Wrapped Exception: Access denied for user 'xwiki2'@'localhost' to database 'xwiki' Do I have to change anything else? All I want is to run my XEM :p Besides this I only made the changes in hibernate.cfg.xml mentioned in my first email. Anamaria > > > Thanks, > > Anamaria > > _______________________________________________ > > devs mailing list > > [email protected] > > http://lists.xwiki.org/mailman/listinfo/devs > > > > > > -- > Thomas Mortagne > _______________________________________________ > devs mailing list > [email protected] > http://lists.xwiki.org/mailman/listinfo/devs > _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
