6 Dec
2009
6 Dec
'09
11:31 a.m.
On Sat, Dec 5, 2009 at 21:36, Anamaria Stoica <anam.stoica(a)gmail.com> wrote:
On Sat, Dec 5, 2009 at 7:06 PM, Thomas Mortagne
<thomas.mortagne(a)xwiki.com>wrote;wrote:
Are you sure you commented it out (remove the # in front of it) ?
On Sat, Dec 5, 2009 at 16:45, Anamaria Stoica
<anam.stoica(a)gmail.com>
wrote:
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: 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#HConfigur…
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
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs
--
Thomas Mortagne
Thanks,
Anamaria
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs
--
Thomas Mortagne
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs