MAILBEE POP3 SMTP WEBMAIL IMAP4 POP IMAP EMAIL COMPONENT VB ASP ACTIVEX COM VBA OCX NET .NET C# VB.NET ASP.NET DOWNLOAD QUEUE SSL SECURITY CENSOR ACCESS PARSER C++ DLL CONTROL LIBRARY MIME INTERFACE

AfterLogic Aurora

AfterLogic Forum : AfterLogic Aurora

Topic: Trouble with onlyoffice

Author

Message

<< Prev Topic | Next Topic >>

solkmaaker
Senior Member

Joined: 28 June 2020
Online Status: Offline
Posts: 163

Posted: 16 May 2021 at 11:45am \| IP Logged

Hi

Aurora is latest version, onlyoffice is latest version.

When i click "edit" window opens and background loads (spreadsheet editor) and then i get message: download failed.
And indeed, nginx log on aurora side shows that documentserver nodejs tried to download file, but got 403 error.
When i try same URL with browser, it works OK.
Some security settings needs to be configured maybe?
Any hints?

solkmaaker
Senior Member

Joined: 28 June 2020
Online Status: Offline
Posts: 163

Posted: 16 May 2021 at 12:40pm \| IP Logged

Well, got it working.

Somehow if i set domain name as parameter for "TrustedServerHost" variable, it did not work.
But if i set IP address, it works.
Weird....

solkmaaker
Senior Member

Joined: 28 June 2020
Online Status: Offline
Posts: 163

Posted: 17 May 2021 at 1:15am \| IP Logged

Still i have one weird problem.

If i open pdf file from mail attachment, it is displayed OK.
But, if i stay in same folder and open same pdf file after about 5 min or so, i'll get dialog box: https://ibb.co/1b81CsW

When i click OK on dialog box, document opens, but content inside is:
{"AuthenticatedUserId":0,"@Time":0.0089,"SubscriptionsResult":null,"@TimeApiInit":0.0082,"@LoggerGuid":"a519fb35","ErrorCode":108,"Module":""}

If i move mail message with attachment to another folder, attachment pdf opens OK, if i move message back to its original folder (where attachment did not open), it opens again.

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104

Posted: 17 May 2021 at 1:48am \| IP Logged

Can you reproduce that on our Aurora Live demo? I have tried a few times, and so far, I wasn't able to.

--
Regards,
Igor, Afterlogic Support

solkmaaker
Senior Member

Joined: 28 June 2020
Online Status: Offline
Posts: 163

Posted: 17 May 2021 at 2:29am \| IP Logged

In Aurora demo, it works.

Could it be that in documentserver side there is some sort of session timeout or something?
Documentserver is configured as described here: https://afterlogic.com/docs/aurora-corporate-8/configuring-webmail/office-document-editor-advanced-configuration
No other changes are made there (except secret).

solkmaaker
Senior Member

Joined: 28 June 2020
Online Status: Offline
Posts: 163

Posted: 17 May 2021 at 2:38am \| IP Logged

in debug mode:

Code:

[09:35:55.25][ed8ded94] PHP[NOTICE]: /var/www/modules/OfficeDocumentEditor/Module.php [line:282, code:8]

[09:35:55.25][ed8ded94] PHP[NOTICE]: Error: Undefined index: UserId

[09:35:55.25][ed8ded94] PHP[NOTICE]: /var/www/modules/OfficeDocumentEditor/Module.php [line:283, code:8]

[09:35:55.25][ed8ded94] PHP[NOTICE]: Error: Undefined index: Type

[09:35:55.25][ed8ded94] PHP[NOTICE]: /var/www/modules/OfficeDocumentEditor/Module.php [line:284, code:8]

[09:35:55.25][ed8ded94] PHP[NOTICE]: Error: Undefined index: Path

[09:35:55.25][ed8ded94] PHP[NOTICE]: /var/www/modules/OfficeDocumentEditor/Module.php [line:285, code:8]

[09:35:55.25][ed8ded94] PHP[NOTICE]: Error: Undefined index: Id

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104

Posted: 18 May 2021 at 4:04am \| IP Logged

There's a known issue with TrustedServerHost value, it's already corrected by the developers and the fix will be in the next release. For now, try setting that value to empty string, does it help?

--
Regards,
Igor, Afterlogic Support

solkmaaker
Senior Member

Joined: 28 June 2020
Online Status: Offline
Posts: 163

Posted: 18 May 2021 at 6:24am \| IP Logged

