1. Beatrix Willius
  2. Valentina Server
  3. 日, 12月 10 2023, 12:08 PM
  4.  メールで購読
In the manual there is a short description on how to move the server property "SystemFolder" to a new directory:

The path to a folder where will be stored databases managed by Valentina Server.

If you change it, you should copy/move existing databases there yourself. Also, you should unregister all databases and register them back, because the master database keeps the full path to the databases inside.


I thought I'd make a somewhat more detailed description:

- Remove all connections.
- Unregister databases.
- Move databases to new directory.
- Change directory for server.
- Restart server.
- Register databases.

Do I need to move master.vdb, too? Do I need to move or copy the databases?

I some testing today to change the directory and must have forgotten or mixed up a step. I ended up with this funny result where the databases are at different locations. See screenshots.

I then deleted the new directory. Which makes even funnier results: the data is written to dev/null and I have databases which can be created but not opened.
添付ファイル
コメント
There are no comments made yet.
Beatrix Willius 承諾済みの回答
I don't think that changing the main database directory works in 13.6. I reset the directory to the original database folder and changed the directory again. This time I managed to get into the lovely hell where Valentina Server starts and stops a couple of times per minute because it couldn't create the master.vdb. Which was in the new directory.
コメント
There are no comments made yet.
Ivan Smahin 承諾済みの回答
Hi Beatrix,

Yes, the wiki must be improved with a more detailed description - of how to change properties like SystemFolder properly.
BTW, your steps seem to be correct.

I cannot reproduce your issue - it works for me, so:
- can you describe the steps in detail?
- could you send me the server logs (verbose mode = 3)?
- how do you restart vServer?
コメント
There are no comments made yet.
Beatrix Willius 承諾済みの回答
I'll make more detailed steps and then I'll send the logs. I restarted Valentina Server by using restart and by shutting the server down and then restarting it.

I actually had the same error a couple of weeks ago with the same result. This was with 13.5 and not 13.6.
コメント
There are no comments made yet.
Ivan Smahin 承諾済みの回答
Regarding master db.

Most simplest way is to let vServer create a new master db in the new location. But you lost users credential data in this case.

A more tricky way is to move master db as well.
- But note, vServer always keeps master db open, so you should stop vServer first, then move master db (BTW, it can be done for all databases - moving files after vServer stops).
- In the master db you have a single record in sysdatabase table - a description of the master db itself. So you should manually change fld_path there.

After vServer starts:


use master;
update sysdatabase set fld_path = 'new_path/master.vdb';


Now, you can register moved databases...
コメント
There are no comments made yet.
  • ページ :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories