[xwiki-users] Porblem Installing w/Oracle
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
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 ________________________
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? Craig On 11/2/07, Vincent Massol <[email protected]> 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
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 On 11/5/07, Fye Kan <[email protected]> wrote:
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?
Craig
On 11/2/07, Vincent Massol <[email protected]> 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
participants (2)
-
Fye Kan -
Vincent Massol