[xwiki-users] Virtual wiki doesn't work - xwiki-users@xwiki.org

Thomas Mortagne

25 Dec 25 Dec

8:04 p.m.

On Thu, Dec 24, 2009 at 16:59, Paolo Rizzi <web(a)oicom.com> wrote:

I'm trying to setup a virtual sub-wiki following instructions from: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Virtualization Since I'm using PostgreSQL I followed the "By hand" method. One of the sub-wiki is called sub1, so I created a new database sub1 giving PostgreSQL user xwiki all privileges upon it. I then created a new page XWiki.XWikiServerSub1, attached a XWikiServerClass object to it specifying server=sub1.mydomain.com Now the server part seems to be working, because if I point my browser to sub1.mydomain.com:8080/... I see XWiki pages, while if I point it to anythingelse.mydomain.com:8080/... I see the page pointed to by xwiki.virtual.redirect. Problem is the database for the sub-wiki is never used!!! The main wiki "xwiki" database is used regardless of the name of the XWiki.XWikiServerSub1 page!!! What could be wrong??? The XWiki.XWikiServerSub1 has to be orphan or _must_ it have some specific parent??? Thank you all in advance for your help!!!

PostgreSQL is not supported in virtual mode. See http://jira.xwiki.org/jira/browse/XWIKI-1960

...

Bye Paolo _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

-- Thomas Mortagne

Reply

Caleb James DeLisle

26 Dec 26 Dec

7 a.m.

Hello Paolo, I know that virtual wikis can be run on postgres because I have done it. I changed the howto to reflect that it could be done (Devs should I make it clear that this feature is unsupported?) I have repeated your problem and it happens when I have only XWiki.XWikiServerSub1 and not XWiki.XWikiServerXWiki XWiki.XWikiServerXWiki should have the following attributes: server: xwiki owner: XWiki.Admin I think this will fix it for you, If it works the sub1 section should have no information in it (like when you first installed.) Let me know how this goes, If this was the problem I will modify the page to list it as a common "got-ya". Caleb James DeLisle Paolo Rizzi wrote:

...

But reading the Virtualization guide I was under the impression that PostgreSQL is not supported only by XEM, in fact the guide says virtual mode can only be setup "By hand". So I didn't used XEM, I created the database and all the XWikiServerXXX stuff myself. Insted you mean it doesn't work at all??? That would be a pity, but I was just testing anyway... But in this case the Virtualization guide should be updated to state it explicitely. Anyway XWiki seems a great product and I'll carry on testing it in any case!!! Thank you. Bye Paolo

On Thu, Dec 24, 2009 at 16:59, Paolo Rizzi <web(a)oicom.com> wrote:

I'm trying to setup a virtual sub-wiki following instructions from: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Virtualization Since I'm using PostgreSQL I followed the "By hand" method. One of the sub-wiki is called sub1, so I created a new database sub1 giving PostgreSQL user xwiki all privileges upon it. I then created a new page XWiki.XWikiServerSub1, attached a XWikiServerClass object to it specifying server=sub1.mydomain.com Now the server part seems to be working, because if I point my browser to sub1.mydomain.com:8080/... I see XWiki pages, while if I point it to anythingelse.mydomain.com:8080/... I see the page pointed to by xwiki.virtual.redirect. Problem is the database for the sub-wiki is never used!!! The main wiki "xwiki" database is used regardless of the name of the XWiki.XWikiServerSub1 page!!! What could be wrong??? The XWiki.XWikiServerSub1 has to be orphan or _must_ it have some specific parent??? Thank you all in advance for your help!!!

PostgreSQL is not supported in virtual mode. See http://jira.xwiki.org/jira/browse/XWIKI-1960

Bye Paolo _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

_______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

Reply

Caleb James DeLisle

11:08 p.m.

Hello, I think the "all-in-one" version may be your problem. It is set up to use HSQL and I know when I compile for postgres, I have to specify a different profile on the command line. All I can say is that I'm using the equivalent of the .war file (mine is built from the source code) and following the instructions for manually setting up virtual wikis works for me. You might try opening your sub1 database and using \dt to see if any tables have been created but I suspect they haven't. My advice is use the war version if you are using postgres. Caleb James DeLisle Paolo Rizzi wrote:

