.

This device server is certified as a reference implementation.

Average: 0
Rating Count: 0

Development status: Released
Information status: New
Repository: https://github.com/tango-controls/TangoDatabase
Contact:


Class Description

This class manage the TANGO database.

Families: System

Key words:

Platform: All Platforms

Language: Cpp

License:

Contact:

Hardware

Manufacturer: none

Bus: Not Applicable

Class interface

Attributes:

Name Description
StoredProcedureReleaseScalar: DevString —
Timing_averageSpectrum: DevDouble —
Timing_minimumSpectrum: DevDouble —
Timing_maximumSpectrum: DevDouble —
Timing_callsSpectrum: DevDouble —
Timing_indexSpectrum: DevString —
Timing_infoSpectrum: DevString —

Commands:

Name Description
StateInput: DevVoid
Output: State
State Code		 This command gets the device state (stored in its <i>device_state</i> data member) and returns it to the caller.
StatusInput: DevVoid
Output: ConstDevString
Status description		 This command gets the device status (stored in its <i>device_status</i> data member) and returns it to the caller.
DbAddDeviceInput: DevVarStringArray
Str[0] = Full device server process name Str[1] = Device name Str[2] = Tango class name
Output: DevVoid		 Add a Tango class device to a specific device server
DbAddServerInput: DevVarStringArray
Str[0] = Full device server name Str[1] = Device(s) name Str[2] = Tango class name Str[n] = Device name Str[n + 1] = Tango class name
Output: DevVoid		 Create a device server process entry in database
DbDeleteAttributeAliasInput: DevString
Attriibute alias name.
Output: DevVoid		 Delete an attribute alias.
DbDeleteClassAttributeInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Attribute name
Output: DevVoid		 delete a class attribute and all its properties from database
DbDeleteClassAttributePropertyInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Attribute name Str[2] = Property name Str[n] = Property name
Output: DevVoid		 delete class attribute properties from database
DbDeleteClassPropertyInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Property name Str[n] = Property name
Output: DevVoid		 Delete class properties from database
DbDeleteDeviceInput: DevString
device name
Output: DevVoid		 Delete a device from database
DbDeleteDeviceAliasInput: DevString
device alias name
Output: DevVoid		 Delete a device alias.
DbDeleteDeviceAttributeInput: DevVarStringArray
Str[0] = Device name Str[1] = Attribute name
Output: DevVoid		 Delete device attribute properties from database
DbDeleteDeviceAttributePropertyInput: DevVarStringArray
Str[0] = Device name Str[1] = Attribute name Str[2] = Property name Str[n] = Property name
Output: DevVoid		 delete a device attribute property from the database
DbDeleteDevicePropertyInput: DevVarStringArray
Str[0] = Device name Str[1] = Property name Str[n] = Property name
Output: DevVoid		 Delete device property(ies)
DbDeletePropertyInput: DevVarStringArray
Str[0] = Object name Str[1] = Property name Str[n] = Property name
Output: DevVoid		 Delete free property from database
DbDeleteServerInput: DevString
Device server name
Output: DevVoid		 Delete server from the database but dont delete device properties
DbDeleteServerInfoInput: DevString
Device server name
Output: DevVoid		 delete info related to a Tango devvice server process
DbExportDeviceInput: DevVarStringArray
Str[0] = Device name Str[1] = CORBA IOR Str[2] = Device server process host name Str[3] = Device server process PID or string ``null`` Str[4] = Device server process version
Output: DevVoid		 Export a device to the database
DbExportEventInput: DevVarStringArray
Str[0] = event channel name (or factory name) Str[1] = CORBA IOR Str[2] = Notifd host name Str[3] = Notifd pid Str[4] = Notifd version
Output: DevVoid		 Export Event channel to database
DbGetAliasDeviceInput: DevString
Alias name
Output: DevString
Device name		 Get device name from its alias.
DbGetAttributeAliasInput: DevString
The attribute alias name
Output: DevString
The attribute name (device/attribute)		 Get the attribute name for the given alias. If alias not found in database, returns an empty string.
DbGetAttributeAliasListInput: DevString
attribute alias filter string (eg: att*)
Output: DevVarStringArray
attribute aliases		 Get attribute alias list for a specified filter
DbGetClassAttributeListInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Attribute name filter (eg: att*)
Output: DevVarStringArray
Str[0] = Class attribute name Str[n] = Class attribute name		 Get attrilute list for a given Tango class with a specified filter
DbGetClassAttributePropertyInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Attribute name Str[n] = Attribute name
Output: DevVarStringArray
Str[0] = Tango class name Str[1] = Attribute property number Str[2] = Attribute property 1 name Str[3] = Attribute property 1 value Str[n + 1] = Attribute property 2 name Str[n + 2] = Attribute property 2 value		 Get Tango class property(ies) value
DbGetClassAttributeProperty2Input: DevVarStringArray
Str[0] = Tango class name Str[1] = Attribute name Str[n] = Attribute name
Output: DevVarStringArray
Str[0] = Tango class name Str[1] = Attribute property number Str[2] = Attribute property 1 name Str[3] = Attribute property 1 value number (array case) Str[4] = Attribute property 1 value Str[n] = Attribute property 1 value (array case) Str[n + 1] = Attribute property 2 name Str[n + 2] = Attribute property 2 value number (array case) Str[n + 3] = Attribute property 2 value Str[n + m] = Attribute property 2 value (array case)		 This command supports array property compared to the old command called DbGetClassAttributeProperty. The old command has not been deleted from the server for compatibility reasons.
DbGetClassAttributePropertyHistInput: DevVarStringArray
Str[0] = Tango class Str[1] = Attribute name Str[2] = Property name
Output: DevVarStringArray
Str[0] = Attribute name Str[1] = Property name Str[2] = date Str[3] = Property value number (array case) Str[4] = Property value 1 Str[n] = Property value n		 Retrieve Tango class attribute property history
DbGetClassForDeviceInput: DevString
Device name
Output: DevString
Device Tango class		 Get Tango class for the specified device.
DbGetClassInheritanceForDeviceInput: DevString
Device name
Output: DevVarStringArray
Classes off the specified device. [0] - is the class of the device. [1] - is the class from the device class is inherited. ........and so on		 Get class inheritance for the specified device.
DbGetClassListInput: DevString
Filter
Output: DevVarStringArray
Class list		 Get Tango class list with a specified filter
DbGetClassPropertyInput: DevVarStringArray
Str[0] = Tango class Str[1] = Property name Str[2] = Property name
Output: DevVarStringArray
Str[0] = Tango class Str[1] = Property number Str[2] = Property name Str[3] = Property value number (array case) Str[4] = Property value Str[n] = Propery value (array case) ....		 —
DbGetClassPropertyHistInput: DevVarStringArray
Str[0] = Tango class Str[1] = Property name
Output: DevVarStringArray
Str[0] = Property name Str[1] = date Str[2] = Property value number (array case) Str[3] = Property value 1 Str[n] = Property value n		 Retrieve Tango class property history
DbGetClassPropertyListInput: DevString
The filter
Output: DevVarStringArray
Property name list		 Get property list for a given Tango class with a specified filter
DbGetDeviceAliasInput: DevString
The device name
Output: DevString
The alias found		 Return alias for device name if found.
DbGetDeviceAliasListInput: DevString
The filter
Output: DevVarStringArray
Device alias list		 Get device alias name with a specific filter
DbGetDeviceAttributeListInput: DevVarStringArray
Str[0] = Device name Str[1] = Wildcard
Output: DevVarStringArray
attribute name list		 Return list of attributes matching the wildcard for the specified device
DbGetDeviceAttributePropertyInput: DevVarStringArray
Str[0] = Device name Str[1] = Attribute name Str[n] = Attribute name
Output: DevVarStringArray
Str[0] = Device name Str[1] = Attribute property number Str[2] = Attribute property 1 name Str[3] = Attribute property 1 value Str[n + 1] = Attribute property 2 name Str[n + 2] = Attribute property 2 value		 Get device attribute property(ies) value
DbImportEventInput: DevString
name of event channel or factory
Output: DevVarLongStringArray
export information e.g. IOR		 Get event channel info from database
DbGetDeviceAttributeProperty2Input: DevVarStringArray
Str[0] = Device name Str[1] = Attribute name Str[n] = Attribute name
Output: DevVarStringArray
Str[0] = Device name Str[1] = Attribute property number Str[2] = Attribute property 1 name Str[3] = Attribute property 1 value number (array case) Str[4] = Attribute property 1 value Str[n] = Attribute property 1 value (array case) Str[n + 1] = Attribute property 2 name Str[n + 2] = Attribute property 2 value number (array case) Str[n + 3] = Attribute property 2 value Str[n + m] = Attribute property 2 value (array case)		 Retrieve device attribute properties. This command has the possibility to retrieve device attribute properties which are arrays. It is not possible with the old DbGetDeviceAttributeProperty command. Nevertheless, the old command has not been deleted for compatibility reason
DbGetDeviceAttributePropertyHistInput: DevVarStringArray
Str[0] = Device name Str[1] = Attribute name Str[2] = Property name
Output: DevVarStringArray
Str[0] = Attribute name Str[1] = Property name Str[2] = date Str[3] = Property value number (array case) Str[4] = Property value 1 Str[n] = Property value n		 Retrieve device attribute property history
DbGetDeviceClassListInput: DevString
Device server process name
Output: DevVarStringArray
Str[0] = Device name Str[1] = Tango class Str[n] = Device name Str[n + 1] = Tango class		 Get Tango classes/device list embedded in a specific device server
DbGetDeviceDomainListInput: DevString
The wildcard
Output: DevVarStringArray
Device name domain list		 Get list of device domain name matching the specified
DbGetDeviceExportedListInput: DevString
filter
Output: DevVarStringArray
list of exported devices		 Get a list of exported devices whose names satisfy the filter (wildcard is
DbGetDeviceFamilyListInput: DevString
The wildcard
Output: DevVarStringArray
Family list		 Get a list of device name families for device name matching the specified wildcard
DbGetDeviceInfoInput: DevString
Device name
Output: DevVarLongStringArray
Str[0] = Device name Str[1] = CORBA IOR Str[2] = Device version Str[3] = Device Server name Str[4] = Device Server process host name Str[5] = Started date (or ? if not set) Str[6] = Stopped date (or ? if not set) Str[7] = Device class Lg[0] = Device exported flag Lg[1] = Device Server process PID (or -1 if not set)		 Returns info from DbImportDevice and started/stopped dates.
DbGetDeviceListInput: DevVarStringArray
argin[0] : server name argin[1] : class name
Output: DevVarStringArray
The list of devices for specified server and class.		 Get a list of devices for specified server and class.
DbGetDeviceWideListInput: DevString
filter
Output: DevVarStringArray
list of exported devices		 Get a list of devices whose names satisfy the filter.
DbGetDeviceMemberListInput: DevString
The filter
Output: DevVarStringArray
Device names member list		 Get a list of device name members for device name matching the specified filter
DbGetDevicePropertyInput: DevVarStringArray
Str[0] = Device name Str[1] = Property name Str[n] = Property name
Output: DevVarStringArray
Str[0] = Device name Str[1] = Property number Str[2] = Property name Str[3] = Property value number (array case) Str[4] = Property value 1 Str[n] = Property value n (array case) Str[n + 1] = Property name Str[n + 2] = Property value number (array case) Str[n + 3] = Property value 1 Str[n + m] = Property value m		 —
DbGetDevicePropertyHistInput: DevVarStringArray
Str[0] = Device name Str[2] = Property name
Output: DevVarStringArray
Str[0] = Property name Str[1] = date Str[2] = Property value number (array case) Str[3] = Property value 1 Str[n] = Property value n		 Retrieve device property history
DbGetDevicePropertyListInput: DevVarStringArray
Str[0] = device name Str[1] = Filter
Output: DevVarStringArray
Property name list		 Get property list belonging to the specified device and with name matching the specified filter
DbGetDeviceServerClassListInput: DevString
device server process name
Output: DevVarStringArray
list of classes for this device server		 Get list of Tango classes for a device server
DbGetExportdDeviceListForClassInput: DevString
Class name
Output: DevVarStringArray
Device exported list		 Query the database for device exported for the specified class.
DbGetHostListInput: DevString
The filter
Output: DevVarStringArray
Host name list		 Get host list with name matching the specified filter
DbGetHostServerListInput: DevString
The filter
Output: DevVarStringArray
Device server process name list		 Get list of device server process name running on host with name matching the specified filter
DbGetHostServersInfoInput: DevString
Host name
Output: DevVarStringArray
Server info for all servers running on specified host		 Get info about all servers running on specified host, name, mode and level
DbGetInstanceNameListInput: DevString
Server name
Output: DevVarStringArray
The instance names found for specified server.		 Returns the instance names found for specified server.
DbGetObjectListInput: DevString
The filter
Output: DevVarStringArray
Object name list		 Get list of free object defined in database with name matching the specified filter
DbGetPropertyInput: DevVarStringArray
Str[0] = Object name Str[1] = Property name Str[n] = Property name
Output: DevVarStringArray
Str[0] = Object name Str[1] = Property number Str[2] = Property name Str[3] = Property value number (array case) Str[4] = Property value 1 Str[n] = Property value n (array case) Str[n + 1] = Property name Str[n + 2] = Property value number (array case) Str[n + 3] = Property value 1 Str[n + m] = Property value m		 Get free object property
DbGetPropertyHistInput: DevVarStringArray
Str[0] = Object name Str[2] = Property name
Output: DevVarStringArray
Str[0] = Property name Str[1] = date Str[2] = Property value number (array case) Str[3] = Property value 1 Str[n] = Property value n		 Retrieve object property history
DbGetPropertyListInput: DevVarStringArray
Str[0] = Object name Str[1] = filter
Output: DevVarStringArray
Property name list		 Get list of property defined for a free object and matching the specified filter
DbGetServerInfoInput: DevString
server name
Output: DevVarStringArray
server info		 Get info about host, mode and level for specified server
DbGetServerListInput: DevString
The filter
Output: DevVarStringArray
Device server process name list		 Get list of device server process defined in database with name matching the specified filter
DbGetServerNameListInput: DevString
wildcard for server names.
Output: DevVarStringArray
server names found.		 Returns the list of server names found for the wildcard specified. It returns only the server executable name without instance name as DbGetServerList.
DbImportDeviceInput: DevString
Device name (or alias)
Output: DevVarLongStringArray
Str[0] = device name Str[1] = CORBA IOR Str[2] = device version Str[3] = device server process name Str[4] = host name Str[5] = Tango class name Lg[0] = Exported flag Lg[1] = Device server process PID		 Import a device from the database
DbInfoInput: DevVoid
Output: DevVarStringArray
Miscellaneous info like: - Device defined in database - Device marked as exported in database - Device server process defined in database - Device server process marked as exported in database - Device properties defined in database - Class properties defined in database - Device attribute properties defined in database - Class attribute properties defined in database - Object properties defined in database		 Get miscellaneous numbers on information stored in database
DbPutAttributeAliasInput: DevVarStringArray
Str[0] = attribute name Str[1] = attribute alias
Output: DevVoid		 Define an alias for an attribute
DbPutClassAttributePropertyInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Attribute number Str[2] = Attribute name Str[3] = Property number Str[4] = Property name Str[5] = Property value .....
Output: DevVoid		 Create/Update class attribute property(ies) in database
DbPutClassAttributeProperty2Input: DevVarStringArray
Str[0] = Tango class name Str[1] = Attribute number Str[2] = Attribute name Str[3] = Property number Str[4] = Property name Str[5] = Property value number (array case) Str[5] = Property value 1 Str[n] = Property value n (array case) .....
Output: DevVoid		 This command adds support for array properties compared to the previous one called DbPutClassAttributeProperty. The old comman is still there for compatibility reason
DbPutClassPropertyInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Property number Str[2] = Property name Str[3] = Property value number Str[4] = Property value 1 Str[n] = Property value n ....
Output: DevVoid		 Create / Update class property(ies)
DbPutDeviceAliasInput: DevVarStringArray
Str[0] = device name Str[1] = alias name
Output: DevVoid		 Define alias for a given device name
DbPutDeviceAttributePropertyInput: DevVarStringArray
Str[0] = Device name Str[1] = Attribute number Str[2] = Attribute name Str[3] = Property number Str[4] = Property name Str[5] = Property value .....
Output: DevVoid		 Create/Update device attribute property(ies) in database
DbPutDeviceAttributeProperty2Input: DevVarStringArray
Str[0] = Device name Str[1] = Attribute number Str[2] = Attribute name Str[3] = Property number Str[4] = Property name Str[5] = Property value number (array case) Str[5] = Property value 1 Str[n] = Property value n (array case) .....
Output: DevVoid		 Put device attribute property. This command adds the possibility to have attribute property which are arrays. Not possible with the old DbPutDeviceAttributeProperty command. This old command is not deleted for compatibility reasons.
DbPutDevicePropertyInput: DevVarStringArray
Str[0] = Tango device name Str[1] = Property number Str[2] = Property name Str[3] = Property value number Str[4] = Property value 1 Str[n] = Property value n ....
Output: DevVoid		 Create / Update device property(ies)
DbPutPropertyInput: DevVarStringArray
Str[0] = Object name Str[1] = Property number Str[2] = Property name Str[3] = Property value number Str[4] = Property value 1 Str[n] = Property value n ....
Output: DevVoid		 Create / Update free object property(ies)
DbPutServerInfoInput: DevVarStringArray
server info
Output: DevVoid		 Update server info including host, mode and level
DbUnExportDeviceInput: DevString
Device name
Output: DevVoid		 Mark a device as non exported in database
DbUnExportEventInput: DevString
name of event channel or factory to unexport
Output: DevVoid		 Mark one event channel as non exported in database
DbUnExportServerInput: DevString
Device server name (executable/instance)
Output: DevVoid		 Mark all devices belonging to a specified device server process as non exported
ResetTimingValuesInput: DevVoid
Output: DevVoid		 Reset the timing attribute values.
DbGetDataForServerCacheInput: DevVarStringArray
Elt[0] = DS name (exec_name/inst_name), Elt[1] = Host name
Output: DevVarStringArray
All the data needed by the device server during its startup sequence. Precise list depend on the device server		 This command returns all the data needed by a device server process during its startup sequence. The aim of this command is to minimize database access during device server startup sequence.
DbDeleteAllDeviceAttributePropertyInput: DevVarStringArray
str[0] = device name Str[1]...str[n] = attribute name(s)
Output: DevVoid		 Delete all attribute properties for the specified device attribute(s)
DbMySqlSelectInput: DevString
MySql Select command
Output: DevVarLongStringArray
MySql Select command result - svalues : select results - lvalue[n] : =0 if svalue[n] is null else =1 (last lvalue -1) is number of rows, (last lvalue) is number of fields		 This is a very low level command. It executes the specified SELECT command on TANGO database and returns its result without filter.
DbGetCSDbServerListInput: DevVoid
Output: DevVarStringArray
List of host:port with one element for each database server		 Get a list of host:port for all database server defined in the control system
DbGetAttributeAlias2Input: DevString
The attribute name (dev_name/att_name)
Output: DevString
The attribute alias name (or empty string)		 Get the attribute alias from the attribute name. Returns one empty string if nothing found in database
DbGetAliasAttributeInput: DevString
The attribute alias
Output: DevString
The attribute name (dev_name/att_name)		 Get the attribute name from the given alias. If the given alias is not found in database, returns an empty string
DbRenameServerInput: DevVarStringArray
s[0] = old device server name (exec/instance) s[1] = new device server name (exec/instance)
Output: DevVoid		 Rename a device server process
DbGetClassPipePropertyInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Pipe name Str[n] = Pipe name
Output: DevVarStringArray
Str[0] = Tango class name Str[1] = Pipe property number Str[2] = Pipe property 1 name Str[3] = Pipe property 1 value number (array case) Str[4] = Pipe property 1 value Str[n] = Pipe property 1 value (array case) Str[n + 1] = Pipe property 2 name Str[n + 2] = Pipe property 2 value number (array case) Str[n + 3] = Pipe property 2 value Str[n + m] = Pipe property 2 value (array case)		 Retrieve class pipe properties
DbGetDevicePipePropertyInput: DevVarStringArray
Str[0] = Device name Str[1] = Pipe name Str[n] = Pipe name
Output: DevVarStringArray
Str[0] = Device name Str[1] = Pipe property number Str[2] = Pipe property 1 name Str[3] = Pipe property 1 value number (array case) Str[4] = Pipe property 1 value Str[n] = Pipe property 1 value (array case) Str[n + 1] = Pipe property 2 name Str[n + 2] = Pipe property 2 value number (array case) Str[n + 3] = Pipe property 2 value Str[n + m] = Pipe property 2 value (array case)		 Retrieve device pipe properties
DbDeleteClassPipeInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Pipe name
Output: DevVoid		 Delete a class pipe and all its properties from database
DbDeleteDevicePipeInput: DevVarStringArray
Str[0] = Device name Str[1] = Pipe name
Output: DevVoid		 Delete device pipe properties from database
DbDeleteClassPipePropertyInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Pipe name Str[2] = Property name Str[n] = Property name
Output: DevVoid		 Delete class pipe properties from database
DbDeleteDevicePipePropertyInput: DevVarStringArray
Str[0] = Device name Str[1] = Pipe name Str[2] = Property name Str[n] = Property name
Output: DevVoid		 Delete device pipe properties from database
DbGetClassPipeListInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Pipe name filter (eg: pip*)
Output: DevVarStringArray
Str[0] = Class pipe name Str[n] = Class pipe name		 Get pipe list for a given Tango class with a specified filter
DbGetDevicePipeListInput: DevVarStringArray
Str[0] = Device name Str[1] = Wildcard
Output: DevVarStringArray
Pipe name list		 Return list of pipes matching the wildcard for the specified device
DbDeleteAllDevicePipePropertyInput: DevVarStringArray
str[0] = device name Str[1]...str[n] = pipe name(s)
Output: DevVoid		 Delete all pipe properties for the specified device pipe(s)
DbPutClassPipePropertyInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Pipe number Str[2] = Pipe name Str[3] = Property number Str[4] = Property name Str[5] = Property value number (array case) Str[5] = Property value 1 Str[n] = Property value n (array case)
Output: DevVoid		 Create/Update class pipe property(ies) in database
DbPutDevicePipePropertyInput: DevVarStringArray
Str[0] = Device name Str[1] = Pipe number Str[2] = Pipe name Str[3] = Property number Str[4] = Property name Str[5] = Property value number (array case) Str[6] = Property value 1 Str[n] = Property value n (array case)
Output: DevVoid		 Create/Update device pipe property(ies) in database
DbGetClassPipePropertyHistInput: DevVarStringArray
Str[0] = Tango class Str[1] = Pipe name Str[2] = Property name
Output: DevVarStringArray
Str[0] = Pipe name Str[1] = Property name Str[2] = date Str[3] = Property value number (array case) Str[4] = Property value 1 Str[n] = Property value n		 Retrieve Tango class pipe property history
DbGetDevicePipePropertyHistInput: DevVarStringArray
Str[0] = Device name Str[1] = Pipe name Str[2] = Property name
Output: DevVarStringArray
Str[0] = Pipe name Str[1] = Property name Str[2] = date Str[3] = Property value number (array case) Str[4] = Property value 1 Str[n] = Property value n		 Retrieve device pipe property history
DbGetForwardedAttributeListForDeviceInput: DevString
The specified device name
Output: DevVarStringArray
argout[n] : device name argout[n+1] :the forwardef attribute argout[n+2] :the root attribute (__root_att)		 Get the list of devices using forwarded attribute(s) from specified device

Pipes:

Name Description

Properties:

Name Description

Please log in to comment.

README

b' Tango Database server README\n ============================\n \nThis file contains information on installing/upgrading the Tango database\nserver. This guide assumes that a MySQL daemon runs on the machine you\nwant to install the database and that the DB server has history capabilities\n(Release_2_9 or higher).\nNote: You need jive 3.3 or higher to be able to access history.\n\n------------------------------------------------------------------------\nStarting from scratch\n------------------------------------------------------------------------\n\n#Launch the mysql client\n\nmysql -u[user] -p[password]\n\n#Create the tango scheme, add the declaration of the DB server and\n#initialise history tables.\n\nmysql>source tango_create.sql\n\n# Set-up the environment variables MYSQL_USER and MYSQL_PASSWORD\n# or prepare the my.cnf (mysql configuration file) file to specify \n# the mysql user and its password to be used to connect to the database.\n\n# The user is root without a password\nexport MYSQL_USER=root\n\n#Now, you should be able to launch the DB server\n\nDatabaseds 2 -ORBendPoint giop:tcp:[hostname]:[port]\n\n#To test if the DB server is working fine, you can launch jive\n\nexport TANGO_HOST=[hostname]:[port]\njive\n\n\n------------------------------------------------------------------------\nHow to upgrade the DB scheme. This section descrbies what you have to do \nif you already use a DB server running with an old scheme (without history \ntables)\n------------------------------------------------------------------------\n\n#Launch the mysql client\n\nmysql -u[user] -p[password]\n\n#Check if the database scheme has already history tables\n\nmysql>show tables;\n\n#If the scheme already has history tables, you should see the 6 following \n#tables\n+--------------------------------+\n| Tables_in_tango |\n+--------------------------------+\n| ... |\n| history_ids |\n| property_attribute_class_hist |\n| property_attribute_device_hist |\n| property_class_hist |\n| property_device_hist |\n| property_hist |\n| ... |\n+--------------------------------+\n\n#Note: If your database server stops with the following exception,that means \n#that you don\'t have the correct scheme.\n\nReceived a CORBA::Exception\nTango exception\nSeverity = ERROR\nError reason = DB_SQLError\nDesc : Failed to query TANGO database (error=Table \'tango.property_device_hist\' doesn\'t exist)\nOrigin : DataBase::check_history_tables()\n\n#If you don\'t have the history scheme:\n#Use the db_init_history program to create/initialise history tables.\n#This program will create and fill the history tables with the current \n#dababase property values (to initialize the first value of the \n#property history). This tool does not affect old tables, that means \n#that even if you run this tool, you will still be able to launch\n#an old release of the DB server.\n\ndb_init_history [user] [password]\n\n#Now, you should be able to launch the DB server\n\nDatabaseds 2 -ORBendPoint giop:tcp:[hostname]:[port]\n\n#To test if the DB server is working fine, you can launch jive\n\nexport TANGO_HOST=[hostname]:[port]\njive\n\n\n------------------------------------------------------------------------\nHow to change the history depth (Number of value kept in the property history)\n------------------------------------------------------------------------\n\nYou can set the property history depth by setting the "historyDepth" device \nproperty of the DB server. The default value is 10.\nNote that you have to launch the DB server in order to be able to configure \nthis property with Jive and then to restart the DB server to take change into\naccount.\n\n\n'

5 Jan 2017, Andy Gotz
Created:
The device server has been added to catalogue.
Added by:agotz on:5 Jan 2017, 12:41 p.m.