The gived creditionals or configuration

Issues during installation and related to database
statimajadwiszczok
Posts: 6
Joined: Fri Jul 09, 2021 10:21 am

The gived creditionals or configuration

Post by statimajadwiszczok » Fri Jul 09, 2021 10:32 am

Hello everyone, its my first post here, if i write in bad location very sorry.

Some day when i come to work my friends talk me cloud onlyoffice didnt work. When i want to enter " share me " i saw big comunication :

The gived creditionals or configuration format does not fits the storage provider. I restart server and this dont solve our problem.

In lops i found problem its with sharpbox.




I dont know how to login Database could you tell me how to login ?

Alexandre
Posts: 329
Joined: Thu Dec 12, 2019 11:08 am

Re: The gived creditionals or configuration

Post by Alexandre » Fri Jul 09, 2021 12:45 pm

Hello statimajadwiszczok.
Please describe situation step-by-step. If I understand you right you are using portal solution and you have connected third-party storage via WebDAV protocol. Please describe how you performed connection (make screenshots), which storage you are using. Also reproduce the issue and make screenshots.
Also let us know information about your installation:
1. OS of the server where ONLYOFFICE is installed.
2. Type of installation (docker, deb/rpm, exe).
3. Version of ONLYOFFICE product installed.
4. Version of ONLYOFFICE components installed (Community Server, Document Server, Control Panel).

statimajadwiszczok
Posts: 6
Joined: Fri Jul 09, 2021 10:21 am

Re: The gived creditionals or configuration

Post by statimajadwiszczok » Mon Jul 12, 2021 11:56 am

Hi, thank you for your replay.


This problem appeared when im was at home.

I cant to find information about webdev connection, if you have any comend to ubuntu please send me.
When i open "shared me" i see this information :
The gived creditionals or configuration format does not fits the storage provider. I restart server and this dont solve our problem.


i use ubuntu 18.04.5
this is docker
openoffice information : 9.6.5.771

Alexandre
Posts: 329
Joined: Thu Dec 12, 2019 11:08 am

Re: The gived creditionals or configuration

Post by Alexandre » Tue Jul 13, 2021 1:42 pm

Hello statimajadwiszczok.
Sorry, but we need complete issue scenario and information about your installation.
this is docker
openoffice information : 9.6.5.771
Could you please go to the host and run docker ps. Please show us the result. Also please provide us with requested earlier information.

statimajadwiszczok
Posts: 6
Joined: Fri Jul 09, 2021 10:21 am

Re: The gived creditionals or configuration

Post by statimajadwiszczok » Thu Jul 15, 2021 6:09 am

OS: Ubuntu 18.04.5 LTS