No, still gives error.

XX.XX.XX.XX is documentserver ip address.

Code:

[13:20:37.85][fc2cf127] [GET][ip:XX.XX.XX.XX]  /?mail-attachment/aheQJ7Xdx_oziUqNban4fo6wFB8SB35CWjq33dVPFOJWhGJTJ6vpJ8fMuq8voS5sZxavBwNOFrSgd2m1DyC0TjIYCKpodKYWI6t-6q2J-kmMJcA7Xb8fcAx2GjsM3INwQNBDDJGRK6wP2ayOp-v3i2eU_na8TNy47RvsQB0u2_JuSPxqZOyqe1 _fqb9MYo432L5XOlP1aVF9-jG1VhLtFnCDkMewZxyGspaz3TeWYyAzv3Htg22Ezc0Vg_8o9f2wPKEjZBOaCMKlwC7EeYQEqtPhOBNOG5pGVQS6-Nha8cL42FkSd_7ZLRCJ2awH8CNioCyRqpxht8hv3lZ2g8el26F5HJEkiZQ1GkWyz8n01dQ_ZZkFNpbM5w4RoZgk5S w2oocGjbQKKvaem31tdOB_maaXnpuBtXjJztrwUrMZj7Q5xnq-gH7UKADd8vAGtyvurOZpVLm_Iq7keOveflpa5ruv3DvNKpuMQgGibN5B4BFw59XU/view/1621343403
 
[13:20:37.85][fc2cf127] POST > []

[13:20:37.85][fc2cf127]

[13:20:37.85][fc2cf127] Exception: ApiException

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104

Posted: 18 May 2021 at 6:27am \| IP Logged

Can you please set LogStackTrace to true in data/settings/config.json configuration file and provide the updated logs? Note that you may need to remove sensitive information from those logs. Thanks.

--
Regards,
Igor, Afterlogic Support

solkmaaker
Senior Member

Joined: 28 June 2020
Online Status: Offline
Posts: 163

Posted: 18 May 2021 at 6:34am \| IP Logged

Code:

[13:31:40.16][91365d8f] PHP[NOTICE]: /var/www/modules/OfficeDocumentEditor/Module.php [line:282, code:8]

[13:31:40.16][91365d8f] PHP[NOTICE]: Error: Undefined index: UserId

[13:31:40.16][91365d8f] PHP[NOTICE]: /var/www/modules/OfficeDocumentEditor/Module.php [line:283, code:8]

[13:31:40.16][91365d8f] PHP[NOTICE]: Error: Undefined index: Type

[13:31:40.16][91365d8f] PHP[NOTICE]: /var/www/modules/OfficeDocumentEditor/Module.php [line:284, code:8]

[13:31:40.16][91365d8f] PHP[NOTICE]: Error: Undefined index: Path

[13:31:40.16][91365d8f] PHP[NOTICE]: /var/www/modules/OfficeDocumentEditor/Module.php [line:285, code:8]

[13:31:40.16][91365d8f] PHP[NOTICE]: Error: Undefined index: Id

Code:

[13:31:42.25][b30d68ef] Aurora\System\Exceptions\ApiException: ApiException in /var/www/system/Api.php:1137

Stack trace:

#0 /var/www/modules/Mail/Module.php(6750): Aurora\System\Api::checkUserRoleIsAtLeast(2)

#1 [internal function]: Aurora\Modules\Mail\Module->EntryDownloadAttachment()

#2 /var/www/system/Router.php(108): call_user_func_array(Array, Array)

#3 /var/www/system/Module/Manager.php(634): Aurora\System\Router->route('mail-attachment')

#4 /var/www/system/Application.php(137): Aurora\System\Module\Manager->RunEntry('mail-attachment')

#5 /var/www/system/Application.php(108): Aurora\System\Application->Route('mail-attachment')

#6 /var/www/index.php(21): Aurora\System\Application::Start()

#7 {main}

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104

Posted: 18 May 2021 at 6:44am \| IP Logged

Thank you. Developers state there's a known issue with viewing attachments, we're now working on a bugfix release; hopefully, it'll be released before the end of the week.

--
Regards,
Igor, Afterlogic Support

solkmaaker
Senior Member

Joined: 28 June 2020
Online Status: Offline
Posts: 163

Posted: 18 May 2021 at 9:49am \| IP Logged

Thank you Igor.

Waiting for update...

solkmaaker
Senior Member

