Valentina Server FAQ

Please read detailed answer here

Yes. We have quite many videos that show in few minutes, how to download VServer, get license file and install it. Check please Valentina Server Videos

Yes. For this you need to specify different ports in the ini file of each VServer.

You can get version of your Valentina Server in few ways.

• In Valentina Studio chose connection to your VServer. In the inspector on the right side you will find Version.
• Open log file. In the first lines you will find info about version.
• Execute command “SHOW PROPERTIES OF SERVER” against your VServer.

Please check this link.

VServer disconnects an idle client on timeout. You can increase the timeout in the .ini file of VServer or set it infinite.

Just set in the .ini file of VServer the MaxClientTimeout to be -1.

You should drop it into your VServer/licenses folder. Read details here. Please remember, that you need restart VServer to make it use new license file.

When VServer starts, it log this information into .log file. So just open log file to see that info. Note, that on OS X and Linux you can open log for for read even while VServer runs.

Valentina Server installer starts VServer without license file, right. You can see empty folder “licenses”. In this mode VServer works with 1 connection only. Such solution allows to get working VServer right after install. But you should of course add as soon as possible:

• a free license file with 5 connections
• a commercial license file with more connections.

sa/sa (This means Sys Admin)

533761 code means “Connection limit reached.”

Often this happens when user runs VServer without any license file. So VServer works with 1 connection enabled only. Or you have try establish 6th connection, while you have license for 5 connections.

They are located in the folder VServer/vlogs. Location of VServer folder depends on OS:

• Windows : /Program Files/Paradigma Software/VServer
• Mac OS X: /Library/VServer
• Linux : /opt/VServer

Yes you can, because they are not used by the current session of VServer. On each start VServer creates a new log file.

On Mac OS X you can also use prefs panel “Valentina Servers” to trash log files.

masterdb is place where Valentina Server keeps its information, such as:

• path and name of a registered database
• user name and password
• events

In general case NO, because masterdb contains full paths to registered databases, so on another computer they can not exists.

You can if execute before command “USE MASTER” in SQL Editor.

• On Windows you can check Task Manager.
• On MAC OS X you also can check Activity Monitor
• O Linux you can use top command in the terminal

• On Windows you need go to Services control panel for this.

• On MAC OS X you can:
  • use “Valentina Servers” preference panel.
  • enable helper AppleScripts for this (Read details).
  • Or execute the same terminal commands from these scripts.

You need to do simple steps:

• Copy/move your Valentina database files (1-4 files) in the closed state into vserver/databases folder. VServer can be running.
• Register the new database in Valentina Studio using menu Server > Register Database, or with the REGISTER DATABASE SQL command.

It is not enough to drop database into folder “databases”. This will not force working Valentina Server to start use it. Besides on register you assign to database some name, which can even differ from the name of disk file. Database commands as “USE db_name” will use exactly this name.

Assume that you want to move database files from one server to another. Then you need to UNREGISTER database, so VServer will close it, and remove references to it from masterdb. Now you can take files from “databases” folder.

You need do simple steps:

• Drop existed database connections with

DROP CONNECTIONS OF DATABASE db1;

• Unregister database from vServer

UNREGISTER DATABASE db1;

• Copy your Valentina database files (1-4 files) in the closed state into vserver/databases folder. VServer can be running.
• Register the new database in Valentina Studio using menu Server > Register Database, or with the REGISTER DATABASE SQL command.

In case when you cannot drop DB files into VServer/databases folder (some WEB server), you have only one way via load of SQL dump, as do this most web-developers with mySQL or postgreSQL.

Keep in mind a simple rule: Databases and Projects are objects of the same level and behavior from point of view of VSERVER. So for projects all operations and even SQL commands are symmetric.

To put your project under VSERVER control you need:

• Copy/move your Valentina Project file (*.vsp) in the closed state into 'VServer/projects' folder. VServer can be running at this time.
• Register the new project in Valentina Studio using menu Server > Register Project, or with the REGISTER PROJECT SQL command.