5 Dec
2009
5 Dec
'09
4:45 p.m.
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?
Thanks,
Anamaria