February 2012 - xwiki-users@xwiki.org

Re: [xwiki-users] Performance tuning for growing wiki
by Crowd Covered 16 Feb '12

16 Feb '12

I've solved the problem I asked about yesterday: Column length too big for column 'XXX' (max = 21845); use BLOB or TEXT instead There is a useful option in MySQL Migration Tool to change the SQL code for table creation, so I've just used LONGTEXT instead of VARCHAR(60000) and alike which are not valid for MySQL. Additionally I needed to fix several dates in XWIKIDATES like 2222-04-16 00:00:00 into 2012... - no idea why they were treated as invalid... Could someone also hint about consequences of several errors I wasn't able to solve? May be they can be solved as well? 1. For XWIKIATTACHMENT_ARCHIVE I got 0 of 20 entries transferred, with an error "Unknown column '0x' in 'field list'". Indeed in .script file I see them like this: INSERT INTO XWIKIATTACHMENT_ARCHIVE VALUES(-2145604653,''). I believe it's safe to ignore this? But how did it happen? 2. Same error for XWIKIATTACHMENT_CONTENT, but there only one row should have been deleted - may I got problems because of this? Will community benefit from description of such HSQLDB->MySQL migration or was it a non-trivial thing for me only (I only faced databases during university course)? :) If yes where can I add it? Andrey

2 1

[xwiki-users] categories: spaces or parent pages?
by Theresa Noisser 16 Feb '12

16 Feb '12

Hi, i want to have our wiki categorized, since it's used as a intranet for a company with a few different work groups. So it would be the best if every group gets its own "category", but every coworker is able to see (and possibly edit) every page. But i'm not sure what's the best way to do this, i think the two possibilities are to use different spaces or to use parent pages. Can you tell me what the main differences are to help me with this decision? Is it only the rights management or are there any other advantages/disadvantages? Thanks again, resi.

3 2

[xwiki-users] List of all users: names and avatars; edit profile pages
by Theresa Noisser 16 Feb '12

16 Feb '12

Hello, for our company intranet wiki i'd like to have a page where all coworkers are listed with their names and pictures. I found a velocity code to give out the useravatar (e.g. #largeUserAvatar('XWiki.username') ), but is there a way to automatically generate a page where all the users are listed with names and pictures (perhaps in 2 columns and with links to their profile pages)? I only found a way to list all editors or page creators. And second, i would like to add information to the profile pages of the coworkers, e.g. their specialities or responsibilities. How can i do that? Thanks in advance, resi.

3 2

[xwiki-users] New Xwiki howto guides - documentation project
by Kaya Saman 16 Feb '12

16 Feb '12

Hello, I've created some howto's over time with the latest last night..... Here are the URLs: http://dev.xwiki.org/xwiki/bin/view/Drafts/BSD_Migration http://dev.xwiki.org/xwiki/bin/view/Drafts/BSD_Install http://dev.xwiki.org/xwiki/bin/view/Drafts/Glassfish_Solaris Could I get some feedback of peoples opinions on these and **if** they're ready/good-enough to be put onto the main Xwiki site..... --if so then where they should go! Many thanks :-) Regards, Kaya

2 1

[xwiki-users] Configuration to enforce specific password policy in xwiki?
by mohit gupta 16 Feb '12

16 Feb '12

