ONLYOFFICE Docs v6.4 with conditional formatting, new scaling options, and WOPI protocol support
ONLYOFFICE Docs v6.4 released

Scheduled report sending by email in Project module

I want to ask a how-to question about sending scheduled reports by email.
As i read in topics about reports i can do scheduled report and this report must be sent by email to user, who generated this report in project.
So i’ve created a schedule report, set time of schedule report and save it. And at this appointed time nothing happened. The scheduled generataed reports even don’t appear in My document folder (should they?), while usual report generated manualy appears in this folder.
Addititonal information: usual reports are generated in normal condition, so document server works fine, every of tested users receive notification of closed or opened task in project, so configured SMTP should work allright.
Can you please tell me where should i look at? Log files: mail.agg.errors.log, mail.agg.log, mail.cln.log, mail.dog.log don’t have any errors at that time, only information messages in other time like “All mailboxes were processed” and “Waiting for 6 minutes for next check” (as i think it is normal). Maybe i should add Mail module on my server? but i thought SMTP configuration is enough, because we have our own mail server. Can you help me with this problem?
Thank you in advance!
Community Server version: v11.1
Type of installation of Workspace: manual installation
OS: Centos 7
Browser version: Chrome, Firefox and Edge latest versions

Hello titarenko.

Please check the date and time on the server. If there’re no issues (the time is the same as yours), then please reproduce the situation and provide us with whole Community Server logs folder.

By the way, is it possible to make portal update? Probably we should start with this step and double-check that issue still persists after update. Community server v.11.1 was released 5 month ago. We always recommend to make update to the actual versions, because actual versions contain new features and fixes for known bugs.

In case of update, please prepare whole server backup. If something goes wrong during update process, you will be able to rollback to current station.

Also please let us know your portal installation type (docker or package) and versions of Control Panel and Document server. Please note, that Control Panel must be updated too. Control Panel version is strongly dependent on the version of Community server. In case of upgrade via Control Panel (docker installation), you should upgrade Control Panel before starting Community server update.

Also how did you perform installation, point me to the link to the guide you used.

Thank you so much for your answer.

The date and time is ok.
I was using this manual: Installing ONLYOFFICE Groups for Red Hat, CentOS, and derivatives - ONLYOFFICE
I used the manual installation (without using script and no docker).

Truely i don’t know what verson was installed. And as i see in this link, onlyoffice has version v11.1 and i thought that it is final version, but as i see now on github there is v11.5.2 released on 13 July. But i don’t know how to update to this version (control pannel don’t have any choises to do this). But i’ll try, please if you can, give me more info about updating. Truely, i don’t know how to watch my current version of Onlyoffice Docs and Onlyoffice Groups in web interface (or can i find it in any other way (CLI?)).
I even don’t know how to do make update of control pannel but i know what version of Control pannel i used (version 3.0.0.381) Is it the last version of Control Pannel?

As you see in other post, i can’t do backup in web interface. So i’ll try to do mysql backup and backup of files in folder /var/www/onlyoffice. I will try to find some info about updating to latest version. Thank you in advance for giving more info.

1 Like

Please run

yum list installed | grep onlyoffice

to check versions of installed components. Please show us the result. If you deployed portal recently, then it is updated to the actual version by now.

So i’ll try to do mysql backup and backup of files in folder /var/www/onlyoffice.

It’s temporal solution. We need to understand what is going wrong. Please reproduce the issue and provide Community Server logs folder.

Thank you for fast answer!
Maybe i was mistaken while installation. But when i saw some results of insallation i was so happy so i did not check other results. Only then i understood that i need document server and other things.

As i see version is latest.

[root@onlyoffice ~]# yum list installed | grep onlyoffice
onlyoffice-communityserver.noarch
11.5.2-460 @onlyoffice
onlyoffice-controlpanel.noarch 3.0.0-381 @onlyoffice
onlyoffice-repo.noarch 1.0.0-11 @/onlyoffice-repo.noarch
onlyoffice-xmppserver.noarch 11.0.0-107 @onlyoffice

Onlyoffice-docs:
[root@docs ~]# yum list installed | grep onlyoffice
Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast
onlyoffice-documentserver.x86_64 6.3.1-32 @onlyoffic
onlyoffice-repo.noarch 1.0.0-11 @/onlyoffice-repo.noarch

Sorry, how can i send you archive with logs? Can i do it by e-mail for security purposes? Also i can’t send archive overhere because .zip attachment is not supported (as i see). On which address can i send logs?

[root@onlyoffice ~]# yum list installed | grep onlyoffice

onlyoffice-communityserver.noarch

11.5.2-460 @onlyoffice

onlyoffice-controlpanel.noarch 3.0.0-381 @onlyoffice

onlyoffice-repo.noarch 1.0.0-11 @/onlyoffice-repo.noarch

onlyoffice-xmppserver.noarch 11.0.0-107 @onlyoffice

That’s right, there’s no Document server. Do you have an external one? Please go to portal settings > Integration > Document Service > make a screenshot of this page.

As for logs, you can send the archive to me via direct message. If the archive weight is big, please upload it to some external storage and provide me with a download link.

Ah, I didn’t notice information about Document server. Is it installed separately?

Yes, it was intalled separetly. I gave information about it later. Sorry, i have edited the message:
Onlyoffice-docs:
[root@docs ~]# yum list installed | grep onlyoffice
Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast
onlyoffice-documentserver.x86_64 6.3.1-32 @onlyoffic
onlyoffice-repo.noarch 1.0.0-11 @/onlyoffice-repo.noarch

Ok, please reproduce the issue and send me Community server logs folder via direct message.

Continuing the discussion from [Scheduled report sending by email in Project module]

