onlyoffice-communityserver package 9.6.3-173 update issues

[marcelsk_br]

Hello,

I currently have OnlyOffice Community Server installed under CentOS 7 with nginx.

After updating the onlyoffice-communityserver package 9.6.2-171 from to 9.6.3-173, its no longer working.
The error message is:

Application Exception
Runtime Error
A runtime error has occurred

Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed (for security reasons).

Details: To enable the details of this specific error message to be viewable, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".

<!-- Web.Config Configuration File -->

<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>


Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.

<!-- Web.Config Configuration File -->

<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration>

Version Information: 5.12.0.301 (tarball Fri Jul 20 15:09:05 UTC 2018); ASP.NET Version: 4.0.30319.42000

Also, there are a lot of Access Denied error messages on the MySQL log (mysqld.log):

Version: '5.7.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server - (GPL)
2018-08-03T04:30:27.297105Z 35 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2018-08-03T04:30:27.297203Z 38 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2018-08-03T04:30:27.297634Z 36 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2018-08-03T04:30:27.297818Z 37 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2018-08-03T04:30:27.480855Z 39 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2018-08-03T04:30:27.525161Z 40 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2018-08-03T04:30:27.537011Z 41 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2018-08-03T04:30:27.557591Z 42 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2018-08-03T04:30:27.580563Z 43 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2018-08-03T04:30:27.593914Z 44 [Note] Access denied for user 'root'@'localhost' (using password: NO)

Additional logs:

