Of course I didn't! Thanks Thomas, works perfectly now
On Sun, Dec 6, 2009 at 12:31 PM, Thomas Mortagne <[email protected]>wrote: > 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 > _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
