Hi,
I use xWiki for Knowledge Base.
It’s very important to access it for us.
But it’s possible that the server or database are not online (for any reasons) ; but we need to access Knowledge Base.
I search a solution to export all XWiki pages in a secure space (can be access if we have a big Disaster on a Datacenter).
How to export all XWiki content to access it offline in degraded mode ?
Thanks for your experience and feedback,
Matt
There are lots of solutions:
I’m sure there are other options but these are the first ones that come to my mind.
Thanks
Note that the Replication app is not really designed to replicate an entire instance but more a set of spaces.
Ok thx for the info. What if you replicate all the top level spaces of your instance? Won’t it provide a “backup” solution for your instance if the replica is in a different data center?
Thx
It only replicates wiki pages (and a bit likes, but not ratings in general), so I would really not advertise it as a backup solution.
I would not recommend replicating the XWiki space, since it contains pretty dangerous stuff to replicate and among other things that can’t be replicated or it would break the instance (each instance needs its own URL setup and more importantly Replication setup).
ok thx, I see. So a bit similar to the limitations from https://www.xwiki.org/xwiki/bin/view/Documentation/AdminGuide/Backup#HUsingtheXWikiExportfeature
As a degraded mode, it should be fine though.
I see some limitations mentioned at https://extensions.xwiki.org/xwiki/bin/view/Extension/Replication%20Application/#HLimitations but it doesn’t seem complete, is it?
I indicated a more generic limitation, there is no point listing everything it does not replicate by default (there is not much chance for it to remain up to date).
ok I must have missed it, I only saw Notifications and Subwiki on the doc page.
You did not, I just added that 
Hi all,
Thanks for your replies.
→ I don’t want to install an XWiki replication - the VM is still protected by a GroupProtection manage by VirtualSolution.
→ I alraedy have a MySQL Replica Instance from the MySQL Instance hosted xwiki schema.
I search a solution where i can extract all the article and send all of them on a computer.
Yes it’s a solution.
Is it possible to write a script that exports all xwiki page ?
Thanks for your help,
Matthieu
First, you should know about Loading...
Re the command line, you can do it, see https://www.xwiki.org/xwiki/bin/view/Documentation/UserGuide/Features/Exports#HAdvanced-1
Hi,
With this URL i’m able to export all page as HTML.
http://XXXXXXXXX:8080/bin/export/Space/Page?format=html&pages=%25.%25
But is it possible to export only one page ?
Example : This reference page [xwiki:Bases de données.ORACLE.Erreurs connues.Fix broken oracle job.WebHome]
What is the URL to export this page as html ?
Thanks for your help,
Matt
The pages parameter is a reference, see https://www.xwiki.org/xwiki/bin/view/Documentation/UserGuide/Features/Exports#HAdvanced-1 which contains the syntax and examples.
To find the reference of a page, please see https://www.xwiki.org/xwiki/bin/view/FAQ/How%20can%20I%20get%20the%20reference%20of%20a%20page
Hi,
I’am able to export only on page to html :
http://wikisrv:8081/bin/export/Space/Page?format=html&pages=xwiki:Bases%20de%20données.ORACLE.Erreurs%20connues.Fix%20broken%20%20oracle%20job.WebHome
Do you have some examples to export the page from a curl or wget with authentification ?
THanks for your help,
Matt
Hi,
I tried to create a little script in bash to export page in pdf for DisasterRecovery Mode.
I got the page name with this query in the Database :
SELECT XWD_FULLNAME FROM XWIKIDOC;
After with a curl request i tried to get the page in pdf format :
curl -v -k -u ${WIKI_USER}:${WIKI_PASSWORD} --request GET "${XWIKI_WEB_URL}xwiki:${WIKI_PAGE}" -o ${XWIKI_ROOT_DEGRADE}/export.pdf
I got a message becauase there are some characters with accent and special character in page name :
<!doctype html><html lang="en"><head><title>HTTP Status 400 – Bad Request</title><style type="text/css">body {font-family:Tahoma,Arial,sans-serif;} h1, h2, h3, b {color:white;background-color:#525D76;} h1 {font-size:22px;} h2 {font-size:16px;} h3 {font-size:14px;} p {font-size:12px;} a {color:black;} .line {height:1px;background-color:#525D76;border:none;}</style></head><body><h1>HTTP Status 400 – Bad Request</h1><hr class="line" /><p><b>Type</b> Exception Report</p><p><b>Message</b> Invalid character found in the request target [/bin/export/Space/Page?format=pdf&pages=xwiki:Bases%20de%20donn%C3%A9es.MYSQL.Erreurs%20connues.%20%5BERROR%5D%20%5BMY-012574%5D%20%5BInnoDB%5D%20Unable%20to%20lock%20\.ibdata1%20error\%3A%2011.WebHome%7D%0A ]. The valid characters are defined in RFC 7230 and RFC 3986</p><p><b>Description</b> The server cannot or will not process the request due to something that is perceived to be a client error (e.g., malformed request syntax, invalid request message framing, or deceptive request routing).</p><p><b>Exception</b></p><pre>java.lang.IllegalArgumentException: Invalid character found in the request target [/bin/export/Space/Page?format=pdf&pages=xwiki:Bases%20de%20donn%C3%A9es.MYSQL.Erreurs%20connues.%20%5BERROR%5D%20%5BMY-012574%5D%20%5BInnoDB%5D%20Unable%20to%20lock%20\.ibdata1%20error\%3A%2011.WebHome%7D%0A ]. The valid characters are defined in RFC 7230 and RFC 3986
org.apache.coyote.http11.Http11InputBuffer.parseRequestLine(Http11InputBuffer.java:482)
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:269)
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
java.base/java.lang.Thread.run(Unknown Source)
</pre><p><b>Note</b> The full stack trace of the root cause is available in the server logs.</p><hr class="line" /><h3>Apache Tomcat/9.0.98</h3></body></html>
Example withe page name got accent and specials characters
Bases de données.MYSQL.Erreurs connues. [ERROR] [MY-012574] [InnoDB] Unable to lock \\.ibdata1 error\\: 11.WebHome
Do you know how to pass specials characters to curl request ?
Thanks for your help,
Matt
Did you tried the
--data-urlencode
option for the curl command?
Hi @NorSch
Yes i already tried this - but with this request, the output file is empty
WIKI_PAGE="Bases de données.MYSQL.Erreurs connues. [ERROR] [MY-012574] [InnoDB] Unable to lock \.ibdata1 error\: 11.WebHome"
curl -k -u ${WIKI_USER}:${WIKI_PASSWORD} --verbose --get --data-urlencode "pages=xwiki:${WIKI_PAGE}" "${XWIKI_WEB_URL}" -o test.pdf
Curl Traces
+ curl -k -u : --verbose --get --data-urlencode 'pages=xwiki:Bases de données.MYSQL.Erreurs connues. [ERROR] [MY-012574] [InnoDB] Unable to lock \.ibdata1 error\: 11.WebHome' 'http://mywikiserver:8084/bin/export/Space/Page?format=pdf' -o test.pdf
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0* Trying XX.XX.XX.XX...
* TCP_NODELAY set
* Connected to mywikiserver (XX.XX.XX.XX) port 8084 (#0)
* Server auth using Basic with user ''
> GET /bin/export/Space/Page?format=pdf&pages=xwiki%3ABases%20de%20donn%C3%A9es.MYSQL.Erreurs%20connues.%20%5BERROR%5D%20%5BMY-012574%5D%20%5BInnoDB%5D%20Unable%20to%20lock%20%5C.ibdata1%20error%5C%3A%2011.WebHome HTTP/1.1
> Host: mywikiserver:8084
> Authorization: Basic Og==
> User-Agent: curl/7.61.1
> Accept: */*
>
< HTTP/1.1 302
< Content-Script-Type: text/javascript
< Set-Cookie: JSESSIONID=DAAA4BC3DA17E93640160E77F2E9E703; Path=/; HttpOnly
< Location: /bin/login/XWiki/XWikiLogin;jsessionid=DAAA4BC3DA17E93640160E77F2E9E703?srid=WtiTNDzT&xredirect=%2Fbin%2Fexport%2FSpace%2FPage%3Fformat%3Dpdf%26pages%3Dxwiki%253ABases%2520de%2520donn%25C3%25A9es.MYSQL.Erreurs%2520connues.%2520%255BERROR%255D%2520%255BMY-012574%255D%2520%255BInnoDB%255D%2520Unable%2520to%2520lock%2520%255C.ibdata1%2520error%255C%253A%252011.WebHome%26srid%3DWtiTNDzT
< Content-Language: fr
< Content-Length: 0
< Date: Wed, 12 Feb 2025 06:43:33 GMT
<
0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0
* Connection #0 to host mywikiserver left intact
File is empty
ls -rtl test.pdf
-rw-r--r-- 1 root root 0 12 févr. 07:43 test.pdf
Thanks for your help,
Matt
If you having programming rights the following groovy code helps.
It introduces a redirect to start the pdf output which is received by curl as standard output.
curl must use the “-L” parameter to follow the redirect.
Store the code into a file. It is a bit self describing.
{{groovy}}
if(request.document != null) {
theDoc=xwiki.getDocument(request.document)
if(request.template != null) { template="&pdftemplate=${request.template}" } else { template="" }
response.sendRedirect(theDoc.getExternalURL("export","format=pdf&pdfcover=0&pdftoc=0&pdfheader=0&pdffooter=0&comments=0&attachments=0${template}"))
} else {
print " "+
"use by CURL \n\n" +
"## curl -L -k -u __WIKIUSER:WIKIPASSWORD__ ~--data-urlencode \"document=__~FULLNAME OF WIKI DOCUMENT__\"" +
" \"__${doc.getExternalURL('view').replaceAll(/^(htt.*?:\/)/,'{{{$1}}}')}__\" > __NAME-OF-OUTPUT-PDF-FILE__ ##\n\n" +
"The __underlined parts__ must be set appropriately"
}
{{/groovy}}