Problem with update

Update/Migration/Backup issues
Post Reply
iteng.jorgerodriguez
Posts: 8
Joined: Sat May 19, 2018 2:07 am

Problem with update

Post by iteng.jorgerodriguez » Wed Jul 10, 2019 5:33 pm

Hello Maxim,

Recently updated to latest version but getting mysql access error.

#cat /var/log/onlyoffice/web.log
2019-07-10 11:00:39,846 ERROR [Thread Pool Worker] ASC.Resources - ReplaceLogo
MySql.Data.MySqlClient.MySqlException (0x80004005): Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'localhost' ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Access denied for user 'root'@'localhost'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00096] in <0a135c8e4d604d948724bf6960583b7f>:0
at MySql.Data.MySqlClient.NativeDriver.ReadPacket () [0x00000] in <0a135c8e4d604d948724bf6960583b7f>:0
at MySql.Data.....

# cat /var/www/onlyoffice/WebStudio/web.connections.config
<?xml version="1.0" encoding="utf-8"?>
<connectionStrings>
<clear />
<add name="default" connectionString="Server=localhost;Database=onlyoffice;User ID=root;Password=;Pooling=True;Character Set=utf8;AutoEnlist=false" providerName="MySql.Data.MySqlClient" />

# mysql -u root -p
Enter password: (pressed Enter)
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 290
Server version: 5.7.26-0ubuntu0.16.04.1 (Ubuntu)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| onlyoffice |
| performance_schema |
| sys |
+--------------------+
5 rows in set (0.01 sec)

mysql>


Why is it still failing even though I can access mysql from the console without password?

Maxim
Posts: 1945
Joined: Tue Oct 11, 2016 2:34 pm

Re: Problem with update

Post by Maxim » Thu Jul 11, 2019 11:27 am

Hello iteng.jorgerodriguez!
Please specify what instrcution you followed to install Onlyoffice. Did you install with script?
While installing, the script sets the password. Did you set the password for mysql?

Post Reply