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
>
> 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
