New release Jakarta 2017.334

andres · February 7, 2018, 4:19pm

There is an SC3 package for Ubuntu on Raspberry too.

https://wiki.ubuntu.com/ARM/RaspberryPi

koymans · February 16, 2018, 2:18pm

I’m working on the update script for patch 3 to migrate our strong motion table… do the order of columns matter? Or can I just add them to the end:

UPDATE Meta SET value='0.10' WHERE name='Schema-Version';

ALTER TABLE FilterParameter
ADD value_pdf_variable_content BLOB,
ADD value_pdf_probability_content BLOB,
ADD value_pdf_used TINYINT(1) NOT NULL DEFAULT '0';

ALTER TABLE PeakMotion
ADD motion_pdf_variable_content BLOB,
ADD motion_pdf_probability_content BLOB,
ADD motion_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD atTime_pdf_variable_content BLOB,
ADD atTime_pdf_probability_content BLOB,
ADD atTime_pdf_used TINYINT(1) NOT NULL DEFAULT '0';

ALTER TABLE Record
ADD value_pdf_variable_content BLOB,
ADD value_pdf_probability_content BLOB,
ADD value_pdf_used TINYINT(1) NOT NULL DEFAULT '0';

ALTER TABLE EventRecordReference
ADD campbellDistance_pdf_variable_content BLOB,
ADD campbellDistance_pdf_probability_content BLOB,
ADD campbellDistance_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD ruptureToStationAzimuth_pdf_variable_content BLOB,
ADD ruptureToStationAzimuth_pdf_probability_content BLOB,
ADD ruptureToStationAzimuth_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD ruptureAreaDistance_pdf_variable_content BLOB,
ADD ruptureAreaDistance_pdf_probability_content BLOB,
ADD ruptureAreaDistance_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD JoynerBooreDistance_pdf_variable_content BLOB,
ADD JoynerBooreDistance_pdf_probability_content BLOB,
ADD JoynerBooreDistance_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD closestFaultDistance_pdf_variable_content BLOB,
ADD closestFaultDistance_pdf_probability_content BLOB,
ADD closestFaultDistance_pdf_used TINYINT(1) NOT NULL DEFAULT '0',

ALTER TABLE Rupture
ADD width_pdf_variable_content BLOB,
ADD width_pdf_probability_content BLOB,
ADD width_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD displacement_pdf_variable_content BLOB,
ADD displacement_pdf_probability_content BLOB,
ADD displacement_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD riseTime_pdf_variable_content BLOB,
ADD riseTime_pdf_probability_content BLOB,
ADD riseTime_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD vt_to_vs_pdf_variable_content BLOB,
ADD vt_to_vs_pdf_probability_content BLOB,
ADD vt_to_vs_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD shallowAsperityDepth_pdf_variable_content BLOB,
ADD shallowAsperityDepth_pdf_probability_content BLOB,
ADD shallowAsperityDepth_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD slipVelocity_pdf_variable_content BLOB,
ADD slipVelocity_pdf_probability_content BLOB,
ADD slipVelocity_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD strike_value DOUBLE,
ADD strike_uncertainty DOUBLE UNSIGNED,
ADD strike_lowerUncertainty DOUBLE UNSIGNED,
ADD strike_upperUncertainty DOUBLE UNSIGNED,
ADD strike_confidenceLevel DOUBLE UNSIGNED,
ADD strike_pdf_variable_content BLOB,
ADD strike_pdf_probability_content BLOB,
ADD strike_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD strike_used TINYINT(1) NOT NULL DEFAULT '0',
ADD length_pdf_variable_content BLOB,
ADD length_pdf_probability_content BLOB,
ADD length_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD area_pdf_variable_content BLOB,
ADD area_pdf_probability_content BLOB,
ADD area_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD ruptureVelocity_pdf_variable_content BLOB,
ADD ruptureVelocity_pdf_probability_content BLOB,
ADD ruptureVelocity_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD stressdrop_pdf_variable_content BLOB,
ADD stressdrop_pdf_probability_content BLOB,
ADD stressdrop_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD momentReleaseTop5km_pdf_variable_content BLOB,
ADD momentReleaseTop5km_pdf_probability_content BLOB,
ADD momentReleaseTop5km_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD centroidReference VARCHAR(255);

