August 2009 - xwiki-users@xwiki.org

[xwiki-users] XE Installation with PostgreSQL or HSQLDB Succeeds. With MySQL Fails.
by Raymond LeClair 17 Aug '09

17 Aug '09

Currently writing special pages to extend functionality of MediaWiki, but considering using XWiki instead. Experimenting with XWiki Enterprise by attempting install of xwiki- enterprise-web-1.9.3.war: In Apache Tomcat 5.5.23 Using PostgreSQL 8.4.0 -- Succeeds Or HSQLDB 1.8.0.7 -- Succeeds But MySQL 5.0.45 -- Fails. MySQL is required for XWiki Enterprise Manger, so I need to use MySQL. I get this error in the browser: javax.servlet.ServletException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3001 in 3: Cannot load class com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param xwiki.store.migration.manager.class Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: Could not create a DBCP pool. There is an error in the hibernate configuration file, please review it. I get this additionally in catalina.out: ** BEGIN NESTED EXCEPTION ** java.net.ConnectException MESSAGE: Connection refused STACKTRACE: java.net.ConnectException: Connection refused I have installed mysql-connector-java-5.0.8-bin.jar in /var/lib/ tomcat5/webapps/xwiki/WEB-INF/lib. I have modified /var/lib/tomcat5/webapps/xwiki/WEB- INF.hibernate.cfg.xml as follows:  <property name="connection.url">jdbc:mysql://localhost/xwiki? useServerPrepStmts=false&useUnicode=true&\ characterEncoding=UTF-8&sessionVariables=sql_mode=''</property> <property name="connection.username">xwiki</property> <property name="connection.password">PASSWORD</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</ property> <property name="dialect">org.hibernate.dialect.MySQLDialect</ property> <property name = "connection .provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> I created an xwiki database and granted privileges in MySQL as follows: $ mysql -u root -p mysql> create database xwiki; mysql> grant all privileges on xwiki.* to xwiki(a)127.0.0.1 identified by 'xwiki'; mysql> grant all privileges on xwiki.* to xwiki@localhost identified by 'xwiki'; OR mysql> create database xwiki; mysql> grant all privileges on xwiki.* to xwiki(a)127.0.0.1 identified by 'SAMEASROOT'; mysql> grant all privileges on xwiki.* to xwiki@localhost identified by 'SAMEASROOT'; Note that PASSWORD in the hibernate.cfg.xml file was set to either 'xwiki', or to the same password as for the root MySQL user, with the thought that perhaps the Hibernate configuration assumed an empty root MySQL user password, and that, somehow, this might help. I then modified /var/lib/tomcat5/webapps/xwiki/WEB- INF.hibernate.cfg.xml as follows, since this is what the installation instructions actually show, that is, omitting some MySQL parameters:  <property name="connection.url">jdbc:mysql://localhost/xwiki</ property> <property name="connection.username">xwiki</property> <property name="connection.password">PASSWORD</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</ property> <property name="dialect">org.hibernate.dialect.MySQLDialect</ property> <property name = "connection .provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> I have tried many permutations and scoured installation instructions, FAQ, and archives. I definitely need some help here.

4 4

[xwiki-users] RE : Bug ? Can't link the last version of an attachment
by Le Genie Logiciel 17 Aug '09

17 Aug '09

>If your attachment is an image, it's most probably a browser cache issue. >Can you try force-refreshing your browser (ctrl-shift-R) in Firefox and see >what happens? My document is not an image but it was a browser cache issue. Thank you for the help

1 0

[xwiki-users] XWiki (with Tomcat/MySQL) security
by Trevor 17 Aug '09

17 Aug '09

Hello, 1. I am wondering if any users running XWiki on Tomcat 5.5 have set up a SecurityManager policy. The documentation isn't really clear on this, other than "it's an issue" that may not be resolved. The one "comment" on XWiki.org that has a security policy is close but not quite clear. I couldn't figure out the part about Log4J. - is a policy necessary? - without one, are there any inherent security risks using XWiki/Tomcat "out of the box"? - what about Tomcat's default "users" and "roles"? 2. Are there any security risks using the default "xwiki" installation location in webapps? ie. if it's there and someone realizes you're running XWiki, couldn't they then direct their attacks specifically at MySQL / Tomcat / XWiki, looking for holes? I tried installing the WAR to a different location, and failed miserably. Does it matter? 3. Is anyone using XWiki over SSL? Anything special we need to do for that, other than getting a certificate? As you can tell, I'm not familiar with Tomcat and not a security guru. I'm just the one who has to make sure our setup "out of the box" is secure against exploits. We're running on Ubuntu, with MySQL. Yes, the server will be behind a firewall, and the MySQL passwords have been changed. I think what would help in the online documentation is a "security checklist" that rounds up all the various bits that I found on various pages. Thanks, Trevor

