I decided to start from scratch on the off chance that maybe we missed some minor detail. The good news is that we're getting different error messages now. Looking at the xwiki log the first error is the following:
10:23:16,311 [http-129.147.132.30-80-1] ERROR store.XWikiHibernateBaseStore - Failed updating schema: ORA-01918: user 'XWIKI' does not exist
After that are a ton of errors regarding missing tables (which would make sense). We're not using an "XWIKI" user for our oracle config, instead we specify our our user/password in the hibernate config file. Could this "XWIKI" ID be hardcoded in the code some where?
Craig
Sorry for the slow response. We downloaded 1.1.1 of the war file (latest stable version). We followed all the directions regarding the configuration files that was up on the site. One point that might be in question is if our user actually has all the permissions necessary for the database. Currently the account can create/drop tables, insert/delete, etc. Also, the oracle HBM file is referenced in the hibernate config file. Any other thoughts?
CraigOn 11/2/07, Vincent Massol < vincent@massol.net> wrote:Hi Craig,
Have you followed the instructions on http://www.xwiki.org/xwiki/bin/view/AdminGuide/InstallationOracle
and especially the part about the oracle HBM file?
Also what version of xwiki are you installing?
Thanks
-Vincent
On Nov 2, 2007, at 12:59 AM, Fye Kan wrote:
> Hello,
>
> We're investingating a few wiki options and were trying to use Xwiki
> with Tomcat 6 and Oracle 10g using the war installation process.
> We've modified all of the config files per the instructions on the
> site but are getting the following errors when trying to access the
> default page:
>
> 17:25:31,106 [http-129.147.132.30-80-1] ERROR
> store.XWikiHibernateBaseStore - Failed updating schema: 2
> 17:25:31,213 [http-129.147.132.30-80-1] ERROR
> store.XWikiHibernateBaseStore - While executing query: update
> xwikidoc set xwd_translation=0 where xwd_translati on is null
> 17:25:31,213 [http-129.147.132.30-80-1] ERROR
> store.XWikiHibernateBaseStore - Failed updating schema: ORA-00942:
> table or view does not exist
>
> followed by a lot more errors. This is a brand new install so no
> tables exist yet. The user account we have for the DB has access to
> create/modify/remove tables so we're at a bit of a loss as to what
> the problem is. Does anyone out there have any suggestions as to
> what the problem could be? Do we need to create the tables a head of
> time? Is there a script to do so? Any help would be appreciated,
> thanks!
>
> Craig
> ________________________
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users