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#HInst... [2] http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL#HInsta... 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