Joined: 28 June 2020
Online Status: Offline
Posts: 163

Posted: 02 June 2021 at 9:52am \| IP Logged

Hi Igor

Any progress on this?

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104

Posted: 04 June 2021 at 4:13am \| IP Logged

Took a bit longer than we expected, have found a few issues and were working on fixing those. Have just rolled out v8.8.2 of Aurora available here - should be working fine for both viewing office document and dealing with them in Files.

Aside from upgrading an existing installation, I'd recommend to try setting up a blank install of Aurora, just to make sure the previous configuration files don't affect the behavior in any way.

Please let us know if the update helps you. Thanks.

--
Regards,
Igor, Afterlogic Support

solkmaaker
Senior Member

Joined: 28 June 2020
Online Status: Offline
Posts: 163

Posted: 04 June 2021 at 6:12am \| IP Logged

Hi Igor

Unfortunately result is still same with mail attachment.
First time it opens OK, after a while it doesnt any more.

PHP notice lines are gone from log now, but stacktrace remains:

Code:

[13:09:00.36][7e5ddbf9] Aurora\System\Exceptions\ApiException: ApiException in /var/www/system/Api.php:1137

Stack trace:

#0 /var/www/modules/Mail/Module.php(6750): Aurora\System\Api::checkUserRoleIsAtLeast(2)

#1 [internal function]: Aurora\Modules\Mail\Module->EntryDownloadAttachment()

#2 /var/www/system/Router.php(108): call_user_func_array(Array, Array)

#3 /var/www/system/Module/Manager.php(634): Aurora\System\Router->route('mail-attachment')

#4 /var/www/system/Application.php(137): Aurora\System\Module\Manager->RunEntry('mail-attachment')

#5 /var/www/system/Application.php(108): Aurora\System\Application->Route('mail-attachment')

#6 /var/www/index.php(21): Aurora\System\Application::Start()

#7 {main}

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104

Posted: 04 June 2021 at 7:20am \| IP Logged

I have tried reproducing this on two different installations of Aurora, and it just works as expected.

To make sure we're on the same page: I open email message with PDF attachment, it opens fine (using OnlyOffice Docs viewer), I close the viewer and stay on the same message, and after 5-10 minutes I click "View" on that same attachment again, this is where I'm supposed to see the error. Is that correct?

I have two more questions: is the issue specific to viewing mail attachments? I mean, if you try viewing .PDF in Files, does it work correctly there? Also, do you encounter any issues with a default viewer, when OnlyOffice integration is disabled?

--
Regards,
Igor, Afterlogic Support

solkmaaker
Senior Member

Joined: 28 June 2020
Online Status: Offline
Posts: 163

Posted: 04 June 2021 at 9:13am \| IP Logged

Yes, your description is correct.

And also yes, issue is specific to mail attachments, if file is located in Files, everything works OK all the time.
And in case of attachments, you don't have to stay on same page, you can even log out and later log back in and you still cannot view attachment any more. In conclusion: you can view it only once.
But, if you move mail message to some other folder, then you can view attachment again, but again after 5min, you cannot view attachment any more.
And if you then move message back to its original folder, you can view attachment again, but again, after ~5min, you cannot view it any more.
Also, if you cannot view attachment any more, what helps is just moving message to other folder and back, then you can view attachment again.

Browser internal pdf viewer works ok, (if i disable onlyoffice integration).
Also, i have nextcloud instance connected with same secret to same onlyoffice instance and in nextcloud side also everything works OK all the time.

Tests are done in our test instance, which have been upgraded in the past from version to version.
I'm now doing clean install (with clean db) test. If clean install is ok, then we can rule code problems out, and in that case we have to look settings or database. I also tried to create new user account, to see if that helps, but it suffered same behavior as already existing accounts.
I'll let you know of the results.

solkmaaker
Senior Member

Joined: 28 June 2020
Online Status: Offline
Posts: 163

Posted: 04 June 2021 at 11:15am \| IP Logged

Unfortunately clean install did not help.
What i did:

Code:

1. Downloaded and unpacked aurora to /var/www

2. Logged in to aurora UI as superadmin and changed superadmin username and set password

3. Created mysql database and user

4. In aurora admin UI, saved DB credentials

5. In aurora admin UI, clicked "create/update tables" and "update configuration"

6. In aurora admin UI, enabled debug logging and set verbosity to debug and enabled user activity logging

7. In aurora admin UI, entered my license key