Hi, I want to apply a specicific set of rules to password policy in xwiki so that that if any new user/existing user(in case he want to change the existing password) adhere to this policy. Some of the rules are like :- 1)Password should have following charectics A minimum password length of fourteen (12) characters Contain at least one alpha characters (a-z, A-Z). Contain at least one Upper Case Alpha character (A-Z). Contain at least one numeric character (0-9). Contain at least one “special” character, such as the following:~ ` ! @ # $ % ’ The maximum number of failed login attempts shall be set to 3. 2)Passwords are required to be changed every 30 days 3)A password history of last 13 passwords must be maintained so that new password is not among last 13 passwords 4)Where any user account has been locked out, admin should be subject to reset the password My first question is about point 1 . I can see one way to modify registration password matching regex at http://wikiURL/myWiki/bin/edit/XWiki/Registration?editor=wiki so that i can change default policy from 6 character to customized policy as per point 1. Is there any other way to from user interface ? Second point is i don't see any configuration setting to fulfil the requirements 2,3 and 4. Does xwiki support this kind of configuration too?

3 3

[xwiki-users] XWiki Enterprise and XWiki Enterprise Manager 3.4 Released
by Marius Dumitru Florea 16 Feb '12

16 Feb '12

The XWiki development team is proud to announce the availability of XWiki Commons, XWiki Rendering, XWiki Platform, XWiki Enterprise and XWiki Enterprise Manager 3.4. XWiki Enterprise 3.4 is a stabilization release as we're approaching the end of the 3.x cycle so its main goal was to improve the Extension Manager and App Within Minutes features. However, this release also comes with a new look and a new default wiki page syntax. The highlights of this release are: * New color themes * XWiki 2.1 is the default page syntax * Improved Extension Manager UI * Delete space menu * Simple space templates * Special characters in attachment file names * Minimized action menu * Display macro See the full release notes at http://www.xwiki.org/xwiki/bin/view/ReleaseNotes/ReleaseNotesXWikiEnterpris… for more details. Thanks -The XWiki dev team

6 7

[xwiki-users] How to get the rendered content of a document with translations?
by Guillaume Delhumeau 16 Feb '12

16 Feb '12

Hi guys. Let met describe you my problem. I get the rendered content of a document on a velocity script : #set($newsletterContent = $newsletterContentDoc.getRenderedContent()) But I would like to specify the language I want ('fr' or 'en') because my document contains translation keys. Of course, I tried to use Document.getTranslatedDocument() before rendering it, but it doesn't work, maybe because my translated content is inside a velocity script of the document. The best way would be having a language parameter into getRenderedContent() function but since we can't, is there an easy way to do it? -- I also tried to do this : #set($newsletterContent = $xwiki.getURLContent($newsletterContentDoc.getExternalURL('get','outputSyntax=plain&language=fr'))) but it is very dirty and doesn't work since the wiki ask for credentials when I do getURLContent(). -- Thx a lot. Guillaume

3 4

[xwiki-users] Installation issue - access denied
by Matthew McClure 16 Feb '12

16 Feb '12

I got a new computer and want to move my old Xwiki instance. I've exported an .xar file on the old system and downloaded the installer and run it on the new computer, but when I attempt to launch it I get a console window that appears very briefly with three Access denied lines and a stack trace that closes before I can see much more than that. So first, does that suggest an obvious problem that's already well-known? And if not, does the startup process generate a logfile somewhere that I could analyze? My system is a 64-bit Windows 7 Enterprise i5-2400 CPU with 16.0 GB of memory. Any assistance would be much appreciated. I use my Xwiki all the time and don't want to lose all my history. Thanks, Matthew

3 2

Re: [xwiki-users] Performance tuning for growing wiki
by Crowd Covered 15 Feb '12

15 Feb '12

Thanks for all who replied to my initial request. I've followed the advice and tried MySQL. I have heard about problems with xar export/import and would like to avoid it if naked DB migration is possible. I've googled up what seems a righteous way using MySQL Migration Toolkit (here are 2 links: http://confluence.atlassian.com/display/DOC/Migrating+from+HSQLDB+to+MySQL, http://wiki.alfresco.com/wiki/Migrating_from_HSQL) After some exercises to make jdbc driver work I've got database exported but run into problems with particular columns because of which complete tables are not copied to MySQL. Below is an excerpt from report where for problematic tables evil columns are mentioned: `PUBLIC`.`XWIKICLASSES` Column length too big for column 'XWO_CUSTOM_MAPPING' (max = 21845); use BLOB or TEXT instead `PUBLIC`.`XWIKICLASSESPROP` Column length too big for column 'XWP_CUSTOMDISPLAY' (max = 21845); use BLOB or TEXT instead `PUBLIC`.`XWIKICOMMENTS` Column length too big for column 'XWC_HIGHLIGHT' (max = 21845); use BLOB or TEXT instead `PUBLIC`.`XWIKIDOC` Column length too big for column 'XWD_CONTENT' (max = 21845); use BLOB or TEXT instead `PUBLIC`.`XWIKILARGESTRINGS` Column length too big for column 'XWL_VALUE' (max = 21845); use BLOB or TEXT instead `PUBLIC`.`XWIKIPREFERENCES` Column length too big for column 'XWP_MENU' (max = 21845); use BLOB or TEXT instead Is there a way to cope with this or the only way is export/import with Large Wiki Export extension? Thx, Andrey

1 0

Re: [xwiki-users] Linking
by goldring, richard 15 Feb '12

15 Feb '12

Here: http://dev.xwiki.org/xwiki/bin/view/Community/Building As in .. "Checking out the sources Use your favorite Subversion client to check out the sources. You can check out the whole source tree or only a single module you wish to build. Maven2 is powerful enough in that it'll always try to download the required dependencies from the remote repositories you have defined, so that you don't have to build the whole project from sources." -----Original Message----- From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On Behalf Of goldring, richard Sent: 06 February 2012 17:15 To: 'XWiki Users' Subject: Re: [xwiki-users] Linking Thankyou Marius - I'll have a look at this when I find some free time - I'm a little snowed under at work at the moment! -----Original Message----- From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On Behalf Of Marius Dumitru Florea Sent: 06 February 2012 17:08 To: XWiki Users Subject: Re: [xwiki-users] Linking On Fri, Feb 3, 2012 at 4:36 PM, Hamster <teunham(a)hotmail.com> wrote: > +1 I've created https://github.com/xwiki/xwiki-platform/tree/feature-alfresco-link . Checkout https://github.com/xwiki/xwiki-platform/blob/feature-alfresco-link/xwiki-pla tform-core/xwiki-platform-wysiwyg/README.txt and the https://github.com/xwiki/xwiki-platform/blob/feature-alfresco-link/xwiki-pla tform-core/xwiki-platform-wysiwyg/xwiki-platform-wysiwyg-server/src/main/jav a/org/xwiki/wysiwyg/server/internal/plugin/alfresco/XWikiAlfrescoService.jav a as an example implementation of the service that is used to browse the tree structure (e.g. file system). You could start by cloning xwiki-platform GitHub repo, checkout the feature-alfresco-link branch, change XWikiAlfrescoService to return information about the network file system, build the WYSIWYG editor modules and update the WYSIWYG editor of your XE instance. Updating the WYSIWYG editor usually means: * overwrite the server and shared jar in WEB-INF/lib * delete resources/js/xwiki/wysiwyg/xwe folder and copy the same folder from the wysiwyg war > > I think this should be part of the "Link" WYSIWYG editor! > > I don't have the knowledge to modify the source-code, but I do the > advantage to modify the source-code (or implement a copy). We have > developed several ClickOnce Applications for internal company use, > which accept URL-parameters. I would love to extend the "Link" menu, > so people can choose "Link to ClickOnceApp", supply the > URL-parameter(s) and XWiki will generate the correct link! > > Is there a step-by-step tutorial on how to modify the > WYSIWYG-editor??? (I know, whishful thinking!) Unfortunately no. Hope this helps, Marius > > -- > View this message in context: > http://xwiki.475771.n2.nabble.com/Linking-tp7247202p7250922.html > Sent from the XWiki- Users mailing list archive at Nabble.com. > _______________________________________________ > 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

2 1