Database access lost after update Tim
    Database access lost after update Synametrics Support
        Database access lost after update Tim
            Database access lost after update Synametrics Support
                Database access lost after update Tim

From: Tim
Date: 4/10/23 10:34 AM
Topic: Database access lost after update
Type: General Discussions
Post a follow up

Dear Xeams-Team, hey everybody,

 

our prior admin set up Xeams as a Mail-Archive, no Input/Output just Drag&Drop from external mail server inbox to local folder structure on local Xeams instance.

 

Xeams runs on an QNAP in our network. Yesterday I upgraded qts to QTS 5.0.1 2277.

After that the clients could not log into Xeams.

As I opened the admin console, the first setup wizard opened. I entered all settings as before.

 -> All user accounts were gone

 

I recreated one of the accounts and now the login is working, the folder structure is visible, but all folders are empty.

The data is still there, the Qnap App Center shows approx. the right database size.

 

I really hope somebody has an idea what happened here and how to fix it.

Here are some of my ideas:

 

1. Xeams got partially or fully reset during the update

2. The user accounts got deleted, and the new users are not associated with the old database anymore

Top

From: Synametrics Support
Date: 4/10/23 10:52 AM
Topic: Database access lost after update
Type: General Discussions
Post a follow up

Sorry to hear you're running into this problem.

I feel the configuration was either corrupted or wiped out during the QTS update. Xeams makes a backup of its configuration to /share/CACHEDEV1_DATA/.qpkg/Xeams/config/archive folder. Do you see any files in this location? If yes, extract the contents of the last good backup from this folder and replace it with files in /share/CACHEDEV1_DATA/.qpkg/Xeams/config folder.

It is always a good idea to back up the "config" folder in Xeams to a different location in case mishaps like this happen.

 

Top

From: Tim
Date: 4/11/23 9:22 AM
Topic: Database access lost after update
Type: General Discussions
Post a follow up

Dear Synametrics Support,

thank you for your fast reply.

 

I took a deeper look inside the file structure. It seems that the "old" file structure was placed into the optXeams/ directory including all config backup up until the update.

The old "deleted" user repositories are there as well.

 

1. What purpose serves the optXeams/ directory?

2. Based on your suggested solution, I would copy the original config files and the UserRepository from the optXeams/ back to the Xeams/ directory.
    Could this work?
    Are there more files that I need to move back (similar to the process described here https://www.xeams.com/movexeams.htm)?

 

With best regards.

 

Top

From: Synametrics Support
Date: 4/11/23 10:21 AM
Topic: Database access lost after update
Type: General Discussions
Post a follow up

Hi Tim,

1. optXeams/ used to be a directory in our very old QNAP package for Xeams. Xeams used to run in a container-station, which had this directory.

The newer QNAP package no longer uses a container to run Xeams. The new package usually installs in either /share/MD0_DATA/.qpkg/Xeams directory or /share/CACHEDEV1_DATA/.qpkg/Xeams directory.

2. Yes, that should work. Yes, the directories (and files) you see in the moving xeams article are the ones you need to move over. Make sure Xeams is currently not running, then move over the files, then start Xeams again.

Top

From: Tim
Date: 4/15/23 10:20 AM
Topic: Database access lost after update
Type: General Discussions
Post a follow up

Dear Synametrics-Team,

 

I executed all steps as discussed and restored full access to all repositories.

Thank you very much for your fast and effective support!

 

With best regards

Top