andres · February 28, 2018, 11:44am

Raspbian 9 (Stretch) packages are included in 2017.334.04 build.

https://www.seiscomp3.org/downloader

jabe · February 28, 2018, 11:47am

The order of columns does not matter.

jabe · March 16, 2018, 7:22am

It should work. Just be aware that you have to change the bytea_output to escape:

ALTER DATABASE seiscomp3 SET bytea_output TO 'escape'

Give it a try and let us know if you observe issues.

wewenk · April 29, 2018, 2:36pm

trying to compile with Ubuntu 18.04

after setup, scconfig cannot import inventory.xml
no selection for format

Selection_001

jabe · May 2, 2018, 6:57am

What is the output on the command line for import_inv help formats?

wewenk · May 2, 2018, 7:21am

here it is

jabe · May 2, 2018, 7:27am

Thanks, that is looking good. So the “format” selection box in scconfig is really empty? I cannot verify that from your screenshot.

wewenk · May 2, 2018, 7:36am

yes, from scconfig the formats is empty…

I can import with import_inv though but it won’t binding station.

jabe · May 7, 2018, 11:53am

I assume that you have tried the master branch from Github? I have pushed a fix which should solve the issue.

wewenk · May 8, 2018, 8:46am

yes… it is now fixed

koymans · May 14, 2018, 2:45pm

I tried updating our 2016.333 version with a separate strong motion DB to the newest version but during a test run it is not saving peak motion values to the database. In scmaster.log there are these exceptions:

