On Sat, Dec 5, 2009 at 16:45, Anamaria Stoica <anam.stoica(a)gmail.com> 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
Thanks,
Anamaria
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs