[SOLVED] Seafile / Onlyoffice pptx xslx error

Hello,

On host, i run :

  • seafile 6.2.2
  • onlyoffice 4.4.3

When seafile is access through http, all works fine :
I can edit or create docx, pptx and xslx with onlyoffice

When seafile is access through https,

I can edit document (docx,pptx,xslx) already created or import in Seafile.
I can edit new docx

but I can’t edit new pptx (loading infinite) and new xslx (unknown error).

If I download pptx file, the file is open with libreoffice writer not impress.

For xslx, spreadsheet try to import it as text.

Any idea ?

Thanks
Maud

Hi, did you tried wait some time? Maybe it’s take some time and file is not already commited.

hi, I have wait 5min before open it and nothing change.

What are saying log files?

Only log change is
Seahub.access.log

10.8.6.94 - - [10/Nov/2017:13:44:09 +0000] "GET / HTTP/1.1" 200 25988 "-" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:56.0) Gecko/20100101 Firefox/56.0"
10.8.6.94 - - [10/Nov/2017:13:44:09 +0000] "GET /api/v2.1/notifications/?_=1510321455029 HTTP/1.1" 200 49 "https://seafile.example.com/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:56.0) Gecko/20100101 Firefox/56.0"
10.8.6.94 - - [10/Nov/2017:13:44:09 +0000] "GET /ajax/lib/cfb08e07-9cb4-445e-8611-19cb60d47e5c/dir/?p=%2F&thumbnail_size=48&_=1510321455030 HTTP/1.1" 200 542 "https://seafile.example.com/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:56.0) Gecko/20100101 Firefox/56.0"
10.8.6.94 - - [10/Nov/2017:13:44:15 +0000] "POST /api/v2.1/repos/cfb08e07-9cb4-445e-8611-19cb60d47e5c/file/?p=%2Fghbnythg.pptx HTTP/1.1" 200 178 "https://seafile.example.com/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:56.0) Gecko/20100101 Firefox/56.0"
10.8.6.94 - - [10/Nov/2017:13:44:16 +0000] "GET /lib/cfb08e07-9cb4-445e-8611-19cb60d47e5c/file/ghbnythg.pptx HTTP/1.1" 200 536 "https://seafile.example.com/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:56.0) Gecko/20100101 Firefox/56.0"
172.17.0.1 - - [10/Nov/2017:13:44:17 +0000] "POST /onlyoffice/editor-callback/ HTTP/1.1" 200 22 "-" "-"
172.17.0.1 - - [10/Nov/2017:13:44:44 +0000] "POST /onlyoffice/editor-callback/ HTTP/1.1" 200 22 "-" "-"

Seahub.log

2017-11-10 13:44:15,551 [ERROR] seahub.api2.endpoints.file:199 post [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:590)

In Onlyoffice I have sometimes this log error (docservie/out.log)

[2017-11-10 14:32:09.925] [ERROR] nodeJS - sendServerRequest error: docId = 8e83c69b024213eac548;url = https://10.8.9.109/onlyoffice/editor-callback/;data = {"key":"8e83c69b024213eac548","status":2,"url":"https://10.8.9.109:8052/cache/files/8e83c69b024213eac548_6722/output.docx/output.docx?md5=75s2Tw50P_kihH_5_6VrdA==&expires=1512916330&disposition=attachment&ooname=output.docx","changesurl":"https://10.8.9.109:8052/cache/files/8e83c69b024213eac548_6722/changes.zip/changes.zip?md5=XiMeXRbRzfVw5mIxwJSCRg==&expires=1512916330&disposition=attachment&ooname=output.zip","history":{"serverVersion":"4.4.3","changes":[{"created":"2017-11-10 14:25:59","user":{"id":"uid-1510323940871","name":"truc"}}]},"users":["uid-1510323940871"],"actions":[{"type":0,"userid":"uid-1510324323619"}],"lastsave":"2017-11-10T14:25:59.970Z","notmodified":false}
Error: Error response: statusCode:500 ;body:
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN"
    "http://www.w3.org/TR/html4/strict.dtd">
<html lang="en">
<head>
    <title>Page unavailable</title>
</head>
<body>
    <h1>Page unavailable</h1>

    <p>Sorry, but the requested page is unavailable due to a
    server hiccup.</p>

    <p>Our engineers have been notified, so check back later.</p>
</body>
</html>

    at Request._callback (/var/www/onlyoffice/documentserver/server/Common/sources/utils.js:269:18)
    at Request.self.callback (/var/www/onlyoffice/documentserver/server/Common/node_modules/request/request.js:188:22)
    at emitTwo (events.js:106:13)
    at Request.emit (events.js:191:7)
    at Request.<anonymous> (/var/www/onlyoffice/documentserver/server/Common/node_modules/request/request.js:1171:10)
    at emitOne (events.js:96:13)
    at Request.emit (events.js:188:7)
    at IncomingMessage.<anonymous> (/var/www/onlyoffice/documentserver/server/Common/node_modules/request/request.js:1091:12)
    at IncomingMessage.g (events.js:292:16)
    at emitNone (events.js:91:20)

Do you wan any other log files ?

Add below code to your seahub_settings.py and restart seahub service, it should start working.

VERIFY_ONLYOFFICE_CERTIFICATE = False

Sorry for delay, I have set this option yet and nothing change

Can you open Developer panel and hit CTRL+F5? There should be some error messages in console.

I solved error, this is due to my onlyoffice ssl certificate.
I have disable ssl onlyoffice verifycation with help to this link Onlyoffice - Documents not saved

Thanks for help !