Error from web.files.log
2021-07-14 16:00:05,977 ERROR [Thread Pool Worker] ASC.Files - AppLimit.CloudComputing.SharpBox.Exceptions.SharpBoxException: The gived credentials or configuration format does not fits to the storage provider
at AppLimit.CloudComputing.SharpBox.StorageProvider.GenericStorageProvider.Open (AppLimit.CloudComputing.SharpBox.ICloudStorageConfiguration configuration, AppLimit.CloudComputing.SharpBox.ICloudStorageAccessToken token) [0x00041] in <3b2d35bb4d1f45c8b69ea87f79b34f8a>:0
at AppLimit.CloudComputing.SharpBox.CloudStorage.Open (AppLimit.CloudComputing.SharpBox.ICloudStorageConfiguration configuration, AppLimit.CloudComputing.SharpBox.ICloudStorageAccessToken token) [0x00052] in <3b2d35bb4d1f45c8b69ea87f79b34f8a>:0
at ASC.Files.Thirdparty.Sharpbox.SharpBoxProviderInfo.CreateStorage () [0x000b1] in <69c7c6e290404b908a5912046f2b59df>:0
at ASC.Files.Thirdparty.Sharpbox.SharpBoxProviderInfo.get_Storage () [0x0003e] in <69c7c6e290404b908a5912046f2b59df>:0
at ASC.Files.Thirdparty.Sharpbox.SharpBoxDaoBase.Dispose () [0x00006] in <69c7c6e290404b908a5912046f2b59df>:0
at ASC.Files.Thirdparty.ProviderDao.ProviderFileDao+<>c__DisplayClass8.<GetFilesForShare>b__5 (System.Linq.IGrouping`2[TKey,TElement] matchedId) [0x0003b] in <69c7c6e290404b908a5912046f2b59df>:0
at System.Linq.Enumerable+SelectManySingleSelectorIterator`2[TSource,TResult].MoveNext () [0x00051] in <dbc731b3823b48689299547fb566d4a8>:0
at System.Linq.Enumerable+WhereEnumerableIterator`1[TSource].MoveNext () [0x0004e] in <dbc731b3823b48689299547fb566d4a8>:0
at System.Collections.Generic.List`1[T].AddEnumerable (System.Collections.Generic.IEnumerable`1[T] enumerable) [0x00059] in <0f8aeac9d63d4b8aa575761bb4e65b79>:0
at System.Collections.Generic.List`1[T].InsertRange (System.Int32 index, System.Collections.Generic.IEnumerable`1[T] collection) [0x000f4] in <0f8aeac9d63d4b8aa575761bb4e65b79>:0
at System.Collections.Generic.List`1[T].AddRange (System.Collections.Generic.IEnumerable`1[T] collection) [0x00000] in <0f8aeac9d63d4b8aa575761bb4e65b79>:0
at System.Linq.Enumerable+ConcatIterator`1[TSource].ToList () [0x00027] in <dbc731b3823b48689299547fb566d4a8>:0
at System.Linq.Enumerable.ToList[TSource] (System.Collections.Generic.IEnumerable`1[T] source) [0x0001f] in <dbc731b3823b48689299547fb566d4a8>:0
at ASC.Files.Thirdparty.ProviderDao.ProviderFileDao.GetFilesForShare (System.Object[] fileIds) [0x000ba] in <69c7c6e290404b908a5912046f2b59df>:0
at ASC.Files.Core.Security.FileSecurity.GetSharesForMe (System.String searchText) [0x0018c] in <4eb0eb2d26824d778b3b815854661255>:0
at ASC.Web.Files.Utils.EntryManager.GetEntries (ASC.Files.Core.IFolderDao folderDao, ASC.Files.Core.IFileDao fileDao, ASC.Files.Core.Folder parent, ASC.Files.Core.FilterType filter, System.Guid subjectId, ASC.Files.Core.OrderBy orderBy, System.String searchText, System.Int32 from, System.Int32 count, System.Int32$


Docker ps result:
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
e0bb19f3e31c onlyoffice/communityserver:9.6.5.771 "/usr/bin/dumb-init …" 2 years ago Up 8 days 0.0.0.0:80->80/tcp, 0.0.0.0:443->443/tcp, 3306/tcp, 5280/tcp, 9865-9866/tcp, 9871/tcp, 9882/tcp, 0.0.0.0:5222->5222/tcp, 9888/tcp onlyoffice-community-server
7fc9ec51d47a onlyoffice/documentserver:5.2.8.24 "/bin/sh -c /app/onl…" 2 years ago Up 8 days 80/tcp, 443/tcp onlyoffice-document-server
f28413c81c75 mysql:5.7.21 "docker-entrypoint.s…" 2 years ago Up 8 days 3306/tcp onlyoffice-mysql-server


We have suspicions that a long time ago WebDAV protocol was configurated to use external FTP (details are unknown). The external FTP server has been decommissioned.
Nowhere in the options we can verify the existing connections or show that there is no configured one.
We would like to remove this configuration, but we don't know how.
Screen issue:
Image
Attachments
123.png
123.png (86.51 KiB) Viewed 292 times

Alexandre
Posts: 329
Joined: Thu Dec 12, 2019 11:08 am

Re: The gived creditionals or configuration

Post by Alexandre » Fri Jul 16, 2021 2:14 pm

Try to check MySQL BD for the presence of WebDAV records.
Go to the server > MySQL container (docker exec -it 'container_ID' bash) > mysql -uroot -pmy-secret-pw -D onlyoffice > use onlyoffice; > select * from files_thirdparty_account;
Please let us know the result.

statimajadwiszczok
Posts: 6
Joined: Fri Jul 09, 2021 10:21 am

Re: The gived creditionals or configuration

Post by statimajadwiszczok » Sun Jul 18, 2021 7:08 am

Mysql query result:


Image


I only must delete this row or there is required updates on other tables?
Attachments
test.png
test.png (6.95 KiB) Viewed 240 times

Alexandre
Posts: 329
Joined: Thu Dec 12, 2019 11:08 am

Re: The gived creditionals or configuration

Post by Alexandre » Mon Jul 19, 2021 1:01 pm

Yes, try to remove this line from the table. After that restart Mono service just in case (run service monoserve restart inside of Community server container). NB! Before these actions, please make a whole server snapshot\backup.
Please let us know the result.

statimajadwiszczok
Posts: 6
Joined: Fri Jul 09, 2021 10:21 am

Re: The gived creditionals or configuration

Post by statimajadwiszczok » Tue Jul 20, 2021 5:34 am

Now we have such error.




I tried delete row in files_thirdparty_id_mapping but now i have error.
I dont know relationship between this table and others (i dont see anything similiar in files_file or files folder).




I restored snapshot to revert changes. You have any idea how to delete this thirdparty permanently?
Attachments
2.png
2.png (2.14 KiB) Viewed 174 times
1.png
1.png (2.11 KiB) Viewed 174 times

Alexandre
Posts: 329
Joined: Thu Dec 12, 2019 11:08 am

Re: The gived creditionals or configuration

Post by Alexandre » Wed Jul 21, 2021 12:19 pm

Is it possible to make a portal update to current versions and after that try to remove the line from DB again? Of course, make a snapshot\backup of the whole server before update process.

Post Reply