How to get data from XWiki 0.9.840 working on XWiki 1.0 Beta 1?
Hi, we have a XWiki 0.9.840 instance running with Postgres 8.1 and we would like to test the new 1.0b1 release with our existing wikis. How could we transfer the data between the old version and the new? The installation docs don't describe a proper way and just copying the dump of the old data to another database and running XWiki with this db doesn't work, too. The Hibernate mappings seem to have changed. What could we do? Our wiki has grown for about half a year and copying the data manually would take really long. Does there any kind of filter exist? Nevertheless, the 1.0b1 looks really nice. You did a really great work. :) I hope I'll be able to run the 1.0-series soon. :) Best regards, Fabian.
Hi Fabian,
-----Original Message----- From: Fabian Gorsler [mailto:fab@der-moloch.de] Sent: mercredi 27 décembre 2006 12:11 To: xwiki-users@objectweb.org Subject: [xwiki-users] How to get data from XWiki 0.9.840 working on XWiki 1.0 Beta 1?
Hi,
we have a XWiki 0.9.840 instance running with Postgres 8.1 and we would like to test the new 1.0b1 release with our existing wikis. How could we transfer the data between the old version and the new?
The installation docs don't describe a proper way
The migration is described in the Release Notes and I've just linked it from the installation page this morning.
and just copying the dump of the old data to another database and running XWiki with this db doesn't work, too. The Hibernate mappings seem to have changed.
Ha, that would be a problem. We need to track this as this is supposed to be the way to upgrade. What errors are you getting?
What could we do? Our wiki has grown for about half a year and copying the data manually would take really long. Does there any kind of filter exist?
Don't do it manually! We thought it would work seamlessly but it seems it doesnt in your case so we need to find out what's not working. Let's work together to resolve this.
Nevertheless, the 1.0b1 looks really nice. You did a really great work. :) I hope I'll be able to run the 1.0-series soon. :)
Thanks -Vincent ___________________________________________________________________________ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com
Fabian, My upgrade from 0.984 to 1.0B1 was painless. I used MySQL as database. I just made sure that my settings (hibernate.cfg) pointed to the MySQL database we are using. I'm not familiar with PostgreSQL, but can't you find a tool that can backup your database and restore to a new schema? That is that I did for MySQL (using MySQL Administrator). Deric On 12/27/06, Vincent Massol <vincent@massol.net> wrote:
Hi Fabian,
-----Original Message----- From: Fabian Gorsler [mailto:fab@der-moloch.de] Sent: mercredi 27 décembre 2006 12:11 To: xwiki-users@objectweb.org Subject: [xwiki-users] How to get data from XWiki 0.9.840 working on XWiki 1.0 Beta 1?
Hi,
we have a XWiki 0.9.840 instance running with Postgres 8.1 and we would like to test the new 1.0b1 release with our existing wikis. How could we transfer the data between the old version and the new?
The installation docs don't describe a proper way
The migration is described in the Release Notes and I've just linked it from the installation page this morning.
and just copying the dump of the old data to another database and running XWiki with this db doesn't work, too. The Hibernate mappings seem to have changed.
Ha, that would be a problem. We need to track this as this is supposed to be the way to upgrade. What errors are you getting?
What could we do? Our wiki has grown for about half a year and copying the data manually would take really long. Does there any kind of filter exist?
Don't do it manually! We thought it would work seamlessly but it seems it doesn't in your case so we need to find out what's not working. Let's work together to resolve this.
Nevertheless, the 1.0b1 looks really nice. You did a really great work. :) I hope I'll be able to run the 1.0-series soon. :)
Thanks -Vincent
___________________________________________________________________________ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com
-- You receive this message as a subscriber of the xwiki-users@objectweb.orgmailing list. To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Hi Frederic, thanks for your fast reply, too. :)
My upgrade from 0.984 to 1.0B1 was painless.
You lucky. :)
I used MySQL as database. I just made sure that my settings (hibernate.cfg) pointed to the MySQL database we are using.
Ok, I did the same.
I'm not familiar with PostgreSQL, but can't you find a tool that can backup your database and restore to a new schema? That is that I did for MySQL (using MySQL Administrator).
Ok, here I did the same either. I have a database on my workstation for these testing purposes. The database is (was) identical to the live system. Do you have any further ideas? Thanks in advance! :) Best regards, Fabian.
Hi Vincent, thanks for your fast reply. :)
The migration is described in the Release Notes and I've just linked it from the installation page this morning.
The tasks described in the Release Notes don't work for my problem. At the moment I'm not able to display anything with XWiki, I just receive exceptions.
Ha, that would be a problem. We need to track this as this is supposed to be the way to upgrade. What errors are you getting?
org.postgresql.util.PSQLException: ERROR: column xwikidocum0_.xwd_title does not exist This exception led me to assume that Hibernate mappings have changed. The dump I've set up on my database for testing is identical to the live system which serves the old XWiki. (The whole log with more exceptions and details is here: http://www.der-moloch.de/files/xwiki-ml/xwiki_stdout.log)
Don't do it manually!
:)
We thought it would work seamlessly but it seems it doesnt in your case so we need to find out what's not working. Let's work together to resolve this.
This sounds really great. Perhaps I should pass you my whole configuration at first: - OS: Windows XP SP 2 - Tomcat 5.5.20 - JVM: Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_07-b03) - DB: PostgreSQL 8.1.5 (JDBC: postgresql-8.1-408.jdbc3.jar) / UTF-8 The things I did: - I downloaded xwiki-1.0-beta-1.war and deployed it via Tomcat Manager. - Stopped Tomcat. - Renamed xwiki-1.0-beta-1/ to xwiki/ in webapps-folder of Tomcat. - Added Postgres-JDBC-driver to xwiki/WEB-INF/lib. - Edited hibernate.cfg.xml: Removed MySQL entries, pasted our configuration of the old XWiki and reconfigured some connection settings. - Started Tomcat and tried to open http://localhost:8080/xwiki/bin/view/Main/WebHome. The connection settings from hibernate.cfg.xml: <property name="connection.url">jdbc:postgresql://localhost/xwikidb</property> <property name="connection.username">xwiki</property> <property name="connection.password">topsecret</property> <property name="connection.driver_class">org.postgresql.Driver</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">50</property> <property name="statement_cache.size">50</property> <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property> Connections to the Postgres-DB are opened and data is transferred. The connection seems to be ok. Which information do you need additionally? What should I try to do? Thanks in advance for your help! :) Best regards, Fabian.
Do you have in your xwiki.cfg xwiki.store.hibernate.updateschema=1 Normally additional fields should be created automatically Ludovic Fabian Gorsler a écrit :
Hi Vincent,
thanks for your fast reply. :)
The migration is described in the Release Notes and I've just linked it from the installation page this morning.
The tasks described in the Release Notes don't work for my problem. At the moment I'm not able to display anything with XWiki, I just receive exceptions.
Ha, that would be a problem. We need to track this as this is supposed to be the way to upgrade. What errors are you getting?
org.postgresql.util.PSQLException: ERROR: column xwikidocum0_.xwd_title does not exist
This exception led me to assume that Hibernate mappings have changed. The dump I've set up on my database for testing is identical to the live system which serves the old XWiki.
(The whole log with more exceptions and details is here: http://www.der-moloch.de/files/xwiki-ml/xwiki_stdout.log)
Don't do it manually!
:)
We thought it would work seamlessly but it seems it doesn’t in your case so we need to find out what's not working. Let's work together to resolve this.
This sounds really great. Perhaps I should pass you my whole configuration at first:
- OS: Windows XP SP 2 - Tomcat 5.5.20 - JVM: Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_07-b03) - DB: PostgreSQL 8.1.5 (JDBC: postgresql-8.1-408.jdbc3.jar) / UTF-8
The things I did:
- I downloaded xwiki-1.0-beta-1.war and deployed it via Tomcat Manager. - Stopped Tomcat. - Renamed xwiki-1.0-beta-1/ to xwiki/ in webapps-folder of Tomcat. - Added Postgres-JDBC-driver to xwiki/WEB-INF/lib. - Edited hibernate.cfg.xml: Removed MySQL entries, pasted our configuration of the old XWiki and reconfigured some connection settings. - Started Tomcat and tried to open http://localhost:8080/xwiki/bin/view/Main/WebHome.
The connection settings from hibernate.cfg.xml: <property name="connection.url">jdbc:postgresql://localhost/xwikidb</property> <property name="connection.username">xwiki</property> <property name="connection.password">topsecret</property> <property name="connection.driver_class">org.postgresql.Driver</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">50</property> <property name="statement_cache.size">50</property> <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
Connections to the Postgres-DB are opened and data is transferred. The connection seems to be ok.
Which information do you need additionally? What should I try to do?
Thanks in advance for your help! :)
Best regards, Fabian.
------------------------------------------------------------------------
-- You receive this message as a subscriber of the xwiki-users@objectweb.org mailing list. To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
-- Ludovic Dubost Blog: http://www.ludovic.org/blog/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost AIM: nvludo Yahoo: ludovic
This line looks bad in your log file 15:05:41,526 ERROR http-8080-1 http://localhost:8080/xwiki/bin/view/Main/WebHome XWikiHibernateBaseStore:updateSchema:334 - Failed updating schema: ERROR: update or delete on "xwikiproperties" violates foreign key constraint "fkdf25ae4f283ee295" on "xwikilongs" Detail: Key (xwp_id,xwp_name)=(-1931600447,editbox_height) is still referenced from table "xwikilongs". You might want to try cleaning references between xwikilongs and xwikiproperties Fabian Gorsler a écrit :
Hi Vincent,
thanks for your fast reply. :)
The migration is described in the Release Notes and I've just linked it from the installation page this morning.
The tasks described in the Release Notes don't work for my problem. At the moment I'm not able to display anything with XWiki, I just receive exceptions.
Ha, that would be a problem. We need to track this as this is supposed to be the way to upgrade. What errors are you getting?
org.postgresql.util.PSQLException: ERROR: column xwikidocum0_.xwd_title does not exist
This exception led me to assume that Hibernate mappings have changed. The dump I've set up on my database for testing is identical to the live system which serves the old XWiki.
(The whole log with more exceptions and details is here: http://www.der-moloch.de/files/xwiki-ml/xwiki_stdout.log)
Don't do it manually!
:)
We thought it would work seamlessly but it seems it doesn’t in your case so we need to find out what's not working. Let's work together to resolve this.
This sounds really great. Perhaps I should pass you my whole configuration at first:
- OS: Windows XP SP 2 - Tomcat 5.5.20 - JVM: Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_07-b03) - DB: PostgreSQL 8.1.5 (JDBC: postgresql-8.1-408.jdbc3.jar) / UTF-8
The things I did:
- I downloaded xwiki-1.0-beta-1.war and deployed it via Tomcat Manager. - Stopped Tomcat. - Renamed xwiki-1.0-beta-1/ to xwiki/ in webapps-folder of Tomcat. - Added Postgres-JDBC-driver to xwiki/WEB-INF/lib. - Edited hibernate.cfg.xml: Removed MySQL entries, pasted our configuration of the old XWiki and reconfigured some connection settings. - Started Tomcat and tried to open http://localhost:8080/xwiki/bin/view/Main/WebHome.
The connection settings from hibernate.cfg.xml: <property name="connection.url">jdbc:postgresql://localhost/xwikidb</property> <property name="connection.username">xwiki</property> <property name="connection.password">topsecret</property> <property name="connection.driver_class">org.postgresql.Driver</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">50</property> <property name="statement_cache.size">50</property> <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
Connections to the Postgres-DB are opened and data is transferred. The connection seems to be ok.
Which information do you need additionally? What should I try to do?
Thanks in advance for your help! :)
Best regards, Fabian.
------------------------------------------------------------------------
-- You receive this message as a subscriber of the xwiki-users@objectweb.org mailing list. To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
-- Ludovic Dubost Blog: http://www.ludovic.org/blog/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost AIM: nvludo Yahoo: ludovic
participants (4)
-
Fabian Gorsler -
Frederic Kho -
Ludovic Dubost -
Vincent Massol