Table of Contents
Valentina Server Properties
On this page you can see list of system Valentina Server properties. You can get the list of properties using SHOW PROPERTIES OF SERVER; command. To change any of these properties server admin privilege required.
ACCESSCONTROLLIST
Read-write system property. Operates with ACCESSCONTROLLIST param in ini-file of the server.
GET PROPERTY ACCESSCONTROLLIST OF server; SET PROPERTY ACCESSCONTROLLIST OF server TO '-0.0.0.0/0,+192.168.0.0/16';
BONJOURENABLE
Read-write system property. Operates with BONJOURENABLE param in ini-file of the server.
GET PROPERTY BONJOURENABLE OF server; SET PROPERTY BONJOURENABLE OF server TO 0;
BONJOURPROTOCOLNAME
Read-write system property. Operates with BONJOURPROTOCOLNAME param in ini-file of the server.
GET PROPERTY BONJOURPROTOCOLNAME OF server; SET PROPERTY BONJOURPROTOCOLNAME OF server TO 'valentina';
BONJOURSERVICENAME
Read-write system property. Operates with BONJOURSERVICENAME param in ini-file of the server.
GET PROPERTY BONJOURSERVICENAME OF server; SET PROPERTY BONJOURSERVICENAME OF server TO 'valentina';
CACHESIZE
Read-write system property. Operates with CACHESIZE param in ini-file of the server.
GET PROPERTY CACHESIZE OF server; SET PROPERTY CACHESIZE OF server TO 10;
CRASH_REPORTER_OWNER_EMAIL
Read-write system property. Operates with CRASH_REPORTER_OWNER_EMAIL param in ini-file of the server.
GET PROPERTY CRASH_REPORTER_OWNER_EMAIL OF server; SET PROPERTY CRASH_REPORTER_OWNER_EMAIL OF server TO 'name@host.com';
CRASH_REPORTER_OWNER_NAME
Read-write system property. Operates with CRASH_REPORTER_OWNER_NAME param in ini-file of the server.
GET PROPERTY CRASH_REPORTER_OWNER_NAME OF server; SET PROPERTY CRASH_REPORTER_OWNER_NAME OF server TO 'John Smith';
CRASH_REPORTER_SEND
Read-write system property. Operates with CRASH_REPORTER_SEND param in ini-file of the server.
GET PROPERTY CRASH_REPORTER_SEND OF server; SET PROPERTY CRASH_REPORTER_SEND OF server TO 1;
DISABLEDNS
Read-write system property. Operates with DISABLEDNS param in ini-file of the server.
GET PROPERTY DISABLEDNS OF server; SET PROPERTY DISABLEDNS OF server TO 1;
FLUSHEACHDATACHANGES
Read-write system property. Operates with FLUSHEACHDATACHANGES param in ini-file of the server.
GET PROPERTY FLUSHEACHDATACHANGES OF server; SET PROPERTY FLUSHEACHDATACHANGES OF server TO 1;
HOSTINGMODE
Read-only system property. Operates with HOSTINGMODE param in ini-file of the server.
GET PROPERTY HOSTINGMODE OF server;
LOGTOCONSOLE
Read-write system property. Operates with LOGTOCONSOLE param in ini-file of the server.
GET PROPERTY LOGTOCONSOLE OF server; SET PROPERTY LOGTOCONSOLE OF server TO 1;
LOGTOFILE
Read-write system property. Operates with LOGTOFILE param in ini-file of the server.
GET PROPERTY LOGTOFILE OF server; SET PROPERTY LOGTOFILE OF server TO 1;
LOGFILESLOCATION
Read-write system property. Operates with LOGFILESLOCATION param in ini-file of the server.
GET PROPERTY LOGFILESLOCATION OF server; SET PROPERTY LOGFILESLOCATION OF server TO 'myLogs';
LOGTOSYSLOG
Read-write system property. Operates with LOGTOSYSLOG param in ini-file of the server.
GET PROPERTY LOGTOSYSLOG OF server; SET PROPERTY LOGTOSYSLOG OF server TO 1;
MAILENABLE
Read-write system property. Operates with MAILENABLE param in ini-file of the server.
GET PROPERTY MAILENABLE OF server; SET PROPERTY MAILENABLE OF server TO 1;
MAXIDLECLIENTTIMEOUT
Read-write system property. Operates with MAXIDLECLIENTTIMEOUT param in ini-file of the server.
GET PROPERTY MAXIDLECLIENTTIMEOUT OF server; SET PROPERTY MAXIDLECLIENTTIMEOUT OF server TO 20;
MAXCONNECTIONTIMEOUT
Read-write system property. Operates with MAXCONNECTIONTIMEOUT param in ini-file of the server. MAXCONNECTIONTIMEOUT applies specifically to the time between queries. The connection time out is about client inactivity. Any command sent to the server is a client activity, and not only SQL queries.
GET PROPERTY MAXCONNECTIONTIMEOUT OF server; SET PROPERTY MAXCONNECTIONTIMEOUT OF server TO 20;
MAXTRANSFERTIMEOUT
Read-write system property. Operates with MAXTRANSFERTIMEOUT param in ini-file of the server. MAXTRANSFERTIMEOUT is the time allocated to actual transfer times of data. It is the time out to send/receive any single command or result from the server.
GET PROPERTY MAXTRANSFERTIMEOUT OF server; SET PROPERTY MAXTRANSFERTIMEOUT OF server TO 20;
PORT
Read-write system property. Operates with PORT param in ini-file of the server.
GET PROPERTY PORT OF server; SET PROPERTY PORT OF server TO 15432;
PORT_HTTP
Read-write system property. Operates with PORT_HTTP param in ini-file of the server.
GET PROPERTY PORT_HTTP OF server; SET PROPERTY PORT_HTTP OF server TO 0;
PORT_SSL
Read-write system property. Operates with PORT_SSL param in ini-file of the server.
GET PROPERTY PORT_SSL OF server; SET PROPERTY PORT_SSL OF server TO 0;
PORT_SNMP
Read-write system property. Operates with PORT_SNMP param in ini-file of the server.
GET PROPERTY PORT_SNMP OF server; SET PROPERTY PORT_SNMP OF server TO 0;
PRIVILEGESENABLE
Read-write system property. Operates with PRIVILEGESENABLE param in ini-file of the server.
GET PROPERTY PRIVILEGESENABLE OF server; SET PROPERTY PRIVILEGESENABLE OF server TO 0;
SINGLECONNECTIONPERLOGIN
Read-write system property. Operates with SINGLECONNECTIONPERLOGIN param in ini-file of the server.
GET PROPERTY SINGLECONNECTIONPERLOGIN OF server; SET PROPERTY SINGLECONNECTIONPERLOGIN OF server TO 1;
SCHEDULEENABLE
Read-write system property. Operates with SCHEDULEENABLE param in ini-file of the server.
GET PROPERTY SCHEDULEENABLE OF server; SET PROPERTY SCHEDULEENABLE OF server TO 0;
SERVERPATH
Read-only system property. Contains path to vServer executable.
GET PROPERTY SERVERPATH OF server;
SYSTEMCATALOG
Read-write system property. Operates with SYSTEMCATALOG param in ini-file of the server.
GET PROPERTY SYSTEMCATALOG OF server; SET PROPERTY SYSTEMCATALOG OF server TO 'Databases';
SYSTEMPROJECTCATALOG
Read-write system property. Operates with SYSTEMPROJECTCATALOG param in ini-file of the server.
GET PROPERTY SYSTEMPROJECTCATALOG OF server; SET PROPERTY SYSTEMPROJECTCATALOG OF server TO 'Projects';
SYSTEMBACKUPCATALOG
Read-write system property. Operates with SYSTEMBACKUPCATALOG param in ini-file of the server.
GET PROPERTY SYSTEMBACKUPCATALOG OF server; SET PROPERTY SYSTEMBACKUPCATALOG OF server TO 'Backup';
SSL_CERTIFICATE
Read-write system property. Operates with SSL_CERTIFICATE param in ini-file of the server.
GET PROPERTY SSL_CERTIFICATE OF server; SET PROPERTY SSL_CERTIFICATE OF server TO 'dummy.pem';
SSL_PRIVATEKEY
Read-write system property. Operates with SSL_PRIVATEKEY param in ini-file of the server.
GET PROPERTY SSL_PRIVATEKEY OF server; SET PROPERTY SSL_PRIVATEKEY OF server TO 'key.pem';
THREADS
Read-write system property. Operates with THREADS param in ini-file of the server.
GET PROPERTY THREADS OF server; SET PROPERTY THREADS OF server TO 5;
USEOLDPASSWORDS
Read-write system property. Operates with USEOLDPASSWORDS param in ini-file of the server.
GET PROPERTY USEOLDPASSWORDS OF server; SET PROPERTY USEOLDPASSWORDS OF server TO 0;
VERBOSELEVEL
Read-write system property. Operates with VERBOSELEVEL param in ini-file of the server.
GET PROPERTY VERBOSELEVEL OF server; SET PROPERTY VERBOSELEVEL OF server TO 3;