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
5 Dec
5 Dec
5:22 p.m.
New subject: [xwiki-devs] XEM 2.0.4. on jetty/mysql - different database name(xwiki2) not working
----- 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
6:06 p.m.
New subject: [xwiki-devs] XEM 2.0.4. on jetty/mysql - different database name (xwiki2) not working
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
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Configuration#HConfigur…
Thanks,
Anamaria
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs
--
Thomas Mortagne
9:36 p.m.
New subject: [xwiki-devs] XEM 2.0.4. on jetty/mysql - different database name (xwiki2) not working
On Sat, Dec 5, 2009 at 7:06 PM, Thomas Mortagne
<thomas.mortagne(a)xwiki.com>wrote;wrote:
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:
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
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…
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
6 Dec
6 Dec
11:31 a.m.
New subject: [xwiki-devs] XEM 2.0.4. on jetty/mysql - different database name (xwiki2) not working
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
7 Dec
7 Dec
12:06 p.m.
New subject: [xwiki-devs] XEM 2.0.4. on jetty/mysql - different database name (xwiki2) not working
Of course I didn't! Thanks Thomas, works perfectly now
On Sun, Dec 6, 2009 at 12:31 PM, Thomas Mortagne
<thomas.mortagne(a)xwiki.com>wrote;wrote:
On Sat, Dec 5, 2009 at 21:36, 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
On Sat, Dec 5, 2009 at 7:06 PM, Thomas Mortagne
<thomas.mortagne(a)xwiki.com>wrote;wrote:
> 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:
>
name="connection.url">jdbc:mysql://localhost/xwiki2?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8&sessionVariables=sql_mode=''</property>
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
> >
> > > 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…
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
_______________________________________________
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
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
5502
days inactive
5504
days old
5 comments
3 participants
participants (3)
-
Anamaria Stoica -
Lukasz Skowronski -
Thomas Mortagne