...

Sorry for this late response, but this year I observed a period of strict vacation... :-) Unfortunately it doesn't work. I had already created a XWiki.XWikiServerXWiki page, so that didn't make the trick. What I write into the "server" property is actually used by the engine, because it doesn't redirect to xwiki.virtual.redirect if I direct my browser to the domain I used there, so it actually find the page. But it ignores the database name. Whatever XXX I use for XWiki.XWikiServerXXX it always use the default xwiki database. The version displayed at bottom of pages is "XWiki Enterprise 2.0.1.24472". I downloaded the "all-in-one" version with Jetty and HSQL, and then configured it to use PostgreSQL and then tried the virtual stuff. Maybe I missed some important step somewhere... Anyway thank you very much for your help, and don't worry about me, I'm just experimenting, so it's not important if it doesn't work... But probably you'd like to discover why, to help others. If I manage to make any progress I'll post it, and if anyone has a suggestion, it's more than welcome!!! Bye Paolo

Hello Paolo, I know that virtual wikis can be run on postgres because I have done it. I changed the howto to reflect that it could be done (Devs should I make it clear that this feature is unsupported?) I have repeated your problem and it happens when I have only XWiki.XWikiServerSub1 and not XWiki.XWikiServerXWiki XWiki.XWikiServerXWiki should have the following attributes: server: xwiki owner: XWiki.Admin I think this will fix it for you, If it works the sub1 section should have no information in it (like when you first installed.) Let me know how this goes, If this was the problem I will modify the page to list it as a common "got-ya". Caleb James DeLisle Paolo Rizzi wrote:

But reading the Virtualization guide I was under the impression that PostgreSQL is not supported only by XEM, in fact the guide says virtual mode can only be setup "By hand". So I didn't used XEM, I created the database and all the XWikiServerXXX stuff myself. Insted you mean it doesn't work at all??? That would be a pity, but I was just testing anyway... But in this case the Virtualization guide should be updated to state it explicitely. Anyway XWiki seems a great product and I'll carry on testing it in any case!!! Thank you. Bye Paolo

On Thu, Dec 24, 2009 at 16:59, Paolo Rizzi <web(a)oicom.com> wrote: > I'm trying to setup a virtual sub-wiki following instructions from: > http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Virtualization > > Since I'm using PostgreSQL I followed the "By hand" method. > One of the sub-wiki is called sub1, so I created a new database sub1 > giving PostgreSQL user xwiki all privileges upon it. > I then created a new page XWiki.XWikiServerSub1, attached a > XWikiServerClass object to it specifying server=sub1.mydomain.com > > Now the server part seems to be working, because if I point my browser > to sub1.mydomain.com:8080/... I see XWiki pages, while if I point it to > anythingelse.mydomain.com:8080/... I see the page pointed to by > xwiki.virtual.redirect. > > Problem is the database for the sub-wiki is never used!!! > The main wiki "xwiki" database is used regardless of the name > of the XWiki.XWikiServerSub1 page!!! > > What could be wrong??? > The XWiki.XWikiServerSub1 has to be orphan > or _must_ it have some specific parent??? > > Thank you all in advance for your help!!! > > PostgreSQL is not supported in virtual mode. See http://jira.xwiki.org/jira/browse/XWIKI-1960 > Bye > Paolo > > > _______________________________________________ > users mailing list > users(a)xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > > >

_______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

Reply

Paolo Rizzi

6 Jan 6 Jan

12:25 a.m.

I downloaded the WAR version and used it to replace the webapps/xwiki directory I had already created with the "all-in-one" version, but it's the same... Well, almost... In fact the WAR I downloaded is version 2.1.1 while the version I had is 2.0.1, in fact the interface is different. When I point my browser to the sub1 domain, I can see the "SUB1" database name in the upper left corner of the blue manu bar, instead of "XWIKI"!!! But data always come from the main xwiki database... I tried a few different PostgreSQL JDBC .jar files, but it did make no difference... I think I should try installing it all locally on my PC under Windows and try to run it under a debugger to see what happens, but not now...!!! :-) Bye Paolo

