Re: [xwiki-users] Database information about xwiki
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 users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users - Helmut Lehner h...@hel.at -- 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. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[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: francisco.hernan...@oepm.es mailto:francisco.hernan...@oepm.es ** 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 users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
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 users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
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: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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 users@xwiki.org 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 users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
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: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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 users@xwiki.org 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 users@xwiki.org 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 users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
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: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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 users@xwiki.org 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 users@xwiki.org 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 users@xwiki.org 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 users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Database information about xwiki
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: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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 users@xwiki.org 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 users@xwiki.org 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 users@xwiki.org 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 users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Database information about xwiki
Hi, On Wed, Feb 11, 2009 at 3:11 PM, Ajdin Brandic aa6...@coventry.ac.ukwrote: 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: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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 users@xwiki.org 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 users@xwiki.org 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 users@xwiki.org 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 users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users -- Guillaume Lerouge Product Manager - XWiki Skype ID : wikibc http://guillaumelerouge.com/ ___ users mailing list users@xwiki.org http://lists.xwiki.org
Re: [xwiki-users] Database information about xwiki
Yes :-). I apologise to the whole community and beyond. Ajdin -Original Message- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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 aa6...@coventry.ac.ukwrote: 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: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] 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 users@xwiki.org 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 users@xwiki.org 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 users@xwiki.org 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 users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Database information about xwiki
On Wed, Feb 11, 2009 at 2:11 AM, Hervé Agnoux herve.agn...@diaam-informatique.com 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 u...@server.com 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+Administrationrecommends 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 ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users