8. In aurora admin UI, created mail server (name, domain, imap ip, smtp ip)

9. Changed in settings/config.json file LogStackTrace to true

10. Changed in settings/modules/OfficeDocumentViewer.config.json file Disabled to true

11. Changed in settings/modules/Office/document/Editor.config.json file Disabled to false, DocumentServerUrl to https:\/\/office.mydomain.com, Secret to mysecret, TrustedServerHost to office.mydomain.com

12. Logged to aurora as normal user (user already existed on IMAP server)

13. Opened mail attachment (xslx file) from message that was in INBOX - onlyoffice window opened OK with document inside

14. Closed onlyoffice window and waited 5 minutes

15. Tried to open same attachment again - opening failed with:

[18:10:42.44][2ddc9580] Aurora\System\Exceptions\ApiException: ApiException in /var/www/system/Api.php:1137

Stack trace:

#0 /var/www/modules/Mail/Module.php(6750): Aurora\System\Api::checkUserRoleIsAtLeast(2)

#1 [internal function]: Aurora\Modules\Mail\Module->EntryDownloadAttachment()

#2 /var/www/system/Router.php(108): call_user_func_array(Array, Array)

#3 /var/www/system/Module/Manager.php(634): Aurora\System\Router->route('mail-attachment')

#4 /var/www/system/Application.php(137): Aurora\System\Module\Manager->RunEntry('mail-attachment')

#5 /var/www/system/Application.php(108): Aurora\System\Application->Route('mail-attachment')

#6 /var/www/index.php(21): Aurora\System\Application::Start()

#7 {main}

solkmaaker
Senior Member

Joined: 28 June 2020
Online Status: Offline
Posts: 163

Posted: 04 June 2021 at 11:59am \| IP Logged

What i also did was:
When 5min passed, i changed OfficeDocumentEditor.config.json to second onlyoffice server, to see if maybe it is onlyoffice server problem. (Second server does not use secret)
But then when i tried to open attachment (that failed on first onlyoffice server) it did not open (this was first query to second server), error message was exactly same as previously.
This indicates that problem is not on onlyoffice server side.
After moving message to other folder and back to inbox, second onlyoffice server displayed attachment correctly, but again, after 5min again attachment cannot be displayed.

solkmaaker
Senior Member

Joined: 28 June 2020
Online Status: Offline
Posts: 163

Posted: 04 June 2021 at 12:36pm \| IP Logged

And one more thing i noticed.
In aurora demo (hosted by afterlogic), when you open attachment, viewer has different URL after "?editor=mail-attachment%2F", but in my server, that part remains always same.
It only changes after i move message to different folder.
This may be reason why it works on aurora demo server and not in mine.
Any ideas, why URL does not change in my server?

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104

Posted: 08 June 2021 at 5:34am \| IP Logged

Got it, thank you, I've asked the developers to look into this. Will get back to you once there are news.

--
Regards,
Igor, Afterlogic Support

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104

Posted: 09 June 2021 at 12:11am \| IP Logged

Developers have provided a small update for Aurora Corporate v8.8.2, you can download it here; please backup your static/js directory and replace it with the package content. You'll also need to set "UseAppMinJs" to false in data/settings/config.json file, and clear web browser cache to make sure the changes apply.

Please let us know if the update helps you. Thanks!

--
Regards,
Igor, Afterlogic Support

solkmaaker
Senior Member

Joined: 28 June 2020
Online Status: Offline
Posts: 163

Posted: 09 June 2021 at 4:14am \| IP Logged

Hi Igor.

Unfortunately it did not help. URL parameters still remain always same for attachment view (unlike in Aurora demo) and after 5 min or so, i'll get same error as before.

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104

Posted: 09 June 2021 at 4:25am \| IP Logged

Would it be possible to provide access credentials so we could reproduce the issue on your installation? Please send those via HelpDesk. Thank you.

--
Regards,
Igor, Afterlogic Support

solkmaaker
Senior Member

Joined: 28 June 2020
Online Status: Offline
Posts: 163

Posted: 09 June 2021 at 1:38pm \| IP Logged

I'm sorry Igor.

It seems that my browser cache was not empty. :(
After applying update and cleaning cache properly, it works OK.
Url parameters are different every time attachment is viewed and now this 5min problem is gone.

Will this update be integrated into next version?

Page of 2 Next >>

Printable version

Forum Jump

.NET Components

ActiveX Components

Web scripts

Solutions

AfterLogic Aurora