- xwiki-users@xwiki.org - lists.xwiki.org

[xwiki-users] Search box in IE8
by Dilipkumar Jadhav 19 Aug '09

19 Aug '09

Hello All, This thing just came to notice when we upgraded our Internet Explorer to IE8. The search box that populates using <meta-g> pulls up at the very bottom of the page in IE8. The same box works normally and shows up at the top of the page in IE7 or Firefox 3.X.X. In IE8, when I enable the compatibility mode, the box works normally & shows up at the top of the page. Although, I've not tried this solution, but I understand that adding this meta tag at the top of any html/jsp page should help circumnavigate this issue : <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" /> However, I am not sure which page to add this so that the search box works & appears at the top of the page. Any help...

2 1

Re: [xwiki-users] Users not displayed
by Christian Ribeaud 17 Aug '09

17 Aug '09

Hi Sergiu, problem is solved. Sorry for the annoyance. Today I have been told that the xwiki database was imported from a previous xwiki instance and not created from the scratch. So we decided to make a xwiki installation from the scratch and this worked like a charm. Having a look at the log would also probably have helped us. There were a lot of exceptions thrown by Hibernate (but I am not sure that they are all related to my problem). Thanks to everyone and have a beautiful day, christian -- Canoo - Your Solution Provider for Rich Internet Applications Christian Ribeaud Canoo Engineering AG Kirschgartenstrasse 5 CH-4051 Basel Tel: +41 61 228 94 44 Fax: +41 61 228 94 49 christian.ribeaud(a)canoo.com http://www.canoo.com/ On Aug 15, 2009, at 7:58 PM, Sergiu Dumitriu wrote: > Christian Ribeaud wrote: >> Hi Sergiu, >>> Thanks for the message. Unfortunately I won't be able to look at >>> it more until tonight. After a first look, indeed it seems to be a >>> real problem, which I can't explain right now. >> No problem. I would really be happy if we could use XWiki. >>> Can you first try to use the MySQL5Dialect dialect in the >>> hibernate configuration file? >> $ /usr/local/mysql5/bin/mysql -V outputs: >> /usr/local/mysql5/bin/mysql Ver 14.12 Distrib 5.0.51, for redhat- >> linux-gnu (i686) using EditLine wrapper >>> Also, what version of the mysql connector are you using? >> I found 'mysql-connector-java-3.0.11-stable-bin.jar' in >> '<TOMCAT_HOME>/lib' directory (Tomcat6). >> If XWiki does not install any other, this is the one which is used. > > Version 3 doesn't work well with XWiki. Can you try putting http://repo2.maven.org/maven2/mysql/mysql-connector-java/5.1.6/mysql-connec… > in webapps/xwiki/WEB-INF/lib and restart the server? > >> Do you think that this could be a file permissions issue? On the >> server where XWiki is running, I have less permissions than >> on my computer. > > No, it correctly retrieves the number of users, and everything else > seems to work, so it's not a permission issue. > > -- > Sergiu Dumitriu > http://purl.org/net/sergiu/ >

3 2

[xwiki-users] Redirect loop
by Daniel Simon 17 Aug '09

17 Aug '09

I'm having a similar problem as documented by others: when not logged in, XWiki redirects to https://domain.com/xwikihttps://domain.com/xwiki/bin/..... That is, it's doubling the base of the URL. I've seen similar discussion at http://jira.xwiki.org/jira/browse/XWIKI-3330?page=com.atlassian.jira.plugin… ...but I don't have any xwiki.base parameter in xwiki.cfg. Also, along the lines of http://jira.xwiki.org/jira/browse/XWIKI-479?page=com.atlassian.jira.plugin.… ...I don't know what to set xwiki.virtual.redirect to (and I'm not using virtual wikis). I do have ProxyPass and ProxyReversePass going on my Apache server, but they seem to be working just fine once I'm logged in to XWiki. Any suggestions? Anyone? Thanks for the help....

1 0

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

17 Aug '09