...

Hello, I think the "all-in-one" version may be your problem. It is set up to use HSQL and I know when I compile for postgres, I have to specify a different profile on the command line. All I can say is that I'm using the equivalent of the .war file (mine is built from the source code) and following the instructions for manually setting up virtual wikis works for me. You might try opening your sub1 database and using \dt to see if any tables have been created but I suspect they haven't. My advice is use the war version if you are using postgres. Caleb James DeLisle Paolo Rizzi wrote:

Sorry for this late response, but this year I observed a period of strict vacation... :-) Unfortunately it doesn't work. I had already created a XWiki.XWikiServerXWiki page, so that didn't make the trick. What I write into the "server" property is actually used by the engine, because it doesn't redirect to xwiki.virtual.redirect if I direct my browser to the domain I used there, so it actually find the page. But it ignores the database name. Whatever XXX I use for XWiki.XWikiServerXXX it always use the default xwiki database. The version displayed at bottom of pages is "XWiki Enterprise 2.0.1.24472". I downloaded the "all-in-one" version with Jetty and HSQL, and then configured it to use PostgreSQL and then tried the virtual stuff. Maybe I missed some important step somewhere... Anyway thank you very much for your help, and don't worry about me, I'm just experimenting, so it's not important if it doesn't work... But probably you'd like to discover why, to help others. If I manage to make any progress I'll post it, and if anyone has a suggestion, it's more than welcome!!! Bye Paolo

Hello Paolo, I know that virtual wikis can be run on postgres because I have done it. I changed the howto to reflect that it could be done (Devs should I make it clear that this feature is unsupported?) I have repeated your problem and it happens when I have only XWiki.XWikiServerSub1 and not XWiki.XWikiServerXWiki XWiki.XWikiServerXWiki should have the following attributes: server: xwiki owner: XWiki.Admin I think this will fix it for you, If it works the sub1 section should have no information in it (like when you first installed.) Let me know how this goes, If this was the problem I will modify the page to list it as a common "got-ya". Caleb James DeLisle Paolo Rizzi wrote:

But reading the Virtualization guide I was under the impression that PostgreSQL is not supported only by XEM, in fact the guide says virtual mode can only be setup "By hand". So I didn't used XEM, I created the database and all the XWikiServerXXX stuff myself. Insted you mean it doesn't work at all??? That would be a pity, but I was just testing anyway... But in this case the Virtualization guide should be updated to state it explicitely. Anyway XWiki seems a great product and I'll carry on testing it in any case!!! Thank you. Bye Paolo > On Thu, Dec 24, 2009 at 16:59, Paolo Rizzi <web(a)oicom.com> wrote: > > > >> I'm trying to setup a virtual sub-wiki following instructions from: >> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Virtualization >> >> Since I'm using PostgreSQL I followed the "By hand" method. >> One of the sub-wiki is called sub1, so I created a new database sub1 >> giving PostgreSQL user xwiki all privileges upon it. >> I then created a new page XWiki.XWikiServerSub1, attached a >> XWikiServerClass object to it specifying server=sub1.mydomain.com >> >> Now the server part seems to be working, because if I point my browser >> to sub1.mydomain.com:8080/... I see XWiki pages, while if I point it to >> anythingelse.mydomain.com:8080/... I see the page pointed to by >> xwiki.virtual.redirect. >> >> Problem is the database for the sub-wiki is never used!!! >> The main wiki "xwiki" database is used regardless of the name >> of the XWiki.XWikiServerSub1 page!!! >> >> What could be wrong??? >> The XWiki.XWikiServerSub1 has to be orphan >> or _must_ it have some specific parent??? >> >> Thank you all in advance for your help!!! >> >> >> > PostgreSQL is not supported in virtual mode. See > http://jira.xwiki.org/jira/browse/XWIKI-1960 > > > > >> Bye >> Paolo >> >> >> _______________________________________________ >> users mailing list >> users(a)xwiki.org >> http://lists.xwiki.org/mailman/listinfo/users >> >> >> >> > > > _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

_______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

Reply