- xwiki-users@xwiki.org - lists.xwiki.org

Re: [xwiki-users] Upgrade from 0.9.1252 to 1.0B3 using a Postgres Database
by Dandre 05 Feb '07

05 Feb '07

Man, I am starting to get depressed. It worked with the dummy DB but when I tried our main DB, it gave the same exception as allways. The XWiki.XWikiPreferences thing that I've been trying to fix for a while now. Regards, Dandre

2 1

authenticated RSS Read
by Uwe Kleinschmidt 04 Feb '07

04 Feb '07

The only way to establish an authenticated RSS Read with XWiki (XWiki <http://www.xwiki.org> Version 1.0b1.1663b <http://motorimmune.xwiki.com/xwiki/bin/view/Main/> ) I thought is to use http://username:[email protected]/xwiki/bin/view/Main/BlogRss?xpage= rdf. It doesn't work though. Can somebody help me, how to create an authenticated RSS Feed with XWiki? Thanks Uwe

1 0

how to build wiki-1.0-beta-3.xar via sources?
by zoke-xwiki＠zoke.de 04 Feb '07

04 Feb '07

How to build xwiki.xar via the sources? Downloading is currently broken and i would like to start :) Markus

2 1

Upgrade from 0.9.1252 to 1.0B3 using a Postgres Database
by VanderLeeden 02 Feb '07

02 Feb '07

I just wanted to let you know that I didn't have serious problems going from XWiki 0.9.1252 to XWiki 1.0B3 with a Postgres database. Basically, I followed the instructions in: http://www.xwiki.org/xwiki/bin/view/Main/ReleaseNotesXWiki10Beta3 As reported earlier, you'll get an exception ("Could not execute JDBC batch update") connecting to XWiki 1.0B3 for the first time. Analyzing the error message in xwiki.log: Batch entry 0 insert into xwikidoc (XWD_FULLNAME .) SQL ERROR: null value in column "xwd_archive" violates not-null constraint leads to an easy conclusion: remove the not-null constraint from the xwd_archive column in the xwikidoc table. The SQL statement is: ALTER TABLE xwikidoc ALTER COLUMN xwd_archive DROP NOT NULL; After running this SQL statement the connection was done successfully and I could load the XAR file as described in the instructions. In my case, only one thing was different from the old XWiki. All the memberships in XWikiAllGroup were gone. Only the ADMIN user was a member. So I created a Ruby script to add all users to XWikiAllGroup in the database. This can of course also be done manually. I don't know if this works in all Postgres cases. BTW, I did at the same time a database upgrade from PG 8.1.3 to 8.2.1. Rudolf VanderLeeden SysAdmin Logic United GmbH (Germany)

1 0

1.0beta2 cannot auto create some tables in Oracle 10
by feixingyu99＠hotmail.com 02 Feb '07

02 Feb '07

Hi everyone, Why can't I find the xwiki.hbm.xml file in 1.0B2 package? Am I required to create it by my self, or XWiki will provide one? Because once XWiki tried to recreate the tables, I got the error: [XWikiHibernateStore] Failed updating schema: ORA-01754: a table may contain only one column of type LONG It seems that we have to map some MySQL datatype to the proper Oracle type, in order to generate the proper DDL. Does anyone have a hbm.xml file that works with Oracle? Or what else need to be changed in the hibernate.cfg.xml? (I am using 10g JDBC driver) Best regards, Eric Sun -----Original Message----- From: Ludovic Dubost [mailto:[email protected]] Sent: Wed 1/18/2006 6:42 PM To: Eric Sun (Toronto) Subject: Re: Installation concerns for Oracle 10g Hi, You should post this to the users/dev lists. http://forge.objectweb.org/mail/?group_id=170 With XWiki 1.0B2 you should be able to run XWiki with an empty database (XWiki creates the tables automatically) and then try to import the ".xar" file available on xwiki.org into the XWiki running with the Oracle DB. Let us know how this works. Ludovic

3 8

Re: Moving from PostgreSQL to MySQL
by Dandre 02 Feb '07

02 Feb '07

Ok, the only problem I encountered while surfing the wiki is that it throws up exceptions while saving stuff. Maybe XWiki has a problem or maybe the problem I encountered while copying is the bugger. Anyway, I think we can use this way to help shape XWiki to use an old xwiki db in postgres directly as MySQL. What you do is you take your old xwiki postgres db, use the SQuirreL (or any DB copier) to copy over the tables from your postgres to MySQL. Move to the new xwiki while pointing at your MySQL db. Then move back to postgres and let the new XWiki point to Postgres again. MySQL and XWiki will "straighten" things out that will allow you to use the new Xwiki with Postgres. I hope this will work for everyone as it worked for me (well it almost worked 100% :-) ). Regards, Dandre

2 1

Re: Moving from PostgreSQL to MySQL
by Dandre 02 Feb '07

02 Feb '07

Ha ha! It worked! Well, it couldn't copy over something in 1 table, something about a duplicate reference or something but other than that, I could open up the new xwiki in postgres with an imported db from the old one! Ok, I'll post more info later. Regards, Dandre

1 0

Re: Moving from PostgreSQL to MySQL
by Dandre 02 Feb '07

02 Feb '07

Ok, so far so good. The plugin seems to work. Now I am really gonna put it through the test ;-) Wish me luck! :-D Regards, Dandre

1 0

Moving from PostgreSQL to MySQL
by Dandre 02 Feb '07

02 Feb '07

I have found a forum on the MySQL site (something like this on the net is as scarce as chicken teeth :-D ) that talks about converting a PostgreSQL db to a MySQL one (well I still need to try it out, will let everyone know): http://forums.mysql.com/read.php?83,34517,34517#msg-34517 Why? Well if you want the new XWiki to work and you don't mind the kind of DB to use, then this is a good solution. But I wanna try something. I want to copy my PSQL db to MySQL and get that to work on the new XWiki and hopefully I can convert it back to PSQL and it'll work on the new XWiki (HOPEFULLY)!!! On that forum thread, there is a plugin for SQuirreL SQL that basically allows you to copy between DBs! Now thats handy! I want to test that out and see if it will work! Oh how I hope it'll work!!! Regards, Dandre

1 0

Debugging XWiki
by Dandre 02 Feb '07

02 Feb '07

Hello Vincent and everyone at XWiki! I am going through the code but I need to view how XWiki is generating SQL queries that are sent to the JDBC driver in order to see if it's XWiki that has a problem or Hibernate or the JDBC driver. Yes, I am working with Fabian and them to try and figure out why Postgres gives a problem when porting from an old DB. Could you guys maybe give me instructions of how to turn on debug mode. Thanks alot. Regards, Dandre

3 3