|
|
<!DOCTYPE html>
|
|
|
|
|
|
<html >
|
|
|
<head>
|
|
|
<meta charset="utf-8" />
|
|
|
<title>scdb — SeisComP Release documentation</title>
|
|
|
<link rel="stylesheet" href="../_static/pygments.css" type="text/css" />
|
|
|
<link rel="stylesheet" href="../_static/seiscomp.css" type="text/css" />
|
|
|
<link rel="stylesheet" type="text/css" href="../_static/graphviz.css" />
|
|
|
<script type="text/javascript" src="../_static/seiscomp.js"></script>
|
|
|
<script type="text/javascript" id="documentation_options" data-url_root="../" src="../_static/documentation_options.js"></script>
|
|
|
<script src="../_static/jquery.js"></script>
|
|
|
<script src="../_static/underscore.js"></script>
|
|
|
<script src="../_static/doctools.js"></script>
|
|
|
<script src="../_static/language_data.js"></script>
|
|
|
<link rel="shortcut icon" href="../_static/favicon.ico"/>
|
|
|
<link rel="index" title="Index" href="../genindex.html" />
|
|
|
<link rel="search" title="Search" href="../search.html" />
|
|
|
<link rel="next" title="scdbstrip" href="scdbstrip.html" />
|
|
|
<link rel="prev" title="scconfig" href="scconfig.html" />
|
|
|
</head>
|
|
|
<body>
|
|
|
<div class="header">
|
|
|
<div class="container">
|
|
|
<div class="brand">
|
|
|
<img class="logo" src="../_static/brands/seiscomp/text/white.svg"/>
|
|
|
<!-- span class="title">SeisComP Release</span -->
|
|
|
<span class="version">5.3.0</span>
|
|
|
</div>
|
|
|
</div>
|
|
|
</div>
|
|
|
<div class="nav">
|
|
|
<div class="container">
|
|
|
<div class="content"><a class="pull-right" id="sidebar-toggle">TOC</a>
|
|
|
|
|
|
<div class="related" role="navigation" aria-label="related navigation">
|
|
|
<ul>
|
|
|
<li class="right">
|
|
|
<a href="../genindex.html" title="General Index"
|
|
|
accesskey="I">
|
|
|
index
|
|
|
</a>
|
|
|
</li>
|
|
|
<li class="right">
|
|
|
<a href="scdbstrip.html" title="scdbstrip"
|
|
|
accesskey="N">
|
|
|
next
|
|
|
</a>
|
|
|
</li>
|
|
|
<li class="right">
|
|
|
<a href="scconfig.html" title="scconfig"
|
|
|
accesskey="P">
|
|
|
previous
|
|
|
</a>
|
|
|
</li>
|
|
|
<li class="nav-item nav-item-0">
|
|
|
<a href="../index.html">Home</a>
|
|
|
</li>
|
|
|
<li class="nav-item nav-item-1">
|
|
|
<a href="../modules.html" >Modules</a>
|
|
|
</li>
|
|
|
<li class="nav-item nav-item-2">
|
|
|
<a href="../toc/utilities.html" accesskey="U">Utilities</a>
|
|
|
</li>
|
|
|
</ul>
|
|
|
</div>
|
|
|
</div>
|
|
|
</div>
|
|
|
</div>
|
|
|
<div class="container">
|
|
|
<div class="fitted content" id="anchors-container">
|
|
|
<div class="body" role="main">
|
|
|
|
|
|
<div class="section" id="scdb">
|
|
|
<span id="id1"></span><h1>scdb<a class="headerlink" href="#scdb" title="Permalink to this headline">¶</a></h1>
|
|
|
<p><strong>Populate a SQL database from XML files or messages.</strong></p>
|
|
|
<div class="section" id="description">
|
|
|
<h2>Description<a class="headerlink" href="#description" title="Permalink to this headline">¶</a></h2>
|
|
|
<p>A major component of the SeisComP system is the database. Almost all
|
|
|
applications have only read access to the database, but all the processing
|
|
|
results and objects have to be written into the database. This was the task of
|
|
|
scdb. In very first versions of SeisComP scdb was the only component that had
|
|
|
write access to the database. Its task is to connect to <a class="reference internal" href="scmaster.html#scmaster"><span class="std std-ref">scmaster</span></a> and populate
|
|
|
the database with all received notifier messages. Although it worked it
|
|
|
introduced race conditions caused by the latency of the database backend since
|
|
|
all other clients received the message at the same time. Accessing the database
|
|
|
immediately at this point in time did not guarantee that the object was
|
|
|
written already.</p>
|
|
|
<p>In consequence, the scmaster itself gained write access to the database and
|
|
|
forwards messages to all clients after they are written to database.</p>
|
|
|
<p><a class="reference internal" href="#scdb"><span class="std std-ref">scdb</span></a> by definition does not check existing objects in the database. It only
|
|
|
generates INSERT/UPDATE/DELETE statements based on the data used and sends
|
|
|
these statements to the database. E.g. if <a class="reference internal" href="#scdb"><span class="std std-ref">scdb</span></a> receives a message to
|
|
|
insert a new object into the database and this object exists already, the
|
|
|
database will raise an error because <a class="reference internal" href="#scdb"><span class="std std-ref">scdb</span></a> hasn’t checked it.</p>
|
|
|
<div class="section" id="online-mode">
|
|
|
<h3>Online mode<a class="headerlink" href="#online-mode" title="Permalink to this headline">¶</a></h3>
|
|
|
<p>Now scdb can be used to maintain a backup or archive the database that is not
|
|
|
part of the real time processing. When running scdb as database write daemon it
|
|
|
can inform a client about the database connection to use. A client sends a
|
|
|
DatabaseRequest message and scdb sends back a DatabaseResponse message containing
|
|
|
the database connection parameters.</p>
|
|
|
<p>For that it connects to a messaging server and writes all received messages to a
|
|
|
configured database, e.g. a backup database.</p>
|
|
|
<div class="admonition note">
|
|
|
<p class="admonition-title">Note</p>
|
|
|
<p>The database connection received from the messaging server during the
|
|
|
handshake is reported to clients requesting a database address. To overwrite
|
|
|
the read-only database, just override the application’s database address
|
|
|
(with the ‘-d’ option)</p>
|
|
|
</div>
|
|
|
</div>
|
|
|
<div class="section" id="offline-mode">
|
|
|
<h3>Offline mode<a class="headerlink" href="#offline-mode" title="Permalink to this headline">¶</a></h3>
|
|
|
<p>Another important task of <a class="reference internal" href="#scdb"><span class="std std-ref">scdb</span></a> is to populate the database with any SeisComP
|
|
|
data model content. In combination with <a class="reference internal" href="scxmldump.html#scxmldump"><span class="std std-ref">scxmldump</span></a> it can be used to copy events
|
|
|
from one database to another.</p>
|
|
|
<p>For that it does not connect to a messaging server but reads data from XML
|
|
|
files and writes it to the database. Offline mode will be used if the
|
|
|
‘–input/-i’ option is provided. Multiple input files can be specified by
|
|
|
providing this option multiple times with separate filenames.</p>
|
|
|
<div class="admonition warning">
|
|
|
<p class="admonition-title">Warning</p>
|
|
|
<p>When reading XML files the output database address is not passed
|
|
|
with -o but -d. The application’s database address is used.</p>
|
|
|
</div>
|
|
|
</div>
|
|
|
<div class="section" id="examples">
|
|
|
<h3>Examples<a class="headerlink" href="#examples" title="Permalink to this headline">¶</a></h3>
|
|
|
<ol class="arabic">
|
|
|
<li><p>Connect to a messaging server and write all messages to the output database
|
|
|
<cite>seiscomp</cite> running on the host <cite>db-server</cite>:</p>
|
|
|
<div class="highlight-sh notranslate"><div class="highlight"><pre><span></span>scdb -H <span class="o">[</span>server<span class="o">]</span> -o mysql://sysop:sysop@db-server/seiscomp
|
|
|
</pre></div>
|
|
|
</div>
|
|
|
</li>
|
|
|
<li><p>As above, but with the read-only database connection using the user <cite>sysop</cite>
|
|
|
and the output database connection using the user <cite>writer</cite>:</p>
|
|
|
<div class="highlight-sh notranslate"><div class="highlight"><pre><span></span>scdb -H <span class="o">[</span>server<span class="o">]</span> -d mysql://sysop:sysop@db-server/seiscomp <span class="se">\</span>
|
|
|
-o mysql://writer:12345@db-server/seiscomp
|
|
|
</pre></div>
|
|
|
</div>
|
|
|
</li>
|
|
|
<li><p>Import data from the file <code class="file docutils literal notranslate"><span class="pre">data.xml</span></code> and write it to the database
|
|
|
<cite>seiscomp</cite> on the host <cite>db-server</cite>:</p>
|
|
|
<div class="highlight-sh notranslate"><div class="highlight"><pre><span></span>scdb -i data.xml -d mysql://sysop:sysop@db-server/seiscomp
|
|
|
</pre></div>
|
|
|
</div>
|
|
|
</li>
|
|
|
<li><p>Import data from three files at once:</p>
|
|
|
<div class="highlight-sh notranslate"><div class="highlight"><pre><span></span>scdb -i data1.xml -i data2.xml -i data3.xml <span class="se">\</span>
|
|
|
-d mysql://sysop:sysop@db-server/seiscomp
|
|
|
</pre></div>
|
|
|
</div>
|
|
|
</li>
|
|
|
</ol>
|
|
|
</div>
|
|
|
</div>
|
|
|
<div class="section" id="module-configuration">
|
|
|
<span id="scdb-configuration"></span><h2>Module Configuration<a class="headerlink" href="#module-configuration" title="Permalink to this headline">¶</a></h2>
|
|
|
<div class="line-block">
|
|
|
<div class="line"><code class="file docutils literal notranslate"><span class="pre">etc/defaults/global.cfg</span></code></div>
|
|
|
<div class="line"><code class="file docutils literal notranslate"><span class="pre">etc/defaults/scdb.cfg</span></code></div>
|
|
|
<div class="line"><code class="file docutils literal notranslate"><span class="pre">etc/global.cfg</span></code></div>
|
|
|
<div class="line"><code class="file docutils literal notranslate"><span class="pre">etc/scdb.cfg</span></code></div>
|
|
|
<div class="line"><code class="file docutils literal notranslate"><span class="pre">~/.seiscomp/global.cfg</span></code></div>
|
|
|
<div class="line"><code class="file docutils literal notranslate"><span class="pre">~/.seiscomp/scdb.cfg</span></code></div>
|
|
|
</div>
|
|
|
<p>scdb inherits <a class="reference internal" href="global.html#global-configuration"><span class="std std-ref">global options</span></a>.</p>
|
|
|
<dl class="confval">
|
|
|
<dt id="confval-connection.requestGroup">
|
|
|
<code class="sig-name descname">connection.requestGroup</code><a class="headerlink" href="#confval-connection.requestGroup" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Type: <em>string</em></p>
|
|
|
<p>Define the group on scmaster to subscribe for database
|
|
|
requests.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="confval">
|
|
|
<dt id="confval-connection.provideGroup">
|
|
|
<code class="sig-name descname">connection.provideGroup</code><a class="headerlink" href="#confval-connection.provideGroup" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Type: <em>string</em></p>
|
|
|
<p>Define the group on scmaster to send database response
|
|
|
messages to.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="confval">
|
|
|
<dt id="confval-output.type">
|
|
|
<code class="sig-name descname">output.type</code><a class="headerlink" href="#confval-output.type" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Type: <em>string</em></p>
|
|
|
<p>Define the output database connection type.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="confval">
|
|
|
<dt id="confval-output.parameters">
|
|
|
<code class="sig-name descname">output.parameters</code><a class="headerlink" href="#confval-output.parameters" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Type: <em>string</em></p>
|
|
|
<p>Define the output database connection parameters.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
</div>
|
|
|
<div class="section" id="command-line-options">
|
|
|
<h2>Command-Line Options<a class="headerlink" href="#command-line-options" title="Permalink to this headline">¶</a></h2>
|
|
|
<p><strong class="program">scdb [options]</strong></p>
|
|
|
<div class="section" id="generic">
|
|
|
<h3>Generic<a class="headerlink" href="#generic" title="Permalink to this headline">¶</a></h3>
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-h">
|
|
|
<code class="sig-name descname">-h</code><code class="sig-prename descclassname"></code><code class="sig-prename descclassname">, </code><code class="sig-name descname">--help</code><code class="sig-prename descclassname"></code><a class="headerlink" href="#cmdoption-scdb-h" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Show help message.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-v">
|
|
|
<code class="sig-name descname">-V</code><code class="sig-prename descclassname"></code><code class="sig-prename descclassname">, </code><code class="sig-name descname">--version</code><code class="sig-prename descclassname"></code><a class="headerlink" href="#cmdoption-scdb-v" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Show version information.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-config-file">
|
|
|
<code class="sig-name descname">--config-file</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-config-file" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Use alternative configuration file. When this option is
|
|
|
used the loading of all stages is disabled. Only the
|
|
|
given configuration file is parsed and used. To use
|
|
|
another name for the configuration create a symbolic
|
|
|
link of the application or copy it. Example:
|
|
|
scautopick -> scautopick2.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-plugins">
|
|
|
<code class="sig-name descname">--plugins</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-plugins" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Load given plugins.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-d">
|
|
|
<code class="sig-name descname">-D</code><code class="sig-prename descclassname"></code><code class="sig-prename descclassname">, </code><code class="sig-name descname">--daemon</code><code class="sig-prename descclassname"></code><a class="headerlink" href="#cmdoption-scdb-d" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Run as daemon. This means the application will fork itself
|
|
|
and doesn’t need to be started with &.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-auto-shutdown">
|
|
|
<code class="sig-name descname">--auto-shutdown</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-auto-shutdown" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Enable/disable self-shutdown because a master module shutdown.
|
|
|
This only works when messaging is enabled and the master
|
|
|
module sends a shutdown message (enabled with –start-stop-msg
|
|
|
for the master module).</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-shutdown-master-module">
|
|
|
<code class="sig-name descname">--shutdown-master-module</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-shutdown-master-module" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Set the name of the master-module used for auto-shutdown.
|
|
|
This is the application name of the module actually
|
|
|
started. If symlinks are used, then it is the name of
|
|
|
the symlinked application.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-shutdown-master-username">
|
|
|
<code class="sig-name descname">--shutdown-master-username</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-shutdown-master-username" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Set the name of the master-username of the messaging
|
|
|
used for auto-shutdown. If “shutdown-master-module” is
|
|
|
given as well, this parameter is ignored.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
</div>
|
|
|
<div class="section" id="verbosity">
|
|
|
<h3>Verbosity<a class="headerlink" href="#verbosity" title="Permalink to this headline">¶</a></h3>
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-verbosity">
|
|
|
<code class="sig-name descname">--verbosity</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-verbosity" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Verbosity level [0..4]. 0:quiet, 1:error, 2:warning, 3:info,
|
|
|
4:debug.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="id2">
|
|
|
<code class="sig-name descname">-v</code><code class="sig-prename descclassname"></code><code class="sig-prename descclassname">, </code><code class="sig-name descname">--v</code><code class="sig-prename descclassname"></code><a class="headerlink" href="#id2" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Increase verbosity level (may be repeated, eg. -vv).</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-q">
|
|
|
<code class="sig-name descname">-q</code><code class="sig-prename descclassname"></code><code class="sig-prename descclassname">, </code><code class="sig-name descname">--quiet</code><code class="sig-prename descclassname"></code><a class="headerlink" href="#cmdoption-scdb-q" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Quiet mode: no logging output.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-component">
|
|
|
<code class="sig-name descname">--component</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-component" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Limit the logging to a certain component. This option can
|
|
|
be given more than once.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-s">
|
|
|
<code class="sig-name descname">-s</code><code class="sig-prename descclassname"></code><code class="sig-prename descclassname">, </code><code class="sig-name descname">--syslog</code><code class="sig-prename descclassname"></code><a class="headerlink" href="#cmdoption-scdb-s" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Use syslog logging backend. The output usually goes to
|
|
|
/var/lib/messages.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-l">
|
|
|
<code class="sig-name descname">-l</code><code class="sig-prename descclassname"></code><code class="sig-prename descclassname">, </code><code class="sig-name descname">--lockfile</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-l" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Path to lock file.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-console">
|
|
|
<code class="sig-name descname">--console</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-console" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Send log output to stdout.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-debug">
|
|
|
<code class="sig-name descname">--debug</code><code class="sig-prename descclassname"></code><a class="headerlink" href="#cmdoption-scdb-debug" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Execute in debug mode.
|
|
|
Equivalent to –verbosity=4 –console=1 .</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-log-file">
|
|
|
<code class="sig-name descname">--log-file</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-log-file" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Use alternative log file.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
</div>
|
|
|
<div class="section" id="messaging">
|
|
|
<h3>Messaging<a class="headerlink" href="#messaging" title="Permalink to this headline">¶</a></h3>
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-u">
|
|
|
<code class="sig-name descname">-u</code><code class="sig-prename descclassname"></code><code class="sig-prename descclassname">, </code><code class="sig-name descname">--user</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-u" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Overrides configuration parameter <a class="reference internal" href="global.html#confval-connection.username"><code class="xref std std-confval docutils literal notranslate"><span class="pre">connection.username</span></code></a>.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-host">
|
|
|
<code class="sig-name descname">-H</code><code class="sig-prename descclassname"></code><code class="sig-prename descclassname">, </code><code class="sig-name descname">--host</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-host" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Overrides configuration parameter <a class="reference internal" href="global.html#confval-connection.server"><code class="xref std std-confval docutils literal notranslate"><span class="pre">connection.server</span></code></a>.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-t">
|
|
|
<code class="sig-name descname">-t</code><code class="sig-prename descclassname"></code><code class="sig-prename descclassname">, </code><code class="sig-name descname">--timeout</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-t" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Overrides configuration parameter <a class="reference internal" href="global.html#confval-connection.timeout"><code class="xref std std-confval docutils literal notranslate"><span class="pre">connection.timeout</span></code></a>.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-g">
|
|
|
<code class="sig-name descname">-g</code><code class="sig-prename descclassname"></code><code class="sig-prename descclassname">, </code><code class="sig-name descname">--primary-group</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-g" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Overrides configuration parameter <a class="reference internal" href="global.html#confval-connection.primaryGroup"><code class="xref std std-confval docutils literal notranslate"><span class="pre">connection.primaryGroup</span></code></a>.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-subscribe-group">
|
|
|
<code class="sig-name descname">-S</code><code class="sig-prename descclassname"></code><code class="sig-prename descclassname">, </code><code class="sig-name descname">--subscribe-group</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-subscribe-group" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>A group to subscribe to.
|
|
|
This option can be given more than once.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-content-type">
|
|
|
<code class="sig-name descname">--content-type</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-content-type" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Overrides configuration parameter <a class="reference internal" href="global.html#confval-connection.contentType"><code class="xref std std-confval docutils literal notranslate"><span class="pre">connection.contentType</span></code></a>.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-start-stop-msg">
|
|
|
<code class="sig-name descname">--start-stop-msg</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-start-stop-msg" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Set sending of a start and a stop message.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-m">
|
|
|
<code class="sig-name descname">--m</code><code class="sig-prename descclassname"></code><code class="sig-prename descclassname">, </code><code class="sig-name descname">--mode</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-m" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>scdb can either process a XML file and write it to the
|
|
|
database or collect messages from scmaster.
|
|
|
If connected to scmaster, the mode defines what objects
|
|
|
are handled: none (no objects at all), notifier (notifier
|
|
|
only) or all (all objects whereas non-notifier objects
|
|
|
are INSERTED into the database).</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
</div>
|
|
|
<div class="section" id="database">
|
|
|
<h3>Database<a class="headerlink" href="#database" title="Permalink to this headline">¶</a></h3>
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-db-driver-list">
|
|
|
<code class="sig-name descname">--db-driver-list</code><code class="sig-prename descclassname"></code><a class="headerlink" href="#cmdoption-scdb-db-driver-list" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>List all supported database drivers.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-database">
|
|
|
<code class="sig-name descname">-d</code><code class="sig-prename descclassname"></code><code class="sig-prename descclassname">, </code><code class="sig-name descname">--database</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-database" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>The database connection string, format:
|
|
|
<a class="reference external" href="service://user:pwd@host/database">service://user:pwd@host/database</a>.
|
|
|
“service” is the name of the database driver which
|
|
|
can be queried with “–db-driver-list”.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-config-module">
|
|
|
<code class="sig-name descname">--config-module</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-config-module" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>The config module to use.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-inventory-db">
|
|
|
<code class="sig-name descname">--inventory-db</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-inventory-db" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Load the inventory from the given database or file, format:
|
|
|
[<a class="reference external" href="service://]location">service://]location</a> .</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-config-db">
|
|
|
<code class="sig-name descname">--config-db</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-config-db" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Load the configuration from the given database or file,
|
|
|
format: [<a class="reference external" href="service://]location">service://]location</a> .</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-o">
|
|
|
<code class="sig-name descname">--o</code><code class="sig-prename descclassname"></code><code class="sig-prename descclassname">, </code><code class="sig-name descname">--output</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-o" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>If connected to scmaster, this flag defines the database
|
|
|
connection to use for writing. The configured application
|
|
|
database connection (as received from scmaster) is reported
|
|
|
to clients as part of a database response messages.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
</div>
|
|
|
<div class="section" id="import">
|
|
|
<h3>Import<a class="headerlink" href="#import" title="Permalink to this headline">¶</a></h3>
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-i">
|
|
|
<code class="sig-name descname">-i</code><code class="sig-prename descclassname"></code><code class="sig-prename descclassname">, </code><code class="sig-name descname">--input</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-i" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Define the import XML file to be written to database.
|
|
|
Can be provided multiple times to import multiple files.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
<dl class="option">
|
|
|
<dt id="cmdoption-scdb-b">
|
|
|
<code class="sig-name descname">-b</code><code class="sig-prename descclassname"></code><code class="sig-prename descclassname">, </code><code class="sig-name descname">--batchsize</code><code class="sig-prename descclassname"> arg</code><a class="headerlink" href="#cmdoption-scdb-b" title="Permalink to this definition">¶</a></dt>
|
|
|
<dd><p>Batch size of a database transactions [0..1000].
|
|
|
By default all INSERT/UPDATE/DELETE statements are
|
|
|
executed in one single transaction.</p>
|
|
|
</dd></dl>
|
|
|
|
|
|
</div>
|
|
|
</div>
|
|
|
</div>
|
|
|
|
|
|
|
|
|
<div id="anchors-bottom"></div>
|
|
|
</div>
|
|
|
|
|
|
<div class="sidebar" role="navigation" aria-label="main navigation">
|
|
|
<div id="anchors-top"></div>
|
|
|
<div id="anchors" class="content">
|
|
|
<div id="searchbox" style="display: none" role="search">
|
|
|
<h3 id="searchlabel">Quick search</h3>
|
|
|
<div class="searchformwrapper">
|
|
|
<form class="search" action="../search.html" method="get">
|
|
|
<input type="text" name="q" aria-labelledby="searchlabel" />
|
|
|
<input type="submit" value="Go" />
|
|
|
</form>
|
|
|
</div>
|
|
|
</div>
|
|
|
<script>$('#searchbox').show(0);</script>
|
|
|
<h3><a href="../index.html">Table of Contents</a></h3>
|
|
|
<ul>
|
|
|
<li><a class="reference internal" href="#">scdb</a><ul>
|
|
|
<li><a class="reference internal" href="#description">Description</a><ul>
|
|
|
<li><a class="reference internal" href="#online-mode">Online mode</a></li>
|
|
|
<li><a class="reference internal" href="#offline-mode">Offline mode</a></li>
|
|
|
<li><a class="reference internal" href="#examples">Examples</a></li>
|
|
|
</ul>
|
|
|
</li>
|
|
|
<li><a class="reference internal" href="#module-configuration">Module Configuration</a></li>
|
|
|
<li><a class="reference internal" href="#command-line-options">Command-Line Options</a><ul>
|
|
|
<li><a class="reference internal" href="#generic">Generic</a></li>
|
|
|
<li><a class="reference internal" href="#verbosity">Verbosity</a></li>
|
|
|
<li><a class="reference internal" href="#messaging">Messaging</a></li>
|
|
|
<li><a class="reference internal" href="#database">Database</a></li>
|
|
|
<li><a class="reference internal" href="#import">Import</a></li>
|
|
|
</ul>
|
|
|
</li>
|
|
|
</ul>
|
|
|
</li>
|
|
|
</ul>
|
|
|
|
|
|
<h4>Previous topic</h4>
|
|
|
<p class="topless"><a href="scconfig.html"
|
|
|
title="previous chapter">scconfig</a></p>
|
|
|
<h4>Next topic</h4>
|
|
|
<p class="topless"><a href="scdbstrip.html"
|
|
|
title="next chapter">scdbstrip</a></p>
|
|
|
<div role="note" aria-label="source link">
|
|
|
<h3>This Page</h3>
|
|
|
<ul class="this-page-menu">
|
|
|
<li><a href="../_sources/apps/scdb.rst.txt"
|
|
|
rel="nofollow">Show Source</a></li>
|
|
|
</ul>
|
|
|
</div>
|
|
|
</div>
|
|
|
</div>
|
|
|
</div>
|
|
|
</div>
|
|
|
<div class="footer">
|
|
|
<div class="container">
|
|
|
<div class="horizontal layout content">
|
|
|
<a class="fade-in" href="https://www.gempa.de" target="_blank">
|
|
|
<img class="brand" src="../_static/brands/gempa.svg"/>
|
|
|
</a>
|
|
|
<div class="stretched align-center fitted content">
|
|
|
<div>
|
|
|
Version <b>5.3.0</b> Release
|
|
|
</div>
|
|
|
<div class="copyright">
|
|
|
Copyright © gempa GmbH, GFZ Potsdam.
|
|
|
</div>
|
|
|
</div>
|
|
|
<a class="fade-in" href="https://www.gfz-potsdam.de" target="_blank">
|
|
|
<img class="brand" src="../_static/brands/gfz.svg"/>
|
|
|
</a>
|
|
|
</div>
|
|
|
</div>
|
|
|
</div>
|
|
|
</body>
|
|
|
</html> |