Hi,
XWiki is configured to use an user and password *for the entire connection*
and not for individual databases. When a new subwiki is created, a new
database is created inside the configured schema.
To configure XWiki's connection to your new database, you need to edit your
hibernate.cfg.xml. See the notes from the Oracle installation [1].
Then you could double check your new database server to see if the user and
password that you have just configured XWiki to use is correct and if the
user has the proper rights. Depending on your setup, use Oracle's interface
to manage users and rights and probably use a console ("Oracle SQL*Plus
command-line tool"?) to connect to your database to validate the user and
password.
Hope this helps,
Eduard
P.S.: I guess it does not hurt to have a look over the MySQL instructions
[2] which might offer some additional details, since the process is more or
less similar.
----------
[1]
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationOracle#HIns…
[2]
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL#HInst…
On Thu, Nov 6, 2014 at 11:01 AM, Michael Stahl <michael.stahl(a)live.de>
wrote:
Hi all,
I'm running XWiki 6.2 (Oracle-DB / Tomcat7) with two sub-wikis.
I learned that for each sub-wiki, a database is created. Does anyone know
the username and password for the sub-wiki databases? Are they the same as
for the main database?
Here's why I'm asking: I'm trying to transfer the wiki including the
sub-wikis to a new server, but the XWiki-User is not allowed to create
databases there. So I had the admin set up the databases and sent three
dumps of the main and sub-wiki databases. After importing, I can't access
the wiki, I get an error message like this:
SQL Error: 1435, SQLState: 72000ORA-01435: No such user
So, basically, the question is: How to transfer a wiki including sub-wikis
to a new server?
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users