On 07/08/2010 04:00 PM, Aleks87 wrote:
I have installed the standalone version of XWiki Enterprise 2.4 M1 The standalone installation have a HSQLDB Database which I should not use.
Is it right?
It all depends on what you plan to do with your wiki. If you just want to play with it, test it, or even use it internally for a few people then HSQLDB is fine. If you plan to make it public on the web or an a wide network then it's recommended that you switch to a more reliable database.
So I have to change the Database. And I decided to use PostgreSQL 8.3 cause it was already installed on this pc. At this time I dont have the rights (password) to create a Database and I have to contact the Admin for that. But I'm not sure how this all should work.
Now I have a Folder "\XWiki Enterprise\database" where my XWiki content will be saved. Is it right?
Yes, HSQLDB stores its data in the database directory.
But changing to PostgreSQL I can erase this Folder because my Database will now been in "\PostgreSQL\8.3\data". Right?
Yes, if you switch to a different database then you can delete the database directory, but first make sure you don't have important wiki pages you wish to keep. If you do have, you can export them and then reimport after moving to a different database. Note that the HSQLDB database of the standalone XE contains already the default XE pages. You'll have to import the default XAR after switching to a different database.
I know that I have to change my hibernate.cfg.xml and to add a .jar to "\XWiki Enterprise\webapps\xwiki\WEB-INF\lib". But what .jar is the right one? "postgresql-8.3-603.jdbc3.jar" or "postgresql-8.3-603.jdbc4.jar"
And if I have done that I can access the wiki over http://localhost:5432/xwiki/bin/view/Main/ (5432 instead of 8080 because of PostgreSQL)
No, you would still use 8080. The port where your database listens for connections is different than the port where Jetty (the web server) listens for connections.
But how could the other people access the wiki. I heared it will be possible with "\\myip:5432/xwiki/bin/view/Main" if all pc's are in the same network.
Indeed.
But it would mean that my pc have to run constantly. And the start_xwiki.bat file has to be opened. I think that would not be the problem. But would my wiki get performance problems after a few days?! And how safe is this all...
You might want to increase the memory allocated to the Jetty server. Hope this helps, Marius
Sorry I'm very new to this all and I have read many tutorials and helps in the last weeks but I'm not sure if I understand them right. If someone could answer my questions and give me some tips how to implement this all, it would be very helpful.
Thank you!