Bug 143893 - wiki publisher gives server connection error
Summary: wiki publisher gives server connection error
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Extensions (show other bugs)
Version:
(earliest affected)
7.1.5.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-08-16 07:56 UTC by pharmankur
Modified: 2023-09-22 18:38 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Mediawiki Setting in Libreoffice Options (51.21 KB, image/png)
2021-08-16 07:58 UTC, pharmankur
Details
Wiki Publisher login error (217.91 KB, image/jpeg)
2022-03-30 12:56 UTC, mail
Details

Note You need to log in before you can comment on or make changes to this bug.
Description pharmankur 2021-08-16 07:56:49 UTC
Description:
--- Linux Mint 19.3 ; Libreoffice 7.1.5 ---

We have running mediawiki server. We use that WIKI for our internal documentation purpose and it runs well through web browser.

I was glad that Libreoffice has provided in built in wiki publisher extension. This is supposed to publish our documents prepared in Libreofice to the Mediawiki server we have set. [ By using WRITER option File --> Send --> To Mediawiki ]

For the setting of MediaWiki server connection Libreoffice has provided Tools --> Options --> Internet --> MediaWiki

There you have to Add --> URL (Mediawiki) --> User Name --> Password

But when you add correct URL and valid username - password it gives error

A connection to the MediaWiki system at 'http://XXX.XX.XXX.XXX:PPP/MediaWiki/index.php' could not be created.

I have checked multiple times that server URL, Login, Password are correct. Its is running well in browser only Libreoffice is not able to make contact with it. 

I have found SAME issue reported on -
https://ask.libreoffice.org/t/mediawiki-extension-server-url-invalid/8477

I have provided screenshot for the setting option.

Unfortunately as our MediaWiki instance is a Production Documentation I cannot share server details to test it for others.

I understand that its is a tough bug to detect and work on as you need to have MediaWiki instance (with valid logins) up and running. [ Or may be just use WIKIPEDIA to test it ... I am not sure ! ]

But if this functionality works smoothly, I presume it will be a sure DEAL MAKER for wider adoption of LIBREOFFICE and MEDIAWIKI in large corporates.

Steps to Reproduce:
1. Go to Tools --> Options --> Internet --> MediaWiki
2. Add --> URL (Mediawiki) --> User Name --> Password
3. You will get Connection Error -- 
A connection to the MediaWiki system at 'http://XXX.XX.XXX.XXX:PPP/MediaWiki/index.php' could not be created.

Actual Results:
NOT GETTING CONNECTED TO MEDIAWIKI SERVER (Which is accessible by other web browsers on same URL)

Expected Results:
Should get connected and upload Libreoffice Articles DIRECTLY to MEDIAWIKI under provided USER LOGIN


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.5.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-IN (en_IN); UI: en-GB
Ubuntu package version: 1:7.1.5~rc2-0ubuntu0.18.04.1~lo1
Calc: threaded
Comment 1 pharmankur 2021-08-16 07:58:00 UTC
Created attachment 174307 [details]
Mediawiki Setting in Libreoffice Options
Comment 2 Julien Nabet 2021-08-18 18:34:58 UTC
On pc Debian x86-64 with master sources updated today, I tried with my account on Wikipedia, whereas login/password is ok, I got:
"User name or password is incorrect. Please try again, or leave the fields blank for an anonymous connection."

I had fixed some bugs about Mediawiki but I don't remember if I used this or not.
Anyway, looking at the code, I don't understand why it doesn't work.
Comment 3 Julien Nabet 2021-08-18 19:16:01 UTC
Just for the record, I could save a website for Mediawiki when I put no login/password.

Michael: do you succeed in declaring a website for mediawiki with a user account?
I took a look at swext/mediawiki/src/com/sun/star/wiki/Helper.java and don't know what's wrong.
Comment 4 mail 2022-03-30 12:50:48 UTC
I'm on Windows 10, using LO 

Version: 7.3.1.3 (x64) / LibreOffice Community
Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL

I try to add a connection to my own hosted MediaWiki using the included Wiki Publisher 1.2.0, but always fail with error

"Username or password incorrect..."

My MediaWiki is set to editing only for logged in users, so no anonymous access!

MediaWiki 	1.37.1
PHP 	7.4.28 (cgi-fcgi)
MySQL 	5.7.37-1
ICU 	63.1

I activated loggin in my MediaWiki, and it seems that Wiki Publisher is transmitting my ip address instead of the entered user name, which of course triggers the "Username incorrect" message, since I don't have ip addresses in my Wiki user database.

Any ideas on how to fix this and use Wiki Publisher as intended?
Comment 5 mail 2022-03-30 12:56:11 UTC
Created attachment 179209 [details]
Wiki Publisher login error
Comment 6 Julien Nabet 2022-03-30 19:47:35 UTC
I gave a new try with https://wiki.documentfoundation.org/, url, username and passsword are ok but it still fails.
At least for this website, I think it's because SSO connection hasn't been implemented in LO.
No idea how to do this=>uncc myself.
Comment 7 Dennis Roczek 2023-09-22 18:38:47 UTC
I get no error message at all, but the pages (wikipedia, TDF wiki) are not created (trying in user page space) using...


Version: 7.6.1.2 (X86_64) / LibreOffice Community
Build ID: 60(Build:2)
CPU threads: 4; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Ubuntu package version: 4:7.6.1~rc2-0ubuntu0.22.04.1~lo2
Calc: threaded


The web browser opens, but no created page ("Wikipedia does not have a user page with this exact name. Before creating this page, please see Wikipedia:Subpages.") nor anything in the user contributions.

I will try a clean test tomorrow and check what wireshark is collecting on the pages.