6 9

Re: [xwiki-users] Syntax problem 1.0 -> 2.0
by Vincent Massol 17 Aug '09

17 Aug '09

Hi, On Mar 6, 2009, at 11:02 AM, Helmut Lehner wrote: > Hi Vincent > >> I don't know if there's much we can do here since the tinymce-based >> wysiwyg will have saved the content of the page in HTML in your case >> and the converter cannot distinguish this from someone typing HTML in >> the page. > > I get this code editing a page in WYSIWYG-Mode with Syntax 1.0 and > only the headings are html. The rest is wiki syntax. This behavior > started somwhere around Version 1.5 i think. before headings were > created correctly in wiki syntax (as the rest). > > >> If you have an idea of how to do it let us know. For me you'll need >> to >> correct the 1.0 content for your pages that have this problem. > > I know how to correct this i just wanted to mention that this could > be a problem not only for me but for every user who creates pages in > syntax 1.0 in WYSIWYG and converts them to syntax 2.0 afterwards. Yes it's a problem. One thing that can be done is to write/provide a small velocity/groovy script that scans all wiki pages and replaces the heading with the wiki syntax. > The best thing would be to make the tiny mce editor create headings > again in wiki syntax:) That will not solve the problem for all page contents which have now HTML for headings. > The next best thing would be to convert html headings like the ones > created (without class, or style information) to headings in xwiki > syntax 2.0 because i think there are fewer headings created > intentionally in html with that code than by accident through that > editor bug. I think I'd prefer the script solution since otherwise that'll make the converter heavier and with some hacks. WDYT? Thanks -Vincent

2 3

[xwiki-users] Bug ? Can't link the last version of an attachment
by Le Genie Logiciel 17 Aug '09

17 Aug '09

Dear all, I encounter the following problem. I have a link to an attachement using the 2.0 syntax : [[document>>attach:docAdmin.doc]] But when I add a new version to the attachement, the link permits to download he previous version. It is the same problem inside the attachment panel, it displays version 1.2 but give access to the 1.1 version. I can only download my new 1.2 version using the history view of the attachment. I use XWiki Enterprise 1.9.2. Is there a bug for this case ? Could you reproduce it ? Regards, Maxime

2 1

[xwiki-users] xwiki Enterprise M3 can't login as Admin
by Nikolaos Georgosopoulos 16 Aug '09

16 Aug '09

I found it, the Administration button at the right top corner was not obvious this time :-O I have installed previous versions of xwiki and it was obvious to me. Nothing has changed but I didn't see it. Maybe it should change color (RED/BOLD) for some blind people like me.

1 0

[xwiki-users] Can't get XWiki to work with Oracle
by Nikolaos Georgosopoulos 16 Aug '09

16 Aug '09

Yes, that seems to work. Thanks

1 0

[xwiki-users] Can't get XWiki to work with Oracle
by Nikos Georgosopoulos 16 Aug '09

16 Aug '09

I had the same problem with my first attempts of XWiki installation. As a trial I used the xwiki user in oracle and it worked. For my installations I have to always use xwiki oracle user in order to get passed this point. Can you try it

1 0

[xwiki-users] XWiki and Liferay
by Frans Thamura 16 Aug '09

16 Aug '09

hi all anyone have u success integrate liferay with xwiki? liferay have their own wiki, but i believe xwiki more mroe advanced in feature i want to make both tech use one LDAP server -- Frans Thamura Meruvian. Center of Java and Enterprise OpenSource Meruvian bukan hanya membuat anak SMK menjadi bisa tapi SAKTI, malah saktinya SAKTI Mandraguna. Mobile: +62 855 7888 699 Blog & Profile: http://frans.thamura.info We provide services to migrate your apps to Java (web), in amazing fast and reliable.

1 0

[xwiki-users] Embedded documents
by hel-o 14 Aug '09

14 Aug '09

Hi, i was just wondering how embedded documents work. The Syntax Help gives no example. I don't know but is it just the include macro? Thanks hel. ----- semantic-web.hel.at hel(a)hel.at -- View this message in context: http://n2.nabble.com/Embedded-documents-tp3423459p3423459.html Sent from the XWiki- Users mailing list archive at Nabble.com.

3 5