I can’t sent a message to you, so i drop the link here. Sorry for delay. And sory for using this fileshare, Messages inside forum don’t give me the rights to share archives. Link to download: DropMeFiles - быстрый файлообменник

(post deleted by author)

Hello titarenko.

I’m posting the same answer in both of your posts for other users to see.

First of all, please accept our apologies for the current situation. We double-checked the guide for manual installation which you pointed us to and we realized that it is not relevant at the moment. This guide is in the process of being updated. Installation via script is OK, but not the manual one.

Please be assured that we will update this guide.

We can offer the following solution to the situation at the moment: make MySQL DB dump, copy Data folder from the portal and restore it on new installation (installation via script).

Please follow my steps to do it:

  1. Make a MySQL dump. Use command mysqldump -u root -p<password> --databases onlyoffice > db_backup.sql

You can check password here: /var/www/onlyoffice/WebStudio/web.connections.config

Copy the dump to external storage.

Command to restore the dump on the new portal: mysql -u root -p < db_backup.sql

  1. Copy Data folder to the external storage:/var/www/onlyoffice/Data/

  2. Install new portal (Groups) via script. You can find it on the same page which you pointed earlier. Place data folder in the same location and restore MySQL dump.

NB! If you intend to use the current server for new portal installation (rollback to zero state) then we strongly recommend to make whole server backup. If something goes wrong during the described actions, you will be able to rollback to the current state.

After the described actions please check if the issues still persist.

Sorry for inconvenience.

2 Likes

Thank you for your answer! Don’t worry, i started it again and tested script installation in this morning, but it was a problem with firewalld. Usualy i stop it before installation (as selinux), but after installation was error in CLI, that firewall stoped, so i did’t receive success result in CLI and web insterface gave me 502 Bad Gateway error.
But at second installation right now i leave firewall enabled and result of installation in CLI was successful (almost - something wrong with mysql), but now it wrote that installation completed.
The reult, that i received:

WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
  Verifying  : 1:nginx-1.20.1-2.el7.x86_64                                                      1/6
  Verifying  : onlyoffice-communityserver-11.5.2-460.noarch                                     2/6
  Verifying  : gperftools-libs-2.6.1-1.el7.x86_64                                               3/6
  Verifying  : 1:openssl11-libs-1.1.1g-3.el7.x86_64                                             4/6
  Verifying  : 1:nginx-filesystem-1.20.1-2.el7.noarch                                           5/6
  Verifying  : centos-indexhtml-7-9.el7.centos.noarch                                           6/6

Installed:
  onlyoffice-communityserver.noarch 0:11.5.2-460

Dependency Installed:
  centos-indexhtml.noarch 0:7-9.el7.centos          gperftools-libs.x86_64 0:2.6.1-1.el7
  nginx.x86_64 1:1.20.1-2.el7                       nginx-filesystem.noarch 1:1.20.1-2.el7
  openssl11-libs.x86_64 1:1.1.1g-3.el7

Complete!
spawn communityserver-configure.sh
Configuring MySQL access...
Host: 127.0.0.1
Database name: onlyoffice
User: root
Password:
Trying to establish MySQL connection... FAILURE
6144+0 records in
6144+0 records out
6442450944 bytes (6.4 GB) copied, 170.412 s, 37.8 MB/s
Setting up swapspace version 1, size = 6291452 KiB
no label, UUID=c7946008-8c94-44ac-8160-5b59bbee9660
firewalld-0.6.3-13.el7_9.noarch
success
success

Thank you for installing ONLYOFFICE.
You can now configure your portal using the Control Panel
In case you have any questions contact us via http://support.onlyoffice.com or visit our forum at http://dev.onlyoffice.org

But in fact on web interface again there is an error:

Error 502. App Crash

The server was unable to complete your request

So i stucked again(
Maybe you can say what is the problem? Maybe after script installation i need some aditional actions? Maybe problem with mysql? Because no database “onlyoffice” created. I have installed mysql 8.0 before running script. Maybe onlyoffice don’t know where to get root password for mysql? I will try again to install onlyoffice , but not to install mysql before and i will give you an answer later.
And if i remeber right, last time i tried to install it by script with no pre installed of mysql and got the same error, that’s why i tried manual installation.
Still Centos 7
Thank you in advance!

1 Like

I have installed mysql 8.0 before running script. Maybe onlyoffice don’t know where to get root password for mysql? I will try again to install onlyoffice , but not to install mysql before and i will give you an answer later.

Please note that we always recommend to use totally clean server for installation process. It’s necessary to avoid dependency and port conflicts. In case of using installation script, the script will install all necessary components. Please reproduce your installation test with clean OS.

By the way, about SELinux (you mentioned it before). You can face the issue which is related to Centos 7 minimal installation and SELinux. We have description about it here in “CentOS issues” category: Troubleshooting. Server Solution - ONLYOFFICE

Probably it will be handy.

1 Like

Great! Thank you so much!
I even did not disabled selinux. Only installed wget and script done everything, that i wanted. Right now server works correctly and i even can see backup menu in control pannel. So i will write in topic about it, when i will check all functions.

So the right way is:

  1. no yum update before script installation
  2. no selinux disabled
  3. no firewall disabled
  4. only installing of wget and 2 commands to install script.

Thank you. I will get some users and tasks and try to do reports and scheduled reports and i will write in this topic about results. Thank you so much again!

We are glad that the installation issue is solved.

no yum update before script installation

Yes, I think this is not a necessary command in case of using latest OS image for deployment.

I will get some users and tasks and try to do reports and scheduled reports and i will write in this topic about results.

We’ll be waiting for your test result.

1 Like

Thank you so much! All works correctly! Generated report was sent by email exactly at time! Sorry if i was disturbing.
Thank you for fast answers!
Have a good day!

2 Likes