[xwiki-devs] XEM 2.0.4. on jetty/mysql - different database name (xwiki2) not working
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
----- Original Message ----- From: "Anamaria Stoica"
See exception here: Wrapped Exception: Access denied for user 'xwiki2'@'localhost' to database 'xwiki' http://ana-s-private-labs.pastebin.com/m20b049f4
This exception in XWikiHibernateBaseStore.setDatabase can be only thrown if isVirtual(context) == true. Is it your purpose to create virtual setup? I connected out-of-the-box XWiki Enterprise (i.e. not virtual) to the xwiki2 db on MySQL and it worked fine - the only modification required was JDBC URL. Regards Luke
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#HConfigure...
Thanks, Anamaria _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- Thomas Mortagne
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#HConfigure...
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: 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
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#HConfigure...
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
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#HConfigure...
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
participants (3)
-
Anamaria Stoica -
Lukasz Skowronski -
Thomas Mortagne