Error Install without docker ubuntu 18.04

[snjikari]

In the process the command use is:

bash workspace-install.sh -ims false

them choice options without docker (N), start the process for installation, in the process installation onlyoffice-communityserver out one error exit 1 error in tables, and not following process installation. please perform the installation review without docker with single script process. thk. Carlos G

[Carazyda]

Hello @snjikari Issue in MySQL Server v8.0.29 (Bug 56925 in our private bug tracker). We will fix this soon.

[ViktorBobanych78]

ERROR 1118 (42000) at line 1512: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
dpkg: error processing package onlyoffice-communityserver (--configure):
 installed onlyoffice-communityserver package post-installation script subprocess returned error exit status 1
E: Sub-process /usr/bin/dpkg returned an error code (1)

community server does not install on ubuntu 20.04, 22.04, 18.04 how do i fix this bug? o how i install mysql server not 8.0.29 RUS После обновления mysql server обвалился сервер с документами!!!

[Pinna3]

Is there an older version of the software available for an ubuntu installation while we wait for the bug to be fixed? I'm currently unable to install Only Office Workspace on an ubuntu server...

[Carazyda]

As I said - the problem is in MySQL Server v8.0.29. You can install from MySQL 8.0.28 or older version of it. A new version of Onlyoffice will be released soon with a fix for MySQL 8.0.29.

[Pinna3]

Right but how does one do that? There are 2 steps to installation provided on the website:

$ wget https://download.onlyoffice.com/install/workspace-install.sh
$ bash workspace-install.sh -md "yourdomain.com"

What do I need to change in that installation script to install an older version of MySQL or what steps do I need to take? Can I downgrade MySQL after the broken version gets installed by that script? I'm unclear about how to do what you're suggesting.

[Carazyda]

Sorry, but we don't have a ready-made solution for the deb version. You can use an external MySQL server of the required version. But the easiest way is to wait for the new version, which will be released very soon.

[ViktorBobanych78]

I solved the problem with installing and updating (breakage after updating Mysql to version 8.0.29), on Ubuntu 20.04. --1 Installation on a clean system: Make it so that the package and components of Mysql version 8.0.29 are not installed. In Ubuntu 20.04, the Mysql package with version 8.0.19 is available for installation.

$ sudo apt-cache policy mysql-server

mysql-server:
  Установлен: (отсутствует)
  Кандидат:   8.0.29-1ubuntu20.04
  Таблица версий:
     8.0.29-1ubuntu20.04 500
        500 http://repo.mysql.com/apt/ubuntu focal/mysql-8.0 amd64 Packages
     8.0.29-0ubuntu0.20.04.3 500
        500 http://ua.archive.ubuntu.com/ubuntu focal-updates/main amd64 Packages
        500 http://ua.archive.ubuntu.com/ubuntu focal-updates/main i386 Packages
        500 http://ua.archive.ubuntu.com/ubuntu focal-security/main amd64 Packages
        500 http://ua.archive.ubuntu.com/ubuntu focal-security/main i386 Packages
     8.0.28-1ubuntu20.04 500
        500 file:/home/bmw/repo ./ Packages
     8.0.19-0ubuntu5 500
        500 http://ua.archive.ubuntu.com/ubuntu focal/main amd64 Packages
        500 http://ua.archive.ubuntu.com/ubuntu focal/main i386 Packages

If the installation candidate has version 8.0.29, then we treat it. Edit or create a package manager file for Mysql.

$ sudo nano /etc/apt/preferences.d/mysql

Insert these lines.

Package: libmysqlclient* mysql*
Pin: version 8.0.29*
Pin-Priority: -1

Package: *
Pin: origin ch.archive.ubuntu.com
Pin-Priority: 700

Package: *
Pin: origin security.ubuntu.com
Pin-Priority: 800

Save the file and check the output for "$ sudo apt-cache policy mysql-server" . The installation candidate version has changed. Then you can install from a standard script.

--2 If there was an unsuccessful installation attempt, or a server crash after updating Mysql to version 8.0.29 *, you will need to perform the following actions: If the community server was installed earlier, make a backup copy of the data. After that, completely remove mysql and all its components, as well as the onlyoffice packages.

$ sudo apt-get remove --purge mysql*
$ sudo apt-get purge mysql*
$ sudo apt-get autoremove
$ sudo apt-get autoclean
$ sudo apt-get remove dbconfig-mysql
$ sudo apt-get dist-upgrade
$ sudo apt-get remove --purge onlyoffice*
$ sudo apt-get purge onlyoffice*
$ sudo apt-get autoremove
$ sudo apt-get autoclean
$ sudo apt-get remove dbconfig-mysql
$ sudo apt-get dist-upgrade

Install onlyoffice from a standard script.

$ sudo bash workspace-install.sh -u true

Restore data from backups. Database and user files.

[Pinna3]

Wow, thank you! I'll try it now.

[serinemsas]

ok thk @ViktorBobanych78