2018/05/14 16:38:42 [error/Communication] message (#scwfparam#localhost -> STRONG_MOTION): decoding failed: expected exact or derived from Object, found StrongOriginDescription
2018/05/14 16:38:42 [error/Communication] message (#scwfparam#localhost -> STRONG_MOTION): decoding failed: expected exact or derived from Object, found EventRecordReference
2018/05/14 16:38:42 [error/Communication] message (#scwfparam#localhost -> STRONG_MOTION): decoding failed: expected exact or derived from Object, found EventRecordReference

Any idea what this means? STRONG_MOTION is my message group…

koymans · May 14, 2018, 3:00pm

Actually this seems unrelated to why peakmotions were not saved… I was missing a column in my strong motion schema update script. But these exceptions are still there regardless!

For completeness here is the scwfparam schema update sql if anyone needs it:

UPDATE Meta SET value='0.10' WHERE name='Schema-Version';

ALTER TABLE FilterParameter
ADD value_pdf_variable_content BLOB,
ADD value_pdf_probability_content BLOB,
ADD value_pdf_used TINYINT(1) NOT NULL DEFAULT '0';

ALTER TABLE PeakMotion
ADD motion_pdf_variable_content BLOB,
ADD motion_pdf_probability_content BLOB,
ADD motion_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD atTime_pdf_variable_content BLOB,
ADD atTime_pdf_probability_content BLOB,
ADD atTime_pdf_used TINYINT(1) NOT NULL DEFAULT '0';

ALTER TABLE Record
ADD startTime_pdf_variable_content BLOB,
ADD startTime_pdf_probability_content BLOB,
ADD startTime_pdf_used TINYINT(1) NOT NULL DEFAULT '0';

ALTER TABLE EventRecordReference
ADD campbellDistance_pdf_variable_content BLOB,
ADD campbellDistance_pdf_probability_content BLOB,
ADD campbellDistance_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD ruptureToStationAzimuth_pdf_variable_content BLOB,
ADD ruptureToStationAzimuth_pdf_probability_content BLOB,
ADD ruptureToStationAzimuth_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD ruptureAreaDistance_pdf_variable_content BLOB,
ADD ruptureAreaDistance_pdf_probability_content BLOB,
ADD ruptureAreaDistance_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD JoynerBooreDistance_pdf_variable_content BLOB,
ADD JoynerBooreDistance_pdf_probability_content BLOB,
ADD JoynerBooreDistance_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD closestFaultDistance_pdf_variable_content BLOB,
ADD closestFaultDistance_pdf_probability_content BLOB,
ADD closestFaultDistance_pdf_used TINYINT(1) NOT NULL DEFAULT '0';

ALTER TABLE Rupture
ADD width_pdf_variable_content BLOB,
ADD width_pdf_probability_content BLOB,
ADD width_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD displacement_pdf_variable_content BLOB,
ADD displacement_pdf_probability_content BLOB,
ADD displacement_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD riseTime_pdf_variable_content BLOB,
ADD riseTime_pdf_probability_content BLOB,
ADD riseTime_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD vt_to_vs_pdf_variable_content BLOB,
ADD vt_to_vs_pdf_probability_content BLOB,
ADD vt_to_vs_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD shallowAsperityDepth_pdf_variable_content BLOB,
ADD shallowAsperityDepth_pdf_probability_content BLOB,
ADD shallowAsperityDepth_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD slipVelocity_pdf_variable_content BLOB,
ADD slipVelocity_pdf_probability_content BLOB,
ADD slipVelocity_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD strike_value DOUBLE,
ADD strike_uncertainty DOUBLE UNSIGNED,
ADD strike_lowerUncertainty DOUBLE UNSIGNED,
ADD strike_upperUncertainty DOUBLE UNSIGNED,
ADD strike_confidenceLevel DOUBLE UNSIGNED,
ADD strike_pdf_variable_content BLOB,
ADD strike_pdf_probability_content BLOB,
ADD strike_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD strike_used TINYINT(1) NOT NULL DEFAULT '0',
ADD length_pdf_variable_content BLOB,
ADD length_pdf_probability_content BLOB,
ADD length_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD area_pdf_variable_content BLOB,
ADD area_pdf_probability_content BLOB,
ADD area_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD ruptureVelocity_pdf_variable_content BLOB,
ADD ruptureVelocity_pdf_probability_content BLOB,
ADD ruptureVelocity_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD stressdrop_pdf_variable_content BLOB,
ADD stressdrop_pdf_probability_content BLOB,
ADD stressdrop_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD momentReleaseTop5km_pdf_variable_content BLOB,
ADD momentReleaseTop5km_pdf_probability_content BLOB,
ADD momentReleaseTop5km_pdf_used TINYINT(1) NOT NULL DEFAULT '0',
ADD centroidReference VARCHAR(255);

jabe · May 15, 2018, 6:05am

scmaster does not know about the message types. You have to load the dmsm plugin into scmaster.

koymans · May 15, 2018, 7:25am

Like so (in scmaster.cfg)?

plugins = dbplugin, dmsm

Because I have dmsm loaded in scdb already so I thought that would work (scdb.cfg)

plugins = dmsm

jabe · May 15, 2018, 8:57am

Yes. If you have scdb running then you can ignore the scmaster error messages because scdb is already handling the messages and populates your database. Is the scdb target database the same as the scmaster database? Furthermore check the scdb.log.

koymans · May 15, 2018, 9:09am

Scdb log is fine and the data is being stored. I will add it to scmaster as well, to get rid of annoying warnings. It won’t save it twice right?

jabe · May 15, 2018, 9:12am

Yes, it will be saved twice. scmaster has the database plugin loaded which is actually the same thing as scdb but guarantees that messages are stored in the database before they are distributed to other clients. scdb cannot hold that. Use scdb only if you want to populate a separate database.

wewenk · May 24, 2018, 2:59pm

how to merge old database to new database?