On Tue, Oct 15, 2013 at 7:49 AM, -bt- <[email protected]> wrote:

Hello,

since a while I try to check out the possibilities of Xwiki. First I installed a 5.1 over the standard Debian packages. My most problems started when I try to install multiple wikis or subwikis. As I wrote 5.2 will have it I decided not to wast to much time to try it with 5.1 Now 5.2 is finally released I set up again a Debian7.1 machine and install XWiki over the standard debian package xwiki-enterprise-tomcat7-mysql. After I while I found out that I need to create templates first. So I click on the link under Wiki that brings me to the template install. As soon as I click on install template I get the following two error messages.

Error installing wiki template. Error number 50035 in 5: Exception in plugin [com.xpn.xwiki.plugin.wikimanager.WikiManagerPlugin]: Wiki [workspacetemplate] database update failed Wiki template features can not be installed without the wiki base template being installed first.

I try to find something on google but the only result I found is that it is a right problem on MySQL. Last time I run the following command I crashed my complete xwiki so I'm not how to proceed...

grant all on *.* to 'xwiki'@'127.0.0.1' identified by 'xwiki'; or grant all on *.* to 'xwiki'@'localhost' identified by 'xwiki';

Are you sure 'xwiki' is the password you chose when installing XWiki ? Look at /etc/xwiki/hibernate.cfg.xml and search for <property name="connection.password">.

Best regards

Kai

-- View this message in context: http://xwiki.475771.n2.nabble.com/XWiki-5-2-Subwikis-Wiki-Template-Error-num... Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users

-- Thomas Mortagne

On Oct 15, 2013, at 10:06 AM, -bt- <[email protected]> wrote:

Thomas Mortagne wrote

...

On Tue, Oct 15, 2013 at 7:49 AM, -bt- <

...

kais3n@

...

> wrote: Are you sure 'xwiki' is the password you chose when installing XWiki ? Look at /etc/xwiki/hibernate.cfg.xml and search for <property name="connection.password"> .

Thanks for the help that was the last time the problem and now it works! Maybe I should look a little bit more to MySQL syntax before copy & past it.

But I'm just wondering why do I need to run this after a standard Xwiki Installation.

We want to remove this step (if you're referring to the wiki install step) in the future (possibly in XWiki 5.3). Thanks -Vincent

Or should I only grant all rights while running this update and than downgrade back?

I have a similar installation, Debian system installed via apt, but with a Postgres Database. And I get exact the same error after the 5.2 upgrade. What is the PostgreSQL equivalent to these commands? -bt- wrote

grant all on *.* to 'xwiki'@'127.0.0.1' identified by 'xwiki'; or grant all on *.* to 'xwiki'@'localhost' identified by 'xwiki';

-- View this message in context: http://xwiki.475771.n2.nabble.com/XWiki-5-2-Subwikis-Wiki-Template-Error-num... Sent from the XWiki- Users mailing list archive at Nabble.com.

The instructions are primary for manual installations. But I had installed xwiki via my distribution packed manager apt. Anyway I've done:

psql -U postgres

postgres=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+----------+----------+-------------+-------------+----------------------- mydb | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 | postgres | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 | template0 | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres xwiki | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 | (5 rows)

postgres=# \connect xwiki

postgres=# \du List of roles Role name | Attributes | Member of -----------+------------------------------------------------+----------- postgres | Superuser, Create role, Create DB, Replication | {} xwiki | | {}

postgres=# GRANT ALL ON SCHEMA public TO xwiki; GRANT

Without success! Versions == Ubuntu 12.04.3 LTS PostgreSQL Version: 9.1+129ubuntu1 xWiki Version: 5.2.2 -- View this message in context: http://xwiki.475771.n2.nabble.com/XWiki-5-2-Subwikis-Wiki-Template-Error-num... Sent from the XWiki- Users mailing list archive at Nabble.com.