search

ONLYOFFICE / CommunityServer

Free open source office suite with business productivity tools: document and project management, CRM, mail aggregator.
http://www.onlyoffice.com
Apache License 2.0
2.73k stars 617 forks source link

I can't log to onlyoffice workspace. Login screen is looping. #398

Open mastipgithub opened 2 years ago

mastipgithub commented 2 years ago

I updated my docker instance on debian by workspace-install script from 11 version to 12. I used command bash workspace-install.sh -u true -ics true -ids true -icp true -ims true

I can't log to onlyoffice workspace. Login screen is looping. I enter loging details and screen is looping and i can write loging details again. Nothing changes. weblog

I tried to update portal few times. Last time I turn of 2-step verification. Always the same, I am stuck on login screen.

Carazyda commented 2 years ago

Hello @mastipgithub Please describe in more details how did you install Onlyoffice Workspace? Have you changed your database connection settings? Are you using an external database? try running the update sql script on the database onlyoffice for the new version - /var/www/onlyoffice/Sql/onlyoffice.upgradev120.sql.

mastipgithub commented 2 years ago

First version of portal I installed by this method https://helpcenter.onlyoffice.com/installation/workspace-install-docker-integrated.aspx. This was time when there was no control panel and elastic search containers. I made folders for binding volumes, installed containers: mysql 5.7 db , document server, email server, community server. I have naver used email server but it was installed. Then I upgraded portal by workspace-script to never version few times. But after update from 11.5 to 12 i can't login.

mastipgithub commented 2 years ago

How to start this script? I have logged to community server container by command docker exec -it containername bash Found script file in folder /var/www/onlyoffice/Sql/

Carazyda commented 2 years ago

Try this command (password and user you can see in the /var/www/onlyoffice/WebStudio/web.connections) mysql -u root -pmy-secret-pw -h onlyoffice-mysql-server onlyoffice</var/www/onlyoffice/Sql/onlyoffice.upgradev120.sql

mastipgithub commented 2 years ago

It works. Thank You Man. You made my day.

mastipgithub commented 2 years ago

hmm I have another problem with my document folder files

document problem

This documents was assigned to my projects. I can't open documents for any projects now.

Do I need update something else? Document server 7.1 was working ok with community server 11.5.

Carazyda commented 2 years ago

Sorry, I didn't see that you had version 11.5 You also need to run this script: mysql -u root -pmy-secret-pw -h onlyoffice-mysql-server onlyoffice</var/www/onlyoffice/Sql/onlyoffice.upgradev116.sql

mastipgithub commented 2 years ago

It works now. So every time after workspace-script update I need start new script from sql folder to update database?

Carazyda commented 2 years ago

No, this is done automatically when the community server is updated. Why it didn't work for you, I'm at a loss to answer. Perhaps you still changed the default settings for connecting to the database. And we don't change the database that often, only in major updates.