27 Dec
2006
27 Dec
'06
12:11 p.m.
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.
27 Dec
27 Dec
1:21 p.m.
New subject: [xwiki-users] How to get data from XWiki 0.9.840 working on XWiki 1.0 Beta 1?
Hi Fabian,
-----Original Message-----
From: Fabian Gorsler [mailto:fab@der-moloch.de]
Sent: mercredi 27 décembre 2006 12:11
To: xwiki-users(a)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
1:30 p.m.
New subject: [xwiki-users] How to get data from XWiki 0.9.840 working on XWiki 1.0 Beta 1?
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(a)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(a)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(a)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
3:34 p.m.
New subject: [xwiki-users] How to get data from XWiki 0.9.840 working on XWiki 1.0 Beta 1?
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.
3:31 p.m.
New subject: [xwiki-users] How to get data from XWiki 0.9.840 working on XWiki 1.0 Beta 1?
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.
7 Jan
7 Jan
1:12 a.m.
New subject: [xwiki-users] How to get data from XWiki 0.9.840 working on XWiki 1.0 Beta 1?
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. :)
--
Ludovic Dubost
Blog: http://www.ludovic.org/blog/
XWiki: http://www.xwiki.com
Skype: ldubost GTalk: ldubost
AIM: nvludo Yahoo: ludovic
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(a)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
1:13 a.m.
New subject: [xwiki-users] How to get data from XWiki 0.9.840 working on XWiki 1.0 Beta 1?
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. :)
--
Ludovic Dubost
Blog: http://www.ludovic.org/blog/
XWiki: http://www.xwiki.com
Skype: ldubost GTalk: ldubost
AIM: nvludo Yahoo: ludovic
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(a)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
6567
days inactive
6578
days old
6 comments
4 participants
participants (4)
-
Fabian Gorsler -
Frederic Kho -
Ludovic Dubost -
Vincent Massol