[xwiki-users] Database information about xwiki
Hello Everybody, In order to set the XWiki up for all users in my organization, I need some information about the database structure, for sending it to the database administrators. I've searched a little but I hadn't found any answer to the following questions: - A little description of the relational model, and the main tables? - A suggestion about how to partitionate the big tables? - If there is any possibility to set up in oracle without Hibernate, just create the tables? Thanks for the info, Francisco -- Francisco Hernández Cuchí OFICINA ESPAÑOLA DE PATENTES Y MARCAS mail: [email protected] <mailto:[email protected]> ********************************************************************************************** IMPORTANTE: El contenido de este correo y ficheros adjuntos es confidencial y está dirigido únicamente para el destinatario/s. Si Ud recibe este correo por error, por favor póngase en contacto con su administrador de correo o con el emisor immediatamente y no difunda su contenido a nadie ni haga copias. *** Este correo ha sido escaneado de virus y contenido malicioso *** **********************************************************************************************
Le mercredi 11 février 2009, Hernández Cuchí, Francisco Ricardo a écrit :
- A little description of the relational model, and the main tables?
See perhaps http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration and the out of date schema at http://platform.xwiki.org/xwiki/bin/view/DevGuide/DatabaseSchema
How outdated is it? Are there new tables or only modifications in the tables? Thanks, -----Mensaje original----- De: [email protected] [mailto:[email protected]] En nombre de Hervé Agnoux Enviado el: miércoles, 11 de febrero de 2009 11:12 Para: XWiki Users Asunto: Re: [xwiki-users] Database information about xwiki Le mercredi 11 février 2009, Hernández Cuchí, Francisco Ricardo a écrit :
- A little description of the relational model, and the main tables?
See perhaps http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration and the out of date schema at http://platform.xwiki.org/xwiki/bin/view/DevGuide/DatabaseSchema _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users ********************************************************************************************** IMPORTANTE: El contenido de este correo y ficheros adjuntos es confidencial y está dirigido únicamente para el destinatario/s. Si Ud recibe este correo por error, por favor póngase en contacto con su administrador de correo o con el emisor immediatamente y no difunda su contenido a nadie ni haga copias. *** Este correo ha sido escaneado de virus y contenido malicioso *** **********************************************************************************************
Hi If you are running a local xwiki you can use tools like DB Visualizer (windows app) to connect and view DB structure. You also need to understand a bit about xwiki properties as they reflect in db structure (table names). Also look at Hibernate mapping http://svn.xwiki.org/svnroot/xwiki/platform/core/trunk/xwiki-core/src/main/r... Hope this help. Ajdin -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hernández Cuchí, Francisco Ricardo Sent: 11 February 2009 11:25 To: XWiki Users Subject: Re: [xwiki-users] Database information about xwiki How outdated is it? Are there new tables or only modifications in the tables? Thanks, -----Mensaje original----- De: [email protected] [mailto:[email protected]] En nombre de Hervé Agnoux Enviado el: miércoles, 11 de febrero de 2009 11:12 Para: XWiki Users Asunto: Re: [xwiki-users] Database information about xwiki Le mercredi 11 février 2009, Hernández Cuchí, Francisco Ricardo a écrit :
- A little description of the relational model, and the main tables?
See perhaps http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration and the out of date schema at http://platform.xwiki.org/xwiki/bin/view/DevGuide/DatabaseSchema _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users ********************************************************************************************** IMPORTANTE: El contenido de este correo y ficheros adjuntos es confidencial y está dirigido únicamente para el destinatario/s. Si Ud recibe este correo por error, por favor póngase en contacto con su administrador de correo o con el emisor immediatamente y no difunda su contenido a nadie ni haga copias. *** Este correo ha sido escaneado de virus y contenido malicioso *** ********************************************************************************************** _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users -------------------------------------------------------- NOTICE This message and any files transmitted with it is intended for the addressee only and may contain information that is confidential or privileged. Unauthorised use is strictly prohibited. If you are not the addressee, you should not read, copy, disclose or otherwise use this message, except for the purpose of delivery to the addressee. Any views or opinions expressed within this e-mail are those of the author and do not necessarily represent those of Coventry University.
I am testing it with the standalone installation (the one that is only a msi file), How can I connect to this database? -----Mensaje original----- De: [email protected] [mailto:[email protected]] En nombre de Ajdin Brandic Enviado el: miércoles, 11 de febrero de 2009 12:55 Para: XWiki Users Asunto: Re: [xwiki-users] Database information about xwiki Hi If you are running a local xwiki you can use tools like DB Visualizer (windows app) to connect and view DB structure. You also need to understand a bit about xwiki properties as they reflect in db structure (table names). Also look at Hibernate mapping http://svn.xwiki.org/svnroot/xwiki/platform/core/trunk/xwiki-core/src/main/r... Hope this help. Ajdin -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hernández Cuchí, Francisco Ricardo Sent: 11 February 2009 11:25 To: XWiki Users Subject: Re: [xwiki-users] Database information about xwiki How outdated is it? Are there new tables or only modifications in the tables? Thanks, -----Mensaje original----- De: [email protected] [mailto:[email protected]] En nombre de Hervé Agnoux Enviado el: miércoles, 11 de febrero de 2009 11:12 Para: XWiki Users Asunto: Re: [xwiki-users] Database information about xwiki Le mercredi 11 février 2009, Hernández Cuchí, Francisco Ricardo a écrit :
- A little description of the relational model, and the main tables?
See perhaps http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration and the out of date schema at http://platform.xwiki.org/xwiki/bin/view/DevGuide/DatabaseSchema _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users ********************************************************************************************** IMPORTANTE: El contenido de este correo y ficheros adjuntos es confidencial y está dirigido únicamente para el destinatario/s. Si Ud recibe este correo por error, por favor póngase en contacto con su administrador de correo o con el emisor immediatamente y no difunda su contenido a nadie ni haga copias. *** Este correo ha sido escaneado de virus y contenido malicioso *** ********************************************************************************************** _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users -------------------------------------------------------- NOTICE This message and any files transmitted with it is intended for the addressee only and may contain information that is confidential or privileged. Unauthorised use is strictly prohibited. If you are not the addressee, you should not read, copy, disclose or otherwise use this message, except for the purpose of delivery to the addressee. Any views or opinions expressed within this e-mail are those of the author and do not necessarily represent those of Coventry University. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users ********************************************************************************************** IMPORTANTE: El contenido de este correo y ficheros adjuntos es confidencial y está dirigido únicamente para el destinatario/s. Si Ud recibe este correo por error, por favor póngase en contacto con su administrador de correo o con el emisor immediatamente y no difunda su contenido a nadie ni haga copias. *** Este correo ha sido escaneado de virus y contenido malicioso *** **********************************************************************************************
I must admit that I had not found an easy way to connect to it using DB Visualizer, sorry. As the standalone version is not to be used for any development work I had to move to MySQL. So I'm using GlassFish and MySQL to ruin xwiki enterprise. It will not take you long to install it yourself and you'll find all the instructions online. Ajdin -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hernández Cuchí, Francisco Ricardo Sent: 11 February 2009 12:00 To: XWiki Users Subject: Re: [xwiki-users] Database information about xwiki I am testing it with the standalone installation (the one that is only a msi file), How can I connect to this database? -----Mensaje original----- De: [email protected] [mailto:[email protected]] En nombre de Ajdin Brandic Enviado el: miércoles, 11 de febrero de 2009 12:55 Para: XWiki Users Asunto: Re: [xwiki-users] Database information about xwiki Hi If you are running a local xwiki you can use tools like DB Visualizer (windows app) to connect and view DB structure. You also need to understand a bit about xwiki properties as they reflect in db structure (table names). Also look at Hibernate mapping http://svn.xwiki.org/svnroot/xwiki/platform/core/trunk/xwiki-core/src/main/r... Hope this help. Ajdin -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hernández Cuchí, Francisco Ricardo Sent: 11 February 2009 11:25 To: XWiki Users Subject: Re: [xwiki-users] Database information about xwiki How outdated is it? Are there new tables or only modifications in the tables? Thanks, -----Mensaje original----- De: [email protected] [mailto:[email protected]] En nombre de Hervé Agnoux Enviado el: miércoles, 11 de febrero de 2009 11:12 Para: XWiki Users Asunto: Re: [xwiki-users] Database information about xwiki Le mercredi 11 février 2009, Hernández Cuchí, Francisco Ricardo a écrit :
- A little description of the relational model, and the main tables?
See perhaps http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration and the out of date schema at http://platform.xwiki.org/xwiki/bin/view/DevGuide/DatabaseSchema _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users ********************************************************************************************** IMPORTANTE: El contenido de este correo y ficheros adjuntos es confidencial y está dirigido únicamente para el destinatario/s. Si Ud recibe este correo por error, por favor póngase en contacto con su administrador de correo o con el emisor immediatamente y no difunda su contenido a nadie ni haga copias. *** Este correo ha sido escaneado de virus y contenido malicioso *** ********************************************************************************************** _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users -------------------------------------------------------- NOTICE This message and any files transmitted with it is intended for the addressee only and may contain information that is confidential or privileged. Unauthorised use is strictly prohibited. If you are not the addressee, you should not read, copy, disclose or otherwise use this message, except for the purpose of delivery to the addressee. Any views or opinions expressed within this e-mail are those of the author and do not necessarily represent those of Coventry University. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users ********************************************************************************************** IMPORTANTE: El contenido de este correo y ficheros adjuntos es confidencial y está dirigido únicamente para el destinatario/s. Si Ud recibe este correo por error, por favor póngase en contacto con su administrador de correo o con el emisor immediatamente y no difunda su contenido a nadie ni haga copias. *** Este correo ha sido escaneado de virus y contenido malicioso *** ********************************************************************************************** _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Hi, On Wed, Feb 11, 2009 at 3:11 PM, Ajdin Brandic <[email protected]>wrote:
I must admit that I had not found an easy way to connect to it using DB Visualizer, sorry. As the standalone version is not to be used for any development work I had to move to MySQL. *So I'm using GlassFish and MySQL to ruin xwiki enterprise.* It will not take you long to install it yourself and you'll find all the instructions online.
I sure hope you meant "run" :-p Guillaume
Ajdin
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hernández Cuchí, Francisco Ricardo Sent: 11 February 2009 12:00 To: XWiki Users Subject: Re: [xwiki-users] Database information about xwiki
I am testing it with the standalone installation (the one that is only a msi file), How can I connect to this database?
-----Mensaje original----- De: [email protected] [mailto:[email protected]] En nombre de Ajdin Brandic Enviado el: miércoles, 11 de febrero de 2009 12:55 Para: XWiki Users Asunto: Re: [xwiki-users] Database information about xwiki
Hi
If you are running a local xwiki you can use tools like DB Visualizer (windows app) to connect and view DB structure. You also need to understand a bit about xwiki properties as they reflect in db structure (table names). Also look at Hibernate mapping http://svn.xwiki.org/svnroot/xwiki/platform/core/trunk/xwiki-core/src/main/r...
Hope this help.
Ajdin
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hernández Cuchí, Francisco Ricardo Sent: 11 February 2009 11:25 To: XWiki Users Subject: Re: [xwiki-users] Database information about xwiki
How outdated is it? Are there new tables or only modifications in the tables?
Thanks,
-----Mensaje original----- De: [email protected] [mailto:[email protected]] En nombre de Hervé Agnoux Enviado el: miércoles, 11 de febrero de 2009 11:12 Para: XWiki Users Asunto: Re: [xwiki-users] Database information about xwiki
Le mercredi 11 février 2009, Hernández Cuchí, Francisco Ricardo a écrit :
- A little description of the relational model, and the main tables?
See perhaps http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration and the out of date schema at http://platform.xwiki.org/xwiki/bin/view/DevGuide/DatabaseSchema
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
********************************************************************************************** IMPORTANTE: El contenido de este correo y ficheros adjuntos es confidencial y está dirigido únicamente para el destinatario/s. Si Ud recibe este correo por error, por favor póngase en contacto con su administrador de correo o con el emisor immediatamente y no difunda su contenido a nadie ni haga copias. *** Este correo ha sido escaneado de virus y contenido malicioso ***
**********************************************************************************************
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
--------------------------------------------------------
NOTICE
This message and any files transmitted with it is intended for the addressee only and may contain information that is confidential or privileged. Unauthorised use is strictly prohibited. If you are not the addressee, you should not read, copy, disclose or otherwise use this message, except for the purpose of delivery to the addressee.
Any views or opinions expressed within this e-mail are those of the author and do not necessarily represent those of Coventry University. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
********************************************************************************************** IMPORTANTE: El contenido de este correo y ficheros adjuntos es confidencial y está dirigido únicamente para el destinatario/s. Si Ud recibe este correo por error, por favor póngase en contacto con su administrador de correo o con el emisor immediatamente y no difunda su contenido a nadie ni haga copias. *** Este correo ha sido escaneado de virus y contenido malicioso ***
**********************************************************************************************
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Guillaume Lerouge Product Manager - XWiki Skype ID : wikibc http://guillaumelerouge.com/
Yes :-). I apologise to the whole community and beyond. Ajdin -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Guillaume Lerouge Sent: 11 February 2009 15:44 To: XWiki Users Subject: Re: [xwiki-users] Database information about xwiki Hi, On Wed, Feb 11, 2009 at 3:11 PM, Ajdin Brandic <[email protected]>wrote:
I must admit that I had not found an easy way to connect to it using DB Visualizer, sorry. As the standalone version is not to be used for any development work I had to move to MySQL. *So I'm using GlassFish and MySQL to ruin xwiki enterprise.* It will not take you long to install it yourself and you'll find all the instructions online.
I sure hope you meant "run" :-p Guillaume
Ajdin
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hernández Cuchí, Francisco Ricardo Sent: 11 February 2009 12:00 To: XWiki Users Subject: Re: [xwiki-users] Database information about xwiki
I am testing it with the standalone installation (the one that is only a msi file), How can I connect to this database?
-----Mensaje original----- De: [email protected] [mailto:[email protected]] En nombre de Ajdin Brandic Enviado el: miércoles, 11 de febrero de 2009 12:55 Para: XWiki Users Asunto: Re: [xwiki-users] Database information about xwiki
Hi
If you are running a local xwiki you can use tools like DB Visualizer (windows app) to connect and view DB structure. You also need to understand a bit about xwiki properties as they reflect in db structure (table names). Also look at Hibernate mapping http://svn.xwiki.org/svnroot/xwiki/platform/core/trunk/xwiki-core/src/ main/resources/xwiki.hbm.xml
Hope this help.
Ajdin
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hernández Cuchí, Francisco Ricardo Sent: 11 February 2009 11:25 To: XWiki Users Subject: Re: [xwiki-users] Database information about xwiki
How outdated is it? Are there new tables or only modifications in the tables?
Thanks,
-----Mensaje original----- De: [email protected] [mailto:[email protected]] En nombre de Hervé Agnoux Enviado el: miércoles, 11 de febrero de 2009 11:12 Para: XWiki Users Asunto: Re: [xwiki-users] Database information about xwiki
Le mercredi 11 février 2009, Hernández Cuchí, Francisco Ricardo a écrit :
- A little description of the relational model, and the main tables?
See perhaps http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administr ation and the out of date schema at http://platform.xwiki.org/xwiki/bin/view/DevGuide/DatabaseSchema
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
********************************************************************** ************************ IMPORTANTE: El contenido de este correo y ficheros adjuntos es confidencial y está dirigido únicamente para el destinatario/s. Si Ud recibe este correo por error, por favor póngase en contacto con su administrador de correo o con el emisor immediatamente y no difunda su contenido a nadie ni haga copias. *** Este correo ha sido escaneado de virus y contenido malicioso ***
********************************************************************** ************************
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
--------------------------------------------------------
NOTICE
This message and any files transmitted with it is intended for the addressee only and may contain information that is confidential or privileged. Unauthorised use is strictly prohibited. If you are not the addressee, you should not read, copy, disclose or otherwise use this message, except for the purpose of delivery to the addressee.
Any views or opinions expressed within this e-mail are those of the author and do not necessarily represent those of Coventry University. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
********************************************************************** ************************ IMPORTANTE: El contenido de este correo y ficheros adjuntos es confidencial y está dirigido únicamente para el destinatario/s. Si Ud recibe este correo por error, por favor póngase en contacto con su administrador de correo o con el emisor immediatamente y no difunda su contenido a nadie ni haga copias. *** Este correo ha sido escaneado de virus y contenido malicioso ***
********************************************************************** ************************
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Guillaume Lerouge Product Manager - XWiki Skype ID : wikibc http://guillaumelerouge.com/ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users -------------------------------------------------------- NOTICE This message and any files transmitted with it is intended for the addressee only and may contain information that is confidential or privileged. Unauthorised use is strictly prohibited. If you are not the addressee, you should not read, copy, disclose or otherwise use this message, except for the purpose of delivery to the addressee. Any views or opinions expressed within this e-mail are those of the author and do not necessarily represent those of Coventry University.
On Wed, Feb 11, 2009 at 2:11 AM, Hervé Agnoux < [email protected]> wrote:
See perhaps http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration and the out of date schema at http://platform.xwiki.org/xwiki/bin/view/DevGuide/DatabaseSchema
I've found it useful to use http://www.quest.com/toad-for-mysql/ to explore the database created by Xwiki.... I use Toad by setting up an SSH tunnel ( \cygwin\bin\ssh.exe -L 3306:localhost:3306 [email protected] "echo '^C to quit' ; exec cat > /dev/null" ) from the windows box running Toad-for-Mysql to the Linux machine running Tomcat & the Mysql db (which is bound only to localhost for security reasons). http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administrationr... http://www.dbvis.com/products/dbvis/download/install.jsp -- is it worth setting up and learning this new tool over toad?? How would I use it remotely via a tunnel (firewalls, security, etc)? Speaking of databases, does anybody see anything wrong with the database-surgery I had to perform -- see http://nielsmayer.com/whatididtopoorsql.txt -- apparently I was allowed to create documents with embedded '.' or '/' characters which ultimately were misinterpreted when given as a URL -- thus leaving me with documents I could neither delete nor rename (let alone access). It is probably a bug to allow such names to be entered w/o validation. --Niels http://nielsmayer.com
Hi, updated the data schema http://platform.xwiki.org/xwiki/bin/view/DevGuide/DatabaseSchema But someone should have a look if everythings correct. hel. Hervé Agnoux wrote:
Le mercredi 11 février 2009, Hernández Cuchí, Francisco Ricardo a écrit :
- A little description of the relational model, and the main tables?
See perhaps http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration and the out of date schema at http://platform.xwiki.org/xwiki/bin/view/DevGuide/DatabaseSchema
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
----- Helmut Lehner [email protected] -- View this message in context: http://n2.nabble.com/Database-information-about-xwiki-tp2307592p2320973.html Sent from the XWiki- Users mailing list archive at Nabble.com.
participants (6)
-
Ajdin Brandic -
Guillaume Lerouge -
hel-o -
Hernández Cuchí, Francisco Ricardo -
Hervé Agnoux -
Niels Mayer