Internet Connection with common cache database, if one of of the clients chooses "refresh entire cache" command, the common cache database is deleted (CB ticket 835672) #10
SITUATION:
Database on cloud server
Common cache server in local area network
PROBLEM:
When CB clients are sharing the local cache database, if one of of the clients chooses "refresh entire cache" command, the common cache database is deleted, but then the client cannot does not have the rights to re-create the common cache database.
This causes all clients to be down because the common cache database has been deleted.
WORKAROUND IDEA:
Give the clients (except for the computer where the common cache database is located), read/write access but not dbowner access to the cache database so the client does not have the rights to delete it (this as not been tested and may not work because of this issue: https://github.com/DynEntTech/CBKnownIssues/issues/12 )
SOLUTION:
If the cache database is on a remote computer, then the option "refresh entire cache" should be grayed out when the client is connected to a remote cache database, so the delete of the cache database cannot take place.
SITUATION: Database on cloud server Common cache server in local area network
PROBLEM: When CB clients are sharing the local cache database, if one of of the clients chooses "refresh entire cache" command, the common cache database is deleted, but then the client cannot does not have the rights to re-create the common cache database.
This causes all clients to be down because the common cache database has been deleted.
WORKAROUND IDEA: Give the clients (except for the computer where the common cache database is located), read/write access but not dbowner access to the cache database so the client does not have the rights to delete it (this as not been tested and may not work because of this issue: https://github.com/DynEntTech/CBKnownIssues/issues/12 )
SOLUTION: If the cache database is on a remote computer, then the option "refresh entire cache" should be grayed out when the client is connected to a remote cache database, so the delete of the cache database cannot take place.