I am registering a device server from jive. Lets say
Server/Instance—> Test/test
Class–>Test
Device---->a/b/c
Now I am entering device properties of the above device through jive which is:
PropertyName=test
Value=Success
Now when I check the tango.property_device table in mysql
The domain/family/member is not getting updated in the table i.e. it is blank.
Ideally domain should contain ‘a’, family should contain ‘b’ and member should contain ‘c’.
I am using the below versions:
Tango-9.2.2
jive-6.9
There is no domain/family/member fields in tango.property_device table.
Fields are:
[*] device
[*] name
[*] count
[*] value
[*] updated
[*] accessed
[*] comment
[/list]
To see your property use the command: select name,value from property_device where device=“a/b/c”;
I am using tango-9.2.2 version of tango. I downloaded it from sourceforge. I installed the setup as per the mentioned steps. The property_device table of tango db has the ‘domain’, family’ and ‘member’ columns.
It would be nice if you could share the tango-db schema sql file here.
Please find the attached screenshot.
Hello
After an historical search, it seems that the script create these fields since years (at least Tango-7).
Nobody knows why it has been added to the scripts, but it is not used by the Database server.
And nobody tried to see what is the property_device table content for these fields.
The misunderstood of my previous message was due to our database schema.
Our database has not been updated or created by the script. And these fields do not exist. -_-
Sorry for the inconvenient.
We will fix it in a future release.
Pascal
No issues.
I will alter the property_device table and remove the ‘domain’, ‘family’ and ‘member’ column.
Is there change in any other table of tango database from previous versions ?