2018-08-03 01:30:30,086 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' (using password: NO) ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Access denied for user 'root'@'localhost' (using password: NO)
at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00096] in <0a135c8e4d604d948724bf6960583b7f>:0
at MySql.Data.MySqlClient.NativeDriver.ReadPacket () [0x00000] in <0a135c8e4d604d948724bf6960583b7f>:0
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket () [0x00000] in <0a135c8e4d604d948724bf6960583b7f>:0
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.AuthenticationFailed (System.Exception ex) [0x0003f] in <0a135c8e4d604d948724bf6960583b7f>:0
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket () [0x0000f] in <0a135c8e4d604d948724bf6960583b7f>:0
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate (System.Boolean reset) [0x00097] in <0a135c8e4d604d948724bf6960583b7f>:0
at MySql.Data.MySqlClient.NativeDriver.Authenticate (System.String authMethod, System.Boolean reset) [0x0002a] in <0a135c8e4d604d948724bf6960583b7f>:0
at MySql.Data.MySqlClient.NativeDriver.Open () [0x00320] in <0a135c8e4d604d948724bf6960583b7f>:0
at MySql.Data.MySqlClient.Driver.Open () [0x0000b] in <0a135c8e4d604d948724bf6960583b7f>:0
at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x0004e] in <0a135c8e4d604d948724bf6960583b7f>:0
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection () [0x00000] in <0a135c8e4d604d948724bf6960583b7f>:0
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection () [0x0008a] in <0a135c8e4d604d948724bf6960583b7f>:0
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x0003f] in <0a135c8e4d604d948724bf6960583b7f>:0
at MySql.Data.MySqlClient.MySqlPool.GetConnection () [0x0001c] in <0a135c8e4d604d948724bf6960583b7f>:0
at MySql.Data.MySqlClient.MySqlConnection.Open () [0x0016d] in <0a135c8e4d604d948724bf6960583b7f>:0
at ASC.Common.Data.AdoProxy.DbConnectionProxy.Open () [0x00019] in <36581e6887064d56b05ff22b7d2875ec>:0
at ASC.Common.Data.DbManager.OpenConnection () [0x000b2] in <36581e6887064d56b05ff22b7d2875ec>:0
at ASC.Common.Data.DbManager.get_Command () [0x0000e] in <36581e6887064d56b05ff22b7d2875ec>:0
at ASC.Common.Data.DbManager.ExecuteList (ASC.Common.Data.Sql.ISqlInstruction sql) [0x00000] in <36581e6887064d56b05ff22b7d2875ec>:0
at ASC.Common.Data.DbManagerProxy.ExecuteList (ASC.Common.Data.Sql.ISqlInstruction sql) [0x00006] in <36581e6887064d56b05ff22b7d2875ec>:0
at ASC.Core.Data.DbBaseService+<>c__DisplayClass7.<ExecList>b__6 (ASC.Common.Data.IDbManager db) [0x00000] in <7272b593fdd5425cae6ad74c1bd68d9f>:0
at ASC.Core.Data.DbBaseService.Execute[T] (System.Func`2[T,TResult] action) [0x00007] in <7272b593fdd5425cae6ad74c1bd68d9f>:0
at ASC.Core.Data.DbBaseService.ExecList (ASC.Common.Data.Sql.ISqlInstruction sql) [0x0000d] in <7272b593fdd5425cae6ad74c1bd68d9f>:0
at ASC.Core.Data.DbTenantService.GetTenants (ASC.Common.Data.Sql.Expressions.Exp where) [0x00008] in <7272b593fdd5425cae6ad74c1bd68d9f>:0
at ASC.Core.Data.DbTenantService.GetTenant (System.String domain) [0x00039] in <7272b593fdd5425cae6ad74c1bd68d9f>:0
at ASC.Core.Caching.CachedTenantService.GetTenant (System.String domain) [0x00012] in <7272b593fdd5425cae6ad74c1bd68d9f>:0
at ASC.Core.TenantManager.GetTenant (System.String domain) [0x0001f] in <7272b593fdd5425cae6ad74c1bd68d9f>:0
at ASC.Core.TenantManager.GetCurrentTenant (System.Boolean throwIfNotFound) [0x00047] in <7272b593fdd5425cae6ad74c1bd68d9f>:0
at TMResourceData.WhiteLabelHelper.ReplaceLogo (System.String resourceName, System.String resourceValue) [0x00019] in <7272b593fdd5425cae6ad74c1bd68d9f>:0

Please advise if this updated version requires any additional steps or configuration after is applied.
Also, please assist in fixing the MySQL Access denied issue.

Thank you very much.

Regards,

Marcel S.

[Maxim]

Hello marcelsk_br!
Did you try to login MySQL?
mysql -uroot -p
password you can find in web.connections.config /var/www/onlyoffice/CommunityServer/WebStudio

[randomstranger]

Just confirming Marcel's problem. Currently experiencing the same issue with CentOS/nginx and the same version of OnlyOffice.

[Maxim]

Hello randomstranger!
Have you updated using 'sudo yum update onlyoffice-communityserver' command?
After update please run 'bash communityserver-configure.sh'

[randomstranger]

Hi Maxim

Yes, just using yum to update. Couple of things I've noticed:
You said the mysql password can be found here:

Code: Select all

/var/www/onlyoffice/CommunityServer/WebStudio

For me, the path is slightly different:

Code: Select all

/var/www/onlyoffice/WebStudio/web.connections.config

Next, what I've noticed is that prior to the update, there is indeed a password for mysql in that file, however, after updating the password is empty.
I did retrieve the password prior to updating and tried to run

Code: Select all

bash communityserver-configure.sh

but it won't accept the password or an empty password as seems to be indicated in the file.

Also, yum didn't change the web.connections file in question, however, it created new entries for the following ones:

Code: Select all

warning: /var/www/onlyoffice/Services/MailAggregator/ASC.Mail.Aggregator.CollectionService.exe.config saved as /var/www/onlyoffice/Services/MailAggregator/ASC.Mail.Aggregator.CollectionService.exe.config.rpmsave
warning: /var/www/onlyoffice/Services/MailWatchdog/ASC.Mail.Watchdog.Service.exe.config saved as /var/www/onlyoffice/Services/MailWatchdog/ASC.Mail.Watchdog.Service.exe.config.rpmsave
warning: /var/www/onlyoffice/Services/TeamLabSvc/TeamLabSvc.exe.Config saved as /var/www/onlyoffice/Services/TeamLabSvc/TeamLabSvc.exe.Config.rpmsave

[randomstranger]

Hi Maxim

Any news on this? The problem still persists with version 9.6.3-181.

Edit:
OK so I solved the issue myself with what I had. Here's what I did should someone have a similar issue:
Make a backup of

Code: Select all

/var/www/onlyoffice/WebStudio/web.connections.config

Next, update the server and replace the newly created web.connections.config file (mine had an empty pw) with the backup (which does include the pw). Finally,

Code: Select all

# bash communityserver-configure.sh

Now the pw should work and it will reconfigure everything as it should. That's it. Successfully updated to 9.6.3-181.

Cheers

[rukitinc]

randomstranger

Should I load the entire onlyoffice or just web.connections.config?

[Maxim]

Hello rukitinc!

Should I load the entire onlyoffice or just web.connections.config?

Just web.connections.config