I have installed for testing the M3 and tried to login immediately with Admin/admin but it says, Wrong user name!!!! I tried to see if anything was written and nothing. Did the password or user name change?

2 2

[xwiki-users] TODO list small bug
by Nikos Georgosopoulos 17 Aug '09

17 Aug '09

Hi all, I have been trying for the last day to put the TODO app in my wiki and it kept on failing to show the mytodo list in the panel. I use Oracle for backend so I thought it was that the problem. Here is the panel's code corrected to work in my case (XWiki 1.9.3, Tomacat 6, Oracle XE 11): #panelheader('My Todos') #set ($hql = ", BaseObject as obj, StringProperty as prop1, LargeStringProperty as prop2 where obj.name=doc.fullName and obj.className='XWiki.TodoClass' and obj.name <> 'XWiki.TodoClassTemplate' and obj.id=prop1.id.id and prop1.id.name='Status' and prop1.value <> 'Finished' and obj.id=prop2.id.id and prop2.id.name ='Assignee' and prop2.value like '$context.user' order by doc.date desc") #foreach ($todo in $xwiki.searchDocuments($hql, 5, 0)) * [$todo] #end #panelfooter() The big difference is the LargeStringProperty (Instead of StringProperty used in the XAR) and the like instead of = used to match the value. For the LargeStringProperty it is strange for me that someone chose a CLOB to store user names but... maybe because of the class hierarchy involved in the user name. Then again, how can this work even without oracle? For the like, well, oracle atleast will not even bother checking a string against a stream. Yes the words are phonetically close but.... oracle doesn't care about phonetics. I hope others out there will enjoy this helpful app.

4 10

[xwiki-users] Different versions of xwiki in one tomcat
by michael.comes＠arcor.de 17 Aug '09

17 Aug '09

Hello! I want to run different xwiki-versions (currently 1.7.2 and new 1.9.3) on one host in one tomcat-container (but different folders: webapps/xwiki172 and webapps/xwiki193) against one Oracle-DB (but different users: xwiki and xwiki2). The user xwiki is used by version 1.7.2 and is running fine, the version 1.9.3 is configured to use the DB-User xwiki2. It seems not to be possible, when I point to http://[...]:8081/xwiki193, I get: 2009-08-17 15:17:46,757 [http://[...]:8081/xwiki193/bin/view/Main/] [http-8081-Processor23] ERROR store.XWikiHibernateBaseStore java.sql.SQLException: ORA-00955: name is already used by an existing object at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1623) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1588) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225) at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:492) at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:308) at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:254) at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:563) at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1024) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:1068) at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDBVersion(XWikiHibernateMigrationManager.java: at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.<init>(AbstractXWikiMigrationManager.java:68) at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.<init>(XWikiHibernateMigrationManager.java:51) [...] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown Source) at java.lang.Thread.run(Thread.java:619) 2009-08-17 15:17:46,809 [http://[...]:8081/xwiki193/bin/view/Main/] [http-8081-Processor23] WARN util.JDBCExceptionReporter 2009-08-17 15:17:46,809 [http://[...]:8081/xwiki193/bin/view/Main/] [http-8081-Processor23] ERROR util.JDBCExceptionReporter com.xpn.xwiki.XWikiException: Error number 3001 in 3: Cannot load class com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigra Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: could not execute query at com.xpn.xwiki.XWiki.createClassFromConfig(XWiki.java:1005) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:728) at com.xpn.xwiki.XWiki.<init>(XWiki.java:670) at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:317) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:388) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) [...] It looks a little bit like jira-XWIKI-2009 which is noticed to be fixed. Is this possible? How to do? hp-ux 11.23 java 1.6.0.03 tomcat 5.5.20 oracle 10.2.0.3 Thanx a lot! Michael ****** Plantschen oder Grog? Der Arcor-Wetterdienst weiss Bescheid! Wassertemperaturen für den Urlaub jetzt checken: www.arcor.de/rd/wetter_wasser

2 2

[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