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#HInstallationsteps
[2]
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL#HInstallationSteps
On Thu, Nov 6, 2014 at 11:01 AM, Michael Stahl <[email protected]>
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
> [email protected]
> http://lists.xwiki.org/mailman/listinfo/users
>
_______________________________________________
users mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/users
