On Sat, Dec 5, 2009 at 21:36, Anamaria Stoica <[email protected]> wrote: > 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:
Are you sure you commented it out (remove the # in front of it) ? > 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 > -- Thomas Mortagne _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
