hdb++mysql not work - TANGO Controls

# 7 years ago
Jimmy	Hi, tangoer today i update hdb++ files from sourceforge,after successfully make(libhdb++.so.4.0.0, libhdb++mysql.so.4.0.0), but when execute hdb++es-srv it fail. $ hdb++es-srv es1 -v4 1469925296 [140372993103680] DEBUG archiving/hdbes/1 HdbEventSubscriber::init_device() create device archiving/hdbes/1 1469925296 [140372993103680] DEBUG archiving/hdbes/1 subscribeRetryPeriod = 60 1469925296 [140372993103680] INFO archiving/hdbes/1 HdbEventSubscriber id=0 1469925296 [140372993103680] DEBUG archiving/hdbes/1 CONFIGURING CONTEXTS: adding ALWAYS <-> 0 1469925296 [140372993103680] DEBUG archiving/hdbes/1 CONFIGURING CONTEXTS: adding RUN <-> 1 1469925296 [140372993103680] DEBUG archiving/hdbes/1 CONFIGURING CONTEXTS: adding SHUTDOWN <-> 2 1469925296 [140372993103680] DEBUG archiving/hdbes/1 CONFIGURING CONTEXTS: adding SERVICE <-> 3 HdbPPMySQL: Configuration parsing error: map::at 1469925296 [140372993103680] FATAL archiving/hdbes/1 PushThreadShared: error connecting DB: Configuration parsing error: map::at but when i execute old version hdb++mysql(libhdb++.so.3.0.0, libhdb++mysql.so.3.2.0) under same configuration, it ok. ———– need some help. Thanks in advance for your help! Edited 7 years ago

# 7 years ago

Hi, tangoer

today i update hdb++ files from sourceforge,after successfully make(libhdb++.so.4.0.0, libhdb++mysql.so.4.0.0), but when execute hdb++es-srv it fail.

$ hdb++es-srv es1 -v4
1469925296 [140372993103680] DEBUG archiving/hdbes/1 HdbEventSubscriber::init_device() create device archiving/hdbes/1
1469925296 [140372993103680] DEBUG archiving/hdbes/1 subscribeRetryPeriod = 60
1469925296 [140372993103680] INFO archiving/hdbes/1 HdbEventSubscriber id=0
1469925296 [140372993103680] DEBUG archiving/hdbes/1 CONFIGURING CONTEXTS: adding ALWAYS <-> 0
1469925296 [140372993103680] DEBUG archiving/hdbes/1 CONFIGURING CONTEXTS: adding RUN <-> 1
1469925296 [140372993103680] DEBUG archiving/hdbes/1 CONFIGURING CONTEXTS: adding SHUTDOWN <-> 2
1469925296 [140372993103680] DEBUG archiving/hdbes/1 CONFIGURING CONTEXTS: adding SERVICE <-> 3
HdbPPMySQL: Configuration parsing error: map::at
1469925296 [140372993103680] FATAL archiving/hdbes/1 PushThreadShared: error connecting DB: Configuration parsing error: map::at

but when i execute old version hdb++mysql(libhdb++.so.3.0.0, libhdb++mysql.so.3.2.0) under same configuration, it ok.
———–
need some help.
Thanks in advance for your help!

Edited 7 years ago

# 7 years ago
Reynald	Hi, Following the last HDB++ meeting which took place in May, there have been some changes recently in HDB++ MySQL, especially in the way to configure the system. I don't think this is documented yet. As far as I know, there is a new property (which can be a class and/or device property) named LibConfiguration in recent version of HDB++ event subscriber and configuration manager. This property is an array of strings containing the information needed by the HDB++ library you are using to insert data into the backend of your choice (MySQL with old schema, MySQL with new schema, Cassandra, maybe more in the future…). The MySQL libraries are expecting a string array containing key=value pairs like in the following example: host=my-hdbpp-host user=hdbppwriter password= dbname=hdb_new port=3306 You can declare LibConfiguration as class property of HdbEventSubscriber and HdbConfigurationManager classes with the correct configuration matching your MySQL installation and it should work with the latest version. The available options for each library are not yet documented but this will come. Hoping this helps, Reynald Rosenberg's Law: Software is easy to make, except when you want it to do something new. Corollary: The only software that's worth making is software that does something new.

# 7 years ago

Reynald

Hi,

Following the last HDB++ meeting which took place in May, there have been some changes recently in HDB++ MySQL, especially in the way to configure the system.
I don't think this is documented yet.
As far as I know, there is a new property (which can be a class and/or device property) named LibConfiguration in recent version of HDB++ event subscriber and configuration manager.
This property is an array of strings containing the information needed by the HDB++ library you are using to insert data into the backend of your choice (MySQL with old schema, MySQL with new schema, Cassandra, maybe more in the future…).
The MySQL libraries are expecting a string array containing key=value pairs like in the following example:
host=my-hdbpp-host
user=hdbppwriter
password=
dbname=hdb_new
port=3306

You can declare LibConfiguration as class property of HdbEventSubscriber and HdbConfigurationManager classes with the correct configuration matching your MySQL installation and it should work with the latest version.

The available options for each library are not yet documented but this will come.

Hoping this helps,
Reynald

Rosenberg's Law: Software is easy to make, except when you want it to do something new.
Corollary: The only software that's worth making is software that does something new.

# 7 years ago
Jimmy	Reynaldo Thanks so much for you help After set LibConfiguration property, it's ok!

# 7 years ago
Anshul	Hello Team What has to be set in LibConfiguration property ? Thanks and Regards Anshul Soni

# 7 years ago
Jimmy	Hi, Anshul LibConfiguration property include: host= user= password= dbname= port=3306

# 7 years ago
Anshul	Hello Jimmy Thankyou. It worked.